Sqlite sakila database

readme

sqlite3
.read schema.sql
.read insert.sql
.tables
.schema
.save sakila.db
.quit


SELECT name FROM sqlite_master WHERE type='table' ORDER BY name;

.mode line
.mode column
.headers on

PRAGMA table_info(table_name);





#
# Creating Tables
#

CREATE TABLE account(
    user_id serial PRIMARY KEY,
    username VARCHAR(50) UNIQUE NOT NULL,
    password VARCHAR(50) NOT NULL,
    email VARCHAR(355) UNIQUE NOT NULL,
    created_on TIMESTAMP NOT NULL,
    last_login TIMESTAMP
);


CREATE TABLE role(
    role_id serial PRIMARY KEY,
    role_name VARCHAR(255) UNIQUE NOT NULL
);

sakila.db

sqlite-sakila-delete-data.sql

sqlite-sakila-drop-objects.sql

sqlite-sakila-insert-data.sql

sqlite-sakila-schema.sql