· 9 years ago · Jun 08, 2017, 07:30 AM
1SET NAMES utf8mb4;
2SET FOREIGN_KEY_CHECKS = 0;
3
4
5-- ----------------------------
6-- Records of `product`
7-- ----------------------------
8BEGIN;
9INSERT INTO `product` VALUES ('1', 'Tea Tree Oil Out Acne Toner 150ml', '3', '49.00'), ('2', 'Rose & Botanic HA Aqua Cubic
10Hydrating Mask 10 pcs', '3', '13.00'), ('3', 'Magnolia Brightening And Firming Night Gelly', '3', '32.00'), ('4', 'Arbutin Intense
11Brightening Mask ', '3', '85.00'), ('5', 'Taiwan Magnolia Brightening and Firming Night Gelly EX ', '3', '105.00'), ('6', 'Taiwan
12Djulis Plumping and Firming Night Gelly', '3', '28.50'), ('7', 'Arbutin Intense Brightening Mask', '3', '75.90'), ('8', 'Facial
13Treatment Essence ', '1', '38.20'), ('9', 'Food Fresh Fruit Lip & Cheek Trio ', '1', '234.00'), ('10', 'Pitera Essence Set', '1',
14'257.00'), ('11', 'Ageless Beauty Set', '1', '832.00'), ('12', 'Glowing Aura Set', '1', '1245.00'), ('13', 'LXP Ultimate Perfecting
15Cream ', '1', '400.00'), ('14', 'Acne Pimple Medication', '2', '14.00'), ('15', 'Anti Pimple Mark', '2', '18.00'), ('16', 'Nose Pore
16Strip ', '2', '22.00'), ('17', 'Blemish Control Starter Kit', '2', '17.00'), ('18', 'Acne Patch Anti Bacterial', '2', '19.50'), ('19', 'The
17Skincare Night Moisture Recharge', '4', '55.00'), ('20', 'White Lucent Brightening Balancing Softener Enriched', '4', '29.00'),
18('21', 'Anti-Trouble Basic Caring Set', '5', '357.00'), ('22', 'Special Care Line Cleansing Nose Strip', '5', '267.00'), ('23', 'Anti-T
19Mask Pack', '5', '18.00'), ('24', 'Special Care Line Brightening Ampoule', '5', '50.00'), ('25', 'Special Care Line Brightening
20Mask Pack', '5', '69.00'), ('26', 'Cosmetic Pouch Blue', '5', '82.00'), ('27', 'Wonder Stick', '6', '35.00'), ('28', 'Two Timer Dual
21Ended Eyeliner', '6', '64.60'), ('29', 'Pro Brush - Dual Brow', '6', '82.40'), ('30', 'Super Skinny Eye Marker', '6', '62.00');
22COMMIT;
23-- ----------------------------
24-- Table structure for `profile`
25-- ----------------------------
26DROP TABLE IF EXISTS `profile`;
27CREATE TABLE `profile` (
28`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
29`full_name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
30`gender` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
31`race_id` int(10) unsigned DEFAULT NULL,
32`country_id` int(10) unsigned DEFAULT NULL,
33PRIMARY KEY (`id`),
34KEY `profile_race_id_foreign` (`race_id`),
35KEY `profile_country_id_foreign` (`country_id`),
36CONSTRAINT `profile_country_id_foreign` FOREIGN KEY (`country_id`) REFERENCES `country` (`id`),
37CONSTRAINT `profile_race_id_foreign` FOREIGN KEY (`race_id`) REFERENCES `races` (`id`)
38) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
39-- ----------------------------
40-- Records of `profile`
41-- ----------------------------
42BEGIN;
43INSERT INTO `profile` VALUES ('1', 'Celest Chong', 'FEMALE', '1', '1'), ('2', 'Qiyan Lim', 'FEMALE', '1', '1'), ('3', 'Chris Chan',
44'FEMALE', '1', '1'), ('4', 'Viviian Koay', 'FEMALE', '1', '1'), ('5', 'Joyee Fish', 'FEMALE', '1', '1'), ('6', 'Kristin Wong', 'FEMALE',
45'1', '1'), ('7', 'Jia Mei', 'FEMALE', '1', '1'), ('8', 'Amanda Chung', 'FEMALE', '1', '1'), ('9', 'Remee Ttl', 'FEMALE', '1', '1'), ('10',
46'Nasuha Ishak', 'FEMALE', '2', '1'), ('11', 'Dibah Shokri', 'FEMALE', '2', '1'), ('12', 'Maggie Chow', 'FEMALE', '1', '1'), ('13',
47'Kellie Seow', 'FEMALE', '1', '1'), ('14', 'Aina Reduzan', 'FEMALE', '2', '1'), ('15', 'Erfa Ha Siraj', 'FEMALE', '2', '1'), ('16', 'Xue
48Tingg', 'FEMALE', '1', '1'), ('17', 'Nurain Shah', 'FEMALE', '2', '1'), ('18', 'Hasnieza Hassan', 'FEMALE', '2', '1'), ('19', 'Fini Izam',
49'FEMALE', '2', '1'), ('20', 'Sean Jeez', 'MALE', '1', '1'), ('21', 'Kamarool Kareem', 'MALE', '2', '1'), ('22', 'Ah Bai', 'MALE', '1', '1'),
50('23', 'Amad Irfan', 'MALE', '2', '1'), ('24', 'Chua Soi Lim', 'MALE', '1', '1');
51COMMIT;
52-- ----------------------------
53-- Table structure for `races`
54-- ----------------------------
55DROP TABLE IF EXISTS `races`;
56CREATE TABLE `races` (
57 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
58 `name` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
59 PRIMARY KEY (`id`)
60) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
61
62-- ----------------------------
63-- Records of `races`
64-- ----------------------------
65BEGIN;
66INSERT INTO `races` VALUES ('1', 'Chinese'), ('2', 'Malay'), ('3', 'Indian'), ('4', 'Others');
67COMMIT;
68-- ----------------------------
69-- Table structure for `users`
70-- ----------------------------
71DROP TABLE IF EXISTS `users`;
72CREATE TABLE `users` (
73`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
74`email` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
75`profile_id` int(10) unsigned DEFAULT NULL,
76`membership_id` int(10) unsigned DEFAULT NULL,
77PRIMARY KEY (`id`),
78KEY `users_profile_id_foreign` (`profile_id`),
79KEY `users_membership_id_foreign` (`membership_id`),
80CONSTRAINT `users_membership_id_foreign` FOREIGN KEY (`membership_id`) REFERENCES `membership` (`id`),
81CONSTRAINT `users_profile_id_foreign` FOREIGN KEY (`profile_id`) REFERENCES `profile` (`id`)
82) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
83-- ----------------------------
84-- Records of `users`
85-- ----------------------------
86BEGIN;
87INSERT INTO `users` VALUES ('1', 'test1@gmail.com', '1', '1'), ('4', 'test2@gmail.com', '2', '1'), ('5', 'test3@gmail.com', '3',
88'3'), ('6', 'test4@gmail.com', '4', '3'), ('7', 'test5@gmail.com', '5', '2'), ('8', 'test6@gmail.com', '6', '2'), ('9',
89'test7@gmail.com', '7', '1'), ('10', 'test8@gmail.com', '8', '3'), ('11', 'test9@gmail.com', '9', '2'), ('12', 'test10@gmail.com',
90'10', '3'), ('13', 'test11@gmail.com', '11', '1'), ('14', 'test12@gmail.com', '12', '1'), ('15', 'test13@gmail.com', '13', '3'), ('16',
91'test14@gmail.com', '14', '3'), ('17', 'test15@gmail.com', '15', '2'), ('18', 'test16@gmail.com', '16', '3'), ('19',
92'test17@gmail.com', '17', '3'), ('20', 'test18@gmail.com', '18', '2'), ('21', 'test19@gmail.com', '19', '3'), ('22',
93'test20@gmail.com', '20', '3'), ('23', 'test21@gmail.com', '21', '3'), ('24', 'test22@gmail.com', '22', '1'), ('25',
94'test23@gmail.com', '23', '3'), ('26', 'test24@gmail.com', '24', '2');
95COMMIT;
96SET FOREIGN_KEY_CHECKS = 1;