tmp/test.db in composite_primary_keys-1.0.2 vs tmp/test.db in composite_primary_keys-1.0.3
- old
+ new
@@ -1,10 +1,10 @@
-SQLite format 3 @ + $
+SQLite format 3 @ ( + $
## NAME_PREFIXName Prefix GENDERGender
MRSMrs FEMALEFemale MSMs MRMr MALEMale
#Product One#Product Two
-
!2008-06-08d!2008-06-072!2008-06-07
- !2008-06-08!2008-06-07!2008-06-07
- -\G k++
tablereference_typesreference_typesCREATE TABLE reference_types (
+
!2008-07-14d!2008-07-132!2008-07-13
+ !2008-07-14!2008-07-13!2008-07-13
- -\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 (
@@ -39,16 +39,15 @@
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-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
-j j
-+room_attributes dorms3membership_statuses
-groups readings articles streets comments users
employees
Dr Nic Santiago
#Article One #Article Two
[' YtablearticlesarticlesCREATE TABLE articles (
+)
!2008-07-13!2008-07-13!2008-07-13
+ !2008-07-13!2008-07-13!2008-07-13
%First Suburb'Second Suburb
+
%First Street 'Second Street %First Street
\ u\ 3membership_statuses
+
+groups readings articles comments users
employees students+room_attributes dorms 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,
@@ -88,11 +87,11 @@
a_date date,
a_string varchar(100),
primary key (id_1, id_2)
)
andrewHack 1User
1Employee
andrew
-andrew
!2008-06-07string
+andrew
!2008-07-13string
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),
@@ -103,17 +102,23 @@
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 (
+
keg
|7 "&--wtableroom_assignmentsroom_assignments-CREATE TABLE room_assignments (
+ student_id integer not null,
dorm_id integer not null,
+ room_id integer not null
+)e% tablestudentsstudents,CREATE TABLE students (
+ id integer not null primary key autoincrement
+)!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