SQLite – шаблон базы данных для парсинга поставщика

CREATE TABLE "products" (
	"row_id"	INTEGER NOT NULL,
	"url"	TEXT,
	"breadcrumbs"	TEXT,
	"sku"	TEXT,
	"name"	TEXT,
	"price"	INTEGER,
	"sale_price"	INTEGER,
	"description"	TEXT,
	PRIMARY KEY("row_id" AUTOINCREMENT)
);

CREATE TABLE "params" (
	"row_id"	INTEGER NOT NULL,
	"sku"	TEXT,
	"name"	TEXT,
	"value"	TEXT,
	PRIMARY KEY("row_id" AUTOINCREMENT)
);

CREATE TABLE "images" (
	"row_id"	INTEGER NOT NULL,
	"sku"	TEXT,
	"image_url"	TEXT,
	"position"	INTEGER,
	"download"	TEXT,
	PRIMARY KEY("row_id" AUTOINCREMENT)
);