diff options
| author | Marvin Borner | 2020-09-30 21:01:13 +0200 |
|---|---|---|
| committer | Marvin Borner | 2020-09-30 21:01:13 +0200 |
| commit | 3491013c43775401b5e87f97c09d906de5bafbc9 (patch) | |
| tree | 7b89937837aa74360d2b06ce5cb1a4684abf927a /tables.sql | |
| parent | 5273769235456e69f6dbde60a63a5a9a7f2ee345 (diff) | |
Lars is dumb
Diffstat (limited to 'tables.sql')
| -rw-r--r-- | tables.sql | 12 |
1 files changed, 8 insertions, 4 deletions
@@ -1,7 +1,11 @@ +set global innodb_large_prefix = ON; + CREATE TABLE IF NOT EXISTS theme( id INTEGER PRIMARY KEY AUTO_INCREMENT, - main TEXT NOT NULL UNIQUE, - description TEXT NOT NULL UNIQUE, + main VARCHAR(255) NOT NULL, + description VARCHAR(255) NOT NULL, votes INTEGER DEFAULT FALSE, - hidden BOOLEAN DEFAULT FALSE -); + hidden BOOLEAN DEFAULT FALSE, + + UNIQUE KEY main (main, description) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; |