1 CREATE DOMAIN D_BOOLEAN AS SMALLINT CHECK (VALUE IN (0, 1) OR VALUE IS NULL);
3 CREATE TABLE accounts (
9 CREATE GENERATOR accounts_seq;
10 SET GENERATOR accounts_seq TO 10000;
12 CREATE TABLE funny_jokes (
17 CREATE GENERATOR funny_jokes_seq;
18 SET GENERATOR funny_jokes_seq TO 10000;
20 CREATE TABLE companies (
23 ruby_type VARCHAR(50),
27 rating INTEGER DEFAULT 1,
30 CREATE GENERATOR companies_nonstd_seq;
31 SET GENERATOR companies_nonstd_seq TO 10000;
36 author_name VARCHAR(255),
37 author_email_address VARCHAR(255),
41 content VARCHAR(4000),
42 approved D_BOOLEAN DEFAULT 1,
43 replies_count INTEGER DEFAULT 0,
48 CREATE GENERATOR topics_seq;
49 SET GENERATOR topics_seq TO 10000;
51 CREATE TABLE developers (
54 salary INTEGER DEFAULT 70000,
59 CREATE GENERATOR developers_seq;
60 SET GENERATOR developers_seq TO 10000;
62 CREATE TABLE projects (
68 CREATE GENERATOR projects_seq;
69 SET GENERATOR projects_seq TO 10000;
71 CREATE TABLE developers_projects (
72 developer_id BIGINT NOT NULL,
73 project_id BIGINT NOT NULL,
75 access_level SMALLINT DEFAULT 1
81 billing_customer_id BIGINT,
82 shipping_customer_id BIGINT,
85 CREATE GENERATOR orders_seq;
86 SET GENERATOR orders_seq TO 10000;
88 CREATE TABLE customers (
91 balance INTEGER DEFAULT 0,
92 address_street VARCHAR(100),
93 address_city VARCHAR(100),
94 address_country VARCHAR(100),
95 gps_location VARCHAR(100),
98 CREATE GENERATOR customers_seq;
99 SET GENERATOR customers_seq TO 10000;
101 CREATE TABLE movies (
102 movieid BIGINT NOT NULL,
104 PRIMARY KEY (movieid)
106 CREATE GENERATOR movies_seq;
107 SET GENERATOR movies_seq TO 10000;
109 CREATE TABLE subscribers (
110 nick VARCHAR(100) NOT NULL,
115 CREATE TABLE booleantests (
120 CREATE GENERATOR booleantests_seq;
121 SET GENERATOR booleantests_seq TO 10000;
123 CREATE TABLE auto_id_tests (
124 auto_id BIGINT NOT NULL,
126 PRIMARY KEY (auto_id)
128 CREATE GENERATOR auto_id_tests_seq;
129 SET GENERATOR auto_id_tests_seq TO 10000;
131 CREATE TABLE entrants (
133 name VARCHAR(255) NOT NULL,
134 course_id INTEGER NOT NULL,
137 CREATE GENERATOR entrants_seq;
138 SET GENERATOR entrants_seq TO 10000;
140 CREATE TABLE colnametests (
142 "REFERENCES" INTEGER NOT NULL,
145 CREATE GENERATOR colnametests_seq;
146 SET GENERATOR colnametests_seq TO 10000;
148 CREATE TABLE mixins (
152 created_at TIMESTAMP,
153 updated_at TIMESTAMP,
160 CREATE GENERATOR mixins_seq;
161 SET GENERATOR mixins_seq TO 10000;
163 CREATE TABLE people (
165 first_name VARCHAR(40),
166 lock_version INTEGER DEFAULT 0 NOT NULL,
169 CREATE GENERATOR people_seq;
170 SET GENERATOR people_seq TO 10000;
172 CREATE TABLE readers (
174 post_id BIGINT NOT NULL,
175 person_id BIGINT NOT NULL,
178 CREATE GENERATOR readers_seq;
179 SET GENERATOR readers_seq TO 10000;
181 CREATE TABLE binaries (
186 CREATE GENERATOR binaries_seq;
187 SET GENERATOR binaries_seq TO 10000;
189 CREATE TABLE computers (
191 developer INTEGER NOT NULL,
192 "extendedWarranty" INTEGER NOT NULL,
195 CREATE GENERATOR computers_seq;
196 SET GENERATOR computers_seq TO 10000;
201 title VARCHAR(255) NOT NULL,
202 "TYPE" VARCHAR(255) NOT NULL,
203 body VARCHAR(3000) NOT NULL,
206 CREATE GENERATOR posts_seq;
207 SET GENERATOR posts_seq TO 10000;
209 CREATE TABLE comments (
211 post_id BIGINT NOT NULL,
212 "TYPE" VARCHAR(255) NOT NULL,
213 body VARCHAR(3000) NOT NULL,
216 CREATE GENERATOR comments_seq;
217 SET GENERATOR comments_seq TO 10000;
219 CREATE TABLE authors (
221 name VARCHAR(255) NOT NULL,
224 CREATE GENERATOR authors_seq;
225 SET GENERATOR authors_seq TO 10000;
229 "STARTING" TIMESTAMP,
233 CREATE GENERATOR tasks_seq;
234 SET GENERATOR tasks_seq TO 10000;
236 CREATE TABLE categories (
238 name VARCHAR(255) NOT NULL,
239 "TYPE" VARCHAR(255) NOT NULL,
242 CREATE GENERATOR categories_seq;
243 SET GENERATOR categories_seq TO 10000;
245 CREATE TABLE categories_posts (
246 category_id BIGINT NOT NULL,
247 post_id BIGINT NOT NULL,
248 PRIMARY KEY (category_id, post_id)
251 CREATE TABLE fk_test_has_pk (
256 CREATE TABLE fk_test_has_fk (
258 fk_id BIGINT NOT NULL,
260 FOREIGN KEY (fk_id) REFERENCES fk_test_has_pk(id)
263 CREATE TABLE keyboards (
264 key_number BIGINT NOT NULL,
266 PRIMARY KEY (key_number)
268 CREATE GENERATOR keyboards_seq;
269 SET GENERATOR keyboards_seq TO 10000;
271 CREATE TABLE defaults (
273 default_timestamp TIMESTAMP DEFAULT CURRENT_TIMESTAMP
275 CREATE GENERATOR defaults_seq;
276 SET GENERATOR defaults_seq TO 10000;
278 CREATE TABLE legacy_things (
280 tps_report_number INTEGER,
281 version INTEGER DEFAULT 0 NOT NULL,
284 CREATE GENERATOR legacy_things_seq;
285 SET GENERATOR legacy_things_seq TO 10000;
287 CREATE TABLE numeric_data (
289 bank_balance DECIMAL(10,2),
290 big_bank_balance DECIMAL(15,2),
291 world_population DECIMAL(10),
292 my_house_population DECIMAL(2),
293 decimal_number_with_default DECIMAL(3,2) DEFAULT 2.78,
296 CREATE GENERATOR numeric_data_seq;
297 SET GENERATOR numeric_data_seq TO 10000;
299 CREATE TABLE mixed_case_monkeys (
300 "monkeyID" BIGINT NOT NULL,
303 CREATE GENERATOR mixed_case_monkeys_seq;
304 SET GENERATOR mixed_case_monkeys_seq TO 10000;
306 CREATE TABLE minimalistics (
309 CREATE GENERATOR minimalistics_seq;
310 SET GENERATOR minimalistics_seq TO 10000;