diff options
| author | Florian Pritz <bluewind@xinu.at> | 2011-12-17 12:06:24 +0100 |
|---|---|---|
| committer | Florian Pritz <bluewind@xinu.at> | 2011-12-17 12:07:57 +0100 |
| commit | e4ee81d800a08a5839dcfeeb3441f2f0b4247a6f (patch) | |
| tree | e4f3740e00f1cdbe08b6c451a72b3c6cf60f209e /db.sql | |
| parent | b11b171bc8054d0734176527d80415227502a37d (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.sql | 13 |
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; |