From: <jm...@us...> - 2005-03-26 11:51:37
|
Update of /cvsroot/tikiwiki/tiki/db In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv12380/db Modified Files: Tag: BRANCH-1-9 tiki_1.8to1.9.sql Log Message: Add missed fields Index: tiki_1.8to1.9.sql =================================================================== RCS file: /cvsroot/tikiwiki/tiki/db/tiki_1.8to1.9.sql,v retrieving revision 1.79.2.105 retrieving revision 1.79.2.106 diff -u -d -r1.79.2.105 -r1.79.2.106 --- tiki_1.8to1.9.sql 18 Mar 2005 11:28:50 -0000 1.79.2.105 +++ tiki_1.8to1.9.sql 26 Mar 2005 11:51:28 -0000 1.79.2.106 @@ -676,6 +676,10 @@ ALTER TABLE `tiki_calendars` ADD `customevents` ENUM('n','y') DEFAULT 'n' NOT NULL AFTER `customparticipants` ; ALTER TABLE `tiki_calendar_items` ADD `evId` INT( 12 ) DEFAULT '0' NOT NULL AFTER `categoryId` ; +# added on 2005-03-26 by jmj +ALTER TABLE `tiki_calendar_items` ADD `nlId` INT( 12 ) DEFAULT '0' NOT NULL AFTER `categoryId` ; +ALTER TABLE `tiki_calendars` ADD `customsubscription` ENUM('n','y') DEFAULT 'n' NOT NULL AFTER `customparticipants` ; + CREATE TABLE tiki_event_subscriptions ( evId int(12) NOT NULL default '0', email varchar(255) NOT NULL default '', |