-----------------------------------------------------------------------------
-- article
-----------------------------------------------------------------------------

DROP TABLE [article];


CREATE TABLE [article]
(
	[id] INTEGER  NOT NULL PRIMARY KEY,
	[title] VARCHAR(255)  NOT NULL,
	[body] MEDIUMTEXT,
	[Online] INTEGER,
	[excerpt] VARCHAR,
	[category_id] INTEGER  NOT NULL,
	[created_at] TIMESTAMP,
	[end_date] TIMESTAMP,
	[book_id] INTEGER,
	UNIQUE ([title],[category_id])
);

-- SQLite does not support foreign keys; this is just for reference
-- FOREIGN KEY ([category_id]) REFERENCES category ([id])

-- SQLite does not support foreign keys; this is just for reference
-- FOREIGN KEY ([book_id]) REFERENCES book ([id])

-----------------------------------------------------------------------------
-- category
-----------------------------------------------------------------------------

DROP TABLE [category];


CREATE TABLE [category]
(
	[id] INTEGER  NOT NULL PRIMARY KEY,
	[name] VARCHAR(255),
	UNIQUE ([name]),
	UNIQUE ([name])
);

-----------------------------------------------------------------------------
-- book
-----------------------------------------------------------------------------

DROP TABLE [book];


CREATE TABLE [book]
(
	[id] INTEGER  NOT NULL PRIMARY KEY,
	[name] VARCHAR(255)
);

-----------------------------------------------------------------------------
-- author
-----------------------------------------------------------------------------

DROP TABLE [author];


CREATE TABLE [author]
(
	[id] INTEGER  NOT NULL PRIMARY KEY,
	[name] VARCHAR(255)
);

-----------------------------------------------------------------------------
-- author_article
-----------------------------------------------------------------------------

DROP TABLE [author_article];


CREATE TABLE [author_article]
(
	[author_id] INTEGER  NOT NULL,
	[article_id] INTEGER  NOT NULL
);

-- SQLite does not support foreign keys; this is just for reference
-- FOREIGN KEY ([author_id]) REFERENCES author ([id])

-- SQLite does not support foreign keys; this is just for reference
-- FOREIGN KEY ([article_id]) REFERENCES article ([id])

-----------------------------------------------------------------------------
-- product
-----------------------------------------------------------------------------

DROP TABLE [product];


CREATE TABLE [product]
(
	[id] INTEGER  NOT NULL PRIMARY KEY,
	[price] FLOAT
);

-----------------------------------------------------------------------------
-- product_i18n
-----------------------------------------------------------------------------

DROP TABLE [product_i18n];


CREATE TABLE [product_i18n]
(
	[id] INTEGER  NOT NULL,
	[culture] VARCHAR(7)  NOT NULL,
	[name] VARCHAR(50)
);

-- SQLite does not support foreign keys; this is just for reference
-- FOREIGN KEY ([id]) REFERENCES product ([id])

-----------------------------------------------------------------------------
-- movie
-----------------------------------------------------------------------------

DROP TABLE [movie];


CREATE TABLE [movie]
(
	[id] INTEGER  NOT NULL PRIMARY KEY,
	[director] VARCHAR(255)
);

-----------------------------------------------------------------------------
-- movie_i18n
-----------------------------------------------------------------------------

DROP TABLE [movie_i18n];


CREATE TABLE [movie_i18n]
(
	[id] INTEGER  NOT NULL,
	[culture] VARCHAR(7)  NOT NULL,
	[title] VARCHAR
);

-- SQLite does not support foreign keys; this is just for reference
-- FOREIGN KEY ([id]) REFERENCES movie ([id])

-----------------------------------------------------------------------------
-- attachment
-----------------------------------------------------------------------------

DROP TABLE [attachment];


CREATE TABLE [attachment]
(
	[id] INTEGER  NOT NULL PRIMARY KEY,
	[article_id] INTEGER,
	[name] VARCHAR(255),
	[file] VARCHAR(255)
);

-- SQLite does not support foreign keys; this is just for reference
-- FOREIGN KEY ([article_id]) REFERENCES article ([id])