cocoon-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Davanum Srinivas <d...@yahoo.com>
Subject Re: Preparing hsql jar
Date Wed, 19 Sep 2001 15:16:24 GMT
Berin,

HSQLDB does not support DEFAULT keyword in the SQL for CREATE TABLE or the ALTER Statement.
But
attached is a zip with 2 tables and the data.

-- dims

--- Berin Loritsch <bloritsch@apache.org> wrote:
> I have a working copy of the tutorial webapp I wrote,
> and before I commit the webapp, I want to make sure
> that it works with CVS stuff.  To that end, I need help
> setting up the HSQL database to support it.
> 
> I need it set up with the included schema.  Any takers?> #
> # Tutorial DB
> #
> 
> #
> # Table structure for table 'department'
> #
> CREATE TABLE department (
>   department_id number(12) DEFAULT '0' NOT NULL,
>   department_name varchar(64) DEFAULT '' NOT NULL,
>   PRIMARY KEY (department_id)
> );
> 
> #
> # Data for table 'department'
> #
> 
> INSERT INTO department VALUES (1,'Development');
> INSERT INTO department VALUES (2,'Management');
> INSERT INTO department VALUES (3,'Testors');
> 
> #
> # Table structure for table 'employee'
> #
> CREATE TABLE employee (
>   employee_id number(12) DEFAULT '0' NOT NULL,
>   department_id number(12) DEFAULT '0' NOT NULL,
>   employee_name varchar(64) DEFAULT '' NOT NULL,
>   PRIMARY KEY (employee_id)
> );
> 
> #
> # Foreign Keys
> #
> ALTER TABLE employee ADD (
>   CONSTRAINT fkdepartment FOREIGN KEY(DEPARTMENT_ID)
>   REFERENCES DEPARTMENT(DEPARTMENT_ID)
>   ON DELETE CASCADE
> );
> 
> #
> # Data for table 'employee'
> #
> 
> INSERT INTO employee VALUES (1,1,'Donald Ball');
> INSERT INTO employee VALUES (2,1,'Stefano Mazzocchi');
> INSERT INTO employee VALUES (3,2,'Pierpaolo Fumagalli');
> INSERT INTO employee VALUES (4,4,'Torsten Curdt');
> 
> > ---------------------------------------------------------------------
> To unsubscribe, e-mail: cocoon-dev-unsubscribe@xml.apache.org
> For additional commands, email: cocoon-dev-help@xml.apache.org


=====
Davanum Srinivas, JNI-FAQ Manager
http://www.jGuru.com/faq/JNI

__________________________________________________
Terrorist Attacks on U.S. - How can you help?
Donate cash, emergency relief information
http://dailynews.yahoo.com/fc/US/Emergency_Information/
Mime
View raw message