taylor 2002/12/05 11:59:43
Modified: webapp/WEB-INF/db jetspeed.properties jetspeed.script
Log:
added primary key to coffees table
Revision Changes Path
1.22 +1 -1 jakarta-jetspeed/webapp/WEB-INF/db/jetspeed.properties
Index: jetspeed.properties
===================================================================
RCS file: /home/cvs/jakarta-jetspeed/webapp/WEB-INF/db/jetspeed.properties,v
retrieving revision 1.21
retrieving revision 1.22
diff -u -r1.21 -r1.22
--- jetspeed.properties 24 Oct 2002 17:17:40 -0000 1.21
+++ jetspeed.properties 5 Dec 2002 19:59:43 -0000 1.22
@@ -1,5 +1,5 @@
#HSQL database
-#Thu Oct 24 10:08:32 PDT 2002
+#Thu Dec 05 11:38:22 PST 2002
sql.strict_fk=false
readonly=false
sql.strong_fk=true
1.24 +13 -13 jakarta-jetspeed/webapp/WEB-INF/db/jetspeed.script
Index: jetspeed.script
===================================================================
RCS file: /home/cvs/jakarta-jetspeed/webapp/WEB-INF/db/jetspeed.script,v
retrieving revision 1.23
retrieving revision 1.24
diff -u -r1.23 -r1.24
--- jetspeed.script 24 Oct 2002 17:17:40 -0000 1.23
+++ jetspeed.script 5 Dec 2002 19:59:43 -0000 1.24
@@ -16,11 +16,11 @@
CREATE INDEX JETSPEED_ROLE_PROFILE_INDEX ON
JETSPEED_ROLE_PROFILE(ROLE_NAME,MEDIA_TYPE,LANGUAGE,COUNTRY,PAGE)
CREATE TABLE JETSPEED_ANON_PROFILE(PSML_ID INTEGER NOT NULL IDENTITY PRIMARY
KEY,MEDIA_TYPE VARCHAR,LANGUAGE VARCHAR,COUNTRY VARCHAR,PAGE VARCHAR,PROFILE
BINARY,CONSTRAINT SYS_CT_13 UNIQUE(PSML_ID),CONSTRAINT SYS_CT_14
UNIQUE(MEDIA_TYPE,LANGUAGE,COUNTRY,PAGE))
CREATE INDEX JETSPEED_ANON_PROFILE_INDEX ON
JETSPEED_ANON_PROFILE(MEDIA_TYPE,LANGUAGE,COUNTRY,PAGE)
-CREATE TABLE COFFEES(COF_NAME VARCHAR,SUP_ID INTEGER,PRICE FLOAT,SALES
INTEGER,TOTAL INTEGER)
+CREATE TABLE COFFEES(COFFEE_ID INTEGER NOT NULL IDENTITY PRIMARY KEY,COFFEE_NAME
VARCHAR(50),SUPPLIER_ID INTEGER,PRICE FLOAT,SALES INTEGER,TOTAL INTEGER)
CREATE TABLE JETSPEED_ACL(ACL_ID INTEGER,SECURITY_ID INTEGER,RESOURCE
VARCHAR,RESOURCE_TYPE VARCHAR,ACTION VARCHAR,ALLOW_TYPE VARCHAR,PRINCIPAL
VARCHAR,CONSTRAINT SYS_CT_17 UNIQUE(ACL_ID))
CREATE INDEX JETSPEED_ACL_I_2 ON JETSPEED_ACL(SECURITY_ID)
-GRANT ALL ON CLASS "org.hsqldb.Library" TO PUBLIC
GRANT ALL ON CLASS "java.lang.Math" TO PUBLIC
+GRANT ALL ON CLASS "org.hsqldb.Library" TO PUBLIC
GRANT ALL ON CLASS "org.hsql.Library" TO PUBLIC
CREATE USER SA PASSWORD "" ADMIN
CREATE ALIAS DAYNAME FOR "org.hsqldb.Library.dayname"
@@ -142,14 +142,14 @@
INSERT INTO ID_TABLE VALUES(10,'JETSPEED_ROLE_PROFILE',120,10)
INSERT INTO ID_TABLE VALUES(11,'JETSPEED_ANON_PROFILE',120,10)
INSERT INTO ID_TABLE VALUES(12,'COFFEES',100,10)
-INSERT INTO COFFEES VALUES('ColombianGrade',5,7.99E0,1,2)
-INSERT INTO COFFEES VALUES('KonaGrade',6,7.99E0,1,2)
-INSERT INTO COFFEES VALUES('FrenchRoastGrade',7,7.99E0,1,2)
-INSERT INTO COFFEES VALUES('HazelNutGrade',8,7.99E0,1,2)
-INSERT INTO COFFEES VALUES('VanillaGrade',9,7.99E0,1,2)
-INSERT INTO COFFEES VALUES('JavaGrade',10,7.99E0,1,2)
-INSERT INTO COFFEES VALUES('IndonesianGrade',11,7.99E0,1,2)
-INSERT INTO COFFEES VALUES('OotyGrade',1,7.99E0,1,2)
-INSERT INTO COFFEES VALUES('KenyanGrade',2,7.99E0,1,2)
-INSERT INTO COFFEES VALUES('JoeGrade',3,7.99E0,1,2)
-INSERT INTO COFFEES VALUES('CantThinkOfAnymoreGrade',4,7.99E0,1,2)
+INSERT INTO COFFEES VALUES(1,'ColombianGrade',5,7.99E0,1,2)
+INSERT INTO COFFEES VALUES(2,'KonaGrade',6,7.99E0,1,2)
+INSERT INTO COFFEES VALUES(3,'FrenchRoastGrade',7,7.99E0,1,2)
+INSERT INTO COFFEES VALUES(4,'HazelNutGrade',8,7.99E0,1,2)
+INSERT INTO COFFEES VALUES(5,'VanillaGrade',9,7.99E0,1,2)
+INSERT INTO COFFEES VALUES(6,'JavaGrade',10,7.99E0,1,2)
+INSERT INTO COFFEES VALUES(7,'IndonesianGrade',11,7.99E0,1,2)
+INSERT INTO COFFEES VALUES(8,'OotyGrade',1,7.99E0,1,2)
+INSERT INTO COFFEES VALUES(9,'KenyanGrade',2,7.99E0,1,2)
+INSERT INTO COFFEES VALUES(10,'JoeGrade',3,7.99E0,1,2)
+INSERT INTO COFFEES VALUES(11,'CantThinkOfAnymoreGrade',4,7.99E0,1,2)
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
