CREATE TABLE `fias_city_map` (
	`id` INT(11) NOT NULL AUTO_INCREMENT,
	`code` VARCHAR(20) NOT NULL COLLATE 'utf8_unicode_ci',
	`aoguid` VARCHAR(100) NOT NULL COLLATE 'utf8_unicode_ci',
	`level` VARCHAR(5) NOT NULL COLLATE 'utf8_unicode_ci',
	`shortname` VARCHAR(100) NOT NULL COLLATE 'utf8_unicode_ci',
	`offname` VARCHAR(100) NOT NULL COLLATE 'utf8_unicode_ci',
	`postalcode` VARCHAR(10) NOT NULL COLLATE 'utf8_unicode_ci',
	PRIMARY KEY (`id`)
);
CREATE TABLE `fias_street_map` (
	`id` INT(11) NOT NULL AUTO_INCREMENT,
	`code` VARCHAR(20) NOT NULL COLLATE 'utf8_unicode_ci',
	`aoguid` VARCHAR(100) NOT NULL COLLATE 'utf8_unicode_ci',
	`level` VARCHAR(5) NOT NULL COLLATE 'utf8_unicode_ci',
	`shortname` VARCHAR(100) NOT NULL COLLATE 'utf8_unicode_ci',
	`offname` VARCHAR(100) NOT NULL COLLATE 'utf8_unicode_ci',
	`postalcode` VARCHAR(10) NOT NULL COLLATE 'utf8_unicode_ci',
	PRIMARY KEY (`id`),
	INDEX offname (offname)
);
CREATE TABLE `fias_house_map` (
	`id` INT(11) NOT NULL AUTO_INCREMENT,
	`aoguid` VARCHAR(100) NOT NULL COLLATE 'utf8_unicode_ci',
	`houseguid` VARCHAR(100) NOT NULL COLLATE 'utf8_unicode_ci',
	`housenum` VARCHAR(20) NOT NULL COLLATE 'utf8_unicode_ci',
	`buildnum` VARCHAR(20) NOT NULL COLLATE 'utf8_unicode_ci',
	`structnum` VARCHAR(100) NOT NULL COLLATE 'utf8_unicode_ci',
	PRIMARY KEY (`id`),
	INDEX aoguid (aoguid),
	INDEX houseguid (houseguid),
	INDEX housenum (housenum),
);

ALTER TABLE `fias_street_map`
	ADD COLUMN `region` VARCHAR(2) NOT NULL AFTER `postalcode`;
ALTER TABLE `fias_street_map`
	ADD COLUMN `status` INT NOT NULL DEFAULT '-1' AFTER `region`;

ALTER TABLE `fias_city_map`
	ADD COLUMN `region` VARCHAR(2) NOT NULL AFTER `postalcode`;
	
ALTER TABLE `fias_house_map`
	ALTER `structnum` DROP DEFAULT;
ALTER TABLE `fias_house_map`
	CHANGE COLUMN `structnum` `strucnum` VARCHAR(100) NOT NULL COLLATE 'utf8_unicode_ci' AFTER `buildnum`;

ALTER TABLE `fias_city_map` ADD COLUMN `parentguid` VARCHAR(100) NOT NULL ;
ALTER TABLE `fias_street_map` ADD COLUMN `parentguid` VARCHAR(100) NOT NULL ;
ALTER TABLE `fias_city_map` DROP PRIMARY KEY, ADD PRIMARY KEY (`id`, `code`);

ALTER TABLE `fias_house_map` ADD COLUMN `eststatus` VARCHAR(100) NOT NULL ;
ALTER TABLE `fias_house_map` ADD COLUMN `strstatus` VARCHAR(100) NOT NULL ;

-- события
-- #BLOCK#
DELETE FROM script_event_type WHERE mid="p$mid";
INSERT INTO script_event_type (mid, event_id, event_mode, title) VALUES ('p$mid', 'ru.bitel.bgbilling.plugins.fias.server.bean.FiasGetAbonentLocationFind', 0, 'Изменение номера поиска и ответа');
-- #ENDB#
