1 CREATE TABLE accounts (
2 id numeric(9,0) IDENTITY PRIMARY KEY,
7 CREATE TABLE funny_jokes (
8 id numeric(9,0) IDENTITY PRIMARY KEY,
12 CREATE TABLE companies (
13 id numeric(9,0) IDENTITY PRIMARY KEY,
14 type varchar(50) NULL,
15 ruby_type varchar(50) NULL,
17 name varchar(50) NULL,
24 id numeric(9,0) IDENTITY PRIMARY KEY,
25 title varchar(255) NULL,
26 author_name varchar(255) NULL,
27 author_email_address varchar(255) NULL,
28 written_on datetime NULL,
29 bonus_time datetime NULL,
30 last_read datetime NULL,
31 content varchar(255) NULL,
32 approved bit default 1,
33 replies_count int default 0,
38 CREATE TABLE developers (
39 id numeric(9,0) IDENTITY PRIMARY KEY,
40 name varchar(100) NULL,
41 salary int default 70000,
42 created_at datetime NULL,
43 updated_at datetime NULL
46 CREATE TABLE projects (
47 id numeric(9,0) IDENTITY PRIMARY KEY,
48 name varchar(100) NULL,
49 type varchar(255) NULL
52 CREATE TABLE developers_projects (
53 developer_id int NOT NULL,
54 project_id int NOT NULL,
55 joined_on datetime NULL,
56 access_level smallint default 1
60 id numeric(9,0) IDENTITY PRIMARY KEY,
61 name varchar(100) NULL,
62 billing_customer_id int NULL,
63 shipping_customer_id int NULL
66 CREATE TABLE customers (
67 id numeric(9,0) IDENTITY PRIMARY KEY,
68 name varchar(100) NULL,
69 balance int default 0,
70 address_street varchar(100) NULL,
71 address_city varchar(100) NULL,
72 address_country varchar(100) NULL,
73 gps_location varchar(100) NULL
77 movieid numeric(9,0) IDENTITY PRIMARY KEY,
78 name varchar(100) NULL
81 CREATE TABLE subscribers (
82 nick varchar(100) PRIMARY KEY,
83 name varchar(100) NULL
86 CREATE TABLE booleantests (
87 id numeric(9,0) IDENTITY PRIMARY KEY,
91 CREATE TABLE auto_id_tests (
92 auto_id numeric(9,0) IDENTITY PRIMARY KEY,
96 CREATE TABLE entrants (
97 id numeric(9,0) IDENTITY PRIMARY KEY,
98 name varchar(255) NOT NULL,
99 course_id int NOT NULL
102 CREATE TABLE colnametests (
103 id numeric(9,0) IDENTITY PRIMARY KEY,
104 [references] int NOT NULL
107 CREATE TABLE mixins (
108 id numeric(9,0) IDENTITY PRIMARY KEY,
111 created_at datetime NULL,
112 updated_at datetime NULL,
116 type varchar(40) NULL
119 CREATE TABLE people (
120 id numeric(9,0) IDENTITY PRIMARY KEY,
121 first_name varchar(40) NULL,
122 lock_version int DEFAULT 0
125 CREATE TABLE readers (
126 id numeric(9,0) IDENTITY PRIMARY KEY,
127 post_id int NOT NULL,
128 person_id int NOT NULL
131 CREATE TABLE binaries (
132 id numeric(9,0) IDENTITY PRIMARY KEY,
136 CREATE TABLE computers (
137 id numeric(9,0) IDENTITY PRIMARY KEY,
138 developer int NOT NULL,
139 extendedWarranty int NOT NULL
143 id numeric(9,0) IDENTITY PRIMARY KEY,
145 title varchar(255) NOT NULL,
146 body varchar(2048) NOT NULL,
147 type varchar(255) NOT NULL
150 CREATE TABLE comments (
151 id numeric(9,0) IDENTITY PRIMARY KEY,
152 post_id int NOT NULL,
153 body varchar(2048) NOT NULL,
154 type varchar(255) NOT NULL
157 CREATE TABLE authors (
158 id numeric(9,0) IDENTITY PRIMARY KEY,
159 name varchar(255) NOT NULL
163 id numeric(9,0) IDENTITY PRIMARY KEY,
164 starting datetime NULL,
168 CREATE TABLE categories (
169 id numeric(9,0) IDENTITY PRIMARY KEY,
170 name varchar(255) NOT NULL,
171 type varchar(255) NOT NULL
174 CREATE TABLE categories_posts (
175 category_id int NOT NULL,
179 CREATE TABLE fk_test_has_pk (
180 id numeric(9,0) IDENTITY PRIMARY KEY
183 CREATE TABLE fk_test_has_fk (
184 id numeric(9,0) PRIMARY KEY,
185 fk_id numeric(9,0) NOT NULL,
187 FOREIGN KEY (fk_id) REFERENCES fk_test_has_pk(id)
191 CREATE TABLE keyboards (
192 key_number numeric(9,0) IDENTITY PRIMARY KEY,
193 name varchar(50) NULL
196 --This table has an altered lock_version column name.
197 CREATE TABLE legacy_things (
198 id numeric(9,0) IDENTITY PRIMARY KEY,
199 tps_report_number int default NULL,
200 version int default 0
204 CREATE TABLE numeric_data (
205 id numeric(9,0) IDENTITY PRIMARY KEY,
206 bank_balance numeric(10,2),
207 big_bank_balance numeric(15,2),
208 world_population numeric(10),
209 my_house_population numeric(2),
210 decimal_number_with_default numeric(3,2) DEFAULT 2.78
213 CREATE TABLE mixed_case_monkeys (
214 [monkeyID] numeric(9,0) IDENTITY PRIMARY KEY,
215 [fleaCount] numeric(9,0)
218 CREATE TABLE minimalistics (
219 id numeric(9,0) IDENTITY PRIMARY KEY