tmp/test.db in composite_primary_keys-1.0.3 vs tmp/test.db in composite_primary_keys-1.0.4
- 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-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 (
+
!2008-07-16d!2008-07-152!2008-07-15
+ !2008-07-16!2008-07-15!2008-07-15
- -\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,12 +39,12 @@
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-07-13!2008-07-13!2008-07-13
- !2008-07-13!2008-07-13!2008-07-13
%First Suburb'Second Suburb
+)
!2008-07-15!2008-07-15!2008-07-15
+ !2008-07-15!2008-07-15!2008-07-15
%First Suburb'Second Suburb
%First Street 'Second Street %First Street
\ u\ 3membership_statuses
groups readingsarticlescomments users
employeesstudents+room_attributes dormsstreets
Dr Nic Santiago
#Article One #Article Two
['