aboutsummaryrefslogtreecommitdiffstats
path: root/activerecord/test/fixtures/db_definitions/openbase.sql
diff options
context:
space:
mode:
Diffstat (limited to 'activerecord/test/fixtures/db_definitions/openbase.sql')
-rw-r--r--activerecord/test/fixtures/db_definitions/openbase.sql318
1 files changed, 0 insertions, 318 deletions
diff --git a/activerecord/test/fixtures/db_definitions/openbase.sql b/activerecord/test/fixtures/db_definitions/openbase.sql
deleted file mode 100644
index ec0029b0f6..0000000000
--- a/activerecord/test/fixtures/db_definitions/openbase.sql
+++ /dev/null
@@ -1,318 +0,0 @@
-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
-
-CREATE TABLE minimalistics (
- id INTEGER NOT NULL DEFAULT _rowid
-);
-go
-CREATE PRIMARY KEY minimalistics (id)
-go