0fDprcN5

1-- MySQL Script generated by MySQL Workbench
2-- Mon Dec 18 08:57:35 2017
3-- Model: New Model    Version: 1.0
4-- MySQL Workbench Forward Engineering
5
6SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
7SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
8SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
9
10-- -----------------------------------------------------
11-- Schema ecommerce
12-- -----------------------------------------------------
13DROP SCHEMA IF EXISTS `ecommerce` ;
14
15-- -----------------------------------------------------
16-- Schema ecommerce
17-- -----------------------------------------------------
18CREATE SCHEMA IF NOT EXISTS `ecommerce` DEFAULT CHARACTER SET utf8 ;
19USE `ecommerce` ;
20
21-- -----------------------------------------------------
22-- Table `ecommerce`.`customer`
23-- -----------------------------------------------------
24CREATE TABLE IF NOT EXISTS `ecommerce`.`customer` (
25  `id` VARCHAR(255) NOT NULL,
26  `password_hash` VARCHAR(64) NOT NULL,
27  `password_salt` VARCHAR(64) NOT NULL,
28  `name` VARCHAR(255) NOT NULL,
29  `avatar` LONGBLOB NULL,
30  `active` TINYINT NOT NULL DEFAULT 1,
31  PRIMARY KEY (`id`))
32ENGINE = InnoDB;
33
34
35-- -----------------------------------------------------
36-- Table `ecommerce`.`user`
37-- -----------------------------------------------------
38CREATE TABLE IF NOT EXISTS `ecommerce`.`user` (
39  `id` VARCHAR(255) NOT NULL,
40  `password_hash` VARCHAR(64) NOT NULL,
41  `password_salt` VARCHAR(64) NOT NULL,
42  `name` VARCHAR(45) NOT NULL,
43  `avatar` LONGBLOB NULL,
44  `active` TINYINT NOT NULL DEFAULT 1,
45  PRIMARY KEY (`id`))
46ENGINE = InnoDB;
47
48
49-- -----------------------------------------------------
50-- Table `ecommerce`.`category`
51-- -----------------------------------------------------
52CREATE TABLE IF NOT EXISTS `ecommerce`.`category` (
53  `id` INT NOT NULL AUTO_INCREMENT,
54  `name` VARCHAR(255) NOT NULL,
55  `active` TINYINT NOT NULL DEFAULT 1,
56  PRIMARY KEY (`id`),
57  UNIQUE INDEX `name_unique` (`name` ASC))
58ENGINE = InnoDB;
59
60
61-- -----------------------------------------------------
62-- Table `ecommerce`.`item`
63-- -----------------------------------------------------
64CREATE TABLE IF NOT EXISTS `ecommerce`.`item` (
65  `id` INT NOT NULL AUTO_INCREMENT,
66  `name` VARCHAR(255) NOT NULL,
67  `description` TEXT NULL,
68  `unit` VARCHAR(45) NULL DEFAULT NULL,
69  `category_id` INT NOT NULL,
70  `new` TINYINT NOT NULL DEFAULT 1,
71  `price` VARCHAR(45) NULL,
72  `active` TINYINT NOT NULL DEFAULT 1,
73  PRIMARY KEY (`id`),
74  UNIQUE INDEX `name_unique` (`name` ASC),
75  INDEX `fk_item_category_idx` (`category_id` ASC),
76  CONSTRAINT `fk_item_category`
77    FOREIGN KEY (`category_id`)
78    REFERENCES `ecommerce`.`category` (`id`)
79    ON DELETE NO ACTION
80    ON UPDATE NO ACTION)
81ENGINE = InnoDB;
82
83
84-- -----------------------------------------------------
85-- Table `ecommerce`.`customer_address`
86-- -----------------------------------------------------
87CREATE TABLE IF NOT EXISTS `ecommerce`.`customer_address` (
88  `id` INT NOT NULL AUTO_INCREMENT,
89  `customer_id` VARCHAR(255) NOT NULL,
90  `address` TEXT NOT NULL,
91  `defaut` TINYINT NOT NULL DEFAULT 0,
92  PRIMARY KEY (`id`),
93  INDEX `fk_address_customer1_idx` (`customer_id` ASC),
94  CONSTRAINT `fk_address_customer1`
95    FOREIGN KEY (`customer_id`)
96    REFERENCES `ecommerce`.`customer` (`id`)
97    ON DELETE NO ACTION
98    ON UPDATE NO ACTION)
99ENGINE = InnoDB;
100
101
102-- -----------------------------------------------------
103-- Table `ecommerce`.`order`
104-- -----------------------------------------------------
105CREATE TABLE IF NOT EXISTS `ecommerce`.`order` (
106  `id` INT NOT NULL AUTO_INCREMENT,
107  `customer_id` VARCHAR(255) NOT NULL,
108  `shipping_cost` DECIMAL(13,2) NOT NULL DEFAULT 0.00,
109  `shipping_address` INT NOT NULL,
110  `status` ENUM('pending', 'confirmed', 'processing', 'dispatched', 'delivered') NOT NULL DEFAULT 'pending',
111  `paid` TINYINT NOT NULL DEFAULT 0,
112  `payment_type` ENUM('cash', 'credit') NOT NULL DEFAULT 'credit',
113  `time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
114  PRIMARY KEY (`id`),
115  INDEX `fk_order_customer1_idx` (`customer_id` ASC),
116  INDEX `fk_order_customer_address1_idx` (`shipping_address` ASC),
117  CONSTRAINT `fk_order_customer1`
118    FOREIGN KEY (`customer_id`)
119    REFERENCES `ecommerce`.`customer` (`id`)
120    ON DELETE NO ACTION
121    ON UPDATE NO ACTION,
122  CONSTRAINT `fk_order_customer_address1`
123    FOREIGN KEY (`shipping_address`)
124    REFERENCES `ecommerce`.`customer_address` (`id`)
125    ON DELETE NO ACTION
126    ON UPDATE NO ACTION)
127ENGINE = InnoDB;
128
129
130-- -----------------------------------------------------
131-- Table `ecommerce`.`order_has_item`
132-- -----------------------------------------------------
133CREATE TABLE IF NOT EXISTS `ecommerce`.`order_has_item` (
134  `order_id` INT NOT NULL,
135  `item_id` INT NOT NULL,
136  `no_of_units` INT NOT NULL DEFAULT 0,
137  `unit_price` DECIMAL(13,2) NOT NULL DEFAULT 0.00,
138  `tax_percentage` DECIMAL(4,2) NOT NULL DEFAULT 00.00,
139  `rating` INT NULL DEFAULT NULL,
140  `feedback` TEXT NULL DEFAULT NULL,
141  PRIMARY KEY (`order_id`, `item_id`),
142  INDEX `fk_order_has_item_item1_idx` (`item_id` ASC),
143  INDEX `fk_order_has_item_order1_idx` (`order_id` ASC),
144  CONSTRAINT `fk_order_has_item_order1`
145    FOREIGN KEY (`order_id`)
146    REFERENCES `ecommerce`.`order` (`id`)
147    ON DELETE NO ACTION
148    ON UPDATE NO ACTION,
149  CONSTRAINT `fk_order_has_item_item1`
150    FOREIGN KEY (`item_id`)
151    REFERENCES `ecommerce`.`item` (`id`)
152    ON DELETE NO ACTION
153    ON UPDATE NO ACTION)
154ENGINE = InnoDB;
155
156
157-- -----------------------------------------------------
158-- Table `ecommerce`.`item_detail`
159-- -----------------------------------------------------
160CREATE TABLE IF NOT EXISTS `ecommerce`.`item_detail` (
161  `id` INT NOT NULL AUTO_INCREMENT,
162  `field_name` VARCHAR(255) NOT NULL,
163  `field_value` VARCHAR(255) NOT NULL DEFAULT '-',
164  `item_id` INT NOT NULL,
165  PRIMARY KEY (`id`),
166  INDEX `fk_item_detail_item1_idx` (`item_id` ASC),
167  UNIQUE INDEX `unique_filed` (`field_name` ASC, `item_id` ASC),
168  CONSTRAINT `fk_item_detail_item1`
169    FOREIGN KEY (`item_id`)
170    REFERENCES `ecommerce`.`item` (`id`)
171    ON DELETE NO ACTION
172    ON UPDATE NO ACTION)
173ENGINE = InnoDB;
174
175
176-- -----------------------------------------------------
177-- Table `ecommerce`.`item_download`
178-- -----------------------------------------------------
179CREATE TABLE IF NOT EXISTS `ecommerce`.`item_download` (
180  `id` INT NOT NULL AUTO_INCREMENT,
181  `field_name` VARCHAR(255) NOT NULL,
182  `download` LONGBLOB NULL,
183  `item_id` INT NOT NULL,
184  PRIMARY KEY (`id`),
185  INDEX `fk_item_download_item1_idx` (`item_id` ASC),
186  UNIQUE INDEX `unique_field` (`item_id` ASC, `field_name` ASC),
187  CONSTRAINT `fk_item_download_item1`
188    FOREIGN KEY (`item_id`)
189    REFERENCES `ecommerce`.`item` (`id`)
190    ON DELETE NO ACTION
191    ON UPDATE NO ACTION)
192ENGINE = InnoDB;
193
194
195-- -----------------------------------------------------
196-- Table `ecommerce`.`item_image`
197-- -----------------------------------------------------
198CREATE TABLE IF NOT EXISTS `ecommerce`.`item_image` (
199  `id` INT NOT NULL AUTO_INCREMENT,
200  `item_id` INT NOT NULL,
201  `image` LONGBLOB NOT NULL,
202  PRIMARY KEY (`id`),
203  INDEX `fk_item_image_item1_idx` (`item_id` ASC),
204  CONSTRAINT `fk_item_image_item1`
205    FOREIGN KEY (`item_id`)
206    REFERENCES `ecommerce`.`item` (`id`)
207    ON DELETE NO ACTION
208    ON UPDATE NO ACTION)
209ENGINE = InnoDB;
210
211
212-- -----------------------------------------------------
213-- Table `ecommerce`.`store_entry`
214-- -----------------------------------------------------
215CREATE TABLE IF NOT EXISTS `ecommerce`.`store_entry` (
216  `id` INT NOT NULL AUTO_INCREMENT,
217  `item_id` INT NOT NULL,
218  `no_of_units` INT NOT NULL DEFAULT 0,
219  PRIMARY KEY (`id`),
220  INDEX `fk_store_entry_item1_idx` (`item_id` ASC),
221  CONSTRAINT `fk_store_entry_item1`
222    FOREIGN KEY (`item_id`)
223    REFERENCES `ecommerce`.`item` (`id`)
224    ON DELETE NO ACTION
225    ON UPDATE NO ACTION)
226ENGINE = InnoDB;
227
228
229-- -----------------------------------------------------
230-- Table `ecommerce`.`store_log`
231-- -----------------------------------------------------
232CREATE TABLE IF NOT EXISTS `ecommerce`.`store_log` (
233  `id` INT NOT NULL AUTO_INCREMENT,
234  `item_id` INT NOT NULL,
235  `order_id` INT NULL,
236  `user_id` VARCHAR(255) NOT NULL,
237  `no_of_units` VARCHAR(45) NOT NULL,
238  `time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
239  `in` TINYINT NOT NULL DEFAULT 1,
240  PRIMARY KEY (`id`),
241  INDEX `fk_store_log_item1_idx` (`item_id` ASC),
242  INDEX `fk_store_log_order1_idx` (`order_id` ASC),
243  INDEX `fk_store_log_user1_idx` (`user_id` ASC),
244  CONSTRAINT `fk_store_log_item1`
245    FOREIGN KEY (`item_id`)
246    REFERENCES `ecommerce`.`item` (`id`)
247    ON DELETE NO ACTION
248    ON UPDATE NO ACTION,
249  CONSTRAINT `fk_store_log_order1`
250    FOREIGN KEY (`order_id`)
251    REFERENCES `ecommerce`.`order` (`id`)
252    ON DELETE NO ACTION
253    ON UPDATE NO ACTION,
254  CONSTRAINT `fk_store_log_user1`
255    FOREIGN KEY (`user_id`)
256    REFERENCES `ecommerce`.`user` (`id`)
257    ON DELETE NO ACTION
258    ON UPDATE NO ACTION)
259ENGINE = InnoDB;
260
261
262-- -----------------------------------------------------
263-- Table `ecommerce`.`item_field`
264-- -----------------------------------------------------
265CREATE TABLE IF NOT EXISTS `ecommerce`.`item_field` (
266  `id` INT NOT NULL AUTO_INCREMENT,
267  `field_name` VARCHAR(255) NOT NULL,
268  PRIMARY KEY (`id`))
269ENGINE = InnoDB;
270
271
272SET SQL_MODE=@OLD_SQL_MODE;
273SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
274SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
275
276-- -----------------------------------------------------
277-- Data for table `ecommerce`.`customer`
278-- -----------------------------------------------------
279START TRANSACTION;
280USE `ecommerce`;
281INSERT INTO `ecommerce`.`customer` (`id`, `password_hash`, `password_salt`, `name`, `avatar`, `active`) VALUES ('customer1@customer', '5e884898da28047151d0e56f8dc6292773603d0d6aabbdd62a11ef721d1542d8', '5e884898da28047151d0e56f8dc6292773603d0d6aabbdd62a11ef721d1542d8', 'Mortey Sanchez', 0x89504E470D0A1A0A0000000D49484452000000D7000000D70803000000BEA3348700000300504C5445FFFFFFF2F2F24C4C4C2828283C3C3C4242422E2E2E8282827474742323239090902222224040403636362C2C2C2A29293D3D3DC7C7C7E3E3E33B3B3BB9B9B9ACACAC3939393A3A3A2626266666663F3F3F303030595959333333343434D5D5D59E9E9D9292922727272A2725453C336A57453D363060504097795BB38E69866C514E4236584A3CA98764A080608E73577C654E735E49373737665442927355AD8864544739AB8763B08B67B28D68AC8864322E29AE8965443B329E7D5D997A5A6F5A45A58361AF8A66554D45B18C678A7055A2805E7760493B342E886D5237322BA88562987859A2805F8E70529B7B5A84684D7D634980654A8A6D51876B4F5D4D3D9475574B41379D7C5B82674C9172549F7E5CAA8662A4815FA884618E7257645341423A312121214C474220202049433D605C5867635F60606056565647474745403BB6A899EEEBE839342D6E63587D756CA59687AB9E90D2C1AFB39576C8B299C2B4A5B4AA9F938A81B5A595C8B8A7BDA388BC9C7C9B88758C7C6D6A5E527B634CCEC4BA95806B57524C524940D8C5B1D5C3B0BCAFA1856C54F6F5F3D8CFC7CCBCABA98C6F5C5249D6C2AEB49E86D1BFADAD9D8D8E765FD1BBA5BFB1A4FCFBFBE7E2DDABA49EA7A09A7A6A59C0C0C0F1EEECDED8D1D4C0AB9A99999797969494949D8A76BDAC9BC6BAAFD3BDA866523FC2B09ED1D1D18B8B8BFAF8F6C6BAADA7917BE4DED8A8A8A88D8D8D777777A59381CBC0B5B3B3B3878787CFB8A2EFEFEF5F5F5FE5E5E5CEB69FA2A2A2D3CAC1E0E0E0848484626262CCCCCCD0C7BE9F9F9FDEDEDE7F7F7FCCB49CF6F6F67C7C7CF0E9E35C5C5CC6AC91E1D3C5BDBDBDB896735B5B5B5A5A5ABD9F816B6B6B707070727272D9C6B44F4F4F535353F5F0EC515151C2A588E7DBD05252524B3F34967757646464977E65B5916DBA9877947556886C4F997959B08E6CECE2D9EFE8E1F4F0EBA5A5A5D8D8D8E4D9CEDCCCBC494949F5F5F5EAEAEAFDF2F2F59B9EED444AF0696EFACDCE464646F6A7AAEC383EFCE6E6FBD9DAEF555BE48A8DE45D61ED666B434343EABDBEF48F92F37F83BF555E9A00001C70494441547801BCD68782E2201006E051F9D91086CDAC20D87DFFA7BC928A1ED7377C76537F3AFDABCD76A7F08DD66F8D360A9F4519DDBC69DD7FDD6D37545B6B193DF7DE69C1E711DDBD3BF4D8B654DB87C5FAEC07D5B52712873FC6CA7B01C07EF8FC434EFA2B5513446FE86018252C134C247EC7808ADF242EEC5AC2C7036DB404AAA4B15DD710C90E25298E14462AF6048803C680E34450D00951B3EB6C532B9683D8402783921FEEF51C077EF956D8B76077A260135C9D60C13A0017B9DAF467F5A5F25C037EADAF330A92BD8A06E06CA0F549876FD81CA7582C2A46CE3BD320F17350BFE490D75D315331094FC18E86A706B9B6BD75C8B17A6D48E93998C43917B21CD396E2D1E98C9CB3FB0AF3564286D36B894B8A332FA2F29B4FD986A7FD18A373A9C3A51AF398BE2133DFB664D55776067EB571904A3DEEA6697D0773C7223DDF99C47FE519C8832BCCEEE6506D409CF83853A252FC0F5EC4C742975336500DADE13CD74ACE98B069695DA16D033DF41D0B892BC1E2AE1FC3A5575C3FD9ADFE4ABC7928B6A94361F87A29910F48B803A9C6E05C308E9578BB0D5DEEDEEFFF4017906F11D89D48F8EB5E341FE3E83F078596EAA111A94A3DA4A80DD4589EBA826ED6F675E45D68F682B1F21AD9C1D97F0DFF9A29F0A8A762F4093BD92A20D43252067FD0973057856000C061485C894D288694C0CD0820055362BB121486F9DF27278B4605CB4861ECD39EC2F0076214A2499C320DDD8348743D13E2063C37C3831B2166D7D141D30DA771CA6D04F4070F97A59E4C6AA2305E295E0E7387EA2F0AF07C21326EB0F4C0F3A5C898CB2B42E6226339C7D213DF888CC51C1FADD11247FD05BD321178F1F776F07E91D6AD92951B80D4122BF0330D580B498C83EC8F712C246B40E9AF7D58092906817BCA6CA85E3E0B1B89BF17482D8152AC6C958908C90280120A1B71600392EBE237B23F8785900071CB74F3C397D63274F18F095A97A892758FE1B7E2C07C0210E55AD27325C93DA45804309D8B03B7FC97D5115DB60C255E542D14557C9889BF6306FEAFD6686420FD8EB33B7BE4FF20646CBD30C87E0CF05AFC2D6B1CE487A2541554A721FE287BCAC77A9B64685F3C80EEE990E1E1495EC6B7FC5AFC3DD77C9B2F04F25892D258CE8107176DD0DA3A8F28DB7ABC733A64D8381613926A8553518769988A91A988F1F6F41A4DB8B76574A4F12E3C1A3D0DDD82305A880DF67C9EFE588745C47D0FC7E98FA4921455188CF555F84EEFC75E36C4422C23807829EAB18C01A2F42031D8EAD355A1A3AFDAB7ED9F78A1FC322D6505AFC962B5CC2F1CFA8997DDD6E6054C99BE57BD782C7413F3EAE2650D951BD180972583A1C52AC94923D554D59575CA31E085881ADD87C3215392D344E86742D4F56B387494944890C601C0C9041550DBB5F146E86783D323D3E0649AD2380E68B581E4472D6B61E0E4C7C5BD66C92718707014A72C027ADF39432FA3ACB55B4D00D6C2046B80C92AC6C1514CD43CA91FF3EA7D68E3C74F8498CD8411E48167D8AEDE87FC81DE669954933CB94B9E0AD3DC916AAA277A7B30C7AE26F970973C13A689C3EABCDE76F485F90B04D8528386F47A2E1AF462DF670100CE588B1622BECF8EE6A0F4C54B619C17F428D533DF274847F1B8F47BA706D70866C23433402753BDAF6309732A9D8212E34DB301FB64FA658E062FE89E4EF27C224C73CB7F30AF071D5ECA5E204BE99443F35E9350ADF24EB107498717B219B3FE5F939DAEDBB8976478FF503E2CC602A4A3591E8D1C52CA50123E17A6997357A2AE62C8198D342DCE7D2E9F2B151BD6C2346BB08F676EBCAFF115D1F1CC904F17C2348B6978ECA5F165D10094D15A30DD473CC4D14C986716E19047FB4957599E61A0D7CB926224789524AFDFECDE8A2658C46F5E2749724D64B5EFF6F47B1DAE58E02439EF44233C4B32D64111A6747A61C5EBBDF4FA209A21C958A1A255E19ABC5A83C1252D1214DF9CC12BE145AF422F078396062D04008A177C4C7244433C49525E4391122900A0FA627DCA18EB16499EEECEE0B50B8B94D8658C697881EEF8E5C4EB479F1AF57A97A4BCF0CA9B8B7CA7F63B4AB02A1D25CE2FD89326BD3EE3EA46EEDA3BF746A8DA29932F8D7B7D21D5AE198D6A560D70AAEFF20834EE05475E0ED4AB1C571D799C6CD3A32B2151A35E4F93248988B275539EE8CE55BDDBD03B781590BD8C1B0DF12149923D39DA1DE0D5BB11A16333ABEC85DF34EEF5069723BDC5EC0ED46C2A21A5A3345F1EBC6EDCEB35788A17879476EDD6723C1880E215DE258D7B2577A1E2050F069A5E9D2B5E017C3D83D76308142F2D4E152FBA4FCEE095ECA95E2F99E7C17199A3548D86BD94CA71DF715DD090E7EF3D728053E4740F73361BBE9EC5EB2BD8872065314439388F06F5EA21462CCB63D937E9B53B8BD74E7ADD3F7C2C0CE17AF570E4573EC586BFF87406AF4F2F7865E3AF3FD2E52573EF96EFCFE0B5E75B791B9AF09245711BEE1AF7DA8552CBED99F0B25C29463EC9DCDB98D7A76F5BD7989792A4DE34ECF566AEA45E2D5EF26565775BDA4989764D7B4D4B5EDB6EFD5796FD8EEFD10ED885971FC2D786BDBE42E817836C1B7CEAF99D7EBD75B9DFBF1A8C2FC0F93E05F88F76FBE06BE348C300BEE989E62CC9BD424C8B3314074219592B8A3845585E2118443D233042E93DC47270B94E7707779BE626A7B889F41EF7EEF49E7C957B67765468815FB4F74FB53DA3DD67A7686624507EF698F1A5584181535560B52A78B482523C86C9651AF31BF00A4EA1D40A4CA3F6CBD9F9911DB311E91E9CB954A79BA5C9F7600D22D70C54445458652A2BA7E355B87320A189177052171E9B94BACD9851208DBB924E20C71CC9058AD00C91CBA0E1F760E72274B7519CB211414DE5ACA07FA4D2ED8602A5782CF84D37FFA3C989E8908B43A19E88D05C4913B396DE8916E8C5A72971C81E95CB5A49A7C185C729A5D350E18CE4B2877219F50BD09D4BB5E88446646013D0A24577F37E5815C9E5A4D3516DC2E31554D0697043550B61AAD47E68643F627FB7011935FFB22842720D6F329BC9AD76B59C42AB02ACB5B5B5D539A012D4D1B0BFE1092951C12A812B07C04BAC5698D5396A27AD50702E34568D8C103F8ED2F22BA34BE2A21788F17A3DCA23A0BE92DD5135649A18E4E4AC78628AF8736532B52E16CD0AB9F2905EBF387A7918B744D32FCF8B85945E86589E3A5AE1B22BD38027A14CCD0973ED6A426431C9CFD7F42BF47350BCDA5A338CA11329421ACAEB9CACA91A539994354CD304F2B29C78228D29C913955EC364A532A243BA2AEC042D16B966A8ABA8786D3E3A5FC282DDAD4768C6ECF041B6ABCC9299D7E49D8EE4AC8CB1A1D265EF34C84D294EC5EC713584DA2B0E21FDDD2C56B336071CF720B0200DDDAB36D8032B898714AEF4095E2FFCABE9F166F0C493614F3DFDF433B3672FF031C999A37F5A23C927C4CF3636473CDBC4C8EC15BDA240D21A1374F9FC07426B9DB40508C825CF491A789E56A55539DC15F282456A3774C014F5820FC82FBEF4F22B2D2D2DAF2ACADA9609F8D7BDF6D2A3BC605AAADA680FA724FB98875E7CA975FD44553628CAC6B56B5B37FDFD1F693EE69FEC704374C40532A545CBD614514AFF25C5EEDF9416B0B5C54388B797814D87253EE63F2D60F25C5C6BBC78F4692929CB428DFCDFF56D6D6DED93E4DAD0C275F0C69609C893792EB48A962BEA7B44679714AB6E4A73309382D81BD88C9584E4389A7CC0E06FE17A36D7D64E9AABCDBFD837D696AD6DCCC4B9ECDB7A7AB6B780977C4C89C34EC8CA67F9916C1AB58AF525DD21C56A07A566912B9E35571D214DEA0078523CF2ED3BE13A1D1D7EFFFAF5EB7B7A5A46696F6B7B796C2CB9B78D8B6EB1ED3D3DEBD7FBFD7D9B28DDD4B19ED7ECD1ABC317BA7DDD2AB6EF835C58554E774AB1EAA49598CB447130212207CBE5635E815BDBDADEDEE2EF90A45DCFEFDEB377CFBA75EB3A3A3AFAFC906F3B60A980C107F2F3B2B3B39BF8B0DCD716D6DEBE1DF2F4F5412DA8BB67EFFEDDBB25E9807F3BAFB8249CCB8178AE74375655530AE5627290D232CC3D82EE9D3DEF5144C2B90E6DE5FC07D5457F427FFF40C2E0E060FF5EF0DC73EB7BB60ACD629C84C6E5D0D690EDEBFB869F83D24B07A0DE40FFD27E755BD575F8C856F05A3817418FB2E9F0A80BAB144AFBA4D81CA654C1D854EA743A9061F6BCB848AE670F71C7BA25E67860704017E012FA0702B34E3CDFFDFAB123BCC45FA1F032B6173513BB0FBC7148B57EB8FBCD03D25BBA8101DD49AEBF3FE194C49CE8E8853F6F15B9C436E52E74D469869DAB996F7486A4D89CA615189B2BCADD9545C8609C17278773351F618E9D91B8B32707138202243C2B41DFF4B78EB0222C573561CBFA15C5352CD7116EB8F54D28F47630612020EA05FA07DE7957620EB4F6420135572A5C51865C06549443E13ED87ECE453BA5D80C5137C66EF8075BD15D902B3F92AB17BCD72A66DCF74F2604EE134E0EE8DEE7FD69F8582F789C75C3156290B27ED8CB8C1CFB40021F0675831F85F40F7EFC89C47D30DCDB1B952B9FB717A54EB63DAA30B12D52CCD3460E56D419112191CB95C2738D80D64F25D567015D60FFE7BA2F9840C2C9CFD4C1796E04F06E885519F08B174738FF09097CFED1C904DDE7FB79BDFB06129E12B94EEC786FE4391F68CA5ACD72C1F84248BCE19497E18298270EF68CCA2A3123C3E760F7B25C1E8F1734BF0776DC21A9CE7E1438795E3A7B8149D005674A5C3B147919CA565BB090E6F5E6BDC79CBB2871C1C0C9FDD2795E2F38A8BB24096786DF6BF582EC8606D15EC8000DC554BBB095D283B1E772BA31930CB9F4D9E15CC9E7CE9DBBFC9C24BC7D2118089EE24EEA02C1F312D73572EEDC8BB08425262C6442CD6DE7C015497535183C791FAF7741A70BBE2F096F6E3B775ACD4540B61E3ECF5BE5C29CD3FD7FC9059417BCE01AD8765112CE3E7DE9E385D76F5CBFB470E1530B1F94842BD7AE19BCDE2282C392BCDE7D376FDEBC7C42123E5B78EBF6ED5BB76EDD7FEACB5BA7CE4BC257AFDEDCE7057551B99C1AE72A50FB61BAC8C5670EB01C335F49C2FEFBBFFE66C98DEB379EFE26F8B9A4FAF6ABAF7016942CCBC561E9D07C19185FFEEA8A24CCBDF1DDD35071C9D3970643BDFAE2F7BC24705879AE38C8955F8AB9EA1C4D72556333150BA9BF8472E5794126E636FE202E71C7FBA7BEFEF1C71F8357D5BB3BD87D1903D86BFDA414E3B09FA1660A66AE7DD5FDBCC47CBEF497EF7EFCF1E32F8E8B0DC49B87B05A1314AAED5503B9D2CC987317E002C8A5C53CAF8CC955E205ECB18B8EF1EFA1717EB586C753399FE58515D0D649A2A6C939345EA3CB8C992C7E0D25946B1E4AC3AA722DE6F9D36C79682D531788F343B9EC495E90D688A792C19ACB0EDDF0371C52CD1B6C2ACB3393C4742872C5A36CCC294E2DDE97FB28EB843CD72390CBA0E6AA77CB5E46CE9CE2EE5642E3547B6C18FF8E436C5550316B8A7AE95EAEAAC1A3F05C2F402E71AD029316EBA883946D7ACCA15C89908BF194892BC35678F9646D9599CE9E7989C703CD750D8779D86CBA32E5610C2639D411AFEDF0783CF53C5722E44AC59C5993756F97D856820C347F7EA2837070C1B2A29FBC42727A4A63B454D81B27CB5EAE44F1108C6FE2089BFD05510DF6D0598DD13253D46A405EF6186980CB10C6C172AD8E74654ABBA5D817BE26AC820D5828573D5C5121F6923CD9FB4792AA0A89D56AC1F87B1CC5424AA638CBCACFAE26403417CFA54738AC3CE6E1C53BA213AB649E4B68F03410AE709270494D5545ECC8DBCA66F9B5BFE1881566B8D3EC9F5E9824928384A89710B9641C628DBD1B8221B603E392EF15B9040B092B749464472971E490907A05DAFBDCEF383A582EE1EC0E477634878344B198488863D53C4332164C1A9CDB80DDFCFC9F596618952B17635B712EF943B92613815CD7CEDDC4A398A6AA576C83578FE4CA9F97B82C54B592D2C39206FA20981983AC05C6C45412211EBEC962261331F39BB364403FFC1DDA6B0C78249354B39856603026D703595805B1C424AFC19154A53AD11B13FF4922A25711365B71349B2DF48766A5A118FA61F4F89AB29A501C9D0B3D129E0BFFDD2569E3B438BC91E3138B48840D4F6D45866285F6BA8CFF044BD4F88A43E13903069746BA76AA87880F1B13534884094FCD4678AE8DF84FC88D9E37B6847B61B7A49983E263E22D89473D24AC184FCD54DF60B5E03F150B93A85C8F3F8699327ED4AB9D21BE9CC2CBEF3A5AF63F66CE234971240AC3D96719EF1D15A28876222AB44022A53F451B89924E0027182BC641ED2008D66D56B39B3BCC66FC01A61DD0E61C23891784C6268950A26F57BBFA79EFFDF93FB9A221CA69DBA64906534AD757269DC8922E542F989F1F6158169C6B971949759D9778448FE87CD0A42BF373C62A28D8CB58158D5E4EEBBC5DE6150EA2DFF1E4E52A53B09721D40C7173183CDEF7951BE2418753B912C6AA28D8CB02968AAED3BC07EDDFCBD9A1E177DC32F751E4057BD9C75AC510792B9DB0E8EA27648844B7AB661B46D0313333A4005541C15E71C00BC9F40D0966EFB21945D183C7C53DA5DD6E36BA4ABA22FCF1460AE5DD0333CC0B662250307ABB176584C6EFDB7D39171A7695EC700DBF8AE922A6F98D66205630442FCA71CF36B9B77D6E46199EA9641B1C4EBE9E8C58150CC710661A64DC62F295E02CCD1C376AA541D124DC95523A343C986FB47AC082554202E026075730C466605ACBC66DDBB6EC0DB7B3BF7AA6921D4640D715C09C55C4C518299E8A21BA0D7F79DB711E38EF64840F1CC7F51BA19A1DBAC899B3CA58CC9012AB2444A2D1B87CF972C3DE2B4585481927AC4A92F9AC3860BB87A2ECC96673BF14E5613ABF3F6115334028310E394AB6110313563D1708E4AB65795A85D36BC434300162A97194A7385E03A68311D62AC6517AF90A70C174300057338E724B4AA461BC28D90BB56B52E5969407B8CBF4308655F980195B7CDC677A9822AC7AC0CE8A2E3F647A488A4E5FF578AD6947D6DD8867D58E17B5A1FE46AC66C0F4B721450EE94544175C9E29FCAB9270A82B6C1033F46511D101AECAA26D0F5C160E5748983EE6E0D288D8F571D3FF3BDCC930731C01CF96B46144976A34310122B9D3BBC8F1523D371DA2E10B10F0BB5297E7940DF53B87FAAE62A7E232A9B66C4721D7D0C910223688CB157CF4905862CAF4329017ACFCA11C89F190E96552D856DA15952BF6709FE96601589282952D978F11D34F0261ED3E61ADEC65745BA95C1CE3053B02536CBDA32953D55865889ED3DC391A2E81841D85EF11C4D24EA4E78608CBD8B50B1F40FF706DBD632BEC447629F08468EFB8783D00E6EC584C66F0E2831E62A72D8ABBC0801D8FE1188175C82B89275B5953764C163308EB700B66BB16B268C6847BA853ECAC26B24818258FD6E9616485C796454C810787F08ED36DB5EEB35A30023805C5F256C88184D583BB00785CCE144956ECD54316E912802715268B24246BC0EAC21CE88B52C24896150098D7499761093AC8CEF6BF3BB916F0EBA6CBB03C04EBBD8491ACD8CF7CB52EBA287464FF171708A915F768422B809716BC2E264F67B341E3B18A4998AA13AEE947C194D588C9EF4646BC42D027614AD58A4388B59191B05AF1DD0FDB2597D301AD502D4B643D98F113AB1B24ACEFE5BE78592513726019D74F16F18D9113738047C6C9E9AE4FD5B802816B643C7DC6EAC84F06952C8070775B5BDAB9BB87F146D673564F7E7A4A255B229B97E60E8EB104BCBE91F3FB0B561B2E5D62459E9330235A01ABE8B26CB41E088807C6863F8BB96F28C7AD2B0CC06F700867288B732E0EFE0DA54AE79CDD39E7EC9A98DAEA54BB3FCE56A0DD71A650DA005618654101DC04EC957144E73023811BA949CA20EF9038208007E5FD5A563FEFBB3F1F2650FEB17EEEF4C6BABA32FA47561DF4552998F8E6B7B2643FD5DD3D3EFECFEF647DF1F38F8B8724D61C01A0EEAD4BEA1DB5B971DA00609F540BFE7F22FF0D6A7689FDF18FEAB62C2BC169BFECFB955A7024884C0B80F3E091BE7A47DCDA25646CC321BA532D5A7BECE373DFFC5796ACEA4FCA3FF5CDAC2DBE23B39AF8CF336A518F3241D446C63EDDDD7C9BE774E434322D03A08923AAECD98FE77E3A99CA773E223F98179FF8E2D7BEF7ED2CEFD35282758DB1495336A2C89C84B31FBCB5FF76855A35009886EB134172FD4555F8DF2F3F9EFBC5D3FFDAFF0A5591ED5416EA1BD281E237AAC2131D5F723944E425690B80B3D17F7B42D9864B0292EB6E55654D966C1EEDDFDFC84A64E63BFFFAA75C99EACEA038CC83592EE12769FBAD8EB6D9350033F149E4B9E83A55E9CC973EBEE0A7FB64A7E63E7AE2ACAA14B23BCB95F3A216406F51B4A58D3C5429D72155EDBFB77C45FEFB57E7335FFAE41D6BAAD2B55C912B8F7644BD59FD2ED08A7C5AD042401383912A935E9CFE67F34735FF78FDC99B9E7A54D5788439A18C059F1605A905FBC8D29B4AF52060BB54367B1FDD3B559DFF3E39FB17E532A9461956951E67F2735162B46177DF70B27502DA0E912E57784ED5593B7693CE2D35C39271658692AB5A64010FF6DFD05E3D08B413AA66425E613EACAAC996D5C77A56D5BB96273ABA5CE41B16B0A15EB70D5B5255336090E4E29ED2382387B1E4E6B3AADE8866B91CD82EBBA137AC4C9602C6FAEB6CF6D3404AD5869DD0352597CFCC34521A67EFA848F5D87F95CE9D3C154C73F154EC7854E6B580D5A5D7332CC0F4A88AE7C49C496153A6C3993B95D6D9C5357BEAAF4AABC722244A60F29C5B31B6A40DFB358F6CDD811D50D9D0731216295AD3943CD1534DC9E434CAAC2495F6148A019181159E9168B4C8B070BAAFF444175644659ECBB948163A943776A41AAC3DBEDF20C71E554D0ECD4310A5855C92D6A7222F05D655B3BE8D964F0BFC41C205804F440E4F1D55CD1EBDE3B19BF35169BB30CF6523E2923818921001E0A86604A045420C8398172DC3212297C59DAAD1F90B172F5D568D4621CF2444EDC55C220E29E720D3554D6EC53868634C737E1873D935888868FECAB5AAC17317B73297B65583539C23021CAE94843E09DFC2D883DD577A4BB6E55360E58F070E5732911211CF84E794CECEA52D71F142E372E586012C97EB38721AC718131920A5B78A643A5B9B263A2ED758819DE7CA9CD21EC1ADDCA51D55EF0916A2E3C28EB98ECCCC933268E3567DC543028DE148AA3A0640D461A1EF8ECBBB5B05F5237B800B3A0652D61A0C5338248358521A0E3C294F8C7D977500BF908B0F6936AB686FAD2656C805C11806EB25568BA6C658D57E7419246CB0DE87E050C0423CA12A6C5FDA2A79BEB7A4F940CE853662D64B91CCEB6353531A6D1294341D8116220AB9E00155727C6FABEC8507D6AFAB8875AA74CA8001EB99964FC2D554C783925E0EE28BAC65624C0EE72AEF1DFDDE4B5B6517D4A8B7F93B5D2C61C00A596FD924926464D7DE3AFAB0671741A2D60758436E88033793F0DCA962B0DF6D6E8ED4EE56C976F6D275BD912A38CA9941B46CAEC441A7E3CB99B19B727D28A1613CA0890054DBF12E4DB9894FE9326B45C0A4661DD7486D1B303A1D2F2906FBDDC1FEA40DCBE392137AB0B06487A5063A09266CD3881C6F0CC3653D04944597AE336B06D6479BA606CC2E25D7341647AB0D08CB25CA62159E9E47FBEDF0F256D1EE2C76AF5F882506411B3923613D8B860973E24BD79FAE29C384E60F1F9E63B3DE0730B1BC6C01B647437967F3604BBDE34ABC528C753E9FE77CC98EF05CDC3181F1D86C2D03E006862DDD15CB86A1AF2A18D22DC38433B10FD64B5F4C53E6288B671075622E5E81CFE5FB73FE623997047BE0E0EFCAD78CC48B80959099A3941BA4E950261ACA3E7655D9118C65B978CA6BB1D0323E847620CF61856077DE30EFBB7C5EE21595BBEEE052219618846DB402979BA591C7C2A78C65AB328223A75038636EF62230F6C98F173F9F0FF39FAB6289CB2A77EED403EA015E147B262C839BBDE8C42C5CCAA43852D71AC398451271B30F604CD449B8E8C8296677A4C4735B8B2E159E22C327422EE904B0226E66063CE3D554FD065279B29F71B95974009E2C64C9B56A6A7BAB6C47CDBD9BABB864638585D68B713E63CAB4CBCD61C093D2D0E52A19C394F7A2E46E3575A9F2BE31731D57EA445866A197CF54AA239DDD7E5F05E02E637824B2EC080000000049454E44AE426082, DEFAULT);
282
283COMMIT;
284
285
286-- -----------------------------------------------------
287-- Data for table `ecommerce`.`user`
288-- -----------------------------------------------------
289START TRANSACTION;
290USE `ecommerce`;
291INSERT INTO `ecommerce`.`user` (`id`, `password_hash`, `password_salt`, `name`, `avatar`, `active`) VALUES ('user1@user', '5e884898da28047151d0e56f8dc6292773603d0d6aabbdd62a11ef721d1542d8', '5e884898da28047151d0e56f8dc6292773603d0d6aabbdd62a11ef721d1542d8', 'Rick Sanchez', 0x89504E470D0A1A0A0000000D49484452000000D7000000D70803000000BEA33487000002FA504C5445B4AEA43D3C3A2E2E2E4242424040403D3D3D3F3F3F4141413B3B3B3939393737372222223A3A3A3434343030306B68637D79733C3C3C2A2A2A3433328F8B83363636282828464542A19C9326262673706B32323298938B605E5924242458565287827BABA69C2C2C2C4F4D4A2727262323233333339C968E49494963636361524A7B7872957B6DF0C1A82E2B29554943C9A28D3B3430A28575897165E4B79FD6AC96BC9986B88E79473E397B695A705E54C59882866B5CEDBA9FEBB69BA07B6ADEA98FEEBCA2EAB3976D584D6B6864EEBEA3837F7954463ED1A088927363EFBFA54B4A4853514F796155EAB398EFC0A6E8AF93E5AA8DE09E7FDB9372E3A486EDBBA1D4815DAB8572DF9979CC7049C7653CC96A42D17C57D68763EAB59ACE7650D88D6A464646CF7852D78A67E8AF92DF9C7CCB6E47E1A080C96941E7AE91D585613B3A3AE5A98BE4A587CD734DE9B195E3A485E6AA8DB7A090BF80634B3425ECB89D9D5435C27756B89B8AC569426A3F2D433025875B42B6A497E7AC8FBD8E76EDCEC2F2D8CE8F6B5A7247308258395F3724432C1E3D281C745B3D644C32E5E4E3FFFFFFEAC4B7DC9574FCF5F28578716C5539623925D8BDB1C17B5CD89578F2F1F168523670573A60493191867FE3B29DCA6E48E7BCAACFCAC759432DDEA086F4E2DA523B2D785E3EFAEDE6C46F4AB6AA9E7A6141F5F5F5998D83D9D7D5B65F3B816543F6DDCFFEFBF99D9186FDF7F4EDC1AAF3D0BDF8E2D7F2CBB7FCF2EDA39E95F1C6AFF3D4C4C5BFB7AA9881A38E74F9E8DFB2A392F1C8B2E1AA92F5D7C7BF8469BD8970F0C2A9E4A689CD9980B99783B47B61DA906FBB927DD78966CA6D45B8B3A9BDB8AFDDDBD9FBFBFBEBEAEAD4D1CBC8C8C7DFDFDE5A5A59938F876666668B8780434242B2B2B25B5B5B4F4F4F61605F4C4C4C595959A8A8A8CFCFCF565656626262939393BDBDBD5F5F5F5252527A7A7A5151519D9D9DD4D4D46464645353535454545E5E5E878787F59B9EED444AF0696EFACDCEF6A7AAEC383EFCE6E6717171FBD9DAEE5056EE8F92EC5D62DF8588F37F8382828211C320C700001A5B494441547801C4D8095E833A108071CB24C024217D491B2AA2A8E9F256DCF7FB1FECD1122C96E2D242FD9FC0EF179C4C73B4B381073F42A80F4E10628571010512C10A919C0F8F7ED51F9CC2CE143A51D9058A4149693E1AFF6AD8C883FDC398EB02A3C011319F1CFFEA8129D81DC59590332845042A2CD127BF1836D0B00722702949C191B096F2C1E96163CE26E323E754A7B0874061417BE09014D65472E0F93189B3D1F9C5F872AF2FD1F1115126E0B8A1E810CBCF2F0FD9253DA9335E4A1202FB084264B5B14A2481358F4F0FD9E511C9D0515E4C602F546809AD61E707ECD2E07B069DD0660AF642A2046A364F6C32393B3D4C57060046A2234C62603F02EA52556B8E796A67F3C121EEE929A70040E5021D0ADD8A6A61826BC428D17FF4DF357417A95AA4C67D8B043AC528BCD3DC20B2F80033FF82A7E010DF983E8E4C30A8182EB160FBDFAC2EB9861A4AFC02814E29060EE1312E2DE6FAA4E7DB6CC009F44D0870E20C57989DF73CF44FB8817ED59760CDB144FF3CEAD731B7D0BF74A34B0E0F30E9096CA554F75FA29EBB2E3E3DEEF7B8C6273C85ED52029D895CD70C4B72CE079361E73FCBC6E393E17432E2596C1771DBB64B6477610656328B0EB3D6A6C3AE6FAD014FB4E72D1816CC5CC276544257A8828272DB7EE08758B8E861CFC852A58CC025CB056CA73CE80A8182D15009A898F4F39C1101086622446CFFDD650C2C053F4FF85A202FFA081B97A74419C3686E618D424DB40AA3F447654AF9DFEAF78E7B3931774A840A39F76A295013E86558205011F83E1FC577D24C3F3BC799058744DC23E0500335BE3400401031F47FF42280A82881CF25A7BDECBCA3082A228B153829D4A95518456CFD4B7D4AA91FB4BC940A450B2D8166DACFA5AC155488E629DD7660014AAFFE7752B2ED700A615804AC7F0D9010D77CD82E393EEAEF5FCC619A5B439B8B868F910D0004BE0B378F47E11768CB9C94671DD69C0E87C3B15B0E2DD4A854A7E5A0823A85CCA310B8B07A1D6986B577050A1A94EEF2F33B1F713E3A5D8D0ECF1268620C6A96450B6C86555FDF92F8BA4B09684A2E3A9D18675EB6DAA8FF021DD32F575E8288C61017B60B0A4010FD1E3F44E76F22333EB900A03613D024EB616E1AFA81D8A34B2086D0C0065D5F5E40D384A700B898A7B029A0D196C1A048B87397DA3E1609BFECF8F23A879240338B056C08C5C7B0324810BA63978F2B016C8AC75DCEF7E964C2D8FA28E4DCA38D4D48928DD9B14477098B923996146CB2C3EEB2CE39D73AE1B42C70EF439E803A8128D59630A4027FC89BFF93B43E27A7E75DFE5AFEF743812BD366635444D8D82A0A22C49F8862FE5F7EC5DAC2D8E4A84BD3FA27576272C63D46AA0C2C9888D6C2143AE177CB16D2CEF8F54D9EFF23B142E0031177DA956ECE049716739DA6291342286C9451ACB0D632268B98955996C519BFBDCB0BFF696C0953BCD36928A1447C4A15D688D135779259214EB44EAB3822B0C4626BB0DD62455ACEEF1FF2A587396B5B8279972FA4E3B4EAC28FA2C9639E3F3D3DDFFF73FDEE65D9E831416AFF64B8C8122B196EE78EFEEAF53177DE3C6C09E35DFE063B49B76FACF22DDFE2F1E9BFD521C65AA6D1A2A2B32237B60B6C5A7831E72F770FF9BB9B8CE11AE9AB6B18C1B603D3FFE5AD9E9EEEAB437CE175F3D9CC5A2B178E6767BC887ABDC93FB8B758437AEA9A886DC340DFE5DFF754F8EFFEFEFE6D33F4EAEDEE316F7A318DB0EEBB06A279E1B2D865EDE6A97493B778F45823ACF32E2EC021B4EAD2F779AFEE12AC0B7AE952EBF764C7BEE53DBBD7582382EEBBC6DC6D466BF2E521EFDBDB87B010965476D475577DC69BAB9BBC770FD7B6F1982374A78FF39B333EB9CB0FE0E1C5C31AD275D7906F6C86F63A3F88C72B89151A40C1B02EBBF4C74BD9CC1FF3C3F89F78BB4A8B188801000C5B85746D702AB8FB0BB69E75BDFF6D90A129ED7BBECCDCE0AF44DB06548A1D66C839F28D55B1A73A6FB6845CEDCE455947439AADB2BAF694563954CE3D767B42AE16F6298DE9D9BD170EB85D6ED6D09F377128E6EABEA85CACB7D521A7EB941EC1F47689B97A886F50C9457A35E27485F9B6FEBC8FF820748688384E363396A522669765A59561191AB2AE09E82C16E8D237B9E276516D78FA8EB22E1C27DAA557B56A8DF14098EBBB92A9A06BF6EBEAC00E2531BBC2ECCA58159820B61FA4CEAFAB0BA56C1B3167766535947A4769178E15858D60C1EDA23EF9622AEF6A9E53D82857995D541C5E4243DE35FD75F9BFB0F08ED3B5FEFF1C9E02CABBDE12FAF43BDCE6FD2B259B6A9C8F4DB8CEB37283D715DAE482A501576387DA4A75C2EBA2D66B07A626EED7A95E5773A66572597E1A36DE4CB93602D7B212769793868D8609D73915BEC0BBD52BD92EB9D09CCBB7985D55454D8A19D7E4CFE5F1BBDCA26B25EB42A03A8ADBE5155D68C265B3BB8E0FACC0B82BB0D85DDB6039465D2F97E97C9EDDE5A6331BE88ABABE99390BF7368EB481070B914BFECADC34F0D1048E028F2993D339D53DB177B5DACDE6D56ABDA7C4829C243BA030B3B3B1CB0DB39D32BA75CACC4C7FD0EDBCAB9564903B2B6D2CFF1E284EED9FE6A519CDD300459A2DAFA99E7BE1F744B6D70D765FA6ADC441102D82924D501405329860880C4156E4217F431445294748B49089837F88D77F79EC55E3CCF3BE1594E12788ACAE84E184B5886588BF9C2C8142869A82A6138660D9686D3002117DB0D7FF4EB7BD1EBEC35BAF89B73909767B5DC14B96C2301A6D9A16060891A1840134FC47A541F582575DCEABC6F1F27CF09DB434EF25B601070A19460838084B782F7A75BD1E98E4BCF7BA6DFE326A514F88043C1832194E300C1C6832BBC74656CCB05FA7FC0BBDBC6CCCF96F2BEF5A805EB2068CE82A555C6D21B6B7B71BAB2CA21631C8132123221489B1150A5B6AFD27E2AB19F1555A02B74C70BC16E4BC1E78D8EB87F3F90BC419E89564311835D06938E88988A48458BBCDEA52B4AF616A62CE6BD94C3B0EFF8DD736DE7EC17C6D91572A060925BD9A0352028EA55206204E6D7CB6D7F51E7A213E7C21ED7825333109B7AA7CAF0E9EC57125D1499185D3EC3AEFB5576D8D93603328A58AAAAF46CAF76AE15AADAF5592B9C68C5E1E5E47AD5B0F161B6E701E8AFA284D514AB37C5A1DA4045CEB8500FE308BA5B6D79C8D00B0699D075A9BB700632BBBF1CD79211C81C468212508F0ACAE273447DD24F4DAC6BC60CBE6CABD36012892246DAF755E2CCFA788DF2F0C2960AB062139BF592958248B43D6A4876AF9698EC6E9E8E593244901D854B1D60E00155F9FDDE5BCB769CE79117F61C7D25118466C4D9C0512294560A7A48DB06A552184979082D702F4BACF472C54801D957AED82B08C2F5F7CB997D8D3725E3221816C6ECBD64477EFD9BB6FFFFE03070E1C3CB4E170D7A123A6791432AA14F797DE2E51ED06A5C7341FDDF058D7A1431B0E1CD8B77DFFE34FEC698AC59913D571A7E5BCD70CFC96682EFECD30ECAAD4EB49D00832A7C64EB059CB2962075860899CEDCC3CD5633EBDED9963DB0E21C78F1D3F619AE649304A5A2172F8548F890B0F1E42BA0EB385BB4FADAA0F149E0338CC60F3C614F4221A3C59797A4904993BCD4EB0597514C9921CA1CC69CBE2CC59F6A9231B0E3FB6D8B4380722190DEDD479B6F04261E1C563CBADBF73C9289CCFB283BDEEF9336148952758AFE3F5E77B30C1F25E0DC44655CE9BB6579F39DBF9F5169928A69151104FE5165E7EF6E90D83179E6CD3894D0375F031AF49FF9FF3EAADD46B0BF3920D808DB576824D5F40911682049B7A4CC611CBEB8CED75FCE2B1E74CC4104969B43D26E3E9B38B9E3FD36CC7E1C5630F9AC89E5532415AA84333F3AADD1896D06B4BE571A810120180175841BC16BD6C0823B5DBCCB1E8B1C3569EE0A77EF1993326D2132225D18F9A367F7ECC2A348CB32FE242A4A7C916A383BD7C2F0058620A6CAADC4B2304C2A01973F0F55FC18BE5B6FC92E970E4B1C3975FECEAEA3AF6E265DC2EE465521267252EBC7CBCABEBA2B5F015D3E1D5D7B02C0DF69A3A47030042B4CABDD60310D2A681429B6B30C16650C4B9E178FD528F69F37C9D256671F9709F99E38D974849FADF78D31173165E7ECBD9AD57DF18200C7FB1D794C9D39A35D0DA0402B0BEF2FE0582AE872041EBF06D4AC1CB9924065EBB72C944DE7EE7DD77DF7DA7EF6967B3FAC9E8BC6722B8D0E2FDDCC22B1F0C0C2DF3E86595C3E500215D14A0F2FEB5192028131286D482E9F8DDF9102F44903FDC836E057ADEFB6880FC11FDEF396A0E7B8E0A1D322125BC6A1B214C881C04A87C40B48FF206C49BEEB2FFBF0014710ABD432075AEE9E4EE3D3647FF2208840B39259C3E79740F72FAC373A1216372C360AFFB3F06836019F362EE5DC99A0DA874E11496603E9A431F69364264E20E4144C87074EAC0D2FB963906B6FA9558362AE41300F6D9834197B389632A7A21C4159F9232A005165E37F986A506B08F01E0130F8E95D83188D6491BF1714AC1CB4F78C9B2F252FEE53CE2BB6EF2F44643C3AE0C5E1C2CB760201A9FD165F8C8B7E0B584F0C236FC83F21EE939247DD74DF12D330C0CC32D133C603D06A22A523A1FBD96150A222F9FD513D25FD6E3DE3C9FFBA64E5B48DB550CC3F55E787D8181280A942EAD615E0B0A0591936CBA4CAF2CCDF3A56FEAA4E5342962187EE185571F06A2481AE88A1B2CAFDB1B0B0591930ECB6BE075C243C932BFFDAEA9F7AFA07E11C3B06F82478128129934D0269660B575AE0BE2CE72BD68817D336EF0E12B70D1A330C49123821F1E76B0494B5D17C474BA850C5CA9A81C765E9831A9197F6204870D4FE805903189EB6EB366B466EA20132EE4749A92818FCA7A3BEFF0D586E977D5B10891A170A6F460F60DA2171B116F9B435D16C47AC7AB8272A8CDB8DD7EDD1EC499D71B7600B4D95743D619ACC6D7E4B22052DB6BA092B211F3CD9C8F67F436BC63F3882701046C924B6F2B2EF42DDC5E02E92FC3AB853AA4C0E75BCA3E481D9CAB288F5A988A5E8DB74F9E7CD723AE0A077AED44AFF2CB46B7E5B5827961F3F28E2DA091567CC83E75F2F4E52E0BC74EC7ABFCB2A1808F857F96B4F1CF50DCB7013855DF585C10B3BC5E94BC8E5EE5968D045C68C62F7FB17979C7D700221E861EB96BF2B439D45DE1589B4E67D1ABECB2D109896616254B429E86211E568238AD2DF3DD52E3A37938DB725A26AF5FF994202D1D7ED765E32BD0E6B0E7300103A06F82970048C46F07221644FEC2D1B0D3F2220502E9F4DA7A9787140DBE62DD4B271A36658FBD303096DF35F9FE05FC9D596656E895276DD1C1E125D33C0029965E325E1C7A4A2F44EC4FF063DFD4DA3AEE0413A4F4885E6A9BE022BD540015CF0FDE7BE1B52F91DB01B6DD3009BDB83AF3CAEE34F2697FFF07030303FDE8C5D02417E9A58085DAD07AD5BCF430C0D6DBEF412F9E0413219E46E40FAE7CF4D147AF0FE4BDD6682EBA720C2CC23A3E18FBD85BAF27D984481408ABF37CC55EF21F78A56D3AC880B5639FE6A6E05447728DC29F5E9D10266A18D80ABC89F2924F0008215A5824641BC6215767169CFDFACC5FD4CD2821816890FF0EC060B91D0A6B57CF4BB1B4C8DEDA2F296F8269DFA41A8252BB55DA03F96131C5FE34EA22BD32C03E84E055D9AF5D003A212162F1F98C18E54D305D0991D04AD0F2622DE9741B284416F8BB570A4FB5440EE21DC0D7DE7A6D0610498E17204EB93B98C0EC544B8CDDB50584743A2849BAABE1D0C0CC4254BC03F0923E0083E48880425D8E8821236D6D19EBD182EBE110C310C12F1C3CA6175616AA5C8216205CA8DFD8F5A3C3E599D20943440EE3A1D2EB045309221B00DDBC0996C7F8B64D338480FB1BECAF202CE5C454CFD30B6F47514C30C042E3ACF4C5C8F58172CE5ED89423026A793CF522EBB680432F40923AE8E46AA0179A32ECCAFFE42DEB2678CFD760B369F384DEE2400C10EF69A50E8A95527D9F00E27D14223BD66FDAB47ED73AECD231DE510AA9E046348107E41DBBD8CFDE31E12AB303A093BFD257F2458A8A2935663C59DCC25A090FB22A4941D96D958F7A3B38715C28265D5FD38BA2EB304CE1EDEE18D20B067720561086116CC46306560EFE402CFF023B81F3E018B2630B747B5211E5D1C2B07B4CAB06B21E62A3B6665DCEA795A4681602414449D322C1A21541B9F4CC1BE3E858DE97FA78E9D6AC2B868468617088C8849DC56C5646545126441055A3ADE4CD461CB76B8CD904D1516644590C46B41C12D20661430345D5D96BA390658C1821B1F46C181DFBEDC29366DCD51761BAAA28829BAA81DB55DD0D938977C8F9EDC211AA1A1BD6ED6AC35C9E9455E70EB49A25D14FBCC24F6D9209E77557154AE257DECF1C3AB5D1F06AB72A7C5234D62FF134BB7090EF9B502D7A2193CF30BE614A144535484AD3DA52E52874A62983EB225134340B00C86846BC9EE35E2353B52874CE2BDD5CA5A35577F6B5C1CF513414AC85556417409CEB02A7B55E6756D9004FD13030B9AACA7A4838B523EBD5B9AB1B2F9EC68F98ECCD6D4D5EABFA629E74E7805D0BE3789F36AEC45A2A10734A4B67627C68611B4BA814D15B2B9D0BBBC7C76E219B00A0BB3231A76644001BD778F14A2440A94CAC3EFFA2E19371E415ED8C41265981988CC3530632E3C9EB13009ACA40A6B36C31D4C2CF66BC79D1A402F0559962A8D58DB13C8EBCBEDB05402DD4044493E588657315A39BA2D7F7E3C4EB87F351B05B4F061271D77D0CB5E21988611803FCF5C7F121F6B669F628D4C6008824DD89B536D8EB14BBECC039D3FC695C44E1B3A625F61A6560EEC7B047CB2EA68C54061B3B72D4B4F8791C783D6F325E7E9DDA24236017C62C5792F95B682A827969F386C9F8F1BBEA6FD78FA68D23463B3580AFB8AA07A6D65709487C450B5AC8F355F7FAD974D8436DF0578D76722499955AA9689155F69299E3C7AA7B3D6BE679833AA4A276FD90478F413DC9423095D77AD3CCF34BF58B619158963AA8316B1F92B4619458AC67FB8A116BF35A8F59E0D7EA6A3D845523CF9B7931AC1FB1AF4AC76240EFCEE0A63AF4BF6C16F1E36FFFF77B959CDEFAC7DFFF39EB88594A8CA634CB4C2DB165F5ED3100ED3FBDDC3594DC581606E0401E9D5373862A50D2D9D26F99F264B00D89315B06CDF2D6A6CECFA6FD769D393F67A916DCC3CBCCC96097AFCBA26EA95BF275911997F5A4AA52BF12F5E09707FDFBC2BB324D5B507A71552808C0B1A50B1FFA6033EDDED7EB03D049A8E44336238F0859B313CF14D760727225FF5DD172EE5B62C145DBD10C0047DD233FFB60325D583A8684EEF944EB62D1EACBCBDB7C2259205FFBEC5FD4663CF58524D5B3DB539DFE8D58B44109DB6921D1E92DED7E9FEB74A48744DB0348BA288ACE2DA7F2D72C29CD77BE9EFFCEAFFC8F133F939E91EAC650FD98523A1C476BC96CEE859FBD5FA10EC9DED3BC20249AE6DA14255E794649F6CDCF7E25FD2F62A524A46CCD7CAEA45F88125BEE9E2C974F44516CB6654FEEFBD9FB134AF70292E6B92E8932AB72C894A27D3699B4CCB3FF9047567D0F4A9BDCCB7349616CB6DEEB68BB97FA801687945072D18A2875EE8913CBAAAF7F35B5BCE0C9DF3D2F4AD91CA8B9A4C86903C7DEA3681FDAA78652725D16E5BEF7BBC3A73FB75CEFC4E9274E9E5B15A5DEE2925C79B423EFFE955A02DA4E480BDAB049EA7545B9D51793FBEF99D34F56657AF289C3270FBCFC8AA8708939A684819016D9A681CE910FBDAB542EA0075434FB750CD64595EFFD3C3B6E0F973890528AA5187022EF8B02AF85CED23B4E76FE18D0F289EA72D96F882AABF5FFC4FC77B25895E54A0CD55C2AC700DC9FBDA3B97281564CE534C424312BABBE3065D5B15E12D5DE62C9ADCB45A16700FBDE7EAC7D1D3595CA8337CDC5035143FEBF5D657EF1BCA8D6A5592E1F7AC0811D0D4B939940FFFCDBDCEC3DC0A47243D70EB42C57C8CCD415359E3F5792EAC5EF893AEB9CB2D35C9C1AF91115456DE0D087DE4EB1002DA232913FE684099D122E27D645ADE717C7ECE5FA547269CC72C5D0782E9814CB16B7D0D971C9CE1F856E97152AF263CE98685362C2D2403425FB7973ADD42E947AB2DD4DDE2E888A1361A0B7B3FDB104C329AB54C03907A084CD92DD150D567F33DD207F784534B93C0F4164C2E205BD9054511FD849C97ED6413BA4057B7A312B903E983EA7AE8866AF9C7BF11779A96A77619E4B87C305235BEDC70038BA835CC700B4D5FEB3C7BCE8A1F4010B38B32E1A9DB97AEDFA0DD1A86BF34C4CD45273E5C928E723B1D4FCD908CB6EC1DA562A7BC4450F40F6EA3CEF5BA2C1CD6BB712D76F8B0677384704F85C2AB6F75026346045E8348DD8873A4648B6917F1EF85C4A4B9F019EA9393BA4BBD76F65AE5D6D1CAEDCD0861170157F4892256BE0E15843AE4388D3DAEA24B90157B0A0E7B912776A5BF056EEFA5D516D8BB77303E8C509506B1665CBA0850BF52B7E1AC882AFA42AF0002297A5A6DD71E3DE2D4575C9D658E1CA355FAB3734B3CEF2D1A97D9F8F22222982B527E03A40A8E4E2CB3593A5BADFAD8865B3C2B6E071BDD86853CAC2A1DAA7CBA38C0EAEF7207C527F8E2D51E2F6F55B05FFDC385BF320E76C1D63AE67229EAF8FDD354BA3455371530BB4E12CE4E2355170F65FB78AAEAF6DAC94C4BA53E832A0C7F53423A44C50B33A5C993E13A1CFB53458E4B3A27877AC6C7CFB56D155D11DFCF8F5C658ECC1B0B9DE431AD174E3EB9557C7CFA0CF0E41A2F6AEA60E68532F48C43C77470DF6FA6B3FEE8A7BB70A6E0BF1FACAA02B1457D20A390F69E678E2BA61D633BADD340D310D473D92ECCA821D4240A9200EC97C886B394028CFFBC033751DF05C7712ABC15E1FACC86D58522EE9EC4019B24D96623786A46B9EE34716BC80EBC196C3302149AB28D8CFD0A2548F39A0F881C6C5D16E61CA08889258CAD77377FA83DF5FDC1AB3D872C8945852CF6E21E7C55CCFA061CC1C87D9AEEF552CC398A48813135FE77ABB203DF49001E8110D0396F260793DFEADC4BA7726AFE77CC82EF2DCD8D500CBD2DA0F01E0069E9EEDAEF174C24AAFA97EB65B8631274621B89ED9374D662789E711B923564FE03736E62D79E69A52AE3379A3AE0D5E2F9E1971E400A62D5BDDE406A6398C59B22911979EBF47609114702A6AF30E780FA26567DF614AB0F5AD5929947A49FF16B995C1592556DE8BED49C0CD4C67C299B42446A7F4FBC49F75A1E45BDCAC0F5821ED192FBECF9BBCA9C452DC10B937EEAC89355E349E68303C6ED6F7C79C092861E248D5D618CE1A2A76B8D92E59633766D5C53BCC41777646159F65E52BD2DEB2B9C0B56138DC4CB3796652B1EAF7C1CCBFECA53137731E46240752A17C91DDBE55B4EDA2FF0F97094887C53BD0CF7FC811255AC5CDD147942D8D998077C082A64C57EE92485D2FBD376656B894EBE021DE098773B66CC4D9F5FB7F89D874223B7F58EA0000000049454E44AE426082, DEFAULT);
292
293COMMIT;
294
295
296-- -----------------------------------------------------
297-- Data for table `ecommerce`.`category`
298-- -----------------------------------------------------
299START TRANSACTION;
300USE `ecommerce`;
301INSERT INTO `ecommerce`.`category` (`id`, `name`, `active`) VALUES (1, 'Building and Construction', DEFAULT);
302INSERT INTO `ecommerce`.`category` (`id`, `name`, `active`) VALUES (2, 'Landscape', DEFAULT);
303INSERT INTO `ecommerce`.`category` (`id`, `name`, `active`) VALUES (3, 'Roofing', DEFAULT);
304INSERT INTO `ecommerce`.`category` (`id`, `name`, `active`) VALUES (4, 'Paint & Decorating', DEFAULT);
305INSERT INTO `ecommerce`.`category` (`id`, `name`, `active`) VALUES (5, 'Plumbing', DEFAULT);
306INSERT INTO `ecommerce`.`category` (`id`, `name`, `active`) VALUES (6, 'Electrical', DEFAULT);
307INSERT INTO `ecommerce`.`category` (`id`, `name`, `active`) VALUES (7, 'Tools', DEFAULT);
308INSERT INTO `ecommerce`.`category` (`id`, `name`, `active`) VALUES (8, 'Steel and Aluminium', DEFAULT);
309INSERT INTO `ecommerce`.`category` (`id`, `name`, `active`) VALUES (9, 'Door and Window', DEFAULT);
310
311COMMIT;
312
313
314-- -----------------------------------------------------
315-- Data for table `ecommerce`.`item`
316-- -----------------------------------------------------
317START TRANSACTION;
318USE `ecommerce`;
319INSERT INTO `ecommerce`.`item` (`id`, `name`, `description`, `unit`, `category_id`, `new`, `price`, `active`) VALUES (1, 'Hume Doors & Timber 2040 x 820 x 35mm Oakfield Internal Door', '\n\nOne of Australia\'s most popular woodgrain designer door, the Oakfield Internal Door from Hume Doors features a pre-primed face and a woodgrain embossed design.\n\n    Featuring woodgrain embossed\n    Pre-primed faces\n    Design featured both sides\n\n', NULL, 1, 1, '42', DEFAULT);
320INSERT INTO `ecommerce`.`item` (`id`, `name`, `description`, `unit`, `category_id`, `new`, `price`, `active`) VALUES (2, 'Earthwool R-2.0 90 x 430mm x 19m 8.17m2 DIY Multi-Use Insulation Roll', '\n\nEarthwool® doesn\'t look or feel like any glasswool insulation you’ve ever experienced because the natural brown colour represents a level of sustainability and ease of handling never before achieved in Australia.\n\nManufactured using recycled glass and sand, Earthwool DIY Multi-Use Insulation Rolls improve acoustic and thermal performance and are super-soft to make installation comfortable.\n\n    Super-soft glasswool\n    Made using recycled glass bottles\n    No added formaldehyde\n    50 year warranty\n\n', NULL, 1, 1, '35', DEFAULT);
321INSERT INTO `ecommerce`.`item` (`id`, `name`, `description`, `unit`, `category_id`, `new`, `price`, `active`) VALUES (3, 'Gorilla 1.2m 150kg Double Sided Aluminium Step Ladder', '\n\nGorilla Aluminium Ladders are highly stable, industrial grade step ladders that are ideal for use by the home DIY enthusiast or industry professional.\n\nWith a patented resin bracing system for added strength and durability, these non-slip ladders can bear a massive 150kg in load weight and are built to last.\n\n    Cross-braced spreader\n    Non-slip aluminium top cap and treads\n    Non-slip rubber feet\n    Stabiliser ready (Included on Models: SM006-I, SM008-I, SM010-I)\n\n', NULL, 1, 1, '118', DEFAULT);
322
323COMMIT;
324
325
326-- -----------------------------------------------------
327-- Data for table `ecommerce`.`customer_address`
328-- -----------------------------------------------------
329START TRANSACTION;
330USE `ecommerce`;
331INSERT INTO `ecommerce`.`customer_address` (`id`, `customer_id`, `address`, `defaut`) VALUES (1, 'customer1@customer', '43B, Kotte road, Kotte', 0);
332INSERT INTO `ecommerce`.`customer_address` (`id`, `customer_id`, `address`, `defaut`) VALUES (2, 'customer1@customer', '32, Dharmapala road, Colombo 10', 1);
333
334COMMIT;
335
336
337-- -----------------------------------------------------
338-- Data for table `ecommerce`.`order`
339-- -----------------------------------------------------
340START TRANSACTION;
341USE `ecommerce`;
342INSERT INTO `ecommerce`.`order` (`id`, `customer_id`, `shipping_cost`, `shipping_address`, `status`, `paid`, `payment_type`, `time`) VALUES (1, 'customer1@customer', 10, 1, 'pending', 0, DEFAULT, DEFAULT);
343INSERT INTO `ecommerce`.`order` (`id`, `customer_id`, `shipping_cost`, `shipping_address`, `status`, `paid`, `payment_type`, `time`) VALUES (2, 'customer1@customer', 12, 2, 'confirmed', 1, 'credit', DEFAULT);
344INSERT INTO `ecommerce`.`order` (`id`, `customer_id`, `shipping_cost`, `shipping_address`, `status`, `paid`, `payment_type`, `time`) VALUES (3, 'customer1@customer', 0, 1, 'processing', 0, 'cash', DEFAULT);
345INSERT INTO `ecommerce`.`order` (`id`, `customer_id`, `shipping_cost`, `shipping_address`, `status`, `paid`, `payment_type`, `time`) VALUES (4, 'customer1@customer', 14, 1, 'dispatched', 1, 'credit', DEFAULT);
346INSERT INTO `ecommerce`.`order` (`id`, `customer_id`, `shipping_cost`, `shipping_address`, `status`, `paid`, `payment_type`, `time`) VALUES (5, 'customer1@customer', 20, 2, 'delivered', 1, 'credit', DEFAULT);
347
348COMMIT;
349
350
351-- -----------------------------------------------------
352-- Data for table `ecommerce`.`order_has_item`
353-- -----------------------------------------------------
354START TRANSACTION;
355USE `ecommerce`;
356INSERT INTO `ecommerce`.`order_has_item` (`order_id`, `item_id`, `no_of_units`, `unit_price`, `tax_percentage`, `rating`, `feedback`) VALUES (1, 1, 12, 13, 12, NULL, NULL);
357INSERT INTO `ecommerce`.`order_has_item` (`order_id`, `item_id`, `no_of_units`, `unit_price`, `tax_percentage`, `rating`, `feedback`) VALUES (1, 2, 1, 23, 11, NULL, NULL);
358INSERT INTO `ecommerce`.`order_has_item` (`order_id`, `item_id`, `no_of_units`, `unit_price`, `tax_percentage`, `rating`, `feedback`) VALUES (2, 2, 4, 34, 1, NULL, NULL);
359INSERT INTO `ecommerce`.`order_has_item` (`order_id`, `item_id`, `no_of_units`, `unit_price`, `tax_percentage`, `rating`, `feedback`) VALUES (2, 1, 5, 54, 0, NULL, NULL);
360INSERT INTO `ecommerce`.`order_has_item` (`order_id`, `item_id`, `no_of_units`, `unit_price`, `tax_percentage`, `rating`, `feedback`) VALUES (2, 3, 10, 1223, 12, NULL, NULL);
361INSERT INTO `ecommerce`.`order_has_item` (`order_id`, `item_id`, `no_of_units`, `unit_price`, `tax_percentage`, `rating`, `feedback`) VALUES (3, 2, 2, 23, 12, NULL, NULL);
362INSERT INTO `ecommerce`.`order_has_item` (`order_id`, `item_id`, `no_of_units`, `unit_price`, `tax_percentage`, `rating`, `feedback`) VALUES (4, 1, 3, 123, 12, NULL, NULL);
363INSERT INTO `ecommerce`.`order_has_item` (`order_id`, `item_id`, `no_of_units`, `unit_price`, `tax_percentage`, `rating`, `feedback`) VALUES (4, 2, 8, 23, 0, NULL, NULL);
364INSERT INTO `ecommerce`.`order_has_item` (`order_id`, `item_id`, `no_of_units`, `unit_price`, `tax_percentage`, `rating`, `feedback`) VALUES (4, 3, 1, 25, 12, NULL, NULL);
365
366COMMIT;
367
368
369-- -----------------------------------------------------
370-- Data for table `ecommerce`.`item_detail`
371-- -----------------------------------------------------
372START TRANSACTION;
373USE `ecommerce`;
374INSERT INTO `ecommerce`.`item_detail` (`id`, `field_name`, `field_value`, `item_id`) VALUES (1, 'Model Name', 'OAKFIELD', 1);
375INSERT INTO `ecommerce`.`item_detail` (`id`, `field_name`, `field_value`, `item_id`) VALUES (2, 'Material', 'Reconstituted Timber', 1);
376INSERT INTO `ecommerce`.`item_detail` (`id`, `field_name`, `field_value`, `item_id`) VALUES (3, 'Model Number', 'HC2', 1);
377INSERT INTO `ecommerce`.`item_detail` (`id`, `field_name`, `field_value`, `item_id`) VALUES (4, 'Product Dimensions (mm)', 'W:820 H:2040 L:35', 1);
378INSERT INTO `ecommerce`.`item_detail` (`id`, `field_name`, `field_value`, `item_id`) VALUES (5, 'Model Name', 'Earthwool R-2.0 430mm DIY Multi-Use Roll Insulation', 2);
379INSERT INTO `ecommerce`.`item_detail` (`id`, `field_name`, `field_value`, `item_id`) VALUES (6, 'Model Number', 'E4385', 2);
380INSERT INTO `ecommerce`.`item_detail` (`id`, `field_name`, `field_value`, `item_id`) VALUES (7, 'Material', 'Glasswool', 2);
381INSERT INTO `ecommerce`.`item_detail` (`id`, `field_name`, `field_value`, `item_id`) VALUES (8, 'Product Dimensions (mm)', 'W:430 H:19000 L:90', 2);
382INSERT INTO `ecommerce`.`item_detail` (`id`, `field_name`, `field_value`, `item_id`) VALUES (9, 'Package Dimensions (mm)', 'W:600 H:430 L:600', 2);
383INSERT INTO `ecommerce`.`item_detail` (`id`, `field_name`, `field_value`, `item_id`) VALUES (10, 'Weight', '7kg', 2);
384INSERT INTO `ecommerce`.`item_detail` (`id`, `field_name`, `field_value`, `item_id`) VALUES (11, 'Energy Star Compliant', 'Yes', 2);
385INSERT INTO `ecommerce`.`item_detail` (`id`, `field_name`, `field_value`, `item_id`) VALUES (12, 'Roll or Batt', 'Roll', 2);
386INSERT INTO `ecommerce`.`item_detail` (`id`, `field_name`, `field_value`, `item_id`) VALUES (13, 'Vapor Retardent', 'No', 2);
387INSERT INTO `ecommerce`.`item_detail` (`id`, `field_name`, `field_value`, `item_id`) VALUES (14, 'Model Name', '4ft (1.2m) Double Sided Alum Ladder 150kg Industrial', 3);
388INSERT INTO `ecommerce`.`item_detail` (`id`, `field_name`, `field_value`, `item_id`) VALUES (15, 'Model Number', 'SM004-I', 3);
389INSERT INTO `ecommerce`.`item_detail` (`id`, `field_name`, `field_value`, `item_id`) VALUES (16, 'Material', 'Aluminium & Steel', 3);
390INSERT INTO `ecommerce`.`item_detail` (`id`, `field_name`, `field_value`, `item_id`) VALUES (17, 'Product Dimensions (mm)', 'W:470 H:1160 L:932', 3);
391INSERT INTO `ecommerce`.`item_detail` (`id`, `field_name`, `field_value`, `item_id`) VALUES (18, 'Package Dimensions (mm)\n', 'W:470 H:190 L:1250', 3);
392INSERT INTO `ecommerce`.`item_detail` (`id`, `field_name`, `field_value`, `item_id`) VALUES (19, 'Maximum Ladder Length', '1.2', 3);
393INSERT INTO `ecommerce`.`item_detail` (`id`, `field_name`, `field_value`, `item_id`) VALUES (20, 'Weather Resistant ', 'Yes', 3);
394INSERT INTO `ecommerce`.`item_detail` (`id`, `field_name`, `field_value`, `item_id`) VALUES (21, 'Load Weight Capacity', '150', 3);
395INSERT INTO `ecommerce`.`item_detail` (`id`, `field_name`, `field_value`, `item_id`) VALUES (22, 'Insulated ', 'No', 3);
396INSERT INTO `ecommerce`.`item_detail` (`id`, `field_name`, `field_value`, `item_id`) VALUES (23, 'Telescoping ', 'No', 3);
397
398COMMIT;
399
400
401-- -----------------------------------------------------
402-- Data for table `ecommerce`.`item_field`
403-- -----------------------------------------------------
404START TRANSACTION;
405USE `ecommerce`;
406INSERT INTO `ecommerce`.`item_field` (`id`, `field_name`) VALUES (1, 'Model Name');
407INSERT INTO `ecommerce`.`item_field` (`id`, `field_name`) VALUES (2, 'Model Number');
408INSERT INTO `ecommerce`.`item_field` (`id`, `field_name`) VALUES (3, 'Material');
409INSERT INTO `ecommerce`.`item_field` (`id`, `field_name`) VALUES (4, 'Product Dimensions (mm)');
410INSERT INTO `ecommerce`.`item_field` (`id`, `field_name`) VALUES (5, 'Package Dimensions (mm)');
411INSERT INTO `ecommerce`.`item_field` (`id`, `field_name`) VALUES (6, 'Weight');
412
413COMMIT;