gistfile1.txt

CREATE TABLE IF NOT EXISTS "menu" (
	"id"	INTEGER NOT NULL unsigned bigint PRIMARY KEY AUTOINCREMENT,
	"name"	TEXT NOT NULL,
	"cn"	TEXT NOT NULL
);
CREATE UNIQUE INDEX "menu.name" ON "menu" (
	"name"
);
CREATE TABLE IF NOT EXISTS "kind" (
	"id"	INTEGER NOT NULL unsigned bigint PRIMARY KEY AUTOINCREMENT,
	"url"	TEXT NOT NULL UNIQUE,
	"menu_id"	INTEGER NOT NULL,
	"name"	TEXT NOT NULL,
	"cn"	TEXT NOT NULL
);
CREATE TABLE IF NOT EXISTS "goods_kind" (
	"id"	INTEGER NOT NULL unsigned bigint PRIMARY KEY AUTOINCREMENT,
	"goods_id"	INTEGER NOT NULL,
	"kind_id"	INTEGER NOT NULL
);
CREATE UNIQUE INDEX "goods_kind.kind_id.goods_id" ON "goods_kind" (
	"kind_id",
	"goods_id"
);
CREATE TABLE IF NOT EXISTS "size" (
	"id"	INTEGER unsigned bigint PRIMARY KEY AUTOINCREMENT,
	"val"	INTEGER NOT NULL UNIQUE
);
CREATE TABLE IF NOT EXISTS "color" (
	"id"	INTEGER NOT NULL unsigned bigint PRIMARY KEY AUTOINCREMENT,
	"val"	TEXT UNIQUE
);
CREATE TABLE IF NOT EXISTS "brand" (
	"id"	INTEGER NOT NULL unsigned bigint PRIMARY KEY AUTOINCREMENT,
	"val"	TEXT UNIQUE
);
CREATE TABLE IF NOT EXISTS "goods_size" (
	"id"	INTEGER unsigned bigint PRIMARY KEY AUTOINCREMENT,
	"goods_id"	INTEGER NOT NULL,
	"size_id"	INTEGER NOT NULL
);
CREATE UNIQUE INDEX "good_size.size_id.goods_id" ON "goods_size" (
	"size_id",
	"goods_id"
);
CREATE TABLE style (
	"id"	INTEGER NOT NULL unsigned bigint PRIMARY KEY AUTOINCREMENT,
	"val"	TEXT UNIQUE
);
CREATE TABLE IF NOT EXISTS "cat" (
	"id"	INTEGER NOT NULL unsigned bigint PRIMARY KEY AUTOINCREMENT,
	"up_id"	INTEGER NOT NULL,
	"name"	TEXT NOT NULL,
	"url"	TEXT NOT NULL
);
CREATE TABLE IF NOT EXISTS "goods" (
	"id"	INTEGER NOT NULL unsigned bigint PRIMARY KEY AUTOINCREMENT,
	"name"	INTEGER NOT NULL,
	"url"	INTEGER NOT NULL,
	"img"	INTEGER NOT NULL,
	"is_on_sale"	INTEGER NOT NULL,
	"supplier_id"	INTEGER NOT NULL,
	"brand_id"	INTEGER NOT NULL,
	"color_id"	INTEGER NOT NULL,
	"sn"	TEXT NOT NULL,
	"style_id"	INTEGER NOT NULL,
	"color_img"	TEXT NOT NULL,
	"cat_id"	INTEGER NOT NULL,
	"comment"	INTEGER NOT NULL DEFAULT 0,
	"price_show"	INTEGER NOT NULL,
	"price_sale"	INTEGER NOT NULL,
	"stock"	INTEGER NOT NULL,
	"date"	INTEGER NOT NULL
);