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

[Pat Eyler]

On Thu, 2 May 2002, Paul POULAIN wrote:

Paul,
could you check things like this into the rel-1-2 branch as well.  It
would be nice to get a cleaner more functional DB included in the 1.1.2
release.

thanks,
-pate


> 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;
>
>
>
> _______________________________________________________________
>
> Have big pipes? SourceForge.net is looking for download mirrors. We supply
> the hardware. You get the recognition. Email Us: address@hidden
> _______________________________________________
> Koha-devel mailing list
> address@hidden
> https://lists.sourceforge.net/lists/listinfo/koha-devel
>