Addendum 5/5 SQL for the std System Icons (Font Awesome and Glyphicons).
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.
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 ;