[Koha-devel] CVS: koha database.mysql,1.4,1.5

[Paul POULAIN]

Update of /cvsroot/koha/koha
In directory usw-pr-cvs1:/tmp/cvs-serv32641

Modified Files:
        database.mysql 
Log Message:
updated database.mysql : dropped unused tables, created indexes : old 
database.mysql updated by updatedatabase2.pl script


Index: database.mysql
===================================================================
RCS file: /cvsroot/koha/koha/database.mysql,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -r1.4 -r1.5
*** database.mysql      2 May 2002 00:23:26 -0000       1.4
--- database.mysql      2 May 2002 09:19:49 -0000       1.5
***************
*** 1,60 ****
! # MySQL dump 7.1
! #
! # Host: localhost    Database: c4test
! #--------------------------------------------------------
! # Server version      3.22.32-log
  
  #
! # Table structure for table 'accountlines'
  #
  CREATE TABLE accountlines (
[...1500 lines suppressed...]
+ 
  CREATE TABLE systempreferences (
!   variable char(50) NOT NULL default '',
!   value char(200) default NULL,
!   PRIMARY KEY  (variable)
! ) TYPE=ISAM PACK_KEYS=1;
! # --------------------------------------------------------
  
  #
! # Table structure for table `users`
  #
+ 
  CREATE TABLE users (
!   usercode varchar(10) NOT NULL default '',
    username text,
    password text,
!   level smallint(6) default NULL,
!   PRIMARY KEY  (usercode)
! ) TYPE=ISAM PACK_KEYS=1;