From 0170069575c7b4cc8bb39515c3efc487decbcc4a Mon Sep 17 00:00:00 2001 From: WubTheCaptain Date: Sun, 20 Sep 2015 07:37:36 +0000 Subject: Remove moe panel tables from core database schema Accounts, invites and reports are not used in the core. These will be moved to pomf-moe repository. You don't need it anymore. While the change of `orginalname` to `originalname` is good to mention, it is better served in the documentantion for those who are upgrading instead of laying around useless here in this code repository. OK pantsucat --- schema.sql | 40 ---------------------------------------- 1 file changed, 40 deletions(-) (limited to 'schema.sql') diff --git a/schema.sql b/schema.sql index a640e6d..f668c5e 100644 --- a/schema.sql +++ b/schema.sql @@ -2,18 +2,6 @@ -- -- Host: localhost Database: pomf --- --- Table structure for table `accounts` --- - -CREATE TABLE `accounts` ( - `id` int(10) unsigned NOT NULL auto_increment, - `email` varchar(255) NOT NULL, - `pass` varchar(255) NOT NULL, - `level` int(11) NOT NULL, - PRIMARY KEY (`id`) -) ENGINE=InnoDB; - -- -- Table structure for table `files` -- @@ -35,33 +23,5 @@ CREATE TABLE `files` ( -- [6 for the name + the file extension length], but since there is no limit for the file -- extension length (at the moment, at least) let's keep it high in order to avoid problems --- --- Table structure for table `invites` --- - -CREATE TABLE `invites` ( - `id` int(10) unsigned NOT NULL auto_increment, - `email` varchar(50) default '0', - `code` varchar(50) default '0', - `used` int(11) default '0', - `level` int(11) default NULL, - PRIMARY KEY (`id`) -) ENGINE=InnoDB; - --- --- Table structure for table `reports` --- - -CREATE TABLE `reports` ( - `id` int(10) unsigned NOT NULL auto_increment, - `hash` char(40) default '0', - `date` date default NULL, - `file` varchar(255) NOT NULL default '0', - `fileid` int(11) default '0', - `reporter` varchar(255) NOT NULL default '0', - `status` int(11) default '0', - PRIMARY KEY (`id`) -) ENGINE=InnoDB; - -- Dump completed on 2014-12-07 19:30:13 -- cgit v1.2.3