1 CREATE TABLE accounts (
2 id INT GENERATED BY DEFAULT AS IDENTITY (START WITH 10000),
3 firm_id INT DEFAULT NULL,
4 credit_limit INT DEFAULT NULL,
8 CREATE TABLE funny_jokes (
9 id INT GENERATED BY DEFAULT AS IDENTITY (START WITH 10000),
10 name VARCHAR(50) DEFAULT NULL,
14 CREATE TABLE companies (
15 id INT GENERATED BY DEFAULT AS IDENTITY (START WITH 10000),
16 type VARCHAR(50) DEFAULT NULL,
17 ruby_type VARCHAR(50) DEFAULT NULL,
18 firm_id INT DEFAULT NULL,
19 name VARCHAR(50) DEFAULT NULL,
20 client_of INT DEFAULT NULL,
26 id INT GENERATED BY DEFAULT AS IDENTITY (START WITH 10000),
27 title VARCHAR(255) DEFAULT NULL,
28 author_name VARCHAR(255) DEFAULT NULL,
29 author_email_address VARCHAR(255) DEFAULT NULL,
30 written_on TIMESTAMP DEFAULT NULL,
31 bonus_time TIME DEFAULT NULL,
32 last_read DATE DEFAULT NULL,
33 content VARCHAR(3000),
34 approved SMALLINT DEFAULT 1,
35 replies_count INT DEFAULT 0,
36 parent_id INT DEFAULT NULL,
37 type VARCHAR(50) DEFAULT NULL,
41 CREATE TABLE developers (
42 id INT GENERATED BY DEFAULT AS IDENTITY (START WITH 10000),
43 name VARCHAR(100) DEFAULT NULL,
44 salary INT DEFAULT 70000,
45 created_at TIMESTAMP DEFAULT NULL,
46 updated_at TIMESTAMP DEFAULT NULL,
50 CREATE TABLE projects (
51 id INT GENERATED BY DEFAULT AS IDENTITY (START WITH 10000),
52 name VARCHAR(100) DEFAULT NULL,
53 type VARCHAR(255) DEFAULT NULL,
57 CREATE TABLE developers_projects (
58 developer_id INT NOT NULL,
59 project_id INT NOT NULL,
60 joined_on DATE DEFAULT NULL,
61 access_level SMALLINT DEFAULT 1
65 id INT GENERATED BY DEFAULT AS IDENTITY (START WITH 10000),
66 name VARCHAR(100) DEFAULT NULL,
67 billing_customer_id INT DEFAULT NULL,
68 shipping_customer_id INT DEFAULT NULL,
72 CREATE TABLE customers (
73 id INT GENERATED BY DEFAULT AS IDENTITY (START WITH 10000),
74 name VARCHAR(100) DEFAULT NULL,
75 balance INT DEFAULT 0,
76 address_street VARCHAR(100) DEFAULT NULL,
77 address_city VARCHAR(100) DEFAULT NULL,
78 address_country VARCHAR(100) DEFAULT NULL,
79 gps_location VARCHAR(100) DEFAULT NULL,
84 movieid INT GENERATED BY DEFAULT AS IDENTITY (START WITH 10000),
85 name VARCHAR(100) DEFAULT NULL,
89 CREATE TABLE subscribers (
90 nick VARCHAR(100) NOT NULL,
91 name VARCHAR(100) DEFAULT NULL,
95 CREATE TABLE booleantests (
96 id INT GENERATED BY DEFAULT AS IDENTITY (START WITH 10000),
97 value INT DEFAULT NULL,
101 CREATE TABLE auto_id_tests (
102 auto_id INT GENERATED BY DEFAULT AS IDENTITY (START WITH 10000),
103 value INT DEFAULT NULL,
104 PRIMARY KEY (auto_id)
107 CREATE TABLE entrants (
108 id INT NOT NULL PRIMARY KEY,
109 name VARCHAR(255) NOT NULL,
110 course_id INT NOT NULL
113 CREATE TABLE colnametests (
114 id INT GENERATED BY DEFAULT AS IDENTITY (START WITH 10000),
115 references INT NOT NULL,
119 CREATE TABLE mixins (
120 id INT GENERATED BY DEFAULT AS IDENTITY (START WITH 10000),
121 parent_id INT DEFAULT NULL,
122 pos INT DEFAULT NULL,
123 created_at TIMESTAMP DEFAULT NULL,
124 updated_at TIMESTAMP DEFAULT NULL,
125 lft INT DEFAULT NULL,
126 rgt INT DEFAULT NULL,
127 root_id INT DEFAULT NULL,
128 type VARCHAR(40) DEFAULT NULL,
132 CREATE TABLE people (
133 id INT GENERATED BY DEFAULT AS IDENTITY (START WITH 10000),
134 first_name VARCHAR(40) NOT NULL,
135 lock_version INT DEFAULT 0,
139 CREATE TABLE readers (
140 id INT GENERATED BY DEFAULT AS IDENTITY (START WITH 10000),
141 post_id INT NOT NULL,
142 person_id INT NOT NULL,
146 CREATE TABLE binaries (
147 id INT GENERATED BY DEFAULT AS IDENTITY (START WITH 10000),
152 CREATE TABLE computers (
153 id INT GENERATED BY DEFAULT AS IDENTITY (START WITH 10000),
154 developer INT NOT NULL,
155 extendedWarranty INT NOT NULL
159 id INT GENERATED BY DEFAULT AS IDENTITY (START WITH 10000),
160 author_id INT DEFAULT NULL,
161 title VARCHAR(255) DEFAULT NULL,
162 type VARCHAR(255) DEFAULT NULL,
163 body VARCHAR(3000) DEFAULT NULL
166 CREATE TABLE comments (
167 id INT GENERATED BY DEFAULT AS IDENTITY (START WITH 10000),
168 post_id INT DEFAULT NULL,
169 type VARCHAR(255) DEFAULT NULL,
170 body VARCHAR(3000) DEFAULT NULL
173 CREATE TABLE authors (
174 id INT GENERATED BY DEFAULT AS IDENTITY (START WITH 10000),
175 name VARCHAR(255) DEFAULT NULL
179 id INT GENERATED BY DEFAULT AS IDENTITY (START WITH 10000),
180 starting TIMESTAMP DEFAULT NULL,
181 ending TIMESTAMP DEFAULT NULL
184 CREATE TABLE categories (
185 id INT GENERATED BY DEFAULT AS IDENTITY (START WITH 10000),
186 name VARCHAR(255) NOT NULL,
187 type VARCHAR(40) DEFAULT NULL
190 CREATE TABLE categories_posts (
191 category_id INT NOT NULL,
195 CREATE TABLE keyboards (
196 key_number INT GENERATED BY DEFAULT AS IDENTITY (START WITH 10000),
200 CREATE TABLE fk_test_has_pk (
201 id INT NOT NULL PRIMARY KEY
204 CREATE TABLE fk_test_has_fk (
205 id INT NOT NULL PRIMARY KEY,
208 FOREIGN KEY (fk_id) REFERENCES fk_test_has_pk(id)
211 --This table has an altered lock_version column name
212 CREATE TABLE legacy_things (
213 id INT GENERATED BY DEFAULT AS IDENTITY (START WITH 10000),
214 tps_report_number INT DEFAULT NULL,
215 version INT DEFAULT 0,
219 CREATE TABLE numeric_data (
220 id INT NOT NULL PRIMARY KEY,
221 bank_balance DECIMAL(10,2),
222 big_bank_balance DECIMAL(15,2),
223 world_population DECIMAL(10),
224 my_house_population DECIMAL(2),
225 decimal_number_with_default DECIMAL(3,2) DEFAULT 2.78
228 CREATE TABLE mixed_case_monkeys (
229 monkeyID INT NOT NULL PRIMARY KEY,
233 CREATE TABLE minimalistics (
234 id INT NOT NULL PRIMARY KEY