tmp/test.db in composite_primary_keys-1.0.0 vs tmp/test.db in composite_primary_keys-1.0.1
- old
+ new
@@ -1,10 +1,10 @@
SQLite format 3 @ " $
## NAME_PREFIXName Prefix GENDERGender
MRSMrs FEMALEFemale MSMs MRMr MALEMale
#Product One#Product Two
-
!2008-06-06d!2008-06-052!2008-06-05
- !2008-06-06!2008-06-05!2008-06-05
- -\G k++
tablereference_typesreference_typesCREATE TABLE reference_types (
+
!2008-06-07d!2008-06-062!2008-06-06
+ !2008-06-07!2008-06-06!2008-06-06
- -\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-06-05!2008-06-05!2008-06-05
- !2008-06-05!2008-06-05!2008-06-05
%First Suburb'Second Suburb
+)
!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 (
id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
name varchar(50) NOT NULL
)< KtablereadingsreadingsCREATE TABLE readings (
@@ -80,10 +80,10 @@
person_type varchar(100) NULL
)Ttablehackshacks CREATE TABLE hacks (
name varchar(50) NOT NULL PRIMARY KEY
)
andrewHack 1User
1Employee
andrew
-andrew
!2008-06-05string
+andrew
!2008-06-06string
McDonalds
& & J 33;tablerestaurants_suburbsrestaurants_suburbs%CREATE TABLE restaurants_suburbs (
franchise_id integer not null,
store_id integer not null,
city_id integer not null,
\ No newline at end of file