1
2CREATE DATABASE numismatics;
3
4CREATE TABLE table1 (att_int INT(8) PRIMARY KEY,
5			att_char CHAR(2),
6			att_varchar VARCHAR(20),
7			att_bit BIT,
8			att_tinyint TINYINT,
9			att_smallint SMALLINT(2),
10			att_integer INTEGER(4),
11			att_bigint BIGINT,
12			att_real REAL,
13			att_double DOUBLE,
14			att_float FLOAT,
15			att_decimal DECIMAL,
16			att_numeric NUMERIC,
17			att_bin bin(10),
18			CONSTRAINT table8_fk FOREIGN KEY(att_integer)
19                           REFERENCES table8(att_integer));
20
21CREATE TABLE table2 (att_int INT(8) PRIMARY KEY);
22
23CREATE TABLE table3 (att_char CHAR(2) PRIMARY KEY);
24
25CREATE TABLE table4 (att_varchar VARCHAR(20) PRIMARY KEY);
26
27CREATE TABLE table5 (att_bit BIT PRIMARY KEY);
28
29CREATE TABLE table6 (att_tinyint TINYINT PRIMARY KEY);
30
31CREATE TABLE table7 (att_smallint SMALLINT(2) PRIMARY KEY);
32
33CREATE TABLE table8 (att_integer INTEGER(4) PRIMARY KEY);
34
35CREATE TABLE table9 (att_bigint BIGINT PRIMARY KEY);
36
37CREATE TABLE table10 (att_real REAL PRIMARY KEY);
38
39CREATE TABLE table11 (att_double DOUBLE PRIMARY KEY);
40
41CREATE TABLE table12 (att_float FLOAT PRIMARY KEY);
42
43CREATE TABLE table13 (att_decimal DECIMAL PRIMARY KEY);
44
45CREATE TABLE table14 (att_numeric NUMERIC PRIMARY KEY);
46
47CREATE TABLE table15 (att_binary bin(10) PRIMARY KEY);
48
49CREATE TABLE table16 (att_int INT(8) PRIMARY KEY,
50			att_char CHAR(2),
51			att_varchar VARCHAR(20),
52			att_bit BIT,
53			att_tinyint TINYINT,
54			att_smallint SMALLINT(2),
55			att_integer INTEGER(4),
56			att_bigint BIGINT,
57			att_real REAL,
58			att_double DOUBLE,
59			att_float FLOAT,
60			att_decimal DECIMAL,
61			att_numeric NUMERIC,
62			att_bin bin(10),
63			CONSTRAINT table17_fk FOREIGN KEY(att_int)
64                           REFERENCES table17(att_int));
65
66CREATE TABLE table17 (att_int INT(8) PRIMARY KEY);
67
68CREATE TABLE table18 (att_char CHAR(2) PRIMARY KEY);
69
70CREATE TABLE table19 (att_varchar VARCHAR(20) PRIMARY KEY);
71
72CREATE TABLE table20 (att_bit BIT PRIMARY KEY);
73
74CREATE TABLE table21 (att_tinyint TINYINT PRIMARY KEY);
75
76CREATE TABLE table22 (att_smallint SMALLINT(2) PRIMARY KEY);
77
78CREATE TABLE table23 (att_integer INTEGER(4) PRIMARY KEY);
79
80CREATE TABLE table24 (att_bigint BIGINT PRIMARY KEY);
81
82CREATE TABLE table25 (att_real REAL PRIMARY KEY);
83
84CREATE TABLE table26 (att_double DOUBLE PRIMARY KEY);
85
86CREATE TABLE table27 (att_float FLOAT PRIMARY KEY);
87
88CREATE TABLE table28 (att_decimal DECIMAL PRIMARY KEY);
89
90CREATE TABLE table29 (att_numeric NUMERIC PRIMARY KEY);
91
92CREATE TABLE table30 (att_binary bin(100) PRIMARY KEY);
93
94