/* ora_tpcb_cre.sql */
/* v.1.0.0 */

/* TPC-B Benchmark schema creation */
/* NB Scale=1 --> Tellers=10, Accounts=100000 */
/* Use TPC username to create the schema */

/* meo@bogliolo.name */

CREATE TABLE branches (Bid INTEGER NOT NULL, Bbalance FLOAT NOT NULL, filler   char(88) NULL) ;
CREATE TABLE tellers (Tid INTEGER NOT NULL, Bid INTEGER NOT NULL, Tbalance FLOAT NOT NULL, filler   CHAR(84) NULL) ;
CREATE TABLE accounts (Aid INTEGER NOT NULL, Bid INTEGER NOT NULL, Abalance FLOAT NOT NULL, filler   CHAR(84) NULL) ;
CREATE TABLE history (Tid INTEGER NOT NULL, Bid INTEGER NOT NULL, Aid INTEGER NOT NULL, delta   FLOAT NOT NULL, Xtime	DATE NOT NULL, filler  CHAR(22) NULL) ;