łeeee

ALTER TABLE players ADD gang_id int(11) NOT NULL DEFAULT '-1';
ALTER TABLE players ADD gang_perm_id int(11) NOT NULL DEFAULT '-1';

ALTER TABLE gangs ADD level int(2) NOT NULL DEFAULT '1';
ALTER TABLE gangs ADD tag varchar(50) NOT NULL DEFAULT '';
ALTER TABLE gangs ADD description text NOT NULL;
ALTER TABLE gangs ADD hq int(11) NOT NULL DEFAULT '-1';
ALTER TABLE gangs ADD hq_upgrades text NOT NULL;
ALTER TABLE gangs ADD permission text NOT NULL;
ALTER TABLE gangs ADD tax int(100) NOT NULL DEFAULT '0';
ALTER TABLE gangs ADD `type` tinyint(1) NOT NULL DEFAULT '0';
ALTER TABLE gangs ADD perm_int int(11) NOT NULL DEFAULT '1';
ALTER TABLE gangs ADD tax_sum int(11) NOT NULL DEFAULT '0';
ALTER TABLE gangs ADD hq_garage varchar(100) NOT NULL DEFAULT '[]';

UPDATE gangs SET `type`= 1;
UPDATE gangs SET `description`='""';
UPDATE gangs SET `hq_upgrades`='"[]"';
UPDATE gangs SET `permission`='"[[0,`Owner`,[`INVITE`,`KICK`,`HQ`,`DEPOSIT`,`PAYTAX`,`HQSPAWN`,`RANKS`,`WITHDRAW`,`DESCRIPTION`,`TAX`,`DISBAND`,`UPGRADE`,`CHANGEPERMISSION`,`TAG`]],[1,`Member`,[`HQSPAWN`,`PAYTAX`,`DEPOSIT`]]]"';
UPDATE players P, gangs G SET P.gang_id=G.id, P.gang_perm_id=0 WHERE P.pid = G.owner;

ALTER TABLE gangs DROP COLUMN members;
ALTER TABLE gangs DROP COLUMN maxmembers;
ALTER TABLE gangs DROP INDEX name_UNIQUE;


CREATE TABLE IF NOT EXISTS `gang_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `value` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=latin1;


INSERT INTO `gang_info` (`id`, `name`, `value`) VALUES
	(1, 'hideout1', -1),
	(2, 'hideout2', -1),
	(3, 'hideout3', -1);

DELIMITER //
CREATE DEFINER=CURRENT_USER PROCEDURE `deactivateTempGangs`()
BEGIN
	UPDATE `gangs` SET `active`= 0 WHERE `type`='0';
END//
DELIMITER ;