aboutsummaryrefslogtreecommitdiffstats
path: root/activerecord/test/fixtures/db_definitions/frontbase.sql
diff options
context:
space:
mode:
Diffstat (limited to 'activerecord/test/fixtures/db_definitions/frontbase.sql')
-rw-r--r--activerecord/test/fixtures/db_definitions/frontbase.sql273
1 files changed, 0 insertions, 273 deletions
diff --git a/activerecord/test/fixtures/db_definitions/frontbase.sql b/activerecord/test/fixtures/db_definitions/frontbase.sql
deleted file mode 100644
index 83441798b4..0000000000
--- a/activerecord/test/fixtures/db_definitions/frontbase.sql
+++ /dev/null
@@ -1,273 +0,0 @@
-CREATE TABLE accounts (
- id integer DEFAULT unique,
- firm_id integer,
- credit_limit integer,
- PRIMARY KEY (id)
-);
-SET UNIQUE FOR accounts(id);
-
-CREATE TABLE funny_jokes (
- id integer DEFAULT unique,
- firm_id integer default NULL,
- name character varying(50),
- PRIMARY KEY (id)
-);
-SET UNIQUE FOR funny_jokes(id);
-
-CREATE TABLE companies (
- id integer DEFAULT unique,
- "type" character varying(50),
- "ruby_type" character varying(50),
- firm_id integer,
- name character varying(50),
- client_of integer,
- rating integer default 1,
- PRIMARY KEY (id)
-);
-SET UNIQUE FOR companies(id);
-
-CREATE TABLE topics (
- id integer DEFAULT unique,
- title character varying(255),
- author_name character varying(255),
- author_email_address character varying(255),
- written_on timestamp,
- bonus_time time,
- last_read date,
- content varchar(65536),
- approved boolean default true,
- replies_count integer default 0,
- parent_id integer,
- "type" character varying(50),
- PRIMARY KEY (id)
-);
-SET UNIQUE FOR topics(id);
-
-CREATE TABLE developers (
- id integer DEFAULT unique,
- name character varying(100),
- salary integer DEFAULT 70000,
- created_at timestamp,
- updated_at timestamp,
- PRIMARY KEY (id)
-);
-SET UNIQUE FOR developers(id);
-
-CREATE TABLE projects (
- id integer DEFAULT unique,
- name character varying(100),
- type varchar(255),
- PRIMARY KEY (id)
-);
-SET UNIQUE FOR projects(id);
-
-CREATE TABLE developers_projects (
- developer_id integer NOT NULL,
- project_id integer NOT NULL,
- joined_on date,
- access_level integer default 1
-);
-
-CREATE TABLE orders (
- id integer DEFAULT unique,
- name character varying(100),
- billing_customer_id integer,
- shipping_customer_id integer,
- PRIMARY KEY (id)
-);
-SET UNIQUE FOR orders(id);
-
-CREATE TABLE customers (
- id integer DEFAULT unique,
- name character varying(100),
- balance integer default 0,
- address_street character varying(100),
- address_city character varying(100),
- address_country character varying(100),
- gps_location character varying(100),
- PRIMARY KEY (id)
-);
-SET UNIQUE FOR customers(id);
-
-CREATE TABLE movies (
- movieid integer DEFAULT unique,
- name varchar(65536),
- PRIMARY KEY (movieid)
-);
-SET UNIQUE FOR movies(movieid);
-
-CREATE TABLE subscribers (
- nick varchar(65536) NOT NULL,
- name varchar(65536),
- PRIMARY KEY (nick)
-);
-
-CREATE TABLE booleantests (
- id integer DEFAULT unique,
- value boolean,
- PRIMARY KEY (id)
-);
-SET UNIQUE FOR booleantests(id);
-
-CREATE TABLE auto_id_tests (
- auto_id integer DEFAULT unique,
- value integer,
- PRIMARY KEY (auto_id)
-);
-SET UNIQUE FOR auto_id_tests(auto_id);
-
-CREATE TABLE entrants (
- id integer DEFAULT unique,
- name varchar(65536),
- course_id integer,
- PRIMARY KEY (id)
-);
-SET UNIQUE FOR entrants(id);
-
-CREATE TABLE colnametests (
- id integer DEFAULT unique,
- "references" integer NOT NULL,
- PRIMARY KEY (id)
-);
-SET UNIQUE FOR colnametests(id);
-
-CREATE TABLE mixins (
- id integer DEFAULT unique,
- parent_id integer,
- type character varying(100),
- pos integer,
- lft integer,
- rgt integer,
- root_id integer,
- created_at timestamp,
- updated_at timestamp,
- PRIMARY KEY (id)
-);
-SET UNIQUE FOR mixins(id);
-
-CREATE TABLE people (
- id integer DEFAULT unique,
- first_name varchar(65536),
- lock_version integer default 0,
- PRIMARY KEY (id)
-);
-SET UNIQUE FOR people(id);
-
-CREATE TABLE readers (
- id integer DEFAULT unique,
- post_id INTEGER NOT NULL,
- person_id INTEGER NOT NULL,
- PRIMARY KEY (id)
-);
-SET UNIQUE FOR readers(id);
-
-CREATE TABLE binaries (
- id integer DEFAULT unique,
- data BLOB,
- PRIMARY KEY (id)
-);
-SET UNIQUE FOR binaries(id);
-
-CREATE TABLE computers (
- id integer DEFAULT unique,
- developer integer NOT NULL,
- "extendedWarranty" integer NOT NULL,
- PRIMARY KEY (id)
-);
-SET UNIQUE FOR computers(id);
-
-CREATE TABLE posts (
- id integer DEFAULT unique,
- author_id integer,
- title varchar(255),
- type varchar(255),
- body varchar(65536),
- PRIMARY KEY (id)
-);
-SET UNIQUE FOR posts(id);
-
-CREATE TABLE comments (
- id integer DEFAULT unique,
- post_id integer,
- type varchar(255),
- body varchar(65536),
- PRIMARY KEY (id)
-);
-SET UNIQUE FOR comments(id);
-
-CREATE TABLE authors (
- id integer DEFAULT unique,
- name varchar(255) default NULL,
- PRIMARY KEY (id)
-);
-SET UNIQUE FOR authors(id);
-
-CREATE TABLE tasks (
- id integer DEFAULT unique,
- starting timestamp,
- ending timestamp,
- PRIMARY KEY (id)
-);
-SET UNIQUE FOR tasks(id);
-
-CREATE TABLE categories (
- id integer DEFAULT unique,
- name varchar(255),
- type varchar(255),
- PRIMARY KEY (id)
-);
-SET UNIQUE FOR categories(id);
-
-CREATE TABLE categories_posts (
- category_id integer NOT NULL,
- post_id integer NOT NULL
-);
-
-CREATE TABLE fk_test_has_pk (
- id INTEGER NOT NULL PRIMARY KEY
-);
-SET UNIQUE FOR fk_test_has_pk(id);
-
-CREATE TABLE fk_test_has_fk (
- id INTEGER NOT NULL PRIMARY KEY,
- fk_id INTEGER NOT NULL REFERENCES fk_test_has_fk(id)
-);
-SET UNIQUE FOR fk_test_has_fk(id);
-
-CREATE TABLE keyboards (
- key_number integer DEFAULT unique,
- "name" character varying(50),
- PRIMARY KEY (key_number)
-);
-SET UNIQUE FOR keyboards(key_number);
-
-create table "legacy_things"
-(
- "id" int,
- "tps_report_number" int default NULL,
- "version" int default 0 not null,
- primary key ("id")
-);
-SET UNIQUE FOR legacy_things(id);
-
-CREATE TABLE "numeric_data" (
- "id" integer NOT NULL
- "bank_balance" DECIMAL(10,2),
- "big_bank_balance" DECIMAL(15,2),
- "world_population" DECIMAL(10),
- "my_house_population" DECIMAL(2),
- "decimal_number_with_default" DECIMAL(3,2) DEFAULT 2.78,
- primary key ("id")
-);
-SET UNIQUE FOR numeric_data(id);
-
-CREATE TABLE mixed_case_monkeys (
- "monkeyID" integer DEFAULT unique,
- "fleaCount" integer
-);
-SET UNIQUE FOR mixed_case_monkeys("monkeyID");
-
-CREATE TABLE minimalistics (
- "id" integer NOT NULL
-);
-SET UNIQUE FOR minimalistics("id");