tmp/test.db in composite_primary_keys-1.0.1 vs tmp/test.db in composite_primary_keys-1.0.2

- old
+ new

@@ -1,10 +1,10 @@ -SQLite format 3@ "$ +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 ( + !2008-06-08d!2008-06-072!2008-06-07 +!2008-06-08!2008-06-07!2008-06-07 --\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 ( @@ -39,14 +39,16 @@ 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 ( +) !2008-06-07!2008-06-07!2008-06-07 +!2008-06-07!2008-06-07!2008-06-07 %First Suburb'Second Suburb + %First Street'Second Street%First Street +jj ++room_attributes dorms3membership_statuses +groups readings articles streets comments users employees  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, @@ -64,11 +66,11 @@ user_id int NOT NULL, group_id int NOT NULL, status varchar(50) NOT NULL )  9Composite Primary Keys    Active Owner  - {{*a,##tabledepartmentsdepartmentsCREATE TABLE departments ( + G~!H,##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, @@ -78,26 +80,40 @@ 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 ( +)  andrewHack 1User 1Employee andrew + +andrew !2008-06-07string + McDonalds + 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#    +)5I#indexsqlite_autoindex_restaurants_1restaurants#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 +)\ tabledormsdorms&CREATE TABLE dorms ( + id integer not null primary key autoincrement +)      + keg  |7!etableroomsrooms'CREATE TABLE rooms ( + dorm_id integer not null, + room_id integer not null, + primary key (dorm_id, room_id) +))"=indexsqlite_autoindex_rooms_1rooms( #++Qtableroom_attributesroom_attributes)CREATE TABLE room_attributes ( + id integer not null primary key autoincrement, + name varchar(50) +)F$AAtableroom_attribute_assignmentsroom_attribute_assignments*CREATE TABLE room_attribute_assignments ( + dorm_id integer not null, + room_id integer not null, + room_attribute_id integer not null +) \ No newline at end of file