diff options
| -rw-r--r-- | schema.sql | 40 | ||||
| -rwxr-xr-x | update.sql | 16 |
2 files changed, 0 insertions, 56 deletions
@@ -3,18 +3,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 diff --git a/update.sql b/update.sql deleted file mode 100755 index 263718e..0000000 --- a/update.sql +++ /dev/null @@ -1,16 +0,0 @@ -ALTER TABLE `accounts`
-CHANGE COLUMN `id` `id` int(10) unsigned NOT NULL auto_increment;
-
-ALTER TABLE `files`
-CHANGE COLUMN `id` `id` int(10) unsigned NOT NULL auto_increment,
-CHANGE COLUMN `originalname` `originalname` varchar(255) NULL default NULL,
-CHANGE COLUMN `size` `size` int(10) NULL default NULL,
-CHANGE COLUMN `user` `user` int(10) NULL default '0';
-
-ALTER TABLE `invites`
-CHANGE COLUMN `id` `id` int(10) unsigned NOT NULL auto_increment;
-
-ALTER TABLE `reports`
-CHANGE COLUMN `id` `id` int(10) unsigned NOT NULL auto_increment,
-CHANGE COLUMN `file` `file` varchar(255) NOT NULL,
-CHANGE COLUMN `reporter` `reporter` varchar(255) NOT NULL;
|
