/*ALIAS>prop_db*/

/*SQLStart>1750*/
CREATE TABLE DISTRICT_KL (
    DISTRICT_ID INTEGER NOT NULL,
    DISTRICT_TEXT VARCHAR(100));
/*SQLStop*/

/*SQLStart>1751*/
alter table DISTRICT_KL
add constraint PK_DISTRICT_KL
primary key (DISTRICT_ID);
/*SQLStop*/

/*SQLStart>1752*/
GRANT ALL ON DISTRICT_KL TO PUBLIC;
/*SQLStop*/

/*SQLStart>1753*/
CREATE TABLE ACT_KL (
    ACT_ID INTEGER NOT NULL,
    ACT_TEXT VARCHAR(100));
/*SQLStop*/

/*SQLStart>1754*/
alter table ACT_KL
add constraint PK_ACT_KL
primary key (ACT_ID);
/*SQLStop*/

/*SQLStart>1755*/
GRANT ALL ON ACT_KL TO PUBLIC;
/*SQLStop*/

/*SQLStart>1756*/
ALTER TABLE IMOT
    ADD IM_DISTRICT INTEGER;
/*SQLStop*/

/*SQLStart>1757*/
ALTER TABLE ASSETS
    ADD ASSET_CONTROLNUMBER VARCHAR(100),
    ADD ASSET_CONTROLNUMBEROLD VARCHAR(100),
	ADD ASSET_ACT VARCHAR(100),
	ADD ASSET_ACTDATE date,
	ADD ASSET_ACTTYPE integer,
	ADD ASSET_ZKIR VARCHAR(100);
/*SQLStop*/

/*ManyStart>1758*/
update system_strings set sys_str = '6.1.6.27' where sys_id = 1402;  /*Imot*/
update system_strings set sys_str = '2.1.12.27' where sys_id = 1401;      /*Kasa*/
update system_strings set sys_str = '2.1.1.1' where sys_id = 1403;      /*Incomes*/
insert into system_strings(sys_id, sys_str) values(1404, '6.1.7.37');      /*Rents*/
/*ManyStop*/