diff options
| author | Benjamin Southall <applemansigloo@gmail.com> | 2017-04-17 03:15:59 +0900 |
|---|---|---|
| committer | Benjamin Southall <applemansigloo@gmail.com> | 2017-04-17 03:15:59 +0900 |
| commit | 8a5850aa117f3664b0ce66865a02307d43a31873 (patch) | |
| tree | 0051c68d30f08f56664bfc0d8abc65502e7a77a4 | |
| parent | 9016ab6db9ef6b07671537c64bcf501b8ed4cc11 (diff) | |
Invalid unique key in install.sql #93 Reduced board and name varchar length to 125 (1000/8 = 125) 2 columns , 4 bytes each column in pages table schema.
| -rw-r--r-- | install.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/install.sql b/install.sql index 3b390645..8edc568b 100644 --- a/install.sql +++ b/install.sql @@ -305,8 +305,8 @@ CREATE TABLE IF NOT EXISTS `ban_appeals` ( CREATE TABLE `pages` ( `id` int(11) NOT NULL AUTO_INCREMENT, - `board` varchar(255) DEFAULT NULL, - `name` varchar(255) NOT NULL, + `board` varchar(125) DEFAULT NULL, + `name` varchar(125) NOT NULL, `title` varchar(255) DEFAULT NULL, `type` varchar(255) DEFAULT NULL, `content` text, |