portals-jetspeed-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From tay...@apache.org
Subject cvs commit: jakarta-jetspeed/webapp/WEB-INF/db jetspeed.properties jetspeed.script
Date Thu, 05 Dec 2002 19:59:43 GMT
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:jetspeed-dev-unsubscribe@jakarta.apache.org>
For additional commands, e-mail: <mailto:jetspeed-dev-help@jakarta.apache.org>


Mime
View raw message