Addendum 5/5 SQL for the std System Icons (Font Awesome and Glyphicons).SQL structure System icons:
It uses the std fontawesome and glyph icons which are available within PHPMaker 2018. This table also leaves room to import your own .PNG or .JPG, but I have not implemented this in the code.The two triggers at the end automatically provide the correct HTML to display the icon when inserting or updating. This is the field ico_preview of the table. The inserted is to force display of the button. If anyone knows a better way, please post.COPY-PASTE the following code into a MySQL console which lets you create tables:
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `std3_ico_systemicons`
-- ----------------------------
DROP TABLE IF EXISTS `std3_ico_systemicons`;
CREATE TABLE `std3_ico_systemicons` (
`ico_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`ico_preview` varchar(255) DEFAULT NULL,
`ico_name` varchar(50) DEFAULT NULL,
`ico_sdp_class` varchar(50) DEFAULT NULL COMMENT 'english.xml will provide correct class names',
`ico_pic` blob COMMENT 'If you need your own image. Not implemented yet! Blob gives 65 kB capacity',
PRIMARY KEY (`ico_id`)
) ENGINE=MyISAM AUTO_INCREMENT=47 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of std3_ico_systemicons
-- ----------------------------
INSERT INTO `std3_ico_systemicons` VALUES ('1', ' <button class=\"btn btn-default\" type=\"button\" title=\"\" ><span class=\"icon-advanced-search ewIcon \"></span></button>', 'Search Advanced', 'icon-advanced-search ewIcon ', null);
INSERT INTO `std3_ico_systemicons` VALUES ('2', ' <button class=\"btn btn-default\" type=\"button\" title=\"\" ><span class=\"icon-filter ewIcon\"></span></button>', 'Filter', 'icon-filter ewIcon', null);
INSERT INTO `std3_ico_systemicons` VALUES ('12', ' <button class=\"btn btn-default\" type=\"button\" title=\"\" ><span class=\"icon-addedit ewIcon\"></span></button>', 'Add-Edit', 'icon-addedit ewIcon', null);
INSERT INTO `std3_ico_systemicons` VALUES ('3', ' <button class=\"btn btn-default\" type=\"button\" title=\"\" ><span class=\"glyphicon glyphicon-home ewIcon\"></span></button>', 'Home', 'glyphicon glyphicon-home ewIcon', null);
INSERT INTO `std3_ico_systemicons` VALUES ('4', ' <button class=\"btn btn-default\" type=\"button\" title=\"\" ><span class=\"glyphicon glyphicon-trash ewIcon \"></span></button>', 'Delete', 'glyphicon glyphicon-trash ewIcon ', null);
INSERT INTO `std3_ico_systemicons` VALUES ('11', ' <button class=\"btn btn-default\" type=\"button\" title=\"\" ><span class=\"icon-options ewIcon \"></span></button>', 'Opties (hamburger)', 'icon-options ewIcon ', null);
INSERT INTO `std3_ico_systemicons` VALUES ('5', ' <button class=\"btn btn-default\" type=\"button\" title=\"\" ><span class=\"icon-excel ewIcon \"></span></button>', 'Export Excel', 'icon-excel ewIcon ', null);
INSERT INTO `std3_ico_systemicons` VALUES ('6', ' <button class=\"btn btn-default\" type=\"button\" title=\"\" ><span class=\"glyphicon glyphicon-bell ewIcon \"></span></button>', 'Bell', 'glyphicon glyphicon-bell ewIcon ', null);
INSERT INTO `std3_ico_systemicons` VALUES ('10', ' <button class=\"btn btn-default\" type=\"button\" title=\"\" ><span class=\"icon-md-add ewIcon \"></span></button>', 'Plus-inverse', 'icon-md-add ewIcon ', null);
INSERT INTO `std3_ico_systemicons` VALUES ('8', ' <button class=\"btn btn-default\" type=\"button\" title=\"\" ><span class=\"glyphicon glyphicon-calendar \"></span></button>', 'Calendar', 'glyphicon glyphicon-calendar ', null);
INSERT INTO `std3_ico_systemicons` VALUES ('9', ' <button class=\"btn btn-default\" type=\"button\" title=\"\" ><span class=\"glyphicon glyphicon-plus ewIcon \"></span></button>', 'Plus', 'glyphicon glyphicon-plus ewIcon ', null);
INSERT INTO `std3_ico_systemicons` VALUES ('13', ' <button class=\"btn btn-default\" type=\"button\" title=\"\" ><span class=\"icon-master-detail ewIcon \"></span></button>', 'Master-Detail', 'icon-master-detail ewIcon ', null);
INSERT INTO `std3_ico_systemicons` VALUES ('14', ' <button class=\"btn btn-default\" type=\"button\" title=\"\" ><span class=\"icon-export ewIcon \"></span></button>', 'Export', 'icon-export ewIcon ', null);
INSERT INTO `std3_ico_systemicons` VALUES ('15', ' <button class=\"btn btn-default\" type=\"button\" title=\"\" ><span class=\"icon-search ewIcon \"></span></button>', 'Search', 'icon-search ewIcon ', null);
INSERT INTO `std3_ico_systemicons` VALUES ('16', ' <button class=\"btn btn-default\" type=\"button\" title=\"\" ><span class=\"glyphicon glyphicon-remove ewIcon \"></span></button>', 'Cancel', 'glyphicon glyphicon-remove ewIcon ', null);
INSERT INTO `std3_ico_systemicons` VALUES ('17', ' <button class=\"btn btn-default\" type=\"button\" title=\"\" ><span class=\"icon-copy ewIcon \"></span></button>', 'Copy', 'icon-copy ewIcon ', null);
INSERT INTO `std3_ico_systemicons` VALUES ('18', ' <button class=\"btn btn-default\" type=\"button\" title=\"\" ><span class=\"icon-md-copy ewIcon \"></span></button>', 'Copy Master-Detail', 'icon-md-copy ewIcon ', null);
INSERT INTO `std3_ico_systemicons` VALUES ('19', ' <button class=\"btn btn-default\" type=\"button\" title=\"\" ><span class=\"icon-md-edit ewIcon \"></span></button>', 'Edit Master-Detail', 'icon-md-edit ewIcon ', null);
INSERT INTO `std3_ico_systemicons` VALUES ('20', ' <button class=\"btn btn-default\" type=\"button\" title=\"\" ><span class=\"icon-table ewIcon \"></span></button>', 'List Detail', 'icon-table ewIcon ', null);
INSERT INTO `std3_ico_systemicons` VALUES ('21', ' <button class=\"btn btn-default\" type=\"button\" title=\"\" ><span class=\"icon-md-view ewIcon \"></span></button>', 'View Master-Detail', 'icon-md-view ewIcon ', null);
INSERT INTO `std3_ico_systemicons` VALUES ('22', ' <button class=\"btn btn-default\" type=\"button\" title=\"\" ><span class=\"icon-csv ewIcon \"></span></button>', 'Export CSV', 'icon-csv ewIcon ', null);
INSERT INTO `std3_ico_systemicons` VALUES ('23', ' <button class=\"btn btn-default\" type=\"button\" title=\"\" ><span class=\"icon-email ewIcon \"></span></button>', 'Email', 'icon-email ewIcon ', null);
INSERT INTO `std3_ico_systemicons` VALUES ('24', ' <button class=\"btn btn-default\" type=\"button\" title=\"\" ><span class=\"icon-html ewIcon \"></span></button>', 'Export HTML', 'icon-html ewIcon ', null);
INSERT INTO `std3_ico_systemicons` VALUES ('25', ' <button class=\"btn btn-default\" type=\"button\" title=\"\" ><span class=\"icon-pdf ewIcon \"></span></button>', 'Export PDF', 'icon-pdf ewIcon ', null);
INSERT INTO `std3_ico_systemicons` VALUES ('26', ' <button class=\"btn btn-default\" type=\"button\" title=\"\" ><span class=\"icon-word ewIcon \"></span></button>', 'Export Word', 'icon-word ewIcon ', null);
INSERT INTO `std3_ico_systemicons` VALUES ('27', ' <button class=\"btn btn-default\" type=\"button\" title=\"\" ><span class=\"icon-xml ewIcon \"></span></button>', 'Export XML', 'icon-xml ewIcon ', null);
INSERT INTO `std3_ico_systemicons` VALUES ('28', ' <button class=\"btn btn-default\" type=\"button\" title=\"\" ><span class=\"glyphicon glyphicon-flash ewIcon \"></span></button>', 'Password - Generate', 'glyphicon glyphicon-flash ewIcon ', null);
INSERT INTO `std3_ico_systemicons` VALUES ('29', ' <button class=\"btn btn-default\" type=\"button\" title=\"\" ><span class=\"icon-grid-add ewIcon \"></span></button>', 'Grid Add', 'icon-grid-add ewIcon ', null);
INSERT INTO `std3_ico_systemicons` VALUES ('30', ' <button class=\"btn btn-default\" type=\"button\" title=\"\" ><span class=\"icon-grid-edit ewIcon \"></span></button>', 'Grid Edit', 'icon-grid-edit ewIcon ', null);
INSERT INTO `std3_ico_systemicons` VALUES ('31', ' <button class=\"btn btn-default\" type=\"button\" title=\"\" ><span class=\"glyphicon glyphicon-ok ewIcon \"></span></button>', 'OK', 'glyphicon glyphicon-ok ewIcon ', null);
INSERT INTO `std3_ico_systemicons` VALUES ('32', ' <button class=\"btn btn-default\" type=\"button\" title=\"\" ><span class=\"icon-highlight ewIcon \"></span></button>', 'Highlight', 'icon-highlight ewIcon ', null);
INSERT INTO `std3_ico_systemicons` VALUES ('33', ' <button class=\"btn btn-default\" type=\"button\" title=\"\" ><span class=\"icon-inline-add ewIcon \"></span></button>', 'Inline Add', 'icon-inline-add ewIcon ', null);
INSERT INTO `std3_ico_systemicons` VALUES ('34', ' <button class=\"btn btn-default\" type=\"button\" title=\"\" ><span class=\"icon-inline-copy ewIcon \"></span></button>', 'Inline Copy', 'icon-inline-copy ewIcon ', null);
INSERT INTO `std3_ico_systemicons` VALUES ('35', ' <button class=\"btn btn-default\" type=\"button\" title=\"\" ><span class=\"icon-inline-edit ewIcon \"></span></button>', 'Inline Edit', 'icon-inline-edit ewIcon ', null);
INSERT INTO `std3_ico_systemicons` VALUES ('36', ' <button class=\"btn btn-default\" type=\"button\" title=\"\" ><span class=\"icon-user ewIcon \"></span></button>', 'User', 'icon-user ewIcon ', null);
INSERT INTO `std3_ico_systemicons` VALUES ('37', ' <button class=\"btn btn-default\" type=\"button\" title=\"\" ><span class=\"icon-print ewIcon \"></span></button>', 'Print', 'icon-print ewIcon ', null);
INSERT INTO `std3_ico_systemicons` VALUES ('38', ' <button class=\"btn btn-default\" type=\"button\" title=\"\" ><span class=\"icon-reset-search ewIcon \"></span></button>', 'Show All', 'icon-reset-search ewIcon ', null);
INSERT INTO `std3_ico_systemicons` VALUES ('39', ' <button class=\"btn btn-default\" type=\"button\" title=\"\" ><span class=\"icon-view ewIcon \"></span></button>', 'View', 'icon-view ewIcon ', null);
INSERT INTO `std3_ico_systemicons` VALUES ('40', ' <button class=\"btn btn-default\" type=\"button\" title=\"\" ><span class=\"icon-edit ewIcon \"></span></button>', 'Edit', 'icon-edit ewIcon ', null);
INSERT INTO `std3_ico_systemicons` VALUES ('41', ' <button class=\"btn btn-default\" type=\"button\" title=\"\" ><span class=\"glyphicon glyphicon-warning-sign\"></span></button>', 'Warning', 'glyphicon glyphicon-warning-sign', null);
INSERT INTO `std3_ico_systemicons` VALUES ('42', ' <button class=\"btn btn-default\" type=\"button\" title=\"\" ><span class=\"fa fa-exclamation-triangle\"></span></button>', 'Warning-2', 'fa fa-exclamation-triangle', null);
INSERT INTO `std3_ico_systemicons` VALUES ('43', ' <button class=\"btn btn-default\" type=\"button\" title=\"\" ><span class=\"glyphicon glyphicon-info-sign\"></span></button>', 'Info', 'glyphicon glyphicon-info-sign', null);
INSERT INTO `std3_ico_systemicons` VALUES ('44', ' <button class=\"btn btn-default\" type=\"button\" title=\"\" ><span class=\"glyphicon glyphicon-question-sign\"></span></button>', 'question-mark', 'glyphicon glyphicon-question-sign', null);
INSERT INTO `std3_ico_systemicons` VALUES ('45', ' <button class=\"btn btn-default\" type=\"button\" title=\"\" ><span class=\"fa fa-lightbulb-o\"></span></button>', 'idea', 'fa fa-lightbulb-o', null);
INSERT INTO `std3_ico_systemicons` VALUES ('46', ' <button class=\"btn btn-default\" type=\"button\" title=\"\" ><span class=\"glyphicon glyphicon-unchecked\"></span></button>', 'Unchecked', 'glyphicon glyphicon-unchecked', null);
DELIMITER ;;
CREATE TRIGGER `PreviewConcatNew` BEFORE INSERT ON `std3_ico_systemicons` FOR EACH ROW set new.ico_preview=CONCAT(' <button class="btn btn-default" type="button" title="" ><span class="', new.ico_sdp_class,'"></span></button>')
;;
DELIMITER ;
DELIMITER ;;
CREATE TRIGGER `PreviewConcatUpd` BEFORE UPDATE ON `std3_ico_systemicons` FOR EACH ROW set new.ico_preview=CONCAT(' <button class="btn btn-default" type="button" title="" ><span class="', new.ico_sdp_class,'"></span></button>')
;;
DELIMITER ;