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

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

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;