CREATE TABLE EJB_ORDER_SEQ(SEQ_NAME VARCHAR(50) NOT NULL, SEQ_VALUE INTEGER,PRIMARY KEY(SEQ_NAME))

INSERT INTO EJB_ORDER_SEQ(SEQ_NAME, SEQ_VALUE) VALUES ('ORDER_SEQ', 10)
INSERT INTO EJB_ORDER_SEQ(SEQ_NAME, SEQ_VALUE) VALUES ('ITEM_SEQ', 10)
INSERT INTO EJB_ORDER_SEQ(SEQ_NAME, SEQ_VALUE) VALUES ('CUST_SEQ', 10)

INSERT INTO EJB_CUSTOMER (CUST_ID, CITY, NAME) VALUES (1, 'Ottawa', 'John Smith')
INSERT INTO EJB_CUSTOMER (CUST_ID, CITY, NAME) VALUES (2, 'Orleans', 'Jane Smith')
INSERT INTO EJB_CUSTOMER (CUST_ID, CITY, NAME) VALUES (3, 'Nepean', 'Karen McDonald')
INSERT INTO EJB_CUSTOMER (CUST_ID, CITY, NAME) VALUES (4, 'Manotick', 'Robert Sampson')

INSERT INTO EJB_ITEM (ITEM_ID, NAME, DESCRIPTION) VALUES (1, 'Item1', 'Item1 description')
INSERT INTO EJB_ITEM (ITEM_ID, NAME, DESCRIPTION) VALUES (2, 'Item2', 'Item2 description')
INSERT INTO EJB_ITEM (ITEM_ID, NAME, DESCRIPTION) VALUES (3, 'Item3', 'Item3 description')
INSERT INTO EJB_ITEM (ITEM_ID, NAME, DESCRIPTION) VALUES (4, 'Item3', 'Item4 description')

INSERT INTO EJB_ORDER (ORDER_ID, QUANTITY, SHIP_ADDR, CUST_ID, ITEM_ID) VALUES (1, 10, '100 Argyle Street', 1, 1)
INSERT INTO EJB_ORDER (ORDER_ID, QUANTITY, SHIP_ADDR, CUST_ID, ITEM_ID) VALUES (2, 20, '99 Fifth Street', 2, 2)
INSERT INTO EJB_ORDER (ORDER_ID, QUANTITY, SHIP_ADDR, CUST_ID, ITEM_ID) VALUES (3, 30, '240 Queen Street', 3, 3)
INSERT INTO EJB_ORDER (ORDER_ID, QUANTITY, SHIP_ADDR, CUST_ID, ITEM_ID) VALUES (4, 15, '123 Main Street', 4, 4)
