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