tmp/test.db in composite_primary_keys-0.9.93 vs tmp/test.db in composite_primary_keys-1.0.0
- old
+ new
@@ -1,10 +1,10 @@
-SQLite format 3 @ $
-
-
-
-
- -\G k++
tablereference_typesreference_typesCREATE TABLE reference_types (
+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 (
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,13 +39,14 @@
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
-)
-
-
[' YtablearticlesarticlesCREATE TABLE articles (
+)
!2008-06-05!2008-06-05!2008-06-05
+ !2008-06-05!2008-06-05!2008-06-05
%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 (
id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
user_id int(11) NOT NULL,
@@ -61,13 +62,13 @@
)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,
status varchar(50) NOT NULL
-)
-
-
{ {*a ,## tabledepartmentsdepartmentsCREATE TABLE departments (
+)
9Composite Primary Keys
+
Active Owner
+
{ {*a ,## tabledepartmentsdepartmentsCREATE TABLE departments (
department_id INTEGER NOT NULL,
location_id INTEGER NOT NULL,
PRIMARY KEY (department_id, location_id)
)5I# indexsqlite_autoindex_departments_1departments tableemployeesemployees CREATE TABLE employees (
id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
@@ -77,14 +78,15 @@
id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
person_id varchar(100) NULL,
person_type varchar(100) NULL
)Ttablehackshacks CREATE TABLE hacks (
name varchar(50) NOT NULL PRIMARY KEY
-)
-
-
-
& & J 33;tablerestaurants_suburbsrestaurants_suburbs%CREATE TABLE restaurants_suburbs (
+)
andrewHack 1User
1Employee
andrew
+
+andrew
!2008-06-05string
+
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,
suburb_id integer not null
))= indexsqlite_autoindex_hacks_1hacks 5'')tablekitchen_sinkskitchen_sinks CREATE TABLE kitchen_sinks (
@@ -96,6 +98,6 @@
)9 M' indexsqlite_autoindex_kitchen_sinks_1kitchen_sinks!5 ##1tablerestaurantsrestaurants"CREATE TABLE restaurants (
franchise_id integer not null,
store_id integer not null,
name varchar(100),
primary key (franchise_id, store_id)
-)5 I# indexsqlite_autoindex_restaurants_1restaurants#
+)5 I# indexsqlite_autoindex_restaurants_1restaurants#
\ No newline at end of file