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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
