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