summaryrefslogtreecommitdiffstats
path: root/db.sql
diff options
context:
space:
mode:
authorFlorian Pritz <bluewind@xinu.at>2011-12-17 12:06:24 +0100
committerFlorian Pritz <bluewind@xinu.at>2011-12-17 12:07:57 +0100
commite4ee81d800a08a5839dcfeeb3441f2f0b4247a6f (patch)
treee4f3740e00f1cdbe08b6c451a72b3c6cf60f209e /db.sql
parentb11b171bc8054d0734176527d80415227502a37d (diff)
use migrations; automatically set up the database
Signed-off-by: Florian Pritz <bluewind@xinu.at>
Diffstat (limited to 'db.sql')
-rw-r--r--db.sql13
1 files changed, 0 insertions, 13 deletions
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;