Diff of /cocoon/branches/BRANCH_2_1_X/src/blocks/hsqldb/conf/schema.sql

Parent Directory | Revision Log | Patch

--- cocoon/branches/BRANCH_2_1_X/src/blocks/hsqldb/samples/WEB-INF/db/tutorial.sql	2005/05/02 17:11:59	165647
+++ cocoon/branches/BRANCH_2_1_X/src/blocks/hsqldb/conf/schema.sql	2005/05/03 18:22:14	167951
@@ -1,6 +1,4 @@
-#
-
-# Copyright 1999-2004 The Apache Software Foundation
+# Copyright 1999-2005 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.
@@ -14,7 +12,8 @@
 # See the License for the specific language governing permissions and
 # limitations under the License.
 
-# Tutorial DB
+#
+# Samples Database Schema
 #
 
 #
@@ -23,16 +22,16 @@
 CREATE TABLE department (
   id number(12) DEFAULT '0' NOT NULL,
   name varchar(64) DEFAULT '' NOT NULL,
+  description varchar(255) DEFAULT '' NULL,
   PRIMARY KEY (id)
 );
 
 #
 # Data for table 'department'
 #
-
-INSERT INTO department VALUES (1,'Development');
-INSERT INTO department VALUES (2,'Management');
-INSERT INTO department VALUES (3,'Testers');
+INSERT INTO department VALUES (1, 'Development', '<span>Department producing software packages, <i>on time</i>, and <i>bug free</i>.</span>');
+INSERT INTO department VALUES (2, 'Management', '<span>Department spending all the budget on <i>meetings</i> and <i>donuts</i>.</span>');
+INSERT INTO department VALUES (3, 'Testers', '<span>Department capable of finding issues in <i>bug free</i> software packages.</span>');
 
 #
 # Table structure for table 'employee'
@@ -41,6 +40,7 @@ CREATE TABLE employee (
   id number(12) DEFAULT '0' NOT NULL,
   department_id number(12) DEFAULT '0' NOT NULL,
   name varchar(64) DEFAULT '' NOT NULL,
+  description varchar(255) DEFAULT '' NULL,
   PRIMARY KEY (id)
 );
 
@@ -56,16 +56,15 @@ ALTER TABLE employee ADD (
 #
 # Data for table 'employee'
 #
-
-INSERT INTO EMPLOYEE VALUES(1,1,'Donald Ball')
-INSERT INTO EMPLOYEE VALUES(2,1,'Sylvain Wallez ')
-INSERT INTO EMPLOYEE VALUES(3,1,'Carsten Ziegeler ')
-INSERT INTO EMPLOYEE VALUES(4,1,'Torsten Curdt')
-INSERT INTO EMPLOYEE VALUES(5,1,'Marcus Crafter')
-INSERT INTO EMPLOYEE VALUES(6,1,'Ovidiu Predescu')
-INSERT INTO EMPLOYEE VALUES(7,1,'Christian Haul')
-INSERT INTO EMPLOYEE VALUES(8,2,'Stefano Mazzocchi')
-INSERT INTO EMPLOYEE VALUES(9,3,'Pierpaolo Fumagalli')
-INSERT INTO EMPLOYEE VALUES(10,3,'Davanum Srinivas')
-INSERT INTO EMPLOYEE VALUES(11,3, 'Carlos Chávez')
-INSERT INTO EMPLOYEE VALUES(12,3, 'Antonio Gallardo')
+INSERT INTO EMPLOYEE VALUES(1,  1, 'Donald Ball')
+INSERT INTO EMPLOYEE VALUES(2,  1, 'Sylvain Wallez ')
+INSERT INTO EMPLOYEE VALUES(3,  1, 'Carsten Ziegeler ')
+INSERT INTO EMPLOYEE VALUES(4,  1, 'Torsten Curdt')
+INSERT INTO EMPLOYEE VALUES(5,  1, 'Marcus Crafter')
+INSERT INTO EMPLOYEE VALUES(6,  1, 'Ovidiu Predescu')
+INSERT INTO EMPLOYEE VALUES(7,  1, 'Christian Haul')
+INSERT INTO EMPLOYEE VALUES(8,  2, 'Stefano Mazzocchi')
+INSERT INTO EMPLOYEE VALUES(9,  3, 'Pierpaolo Fumagalli')
+INSERT INTO EMPLOYEE VALUES(10, 3, 'Davanum Srinivas')
+INSERT INTO EMPLOYEE VALUES(11, 3, 'Carlos Chávez')
+INSERT INTO EMPLOYEE VALUES(12, 3, 'Antonio Gallardo')