[Koha-cvs] CVS: koha database.mysql,1.2,1.2.2.1

[Paul POULAIN]

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

Modified Files:
      Tag: rel-1-2
	database.mysql 
Log Message:
Table optimisation : aqorders. SPEEEEEEEEEEEEEEEDs up receive.pl. try to add indexes on production tables, and you will see... Quite proud of this 2 lines patch ;-)


Index: database.mysql
===================================================================
RCS file: /cvsroot/koha/koha/database.mysql,v
retrieving revision 1.2
retrieving revision 1.2.2.1
diff -C2 -r1.2 -r1.2.2.1
*** database.mysql	17 May 2001 22:36:07 -0000	1.2
--- database.mysql	10 May 2002 16:04:39 -0000	1.2.2.1
***************
*** 129,172 ****
  #
  CREATE TABLE aqorders (
!   ordernumber int(11) DEFAULT '0' NOT NULL auto_increment,
!   biblionumber int(11),
    title text,
!   requisitionedby varchar(10),
!   authorisedby varchar(10),
!   booksellerid varchar(10) DEFAULT '' NOT NULL,
!   deliverydays smallint(6),
!   followupdays smallint(6),
!   numberfollowupsallowed smallint(6),
!   numberfollowupssent smallint(6),
!   entrydate date,
!   dateprinted date,
!   quantity smallint(6),
!   currency char(3),
!   listprice decimal(28,6),
!   totalamount decimal(28,6),
!   datereceived date,
    booksellerinvoicenumber text,
!   freight decimal(28,6),
!   unitprice decimal(28,6),
!   quantityreceived smallint(6),
    sourced text,
!   cancelledby varchar(10),
!   quantityreceiveddamaged smallint(6),
!   datecancellationprinted date,
    notes text,
    supplierreference text,
    purchaseordernumber text,
!   subscription tinyint(1),
!   subscriptionfrom date,
!   subscriptionto date,
!   serialid varchar(30),
!   basketno int(11),
!   biblioitemnumber int(11),
!   timestamp timestamp(14),
!   rrp decimal(13,2),
!   ecost decimal(13,2),
!   gst decimal(13,2),
!   PRIMARY KEY (ordernumber)
! );
  
  #
--- 129,176 ----
  #
  CREATE TABLE aqorders (
!   ordernumber int(11) NOT NULL auto_increment,
!   biblionumber int(11) default NULL,
    title text,
!   requisitionedby varchar(10) default NULL,
!   authorisedby varchar(10) default NULL,
!   booksellerid varchar(10) NOT NULL default '',
!   deliverydays smallint(6) default NULL,
!   followupdays smallint(6) default NULL,
!   numberfollowupsallowed smallint(6) default NULL,
!   numberfollowupssent smallint(6) default NULL,
!   entrydate date default NULL,
!   dateprinted date default NULL,
!   quantity smallint(6) default NULL,
!   currency char(3) default NULL,
!   listprice decimal(28,6) default NULL,
!   totalamount decimal(28,6) default NULL,
!   datereceived date default NULL,
    booksellerinvoicenumber text,
!   freight decimal(28,6) default NULL,
!   unitprice decimal(28,6) default NULL,
!   quantityreceived smallint(6) default NULL,
    sourced text,
!   cancelledby varchar(10) default NULL,
!   quantityreceiveddamaged smallint(6) default NULL,
!   datecancellationprinted date default NULL,
    notes text,
    supplierreference text,
    purchaseordernumber text,
!   subscription tinyint(1) default NULL,
!   subscriptionfrom date default NULL,
!   subscriptionto date default NULL,
!   serialid varchar(30) default NULL,
!   basketno int(11) default NULL,
!   biblioitemnumber int(11) default NULL,
!   timestamp timestamp(14) NOT NULL,
!   rrp decimal(13,2) default NULL,
!   ecost decimal(13,2) default NULL,
!   gst decimal(13,2) default NULL,
!   PRIMARY KEY  (ordernumber),
!   KEY booksellerid (booksellerid),
!   KEY biblionumber (biblionumber),
!   KEY biblioitemnumber (biblioitemnumber),
!   KEY biblioitemnumber_2 (biblioitemnumber)
! ) TYPE=MyISAM;
  
  #