-- ----------------------------
-- -------- INSERTS E2 --------
-- ----------------------------

Delete From InvoiceDetails Where id >= 1;
Delete From Invoices Where id >= 1;
Delete From Payments Where id >= 1;
Delete From Customers Where id >= 1;
Delete From CustomerTypes Where id >= 1;

ALTER TABLE InvoiceDetails AUTO_INCREMENT = 1;
ALTER TABLE Invoices AUTO_INCREMENT = 1;
ALTER TABLE Payments AUTO_INCREMENT = 1;
ALTER TABLE Customers AUTO_INCREMENT = 1;
ALTER TABLE CustomerTypes AUTO_INCREMENT = 1;

INSERT CustomerTypes (__CreationTime, __ModificationTime, __CreationUser, __ModificationUser, _UUID, Notes, Type)
VALUES
(now(), now(), 'SYSTEM', 'SYSTEM',UUID(), '', 'VIP'),
(now(), now(), 'SYSTEM', 'SYSTEM',UUID(), '', 'Critic'),
(now(), now(), 'SYSTEM', 'SYSTEM',UUID(), '', 'Regular');

INSERT Customers (id_CustomerTypes, __CreationTime, __ModificationTime, __CreationUser, __ModificationUser, _UUID, Notes, PhoneNumber, PostalCode, Name, Address, Province, Appartment, Email)
VALUES
(1, now(), now(), 'SYSTEM', 'SYSTEM',UUID(), '','8195370549', 'G9N1A4', 'Charles Brouard', '333 10eRue', 'QC', '', 'charles.brouard@hotmail.com'),
(2, now(), now(), 'SYSTEM', 'SYSTEM',UUID(), '','8199854267', 'G9N1Y8', 'Rachel Forest', '1558 Cote des Neiges', 'QC', '5', 'rachel.forest@gmail.com'),
(3, now(), now(), 'SYSTEM', 'SYSTEM',UUID(), '','8198524697', 'G9N3f5', 'Mathieu Alain', '9898 Ave Fleurs', 'QC', '', 'DAS_NAIN@hotmail.com');

INSERT Invoices (id_Customer, id_Employee, __CreationTime, __ModificationTime, __CreationUser, __ModificationUser, _UUID, Notes, Status, Total)
VALUES
(1, 1, now(), now(), 'SYSTEM', 'SYSTEM',UUID(), '', 'Completed', 0.00),
(2, 2, now(), now(), 'SYSTEM', 'SYSTEM',UUID(), '', 'Completed', 0.00),
(3, 3, now(), now(), 'SYSTEM', 'SYSTEM',UUID(), '', 'Completed', 0.00);

INSERT InvoiceDetails (id_Invoice, id_Product, __CreationTime, __ModificationTime, __CreationUser, __ModificationUser, _UUID, Notes)
VALUES
(1, 1, now(), now(), 'SYSTEM', 'SYSTEM',UUID(), ''),
(1, 2, now(), now(), 'SYSTEM', 'SYSTEM',UUID(), ''),
(2, 3, now(), now(), 'SYSTEM', 'SYSTEM',UUID(), ''),
(3, 4, now(), now(), 'SYSTEM', 'SYSTEM',UUID(), ''),
(3, 5, now(), now(), 'SYSTEM', 'SYSTEM',UUID(), ''),
(3, 6, now(), now(), 'SYSTEM', 'SYSTEM',UUID(), ''),
(3, 7, now(), now(), 'SYSTEM', 'SYSTEM',UUID(), '');