tmp/test.db in composite_primary_keys-0.9.0 vs tmp/test.db in composite_primary_keys-0.9.90
- old
+ new
@@ -1,10 +1,10 @@
-SQLite format 3 @
-
G NEW_TYPEN" ##NAME_PREFIXName PrefixRT Desc GENDERGender
nMRMrRT Desc MRSMrs FEMALEFemale MSMs MRMr MALEMale
- 0
#Product One#Product Two
-
!2007-09-28d!2007-09-272!2007-09-27
- !2007-09-28!2007-09-27!2007-09-27
N u++!tablereference_typesreference_typesCREATE TABLE `reference_types` (
+SQLite format 3 @
+
## NAME_PREFIXName Prefix GENDERGender
MRSMrs FEMALEFemale MSMs MRMr MALEMale
+
#Product One#Product Two
+
!2007-12-21d!2007-12-202!2007-12-20
+ !2007-12-21!2007-12-20!2007-12-20
N u++!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
)N++Stablereference_codesreference_codesCREATE TABLE `reference_codes` (
@@ -37,12 +37,12 @@
)- A indexsqlite_autoindex_suburbs_1suburbsD _tablestreetsstreetsCREATE TABLE `streets` (
`id` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
`city_id` int(11) NOT NULL,
`suburb_id` int(11) NOT NULL,
`name` varchar(50) NOT NULL
-)
!2007-09-27!2007-09-27!2007-09-27
- !2007-09-27!2007-09-27!2007-09-27
%First Suburb'Second Suburb
+)
!2007-12-20!2007-12-20!2007-12-20
+ !2007-12-20!2007-12-20!2007-12-20
%First Suburb'Second Suburb
%First Street 'Second Street %First Street
3membership_statuses
groups readings articles comments users
employees streets
#k P
++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq) _tableusersusersCREATE TABLE `users` (
`id` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
`name` varchar(50) NOT NULL
) etablearticlesarticlesCREATE TABLE `articles` (
@@ -59,11 +59,11 @@
)##ktablemembershipsmembershipsCREATE TABLE memberships (
user_id int NOT NULL,
group_id int NOT NULL,
PRIMARY KEY (user_id,group_id)
)
Dr Nic Santiago
#Article One #Article Two
9Composite Primary Keys
-
Active Owner
A _ A Ttablehackshacks CREATE TABLE hacks (
+
Active Owner
< Z < Ttablehackshacks CREATE TABLE hacks (
name varchar(50) NOT NULL PRIMARY KEY
))= indexsqlite_autoindex_hacks_1hacks 5I# indexsqlite_autoindex_memberships_1membershipsV33Stablemembership_statusesmembership_statusesCREATE TABLE membership_statuses (
id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
user_id int NOT NULL,
group_id int NOT NULL,
@@ -74,13 +74,13 @@
PRIMARY KEY (department_id, location_id)
)5I# indexsqlite_autoindex_departments_1departments tableemployeesemployees CREATE TABLE employees (
id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
department_id INTEGER NULL,
location_id INTEGER NULL
-) tablecommentscomments CREATE TABLE comments (
+)# tablecommentscomments CREATE TABLE comments (
id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
- person_id INTEGER NULL,
+ person_id varchar(100) NULL,
person_type varchar(100) NULL
)
-
andrewHack User
Employee
andrew
+
andrewHack 1User
1Employee
andrew
andrew
\ No newline at end of file