diff options
Diffstat (limited to 'update.sql')
| -rwxr-xr-x | update.sql | 16 |
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 |
