DROP TABLE IF EXISTS film;
CREATE TABLE film (
title TEXT NOT NULL,
rating TEXT,
privileges INT NOT NULL
);
INSERT INTO film(title, rating, privileges) VALUES
('ATTRACTION NEWTON', 'PG-13', 1), -- Free users
('CHRISTMAS MOONSHINE', 'NC-17', 2), -- Premium users
('DANGEROUS UPTOWN', 'PG', 3), -- Free + Premium users (bits 0 and 1)
('KILL BROTHERHOOD', 'G', 4), -- Admin-only content
('HALLOWEEN NUTS', 'PG-13', 1),
('HOURS RAGE', 'NC-17', 2),
('PIANIST OUTFIELD', 'NC-17', 3),
('PICKUP DRIVING', 'G', 4),
('INDEPENDENCE HOTEL', 'NC-17', 1),
('PRIVATE DROP', 'PG', 2),
('SAINTS BRIDE', 'G', 3),
('FOREVER CANDIDATE', 'NC-17', 4),
('MILLION ACE', 'PG-13', 1),
('SLEEPY JAPANESE', 'PG', 2),
('WRATH MILE', 'NC-17', 3),
('YOUTH KICK', 'NC-17', 4),
('CLOCKWORK PARADISE', 'PG-13', 1);