Merge pull request #27 from cenci0/master

Minor code refactoring and improvements

1 files changed, 16 insertions, 0 deletions

diff --git a/update.sql b/update.sql
new file mode 100755
index 0000000..ac4d548
--- /dev/null
+++ b/update.sql
@@ -0,0 +1,16 @@
+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 `orginalname` `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;
\ No newline at end of file