-- create database map_crm; USE map_crm;
CREATE TABLE IF NOT EXISTS yetkazib_beruvchilar (
id INT AUTO_INCREMENT PRIMARY KEY,
nomi VARCHAR(255) NOT NULL,
telefon VARCHAR(50) DEFAULT NULL,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE IF NOT EXISTS hududlar (
id INT AUTO_INCREMENT PRIMARY KEY,
nomi VARCHAR(255) NOT NULL,
viloyat VARCHAR(255) DEFAULT NULL,
qamrov_km INT DEFAULT NULL,
geojson LONGTEXT DEFAULT NULL,
supplier_id INT DEFAULT NULL,
supplier_name VARCHAR(255) DEFAULT NULL,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE IF NOT EXISTS yetkazib_beruvchi_hudud (
id INT AUTO_INCREMENT PRIMARY KEY,
yetkazib_beruvchi_id INT NOT NULL,
hudud_id INT NOT NULL,
assigned_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
UNIQUE KEY pair (yetkazib_beruvchi_id,hudud_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- Namuna ma'lumotlar: kichik misol hududlar (GeoJSON qisqacha poligonlar)
INSERT INTO yetkazib_beruvchilar (nomi,telefon) VALUES ('Daily', '+998901112233'), ('UzDelivery', '+998931234567');
INSERT INTO hududlar (nomi, viloyat, qamrov_km, geojson) VALUES
('Yovqochor MFY','Farg\'ona',25, '{"type":"Feature","geometry":{"type":"Polygon","coordinates":[[[71.700,40.400],[71.710,40.400],[71.710,40.410],[71.700,40.410],[71.700,40.400]]]},"properties":{}}'),
('Qo\'rg\'ontepa tumani','Andijon',40, '{"type":"Feature","geometry":{"type":"Polygon","coordinates":[[[72.300,40.700],[72.320,40.700],[72.320,40.720],[72.300,40.720],[72.300,40.700]]]},"properties":{}}');
-- Ixtiyoriy: biriktirish
INSERT INTO yetkazib_beruvchi_hudud (yetkazib_beruvchi_id,hudud_id) VALUES (1,1);
UPDATE hududlar SET supplier_id=1, supplier_name='Daily' WHERE id=1;
-- END OF FILE