aboutsummaryrefslogtreecommitdiffstats
path: root/activerecord/test/fixtures/db_definitions/sybase.sql
diff options
context:
space:
mode:
Diffstat (limited to 'activerecord/test/fixtures/db_definitions/sybase.sql')
-rw-r--r--activerecord/test/fixtures/db_definitions/sybase.sql222
1 files changed, 0 insertions, 222 deletions
diff --git a/activerecord/test/fixtures/db_definitions/sybase.sql b/activerecord/test/fixtures/db_definitions/sybase.sql
deleted file mode 100644
index 9f0cb3ebe2..0000000000
--- a/activerecord/test/fixtures/db_definitions/sybase.sql
+++ /dev/null
@@ -1,222 +0,0 @@
-CREATE TABLE accounts (
- id numeric(9,0) IDENTITY PRIMARY KEY,
- firm_id int NULL,
- credit_limit int NULL
-)
-
-CREATE TABLE funny_jokes (
-id numeric(9,0) IDENTITY PRIMARY KEY,
- name varchar(50) NULL
-)
-
-CREATE TABLE companies (
- id numeric(9,0) IDENTITY PRIMARY KEY,
- type varchar(50) NULL,
- ruby_type varchar(50) NULL,
- firm_id int NULL,
- name varchar(50) NULL,
- client_of int NULL,
- rating int default 1
-)
-
-
-CREATE TABLE topics (
- id numeric(9,0) IDENTITY PRIMARY KEY,
- title varchar(255) NULL,
- author_name varchar(255) NULL,
- author_email_address varchar(255) NULL,
- written_on datetime NULL,
- bonus_time datetime NULL,
- last_read datetime NULL,
- content varchar(255) NULL,
- approved bit default 1,
- replies_count int default 0,
- parent_id int NULL,
- type varchar(50) NULL
-)
-
-CREATE TABLE developers (
- id numeric(9,0) IDENTITY PRIMARY KEY,
- name varchar(100) NULL,
- salary int default 70000,
- created_at datetime NULL,
- updated_at datetime NULL
-)
-
-CREATE TABLE projects (
- id numeric(9,0) IDENTITY PRIMARY KEY,
- name varchar(100) NULL,
- type varchar(255) NULL
-)
-
-CREATE TABLE developers_projects (
- developer_id int NOT NULL,
- project_id int NOT NULL,
- joined_on datetime NULL,
- access_level smallint default 1
-)
-
-CREATE TABLE orders (
- id numeric(9,0) IDENTITY PRIMARY KEY,
- name varchar(100) NULL,
- billing_customer_id int NULL,
- shipping_customer_id int NULL
-)
-
-CREATE TABLE customers (
- id numeric(9,0) IDENTITY PRIMARY KEY,
- name varchar(100) NULL,
- balance int default 0,
- address_street varchar(100) NULL,
- address_city varchar(100) NULL,
- address_country varchar(100) NULL,
- gps_location varchar(100) NULL
-)
-
-CREATE TABLE movies (
- movieid numeric(9,0) IDENTITY PRIMARY KEY,
- name varchar(100) NULL
-)
-
-CREATE TABLE subscribers (
- nick varchar(100) PRIMARY KEY,
- name varchar(100) NULL
-)
-
-CREATE TABLE booleantests (
- id numeric(9,0) IDENTITY PRIMARY KEY,
- value int NULL
-)
-
-CREATE TABLE auto_id_tests (
- auto_id numeric(9,0) IDENTITY PRIMARY KEY,
- value int NULL
-)
-
-CREATE TABLE entrants (
- id numeric(9,0) IDENTITY PRIMARY KEY,
- name varchar(255) NOT NULL,
- course_id int NOT NULL
-)
-
-CREATE TABLE colnametests (
- id numeric(9,0) IDENTITY PRIMARY KEY,
- [references] int NOT NULL
-)
-
-CREATE TABLE mixins (
- id numeric(9,0) IDENTITY PRIMARY KEY,
- parent_id int NULL,
- pos int NULL,
- created_at datetime NULL,
- updated_at datetime NULL,
- lft int NULL,
- rgt int NULL,
- root_id int NULL,
- type varchar(40) NULL
-)
-
-CREATE TABLE people (
- id numeric(9,0) IDENTITY PRIMARY KEY,
- first_name varchar(40) NULL,
- lock_version int DEFAULT 0
-)
-
-CREATE TABLE readers (
- id numeric(9,0) IDENTITY PRIMARY KEY,
- post_id int NOT NULL,
- person_id int NOT NULL
-)
-
-CREATE TABLE binaries (
- id numeric(9,0) IDENTITY PRIMARY KEY,
- data image NULL
-)
-
-CREATE TABLE computers (
- id numeric(9,0) IDENTITY PRIMARY KEY,
- developer int NOT NULL,
- extendedWarranty int NOT NULL
-)
-
-CREATE TABLE posts (
- id numeric(9,0) IDENTITY PRIMARY KEY,
- author_id int NULL,
- title varchar(255) NOT NULL,
- body varchar(2048) NOT NULL,
- type varchar(255) NOT NULL
-)
-
-CREATE TABLE comments (
- id numeric(9,0) IDENTITY PRIMARY KEY,
- post_id int NOT NULL,
- body varchar(2048) NOT NULL,
- type varchar(255) NOT NULL
-)
-
-CREATE TABLE authors (
- id numeric(9,0) IDENTITY PRIMARY KEY,
- name varchar(255) NOT NULL
-)
-
-CREATE TABLE tasks (
- id numeric(9,0) IDENTITY PRIMARY KEY,
- starting datetime NULL,
- ending datetime NULL
-)
-
-CREATE TABLE categories (
- id numeric(9,0) IDENTITY PRIMARY KEY,
- name varchar(255) NOT NULL,
- type varchar(255) NOT NULL
-)
-
-CREATE TABLE categories_posts (
- category_id int NOT NULL,
- post_id int NOT NULL
-)
-
-CREATE TABLE fk_test_has_pk (
- id numeric(9,0) IDENTITY PRIMARY KEY
-)
-
-CREATE TABLE fk_test_has_fk (
- id numeric(9,0) PRIMARY KEY,
- fk_id numeric(9,0) NOT NULL,
-
- FOREIGN KEY (fk_id) REFERENCES fk_test_has_pk(id)
-)
-
-
-CREATE TABLE keyboards (
- key_number numeric(9,0) IDENTITY PRIMARY KEY,
- name varchar(50) NULL
-)
-
---This table has an altered lock_version column name.
-CREATE TABLE legacy_things (
- id numeric(9,0) IDENTITY PRIMARY KEY,
- tps_report_number int default NULL,
- version int default 0
-)
-
-
-CREATE TABLE numeric_data (
- id numeric(9,0) IDENTITY PRIMARY KEY,
- bank_balance numeric(10,2),
- big_bank_balance numeric(15,2),
- world_population numeric(10),
- my_house_population numeric(2),
- decimal_number_with_default numeric(3,2) DEFAULT 2.78
-)
-
-CREATE TABLE mixed_case_monkeys (
- [monkeyID] numeric(9,0) IDENTITY PRIMARY KEY,
- [fleaCount] numeric(9,0)
-);
-
-CREATE TABLE minimalistics (
- id numeric(9,0) IDENTITY PRIMARY KEY
-);
-
-go