X-Git-Url: https://git.openstreetmap.org/rails.git/blobdiff_plain/3a0f4d30cf6cbe921ffa2a78e5a0192c32a86ef4..62f999cd835dad3c16ea46e340bc15b0e43f31db:/vendor/gems/composite_primary_keys-1.1.0/test/fixtures/db_definitions/mysql.sql

diff --git a/vendor/gems/composite_primary_keys-1.1.0/test/fixtures/db_definitions/mysql.sql b/vendor/gems/composite_primary_keys-1.1.0/test/fixtures/db_definitions/mysql.sql
deleted file mode 100644
index e83d3aae5..000000000
--- a/vendor/gems/composite_primary_keys-1.1.0/test/fixtures/db_definitions/mysql.sql
+++ /dev/null
@@ -1,174 +0,0 @@
-create table reference_types (
-    reference_type_id int(11) not null auto_increment,
-    type_label varchar(50) default null,
-    abbreviation varchar(50) default null,
-    description varchar(50) default null,
-    primary key (reference_type_id)
-) type=InnoDB;
-
-create table reference_codes (
-    reference_type_id int(11),
-    reference_code int(11) not null,
-    code_label varchar(50) default null,
-    abbreviation varchar(50) default null,
-    description varchar(50) default null,
-    primary key (reference_type_id, reference_code)
-) type=InnoDB;
-
-create table products (
-    id int(11) not null auto_increment,
-    name varchar(50) default null,
-    primary key (id)
-) type=InnoDB;
-
-create table tariffs (
-    tariff_id int(11) not null,
-    start_date date not null,
-    amount integer(11) default null,
-    primary key (tariff_id, start_date)
-) type=InnoDB;
-
-create table product_tariffs (
-    product_id int(11) not null,
-    tariff_id int(11) not null,
-    tariff_start_date date not null,
-    primary key (product_id, tariff_id, tariff_start_date)
-) type=InnoDB;
-
-create table suburbs (
-    city_id int(11) not null,
-    suburb_id int(11) not null,
-    name varchar(50) not null,
-    primary key (city_id, suburb_id)
-) type=InnoDB;
-
-create table streets (
-    id int(11) not null auto_increment,
-    city_id int(11) not null,
-    suburb_id int(11) not null,
-    name varchar(50) not null,
-    primary key (id)
-) type=InnoDB;
-
-create table users (
-    id int(11) not null auto_increment,
-    name varchar(50) not null,
-    primary key (id)
-) type=InnoDB;
-
-create table articles (
-    id int(11) not null auto_increment,
-    name varchar(50) not null,
-    primary key (id)
-) type=InnoDB;
-
-create table readings (
-    id int(11) not null auto_increment,
-    user_id int(11) not null,
-    article_id int(11) not null,
-    rating int(11) not null,
-    primary key (id)
-) type=InnoDB;
-
-create table groups (
-    id int(11) not null auto_increment,
-    name varchar(50) not null,
-    primary key (id)
-) type=InnoDB;
-
-create table memberships (
-    user_id int(11) not null,
-    group_id int(11) not null,
-    primary key  (user_id,group_id)
-) type=InnoDB;
-
-create table membership_statuses (
-    id int(11) not null auto_increment,
-    user_id int(11) not null,
-    group_id int(11) not null,
-    status varchar(50) not null,
-    primary key (id)
-) type=InnoDB;
-
-create table departments (
-    department_id int(11) not null,
-    location_id int(11) not null,
-    primary key (department_id, location_id)
-) type=InnoDB;
-
-create table employees (
-    id int(11) not null auto_increment,
-    department_id int(11) default null,
-    location_id int(11) default null,
-    primary key (id)
-) type=InnoDB;
-
-create table comments (
-    id int(11) not null auto_increment,
-    person_id varchar(100) default null,
-    person_type varchar(100) default null,
-    hack_id varchar(100) default null,
-    primary key (id)
-) type=InnoDB;
-
-create table hacks (
-    name varchar(50) not null,
-    primary key (name)
-) type=InnoDB;
-
-create table kitchen_sinks (
-    id_1 int(11) not null,
-    id_2 int(11) not null,
-    a_date date,
-    a_string varchar(100),
-    primary key (id_1, id_2)
-) type=InnoDB;
-
-create table restaurants (
-    franchise_id int(11) not null,
-    store_id int(11) not null,
-    name varchar(100),
-    primary key (franchise_id, store_id)
-) type=InnoDB;
-
-create table restaurants_suburbs (
-    franchise_id int(11) not null,
-    store_id int(11) not null,
-    city_id int(11) not null,
-    suburb_id int(11) not null
-) type=InnoDB;
-
-create table dorms (
-    id int(11) not null auto_increment,
-    primary key(id)
-) type=InnoDB;
-
-create table rooms (
-    dorm_id int(11) not null,
-    room_id int(11) not null,
-    primary key (dorm_id, room_id)
-) type=InnoDB;
-
-create table room_attributes (
-    id int(11) not null auto_increment,
-    name varchar(50),
-    primary key(id)
-) type=InnoDB;
-
-create table room_attribute_assignments (
-    dorm_id int(11) not null,
-    room_id int(11) not null,
-    room_attribute_id int(11) not null
-) type=InnoDB;
-
-create table students (
-    id int(11) not null auto_increment,
-    primary key(id)
-) type=InnoDB;
-
-create table room_assignments (
-    student_id int(11) not null,
-    dorm_id int(11) not null,
-    room_id int(11) not null
-) type=InnoDB;
-