update.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
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;