aboutsummaryrefslogtreecommitdiffstats
path: root/activerecord/test/fixtures/db_definitions/mysql.sql
diff options
context:
space:
mode:
Diffstat (limited to 'activerecord/test/fixtures/db_definitions/mysql.sql')
-rwxr-xr-xactiverecord/test/fixtures/db_definitions/mysql.sql238
1 files changed, 0 insertions, 238 deletions
diff --git a/activerecord/test/fixtures/db_definitions/mysql.sql b/activerecord/test/fixtures/db_definitions/mysql.sql
deleted file mode 100755
index a2195a4f5a..0000000000
--- a/activerecord/test/fixtures/db_definitions/mysql.sql
+++ /dev/null
@@ -1,238 +0,0 @@
-CREATE TABLE `accounts` (
- `id` int(11) NOT NULL auto_increment,
- `firm_id` int(11) default NULL,
- `credit_limit` int(5) default NULL,
- PRIMARY KEY (`id`)
-) TYPE=InnoDB;
-
-CREATE TABLE `funny_jokes` (
- `id` int(11) NOT NULL auto_increment,
- `name` varchar(50) default NULL,
- PRIMARY KEY (`id`)
-) TYPE=InnoDB;
-
-CREATE TABLE `companies` (
- `id` int(11) NOT NULL auto_increment,
- `type` varchar(50) default NULL,
- `ruby_type` varchar(50) default NULL,
- `firm_id` int(11) default NULL,
- `name` varchar(50) default NULL,
- `client_of` int(11) default NULL,
- `rating` int(11) default NULL default 1,
- PRIMARY KEY (`id`)
-) TYPE=InnoDB;
-
-
-CREATE TABLE `topics` (
- `id` int(11) NOT NULL auto_increment,
- `title` varchar(255) default NULL,
- `author_name` varchar(255) default NULL,
- `author_email_address` varchar(255) default NULL,
- `written_on` datetime default NULL,
- `bonus_time` time default NULL,
- `last_read` date default NULL,
- `content` text,
- `approved` tinyint(1) default 1,
- `replies_count` int(11) default 0,
- `parent_id` int(11) default NULL,
- `type` varchar(50) default NULL,
- PRIMARY KEY (`id`)
-) TYPE=InnoDB DEFAULT CHARSET=utf8;
-
-CREATE TABLE `developers` (
- `id` int(11) NOT NULL auto_increment,
- `name` varchar(100) default NULL,
- `salary` int(11) default 70000,
- `created_at` datetime default NULL,
- `updated_at` datetime default NULL,
- PRIMARY KEY (`id`)
-) TYPE=InnoDB;
-
-CREATE TABLE `projects` (
- `id` int(11) NOT NULL auto_increment,
- `name` varchar(100) default NULL,
- `type` VARCHAR(255) default NULL,
- PRIMARY KEY (`id`)
-) TYPE=InnoDB;
-
-CREATE TABLE `developers_projects` (
- `developer_id` int(11) NOT NULL,
- `project_id` int(11) NOT NULL,
- `joined_on` date default NULL,
- `access_level` smallint default 1
-) TYPE=InnoDB;
-
-CREATE TABLE `orders` (
- `id` int(11) NOT NULL auto_increment,
- `name` varchar(100) default NULL,
- `billing_customer_id` int(11) default NULL,
- `shipping_customer_id` int(11) default NULL,
- PRIMARY KEY (`id`)
-) TYPE=InnoDB;
-
-CREATE TABLE `customers` (
- `id` int(11) NOT NULL auto_increment,
- `name` varchar(100) default NULL,
- `balance` int(6) default 0,
- `address_street` varchar(100) default NULL,
- `address_city` varchar(100) default NULL,
- `address_country` varchar(100) default NULL,
- `gps_location` varchar(100) default NULL,
- PRIMARY KEY (`id`)
-) TYPE=InnoDB;
-
-CREATE TABLE `movies` (
- `movieid` int(11) NOT NULL auto_increment,
- `name` varchar(100) default NULL,
- PRIMARY KEY (`movieid`)
-) TYPE=InnoDB;
-
-CREATE TABLE `subscribers` (
- `nick` varchar(100) NOT NULL,
- `name` varchar(100) default NULL,
- PRIMARY KEY (`nick`)
-) TYPE=InnoDB;
-
-CREATE TABLE `booleantests` (
- `id` int(11) NOT NULL auto_increment,
- `value` integer default NULL,
- PRIMARY KEY (`id`)
-) TYPE=InnoDB;
-
-CREATE TABLE `auto_id_tests` (
- `auto_id` int(11) NOT NULL auto_increment,
- `value` integer default NULL,
- PRIMARY KEY (`auto_id`)
-) TYPE=InnoDB;
-
-CREATE TABLE `entrants` (
- `id` INTEGER NOT NULL auto_increment PRIMARY KEY,
- `name` VARCHAR(255) NOT NULL,
- `course_id` INTEGER NOT NULL
-);
-
-CREATE TABLE `colnametests` (
- `id` int(11) NOT NULL auto_increment,
- `references` int(11) NOT NULL,
- PRIMARY KEY (`id`)
-) TYPE=InnoDB;
-
-CREATE TABLE `mixins` (
- `id` int(11) NOT NULL auto_increment,
- `parent_id` int(11) default NULL,
- `pos` int(11) default NULL,
- `created_at` datetime default NULL,
- `updated_at` datetime default NULL,
- `lft` int(11) default NULL,
- `rgt` int(11) default NULL,
- `root_id` int(11) default NULL,
- `type` varchar(40) default NULL,
- PRIMARY KEY (`id`)
-) TYPE=InnoDB;
-
-CREATE TABLE `people` (
- `id` INTEGER NOT NULL auto_increment PRIMARY KEY,
- `first_name` VARCHAR(40) NOT NULL,
- `lock_version` INTEGER NOT NULL DEFAULT 0
-) TYPE=InnoDB;
-
-CREATE TABLE `readers` (
- `id` int(11) NOT NULL auto_increment PRIMARY KEY,
- `post_id` INTEGER NOT NULL,
- `person_id` INTEGER NOT NULL
-) TYPE=InnoDB;
-
-CREATE TABLE `binaries` (
- `id` int(11) NOT NULL auto_increment,
- `data` mediumblob,
- PRIMARY KEY (`id`)
-) TYPE=InnoDB;
-
-CREATE TABLE `computers` (
- `id` INTEGER NOT NULL auto_increment PRIMARY KEY,
- `developer` INTEGER NOT NULL,
- `extendedWarranty` INTEGER NOT NULL
-) TYPE=InnoDB;
-
-CREATE TABLE `posts` (
- `id` INTEGER NOT NULL auto_increment PRIMARY KEY,
- `author_id` INTEGER,
- `title` VARCHAR(255) NOT NULL,
- `body` TEXT NOT NULL,
- `type` VARCHAR(255) default NULL
-) TYPE=InnoDB;
-
-CREATE TABLE `comments` (
- `id` INTEGER NOT NULL auto_increment PRIMARY KEY,
- `post_id` INTEGER NOT NULL,
- `body` TEXT NOT NULL,
- `type` VARCHAR(255) default NULL
-) TYPE=InnoDB;
-
-CREATE TABLE `authors` (
- `id` INTEGER NOT NULL auto_increment PRIMARY KEY,
- `name` VARCHAR(255) NOT NULL
-) TYPE=InnoDB;
-
-CREATE TABLE `tasks` (
- `id` int(11) NOT NULL auto_increment,
- `starting` datetime NOT NULL default '1000-01-01 00:00:00',
- `ending` datetime NOT NULL default '1000-01-01 00:00:00',
- PRIMARY KEY (`id`)
-) TYPE=InnoDB;
-
-CREATE TABLE `categories` (
- `id` int(11) NOT NULL auto_increment,
- `name` VARCHAR(255) NOT NULL,
- `type` VARCHAR(255) default NULL,
- PRIMARY KEY (`id`)
-) TYPE=InnoDB;
-
-CREATE TABLE `categories_posts` (
- `category_id` int(11) NOT NULL,
- `post_id` int(11) NOT NULL
-) TYPE=InnoDB;
-
-CREATE TABLE `fk_test_has_pk` (
- `id` INTEGER NOT NULL auto_increment PRIMARY KEY
-) TYPE=InnoDB;
-
-CREATE TABLE `fk_test_has_fk` (
- `id` INTEGER NOT NULL auto_increment PRIMARY KEY,
- `fk_id` INTEGER NOT NULL,
-
- FOREIGN KEY (`fk_id`) REFERENCES `fk_test_has_pk`(`id`)
-) TYPE=InnoDB;
-
-
-CREATE TABLE `keyboards` (
- `key_number` int(11) NOT NULL auto_increment primary key,
- `name` varchar(50) default NULL
-);
-
--- Altered lock_version column name.
-CREATE TABLE `legacy_things` (
- `id` int(11) NOT NULL auto_increment,
- `tps_report_number` int(11) default NULL,
- `version` int(11) NOT NULL default 0,
- PRIMARY KEY (`id`)
-) TYPE=InnoDB;
-
-CREATE TABLE `numeric_data` (
- `id` INTEGER NOT NULL auto_increment PRIMARY KEY,
- `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
-) TYPE=InnoDB;
-
-CREATE TABLE mixed_case_monkeys (
- `monkeyID` int(11) NOT NULL auto_increment,
- `fleaCount` int(11),
- PRIMARY KEY (`monkeyID`)
-) TYPE=InnoDB;
-
-CREATE TABLE `minimalistics` (
- `id` INTEGER NOT NULL auto_increment PRIMARY KEY
-);
generated by cgit v1.2.3 (git 2.25.1) at 2024-08-26 08:42:52 +0000