CREATE TABLE accounts ( id integer NOT NULL UNIQUE INDEX DEFAULT _rowid, firm_id integer, credit_limit integer ) go CREATE PRIMARY KEY accounts (id) go CREATE TABLE funny_jokes ( id integer NOT NULL UNIQUE INDEX DEFAULT _rowid, name char(50) DEFAULT NULL ) go CREATE PRIMARY KEY funny_jokes (id) go CREATE TABLE companies ( id integer NOT NULL UNIQUE INDEX DEFAULT _rowid, type char(50), ruby_type char(50), firm_id integer, name char(50), client_of integer, rating integer default 1 ) go CREATE PRIMARY KEY companies (id) go CREATE TABLE developers_projects ( developer_id integer NOT NULL, project_id integer NOT NULL, joined_on date, access_level integer default 1 ) go CREATE TABLE developers ( id integer NOT NULL UNIQUE INDEX DEFAULT _rowid, name char(100), salary integer DEFAULT 70000, created_at datetime, updated_at datetime ) go CREATE PRIMARY KEY developers (id) go CREATE TABLE projects ( id integer NOT NULL UNIQUE INDEX DEFAULT _rowid, name char(100), type char(255) ) go CREATE PRIMARY KEY projects (id) go CREATE TABLE topics ( id integer NOT NULL UNIQUE INDEX DEFAULT _rowid, title char(255), author_name char(255), author_email_address char(255), written_on datetime, bonus_time time, last_read date, content char(4096), approved boolean default true, replies_count integer default 0, parent_id integer, type char(50) ) go CREATE PRIMARY KEY topics (id) go CREATE TABLE customers ( id integer NOT NULL UNIQUE INDEX DEFAULT _rowid, name char, balance integer default 0, address_street char, address_city char, address_country char, gps_location char ) go CREATE PRIMARY KEY customers (id) go CREATE TABLE orders ( id integer NOT NULL UNIQUE INDEX DEFAULT _rowid, name char, billing_customer_id integer, shipping_customer_id integer ) go CREATE PRIMARY KEY orders (id) go CREATE TABLE movies ( movieid integer NOT NULL UNIQUE INDEX DEFAULT _rowid, name text ) go CREATE PRIMARY KEY movies (movieid) go CREATE TABLE subscribers ( nick CHAR(100) NOT NULL DEFAULT _rowid, name CHAR(100) ) go CREATE PRIMARY KEY subscribers (nick) go CREATE TABLE booleantests ( id integer NOT NULL UNIQUE INDEX DEFAULT _rowid, value boolean ) go CREATE PRIMARY KEY booleantests (id) go CREATE TABLE defaults ( id integer UNIQUE INDEX , modified_date date default CURDATE(), modified_date_function date default NOW(), fixed_date date default '2004-01-01', modified_time timestamp default NOW(), modified_time_function timestamp default NOW(), fixed_time timestamp default '2004-01-01 00:00:00.000000-00', char1 char(1) default 'Y', char2 char(50) default 'a char field', char3 text default 'a text field', positive_integer integer default 1, negative_integer integer default -1, decimal_number money default 2.78 ) go CREATE PRIMARY KEY defaults (id) go CREATE TABLE auto_id_tests ( auto_id integer NOT NULL UNIQUE INDEX DEFAULT _rowid, value integer ) go CREATE PRIMARY KEY auto_id_tests (auto_id) go CREATE TABLE entrants ( id integer NOT NULL UNIQUE INDEX, name text NOT NULL, course_id integer NOT NULL ) go CREATE PRIMARY KEY entrants (id) go CREATE TABLE colnametests ( id integer UNIQUE INDEX , references integer NOT NULL ) go CREATE PRIMARY KEY colnametests (id) go CREATE TABLE mixins ( id integer NOT NULL UNIQUE INDEX DEFAULT _rowid, parent_id integer, type char, pos integer, lft integer, rgt integer, root_id integer, created_at timestamp, updated_at timestamp ) go CREATE PRIMARY KEY mixins (id) go CREATE TABLE people ( id integer NOT NULL UNIQUE INDEX DEFAULT _rowid, first_name text, lock_version integer default 0 ) go CREATE PRIMARY KEY people (id) go CREATE TABLE readers ( id integer NOT NULL UNIQUE INDEX DEFAULT _rowid, post_id integer NOT NULL, person_id integer NOT NULL ) go CREATE PRIMARY KEY readers (id) go CREATE TABLE binaries ( id integer NOT NULL UNIQUE INDEX DEFAULT _rowid, data object ) go CREATE PRIMARY KEY binaries (id) go CREATE TABLE computers ( id integer UNIQUE INDEX , developer integer NOT NULL, extendedWarranty integer NOT NULL ) go CREATE TABLE posts ( id integer UNIQUE INDEX , author_id integer, title char(255), type char(255), body text ) go CREATE TABLE comments ( id integer UNIQUE INDEX , post_id integer, type char(255), body text ) go CREATE TABLE authors ( id integer UNIQUE INDEX , name char(255) default NULL ) go CREATE TABLE tasks ( id integer NOT NULL UNIQUE INDEX DEFAULT _rowid, starting datetime, ending datetime ) go CREATE PRIMARY KEY tasks (id) go CREATE TABLE categories ( id integer UNIQUE INDEX , name char(255), type char(255) ) go CREATE TABLE categories_posts ( category_id integer NOT NULL, post_id integer NOT NULL ) go CREATE TABLE fk_test_has_pk ( id INTEGER NOT NULL DEFAULT _rowid ) go CREATE PRIMARY KEY fk_test_has_pk (id) go CREATE TABLE fk_test_has_fk ( id INTEGER NOT NULL DEFAULT _rowid, fk_id INTEGER NOT NULL REFERENCES fk_test_has_pk.id ) go CREATE PRIMARY KEY fk_test_has_fk (id) go CREATE TABLE keyboards ( key_number integer UNIQUE INDEX DEFAULT _rowid, name char(50) ) go CREATE PRIMARY KEY keyboards (key_number) go CREATE TABLE legacy_things ( id INTEGER NOT NULL DEFAULT _rowid, tps_report_number INTEGER default NULL, version integer NOT NULL default 0 ) go CREATE PRIMARY KEY legacy_things (id) go CREATE TABLE numeric_data ( id INTEGER NOT NULL DEFAULT _rowid, bank_balance MONEY, big_bank_balance MONEY, world_population longlong, my_house_population longlong, decimal_number_with_default MONEY DEFAULT 2.78 ); go CREATE PRIMARY KEY numeric_data (id) go CREATE TABLE mixed_case_monkeys ( monkeyID INTEGER NOT NULL DEFAULT _rowid, fleaCount INTEGER ); go CREATE PRIMARY KEY mixed_case_monkeys (monkeyID) go