[Redpos-cvs] RedPOS/db/scripts localDB.log,NONE,1.1 localDB.data,1.2,1.3 localDB.properties,1.2,1.3

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 422-6466

Update of /cvsroot/redpos/RedPOS/db/scripts
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv16962/db/scripts

Modified Files:
	localDB.data localDB.properties localDB.script 
Added Files:
	localDB.log 
Log Message:
Added index on RPPRODCT, RPRECIPT and RPTALLY

--- NEW FILE: localDB.log ---
/*C2*/CONNECT USER SA
SET AUTOCOMMIT FALSE
DISCONNECT

Index: localDB.properties
===================================================================
RCS file: /cvsroot/redpos/RedPOS/db/scripts/localDB.properties,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** localDB.properties	27 Dec 2004 22:35:05 -0000	1.2
--- localDB.properties	19 Feb 2005 08:07:28 -0000	1.3
***************
*** 1,16 ****
  #HSQL database
! #Mon Dec 27 23:33:23 CET 2004
! sql.strict_fk=true
! readonly=false
! sql.strong_fk=true
! hsqldb.version=1.7.1
! version=1.7.1
  hsqldb.cache_scale=14
! sql.compare_in_locale=false
! sql.month=true
  hsqldb.log_size=200
! modified=no
! hsqldb.cache_version=1.7.0
  hsqldb.original_version=1.7.1
! hsqldb.compatible_version=1.7.0
! sql.enforce_size=false
--- 1,20 ----
  #HSQL database
! #Sat Feb 19 08:56:41 CET 2005
! hsqldb.cache_file_scale=1
! runtime.gc_interval=0
! hsqldb.first_identity=0
! version=1.7.2
! modified=yes
! hsqldb.script_format=0
! sql.enforce_size=false
! hsqldb.cache_size_scale=10
  hsqldb.cache_scale=14
! hsqldb.version=1.7.2
  hsqldb.log_size=200
! sql.enforce_strict_size=false
! readonly=false
! hsqldb.compatible_version=1.7.2
  hsqldb.original_version=1.7.1
! sql.compare_in_locale=false
! hsqldb.nio_data_file=true
! hsqldb.cache_version=1.7.0

Index: localDB.script
===================================================================
RCS file: /cvsroot/redpos/RedPOS/db/scripts/localDB.script,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** localDB.script	11 Jan 2005 09:26:50 -0000	1.3
--- localDB.script	19 Feb 2005 08:07:28 -0000	1.4
***************
*** 1,97 ****
! CREATE TABLE RPPRODCT(PRODUCTID VARCHAR NOT NULL PRIMARY KEY,BARCODE1 VARCHAR NOT NULL,BARCODE2 VARCHAR,BARCODE3 VARCHAR,PRODUCTTEXT VARCHAR NOT NULL,CAMPAIGNCODE VARCHAR,SERVICES VARCHAR,SALESUPPORT VARCHAR,TAXPERCENTAGE DOUBLE,DISCOUNTABLE BIT,BLOCKED BIT,CONSTRAINT SYS_CT_1 UNIQUE(PRODUCTID))
  CREATE TABLE RPPRCLST(PRODUCTID VARCHAR NOT NULL,PRICELISTID VARCHAR NOT NULL,NETPRICE DOUBLE,GROSSPRICE DOUBLE,CURRENCY VARCHAR,TAXAMOUNT DOUBLE,CONSTRAINT SYS_PK_RPPRCLST PRIMARY KEY(PRODUCTID,PRICELISTID),CONSTRAINT SYS_CT_3 UNIQUE(PRODUCTID,PRICELISTID))
! CREATE CACHED TABLE RPRECIPT(RECEIPTID VARCHAR NOT NULL PRIMARY KEY,REGISTERID VARCHAR NOT NULL,STOREID VARCHAR NOT NULL,CASHIER VARCHAR NOT NULL,PRICELISTID VARCHAR NOT NULL,ADDEDDATE TIMESTAMP NOT NULL,RECEIPTTYPE INTEGER NOT NULL,RECEIPTSTATUS INTEGER NOT NULL,UPLOADED BIT,TALLIED BIT,CONSTRAINT SYS_CT_5 UNIQUE(RECEIPTID))
  CREATE CACHED TABLE RPRCPTRW(RECEIPTID VARCHAR NOT NULL,ROWORDER INTEGER NOT NULL,ROWTYPE INTEGER NOT NULL,ROWREF INTEGER,ROWOBJECT VARCHAR,ROWTEXT VARCHAR NOT NULL,QUANTITY DOUBLE NOT NULL,AMOUNT DOUBLE,CURRENCY VARCHAR,TAXPERCENTAGE DOUBLE,TAXAMOUNT DOUBLE,ROWSTATUS INTEGER NOT NULL,CONSTRAINT SYS_PK_RPRCPTRW PRIMARY KEY(RECEIPTID,ROWORDER),CONSTRAINT SYS_CT_7 UNIQUE(RECEIPTID,ROWORDER))
! CREATE TABLE RPIDS(IDNAME VARCHAR NOT NULL,KEY VARCHAR NOT NULL,VALUE VARCHAR,CONSTRAINT SYS_PK_RPIDS PRIMARY KEY(IDNAME,KEY),CONSTRAINT SYS_CT_9 UNIQUE(IDNAME,KEY))
! CREATE CACHED TABLE RPUSERS(USERID VARCHAR NOT NULL,USERNAME VARCHAR NOT NULL,NAME VARCHAR,PASSWORD VARCHAR,ALTID VARCHAR,CONSTRAINT SYS_PK_RPUSERS PRIMARY KEY(USERID,USERNAME),CONSTRAINT SYS_CT_11 UNIQUE(USERID,USERNAME))
! CREATE CACHED TABLE RPTALLY(TALLYID VARCHAR NOT NULL PRIMARY KEY,REGISTERID VARCHAR NOT NULL,STOREID VARCHAR NOT NULL,CREATEDBY VARCHAR NOT NULL,CREATEDDATE TIMESTAMP NOT NULL,FROMRECEIPTID VARCHAR NOT NULL,TORECEIPTID VARCHAR NOT NULL,FROMRECEIPTDATE TIMESTAMP NOT NULL,TORECEIPTDATE TIMESTAMP NOT NULL,CASHIERS VARCHAR NOT NULL,UPLOADED BIT,CONSTRAINT SYS_CT_13 UNIQUE(TALLYID))
  CREATE CACHED TABLE RPTALRW(TALLYID VARCHAR NOT NULL,ROWNUMBER INTEGER NOT NULL,TYPE VARCHAR NOT NULL,ID VARCHAR,AMOUNT DOUBLE,CURRENCY VARCHAR,RECEIPTCOUNT INTEGER,TAXPERCENTAGE DOUBLE,DATA VARCHAR,CONSTRAINT SYS_PK_RPTALRW PRIMARY KEY(TALLYID,ROWNUMBER),CONSTRAINT SYS_CT_15 UNIQUE(TALLYID,ROWNUMBER))
! SET TABLE RPRECIPT INDEX '-1 -1 0'
! SET TABLE RPRCPTRW INDEX '-1 -1 0'
! SET TABLE RPUSERS INDEX '32 32 1'
! SET TABLE RPTALLY INDEX '-1 -1 0'
! SET TABLE RPTALRW INDEX '-1 -1 0'
! GRANT ALL ON CLASS "java.lang.Math" TO PUBLIC
! GRANT ALL ON CLASS "org.hsqldb.Library" TO PUBLIC
  CREATE USER SA PASSWORD "" ADMIN
! CREATE ALIAS DAYNAME FOR "org.hsqldb.Library.dayname"
! CREATE ALIAS SPACE FOR "org.hsqldb.Library.space"
! CREATE ALIAS SUBSTRING FOR "org.hsqldb.Library.substring"
! CREATE ALIAS HEXTORAW FOR "org.hsqldb.Library.hexToRaw"
! CREATE ALIAS SQRT FOR "java.lang.Math.sqrt"
! CREATE ALIAS ABS FOR "org.hsqldb.Library.abs"
! CREATE ALIAS POWER FOR "java.lang.Math.pow"
! CREATE ALIAS CHAR FOR "org.hsqldb.Library.character"
! CREATE ALIAS CONCAT FOR "org.hsqldb.Library.concat"
! CREATE ALIAS PI FOR "org.hsqldb.Library.pi"
! CREATE ALIAS RAWTOHEX FOR "org.hsqldb.Library.rawToHex"
! CREATE ALIAS SECOND FOR "org.hsqldb.Library.second"
! CREATE ALIAS TRUNCATE FOR "org.hsqldb.Library.truncate"
! CREATE ALIAS MONTH FOR "org.hsqldb.Library.month"
! CREATE ALIAS LOWER FOR "org.hsqldb.Library.lcase"
! CREATE ALIAS ATAN2 FOR "java.lang.Math.atan2"
! CREATE ALIAS REPEAT FOR "org.hsqldb.Library.repeat"
! CREATE ALIAS DAYOFMONTH FOR "org.hsqldb.Library.dayofmonth"
! CREATE ALIAS TAN FOR "java.lang.Math.tan"
! CREATE ALIAS RADIANS FOR "java.lang.Math.toRadians"
! CREATE ALIAS FLOOR FOR "java.lang.Math.floor"
! CREATE ALIAS NOW FOR "org.hsqldb.Library.now"
! CREATE ALIAS ACOS FOR "java.lang.Math.acos"
! CREATE ALIAS DAYOFWEEK FOR "org.hsqldb.Library.dayofweek"
! CREATE ALIAS CEILING FOR "java.lang.Math.ceil"
! CREATE ALIAS DAYOFYEAR FOR "org.hsqldb.Library.dayofyear"
! CREATE ALIAS LCASE FOR "org.hsqldb.Library.lcase"
! CREATE ALIAS WEEK FOR "org.hsqldb.Library.week"
! CREATE ALIAS SOUNDEX FOR "org.hsqldb.Library.soundex"
! CREATE ALIAS ASIN FOR "java.lang.Math.asin"
! CREATE ALIAS LOCATE FOR "org.hsqldb.Library.locate"
! CREATE ALIAS EXP FOR "java.lang.Math.exp"
! CREATE ALIAS MONTHNAME FOR "org.hsqldb.Library.monthname"
! CREATE ALIAS YEAR FOR "org.hsqldb.Library.year"
! CREATE ALIAS LEFT FOR "org.hsqldb.Library.left"
! CREATE ALIAS ROUNDMAGIC FOR "org.hsqldb.Library.roundMagic"
! CREATE ALIAS BITOR FOR "org.hsqldb.Library.bitor"
! CREATE ALIAS LTRIM FOR "org.hsqldb.Library.ltrim"
! CREATE ALIAS COT FOR "org.hsqldb.Library.cot"
! CREATE ALIAS COS FOR "java.lang.Math.cos"
! CREATE ALIAS MOD FOR "org.hsqldb.Library.mod"
! CREATE ALIAS SIGN FOR "org.hsqldb.Library.sign"
! CREATE ALIAS DEGREES FOR "java.lang.Math.toDegrees"
! CREATE ALIAS LOG FOR "java.lang.Math.log"
! CREATE ALIAS SIN FOR "java.lang.Math.sin"
! CREATE ALIAS CURTIME FOR "org.hsqldb.Library.curtime"
! CREATE ALIAS DIFFERENCE FOR "org.hsqldb.Library.difference"
! CREATE ALIAS INSERT FOR "org.hsqldb.Library.insert"
! CREATE ALIAS SUBSTR FOR "org.hsqldb.Library.substring"
! CREATE ALIAS DATABASE FOR "org.hsqldb.Library.database"
! CREATE ALIAS MINUTE FOR "org.hsqldb.Library.minute"
! CREATE ALIAS HOUR FOR "org.hsqldb.Library.hour"
! CREATE ALIAS IDENTITY FOR "org.hsqldb.Library.identity"
! CREATE ALIAS QUARTER FOR "org.hsqldb.Library.quarter"
! CREATE ALIAS CURDATE FOR "org.hsqldb.Library.curdate"
! CREATE ALIAS BITAND FOR "org.hsqldb.Library.bitand"
! CREATE ALIAS USER FOR "org.hsqldb.Library.user"
! CREATE ALIAS UCASE FOR "org.hsqldb.Library.ucase"
! CREATE ALIAS RTRIM FOR "org.hsqldb.Library.rtrim"
! CREATE ALIAS LOG10 FOR "org.hsqldb.Library.log10"
! CREATE ALIAS RIGHT FOR "org.hsqldb.Library.right"
! CREATE ALIAS ATAN FOR "java.lang.Math.atan"
! CREATE ALIAS UPPER FOR "org.hsqldb.Library.ucase"
! CREATE ALIAS ASCII FOR "org.hsqldb.Library.ascii"
! CREATE ALIAS RAND FOR "java.lang.Math.random"
! CREATE ALIAS LENGTH FOR "org.hsqldb.Library.length"
! CREATE ALIAS ROUND FOR "org.hsqldb.Library.round"
! CREATE ALIAS REPLACE FOR "org.hsqldb.Library.replace"
! INSERT INTO RPPRODCT VALUES('1','1','7314440250073','BARCODE3','Water','','','Fresh water on bottle',0.25E0,true,false)
! INSERT INTO RPPRODCT VALUES('10','10','3086126100326','BARCODE3','Fermented herring','','','Served with cold milk, beware of the smell',0.25E0,true,false)
! INSERT INTO RPPRODCT VALUES('12','12','7310321250002','BARCODE3','Vegemite','','','Concentrated yeast extract',0.25E0,true,false)
! INSERT INTO RPPRODCT VALUES('2','2','7311310027094','BARCODE3','Clothes','','','Genuine brand',0.25E0,true,false)
! INSERT INTO RPPRODCT VALUES('3','3','7310130418006','BARCODE3','Fruit','','','Fresh and tasty',0.25E0,true,false)
! INSERT INTO RPPRODCT VALUES('4','4','7300330003218','BARCODE3','Shoes','','','Made for walking',0.25E0,true,false)
! INSERT INTO RPPRODCT VALUES('5','5','7310186023056','BARCODE3','Record','','','Play some music',0.25E0,true,false)
! INSERT INTO RPPRODCT VALUES('6','6','7310106023685','BARCODE3','Sport','','','Sport and fitness',0.25E0,true,false)
! INSERT INTO RPPRODCT VALUES('7','7','7310130418013','BARCODE3','Sony Ericsson T610','','','Offer the customer Bluetooth Headset',0.25E0,true,false)
! INSERT INTO RPPRODCT VALUES('8','8','7392620102206','BARCODE3','Book','','','Read me',0.25E0,true,false)
! INSERT INTO RPPRODCT VALUES('9','9','7200266061842','BARCODE3','Red Hat Linux 9 Manual','','','Have fun',0.25E0,true,false)
  INSERT INTO RPPRCLST VALUES('1','1000001',100.0E0,125.0E0,'USD',25.0E0)
  INSERT INTO RPPRCLST VALUES('10','1000001',88.0E0,110.0E0,'USD',22.0E0)
--- 1,30 ----
! CREATE TABLE RPPRODCT(PRODUCTID VARCHAR NOT NULL PRIMARY KEY,BARCODE1 VARCHAR_IGNORECASE NOT NULL,BARCODE2 VARCHAR_IGNORECASE,BARCODE3 VARCHAR_IGNORECASE,PRODUCTTEXT VARCHAR_IGNORECASE NOT NULL,CAMPAIGNCODE VARCHAR,SERVICES VARCHAR,SALESUPPORT VARCHAR,TAXPERCENTAGE DOUBLE,DISCOUNTABLE BOOLEAN,BLOCKED BOOLEAN,CONSTRAINT SYS_CT_1 UNIQUE(PRODUCTID))
! CREATE INDEX RPPRODCT_IX1 ON RPPRODCT(BARCODE1)
! CREATE INDEX RPPRODCT_IX2 ON RPPRODCT(BARCODE2)
! CREATE INDEX RPPRODCT_IX3 ON RPPRODCT(PRODUCTTEXT)
  CREATE TABLE RPPRCLST(PRODUCTID VARCHAR NOT NULL,PRICELISTID VARCHAR NOT NULL,NETPRICE DOUBLE,GROSSPRICE DOUBLE,CURRENCY VARCHAR,TAXAMOUNT DOUBLE,CONSTRAINT SYS_PK_RPPRCLST PRIMARY KEY(PRODUCTID,PRICELISTID),CONSTRAINT SYS_CT_3 UNIQUE(PRODUCTID,PRICELISTID))
! CREATE CACHED TABLE RPRECIPT(RECEIPTID VARCHAR NOT NULL PRIMARY KEY,REGISTERID VARCHAR NOT NULL,STOREID VARCHAR NOT NULL,CASHIER VARCHAR NOT NULL,PRICELISTID VARCHAR NOT NULL,ADDEDDATE TIMESTAMP NOT NULL,RECEIPTTYPE INTEGER NOT NULL,RECEIPTSTATUS INTEGER NOT NULL,UPLOADED BOOLEAN,TALLIED BOOLEAN,CONSTRAINT SYS_CT_5 UNIQUE(RECEIPTID))
! CREATE INDEX RPRECIPT_IX1 ON RPRECIPT(REGISTERID,TALLIED)
! CREATE INDEX RPRECIPT_IX2 ON RPRECIPT(UPLOADED)
  CREATE CACHED TABLE RPRCPTRW(RECEIPTID VARCHAR NOT NULL,ROWORDER INTEGER NOT NULL,ROWTYPE INTEGER NOT NULL,ROWREF INTEGER,ROWOBJECT VARCHAR,ROWTEXT VARCHAR NOT NULL,QUANTITY DOUBLE NOT NULL,AMOUNT DOUBLE,CURRENCY VARCHAR,TAXPERCENTAGE DOUBLE,TAXAMOUNT DOUBLE,ROWSTATUS INTEGER NOT NULL,CONSTRAINT SYS_PK_RPRCPTRW PRIMARY KEY(RECEIPTID,ROWORDER),CONSTRAINT SYS_CT_7 UNIQUE(RECEIPTID,ROWORDER))
! CREATE TABLE RPIDS(IDNAME VARCHAR_IGNORECASE NOT NULL,KEY VARCHAR NOT NULL,VALUE VARCHAR,CONSTRAINT SYS_PK_RPIDS PRIMARY KEY(IDNAME,KEY),CONSTRAINT SYS_CT_9 UNIQUE(IDNAME,KEY))
! CREATE CACHED TABLE RPUSERS(USERID VARCHAR NOT NULL,USERNAME VARCHAR_IGNORECASE NOT NULL,NAME VARCHAR,PASSWORD VARCHAR,ALTID VARCHAR,CONSTRAINT SYS_PK_RPUSERS PRIMARY KEY(USERID,USERNAME),CONSTRAINT SYS_CT_11 UNIQUE(USERID,USERNAME))
! CREATE CACHED TABLE RPTALLY(TALLYID VARCHAR NOT NULL PRIMARY KEY,REGISTERID VARCHAR NOT NULL,STOREID VARCHAR NOT NULL,CREATEDBY VARCHAR NOT NULL,CREATEDDATE TIMESTAMP NOT NULL,FROMRECEIPTID VARCHAR NOT NULL,TORECEIPTID VARCHAR NOT NULL,FROMRECEIPTDATE TIMESTAMP NOT NULL,TORECEIPTDATE TIMESTAMP NOT NULL,CASHIERS VARCHAR NOT NULL,UPLOADED BOOLEAN,CONSTRAINT SYS_CT_13 UNIQUE(TALLYID))
! CREATE INDEX RPTALLY_IX1 ON RPTALLY(CREATEDDATE)
  CREATE CACHED TABLE RPTALRW(TALLYID VARCHAR NOT NULL,ROWNUMBER INTEGER NOT NULL,TYPE VARCHAR NOT NULL,ID VARCHAR,AMOUNT DOUBLE,CURRENCY VARCHAR,RECEIPTCOUNT INTEGER,TAXPERCENTAGE DOUBLE,DATA VARCHAR,CONSTRAINT SYS_PK_RPTALRW PRIMARY KEY(TALLYID,ROWNUMBER),CONSTRAINT SYS_CT_15 UNIQUE(TALLYID,ROWNUMBER))
! SET TABLE RPUSERS INDEX'32 32 1'
  CREATE USER SA PASSWORD "" ADMIN
! SET WRITE_DELAY 60
! INSERT INTO RPPRODCT VALUES('1','1','7314440250073','BARCODE3','Water','','','Fresh water on bottle',0.25E0,TRUE,FALSE)
! INSERT INTO RPPRODCT VALUES('10','10','3086126100326','BARCODE3','Fermented herring','','','Served with cold milk, beware of the smell',0.25E0,TRUE,FALSE)
! INSERT INTO RPPRODCT VALUES('12','12','7310321250002','BARCODE3','Vegemite','','','Concentrated yeast extract',0.25E0,TRUE,FALSE)
! INSERT INTO RPPRODCT VALUES('2','2','7311310027094','BARCODE3','Clothes','','','Genuine brand',0.25E0,TRUE,FALSE)
! INSERT INTO RPPRODCT VALUES('3','3','7310130418006','BARCODE3','Fruit','','','Fresh and tasty',0.25E0,TRUE,FALSE)
! INSERT INTO RPPRODCT VALUES('4','4','7300330003218','BARCODE3','Shoes','','','Made for walking',0.25E0,TRUE,FALSE)
! INSERT INTO RPPRODCT VALUES('5','5','7310186023056','BARCODE3','Record','','','Play some music',0.25E0,TRUE,FALSE)
! INSERT INTO RPPRODCT VALUES('6','6','7310106023685','BARCODE3','Sport','','','Sport and fitness',0.25E0,TRUE,FALSE)
! INSERT INTO RPPRODCT VALUES('7','7','7310130418013','BARCODE3','Sony Ericsson T610','','','Offer the customer Bluetooth Headset',0.25E0,TRUE,FALSE)
! INSERT INTO RPPRODCT VALUES('8','8','7392620102206','BARCODE3','Book','','','Read me',0.25E0,TRUE,FALSE)
! INSERT INTO RPPRODCT VALUES('9','9','7200266061842','BARCODE3','Red Hat Linux 9 Manual','','','Have fun',0.25E0,TRUE,FALSE)
  INSERT INTO RPPRCLST VALUES('1','1000001',100.0E0,125.0E0,'USD',25.0E0)
  INSERT INTO RPPRCLST VALUES('10','1000001',88.0E0,110.0E0,'USD',22.0E0)

Index: localDB.data
===================================================================
RCS file: /cvsroot/redpos/RedPOS/db/scripts/localDB.data,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
Binary files /tmp/cvsTlIInB and /tmp/cvsvE6R6o differ

[Redpos-cvs] RedPOS/db/scripts localDB.log,NONE,1.1 localDB.data,1.2,1.3 localDB.properties,1.2,1.3

[Redpos-cvs] RedPOS/db/scripts localDB.log,NONE,1.1 localDB.data,1.2,1.3 localDB.properties,1.2,1.3 localDB.script,1.3,1.4