--- setup/db/calendar.sql	2001-03-21 02:19:48.000000000 +0100

+++ setup/db/calendar.sql	2010-09-21 20:31:13.000000000 +0200

@@ -118,7 +118,7 @@

 CREATE TABLE users (

   uid int(11) NOT NULL auto_increment,

   username varchar(25) DEFAULT '' NOT NULL,

-  password varchar(25) DEFAULT '' NOT NULL,

+  password varchar(50) DEFAULT '' NOT NULL,

   accesslevel tinyint(2),

   fullname varchar(255),

   email varchar(255),

@@ -185,7 +185,7 @@

 #

 CREATE TABLE submitted_events (

-  eventid int(11) NOT NULL DEFAULT '0' auto_increment,

+  eventid int(11) NOT NULL auto_increment,

   site_id int(11) DEFAULT '0' NOT NULL,

   calendar varchar(255) DEFAULT '' NOT NULL,

   sub_name varchar(255) DEFAULT '',

--- setup/db/caluser.sql	2001-03-14 01:12:52.000000000 +0100

+++ setup/db/caluser.sql	2010-09-21 20:29:01.000000000 +0200

@@ -11,13 +11,12 @@

 # Inserts user account into MySQL user table

 # MAKE SURE TO CHANGE THE PASSWORD

-INSERT INTO user VALUES ('localhost', 'caluser', password('4caladmin'), 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N');

-

+CREATE USER 'caluser'@'localhost' IDENTIFIED BY '4caladmin';

 # Inserts user permissions for calendar table

 # MAKE SURE THE TABLE NAME, HOST, AND USERNAME

 # ARE CORRECT.

-INSERT INTO db VALUES ('localhost', 'calendar', 'caluser', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'N', 'Y', 'Y', 'Y');

+GRANT SELECT,INSERT,UPDATE,DELETE ON calendar.* TO 'caluser'@'localhost' ;

 FLUSH PRIVILEGES;