1CREATE DATABASE numismatics; /*+ MODE = TRANSACTIONAL */
2
3CREATE TABLE coin (cid INT(8) PRIMARY KEY,
4                       unit VARCHAR2(20),
5                       value NUMERIC(8,2),  /*+ MODE = TRANSACTIONAL */
6                       mintage_year INT(8),
7                       mint_id INT(8),
8                       CONSTRAINT mint_id_fk FOREIGN KEY(mint_id)
9                           REFERENCES mint(mid));
10
11CREATE INDEX unit_index ON coin(unit);
12
13CREATE TABLE mint (mid INT(8) PRIMARY KEY,
14       country VARCHAR2(20),
15       city VARCHAR2(20));   /*+ MODE = TRANSACTIONAL */
16
17CREATE INDEX mid_index ON mint(mid);
18
19CREATE TABLE random (rid VARCHAR2(20) PRIMARY KEY,
20       chunk bin(127));
21
22CREATE TABLE table1 (att_int INT(8) PRIMARY KEY,
23		 	att_char CHAR(20),
24			att_varchar VARCHAR(20),
25			att_bit BIT,
26			att_tinyint TINYINT,
27			att_smallint SMALLINT(2),
28			att_integer INTEGER(4),
29			att_bigint BIGINT,
30			att_real REAL,
31			att_double DOUBLE,
32			att_float FLOAT,
33			att_decimal DECIMAL,
34			att_numeric NUMERIC,
35			att_bin bin(5));
36
37CREATE TABLE table2(att_int INT(8) PRIMARY KEY);
38
39CREATE TABLE table3(att_char CHAR(20) PRIMARY KEY);
40
41CREATE TABLE table4(att_bin bin(10) PRIMARY KEY);
42
43CREATE TABLE table5(att_bin bin(10) PRIMARY KEY,
44			att_bit BIT);
45
46CREATE TABLE table6(att_bin bin(10),
47                        att_bit BIT PRIMARY KEY); /*+ MODE = TRANSACTIONAL */
48