Server : Apache System : Linux server2.corals.io 4.18.0-348.2.1.el8_5.x86_64 #1 SMP Mon Nov 15 09:17:08 EST 2021 x86_64 User : corals ( 1002) PHP Version : 7.4.33 Disable Function : exec,passthru,shell_exec,system Directory :  /home/corals/old/vendor/wyomind/msicustomattributes/Sample/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

DELETE FROM `{{table:msi_custom_attribute_value}}`;
DELETE FROM `{{table:msi_custom_attribute_dropdown_option_value}}`;
DELETE FROM `{{table:msi_custom_attribute_dropdown_option}}`;
DELETE FROM `{{table:msi_custom_attribute}}`;

ALTER TABLE `{{table:msi_custom_attribute}}` AUTO_INCREMENT = 0;
insert into `{{table:msi_custom_attribute}}`(`attribute_id`,`code`,`label`,`type`,`sort_order`,`is_system`,`default`,`is_required`) values (1,'text','Text Field Example','text',1,0,'Default Text',0);
insert into `{{table:msi_custom_attribute}}`(`attribute_id`,`code`,`label`,`type`,`sort_order`,`is_system`,`default`,`is_required`) values (2,'number','Number Field Example','int',2,0,'999',0);
insert into `{{table:msi_custom_attribute}}`(`attribute_id`,`code`,`label`,`type`,`sort_order`,`is_system`,`default`,`is_required`) values (3,'date','Date Field Example','date',3,0,'',1);
insert into `{{table:msi_custom_attribute}}`(`attribute_id`,`code`,`label`,`type`,`sort_order`,`is_system`,`default`,`is_required`) values (4,'bool','Yes/No Example','bool',4,0,'',0);
insert into `{{table:msi_custom_attribute}}`(`attribute_id`,`code`,`label`,`type`,`sort_order`,`is_system`,`default`,`is_required`) values (5,'select','Dropdown Example','select',5,0,'',0);


ALTER TABLE `{{table:msi_custom_attribute_dropdown_option}}` AUTO_INCREMENT = 0;
insert into `{{table:msi_custom_attribute_dropdown_option}}` (`option_id`,`attribute_id`,`is_default`,`position`) values (1,5,0,1);
insert into `{{table:msi_custom_attribute_dropdown_option}}` (`option_id`,`attribute_id`,`is_default`,`position`) values (2,5,0,2);
insert into `{{table:msi_custom_attribute_dropdown_option}}` (`option_id`,`attribute_id`,`is_default`,`position`) values (3,5,1,3);



ALTER TABLE `{{table:msi_custom_attribute_dropdown_option_value}}` AUTO_INCREMENT = 0;
insert into `{{table:msi_custom_attribute_dropdown_option_value}}` (`value_id`,`option_id`,`store_id`,`value`) values (1,1,0,'Option A');
insert into `{{table:msi_custom_attribute_dropdown_option_value}}` (`value_id`,`option_id`,`store_id`,`value`) values (2,2,0,'Option B');
insert into `{{table:msi_custom_attribute_dropdown_option_value}}` (`value_id`,`option_id`,`store_id`,`value`) values (3,3,0,'Option C');