SQLite format 3@ "$   ##NAME_PREFIXName PrefixGENDERGender MRSMrsFEMALEFemale MSMs MRMrMALEMale  #Product One#Product Two  !2008-06-07d!2008-06-062!2008-06-06 !2008-06-07!2008-06-06!2008-06-06 --\Gk++ tablereference_typesreference_typesCREATE TABLE reference_types ( reference_type_id INTEGER PRIMARY KEY, type_label varchar(50) default NULL, abbreviation varchar(50) default NULL, description varchar(50) default NULL )>++3tablereference_codesreference_codesCREATE TABLE reference_codes ( reference_type_id int(11) NOT NULL, 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) )=Q+indexsqlite_autoindex_reference_codes_1reference_codesyEtableproductsproductsCREATE TABLE products ( id int(11) NOT NULL PRIMARY KEY, name varchar(50) default NULL )/Cindexsqlite_autoindex_products_1products6CtabletariffstariffsCREATE TABLE tariffs ( tariff_id int(11) NOT NULL, start_date date NOT NULL, amount integer(11) default NULL, PRIMARY KEY (tariff_id,start_date) ) BBqWFu2-Aindexsqlite_autoindex_tariffs_1tariffsc++}tableproduct_tariffsproduct_tariffs 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) )= Q+indexsqlite_autoindex_product_tariffs_1product_tariffs - 1tablesuburbssuburbs 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) )- Aindexsqlite_autoindex_suburbs_1suburbs: KtablestreetsstreetsCREATE TABLE streets ( id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, city_id int(11) NOT NULL, suburb_id int(11) NOT NULL, name varchar(50) NOT NULL )P ++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)zStableusersusersCREATE TABLE users ( id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, name varchar(50) NOT NULL ) !2008-06-06!2008-06-06!2008-06-06 !2008-06-06!2008-06-06!2008-06-06 %First Suburb'Second Suburb  %First Street'Second Street%First Street 3membership_statuses groups readings articles comments users employees streets  Dr Nic Santiago #Article One#Article Two ['YtablearticlesarticlesCREATE TABLE articles ( id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, name varchar(50) NOT NULL )<KtablereadingsreadingsCREATE TABLE readings ( id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, user_id int(11) NOT NULL, article_id int(11) NOT NULL, rating int(11) NOT NULL )}UtablegroupsgroupsCREATE TABLE groups ( id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, name varchar(50) NOT NULL )##ktablemembershipsmembershipsCREATE TABLE memberships ( user_id int NOT NULL, group_id int NOT NULL, PRIMARY KEY (user_id,group_id) )5I#indexsqlite_autoindex_memberships_1membershipsV33Stablemembership_statusesmembership_statusesCREATE TABLE membership_statuses ( id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, user_id int NOT NULL, group_id int NOT NULL, status varchar(50) NOT NULL )  9Composite Primary Keys    Active Owner   {{*a,##tabledepartmentsdepartmentsCREATE TABLE departments ( department_id INTEGER NOT NULL, location_id INTEGER NOT NULL, PRIMARY KEY (department_id, location_id) )5I#indexsqlite_autoindex_departments_1departments tableemployeesemployeesCREATE TABLE employees ( id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, department_id INTEGER NULL, location_id INTEGER NULL )#tablecommentscommentsCREATE TABLE comments ( id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, person_id varchar(100) NULL, person_type varchar(100) NULL )TtablehackshacksCREATE TABLE hacks ( name varchar(50) NOT NULL PRIMARY KEY )  andrewHack 1User 1Employee andrew  andrew !2008-06-06string  McDonalds  &&J33;tablerestaurants_suburbsrestaurants_suburbs%CREATE TABLE restaurants_suburbs ( franchise_id integer not null, store_id integer not null, city_id integer not null, suburb_id integer not null ))=indexsqlite_autoindex_hacks_1hacks5'')tablekitchen_sinkskitchen_sinks CREATE TABLE kitchen_sinks ( id_1 integer not null, id_2 integer not null, a_date date, a_string varchar(100), primary key (id_1, id_2) )9M'indexsqlite_autoindex_kitchen_sinks_1kitchen_sinks!5##1tablerestaurantsrestaurants"CREATE TABLE restaurants ( franchise_id integer not null, store_id integer not null, name varchar(100), primary key (franchise_id, store_id) )5I#indexsqlite_autoindex_restaurants_1restaurants#