ports/150974: www/cybercalendar : port fix / deprecate

[Rodrigo OSORIO (ros)]

The following reply was made to PR ports/150974; it has been noted by GNATS.

From: "Rodrigo OSORIO (ros)" <rodrigo at bebik.net>
To: wen heping <wenheping at gmail.com>
Cc: bug-followup at FreeBSD.org
Subject: Re: ports/150974: www/cybercalendar : port fix / deprecate
Date: Thu, 4 Nov 2010 10:41:46 +0100

 --EeQfGwPcQSOJBaQU
 Content-Type: text/plain; charset=us-ascii
 Content-Disposition: inline
 
 On 03/11/10 16:08 +0800, wen heping wrote:
 > But where is the patch file ?
 > 
 > wen
 > 
 
 Hi,
 
 You right, there is a missing file.
 
 The attached file is the original fix;
 I suppose you don't need a patch to add
 the DEPRECATE flag into the Makefile.
 
 regards
 - rodrigo
 
 --EeQfGwPcQSOJBaQU
 Content-Type: text/x-diff; charset=us-ascii
 Content-Disposition: attachment; filename="cybercalendar.patch"
 
 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;
 
 --EeQfGwPcQSOJBaQU--