DROP TABLE L_NODE_HIER_VIEW cascade constraints
DROP TABLE PADR.sadr cascade constraints
DROP TABLE PADR.sadr_address cascade constraints
DROP TABLE PADR.sadr_country cascade constraints
DROP TABLE PADR.sadr_region cascade constraints
DROP TABLE PADR.sadr_street cascade constraints
DROP TABLE PADR.sadr_town cascade constraints
DROP TABLE PADR.sadr_town_distr cascade constraints
DROP TABLE PADR.sadr_town_part cascade constraints
DROP TABLE adr_address cascade constraints
DROP TABLE adr_region cascade constraints
DROP TABLE adr_street cascade constraints
DROP TABLE adr_town cascade constraints
DROP TABLE adr_town_distr cascade constraints
DROP TABLE adr_town_part cascade constraints
DROP TABLE l_locality cascade constraints
DROP TABLE l_node cascade constraints
DROP TABLE l_node_hier cascade constraints
DROP TABLE l_object cascade constraints
DROP TABLE l_room cascade constraints
DROP TABLE l_user cascade constraints
DROP sequence adr_address_gts_seq
DROP sequence adr_region_gts_seq
DROP sequence adr_street_gts_seq
DROP sequence adr_town_distr_gts_seq
DROP sequence adr_town_gts_seq
DROP sequence adr_town_part_gts_seq
DROP sequence l_node_seq
CREATE TABLE L_NODE_HIER_VIEW (ID varchar2(255) NOT NULL, LOC_ID varchar2(255), LOC_NAME varchar2(255), LOC_TYPE varchar2(255), BUILD_ID number(10,0), BUILD_NAME varchar2(255), BUILD_TYPE varchar2(255), ROOM_ID number(10,0), ROOM_NAME varchar2(255), ROOM_TYPE varchar2(255), PRIMARY KEY (ID))
CREATE TABLE PADR.sadr (id number(19,0) NOT NULL, source char(1) NOT NULL, txt varchar2(250), PRIMARY KEY (id, source))
CREATE TABLE PADR.sadr_address (id number(19,0) NOT NULL, source char(1) NOT NULL, num_orient varchar2(20), num_descr number(19,0), zip varchar2(20), lon varchar2(20), lat varchar2(20), street_id number(19,0), street_source char(1), town_distr_id number(19,0), town_distr_source char(1), town_part_id number(19,0), town_part_source char(1), PRIMARY KEY (id, source))
CREATE TABLE PADR.sadr_country (ID number(19,0) NOT NULL, NAME varchar2(50), PRIMARY KEY (ID))
CREATE TABLE PADR.sadr_region (id number(19,0) NOT NULL, source char(1) NOT NULL, NAME varchar2(50), country_id number(19,0), PRIMARY KEY (id, source))
CREATE TABLE PADR.sadr_street (id number(19,0) NOT NULL, source char(1) NOT NULL, NAME varchar2(50), town_id number(19,0), town_source char(1), PRIMARY KEY (id, source))
CREATE TABLE PADR.sadr_town (id number(19,0) NOT NULL, source char(1) NOT NULL, NAME varchar2(50), region_id number(19,0), region_source char(1), PRIMARY KEY (id, source))
CREATE TABLE PADR.sadr_town_distr (id number(19,0) NOT NULL, source char(1) NOT NULL, NAME varchar2(50), town_id number(19,0), town_source char(1), PRIMARY KEY (id, source))
CREATE TABLE PADR.sadr_town_part (id number(19,0) NOT NULL, source char(1) NOT NULL, NAME varchar2(50), town_id number(19,0), town_source char(1), PRIMARY KEY (id, source))
CREATE TABLE adr_address (ID number(19,0) NOT NULL, num_orient varchar2(20), num_descr number(19,0), zip varchar2(20), lon varchar2(255), lat varchar2(255), street_id number(19,0), street_source char(1), town_part_id number(19,0), town_part_source char(1), town_distr_id number(19,0), town_distr_source char(1), source char(1), source_id number(19,0), BUILDING_ID number(19,0), PRIMARY KEY (ID))
CREATE TABLE adr_region (ID number(19,0) NOT NULL, NAME varchar2(50), country_id number(19,0) NOT NULL, source char(1), source_id number(19,0), PRIMARY KEY (ID))
CREATE TABLE adr_street (ID number(19,0) NOT NULL, NAME varchar2(50), town_id number(19,0), town_source char(1), source char(1), source_id number(19,0), PRIMARY KEY (ID))
CREATE TABLE adr_town (ID number(19,0) NOT NULL, NAME varchar2(50), region_id number(19,0), region_source char(1), source char(1), source_id number(19,0), PRIMARY KEY (ID))
CREATE TABLE adr_town_distr (ID number(19,0) NOT NULL, NAME varchar2(255), town_id number(19,0), town_source char(1), source char(1), source_id number(19,0), PRIMARY KEY (ID))
CREATE TABLE adr_town_part (ID number(19,0) NOT NULL, NAME varchar2(50), town_id number(19,0), town_source char(1), source char(1), source_id number(19,0), PRIMARY KEY (ID))
CREATE TABLE l_locality (node_id number(19,0) NOT NULL, PRESENTABLE_ADDRESS_ID number(19,0), PRIMARY KEY (node_id))
CREATE TABLE l_node (node_id number(19,0) NOT NULL, node_type char(1) NOT NULL, node_name varchar2(64) NOT NULL, node_tl varchar2(32) NOT NULL, x number(19,0), y number(19,0), COUNTRY_ID number(19,0) NOT NULL, PRIMARY KEY (node_id))
CREATE TABLE l_node_hier (node_id_parent number(19,0) NOT NULL, node_id_child number(19,0) NOT NULL, PRIMARY KEY (node_id_parent, node_id_child))
CREATE TABLE l_object (node_id number(19,0) NOT NULL, type varchar2(255), PRIMARY KEY (node_id))
CREATE TABLE l_room (node_id number(19,0) NOT NULL, PRIMARY KEY (node_id))
CREATE TABLE l_user (node_id number(19,0) NOT NULL, phone varchar2(255), comp_num varchar2(255), apps varchar2(255), username varchar2(255), stype varchar2(255), ets varchar2(255), eveta varchar2(255), ptype varchar2(255), technology varchar2(255), speed varchar2(255), monitoring number(1,0), datum date, note varchar2(255), owner varchar2(255), port varchar2(255), vystav varchar2(255), PRIMARY KEY (node_id))
ALTER TABLE PADR.sadr_address ADD constraint FK9AC5E61165A53B8F FOREIGN KEY (street_id, street_source) REFERENCES PADR.sadr_street
ALTER TABLE PADR.sadr_address ADD constraint FK9AC5E6114D1176F7 FOREIGN KEY (town_part_id, town_part_source) REFERENCES PADR.sadr_town_part
ALTER TABLE PADR.sadr_address ADD constraint FK9AC5E611A07EC114 FOREIGN KEY (town_distr_id, town_distr_source) REFERENCES PADR.sadr_town_distr
ALTER TABLE PADR.sadr_address ADD constraint FK9AC5E611851DAFBD FOREIGN KEY (id, source) REFERENCES PADR.sadr
ALTER TABLE PADR.sadr_region ADD constraint FK949A537A23C8CDC FOREIGN KEY (country_id) REFERENCES PADR.sadr_country
ALTER TABLE PADR.sadr_street ADD constraint FKBD6CE4693C85340 FOREIGN KEY (town_id, town_source) REFERENCES PADR.sadr_town
ALTER TABLE PADR.sadr_town ADD constraint FK68F89D95DEE6B1DE FOREIGN KEY (region_id, region_source) REFERENCES PADR.sadr_region
ALTER TABLE PADR.sadr_town_distr ADD constraint FK731E646293C85340 FOREIGN KEY (town_id, town_source) REFERENCES PADR.sadr_town
ALTER TABLE PADR.sadr_town_part ADD constraint FK5E92B45D93C85340 FOREIGN KEY (town_id, town_source) REFERENCES PADR.sadr_town
ALTER TABLE adr_address ADD constraint FK25F89C6465A53B8F FOREIGN KEY (street_id, street_source) REFERENCES PADR.sadr_street
ALTER TABLE adr_address ADD constraint FK25F89C64A07EC114 FOREIGN KEY (town_distr_id, town_distr_source) REFERENCES PADR.sadr_town_distr
ALTER TABLE adr_address ADD constraint FK25F89C644D1176F7 FOREIGN KEY (town_part_id, town_part_source) REFERENCES PADR.sadr_town_part
ALTER TABLE adr_address ADD constraint FK25F89C6440515D50 FOREIGN KEY (BUILDING_ID) REFERENCES l_node
ALTER TABLE adr_region ADD constraint FK268D5884A23C8CDC FOREIGN KEY (country_id) REFERENCES PADR.sadr_country
ALTER TABLE adr_street ADD constraint FK291A819393C85340 FOREIGN KEY (town_id, town_source) REFERENCES PADR.sadr_town
ALTER TABLE adr_town ADD constraint FKCE3AC022DEE6B1DE FOREIGN KEY (region_id, region_source) REFERENCES PADR.sadr_region
ALTER TABLE adr_town_distr ADD constraint FK158DA92F93C85340 FOREIGN KEY (town_id, town_source) REFERENCES PADR.sadr_town
ALTER TABLE adr_town_part ADD constraint FKE7F121F093C85340 FOREIGN KEY (town_id, town_source) REFERENCES PADR.sadr_town
ALTER TABLE l_locality ADD constraint FK85ACE7D6D96341F1 FOREIGN KEY (node_id) REFERENCES l_node
ALTER TABLE l_locality ADD constraint FK85ACE7D6DEAD284E FOREIGN KEY (PRESENTABLE_ADDRESS_ID) REFERENCES adr_address
ALTER TABLE l_node ADD constraint FKBDB9C9F5A23C8CDC FOREIGN KEY (COUNTRY_ID) REFERENCES PADR.sadr_country
ALTER TABLE l_node_hier ADD constraint FK937ABD78C1CD2369 FOREIGN KEY (node_id_parent) REFERENCES l_node
ALTER TABLE l_node_hier ADD constraint FK937ABD7867C18BAD FOREIGN KEY (node_id_child) REFERENCES l_node
ALTER TABLE l_object ADD constraint FK376F8E7212D15742 FOREIGN KEY (node_id) REFERENCES l_node
ALTER TABLE l_room ADD constraint FKBDBB9CCE96B84069 FOREIGN KEY (node_id) REFERENCES l_node
ALTER TABLE l_user ADD constraint FKBDBD07BE96B9AB59 FOREIGN KEY (node_id) REFERENCES l_node
CREATE sequence adr_address_gts_seq
CREATE sequence adr_region_gts_seq
CREATE sequence adr_street_gts_seq
CREATE sequence adr_town_distr_gts_seq
CREATE sequence adr_town_gts_seq
CREATE sequence adr_town_part_gts_seq
CREATE sequence l_node_seq