SQLite format 3@  -  9f   r ?tablecitiescities CREATE TABLE `cities` (`city` varchar(255), `country` varchar(255), PRIMARY KEY (`city`))+ ?indexsqlite_autoindex_cities_1cities &tablesuppliessupplies CREATE TABLE `supplies` (`sid` varchar(255), `pid` varchar(255), `qty` integer, PRIMARY KEY (`sid`, `pid`), FOREIGN KEY (`sid`) REFERENCES `suppliers`(`sid`) DEFERRABLE INITIALLY DEFERRED, FOREIGN KEY (`pid`) REFERENCES `parts`(`pid`) DEFERRABLE INITIALLY DEFERRED)/ Cindexsqlite_autoindex_supplies_1supplies 0?tablepartspartsCREATE TABLE `parts` (`pid` varchar(255), `name` varchar(255), `color` varchar(255), `weight` double precision, `city` varchar(255), PRIMARY KEY (`pid`)))=indexsqlite_autoindex_parts_1partsl5indexsuppliers_name_indexsuppliersCREATE UNIQUE INDEX `suppliers_name_index` ON `suppliers` (`name`) tablesupplierssuppliersCREATE TABLE `suppliers` (`sid` varchar(255), `name` varchar(255), `status` integer, `city` varchar(255), PRIMARY KEY (`sid`))1Eindexsqlite_autoindex_suppliers_1suppliers~//+tableschema_migrationsschema_migrationsCREATE TABLE `schema_migrations` (`filename` varchar(255) NOT NULL PRIMARY KEY)AU/indexsqlite_autoindex_schema_migrations_1schema_migrations )[20130723164400_create_initial_schema.rb +[20130723164400_create_initial_schema.rb S5AdamsAthensS4ClarkLondonS3BlakeParisS2Jones ParisS1SmithLondon S5S4S3S2S1  Adams Clark Blake Jones Smith qqP6CogRedLondonP5CamBlue ParisP4ScrewRedLondonP3ScrewBlueOsloP2BoltGreenParisP1NutRed London P6P5P4P3P2P1 r~r S4P5 S4P4, S4P2 S3P2 S2P2 S2P1, S1P6d S1P5d S1P4 S1P3 S1P2 S1P1,  S4P5 S4P4 S4P2 S3P2 S2P2 S2P1 S1P6 S1P5 S1P4 S1P3 S1P2 S1P1