Script_AddEntry.sql - master - Bagdasaryan_Alex/First_PP

Script_AddEntry.sql
166 строк10 KB
Bagdasaryan_Alex
Add all files.
16 апр 2026, 12:36
16 апр 2026, 12:36b87ac51
USE [PP_First];
GO

INSERT INTO StatusAppointments VALUES
(1,'Scheduled',NULL),(2,'Completed',NULL),(3,'Cancelled',NULL),(4,'NoShow',NULL),
(5,'InProgress',NULL),(6,'Rescheduled',NULL),(7,'Pending',NULL),(8,'Confirmed',NULL),
(9,'Paid',NULL),(10,'Unpaid',NULL),(11,'Late',NULL),(12,'Early',NULL),
(13,'Failed',NULL),(14,'Refunded',NULL),(15,'PartiallyDone',NULL),
(16,'Waiting',NULL),(17,'Approved',NULL),(18,'Declined',NULL),(19,'Archived',NULL),(20,'Test',NULL);

INSERT INTO StatusClients VALUES
(1,'Active',NULL),(2,'Inactive',NULL),(3,'Blocked',NULL),(4,'VIP',NULL),
(5,'New',NULL),(6,'Regular',NULL),(7,'Suspended',NULL),(8,'Blacklisted',NULL),
(9,'Premium',NULL),(10,'Standard',NULL),(11,'Trial',NULL),(12,'Loyal',NULL),
(13,'Returning',NULL),(14,'Occasional',NULL),(15,'Banned',NULL),
(16,'Deleted',NULL),(17,'Verified',NULL),(18,'Unverified',NULL),
(19,'Gold',NULL),(20,'Silver',NULL);

INSERT INTO StatusMasters VALUES
(1,'Active',NULL),(2,'Busy',NULL),(3,'OnLeave',NULL),(4,'Offline',NULL),
(5,'Available',NULL),(6,'Training',NULL),(7,'Suspended',NULL),(8,'Retired',NULL),
(9,'Probation',NULL),(10,'Senior',NULL),(11,'Junior',NULL),(12,'PartTime',NULL),
(13,'FullTime',NULL),(14,'Overloaded',NULL),(15,'Idle',NULL),
(16,'Vacation',NULL),(17,'SickLeave',NULL),(18,'BusinessTrip',NULL),
(19,'Fired',NULL),(20,'Test',NULL);

INSERT INTO StatusPayments VALUES
(1,'Paid',NULL),(2,'Pending',NULL),(3,'Failed',NULL),(4,'Refunded',NULL),
(5,'Partial',NULL),(6,'Cancelled',NULL),(7,'Processing',NULL),(8,'Completed',NULL),
(9,'Declined',NULL),(10,'Authorized',NULL),(11,'Captured',NULL),(12,'Voided',NULL),
(13,'Chargeback',NULL),(14,'InReview',NULL),(15,'Expired',NULL),
(16,'Test',NULL),(17,'Manual',NULL),(18,'Auto',NULL),(19,'Hold',NULL),(20,'Archived',NULL);

INSERT INTO StatusServices VALUES
(1,'Active',NULL),(2,'Inactive',NULL),(3,'Draft',NULL),(4,'Deleted',NULL),
(5,'Hidden',NULL),(6,'Visible',NULL),(7,'Seasonal',NULL),(8,'Popular',NULL),
(9,'New',NULL),(10,'Old',NULL),(11,'Premium',NULL),(12,'Basic',NULL),
(13,'Discounted',NULL),(14,'Limited',NULL),(15,'Exclusive',NULL),
(16,'Test',NULL),(17,'Blocked',NULL),(18,'Scheduled',NULL),
(19,'Archived',NULL),(20,'Future',NULL);

INSERT INTO CatedoryServices VALUES
(1,'Haircut',NULL),(2,'Coloring',NULL),(3,'Manicure',NULL),(4,'Pedicure',NULL),
(5,'Massage',NULL),(6,'Facial',NULL),(7,'Makeup',NULL),(8,'Eyebrows',NULL),
(9,'Lashes',NULL),(10,'Spa',NULL),(11,'Styling',NULL),(12,'Treatment',NULL),
(13,'BeardCare',NULL),(14,'Skincare',NULL),(15,'HairTreatment',NULL),
(16,'BodyCare',NULL),(17,'Waxing',NULL),(18,'Consulting',NULL),
(19,'Wellness',NULL),(20,'Other',NULL);

INSERT INTO SpecializationMasters VALUES
(1,'Hair Stylist',NULL),(2,'Color Specialist',NULL),(3,'Manicurist',NULL),(4,'Barber',NULL),
(5,'Massage Therapist',NULL),(6,'Esthetician',NULL),(7,'Makeup Artist',NULL),(8,'Brow Master',NULL),
(9,'Lash Technician',NULL),(10,'Spa Therapist',NULL),(11,'Junior Stylist',NULL),
(12,'Senior Stylist',NULL),(13,'Trainer',NULL),(14,'Skin Expert',NULL),
(15,'Body Specialist',NULL),(16,'Wax Specialist',NULL),(17,'Consultant',NULL),
(18,'Wellness Coach',NULL),(19,'Admin Specialist',NULL),(20,'Intern',NULL);

INSERT INTO Clients VALUES
(1,'Ivanov','Ivan','Petrovich',79000000001,'2025-01-10','1995-05-12',1,'No preferences'),
(2,'Smirnova','Anna',NULL,79000000002,'2025-02-11','1998-03-21',4,'VIP client'),
(3,'Kuznetsov','Oleg','Sergeevich',79000000003,'2025-03-05','1992-07-11',2,'Short haircut'),
(4,'Popova','Maria',NULL,79000000004,'2025-03-15','2000-09-09',6,'Coloring'),
(5,'Sidorov','Pavel',NULL,79000000005,'2025-04-01','1991-12-01',1,'Massage'),
(6,'Volkova','Elena','Ivanovna',79000000006,'2025-04-10','1989-11-23',9,'Premium care'),
(7,'Fedorov','Dmitry',NULL,79000000007,'2025-04-12','1993-06-17',10,'Standard'),
(8,'Morozova','Sofia',NULL,79000000008,'2025-04-20','1997-08-08',11,'Trial'),
(9,'Lebedev','Nikita',NULL,79000000009,'2025-04-21','1996-02-14',12,'Loyal'),
(10,'Orlova','Victoria',NULL,79000000010,'2025-04-22','2001-10-30',13,'Returning'),
(11,'Pavlov','Artem','Igorevich',79000000011,'2025-04-23','1994-01-19',14,'Occasional'),
(12,'Sokolova','Daria',NULL,79000000012,'2025-04-24','1999-04-04',15,'Blocked'),
(13,'Zaitsev','Kirill',NULL,79000000013,'2025-04-25','1990-05-05',17,'Verified'),
(14,'Belyaeva','Alina',NULL,79000000014,'2025-04-26','1998-08-18',18,'Unverified'),
(15,'Karpov','Maxim',NULL,79000000015,'2025-04-27','1993-03-03',19,'Gold'),
(16,'Novikova','Yulia',NULL,79000000016,'2025-04-28','1997-07-07',20,'Silver'),
(17,'Gromov','Anton',NULL,79000000017,'2025-04-29','1992-02-02',5,'New'),
(18,'Tikhonova','Natalia',NULL,79000000018,'2025-04-30','1995-09-09',7,'Suspended'),
(19,'Belov','Sergey',NULL,79000000019,'2025-05-01','1991-01-01',8,'Blacklisted'),
(20,'Egorova','Kristina',NULL,79000000020,'2025-05-02','1996-06-06',3,'Blocked');

INSERT INTO Masters VALUES
(1,'Master1','Ivan',NULL,1,79010000001,1000,'9-18',1,5),
(2,'Master2','Anna',NULL,2,79010000002,1200,'10-19',5,7),
(3,'Master3','Oleg',NULL,3,79010000003,900,'9-17',2,3),
(4,'Master4','Maria',NULL,4,79010000004,1100,'11-20',1,6),
(5,'Master5','Pavel',NULL,5,79010000005,1500,'8-16',3,10),
(6,'Master6','Elena',NULL,6,79010000006,1300,'9-18',4,8),
(7,'Master7','Dmitry',NULL,7,79010000007,1400,'10-19',6,4),
(8,'Master8','Sofia',NULL,8,79010000008,1600,'9-17',1,9),
(9,'Master9','Nikita',NULL,9,79010000009,1700,'12-21',2,11),
(10,'Master10','Victoria',NULL,10,79010000010,1000,'9-18',1,2),
(11,'Master11','Artem',NULL,11,79010000011,1100,'9-18',5,6),
(12,'Master12','Daria',NULL,12,79010000012,1200,'10-19',3,7),
(13,'Master13','Kirill',NULL,13,79010000013,1300,'9-18',4,5),
(14,'Master14','Alina',NULL,14,79010000014,1400,'11-20',6,8),
(15,'Master15','Maxim',NULL,15,79010000015,1500,'8-16',1,10),
(16,'Master16','Yulia',NULL,16,79010000016,1600,'9-18',2,9),
(17,'Master17','Anton',NULL,17,79010000017,1700,'10-19',3,12),
(18,'Master18','Natalia',NULL,18,79010000018,1800,'9-17',4,15),
(19,'Master19','Sergey',NULL,19,79010000019,1900,'9-18',5,20),
(20,'Master20','Kristina',NULL,20,79010000020,2000,'12-21',1,1);

INSERT INTO Services VALUES
(1,'Haircut Basic',1,60,1000,'Basic haircut','Scissors',1),
(2,'Hair Color',2,120,3000,'Coloring','Dye',1),
(3,'Manicure Classic',3,50,1200,'Nails','Tools',1),
(4,'Pedicure Spa',4,70,1500,'Feet care','Creams',1),
(5,'Relax Massage',5,90,2500,'Body massage','Oil',1),
(6,'Facial Clean',6,60,1800,'Skin cleaning','Masks',1),
(7,'Makeup Event',7,80,3500,'Makeup','Cosmetics',1),
(8,'Eyebrow Shape',8,30,800,'Brows','Tweezers',1),
(9,'Lash Extension',9,90,4000,'Lashes','Glue',1),
(10,'Spa Full',10,120,5000,'Spa','Various',1),
(11,'Styling Hair',11,45,1300,'Styling','Spray',1),
(12,'Hair Treatment',12,75,2200,'Treatment','Serum',1),
(13,'Beard Trim',13,30,900,'Beard','Trimmer',1),
(14,'Skin Care Pro',14,60,2600,'Skin','Cream',1),
(15,'Hair Repair',15,90,2800,'Repair','Keratin',1),
(16,'Body Scrub',16,50,2000,'Scrub','Salt',1),
(17,'Waxing',17,40,1700,'Hair removal','Wax',1),
(18,'Consultation',18,20,500,'Advice','None',1),
(19,'Wellness Plan',19,100,3200,'Plan','Docs',1),
(20,'Other Service',20,60,1000,'Misc','Various',1);

INSERT INTO Appointments VALUES
(1,1,1,1,'2026-04-01 10:00:00',60,'10:00','11:00',1,NULL,1000),
(2,2,2,2,'2026-04-01 11:00:00',120,'11:00','13:00',2,NULL,3000),
(3,3,3,3,'2026-04-02 10:00:00',50,'10:00','10:50',3,NULL,1200),
(4,4,4,4,'2026-04-02 12:00:00',70,'12:00','13:10',1,NULL,1500),
(5,5,5,5,'2026-04-03 09:00:00',90,'09:00','10:30',2,NULL,2500),
(6,6,6,6,'2026-04-03 11:00:00',60,'11:00','12:00',1,NULL,1800),
(7,7,7,7,'2026-04-04 10:00:00',80,'10:00','11:20',4,NULL,3500),
(8,8,8,8,'2026-04-04 12:00:00',30,'12:00','12:30',1,NULL,800),
(9,9,9,9,'2026-04-05 10:00:00',90,'10:00','11:30',2,NULL,4000),
(10,10,10,10,'2026-04-05 11:00:00',120,'11:00','13:00',1,NULL,5000),
(11,11,11,11,'2026-04-06 10:00:00',45,'10:00','10:45',1,NULL,1300),
(12,12,12,12,'2026-04-06 11:00:00',75,'11:00','12:15',3,NULL,2200),
(13,13,13,13,'2026-04-07 10:00:00',30,'10:00','10:30',1,NULL,900),
(14,14,14,14,'2026-04-07 11:00:00',60,'11:00','12:00',2,NULL,2600),
(15,15,15,15,'2026-04-08 10:00:00',90,'10:00','11:30',1,NULL,2800),
(16,16,16,16,'2026-04-08 12:00:00',50,'12:00','12:50',5,NULL,2000),
(17,17,17,17,'2026-04-09 10:00:00',40,'10:00','10:40',1,NULL,1700),
(18,18,18,18,'2026-04-09 11:00:00',20,'11:00','11:20',2,NULL,500),
(19,19,19,19,'2026-04-10 10:00:00',100,'10:00','11:40',1,NULL,3200),
(20,20,20,20,'2026-04-10 12:00:00',60,'12:00','13:00',4,NULL,1000);

INSERT INTO Payments VALUES
(1,1,'2026-04-01 11:10:00',1000,'Cash',0,1000,1,10001),
(2,2,'2026-04-01 13:10:00',3000,'Card',0,3000,1,10002),
(3,3,'2026-04-02 11:00:00',1200,'Card',0,1200,2,10003),
(4,4,'2026-04-02 13:20:00',1500,'Cash',0,1500,1,10004),
(5,5,'2026-04-03 10:40:00',2500,'Card',0,2500,1,10005),
(6,6,'2026-04-03 12:10:00',1800,'Cash',0,1800,1,10006),
(7,7,'2026-04-04 11:30:00',3500,'Card',0,3500,2,10007),
(8,8,'2026-04-04 12:40:00',800,'Cash',0,800,1,10008),
(9,9,'2026-04-05 11:40:00',4000,'Card',0,4000,1,10009),
(10,10,'2026-04-05 13:10:00',5000,'Card',0,5000,1,10010),
(11,11,'2026-04-06 10:50:00',1300,'Cash',0,1300,1,10011),
(12,12,'2026-04-06 12:30:00',2200,'Card',0,2200,2,10012),
(13,13,'2026-04-07 10:40:00',900,'Cash',0,900,1,10013),
(14,14,'2026-04-07 12:10:00',2600,'Card',0,2600,1,10014),
(15,15,'2026-04-08 11:40:00',2800,'Card',0,2800,1,10015),
(16,16,'2026-04-08 13:00:00',2000,'Cash',0,2000,5,10016),
(17,17,'2026-04-09 10:50:00',1700,'Card',0,1700,1,10017),
(18,18,'2026-04-09 11:30:00',500,'Cash',0,500,1,10018),
(19,19,'2026-04-10 11:50:00',3200,'Card',0,3200,4,10019),
(20,20,'2026-04-10 13:10:00',1000,'Cash',0,1000,1,10020);