Просмотр архива Двиг КоТа

-- phpMyAdmin SQL Dump
-- version 2.8.1
-- http://www.phpmyadmin.net
--

-- Хост: localhost
-- Время создания: Июл 11 2007
г., 18:14
-- Версия сервера: 5.0.17
-- Версия PHP:
5.1.4
-- 
-- БД: `geodb`
-- 

--
--------------------------------------------------------

-- 
--
Структура таблицы `geo_cities`
-- 

CREATE TABLE
`geo_cities` (
  `city_id` int(12) unsigned NOT NULL,
  `rid` int(12)
unsigned NOT NULL,
  `cid` int(12) unsigned NOT NULL,
  `city_name`
varchar(200) NOT NULL,
  PRIMARY KEY  (`city_id`),
  KEY `rid` (`rid`),

 KEY `cid` (`cid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- 
--
Дамп данных таблицы `geo_cities`
-- 

INSERT INTO
`geo_cities` VALUES 
(2450, 2449, 2448, 'Айзпуте'),
(2451, 2449,
2448, 'Айнажи'),
(2452, 2449, 2448, 'Алоя'),
(2453, 2449, 2448,
'Алсунга'),
(2454, 2449, 2448, 'Алуксне'),
(2455, 2449,
2448, 'Апе'),
(2456, 2449, 2448, 'Ауце'),
(2457, 2449, 2448,
'Балви'),
(2458, 2449, 2448, 'Балдоне'),
(2459, 2449, 2448,
'Баложи'),
(2460, 2449, 2448, 'Бауска'),
(2461, 2449, 2448,
'Бене'),
(2462, 2449, 2448, 'Броцены'),
(2463, 2449, 2448,
'Валдемарпилс'),
(2464, 2449, 2448, 'Валка'),
(2465,
2449, 2448, 'Валмиера'),
(2466, 2449, 2448,
'Варакляны'),
(2467, 2449, 2448, 'Вентспилс'),
(2468,
2449, 2448, 'Виесите'),
(2469, 2449, 2448, 'Виляка'),
(2470,
2449, 2448, 'Виляны'),
(2471, 2449, 2448, 'Гробиня'),
(2472,
2449, 2448, 'Гулбитис'),
(2473, 2449, 2448,
'Гулбене'),
(2474, 2449, 2448, 'Даугавпилс'),
(2475,
2449, 2448, 'Добеле'),
(2476, 2449, 2448, 'Дундага'),
(2477,
2449, 2448, 'Дурбе'),
(2506, 2449, 2448, 'Екабпилс'),
(2478,
2449, 2448, 'Елгава'),
(2479, 2449, 2448, 'Зилупе'),
(2480,
2449, 2448, 'Иецава'),
(2481, 2449, 2448, 'Илуксте'),
(2482,
2449, 2448, 'Калнциемс'),
(2483, 2449, 2448,
'Кандава'),
(2484, 2449, 2448, 'Карсава'),
(2485, 2449,
2448, 'Кегумс'),
(2486, 2449, 2448, 'Кокнесе'),
(2487, 2449,
2448, 'Колка'),
(2488, 2449, 2448, 'Краслава'),
(2489, 2449,
2448, 'Кулдига'),
(2490, 2449, 2448, 'Ливаны'),
(2491, 2449,
2448, 'Лиепая'),
(2492, 2449, 2448, 'Лимбажи'),
(2493, 2449,
2448, 'Лудза'),
(2494, 2449, 2448, 'Мадона'),
(2495, 2449,
2448, 'Огре'),
(2496, 2449, 2448, 'Плявиняс'),
(2497, 2449,
2448, 'Прейли'),
(2498, 2449, 2448, 'Резекне'),
(2499, 2449,
2448, 'Рига'),
(2500, 2449, 2448, 'Салдус'),
(2501, 2449, 2448,
'Сигулда'),
(2502, 2449, 2448, 'Стучка'),
(2503, 2449, 2448,
'Талси'),
(2504, 2449, 2448, 'Тукумс'),
(2505, 2449, 2448,
'Цесис'),
(2507, 2449, 2448, 'Элея'),
(2508, 2449, 2448,
'Юрмала');

--
--------------------------------------------------------

-- 
--
Структура таблицы `geo_cities2`
-- 

CREATE TABLE
`geo_cities2` (
  `city_id` int(12) unsigned NOT NULL,
  `rid` int(12)
unsigned NOT NULL,
  `cid` int(12) unsigned NOT NULL,
  `city_name`
varchar(200) NOT NULL,
  PRIMARY KEY  (`city_id`),
  KEY `rid` (`rid`),

 KEY `cid` (`cid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- 
--
Дамп данных таблицы `geo_cities2`
-- 

INSERT INTO
`geo_cities2` VALUES 
(2450, 2449, 2448, 'Aizpute'),
(2451, 2449, 2448,
'Ainaži'),
(2452, 2449, 2448, 'Aloja'),
(2453, 2449, 2448,
'Alsunga'),
(2454, 2449, 2448, 'Alūksne'),
(2455, 2449, 2448,
'Ape'),
(2456, 2449, 2448, 'Auce'),
(2457, 2449, 2448, 'Balvi'),
(2458,
2449, 2448, 'Baldone'),
(2459, 2449, 2448, 'Baloži'),
(2460, 2449, 2448,
'Bauska'),
(2461, 2449, 2448, 'Bēne'),
(2462, 2449, 2448,
'Brocēni'),
(2463, 2449, 2448, 'Valdemārpils'),
(2464, 2449, 2448,
'Valka'),
(2465, 2449, 2448, 'Valmiera'),
(2466, 2449, 2448,
'Varakļāni'),
(2467, 2449, 2448, 'Ventspils'),
(2468, 2449, 2448,
'Viesīte'),
(2469, 2449, 2448, 'Viļaka'),
(2470, 2449, 2448,
'Viļāni'),
(2471, 2449, 2448, 'Grobiņa'),
(2472, 2449, 2448,
'Gulbītis'),
(2473, 2449, 2448, 'Gulbene'),
(2474, 2449, 2448,
'Daugavpils'),
(2475, 2449, 2448, 'Dobele'),
(2476, 2449, 2448,
'Dundaga'),
(2477, 2449, 2448, 'Durbe'),
(2506, 2449, 2448,
'Jēkabpils'),
(2478, 2449, 2448, 'Jelgava'),
(2479, 2449, 2448,
'Zilupe'),
(2480, 2449, 2448, 'Iecava'),
(2481, 2449, 2448,
'Ilūkste'),
(2482, 2449, 2448, 'Kalnciems'),
(2483, 2449, 2448,
'Kandava'),
(2484, 2449, 2448, 'Kārsava'),
(2485, 2449, 2448,
'Ķegums'),
(2486, 2449, 2448, 'Koknese'),
(2487, 2449, 2448,
'Kolka'),
(2488, 2449, 2448, 'Krāslava'),
(2489, 2449, 2448,
'Kuldīga'),
(2490, 2449, 2448, 'Līvāni'),
(2491, 2449, 2448,
'Liepāja'),
(2492, 2449, 2448, 'Limbaži'),
(2493, 2449, 2448,
'Ludza'),
(2494, 2449, 2448, 'Madona'),
(2495, 2449, 2448,
'Ogre'),
(2496, 2449, 2448, 'Pļaviņas'),
(2497, 2449, 2448,
'Preiļi'),
(2498, 2449, 2448, 'Rēzekne'),
(2499, 2449, 2448,
'Rīga'),
(2500, 2449, 2448, 'Saldus'),
(2501, 2449, 2448,
'Sigūlda'),
(2502, 2449, 2448, 'Stučka'),
(2503, 2449, 2448,
'Talsi'),
(2504, 2449, 2448, 'Tukums'),
(2505, 2449, 2448,
'Cēsis'),
(2507, 2449, 2448, 'Eleja'),
(2508, 2449, 2448,
'Jūrmala');

--
--------------------------------------------------------

-- 
--
Структура таблицы `geo_countries`
-- 

CREATE TABLE
`geo_countries` (
  `country_id` int(12) unsigned NOT NULL,
 
`country_name` varchar(100) NOT NULL,
  PRIMARY KEY  (`country_id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- 
-- Дамп данных
таблицы `geo_countries`
-- 

INSERT INTO `geo_countries` VALUES
(2448, 'Латвия');

--
--------------------------------------------------------

-- 
--
Структура таблицы `geo_countries2`
-- 

CREATE TABLE
`geo_countries2` (
  `country_id` int(12) unsigned NOT NULL,
 
`country_name` varchar(100) NOT NULL,
  PRIMARY KEY  (`country_id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- 
-- Дамп данных
таблицы `geo_countries2`
-- 

INSERT INTO `geo_countries2` VALUES
(2448, 'Latvija');

--
--------------------------------------------------------

-- 
--
Структура таблицы `geo_regions`
-- 

CREATE TABLE
`geo_regions` (
  `region_id` int(12) unsigned NOT NULL,
  `cid` int(12)
unsigned NOT NULL,
  `region_name` varchar(100) NOT NULL,
  PRIMARY KEY 
(`region_id`),
  KEY `cid` (`cid`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8;

-- 
-- Дамп данных таблицы
`geo_regions`
-- 

INSERT INTO `geo_regions` VALUES 
(2449, 2448,
'Латвия');

--
--------------------------------------------------------

-- 
--
Структура таблицы `geo_regions2`
-- 

CREATE TABLE
`geo_regions2` (
  `region_id` int(12) unsigned NOT NULL,
  `cid` int(12)
unsigned NOT NULL,
  `region_name` varchar(100) NOT NULL,
  PRIMARY KEY 
(`region_id`),
  KEY `cid` (`cid`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8;

-- 
-- Дамп данных таблицы
`geo_regions2`
-- 

INSERT INTO `geo_regions2` VALUES 
(2449, 2448,
'Latvija');