CREATE TABLE GEOPUNCT (ID NUMBER NOT NULL, PARENT_ID NUMBER NULL, NAME VARCHAR2( 20 ) NOT NULL, TYPE_ID NUMBER NOT NULL);

CREATE TABLE GEOPUNCTTYPE (ID_TYPE NUMBER NOT NULL, TYPE_NAME VARCHAR2( 20 ) NOT NULL);

INSERT INTO GEOPUNCTTYPE (ID_TYPE , TYPE_NAME)
SELECT  1 , 'СТРАНА' from dual
union all
SELECT  2 , 'Субъект федерации' from dual
union all
SELECT  3 , 'Область' from dual
union all
SELECT  4 , 'Район' from dual
union all
SELECT  5 , 'Штат (США)' from dual
union all
SELECT  6 , 'Кантон (Швейцария)' from dual;
union all
SELECT  7 , 'Федеральный округ(США)' from dual
union all
SELECT  8 , 'Город' from dual


insert into GEOPUNCT (ID, PARENT_ID , NAME, TYPE_ID)
select  1 , null, 'Россия',  1  from dual
union all
select  2 ,  1 , 'Москва',  2  from dual
union all
select  3 ,  1 , 'Московская обл',  3  from dual
union all
select  4 ,  3 , 'Мытищи',  8  from dual
union all
select  5 , null, 'США',  1  from dual
union all
select  6 ,  5 , 'Колумбия',  7  from dual
union all
select  7 ,  6 , 'Вашингтон',  8  from dual
union all
select  9 ,  5 , 'Иллинойс',  5  from dual
union all
select  10 ,  9 , 'Чикаго',  8  from dual;