VMware VCLOUD SDK FOR JAVA 1.0 - DEVELOPER S GUIDE Manuale Utente Scaricare il pdf (Pagina 57)

references supplier (suppid)

);

-- create index itemProd on item (productid);

create table inventory (

itemid varchar(10) not null,

qty int not null,

constraint pk_inventory primary key (itemid)

)

REPLICATE

;

CREATE TABLE sequence

(

name varchar(30) not null,

nextid int not null,

constraint pk_sequence primary key (name)

);

jpetstore-derby-dataload.sql

This section contains the data to place in the tables at startup, after the

tablespace has been setup:

INSERT INTO sequence VALUES('ordernum', 1000);

INSERT INTO sequence VALUES('linenum', 1000);

INSERT INTO signon VALUES('j2ee','j2ee');

INSERT INTO signon VALUES('ACID','ACID');

INSERT INTO account VALUES('j2ee','[email protected]','ABC', 'XYX', 'OK', '901 San

Antonio Road', 'MS UCUP02-206', 'Palo Alto', 'CA', '94303', 'USA', '555-555-5555');

INSERT INTO account VALUES('ACID','[email protected]','ABC', 'XYX', 'OK', '901 San

Antonio Road', 'MS UCUP02-206', 'Palo Alto', 'CA', '94303', 'USA', '555-555-5555');

INSERT INTO profile VALUES('j2ee','english','DOGS',1,1);

INSERT INTO profile VALUES('ACID','english','CATS',1,1);

INSERT INTO bannerdata VALUES ('FISH','<image src="../images/banner_fish.gif">');

INSERT INTO bannerdata VALUES ('CATS','<image src="../images/banner_cats.gif">');

INSERT INTO bannerdata VALUES ('DOGS','<image src="../images/banner_dogs.gif">');

1 2 ... 52 53 54 55 56 57 58 59 60 61 62 63 64 65

Nessun commento

VMware VCLOUD SDK FOR JAVA 1.0 - DEVELOPER S GUIDE Manuale Utente Pagina 57