VMware VCLOUD SDK FOR JAVA 1.0 - DEVELOPER S GUIDE Manual do Utilizador descarregar pdf (Página 53)

jpetstore-derby-schema.sql

This is the database setup in vFabric SQLFire before inventory data is

loaded. This needs to be run on each DB node before the application starts,

and after the database has started. The following script accomplishes this.

These statements initialize the structures and setup the partitioning.

We modify tables to use the gateway. To point the tables to the hub, you

have to add “HUB(ALL)” at the end of their table creation DDLs. This was

done to the line item and orders tables. The following is our example of the

lineitem table from jpetstore-derby-schema.sql:

-- identity column ordernum increment by 1 start 1000;

-- identity column linenum increment by 1 start 1000;

-- change datatype bool to smallint table: profile -- remove null declarations

DROP TABLE lineitem;

DROP TABLE orderstatus;

DROP TABLE orders;

DROP TABLE bannerdata;

DROP TABLE profile;

DROP TABLE signon;

DROP TABLE inventory;

DROP TABLE item;

DROP TABLE product;

DROP TABLE account;

DROP TABLE category;

DROP TABLE supplier;

DROP TABLE sequence;

create table supplier (

suppid int not null,

name varchar(80) ,

status varchar(2) not null,

addr1 varchar(80) ,

addr2 varchar(80) ,

city varchar(80) ,

state varchar(80) ,

zip varchar(5) ,

phone varchar(80) ,

constraint pk_supplier primary key (suppid)

)

REPLICATE

;

create table signon (

1 2 ... 48 49 50 51 52 53 54 55 56 57 58 ... 64 65

Sem comentários

VMware VCLOUD SDK FOR JAVA 1.0 - DEVELOPER S GUIDE Manual do Utilizador Página 53