tmp/test.db in composite_primary_keys-1.0.4 vs tmp/test.db in composite_primary_keys-1.0.5
- 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-16d!2008-07-152!2008-07-15
- !2008-07-16!2008-07-15!2008-07-15
- -\G k++
tablereference_typesreference_typesCREATE TABLE reference_types (
+
!2008-07-26d!2008-07-252!2008-07-25
+ !2008-07-26!2008-07-25!2008-07-25
- -\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-15!2008-07-15!2008-07-15
- !2008-07-15!2008-07-15!2008-07-15
%First Suburb'Second Suburb
+)
!2008-07-25!2008-07-25!2008-07-25
+ !2008-07-25!2008-07-25!2008-07-25
%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
['