From: <dts...@us...> - 2003-06-03 20:07:43
|
Update of /cvsroot/phpwebsite-comm/modules/phpwsbb/boost In directory sc8-pr-cvs1:/tmp/cvs-serv32753/boost Modified Files: install.sql uninstall.sql Log Message: Adding thread layer Index: install.sql =================================================================== RCS file: /cvsroot/phpwebsite-comm/modules/phpwsbb/boost/install.sql,v retrieving revision 1.4 retrieving revision 1.5 diff -C2 -d -r1.4 -r1.5 *** install.sql 3 Jun 2003 16:22:40 -0000 1.4 --- install.sql 3 Jun 2003 20:07:09 -0000 1.5 *************** *** 1,4 **** --- 1,21 ---- -- $Id$ + CREATE TABLE mod_phpwsbb_threads ( + id int NOT NULL default '0', + owner varchar(20) default '', + editor varchar(20) default '', + ip text, + label text NOT NULL, + groups text, + created int NOT NULL default '0', + updated int NOT NULL default '0', + hidden smallint NOT NULL default '1', + approved smallint NOT NULL default '0', + sticky smallint, + locked smallint, + replies int NOT NULL default '0', + PRIMARY KEY (id) + ); + CREATE TABLE mod_phpwsbb_messages ( id int NOT NULL default '0', *************** *** 12,23 **** hidden smallint NOT NULL default '1', approved smallint NOT NULL default '0', ! pid int NOT NULL default '0', guestname varchar(50), guestemail varchar(80), body text, - sticky smallint, - locked smallint, - replies int NOT NULL default '0', - lastreply int NOT NULL default 0, PRIMARY KEY (id) ); --- 29,36 ---- hidden smallint NOT NULL default '1', approved smallint NOT NULL default '0', ! tid int NOT NULL default '0', guestname varchar(50), guestemail varchar(80), body text, PRIMARY KEY (id) ); Index: uninstall.sql =================================================================== RCS file: /cvsroot/phpwebsite-comm/modules/phpwsbb/boost/uninstall.sql,v retrieving revision 1.1 retrieving revision 1.2 diff -C2 -d -r1.1 -r1.2 *** uninstall.sql 20 May 2003 19:29:38 -0000 1.1 --- uninstall.sql 3 Jun 2003 20:07:09 -0000 1.2 *************** *** 1,3 **** --- 1,4 ---- -- $Id$ + DROP TABLE mod_phpwsbb_threads; DROP TABLE mod_phpwsbb_messages; |