aboutsummaryrefslogtreecommitdiff
path: root/tables.sql
blob: 7cd726801f76eed605798bf84245fa3c8a7ce893 (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
set global innodb_large_prefix = ON;

CREATE TABLE IF NOT EXISTS theme(
    id INTEGER PRIMARY KEY AUTO_INCREMENT,
    main VARCHAR(255) NOT NULL,
    description VARCHAR(255) NOT NULL,
    votes INTEGER DEFAULT FALSE,
    hidden BOOLEAN DEFAULT FALSE,

    UNIQUE KEY main (main, description)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;