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