Update of /cvsroot/basedb/basedb
In directory usw-pr-cvs1:/tmp/cvs-serv22642
Modified Files:
base.sql
Log Message:
Renamed columns and did other changes for postgresql compatibility
Index: base.sql
===================================================================
RCS file: /cvsroot/basedb/basedb/base.sql,v
retrieving revision 1.6
retrieving revision 1.7
diff -C2 -d -r1.6 -r1.7
*** base.sql 10 Jul 2002 17:57:32 -0000 1.6
--- base.sql 7 Sep 2002 11:34:17 -0000 1.7
***************
*** 33,37 ****
printStartDate datetime NOT NULL default '0000-00-00 00:00:00',
printEndDate datetime NOT NULL default '0000-00-00 00:00:00',
! user int(11) NOT NULL default '0',
name varchar(40) NOT NULL default '',
addedDate date NOT NULL default '0000-00-00',
--- 33,37 ----
printStartDate datetime NOT NULL default '0000-00-00 00:00:00',
printEndDate datetime NOT NULL default '0000-00-00 00:00:00',
! owner int(11) NOT NULL default '0',
name varchar(40) NOT NULL default '',
[...939 lines suppressed...]
! KEY usertype (owner,etype)
) TYPE=MyISAM;
***************
*** 1160,1166 ****
CREATE TABLE WizzzardUser (
wizzzard int(11) NOT NULL default '0',
! user int(11) NOT NULL default '0',
! PRIMARY KEY (wizzzard,user),
! KEY user (user)
) TYPE=MyISAM;
--- 1197,1203 ----
CREATE TABLE WizzzardUser (
wizzzard int(11) NOT NULL default '0',
! owner int(11) NOT NULL default '0',
! PRIMARY KEY (wizzzard,owner),
! KEY owner (owner)
) TYPE=MyISAM;
|
