Menu
▾
▴
[Pocolap-cvscommit] pocolap/data/pocolapDB/sampleDB service.properties,NONE,1.1 nss.properties,NONE,1.1 nss.script,NONE,1.1
|
From: todd r. <to...@us...> - 2005-03-31 20:54:52
|
Update of /cvsroot/pocolap/pocolap/data/pocolapDB/sampleDB In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv9992/data/pocolapDB/sampleDB Added Files: service.properties nss.properties nss.script Log Message: Reorganization of resources --- NEW FILE: service.properties --- #/tmp/newdata/sampleDB # ******************************************************************** # *** Please do NOT edit this file. *** # *** CHANGING THE CONTENT OF THIS FILE MAY CAUSE DATA CORRUPTION. *** # ******************************************************************** #Wed Mar 30 11:28:58 PST 2005 SysschemasIndex2Identifier=225 SyscolumnsIdentifier=144 SysconglomeratesIndex1Identifier=49 SysconglomeratesIdentifier=32 SyscolumnsIndex2Identifier=177 SysschemasIndex1Identifier=209 SysconglomeratesIndex3Identifier=81 SystablesIndex2Identifier=129 SyscolumnsIndex1Identifier=161 derby.serviceProtocol=org.apache.derby.database.Database SysschemasIdentifier=192 derby.storage.propertiesId=16 SysconglomeratesIndex2Identifier=65 derby.serviceLocale=en_US SystablesIdentifier=96 SystablesIndex1Identifier=113 --- NEW FILE: nss.script --- CREATE TABLE "CUSTOMERS"("CUSTOMERID" INTEGER NOT NULL IDENTITY PRIMARY KEY,"CUSTOMERNUMBER" INTEGER,"FIRSTNAME" VARCHAR(50),"LASTNAME" VARCHAR(50),"ADDRESS" VARCHAR(100),"CITY" VARCHAR(60),"STATENAME" VARCHAR(50),"STATEABBREV" CHAR(2),"ZIP" VARCHAR(15),"PHONE" VARCHAR(25),"BIRTHDATE" DATE,"SIZINGGENDER" VARCHAR(20),"SHOESIZE" FLOAT,"WIDESIZES" BIT) CREATE TABLE "SALABLEITEMS"("SALABLEITEMSID" INTEGER NOT NULL IDENTITY PRIMARY KEY,"SKU" INTEGER,"DESCRIPTION" VARCHAR(50),"ISPRODUCT" BIT,"ISSIZEDEPENDANT" BIT,"COLOR" VARCHAR(30),"VENDOR" VARCHAR(80),"VENDORNUMBER" INTEGER) CREATE TABLE "CALENDAR"("CALENDARID" INTEGER NOT NULL IDENTITY PRIMARY KEY,"DAYDATE" DATE,"DAYNAME" VARCHAR(12),"DAYABBREV" CHAR(3),"DAYOFWEEK" INTEGER,"DAYOFMONTH" INTEGER,"MONTHNAME" VARCHAR(12),"MONTHABBREV" CHAR(3),"MONTHOFYEAR" INTEGER,"YEAR" INTEGER,"ISHOLIDAY" BIT,"WASOPENED" BIT) CREATE TABLE "SALES"("CUSTOMERID" INTEGER,"SALABLEITEMSID" INTEGER,"CALENDARID" INTEGER,"AMOUNT" FLOAT,"WEBSALE" BIT) GRANT ALL ON CLASS "java.lang.Math" TO PUBLIC GRANT ALL ON CLASS "org.hsqldb.Library" TO PUBLIC CREATE USER SA PASSWORD "" ADMIN CREATE USER NSSUSER PASSWORD "NSSPASS" GRANT SELECT ON CUSTOMERS TO NSSUSER GRANT SELECT ON CALENDAR TO NSSUSER GRANT SELECT ON SALABLEITEMS TO NSSUSER GRANT SELECT ON SALES TO NSSUSER 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 DATE_ADD FOR "com.pocolap.hsqldb.datetime.DateAgent.dateAdd" 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 DATE_FORMAT FOR "com.pocolap.hsqldb.datetime.DateAgent.dateFormat" 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 "CUSTOMERS" VALUES(0,0,'Nobody','Blank','0 Identity Rd','Portland','Oregon','OR','97201','503-555-0001','1950-01-01','mens',10.0E0,false) INSERT INTO "CUSTOMERS" VALUES(1,17,'Tom','Ling','112 SomeStreet','Portland','Oregon','OR','97201','503-555-1233','1962-02-25','mens',7.5E0,false) INSERT INTO "CUSTOMERS" VALUES(2,19,'Sammy','Hamm','4102 W. First','Portland','Oregon','OR','97210','503-555-4754','1964-10-04','mens',9.0E0,true) INSERT INTO "CUSTOMERS" VALUES(3,24,'Sarah','Weston','421 Sideline St. Apt #4','Lake Oswego','Oregon','OR','97035','503-555-8874','1974-03-21','mens',8.0E0,false) INSERT INTO "CUSTOMERS" VALUES(4,25,'Lisa','Weston','421 Sideline St. Apt #4','Lake Oswego','Oregon','OR','97035','503-555-8874','1991-10-07','girls',2.0E0,true) INSERT INTO "CUSTOMERS" VALUES(5,26,'Bill','Franklin','801 Lake Ave.','Portland','Oregon','OR','97202','503-555-4120','1965-09-21','mens',10.0E0,false) INSERT INTO "CUSTOMERS" VALUES(6,28,'Wilma','Barkley','7021 SW 66th','Tigard','Oregon','OR','97224','503-555-4998','1975-09-21','womens',7.0E0,false) INSERT INTO "CUSTOMERS" VALUES(7,29,'Walter','McClellan','10425 Walling Cir','West Linn','Oregon','OR','97068','503-555-8856','1938-03-01','mens',8.5E0,true) INSERT INTO "SALABLEITEMS" VALUES(0,234001,'36" laces',true,false,'Brown','Laces USA',78778) INSERT INTO "SALABLEITEMS" VALUES(1,234002,'36" laces',true,false,'Black','Laces USA',78778) INSERT INTO "SALABLEITEMS" VALUES(2,234003,'36" laces',true,false,'Beige','Laces USA',78778) INSERT INTO "SALABLEITEMS" VALUES(3,234004,'36" laces',true,false,'White','Laces USA',78778) INSERT INTO "SALABLEITEMS" VALUES(4,234011,'54" laces',true,false,'Brown','Laces USA',78778) INSERT INTO "SALABLEITEMS" VALUES(5,234012,'54" laces',true,false,'Black','Laces USA',78778) INSERT INTO "SALABLEITEMS" VALUES(6,234013,'54" laces',true,false,'Beige','Laces USA',78778) INSERT INTO "SALABLEITEMS" VALUES(7,234014,'54" laces',true,false,'White','Laces USA',78778) INSERT INTO "SALABLEITEMS" VALUES(8,170211,'odor insoles',true,true,'none','feeterEater',117) INSERT INTO "SALABLEITEMS" VALUES(9,170211,'cushioned insoles',true,true,'none','feeterEater',117) INSERT INTO "SALABLEITEMS" VALUES(10,170211,'cushioned odor insoles',true,true,'none','feeterEater',117) INSERT INTO "SALABLEITEMS" VALUES(11,42187,'Polish',true,false,'Black','Shine Right',4242) INSERT INTO "SALABLEITEMS" VALUES(12,42188,'Polish',true,false,'Brown','Shine Right',4242) INSERT INTO "SALABLEITEMS" VALUES(13,42189,'Polish',true,false,'Tan','Shine Right',4242) INSERT INTO "SALABLEITEMS" VALUES(14,42190,'Polish',true,false,'Beige','Shine Right',4242) INSERT INTO "SALABLEITEMS" VALUES(15,42191,'Polish',true,false,'Red','Shine Right',4242) INSERT INTO "SALABLEITEMS" VALUES(16,42192,'Polish',true,false,'Blue','Shine Right',4242) INSERT INTO "SALABLEITEMS" VALUES(17,100,'Restitch',false,false,'none','Self',1) INSERT INTO "SALABLEITEMS" VALUES(18,101,'Glue',false,false,'none','Self',1) INSERT INTO "SALABLEITEMS" VALUES(19,102,'Shine',false,false,'none','Self',1) INSERT INTO "CALENDAR" VALUES(0,'2002-12-29','Sunday','Sun',0,29,'December','Dec',12,2002,NULL,false) INSERT INTO "CALENDAR" VALUES(1,'2003-01-05','Sunday','Sun',0,5,'January','Jan',1,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(2,'2003-01-12','Sunday','Sun',0,12,'January','Jan',1,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(3,'2003-01-19','Sunday','Sun',0,19,'January','Jan',1,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(4,'2003-01-26','Sunday','Sun',0,26,'January','Jan',1,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(5,'2003-02-02','Sunday','Sun',0,2,'February','Feb',2,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(6,'2003-02-09','Sunday','Sun',0,9,'February','Feb',2,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(7,'2003-02-16','Sunday','Sun',0,16,'February','Feb',2,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(8,'2003-02-23','Sunday','Sun',0,23,'February','Feb',2,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(9,'2003-03-02','Sunday','Sun',0,2,'March','Mar',3,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(10,'2003-03-09','Sunday','Sun',0,9,'March','Mar',3,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(11,'2003-03-16','Sunday','Sun',0,16,'March','Mar',3,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(12,'2003-03-23','Sunday','Sun',0,23,'March','Mar',3,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(13,'2003-03-30','Sunday','Sun',0,30,'March','Mar',3,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(14,'2003-04-06','Sunday','Sun',0,6,'April','Apr',4,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(15,'2003-04-13','Sunday','Sun',0,13,'April','Apr',4,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(16,'2003-04-20','Sunday','Sun',0,20,'April','Apr',4,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(17,'2003-04-27','Sunday','Sun',0,27,'April','Apr',4,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(18,'2003-05-04','Sunday','Sun',0,4,'May','May',5,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(19,'2003-05-11','Sunday','Sun',0,11,'May','May',5,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(20,'2003-05-18','Sunday','Sun',0,18,'May','May',5,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(21,'2003-05-25','Sunday','Sun',0,25,'May','May',5,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(22,'2003-06-01','Sunday','Sun',0,1,'June','Jun',6,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(46,'2002-12-30','Monday','Mon',1,30,'December','Dec',12,2002,NULL,false) INSERT INTO "CALENDAR" VALUES(47,'2003-01-06','Monday','Mon',1,6,'January','Jan',1,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(48,'2003-01-13','Monday','Mon',1,13,'January','Jan',1,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(49,'2003-01-20','Monday','Mon',1,20,'January','Jan',1,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(50,'2003-01-27','Monday','Mon',1,27,'January','Jan',1,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(51,'2003-02-03','Monday','Mon',1,3,'February','Feb',2,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(52,'2003-02-10','Monday','Mon',1,10,'February','Feb',2,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(53,'2003-02-17','Monday','Mon',1,17,'February','Feb',2,2003,false,false) INSERT INTO "CALENDAR" VALUES(54,'2003-02-24','Monday','Mon',1,24,'February','Feb',2,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(55,'2003-03-03','Monday','Mon',1,3,'March','Mar',3,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(56,'2003-03-10','Monday','Mon',1,10,'March','Mar',3,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(57,'2003-03-17','Monday','Mon',1,17,'March','Mar',3,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(58,'2003-03-24','Monday','Mon',1,24,'March','Mar',3,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(59,'2003-03-31','Monday','Mon',1,31,'March','Mar',3,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(60,'2003-04-07','Monday','Mon',1,7,'April','Apr',4,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(61,'2003-04-14','Monday','Mon',1,14,'April','Apr',4,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(62,'2003-04-21','Monday','Mon',1,21,'April','Apr',4,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(63,'2003-04-28','Monday','Mon',1,28,'April','Apr',4,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(64,'2003-05-05','Monday','Mon',1,5,'May','May',5,2003,false,false) INSERT INTO "CALENDAR" VALUES(65,'2003-05-12','Monday','Mon',1,12,'May','May',5,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(66,'2003-05-19','Monday','Mon',1,19,'May','May',5,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(67,'2003-05-26','Monday','Mon',1,26,'May','May',5,2003,false,false) INSERT INTO "CALENDAR" VALUES(68,'2003-06-02','Monday','Mon',1,2,'June','Jun',6,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(69,'2002-12-31','Tuesday','Tue',2,31,'December','Dec',12,2002,false,false) INSERT INTO "CALENDAR" VALUES(70,'2003-01-07','Tuesday','Tue',2,7,'January','Jan',1,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(71,'2003-01-14','Tuesday','Tue',2,14,'January','Jan',1,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(72,'2003-01-21','Tuesday','Tue',2,21,'January','Jan',1,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(73,'2003-01-28','Tuesday','Tue',2,28,'January','Jan',1,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(74,'2003-02-04','Tuesday','Tue',2,4,'February','Feb',2,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(75,'2003-02-11','Tuesday','Tue',2,11,'February','Feb',2,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(76,'2003-02-18','Tuesday','Tue',2,18,'February','Feb',2,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(77,'2003-02-25','Tuesday','Tue',2,25,'February','Feb',2,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(78,'2003-03-04','Tuesday','Tue',2,4,'March','Mar',3,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(79,'2003-03-11','Tuesday','Tue',2,11,'March','Mar',3,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(80,'2003-03-18','Tuesday','Tue',2,18,'March','Mar',3,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(81,'2003-03-25','Tuesday','Tue',2,25,'March','Mar',3,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(82,'2003-04-01','Tuesday','Tue',2,1,'April','Apr',4,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(83,'2003-04-08','Tuesday','Tue',2,8,'April','Apr',4,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(84,'2003-04-15','Tuesday','Tue',2,15,'April','Apr',4,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(85,'2003-04-22','Tuesday','Tue',2,22,'April','Apr',4,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(86,'2003-04-29','Tuesday','Tue',2,29,'April','Apr',4,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(87,'2003-05-06','Tuesday','Tue',2,6,'May','May',5,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(88,'2003-05-13','Tuesday','Tue',2,13,'May','May',5,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(89,'2003-05-20','Tuesday','Tue',2,20,'May','May',5,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(90,'2003-05-27','Tuesday','Tue',2,27,'May','May',5,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(91,'2003-06-03','Tuesday','Tue',2,3,'June','Jun',6,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(92,'2003-01-01','Wednesday','Wed',3,1,'January','Jan',1,2003,false,false) INSERT INTO "CALENDAR" VALUES(93,'2003-01-08','Wednesday','Wed',3,8,'January','Jan',1,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(94,'2003-01-15','Wednesday','Wed',3,15,'January','Jan',1,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(95,'2003-01-22','Wednesday','Wed',3,22,'January','Jan',1,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(96,'2003-01-29','Wednesday','Wed',3,29,'January','Jan',1,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(97,'2003-02-05','Wednesday','Wed',3,5,'February','Feb',2,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(98,'2003-02-12','Wednesday','Wed',3,12,'February','Feb',2,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(99,'2003-02-19','Wednesday','Wed',3,19,'February','Feb',2,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(100,'2003-02-26','Wednesday','Wed',3,26,'February','Feb',2,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(101,'2003-03-05','Wednesday','Wed',3,5,'March','Mar',3,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(102,'2003-03-12','Wednesday','Wed',3,12,'March','Mar',3,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(103,'2003-03-19','Wednesday','Wed',3,19,'March','Mar',3,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(104,'2003-03-26','Wednesday','Wed',3,26,'March','Mar',3,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(105,'2003-04-02','Wednesday','Wed',3,2,'April','Apr',4,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(106,'2003-04-09','Wednesday','Wed',3,9,'April','Apr',4,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(107,'2003-04-16','Wednesday','Wed',3,16,'April','Apr',4,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(108,'2003-04-23','Wednesday','Wed',3,23,'April','Apr',4,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(109,'2003-04-30','Wednesday','Wed',3,30,'April','Apr',4,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(110,'2003-05-07','Wednesday','Wed',3,7,'May','May',5,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(111,'2003-05-14','Wednesday','Wed',3,14,'May','May',5,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(112,'2003-05-21','Wednesday','Wed',3,21,'May','May',5,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(113,'2003-05-28','Wednesday','Wed',3,28,'May','May',5,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(114,'2003-06-04','Wednesday','Wed',3,4,'June','Jun',6,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(115,'2003-01-02','Thursday','Thu',4,2,'January','Jan',1,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(116,'2003-01-09','Thursday','Thu',4,9,'January','Jan',1,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(117,'2003-01-16','Thursday','Thu',4,16,'January','Jan',1,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(118,'2003-01-23','Thursday','Thu',4,23,'January','Jan',1,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(119,'2003-01-30','Thursday','Thu',4,30,'January','Jan',1,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(120,'2003-02-06','Thursday','Thu',4,6,'February','Feb',2,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(121,'2003-02-13','Thursday','Thu',4,13,'February','Feb',2,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(122,'2003-02-20','Thursday','Thu',4,20,'February','Feb',2,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(123,'2003-02-27','Thursday','Thu',4,27,'February','Feb',2,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(124,'2003-03-06','Thursday','Thu',4,6,'March','Mar',3,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(125,'2003-03-13','Thursday','Thu',4,13,'March','Mar',3,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(126,'2003-03-20','Thursday','Thu',4,20,'March','Mar',3,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(127,'2003-03-27','Thursday','Thu',4,27,'March','Mar',3,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(128,'2003-04-03','Thursday','Thu',4,3,'April','Apr',4,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(129,'2003-04-10','Thursday','Thu',4,10,'April','Apr',4,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(130,'2003-04-17','Thursday','Thu',4,17,'April','Apr',4,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(131,'2003-04-24','Thursday','Thu',4,24,'April','Apr',4,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(132,'2003-05-01','Thursday','Thu',4,1,'May','May',5,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(133,'2003-05-08','Thursday','Thu',4,8,'May','May',5,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(134,'2003-05-15','Thursday','Thu',4,15,'May','May',5,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(135,'2003-05-22','Thursday','Thu',4,22,'May','May',5,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(136,'2003-05-29','Thursday','Thu',4,29,'May','May',5,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(137,'2003-06-05','Thursday','Thu',4,5,'June','Jun',6,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(138,'2003-01-03','Friday','Fri',5,3,'January','Jan',1,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(139,'2003-01-10','Friday','Fri',5,10,'January','Jan',1,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(140,'2003-01-17','Friday','Fri',5,17,'January','Jan',1,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(141,'2003-01-24','Friday','Fri',5,24,'January','Jan',1,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(142,'2003-01-31','Friday','Fri',5,31,'January','Jan',1,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(143,'2003-02-07','Friday','Fri',5,7,'February','Feb',2,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(144,'2003-02-14','Friday','Fri',5,14,'February','Feb',2,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(145,'2003-02-21','Friday','Fri',5,21,'February','Feb',2,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(146,'2003-02-28','Friday','Fri',5,28,'February','Feb',2,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(147,'2003-03-07','Friday','Fri',5,7,'March','Mar',3,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(148,'2003-03-14','Friday','Fri',5,14,'March','Mar',3,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(149,'2003-03-21','Friday','Fri',5,21,'March','Mar',3,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(150,'2003-03-28','Friday','Fri',5,28,'March','Mar',3,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(151,'2003-04-04','Friday','Fri',5,4,'April','Apr',4,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(152,'2003-04-11','Friday','Fri',5,11,'April','Apr',4,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(153,'2003-04-18','Friday','Fri',5,18,'April','Apr',4,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(154,'2003-04-25','Friday','Fri',5,25,'April','Apr',4,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(155,'2003-05-02','Friday','Fri',5,2,'May','May',5,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(156,'2003-05-09','Friday','Fri',5,9,'May','May',5,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(157,'2003-05-16','Friday','Fri',5,16,'May','May',5,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(158,'2003-05-23','Friday','Fri',5,23,'May','May',5,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(159,'2003-05-30','Friday','Fri',5,30,'May','May',5,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(160,'2003-06-06','Friday','Fri',5,6,'June','Jun',6,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(161,'2003-01-04','Saturday','Sat',6,4,'January','Jan',1,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(162,'2003-01-11','Saturday','Sat',6,11,'January','Jan',1,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(163,'2003-01-18','Saturday','Sat',6,18,'January','Jan',1,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(164,'2003-01-25','Saturday','Sat',6,25,'January','Jan',1,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(165,'2003-02-01','Saturday','Sat',6,1,'February','Feb',2,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(166,'2003-02-08','Saturday','Sat',6,8,'February','Feb',2,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(167,'2003-02-15','Saturday','Sat',6,15,'February','Feb',2,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(168,'2003-02-22','Saturday','Sat',6,22,'February','Feb',2,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(169,'2003-03-01','Saturday','Sat',6,1,'March','Mar',3,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(170,'2003-03-08','Saturday','Sat',6,8,'March','Mar',3,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(171,'2003-03-15','Saturday','Sat',6,15,'March','Mar',3,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(172,'2003-03-22','Saturday','Sat',6,22,'March','Mar',3,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(173,'2003-03-29','Saturday','Sat',6,29,'March','Mar',3,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(174,'2003-04-05','Saturday','Sat',6,5,'April','Apr',4,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(175,'2003-04-12','Saturday','Sat',6,12,'April','Apr',4,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(176,'2003-04-19','Saturday','Sat',6,19,'April','Apr',4,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(177,'2003-04-26','Saturday','Sat',6,26,'April','Apr',4,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(178,'2003-05-03','Saturday','Sat',6,3,'May','May',5,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(179,'2003-05-10','Saturday','Sat',6,10,'May','May',5,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(180,'2003-05-17','Saturday','Sat',6,17,'May','May',5,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(181,'2003-05-24','Saturday','Sat',6,24,'May','May',5,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(182,'2003-05-31','Saturday','Sat',6,31,'May','May',5,2003,NULL,false) INSERT INTO "CALENDAR" VALUES(183,'2003-06-07','Saturday','Sat',6,7,'June','Jun',6,2003,NULL,false) INSERT INTO "SALES" VALUES(1,3,72,2.25E0,false) INSERT INTO "SALES" VALUES(1,2,72,2.25E0,false) INSERT INTO "SALES" VALUES(1,2,72,2.25E0,false) INSERT INTO "SALES" VALUES(4,7,101,2.5E0,false) INSERT INTO "SALES" VALUES(4,7,100,2.5E0,false) INSERT INTO "SALES" VALUES(3,5,47,2.5E0,false) INSERT INTO "SALES" VALUES(3,6,47,2.5E0,false) INSERT INTO "SALES" VALUES(3,7,47,2.5E0,false) INSERT INTO "SALES" VALUES(3,6,116,2.5E0,false) INSERT INTO "SALES" VALUES(3,10,116,15.0E0,false) INSERT INTO "SALES" VALUES(7,11,75,17.5E0,false) INSERT INTO "SALES" VALUES(7,20,75,10.0E0,false) INSERT INTO "SALES" VALUES(2,15,105,7.25E0,false) INSERT INTO "SALES" VALUES(2,10,105,15.0E0,false) INSERT INTO "SALES" VALUES(2,13,105,7.25E0,false) INSERT INTO "SALES" VALUES(2,18,105,8.0E0,false) --- NEW FILE: nss.properties --- #HSQL database #Thu Aug 05 13:49:20 PDT 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 |
