diff options
| -rw-r--r-- | db.sql | 10 |
1 files changed, 5 insertions, 5 deletions
@@ -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`) |