-- --------------------------------------------------------
-- Host:                         127.0.0.1
-- Server version:               10.4.32-MariaDB - mariadb.org binary distribution
-- Server OS:                    Win64
-- HeidiSQL Version:             12.6.0.6765
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

-- Dumping structure for table 100ad.martins_address_name
CREATE TABLE IF NOT EXISTS `martins_address_name` (
  `id_address_name` int(10) unsigned NOT NULL COMMENT 'Piesaistītās adreses ID',
  `id` int(10) unsigned NOT NULL COMMENT 'Adreses ID',
  `id_address_level` int(10) unsigned NOT NULL COMMENT 'Adreses līmeņa ID',
  `name` varchar(20) NOT NULL COMMENT 'Nosaukums',
  `id_address_index` int(10) unsigned DEFAULT 0 COMMENT 'Pasta indeksa ID',
  PRIMARY KEY (`id`),
  KEY `id_level` (`id_address_level`,`id_address_name`) USING BTREE,
  KEY `FK_address_name_address_name` (`id_address_name`),
  KEY `FK_address_name_address_index` (`id_address_index`),
  CONSTRAINT `FK_address_name_address_index` FOREIGN KEY (`id_address_index`) REFERENCES `address_index` (`id`),
  CONSTRAINT `FK_address_name_address_level` FOREIGN KEY (`id_address_level`) REFERENCES `address_level` (`id`),
  CONSTRAINT `FK_address_name_address_name` FOREIGN KEY (`id_address_name`) REFERENCES `martins_address_name` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Adreses';

-- Dumping data for table 100ad.martins_address_name: ~116 rows (approximately)
INSERT INTO `martins_address_name` (`id_address_name`, `id`, `id_address_level`, `name`, `id_address_index`) VALUES
	(100000000, 100000000, 1, 'Latvija', 0),
	(100016534, 100011533, 5, 'Sesavas pag.', 0),
	(100000000, 100016534, 2, 'Jelgavas nov.', 0),
	(100011533, 100128363, 6, 'Sesava', 0),
	(100011533, 100128443, 6, 'Bērvircava', 0),
	(100128443, 100354057, 7, 'Bērzu iela', 0),
	(100128443, 100354065, 7, 'Dārza iela', 0),
	(100128443, 100354073, 7, 'Kastaņu iela', 0),
	(100128443, 100354081, 7, 'Kļavu iela', 0),
	(100128443, 100354098, 7, 'Liepu iela', 0),
	(100128443, 100354104, 7, 'Līvānu iela', 0),
	(100128443, 100354112, 7, 'Saulstaru iela', 0),
	(100128443, 100354120, 7, 'Upes iela', 0),
	(100128443, 100354137, 7, 'Zvaigžņu iela', 0),
	(100128443, 100482550, 7, 'Pīlādžu iela', 0),
	(100128443, 100486277, 7, 'Tūju iela', 0),
	(100354081, 101539431, 8, '4', 96),
	(100354098, 101539448, 8, '7', 96),
	(100354112, 101539456, 8, '2', 96),
	(100354112, 101539464, 8, '8', 96),
	(100354120, 101539472, 8, '35', 96),
	(100354137, 101539497, 8, '9', 96),
	(100354057, 102254475, 8, '2', 96),
	(100354057, 102254483, 8, '4', 96),
	(100354057, 102254491, 8, '6', 96),
	(100354057, 102254506, 8, '8', 96),
	(100354065, 102254514, 8, '10', 96),
	(100354065, 102254522, 8, '2', 96),
	(100354065, 102254530, 8, '4', 96),
	(100354065, 102254547, 8, '6', 96),
	(100354065, 102254555, 8, '8', 96),
	(100354073, 102254563, 8, '6', 96),
	(100354081, 102254571, 8, '1', 96),
	(100354081, 102254588, 8, '10', 96),
	(100354081, 102254596, 8, '11', 96),
	(100354081, 102254602, 8, '12', 96),
	(100354081, 102254610, 8, '13', 96),
	(100354081, 102254627, 8, '14', 96),
	(100354081, 102254635, 8, '2', 96),
	(100354081, 102254643, 8, '3', 96),
	(100354081, 102254651, 8, '5', 96),
	(100354081, 102254668, 8, '6', 96),
	(100354081, 102254676, 8, '7', 96),
	(100354081, 102254684, 8, '8', 96),
	(100354098, 102254692, 8, '1', 96),
	(100354098, 102254707, 8, '11', 96),
	(100354098, 102254715, 8, '13', 96),
	(100354098, 102254723, 8, '3', 96),
	(100354098, 102254731, 8, '5', 96),
	(100354098, 102254748, 8, '9', 96),
	(100354104, 102254756, 8, '1', 96),
	(100354104, 102254764, 8, '2', 96),
	(100354104, 102254772, 8, '3', 96),
	(100354104, 102254780, 8, '4', 96),
	(100354104, 102254797, 8, '6', 96),
	(100354112, 102254803, 8, '10', 96),
	(100354112, 102254811, 8, '12', 96),
	(100354112, 102254828, 8, '14', 96),
	(100354112, 102254836, 8, '4', 96),
	(100354112, 102254844, 8, '6', 96),
	(100354120, 102254852, 8, '11', 96),
	(100354120, 102254860, 8, '13', 96),
	(100354120, 102254877, 8, '15', 96),
	(100354120, 102254885, 8, '17', 96),
	(100354120, 102254893, 8, '19', 96),
	(100354120, 102254908, 8, '21', 96),
	(100354120, 102254916, 8, '23', 96),
	(100354120, 102254924, 8, '25', 96),
	(100354120, 102254932, 8, '27', 96),
	(100354120, 102254940, 8, '29', 96),
	(100354120, 102254957, 8, '31', 96),
	(100354120, 102254965, 8, '33', 96),
	(100354120, 102254973, 8, '37', 96),
	(100354120, 102254981, 8, '39', 96),
	(100354120, 102254998, 8, '41', 96),
	(100354120, 102255001, 8, '43', 96),
	(100354120, 102255018, 8, '45', 96),
	(100354120, 102255026, 8, '47', 96),
	(100354120, 102255034, 8, '5', 96),
	(100354120, 102255042, 8, '7', 96),
	(100354120, 102255050, 8, '8', 96),
	(100354120, 102255067, 8, '9', 96),
	(100354137, 102255075, 8, '1', 96),
	(100354137, 102255083, 8, '10', 96),
	(100486277, 102255106, 8, '6', 96),
	(100486277, 102255114, 8, '3', 96),
	(100486277, 102255122, 8, '1', 96),
	(100486277, 102255130, 8, '2', 96),
	(100354137, 102255147, 8, '4', 96),
	(100354137, 102255155, 8, '5', 96),
	(100354137, 102255163, 8, '8', 96),
	(100354137, 102624406, 8, '3', 96),
	(100354137, 102624414, 8, '7', 96),
	(100354073, 102633938, 8, '4', 96),
	(100354081, 102682523, 8, '9', 96),
	(100486277, 102682531, 8, '4', 96),
	(100011533, 103504848, 8, 'Akācijas', 0),
	(100128443, 103509391, 8, 'Rītiņi', 96),
	(100482550, 103509406, 8, '10', 96),
	(100482550, 103509471, 8, '6', 96),
	(100482550, 103509488, 8, '4', 96),
	(100354120, 103509576, 8, '10', 96),
	(100354137, 103509584, 8, '2', 96),
	(100482550, 103509631, 8, '2', 96),
	(100354137, 103509648, 8, '6', 96),
	(100354104, 104920235, 8, ' 1B', 96),
	(100354112, 105532103, 8, ' 2A', 96),
	(100354120, 105796752, 8, '1', 96),
	(100128443, 105882516, 8, 'Nomaļi', 96),
	(100482550, 106187703, 8, '1', 96),
	(100354073, 106398240, 8, '2', 96),
	(100354112, 106582723, 8, '1', 96),
	(100354057, 106582748, 8, '10', 96),
	(100482550, 106583758, 8, '3', 96),
	(100482550, 106766836, 8, ' 8A', 96),
	(100011533, 106966088, 8, 'Akāciju darbnīcas', 0);

/*!40103 SET TIME_ZONE=IFNULL(@OLD_TIME_ZONE, 'system') */;
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS, 1) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40111 SET SQL_NOTES=IFNULL(@OLD_SQL_NOTES, 1) */;