SQLite format 3@ 'a'-$ rAP ++Wtableshoppe_productsshoppe_productsCREATE TABLE "shoppe_products" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "product_category_id" integer, "title" varchar(255), "sku" varchar(255), "permalink" varchar(255), "description" text, "short_description" text, "active" boolean DEFAULT 't', "weight" decimal(8,3) DEFAULT 0.0, "price" decimal(8,2) DEFAULT 0.0, "tax_rate" decimal(8,2) DEFAULT 0.0, "stock" integer DEFAULT 0, "created_at" datetime, "updated_at" datetime, "featured" boolean DEFAULT 'f', "in_the_box" text, "cost_price" decimal(8,2), "stock_control" boolean DEFAULT 't')e??Ytableshoppe_product_attributesshoppe_product_attributes CREATE TABLE "shoppe_product_attributes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "product_id" integer, "key" varchar(255), "value" varchar(255), "position" integer DEFAULT 1, "searchable" boolean DEFAULT 't', "created_at" datetime, "updated_at" datetime, "public" boolean DEFAULT 't')K''Utableshoppe_ordersshoppe_ordersCREATE TABLE "shoppe_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "company" varchar(255), "address1" varchar(255), "address2" varchar(255), "address3" varchar(255), "address4" varchar(255), "postcode" varchar(255), "email_address" varchar(255), "phone_number" varchar(255), "status" varchar(255), "received_at" datetime, "accepted_at" datetime, "shipped_at" datetime, "created_at" datetime, "updated_at" datetime, "delivery_service_id" integer, "delivery_price" decimal(8,2), "delivery_tax_rate" decimal(8,2), "delivery_tax_amount" decimal(8,2), "paid_at" datetime, "accepted_by" integer, "shipped_by" integer, "consignment_number" varchar(255), "rejected_at" datetime, "rejected_by" integer, "ip_address" varchar(255), "country" varchar(255), "payment_reference" varchar(255), "payment_method" varchar(255), "delivery_cost_price" decimal(8,2))`==Stableshoppe_delivery_servicesshoppe_delivery_services CREATE TABLE "shoppe_delivery_services" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "code" varchar(255), "default" boolean DEFAULT 'f', "active" boolean DEFAULT 't', "created_at" datetime, "updated_at" datetime, "courier" varchar(255), "tracking_url" varchar(255)) IItableshoppe_delivery_service_pricesshoppe_delivery_service_prices CREATE TABLE "shoppe_delivery_service_prices" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "delivery_service_id" integer, "code" varchar(255), "price" decimal(8,2), "tax_rate" decimal(8,2), "min_weight" decimal(8,2), "max_weight" decimal(8,2), "created_at" datetime, "updated_at" datetime, "cost_price" decimal(8,2)) 11Ctableshoppe_order_itemsshoppe_order_itemsCREATE TABLE "shoppe_order_items" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order_id" integer, "product_id" integer, "quantity" integer DEFAULT 1, "unit_price" decimal(8,2), "tax_amount" decimal(8,2), "tax_rate" decimal(8,2), "weight" decimal(8,3) DEFAULT 0.0, "created_at" datetime, "updated_at" datetime, "unit_cost_price" decimal(8,2))%%itableshoppe_usersshoppe_users CREATE TABLE "shoppe_users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "first_name" varchar(255), "last_name" varchar(255), "email_address" varchar(255), "password_digest" varchar(255), "created_at" datetime, "updated_at" datetime)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq) ??#tableshoppe_product_categoriesshoppe_product_categoriesCREATE TABLE "shoppe_product_categories" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "permalink" varchar(255), "description" text, "created_at" datetime, "updated_at" datetime)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")q//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT   p^L:(tbP>, )20131017144430)20131013131658)20131013123937)20131012163301)20131012123829)20131006144849)20131004193320)20131004185043)20131003163827)20131002162301)20131002155246)20131002154122)20130930181344)20130929203421)20130929151744)20130928201257)20130928193023)20130928180041 )20130928173818 )20130928134518 )20130928131502 )20130928111819 )20130927150025)20130927132143)20130927130022)20130927113134)20130926151718)20130926094654)20130926094647)20130926094551)20130926094549  |iVC0 r_L9& )20131017144430)20131013131658)20131013123937)20131012163301)20131012123829)20131006144849)20131004193320)20131004185043)20131003163827)20131002162301)20131002155246)20131002154122)20130930181344)20130929203421)20130929151744)20130928201257)20130928193023)20130928180041)20130928173818 )20130928134518 )20130928131502 )20130928111819 )20130927150025 )20130927132143)20130927130022)20130927113134)20130926151718)20130926094654)20130926094647)20130926094551) 20130926094549            ) { ss c P ++Wtableshoppe_productsshoppe_productsCREATE TABLE "shoppe_products" ("id" INTEGER PRIMAq//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version") ??#tableshoppe_product_categoriesshoppe_product_categoriesCREATE TABLE "shoppe_product_categories" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "permalink" varchar(255), "description" text, "created_at" datetime, "updated_at" datetime)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)%%itableshoppe_usersshoppe_users CREATE TABLE "shoppe_users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "first_name" varchar(255), "last_name" varchar(255), "email_address" varchar(255), "password_digest" varchar(255), "created_at" datetime, "updated_at" datetime)P ++Wtableshoppe_productsshoppe_productsCREATE TABLE "shoppe_products" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "product_category_id" integer, "title" varchar(255), "sku" varchar(255), "permalink" varchar(255), "description" text, "short_description" text, "active" boolean DEFAULT 't', "weight" decimal(8,3) DEFAULT 0.0, "price" decimal(8,2) DEFAULT 0.0, "tax_rate" decimal(8,2) DEFAULT 0.0, "stock" integer DEFAULT 0, "created_at" datetime, "updated_at" datetime, "featured" boolean DEFAULT 'f', "in_the_box" text, "cost_price" decimal(8,2), "stock_control" boolean DEFAULT 't') 11Ctableshoppe_order_itemsshoppe_order_itemsCREATE TABLE "shoppe_order_items" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order_id" integer, "product_id" integer, "quantity" integer DEFAULT 1, "unit_prq//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version") ??#tableshoppe_product_categoriesshoppe_product_categoriesCREATE TABLE "shoppe_product_categories" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "permalink" varchar(255), "description" text, "created_at" datetime, "updated_at" datetime)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)%%itableshoppe_usersshoppe_users CREATE TABLE "shoppe_users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "first_name" varchar(255), "last_name" varchar(255), "email_address" varchar(255), "password_digest" varchar(255), "created_at" datetime, "updated_at" datetime)S++Wtableshoppe_productsshoppe_productsCREATE TABLE "shoppe_products" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "product_category_id" integer, "title" varchar(255), "sku" varchar(255), "permalink" varchar(255), "description" text, "short_description" text, "active" boolean DEFAULT 't', "weight" decimal(8,3) DEFAULT 0.0, "price" decimal(8,2) DEFAULT 0.0, "tax_rate" decimal(8,2) DEFAULT 0.0, "stock" integer DEFAULT 0, "created_at" datetime, "updated_at" datetime, "featured" boolean DEFAULT 'f', "in_the_box" text, "cost_price" decimal(8,2), "stock_control" boolean DEFAULT 't') 11Ctableshoppe_order_itemsshoppe_order_itemsCREATE TABLE "shoppe_order_items" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order_id" integer, "product_id" integer, "quantity" integer DEFAULT 1, "unit_price" decimal(8,2), "tax_amount" decimal(8,2), "tax_rate" decimal(8,2), "weight" decimal(8,3) DEFAULT 0.0, "created_at" datetime, "updated_at" datetime, "unit_cost_price" decimal(8,2)) IItableshoppe_delivery_service_pricesshoppe_delivery_service_prices CREATE TABLE "shoppe_delivery_service_prices" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "delivery_service_id" integer, "code" varchar(255), "price" decimal(8,2), "tax_rate" decimal(8,2), "min_weight" decimal(8,2), "max_weight" decimal(8,2), "created_at" datetime, "updated_at" datetime, "cost_price" decimal(8,2))  n <S++Wtableshoppe_produ5++!tableshoppe_productsshoppe_productsCREATE TABLE "shoppe_products" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "product_category_id" integer, "title" varchar(255), "sku" varchar(255), "permalink" varchar(255), "description" text, "short_description" text, "active" boolean DEFAULT 't', "weight" decimal(8,3) DEFAULT 0.0, "price" decimal(8,2) DEFAULT 0.0, "tax_rate" decimal(8,2) DEFAULT 0.0, "created_at" datetime, "updated_at" datetime, "featured" boolean DEFAULT 'f', "in_the_box" text, "cost_price" decimal(8,2), "stock_control" boolean DEFAULT 't')`==Stableshoppe_delivery_servicesshoppe_delivery_services CREATE TABLE "shoppe_delivery_services" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "code" varchar(255), "default" boolean DEFAULT 'f', "active" boolean DEFAULT 't', "created_at" datetime, "updated_at" datetime, "courier" varchar(255), "tracking_url" varchar(255))K''Utableshoppe_ordersshoppe_ordersCREATE TABLE "shoppe_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "company" varchar(255), "address1" varchar(255), "address2" varchar(255), "address3" varchar(255), "address4" varchar(255), "postcode" varchar(255), "email_address" varchar(255), "phone_number" varchar(255), "status" varchar(255), "received_at" datetime, "accepted_at" datetime, "shipped_at" datetime, "created_at" datetime, "updated_at" datetime, "delivery_service_id" integer, "delivery_price" decimal(8,2), "delivery_tax_rate" decimal(8,2), "delivery_tax_amount" decimal(8,2), "paid_at" datetime, "accepted_by" integer, "shipped_by" integer, "consignment_number" varchar(255), "rejected_at" datetime, "rejected_by" integer, "ip_address" varchar(255), "country" varchar(255), "payment_reference" varchar(255), "payment_method" varchar(255), "delivery_cost_price" decimal(8,2))e??Ytableshoppe_product_attributesshoppe_product_attributes CREATE TABLE "shoppe_product_attributes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "product_id" integer, "key" varchar(255), "value" varchar(255), "position" integer DEFAULT 1, "searchable" boolean DEFAULT 't', "created_at" datetime, "updated_at" datetime, "public" boolean DEFAULT 't')YII-tableshoppe_stock_level_adjustmentsshoppe_stock_level_adjustments CREATE TABLE "shoppe_stock_level_adjustments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "product_id" integer, "description" varchar(255), "adjustment" integer DEFAULT 0, "parent_type" varchar(255), "parent_id" integer, "created_at" datetime, "updated_at" datetime)