Attachment 109909 Details for Bug 150974 – cybercalendar.patch

[patch] cybercalendar.patch

cybercalendar.patch (text/x-diff; charset=us-ascii), 2.06 KB, created by Rodrigo OSORIO on 2010-11-04 09:41:46 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Rodrigo OSORIO

Created: 2010-11-04 09:41:46 UTC

Size: 2.06 KB

patch

obsolete

>diff -rupN cybercalendar/files/patch-setup-db-calendar.sql cybercalendar.new/files/patch-setup-db-calendar.sql
>--- cybercalendar/files/patch-setup-db-calendar.sql	1970-01-01 01:00:00.000000000 +0100
>+++ cybercalendar.new/files/patch-setup-db-calendar.sql	2010-09-26 21:15:24.000000000 +0200
>@@ -0,0 +1,20 @@
>+--- 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 '',
>diff -rupN cybercalendar/files/patch-setup-db-caluser.sql cybercalendar.new/files/patch-setup-db-caluser.sql
>--- cybercalendar/files/patch-setup-db-caluser.sql	1970-01-01 01:00:00.000000000 +0100
>+++ cybercalendar.new/files/patch-setup-db-caluser.sql	2010-09-26 21:15:24.000000000 +0200
>@@ -0,0 +1,18 @@
>+--- 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;

Actions: View | Diff

Attachments on bug 150974: 109909