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