-
Notifications
You must be signed in to change notification settings - Fork 18
/
data.sql
38 lines (27 loc) · 4.37 KB
/
data.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
USE `UrbanClap`;
LOCK TABLES `CATEGORY` WRITE;
INSERT INTO `CATEGORY`
VALUES (1,'Plumbing'),(2,'Electrical'),(3,'Carpentry'),(4,'Home Deep Cleaning'),(5,'Sofa Cleaning'),(6,'Bathroom Deep Cleaning'),(7,'Carpet Cleaning'),(8,'Kitchen Deep Cleaning'),(9,'Pest Control'),(10,'Car Cleaning'),(11,'AC Service and Repair'),(12,'RO or Water Purifier Repair'),(13,'Washing Machine Repair'),(14,'Refrigerator Repair'),(15,'Microwave Repair'),(16,'TV Repair and Installation'),(17,'Mobile Repair'),(18,'Laptop Repair'),(19,'iPhone, iPad, Mac Repair'),(20,'Computer Repair'),(21,'Geyser/Water Heater Repair'),(22,'House Painters'),(23,'Interiors'),(24,'Furniture and Wood work'),(25,'Modular Kitchens'),(26,'Renovation'),(27,'Architect'),(28,'Bathroom Renovation'),(29,'Plans and Designs'),(30,'Vastu Shastra Consultants');
UNLOCK TABLES;
LOCK TABLES `CITY` WRITE;
INSERT INTO `CITY` VALUES (1,'Pune','Maharashtra','India'),(2,'Nagpur','Maharashtra','India'),(3,'Nashik','Maharashtra','India'),(4,'Thane','Maharashtra','India'),(5,'Kalyan','Maharashtra','India'),(6,'Dadar','Maharashtra','India'),(7,'Lonavala','Maharashtra','India'),(8,'Visakhapatnam','Andhra Pradesh','India'),(9,'Tirupati','Andhra Pradesh','India'),(10,'Chittoor','Andhra Pradesh','India'),(11,'Bengaluru','Karnataka','India'),(12,'Mysore','Karnataka','India'),(13,'Hubli','Karnataka','India'),(14,'Mangalore','Karnataka','India'),(15,'Ahmedabad','Gujarat','India'),(16,'Surat','Gujarat','India'),(17,'Vadodara','Gujarat','India'),(18,'Bhopal','Madhya Pradesh','India'),(19,'Indore','Madhya Pradesh','India'),(20,'Jabalpur','Madhya Pradesh','India'),(21,'Ujjain','Madhya Pradesh','India'),(22,'Gwalior','Madhya Pradesh','India'),(23,'Delhi','Delhi','India'),(24,'Noida','Uttar Pradesh','India'),(25,'Ghaziabad','Uttar Pradesh','India'),(26,'Faridabad','Haryana','India'),(27,'Meerut','Uttar Pradesh','India'),(28,'Sonipat','Haryana','India'),(29,'Gurgaon','Haryana','India'),(30,'Jaipur','Rajasthan','India');
UNLOCK TABLES;
LOCK TABLES `CUSTOMER` WRITE;
INSERT INTO `CUSTOMER` VALUES (1,'Aarav Acharya','M','[email protected]','1111111111','A',1),(2,'Vivaan Agarwal','M','[email protected]','2222222222','A',2),(3,'Aditya Khatri','M','[email protected]','3333333333','A',3),(4,'Vihaan Ahuja','M','[email protected]','4444444444','A',4),(5,'Arjun Anand','M','[email protected]','5555555555','A',5),(6,'Reyansh Laghari','M','[email protected]','6666666666','A',6),(7,'Muhammad Patel','M','muhammad.patel','7777777777','A',7),(8,'Sai Reddy','M','[email protected]','8888888888','A',8),(9,'Arnav Bakshi','M','[email protected]','9999999999','A',9),(10,'Ayaan Anthony','M','[email protected]','1010101010','A',10),(11,'Ansh Burman','M','[email protected]','1101101111','A',11),(12,'Kabir Bedi','M','[email protected]','1201201111','A',12),(13,'Rudra Bhatt','M','[email protected]','1301301111','A',13),(14,'Raghav Dalal','M','[email protected]','1401401111','A',14),(15,'Mehul Chawla','M','[email protected]','1501501111','A',15),(16,'Ananya Birla','F','[email protected]','1601601111','A',16),(17,'Riya Patel','F','[email protected]','17017011111','A',17),(18,'Diya Saxena','F','[email protected]','1801801111','A',18),(19,'Ishita Patel','F','[email protected]','1901901111','A',19),(20,'Kavya Sinha','F','[email protected]','2002001111','A',20),(21,'Khushi Chatterji','F','[email protected]','2102101111','A',21),(22,'Tanvi Apte','F','[email protected]','2202201111','A',22),(23,'Radhika Sharma','F','[email protected]','2302301111','A',23),(24,'Krisha Datta','F','[email protected]','2402401111','A',24),(25,'Zoya Mendes','F','[email protected]','2502501111','A',25),(26,'Akira Shamsi','F','[email protected]','2602601111','A',26),(27,'Mariya Shah','F','[email protected]','2702701111','A',27),(28,'Vrunda Adhvaryu','F','[email protected]','2802801111','A',28),(29,'Anjali Vij','F','[email protected]','2902901111','A',29),(30,'Kosha Prajapati','F','[email protected]','3003001111','A',30);
UNLOCK TABLES;
LOCK TABLES `OFFER` WRITE;
UNLOCK TABLES;
LOCK TABLES `PARTNER` WRITE;
UNLOCK TABLES;
LOCK TABLES `SERVICE` WRITE;
UNLOCK TABLES;
LOCK TABLES `avails` WRITE;
UNLOCK TABLES;
LOCK TABLES `belongs_to` WRITE;
UNLOCK TABLES;
LOCK TABLES `books` WRITE;
UNLOCK TABLES;
LOCK TABLES `feedbacks` WRITE;
UNLOCK TABLES;
LOCK TABLES `proposes` WRITE;
UNLOCK TABLES;