hpr_generator/_sql/sqlite/Create_Table_miniseries.sql

11 lines
243 B
SQL

-- miniseries definition
CREATE TABLE miniseries (
id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
name VARCHAR(100) NOT NULL,
description TEXT NOT NULL,
private INTEGER NOT NULL,
image TEXT NOT NULL,
valid INTEGER DEFAULT 1 NOT NULL
);