summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-rw-r--r--db.sql10
1 files changed, 5 insertions, 5 deletions
diff --git a/db.sql b/db.sql
index 10cc76607..fc2c191ea 100644
--- a/db.sql
+++ b/db.sql
@@ -1,12 +1,12 @@
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
CREATE TABLE IF NOT EXISTS `files` (
- `hash` varchar(32) COLLATE utf8_bin NOT NULL,
- `id` varchar(8) COLLATE utf8_bin NOT NULL,
+ `hash` varchar(32) CHARACTER SET ascii NOT NULL,
+ `id` varchar(6) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
`filename` varchar(256) COLLATE utf8_bin NOT NULL,
- `password` varchar(40) COLLATE utf8_bin DEFAULT NULL,
- `date` int(11) NOT NULL,
- `mimetype` varchar(255) COLLATE utf8_bin NOT NULL,
+ `password` varchar(40) CHARACTER SET ascii COLLATE ascii_bin DEFAULT NULL,
+ `date` int(11) unsigned NOT NULL,
+ `mimetype` varchar(255) CHARACTER SET ascii NOT NULL,
PRIMARY KEY (`id`),
KEY `date` (`date`),
KEY `hash` (`hash`,`id`)