-- phpMyAdmin SQL Dump
-- version 5.2.1deb3
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Jun 12, 2025 at 08:16 AM
-- Server version: 8.0.40-0ubuntu0.24.04.1
-- PHP Version: 8.3.6

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `adreses`
--

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

--
-- Table structure for table `Buls_address_index`
--

CREATE TABLE `Buls_address_index` (
  `id` bigint NOT NULL,
  `id_address_index` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `Buls_address_index`
--

INSERT INTO `Buls_address_index` (`id`, `id_address_index`) VALUES
(100000000, 0),
(100003028, 0),
(100319063, 0),
(100319071, 0),
(101151153, 97),
(101151161, 97),
(101151178, 97),
(101151186, 97),
(101154134, 97),
(101751076, 97),
(101751084, 97),
(101751092, 97),
(101751107, 97),
(101751115, 97),
(101751123, 97),
(101751131, 97),
(101751148, 95),
(101751228, 95),
(101751260, 95),
(101751277, 95),
(101751285, 95),
(102493948, 97),
(102493956, 97),
(102493964, 97),
(102493972, 97),
(102493980, 95),
(102494000, 95),
(102687821, 95),
(103049300, 97),
(104001537, 95),
(104001545, 95),
(104378791, 97),
(104378806, 95),
(104389097, 97),
(104486644, 97),
(104689760, 95),
(104689777, 95),
(104689785, 95),
(104689793, 95),
(104689808, 95),
(104689816, 95),
(104689824, 95),
(104689832, 95),
(104689840, 95),
(104967113, 97),
(104967121, 97),
(104967138, 97),
(104967154, 97),
(104967162, 97),
(104967170, 97),
(104967187, 97),
(104967195, 97),
(104967201, 97),
(104967218, 97),
(105018716, 95),
(105018724, 95),
(105018732, 95),
(105018740, 95),
(105018757, 95),
(105018765, 95),
(105018773, 95),
(105018781, 95),
(105018798, 95),
(105018804, 95),
(105196813, 97),
(105196821, 97),
(105196838, 97),
(105196846, 97),
(105196854, 97),
(105196862, 97),
(105196870, 97),
(105196887, 97),
(105196895, 97),
(105196901, 97),
(105196918, 97),
(105196926, 97),
(105196934, 97),
(105196942, 97),
(105196950, 97),
(105196967, 97),
(105196975, 97),
(105196983, 97),
(105197300, 97),
(105218618, 97),
(105328121, 97),
(105328138, 97),
(105382842, 95),
(105398550, 97),
(105398567, 97),
(105446075, 95),
(105523280, 97),
(105587737, 97),
(106166794, 95),
(106166800, 95),
(106166817, 95),
(106180338, 95),
(106261534, 95),
(106620294, 95),
(106870554, 97),
(106870562, 97),
(106870570, 97),
(106870587, 97),
(106870595, 97),
(106870601, 97),
(107008745, 95),
(107008753, 95);

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

--
-- Table structure for table `Buls_address_level`
--

CREATE TABLE `Buls_address_level` (
  `id` bigint NOT NULL,
  `id_address_level` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `Buls_address_level`
--

INSERT INTO `Buls_address_level` (`id`, `id_address_level`) VALUES
(100000000, 1),
(100003028, 3),
(100319063, 7),
(100319071, 7),
(101151153, 8),
(101151161, 8),
(101151178, 8),
(101151186, 8),
(101154134, 8),
(101751076, 8),
(101751084, 8),
(101751092, 8),
(101751107, 8),
(101751115, 8),
(101751123, 8),
(101751131, 8),
(101751148, 8),
(101751228, 8),
(101751260, 8),
(101751277, 8),
(101751285, 8),
(102493948, 8),
(102493956, 8),
(102493964, 8),
(102493972, 8),
(102493980, 8),
(102494000, 8),
(102687821, 8),
(103049300, 8),
(104001537, 8),
(104001545, 8),
(104378791, 8),
(104378806, 8),
(104389097, 8),
(104486644, 8),
(104689760, 8),
(104689777, 8),
(104689785, 8),
(104689793, 8),
(104689808, 8),
(104689816, 8),
(104689824, 8),
(104689832, 8),
(104689840, 8),
(104967113, 8),
(104967121, 8),
(104967138, 8),
(104967154, 8),
(104967162, 8),
(104967170, 8),
(104967187, 8),
(104967195, 8),
(104967201, 8),
(104967218, 8),
(105018716, 8),
(105018724, 8),
(105018732, 8),
(105018740, 8),
(105018757, 8),
(105018765, 8),
(105018773, 8),
(105018781, 8),
(105018798, 8),
(105018804, 8),
(105196813, 8),
(105196821, 8),
(105196838, 8),
(105196846, 8),
(105196854, 8),
(105196862, 8),
(105196870, 8),
(105196887, 8),
(105196895, 8),
(105196901, 8),
(105196918, 8),
(105196926, 8),
(105196934, 8),
(105196942, 8),
(105196950, 8),
(105196967, 8),
(105196975, 8),
(105196983, 8),
(105197300, 8),
(105218618, 8),
(105328121, 8),
(105328138, 8),
(105382842, 8),
(105398550, 8),
(105398567, 8),
(105446075, 8),
(105523280, 8),
(105587737, 8),
(106166794, 8),
(106166800, 8),
(106166817, 8),
(106180338, 8),
(106261534, 8),
(106620294, 8),
(106870554, 8),
(106870562, 8),
(106870570, 8),
(106870587, 8),
(106870595, 8),
(106870601, 8),
(107008745, 8),
(107008753, 8);

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

--
-- Table structure for table `Buls_address_name`
--

CREATE TABLE `Buls_address_name` (
  `id` bigint NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `lname` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `Buls_address_name`
--

INSERT INTO `Buls_address_name` (`id`, `name`, `lname`) VALUES
(100000000, 'Latvija', 'Latvija'),
(100003028, 'Jelgava, Latvija', 'Jelgava'),
(100319063, '1. līnija, Jelgava, Latvija', '1. līnija'),
(100319071, '2. līnija, Jelgava, Latvija', '2. līnija'),
(101151153, '1. līnija 4B, Jelgava, LV-3007', '4B'),
(101151161, '1. līnija 4C, Jelgava, LV-3007', '4C'),
(101151178, '1. līnija 4D, Jelgava, LV-3007', '4D'),
(101151186, '1. līnija 4E, Jelgava, LV-3007', '4E'),
(101154134, '1. līnija 4A, Jelgava, LV-3007', '4A'),
(101751076, '1. līnija 11, Jelgava, LV-3007', '11'),
(101751084, '1. līnija 2, Jelgava, LV-3007', '2'),
(101751092, '1. līnija 3, Jelgava, LV-3007', '3'),
(101751107, '1. līnija 4, Jelgava, LV-3007', '4'),
(101751115, '1. līnija 5, Jelgava, LV-3007', '5'),
(101751123, '1. līnija 7, Jelgava, LV-3007', '7'),
(101751131, '1. līnija 7A, Jelgava, LV-3007', '7A'),
(101751148, '2. līnija 1, Jelgava, LV-3003', '1'),
(101751228, '2. līnija 2, Jelgava, LV-3003', '2'),
(101751260, '2. līnija 7, Jelgava, LV-3003', '7'),
(101751277, '2. līnija 7A, Jelgava, LV-3003', '7A'),
(101751285, '2. līnija 9, Jelgava, LV-3003', '9'),
(102493948, '1. līnija 13, Jelgava, LV-3007', '13'),
(102493956, '1. līnija 2A, Jelgava, LV-3007', '2A'),
(102493964, '1. līnija 6, Jelgava, LV-3007', '6'),
(102493972, '1. līnija 9, Jelgava, LV-3007', '9'),
(102493980, '2. līnija 10, Jelgava, LV-3003', '10'),
(102494000, '2. līnija 3, Jelgava, LV-3003', '3'),
(102687821, '2. līnija 8, Jelgava, LV-3003', '8'),
(103049300, '1. līnija 9A, Jelgava, LV-3007', '9A'),
(104001537, '2. līnija 3A, Jelgava, LV-3003', '3A'),
(104001545, '2. līnija 3B, Jelgava, LV-3003', '3B'),
(104378791, '1. līnija 3A, Jelgava, LV-3007', '3A'),
(104378806, '2. līnija 2A, Jelgava, LV-3003', '2A'),
(104389097, '1. līnija 4F, Jelgava, LV-3007', '4F'),
(104486644, '1. līnija 4G, Jelgava, LV-3007', '4G'),
(104689760, '2. līnija 2B, Jelgava, LV-3003', '2B'),
(104689777, '2. līnija 2C, Jelgava, LV-3003', '2C'),
(104689785, '2. līnija 2D, Jelgava, LV-3003', '2D'),
(104689793, '2. līnija 2E, Jelgava, LV-3003', '2E'),
(104689808, '2. līnija 2F, Jelgava, LV-3003', '2F'),
(104689816, '2. līnija 2G, Jelgava, LV-3003', '2G'),
(104689824, '2. līnija 2H, Jelgava, LV-3003', '2H'),
(104689832, '2. līnija 2I, Jelgava, LV-3003', '2I'),
(104689840, '2. līnija 2J, Jelgava, LV-3003', '2J'),
(104967113, '1. līnija 9B, Jelgava, LV-3007', '9B'),
(104967121, '1. līnija 9C, Jelgava, LV-3007', '9C'),
(104967138, '1. līnija 9D, Jelgava, LV-3007', '9D'),
(104967154, '1. līnija 9F, Jelgava, LV-3007', '9F'),
(104967162, '1. līnija 9G, Jelgava, LV-3007', '9G'),
(104967170, '1. līnija 9H, Jelgava, LV-3007', '9H'),
(104967187, '1. līnija 9I, Jelgava, LV-3007', '9I'),
(104967195, '1. līnija 9J, Jelgava, LV-3007', '9J'),
(104967201, '1. līnija 9K, Jelgava, LV-3007', '9K'),
(104967218, '1. līnija 9L, Jelgava, LV-3007', '9L'),
(105018716, '2. līnija 8A, Jelgava, LV-3003', '8A'),
(105018724, '2. līnija 8B, Jelgava, LV-3003', '8B'),
(105018732, '2. līnija 8C, Jelgava, LV-3003', '8C'),
(105018740, '2. līnija 8D, Jelgava, LV-3003', '8D'),
(105018757, '2. līnija 8E, Jelgava, LV-3003', '8E'),
(105018765, '2. līnija 8F, Jelgava, LV-3003', '8F'),
(105018773, '2. līnija 8G, Jelgava, LV-3003', '8G'),
(105018781, '2. līnija 8H, Jelgava, LV-3003', '8H'),
(105018798, '2. līnija 8I, Jelgava, LV-3003', '8I'),
(105018804, '2. līnija 8J, Jelgava, LV-3003', '8J'),
(105196813, '1. līnija 7N, Jelgava, LV-3007', '7N'),
(105196821, '1. līnija 7O, Jelgava, LV-3007', '7O'),
(105196838, '1. līnija 7P, Jelgava, LV-3007', '7P'),
(105196846, '1. līnija 7R, Jelgava, LV-3007', '7R'),
(105196854, '1. līnija 7S, Jelgava, LV-3007', '7S'),
(105196862, '1. līnija 7T, Jelgava, LV-3007', '7T'),
(105196870, '1. līnija 7U, Jelgava, LV-3007', '7U'),
(105196887, '1. līnija 7V, Jelgava, LV-3007', '7V'),
(105196895, '1. līnija 9Z, Jelgava, LV-3007', '9Z'),
(105196901, '1. līnija 9V, Jelgava, LV-3007', '9V'),
(105196918, '1. līnija 9U, Jelgava, LV-3007', '9U'),
(105196926, '1. līnija 9T, Jelgava, LV-3007', '9T'),
(105196934, '1. līnija 9S, Jelgava, LV-3007', '9S'),
(105196942, '1. līnija 9R, Jelgava, LV-3007', '9R'),
(105196950, '1. līnija 9P, Jelgava, LV-3007', '9P'),
(105196967, '1. līnija 9O, Jelgava, LV-3007', '9O'),
(105196975, '1. līnija 9N, Jelgava, LV-3007', '9N'),
(105196983, '1. līnija 9M, Jelgava, LV-3007', '9M'),
(105197300, '1. līnija 7Z, Jelgava, LV-3007', '7Z'),
(105218618, '1. līnija 7M, Jelgava, LV-3007', '7M'),
(105328121, '1. līnija 5A, Jelgava, LV-3007', '5A'),
(105328138, '1. līnija 7B, Jelgava, LV-3007', '7B'),
(105382842, '2. līnija 3C, Jelgava, LV-3003', '3C'),
(105398550, '1. līnija 5B, Jelgava, LV-3007', '5B'),
(105398567, '1. līnija 5C, Jelgava, LV-3007', '5C'),
(105446075, '2. līnija 2K, Jelgava, LV-3003', '2K'),
(105523280, '1. līnija 4I, Jelgava, LV-3007', '4I'),
(105587737, '1. līnija 5D, Jelgava, LV-3007', '5D'),
(106166794, '2. līnija 7B, Jelgava, LV-3003', '7B'),
(106166800, '2. līnija 1C, Jelgava, LV-3003', '1C'),
(106166817, '2. līnija 1B, Jelgava, LV-3003', '1B'),
(106180338, '2. līnija 9A, Jelgava, LV-3003', '9A'),
(106261534, '2. līnija 1A, Jelgava, LV-3003', '1A'),
(106620294, '2. līnija 7C, Jelgava, LV-3003', '7C'),
(106870554, '1. līnija 15, Jelgava, LV-3007', '15'),
(106870562, '1. līnija 17, Jelgava, LV-3007', '17'),
(106870570, '1. līnija 19, Jelgava, LV-3007', '19'),
(106870587, '1. līnija 21, Jelgava, LV-3007', '21'),
(106870595, '1. līnija 23, Jelgava, LV-3007', '23'),
(106870601, '1. līnija 25, Jelgava, LV-3007', '25'),
(107008745, '2. līnija 2L, Jelgava, LV-3003', '2L'),
(107008753, '2. līnija 2M, Jelgava, LV-3003', '2M');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `Buls_address_index`
--
ALTER TABLE `Buls_address_index`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `Buls_address_level`
--
ALTER TABLE `Buls_address_level`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `Buls_address_name`
--
ALTER TABLE `Buls_address_name`
  ADD PRIMARY KEY (`id`);
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
