[basedb-cvs] basedb base.sql,1.7,1.8

[<tr...@us...>]

Update of /cvsroot/basedb/basedb
In directory usw-pr-cvs1:/tmp/cvs-serv28185

Modified Files:
	base.sql 
Log Message:
New user access system, 'removed' flag.

Index: base.sql
===================================================================
RCS file: /cvsroot/basedb/basedb/base.sql,v
retrieving revision 1.7
retrieving revision 1.8
diff -C2 -d -r1.7 -r1.8
*** base.sql	7 Sep 2002 11:34:17 -0000	1.7
--- base.sql	30 Sep 2002 17:19:36 -0000	1.8
***************
*** 39,43 ****
    protocol int(11) NOT NULL default '0',
    notes tinytext NOT NULL,
!   isVisible tinyint(1) NOT NULL default '1',
    PRIMARY KEY  (id),
    UNIQUE KEY name (name),
--- 39,46 ----
    protocol int(11) NOT NULL default '0',
    notes tinytext NOT NULL,
!   removed tinyint(1) NOT NULL default '0',
!   gid int(11) NOT NULL default '0',
[...531 lines suppressed...]
+   parent int(11) NOT NULL default '0',
+   PRIMARY KEY  (child,parent)
+ ) TYPE=MyISAM;
+ 
+ #
  # Table structure for table 'UserSearch'
  #
***************
*** 1134,1138 ****
  CREATE TABLE UserSearch (
    item int(11) NOT NULL default '0',
!   searchType enum('plate','sample','extract','labeled','hybridization','value','arraytype','well','wizzzard','raw','exp','user','gene','genelist','program','news','acq','acq_img','ware','acq_rba','platetype','print','array','molecule','upload') NOT NULL default 'plate',
    search int(11) NOT NULL default '0',
    PRIMARY KEY  (search),
--- 1238,1242 ----
  CREATE TABLE UserSearch (
    item int(11) NOT NULL default '0',
!   searchType enum('plate','sample','extract','labeled','hybridization','value','arraytype','well','wizzzard','raw','exp','user','gene','genelist','program','news','acq','acq_img','ware','acq_rba','platetype','print','array','molecule','upload','annottype','protocol') NOT NULL default 'plate',
    search int(11) NOT NULL default '0',
    PRIMARY KEY  (search),