portals-jetspeed-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From jf...@apache.org
Subject cvs commit: jakarta-jetspeed-2/cornerstone-demo/hsqldb/data insert.sql test.script test.properties drop.sql select.sql create.sql query.bat
Date Thu, 18 Mar 2004 16:48:40 GMT
jford       2004/03/18 08:48:40

  Modified:    cornerstone-demo/hsqldb/data insert.sql test.script
                        test.properties drop.sql select.sql create.sql
                        query.bat
  Log:
  Added Apache License 2.0
  
  Revision  Changes    Path
  1.2       +15 -0     jakarta-jetspeed-2/cornerstone-demo/hsqldb/data/insert.sql
  
  Index: insert.sql
  ===================================================================
  RCS file: /home/cvs/jakarta-jetspeed-2/cornerstone-demo/hsqldb/data/insert.sql,v
  retrieving revision 1.1
  retrieving revision 1.2
  diff -u -r1.1 -r1.2
  --- insert.sql	2 Dec 2003 17:46:51 -0000	1.1
  +++ insert.sql	18 Mar 2004 16:48:40 -0000	1.2
  @@ -1,3 +1,18 @@
  +-----------------------------------------------------------------------------
  +-- Copyright 2004 The Apache Software Foundation
  +-- 
  +-- Licensed under the Apache License, Version 2.0 (the "License");
  +-- you may not use this file except in compliance with the License.
  +-- You may obtain a copy of the License at
  +-- 
  +-- http://www.apache.org/licenses/LICENSE-2.0
  +-- 
  +-- Unless required by applicable law or agreed to in writing, software
  +-- distributed under the License is distributed on an "AS IS" BASIS,
  +-- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
  +-- See the License for the specific language governing permissions and
  +-- limitations under the License.
  +-----------------------------------------------------------------------------
   insert into test_user values (101, 'dilbert', 'Dilbert', 'Funny')
   insert into test_user values (102, 'outm', 'Out', 'of Mind')
   insert into test_user values (201, 'pointy', 'Pointy', 'Hair')
  
  
  
  1.2       +1 -1      jakarta-jetspeed-2/cornerstone-demo/hsqldb/data/test.script
  
  Index: test.script
  ===================================================================
  RCS file: /home/cvs/jakarta-jetspeed-2/cornerstone-demo/hsqldb/data/test.script,v
  retrieving revision 1.1
  retrieving revision 1.2
  diff -u -r1.1 -r1.2
  --- test.script	2 Dec 2003 17:46:51 -0000	1.1
  +++ test.script	18 Mar 2004 16:48:40 -0000	1.2
  @@ -1,8 +1,8 @@
   CREATE TABLE TEST_USER(ID INTEGER NOT NULL IDENTITY PRIMARY KEY,LOGIN_NAME VARCHAR,FIRST_NAME
VARCHAR,LAST_NAME VARCHAR)
   CREATE TABLE TEST_GROUP(ID INTEGER NOT NULL IDENTITY PRIMARY KEY,NAME VARCHAR)
   CREATE TABLE TEST_USER_GROUP(ID INTEGER NOT NULL IDENTITY PRIMARY KEY,USER_ID INTEGER,GROUP_ID
INTEGER,CONSTRAINT SYS_FK_1 FOREIGN KEY(USER_ID) REFERENCES TEST_USER(ID),CONSTRAINT SYS_FK_2
FOREIGN KEY(GROUP_ID) REFERENCES TEST_GROUP(ID))
  -GRANT ALL ON CLASS "java.lang.Math" TO PUBLIC
   GRANT ALL ON CLASS "org.hsqldb.Library" TO PUBLIC
  +GRANT ALL ON CLASS "java.lang.Math" TO PUBLIC
   CREATE USER SA PASSWORD "" ADMIN
   CREATE ALIAS DAYNAME FOR "org.hsqldb.Library.dayname"
   CREATE ALIAS SPACE FOR "org.hsqldb.Library.space"
  
  
  
  1.2       +15 -1     jakarta-jetspeed-2/cornerstone-demo/hsqldb/data/test.properties
  
  Index: test.properties
  ===================================================================
  RCS file: /home/cvs/jakarta-jetspeed-2/cornerstone-demo/hsqldb/data/test.properties,v
  retrieving revision 1.1
  retrieving revision 1.2
  diff -u -r1.1 -r1.2
  --- test.properties	2 Dec 2003 17:46:51 -0000	1.1
  +++ test.properties	18 Mar 2004 16:48:40 -0000	1.2
  @@ -1,5 +1,19 @@
  +# Copyright 2004 The Apache Software Foundation
  +#
  +# Licensed under the Apache License, Version 2.0 (the "License");
  +# you may not use this file except in compliance with the License.
  +# You may obtain a copy of the License at
  +# 
  +#     http://www.apache.org/licenses/LICENSE-2.0
  +# 
  +# Unless required by applicable law or agreed to in writing, software
  +# distributed under the License is distributed on an "AS IS" BASIS,
  +# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
  +# See the License for the specific language governing permissions and
  +# limitations under the License.
  +
   #HSQL database
  -#Wed Nov 26 22:25:19 PST 2003
  +#Thu Feb 12 12:34:26 CST 2004
   sql.strict_fk=true
   readonly=false
   sql.strong_fk=true
  
  
  
  1.2       +15 -0     jakarta-jetspeed-2/cornerstone-demo/hsqldb/data/drop.sql
  
  Index: drop.sql
  ===================================================================
  RCS file: /home/cvs/jakarta-jetspeed-2/cornerstone-demo/hsqldb/data/drop.sql,v
  retrieving revision 1.1
  retrieving revision 1.2
  diff -u -r1.1 -r1.2
  --- drop.sql	2 Dec 2003 17:46:51 -0000	1.1
  +++ drop.sql	18 Mar 2004 16:48:40 -0000	1.2
  @@ -1,3 +1,18 @@
  +-----------------------------------------------------------------------------
  +-- Copyright 2004 The Apache Software Foundation
  +-- 
  +-- Licensed under the Apache License, Version 2.0 (the "License");
  +-- you may not use this file except in compliance with the License.
  +-- You may obtain a copy of the License at
  +-- 
  +-- http://www.apache.org/licenses/LICENSE-2.0
  +-- 
  +-- Unless required by applicable law or agreed to in writing, software
  +-- distributed under the License is distributed on an "AS IS" BASIS,
  +-- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
  +-- See the License for the specific language governing permissions and
  +-- limitations under the License.
  +-----------------------------------------------------------------------------
   drop table test_user;
   drop table test_group;
   drop table test_user_group;
  
  
  
  1.2       +16 -0     jakarta-jetspeed-2/cornerstone-demo/hsqldb/data/select.sql
  
  Index: select.sql
  ===================================================================
  RCS file: /home/cvs/jakarta-jetspeed-2/cornerstone-demo/hsqldb/data/select.sql,v
  retrieving revision 1.1
  retrieving revision 1.2
  diff -u -r1.1 -r1.2
  --- select.sql	2 Dec 2003 17:46:51 -0000	1.1
  +++ select.sql	18 Mar 2004 16:48:40 -0000	1.2
  @@ -1,3 +1,19 @@
  +-----------------------------------------------------------------------------
  +-- Copyright 2004 The Apache Software Foundation
  +-- 
  +-- Licensed under the Apache License, Version 2.0 (the "License");
  +-- you may not use this file except in compliance with the License.
  +-- You may obtain a copy of the License at
  +-- 
  +-- http://www.apache.org/licenses/LICENSE-2.0
  +-- 
  +-- Unless required by applicable law or agreed to in writing, software
  +-- distributed under the License is distributed on an "AS IS" BASIS,
  +-- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
  +-- See the License for the specific language governing permissions and
  +-- limitations under the License.
  +-----------------------------------------------------------------------------
  +
   select * from test_user
   go
   select * from test_group
  
  
  
  1.2       +15 -0     jakarta-jetspeed-2/cornerstone-demo/hsqldb/data/create.sql
  
  Index: create.sql
  ===================================================================
  RCS file: /home/cvs/jakarta-jetspeed-2/cornerstone-demo/hsqldb/data/create.sql,v
  retrieving revision 1.1
  retrieving revision 1.2
  diff -u -r1.1 -r1.2
  --- create.sql	2 Dec 2003 17:46:51 -0000	1.1
  +++ create.sql	18 Mar 2004 16:48:40 -0000	1.2
  @@ -1,3 +1,18 @@
  +-----------------------------------------------------------------------------
  +-- Copyright 2004 The Apache Software Foundation
  +-- 
  +-- Licensed under the Apache License, Version 2.0 (the "License");
  +-- you may not use this file except in compliance with the License.
  +-- You may obtain a copy of the License at
  +-- 
  +-- http://www.apache.org/licenses/LICENSE-2.0
  +-- 
  +-- Unless required by applicable law or agreed to in writing, software
  +-- distributed under the License is distributed on an "AS IS" BASIS,
  +-- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
  +-- See the License for the specific language governing permissions and
  +-- limitations under the License.
  +-----------------------------------------------------------------------------
   create table test_user
   (
   	id int identity,
  
  
  
  1.2       +14 -0     jakarta-jetspeed-2/cornerstone-demo/hsqldb/data/query.bat
  
  Index: query.bat
  ===================================================================
  RCS file: /home/cvs/jakarta-jetspeed-2/cornerstone-demo/hsqldb/data/query.bat,v
  retrieving revision 1.1
  retrieving revision 1.2
  diff -u -r1.1 -r1.2
  --- query.bat	2 Dec 2003 17:46:51 -0000	1.1
  +++ query.bat	18 Mar 2004 16:48:40 -0000	1.2
  @@ -1 +1,15 @@
  +REM Copyright 2004 The Apache Software Foundation
  +REM
  +REM Licensed under the Apache License, Version 2.0 (the "License");
  +REM you may not use this file except in compliance with the License.
  +REM You may obtain a copy of the License at
  +REM 
  +REM     http://www.apache.org/licenses/LICENSE-2.0
  +REM 
  +REM Unless required by applicable law or agreed to in writing, software
  +REM distributed under the License is distributed on an "AS IS" BASIS,
  +REM WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
  +REM See the License for the specific language governing permissions and
  +REM limitations under the License.
  +
   ..\bin\runUtil.bat ScriptTool -script %1
  
  
  

---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-dev-help@jakarta.apache.org


Mime
View raw message