Sorry, about that. It is attached
On Wednesday, December 25, 2013 2:01:36 AM UTC-5, Noel Grandin wrote:
>
> On Tue, Dec 24, 2013 at 7:24 PM, Ilya Belopolsky
> <[email protected] <javascript:>> wrote:
> > I have attached a sql script to reproduce the schema, tables, and data
>
> There seems to be an attachment missing?
>
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/groups/opt_out.
drop schema test_schema;
create schema test_schema;
set schema test_schema;
CREATE TABLE employees
( employee_id INT(6),
first_name VARCHAR(20),
last_name VARCHAR(25) NOT NULL
) ;
CREATE TABLE job_history
( employee_id INT(6) NOT NULL,
start_date DATE NOT NULL,
end_date DATE NOT NULL,
job_id VARCHAR(10) NOT NULL
) ;
INSERT INTO employees VALUES ( 101 , 'Steven', 'King' );
INSERT INTO employees VALUES ( 102, 'Neena', 'Kochhar' );
INSERT INTO employees VALUES ( 108, 'Nancy', 'Greenberg' );
INSERT INTO employees VALUES ( 109, 'Daniel', 'Faviet' );
INSERT INTO employees VALUES ( 110, 'John', 'Chen' );
INSERT INTO job_history VALUES ( 101, DATE '1993-01-13', DATE '1998-07-24', 'IT_PROG' );
INSERT INTO job_history VALUES ( 102, DATE '1989-09-21', DATE '1993-10-27', 'AC_ACCOUNT' );
INSERT INTO job_history VALUES ( 103, DATE '1993-10-28', DATE '1997-03-15', 'AC_MGR' );
INSERT INTO job_history VALUES ( 104, DATE '1996-02-17', DATE '1999-12-19', 'MK_REP' );
