tmp/test.db in composite_primary_keys-0.9.92 vs tmp/test.db in composite_primary_keys-0.9.93
- old
+ new
@@ -1,86 +1,101 @@
-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` (
- `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` (
- `reference_type_id` int(11) NOT NULL,
- `reference_code` int(11) NOT NULL,
- `code_label` varchar(50) default NULL,
- `abbreviation` varchar(50) default NULL,
- `description` varchar(50) default NULL,
- PRIMARY KEY (`reference_type_id`,`reference_code`)
-)=Q+ indexsqlite_autoindex_reference_codes_1reference_codes QtableproductsproductsCREATE TABLE `products` (
- `id` int(11) NOT NULL PRIMARY KEY,
- `name` varchar(50) default NULL
-)/C indexsqlite_autoindex_products_1products
' ' N
-9 B[tabletariffstariffsCREATE TABLE `tariffs` (
- `tariff_id` int(11) NOT NULL,
- `start_date` date NOT NULL,
- `amount` integer(11) default NULL,
- PRIMARY KEY (`tariff_id`,`start_date`)
-)-A indexsqlite_autoindex_tariffs_1tariffsq++tableproduct_tariffsproduct_tariffs CREATE TABLE `product_tariffs` (
- `product_id` int(11) NOT NULL,
- `tariff_id` int(11) NOT NULL,
- `tariff_start_date` date NOT NULL,
- PRIMARY KEY (`product_id`,`tariff_id`,`tariff_start_date`)
-)= Q+ indexsqlite_autoindex_product_tariffs_1product_tariffs 9
-Itablesuburbssuburbs
CREATE TABLE `suburbs` (
- `city_id` int(11) NOT NULL,
- `suburb_id` int(11) NOT NULL,
- `name` varchar(50) NOT NULL,
- PRIMARY KEY (`city_id`,`suburb_id`)
-)- 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
-
%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` (
- `id` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
- `name` varchar(50) NOT NULL
-)F _tablereadingsreadingsCREATE TABLE `readings` (
- `id` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
- `user_id` int(11) NOT NULL,
- `article_id` int(11) NOT NULL,
- `rating` int(11) NOT NULL
+SQLite format 3 @ $
+
+
+
+
- -\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 (
+ reference_type_id int(11) NOT NULL,
+ reference_code int(11) NOT NULL,
+ code_label varchar(50) default NULL,
+ abbreviation varchar(50) default NULL,
+ description varchar(50) default NULL,
+ PRIMARY KEY (reference_type_id,reference_code)
+)=Q+ indexsqlite_autoindex_reference_codes_1reference_codesy EtableproductsproductsCREATE TABLE products (
+ id int(11) NOT NULL PRIMARY KEY,
+ name varchar(50) default NULL
+)/C indexsqlite_autoindex_products_1products6CtabletariffstariffsCREATE TABLE tariffs (
+ tariff_id int(11) NOT NULL,
+ start_date date NOT NULL,
+ amount integer(11) default NULL,
+ PRIMARY KEY (tariff_id,start_date)
+)
B B qWFu2 -A indexsqlite_autoindex_tariffs_1tariffsc++}tableproduct_tariffsproduct_tariffs CREATE TABLE product_tariffs (
+ product_id int(11) NOT NULL,
+ tariff_id int(11) NOT NULL,
+ tariff_start_date date NOT NULL,
+ PRIMARY KEY (product_id,tariff_id,tariff_start_date)
+)= Q+ indexsqlite_autoindex_product_tariffs_1product_tariffs -
+1tablesuburbssuburbs
CREATE TABLE suburbs (
+ city_id int(11) NOT NULL,
+ suburb_id int(11) NOT NULL,
+ name varchar(50) NOT NULL,
+ PRIMARY KEY (city_id,suburb_id)
+)- A indexsqlite_autoindex_suburbs_1suburbs: KtablestreetsstreetsCREATE 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
+)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 (
+ 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,
+ article_id int(11) NOT NULL,
+ rating int(11) NOT NULL
)}UtablegroupsgroupsCREATE TABLE groups (
id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
name varchar(50) NOT NULL
)##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 (
- name varchar(50) NOT NULL PRIMARY KEY
-))= indexsqlite_autoindex_hacks_1hacks 5I# indexsqlite_autoindex_memberships_1membershipsV33Stablemembership_statusesmembership_statusesCREATE TABLE membership_statuses (
+)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
-),## tabledepartmentsdepartmentsCREATE TABLE departments (
+)
+
+
{ {*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 (
+)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
-
-andrew
+)Ttablehackshacks CREATE TABLE hacks (
+ name varchar(50) NOT NULL PRIMARY KEY
+)
+
+
+
& & 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 (
+ id_1 integer not null,
+ id_2 integer not null,
+ a_date date,
+ a_string varchar(100),
+ primary key (id_1, id_2)
+)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#
\ No newline at end of file