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
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
|
CREATE DOMAIN D_BOOLEAN AS SMALLINT CHECK (VALUE IN (0, 1));
CREATE TABLE accounts (
id BIGINT NOT NULL,
firm_id BIGINT,
credit_limit INTEGER,
PRIMARY KEY (id)
);
CREATE GENERATOR accounts_seq;
SET GENERATOR accounts_seq TO 10000;
CREATE TABLE companies (
id BIGINT NOT NULL,
"TYPE" VARCHAR(50),
ruby_type VARCHAR(50),
firm_id BIGINT,
name VARCHAR(50),
client_of INTEGER,
rating INTEGER DEFAULT 1,
PRIMARY KEY (id)
);
CREATE GENERATOR companies_nonstd_seq;
SET GENERATOR companies_nonstd_seq TO 10000;
CREATE TABLE topics (
id BIGINT NOT NULL,
title VARCHAR(255),
author_name VARCHAR(255),
author_email_address VARCHAR(255),
written_on TIMESTAMP,
bonus_time TIME,
last_read DATE,
content VARCHAR(4000),
approved D_BOOLEAN DEFAULT 1,
replies_count INTEGER DEFAULT 0,
parent_id BIGINT,
"TYPE" VARCHAR(50),
PRIMARY KEY (id)
);
CREATE GENERATOR topics_seq;
SET GENERATOR topics_seq TO 10000;
CREATE TABLE developers (
id BIGINT NOT NULL,
name VARCHAR(100),
salary INTEGER DEFAULT 70000,
created_at TIMESTAMP,
updated_at TIMESTAMP,
PRIMARY KEY (id)
);
CREATE GENERATOR developers_seq;
SET GENERATOR developers_seq TO 10000;
CREATE TABLE projects (
id BIGINT NOT NULL,
name VARCHAR(100),
"TYPE" VARCHAR(255),
PRIMARY KEY (id)
);
CREATE GENERATOR projects_seq;
SET GENERATOR projects_seq TO 10000;
CREATE TABLE developers_projects (
developer_id BIGINT NOT NULL,
project_id BIGINT NOT NULL,
joined_on DATE,
access_level SMALLINT DEFAULT 1
);
CREATE TABLE orders (
id BIGINT NOT NULL,
name VARCHAR(100),
billing_customer_id BIGINT,
shipping_customer_id BIGINT,
PRIMARY KEY (id)
);
CREATE GENERATOR orders_seq;
SET GENERATOR orders_seq TO 10000;
CREATE TABLE customers (
id BIGINT NOT NULL,
name VARCHAR(100),
balance INTEGER DEFAULT 0,
address_street VARCHAR(100),
address_city VARCHAR(100),
address_country VARCHAR(100),
gps_location VARCHAR(100),
PRIMARY KEY (id)
);
CREATE GENERATOR customers_seq;
SET GENERATOR customers_seq TO 10000;
CREATE TABLE movies (
movieid BIGINT NOT NULL,
name varchar(100),
PRIMARY KEY (movieid)
);
CREATE GENERATOR movies_seq;
SET GENERATOR movies_seq TO 10000;
CREATE TABLE subscribers (
nick VARCHAR(100) NOT NULL,
name VARCHAR(100),
PRIMARY KEY (nick)
);
CREATE TABLE booleantests (
id BIGINT NOT NULL,
"VALUE" D_BOOLEAN,
PRIMARY KEY (id)
);
CREATE GENERATOR booleantests_seq;
SET GENERATOR booleantests_seq TO 10000;
CREATE TABLE auto_id_tests (
auto_id BIGINT NOT NULL,
"VALUE" INTEGER,
PRIMARY KEY (auto_id)
);
CREATE GENERATOR auto_id_tests_seq;
SET GENERATOR auto_id_tests_seq TO 10000;
CREATE TABLE entrants (
id BIGINT NOT NULL,
name VARCHAR(255) NOT NULL,
course_id INTEGER NOT NULL,
PRIMARY KEY (id)
);
CREATE GENERATOR entrants_seq;
SET GENERATOR entrants_seq TO 10000;
CREATE TABLE colnametests (
id BIGINT NOT NULL,
"REFERENCES" INTEGER NOT NULL,
PRIMARY KEY (id)
);
CREATE GENERATOR colnametests_seq;
SET GENERATOR colnametests_seq TO 10000;
CREATE TABLE mixins (
id BIGINT NOT NULL,
parent_id BIGINT,
pos INTEGER,
created_at TIMESTAMP,
updated_at TIMESTAMP,
lft INTEGER,
rgt INTEGER,
root_id BIGINT,
"TYPE" VARCHAR(40),
PRIMARY KEY (id)
);
CREATE GENERATOR mixins_seq;
SET GENERATOR mixins_seq TO 10000;
CREATE TABLE people (
id BIGINT NOT NULL,
first_name VARCHAR(40),
lock_version INTEGER DEFAULT 0 NOT NULL,
PRIMARY KEY (id)
);
CREATE GENERATOR people_seq;
SET GENERATOR people_seq TO 10000;
CREATE TABLE binaries (
id BIGINT NOT NULL,
data BLOB,
PRIMARY KEY (id)
);
CREATE GENERATOR binaries_seq;
SET GENERATOR binaries_seq TO 10000;
CREATE TABLE computers (
id BIGINT NOT NULL,
developer INTEGER NOT NULL,
"extendedWarranty" INTEGER NOT NULL,
PRIMARY KEY (id)
);
CREATE GENERATOR computers_seq;
SET GENERATOR computers_seq TO 10000;
CREATE TABLE posts (
id BIGINT NOT NULL,
author_id BIGINT,
title VARCHAR(255) NOT NULL,
"TYPE" VARCHAR(255) NOT NULL,
body VARCHAR(3000) NOT NULL,
PRIMARY KEY (id)
);
CREATE GENERATOR posts_seq;
SET GENERATOR posts_seq TO 10000;
CREATE TABLE comments (
id BIGINT NOT NULL,
post_id BIGINT NOT NULL,
"TYPE" VARCHAR(255) NOT NULL,
body VARCHAR(3000) NOT NULL,
PRIMARY KEY (id)
);
CREATE GENERATOR comments_seq;
SET GENERATOR comments_seq TO 10000;
CREATE TABLE authors (
id BIGINT NOT NULL,
name VARCHAR(255) NOT NULL,
PRIMARY KEY (id)
);
CREATE GENERATOR authors_seq;
SET GENERATOR authors_seq TO 10000;
CREATE TABLE tasks (
id BIGINT NOT NULL,
"STARTING" TIMESTAMP,
ending TIMESTAMP,
PRIMARY KEY (id)
);
CREATE GENERATOR tasks_seq;
SET GENERATOR tasks_seq TO 10000;
CREATE TABLE categories (
id BIGINT NOT NULL,
name VARCHAR(255) NOT NULL,
"TYPE" VARCHAR(255) NOT NULL,
PRIMARY KEY (id)
);
CREATE GENERATOR categories_seq;
SET GENERATOR categories_seq TO 10000;
CREATE TABLE categories_posts (
category_id BIGINT NOT NULL,
post_id BIGINT NOT NULL,
PRIMARY KEY (category_id, post_id)
);
CREATE TABLE fk_test_has_pk (
id BIGINT NOT NULL,
PRIMARY KEY (id)
);
CREATE TABLE fk_test_has_fk (
id BIGINT NOT NULL,
fk_id BIGINT NOT NULL,
PRIMARY KEY (id),
FOREIGN KEY (fk_id) REFERENCES fk_test_has_pk(id)
);
CREATE TABLE keyboards (
key_number BIGINT NOT NULL,
name VARCHAR(50),
PRIMARY KEY (key_number)
);
CREATE GENERATOR keyboards_seq;
SET GENERATOR keyboards_seq TO 10000;
CREATE TABLE defaults (
id BIGINT NOT NULL,
default_timestamp TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
CREATE GENERATOR defaults_seq;
SET GENERATOR defaults_seq TO 10000;
|
