tmp/test.db in composite_primary_keys-2.3.5 vs tmp/test.db in composite_primary_keys-2.3.5.1
- old
+ new
@@ -34,13 +34,13 @@
reference_type_id integer primary key,
type_label varchar(50) default null,
abbreviation varchar(50) default null,
description varchar(50) defa
## NAME_PREFIXName Prefix GENDERGender
MRMr MRSMrs FEMALEFemale MSMs MALEMale
#Product Two#Product One
-
!2009-12-17d!2009-12-162!2009-12-16
- !2009-12-17!2009-12-16!2009-12-16
!2009-12-16!2009-12-16!2009-12-16
- !2009-12-16!2009-12-16!2009-12-16
%First Suburb'Second Suburb
+
!2010-02-14d!2010-02-132!2010-02-13
+ !2010-02-14!2010-02-13!2010-02-13
!2010-02-13!2010-02-13!2010-02-13
+ !2010-02-13!2010-02-13!2010-02-13
%First Suburb'Second Suburb
'Second Street %First Street %First Street
\ u\ 3membership_statuses
groups comments
employees readings users students+room_attributes dorms streets articles
Dr Nic Santiago
4 7 s++ tablereference_typesreference_typesCREATE TABLE reference_types (
reference_type_id integer primary key,
types++ tablereference_typesreference_typesCREATE TABLE reference_types (
@@ -122,10 +122,10 @@
name varchar(50) not null primary key
))= indexsqlite_autoindex_hacks_1hacks
9Composite Primary Keys
Active Owner
andrewHack 1Userandrew 1Employee
andrew
-andrew
!2009-12-16string
+andrew
!2010-02-13string
McDonalds
p+[ U e% tablestudentsstudents)CREATE TABLE students (
id integer not null primary key autoincrement
)F$AAtableroom_attribute_assignmentsroom_attribute_assignments(CREATE TABL ' tableseatsseats+CREATE TABLE seats (
flight_number integer not_null,
\ No newline at end of file