commento/db/20180922181651-page-attributes.sql

10 lines
352 B
MySQL
Raw Permalink Normal View History

-- Introduces page attributes
CREATE TABLE IF NOT EXISTS pages (
domain TEXT NOT NULL ,
path TEXT NOT NULL ,
isLocked BOOLEAN NOT NULL DEFAULT false
);
CREATE UNIQUE INDEX pagesUniqueIndex ON pages(domain, path);