test.db in composite_primary_keys-1.0.10

- old
+ new
@@ -1,97 +1,97 @@
 SQLite format 3@  &ç+ûöñìç$ 
 	
ÐÐí##NAME_PREFIXName PrefixGENDERGender
¬îàÒ¼¬MRSMrsFEMALEFemaleMSMsMRMrMALEMale
 ØðØèøà
ÞïÞ#Product One#Product Two
-ôôú
ÊîÜÊ!2008-08-28d!2008-08-272!2008-08-27
-ÍÞÍï!2008-08-28!2008-08-27!2008-08-27
--\›Gk++ƒ
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_codesyEtableproductsproductsCREATE TABLE products (
-  id int(11) NOT NULL PRIMARY KEY,
-  name varchar(50) default NULL
-)/Cindexsqlite_autoindex_products_1products6‚Ctabletariffstariffs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)
-)
BBqW–Fu2„-Aindexsqlite_autoindex_tariffs_1tariffsc++‚}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)
-)-Aindexsqlite_autoindex_suburbs_1suburbs:‚KtablestreetsstreetsCREATE 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_sequenceCREATE TABLE sqlite_sequence(name,seq)zStableusersusersCREATE TABLE users (
-  id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
-  name varchar(50) NOT NULL
-)
ÊîÜÊ!2008-08-27!2008-08-27!2008-08-27
-ÇÇÚí!2008-08-27!2008-08-27!2008-08-27
×ë×%First Suburb'Second Suburb
+ôôú
ÊîÜÊ!2008-10-23d!2008-10-222!2008-10-22
+ÍÞÍï!2008-10-23!2008-10-22!2008-10-22
P?s++ƒ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
+)‚A++„9tablereference_codesreference_codesCREATE 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)
+)=Q+indexsqlite_autoindex_reference_codes_1reference_codes}MtableproductsproductsCREATE TABLE products (
+    id int(11) not null primary key,
+    name varchar(50) default null
+)/Cindexsqlite_autoindex_products_1products>‚Stabletariffstariffs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)
+)
%%TC‚:i.€-Aindexsqlite_autoindex_tariffs_1tariffsl++ƒ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5
+‚Atablesuburbssuburbs
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)
+)-Aindexsqlite_autoindex_suburbs_1suburbsB‚[tablestreetsstreetsCREATE 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_sequenceCREATE TABLE sqlite_sequence(name,seq)~[tableusersusersCREATE TABLE users (
+    id integer not null primary key autoincrement,
+    name varchar(50) not null
+)
ÊîÜÊ!2008-10-22!2008-10-22!2008-10-22
+ÇÇÚí!2008-10-22!2008-10-22!2008-10-22
×ë×%First Suburb'Second Suburb
 ððø
ÀÀëÕ%First Street'Second Street%First Street
\òåÚÅ·¬žu\3membership_statuses
 
-groups	comments
employeesreadings	usersstudents+room_attributes	dormsstreetsarticles
èóè	Dr NicSantiago
ààð#Article One#Article Two
——Ü[ð'YtablearticlesarticlesCREATE TABLE articles (
-  id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
-  name varchar(50) NOT NULL
-)<‚KtablereadingsreadingsCREATE 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
-)}UtablegroupsgroupsCREATE TABLE groups (
-  id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
-  name varchar(50) NOT NULL
-)##ktablemembershipsmembershipsCREATE TABLE memberships (
-  user_id int NOT NULL,
-  group_id int NOT NULL,
-  PRIMARY KEY  (user_id,group_id)
-)5I#indexsqlite_autoindex_memberships_1membershipsV33‚Stablemembership_statusesmembership_statusesCREATE 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
+groups	comments
employeesreadings	usersstudents+room_attributes	dormsstreetsarticles
èóè	Dr NicSantiago
ààð#Article One#Article Two
zzËOê!atablearticlesarticlesCREATE TABLE articles (
+    id integer not null primary key autoincrement,
+    name varchar(50) not null
+)D‚[tablereadingsreadingsCREATE 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
+)]tablegroupsgroupsCREATE TABLE groups (
+    id integer not null primary key autoincrement,
+    name varchar(50) not null
+)##wtablemembershipsmembershipsCREATE TABLE memberships (
+    user_id int not null,
+    group_id int not null,
+    primary key (user_id, group_id)
+)5I#indexsqlite_autoindex_memberships_1memberships\33‚_tablemembership_statusesmembership_statusesCREATE 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
ùù
-øø
||+bÇH,##‚tabledepartmentsdepartmentsCREATE TABLE departments (
-  department_id INTEGER NOT NULL,
-  location_id INTEGER NOT NULL,
-  PRIMARY KEY (department_id, location_id)
-)5I#indexsqlite_autoindex_departments_1departments ‚tableemployeesemployeesCREATE TABLE employees (
- id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
- department_id INTEGER NULL,
- location_id INTEGER NULL
+øø
jjVÄH2##‚+tabledepartmentsdepartmentsCREATE TABLE departments (
+    department_id integer not null,
+    location_id integer not null,
+    primary key (department_id, location_id)
+)5I#indexsqlite_autoindex_departments_1departments)‚!tableemployeesemployeesCREATE TABLE employees (
+    id integer not null primary key autoincrement,
+    department_id integer null,
+    location_id integer null
 )?‚QtablecommentscommentsCREATE TABLE comments (
-	id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
-	person_id varchar(100) NULL,
-	person_type varchar(100) NULL,
-	hack_id varchar(100) NULL
-)TtablehackshacksCREATE TABLE hacks (
- name varchar(50) NOT NULL PRIMARY KEY
+	id integer not null primary key autoincrement,
+	person_id varchar(100) null,
+	person_type varchar(100) null,
+	hack_id varchar(100) null
+)W
tablehackshacksCREATE TABLE hacks (
+    name varchar(50) not null primary key
 ))=indexsqlite_autoindex_hacks_1hacks5''‚)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)
 )
ðøð
ÍðÞÍandrewHack1Userandrew1Employee
ööandrew
 õõ
-andrew
çç!2008-08-27string
+andrew
çç!2008-10-22string
 øø
ïïMcDonalds
 øø
««æžÕ¢9M'indexsqlite_autoindex_kitchen_sinks_1kitchen_sinks!5##‚1tablerestaurantsrestaurants"CREATE TABLE restaurants (
 	franchise_id integer not null,
 	store_id integer not null,
 	name varchar(100),
\ No newline at end of file