From e4ee81d800a08a5839dcfeeb3441f2f0b4247a6f Mon Sep 17 00:00:00 2001 From: Florian Pritz Date: Sat, 17 Dec 2011 12:06:24 +0100 Subject: use migrations; automatically set up the database Signed-off-by: Florian Pritz --- db.sql | 13 ------------- 1 file changed, 13 deletions(-) delete mode 100644 db.sql (limited to 'db.sql') diff --git a/db.sql b/db.sql deleted file mode 100644 index fc2c191ea..000000000 --- a/db.sql +++ /dev/null @@ -1,13 +0,0 @@ -SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; - -CREATE TABLE IF NOT EXISTS `files` ( - `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) 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`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- cgit v1.2.3-24-g4f1b