--- /dev/null
+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;
+