phpwebsite-comm-cvs-commits

[<dts...@us...>]

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;