---

-- ========== Очистка таблиц (в правильном порядке) ==========
DELETE FROM Orders;
DELETE FROM Products;
DELETE FROM Clients;
DELETE FROM Currency;
DELETE FROM Locations;

-- Сброс автоинкремента (чтобы ClientID и OrderID начинались с 1)
DBCC CHECKIDENT ('Clients', RESEED, 0);
DBCC CHECKIDENT ('Orders', RESEED, 0);


-- ==================== Locations ====================
INSERT INTO Locations (LocationID, Country, Region, City, Address, Phone)
VALUES (101, 'Беларусь', 'Витебская', 'Полоцк', 'ул.Лесная, 6', '+375172691376');

INSERT INTO Locations
VALUES (102, 'Беларусь', 'Гродненская', 'Лида', 'ул.Моховая, 12', NULL);

INSERT INTO Locations (LocationID, Region, City, Address, Phone)
VALUES (103, '', 'Минск', 'ул.Маркса, 24', NULL);

INSERT INTO Locations (LocationID, Country, Region, City, Address, Phone)
VALUES (201, 'Россия', 'Московская', 'Королев', 'ул.Труда, 8', '387-23-04');

INSERT INTO Locations (LocationID, Region, City, Address, Phone)
VALUES (202, '', 'Москва', 'ул.Тверская, 25', '900-8876');

INSERT INTO Locations (LocationID, Country, Region, City, Address, Phone)
VALUES (301, 'Украина', '', 'Киев', 'ул. Крещатик, 14', NULL);

INSERT INTO Locations (LocationID, Country, Region, City, Address, Phone)
VALUES (302, 'Украина', 'Львовская', 'Моршин', 'ул.Франко, 24', NULL);


-- ==================== Clients ====================
INSERT INTO Clients (ClientName, HeadFullName, Location)
VALUES ('ГП "Верас"', 'Прокушев Станислав Игоревич', 202);

INSERT INTO Clients
VALUES ('ИП "Temp"', 'Васько Григорий Терентьевич', 101);

INSERT INTO Clients (ClientName, HeadFullName, Location)
VALUES ('УП "Вера"', 'Прокуш Станислав Игоревич', 102);

INSERT INTO Clients (ClientName, HeadFullName, Location)
VALUES ('ИП "Темпера"', 'Вась Григорий Терентьевич', 102);

INSERT INTO Clients
VALUES ('ОАО "Старт"', 'Кулагин Василий Петрович', 103);

INSERT INTO Clients (ClientName, HeadFullName, Location)
VALUES ('ОАО "Рога и копыта"', 'Бендер Остап', 301);


-- ==================== Currency ====================
INSERT INTO Currency (CurrencyID, CurrencyName, Rate) VALUES
('BYN', 'БелРубНов', 1.0000),
('BYR', 'БелРуб', 0.0001),
('EUR', 'Евро', 2.2900),
('RUR', 'Российские рубли', 0.0320),
('USD', 'Доллары США', 1.9350);


-- ==================== Products ====================
INSERT INTO Products (ProductID, ProductName, Measure, Price, Currency) VALUES
(111, 'Монитор 24"', 'шт', 199.0000, 'USD'),
(333, 'Кабель', '10м', 2.5000, 'EUR'),
(444, 'Винчестер HDD 4 TB', 'шт', 299.9000, 'BYN'),
(555, 'Компьютер', 'шт', 999.0000, 'USD'),
(666, 'Планшет', 'шт', 1205.0000, 'USD'),
(777, 'Винчестер HDD 1100GB', 'шт', 119.9900, 'BYN');


-- ==================== Orders ====================
INSERT INTO Orders (Client, Product, Quantity, OrderDate, DeliveryDate) VALUES
(1, 111, 14.000, '2017-04-12', '2017-05-03'),
(2, 444, 27.000, '2017-05-09', '2017-05-25'),
(3, 777, 58.000, '2017-04-19', '2017-05-03'),
(2, 111, 122.000, '2017-04-04', '2017-05-03'),
(4, 444, 25.000, '2017-04-04', '2017-05-10'),
(3, 111, 37.000, '2017-04-24', '2017-05-10'),
(2, 555, 10.000, '2017-06-30', '2017-09-25'),
(6, 777, 25.000, '2017-05-30', '2017-05-15'),
(2, 111, 80.000, '2017-04-04', '2017-04-14');