[phpws-comm-commits] modules/phpwsbb/boost install.sql,1.1,1.2

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

Update of /cvsroot/phpwebsite-comm/modules/phpwsbb/boost
In directory sc8-pr-cvs1:/tmp/cvs-serv13892/boost

Modified Files:
	install.sql 
Log Message:
Getting lists working


Index: install.sql
===================================================================
RCS file: /cvsroot/phpwebsite-comm/modules/phpwsbb/boost/install.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** install.sql	20 May 2003 19:29:38 -0000	1.1
--- install.sql	22 May 2003 02:53:34 -0000	1.2
***************
*** 2,19 ****
  
  CREATE TABLE mod_phpwsbb_messages (
!     id          int(10) NOT NULL default '0',
!     owner       varchar(20) binary default '',
!     editor      varchar(20) binary default '',
      ip          text,
      label       text NOT NULL,
!     groups      mediumtext,
!     created     int(11) NOT NULL default '0',
!     updated     int(11) NOT NULL default '0',
!     hidden      int(1) NOT NULL default '1',
!     approved    int(1) NOT NULL default '0',
!     pid         int(10) NOT NULL default '0',
      guestname   varchar(50),
      guestemail  varchar(80),
      body        text,
      PRIMARY KEY (id)
  );
--- 2,20 ----
  
  CREATE TABLE mod_phpwsbb_messages (
!     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',
!     pid         int NOT NULL default '0',
      guestname   varchar(50),
      guestemail  varchar(80),
      body        text,
+     sticky      smallint,
      PRIMARY KEY (id)
  );