tmp/test.db in composite_primary_keys-2.2.0 vs tmp/test.db in composite_primary_keys-2.2.1
- old
+ new
@@ -1,10 +1,10 @@
-SQLite format 3 @ n + $
+SQLite format 3 @ + $
## NAME_PREFIXName Prefix GENDERGender
MRSMrs FEMALEFemale MSMs MRMr MALEMale
#Product One#Product Two
-
!2008-10-30d!2008-10-292!2008-10-29
- !2008-10-30!2008-10-29!2008-10-29
P? s++tablereference_typesreference_typesCREATE TABLE reference_types (
+
!2009-01-22d!2009-01-212!2009-01-21
+ !2009-01-22!2009-01-21!2009-01-21
P? s++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
)A++9tablereference_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)~[tableusersusersCREATE TABLE users (
id integer not null primary key autoincrement,
name varchar(50) not null
-)
!2008-10-29!2008-10-29!2008-10-29
- !2008-10-29!2008-10-29!2008-10-29
%First Suburb'Second Suburb
+)
!2009-01-21!2009-01-21!2009-01-21
+ !2009-01-21!2009-01-21!2009-01-21
%First Suburb'Second Suburb
%First Street 'Second Street %First Street
\ u\ 3membership_statuses
groups comments
employeesreadings usersstudents+room_attributes dormsstreetsarticles
Dr Nic Santiago
#Article One #Article Two
z zO! atablearticlesarticlesCREATE TABLE articles (
id integer not null primary key autoincrement,
name varchar(50) not null
@@ -88,10 +88,10 @@
a_date date,
a_string varchar(100),
primary key (id_1, id_2)
)
andrewHack 1Userandrew 1Employee
andrew
-andrew
!2008-10-29string
+andrew
!2009-01-21string
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),
\ No newline at end of file