Home Esplora Aiuto
Registrati Accedi
neal
/
una
mirror da https://github.com/unaio/una.git
1
0
Forka 0
File Problemi 0 Wiki
Albero (Tree): f982f218d0
Rami (Branch) Tag
una
/
modules
/
boonex
/
uni
/
install
/
sql
/
install.sql

install.sql 28 KB
Cronologia Originale

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293 
  1. SET @sName = 'bx_uni';
    2. 

  2. 

  3. 

  4. -- SETTINGS
    5. 

  5. INSERT INTO `sys_options_types`(`group`, `name`, `caption`, `icon`, `order`) VALUES 
    6. 

  6. ('templates', @sName, '_bx_uni_stg_cpt_type', 'bx_uni@modules/boonex/uni/|std-mi.png', 2);
    7. 

  7. SET @iTypeId = LAST_INSERT_ID();
    8. 

  8. 

  9. -- SETTINGS: UNI System
    10. 

  10. INSERT INTO `sys_options_categories`(`type_id`, `name`, `caption`, `order`) VALUES 
    11. 

  11. (@iTypeId, CONCAT(@sName, '_system'), '_bx_uni_stg_cpt_category_system', 1);
    12. 

  12. SET @iCategoryId = LAST_INSERT_ID();
    13. 

  13. 

  14. INSERT INTO `sys_options`(`category_id`, `name`, `caption`, `value`, `type`, `extra`, `check`, `check_error`, `order`) VALUES
    15. 

  15. (@iCategoryId, CONCAT(@sName, '_switcher_title'), '_bx_uni_stg_cpt_option_switcher_name', 'UNI', 'digit', '', '', '', 1);
    16. 

  16. 

  17. 

  18. -- SETTINGS: UNI Styles General
    19. 

  19. INSERT INTO `sys_options_categories`(`type_id`, `name`, `caption`, `order`) VALUES 
    20. 

  20. (@iTypeId, CONCAT(@sName, '_styles_general'), '_bx_uni_stg_cpt_category_styles_general', 2);
    21. 

  21. SET @iCategoryId = LAST_INSERT_ID();
    22. 

  22. 

  23. INSERT INTO `sys_options`(`category_id`, `name`, `caption`, `value`, `type`, `extra`, `check`, `check_error`, `order`) VALUES
    24. 

  24. (@iCategoryId, CONCAT(@sName, '_general_item_bg_color_hover'), '_bx_uni_stg_cpt_option_general_item_bg_color_hover', 'rgba(196, 248, 156, 0.2)', 'rgba', '', '', '', 1),
    25. 

  25. (@iCategoryId, CONCAT(@sName, '_general_item_bg_color_active'), '_bx_uni_stg_cpt_option_general_item_bg_color_active', 'rgba(196, 248, 156, 0.4)', 'rgba', '', '', '', 2);
    26. 

  26. 

  27. 

  28. -- SETTINGS: UNI Styles Header
    29. 

  29. INSERT INTO `sys_options_categories`(`type_id`, `name`, `caption`, `order`) VALUES 
    30. 

  30. (@iTypeId, CONCAT(@sName, '_styles_header'), '_bx_uni_stg_cpt_category_styles_header', 3);
    31. 

  31. SET @iCategoryId = LAST_INSERT_ID();
    32. 

  32. 

  33. INSERT INTO `sys_options`(`category_id`, `name`, `caption`, `value`, `type`, `extra`, `check`, `check_error`, `order`) VALUES
    34. 

  34. (@iCategoryId, CONCAT(@sName, '_header_height'), '_bx_uni_stg_cpt_option_header_height', '3rem', 'digit', '', '', '', 1),
    35. 

  35. (@iCategoryId, CONCAT(@sName, '_header_content_padding'), '_bx_uni_stg_cpt_option_header_content_padding', '0px', 'digit', '', '', '', 2),
    36. 

  36. (@iCategoryId, CONCAT(@sName, '_header_bg_color'), '_bx_uni_stg_cpt_option_header_bg_color', 'rgba(59, 134, 134, 1)', 'rgba', '', '', '', 3),
    37. 

  37. (@iCategoryId, CONCAT(@sName, '_header_bg_image'), '_bx_uni_stg_cpt_option_header_bg_image', '', 'image', '', '', '', 4),
    38. 

  38. (@iCategoryId, CONCAT(@sName, '_header_bg_image_repeat'), '_bx_uni_stg_cpt_option_header_bg_image_repeat', 'no-repeat', 'select', 'no-repeat,repeat,repeat-x,repeat-y', '', '', 5),
    39. 

  39. (@iCategoryId, CONCAT(@sName, '_header_bg_image_size'), '_bx_uni_stg_cpt_option_header_bg_image_size', 'cover', 'select', 'auto,cover,contain', '', '', 6),
    40. 

  40. (@iCategoryId, CONCAT(@sName, '_site_logo'), '_bx_uni_stg_cpt_option_site_logo', '', 'image', '', '', '', 7),
    41. 

  41. (@iCategoryId, CONCAT(@sName, '_site_logo_alt'), '_bx_uni_stg_cpt_option_site_logo_alt', '', 'text', '', '', '', 8),
    42. 

  42. (@iCategoryId, CONCAT(@sName, '_site_logo_width'), '_bx_uni_stg_cpt_option_site_logo_width', '240', 'digit', '', '', '', 9),
    43. 

  43. (@iCategoryId, CONCAT(@sName, '_site_logo_height'), '_bx_uni_stg_cpt_option_site_logo_height', '48', 'digit', '', '', '', 10),
    44. 

  44. (@iCategoryId, CONCAT(@sName, '_header_border_color'), '_bx_uni_stg_cpt_option_header_border_color', 'rgba(208, 208, 208, 1)', 'rgba', '', '', '', 11),
    45. 

  45. (@iCategoryId, CONCAT(@sName, '_header_border_size'), '_bx_uni_stg_cpt_option_header_border_size', '0px', 'digit', '', '', '', 12),
    46. 

  46. (@iCategoryId, CONCAT(@sName, '_header_shadow'), '_bx_uni_stg_cpt_option_header_shadow', 'none', 'digit', '', '', '', 13),
    47. 

  47. (@iCategoryId, CONCAT(@sName, '_header_icon_color'), '_bx_uni_stg_cpt_option_header_icon_color', 'rgba(255, 255, 255, 1)', 'rgba', '', '', '', 14),
    48. 

  48. (@iCategoryId, CONCAT(@sName, '_header_icon_color_hover'), '_bx_uni_stg_cpt_option_header_icon_color_hover', 'rgba(255, 255, 255, 1)', 'rgba', '', '', '', 15),
    49. 

  49. (@iCategoryId, CONCAT(@sName, '_header_link_color'), '_bx_uni_stg_cpt_option_header_link_color', 'rgba(255, 255, 255, 1)', 'rgba', '', '', '', 16),
    50. 

  50. (@iCategoryId, CONCAT(@sName, '_header_link_color_hover'), '_bx_uni_stg_cpt_option_header_link_color_hover', 'rgba(255, 255, 255, 1)', 'rgba', '', '', '', 17);
    51. 

  51. 

  52. -- SETTINGS: UNI Styles Footer
    53. 

  53. INSERT INTO `sys_options_categories`(`type_id`, `name`, `caption`, `order`) VALUES 
    54. 

  54. (@iTypeId, CONCAT(@sName, '_styles_footer'), '_bx_uni_stg_cpt_category_styles_footer', 4);
    55. 

  55. SET @iCategoryId = LAST_INSERT_ID();
    56. 

  56. 

  57. INSERT INTO `sys_options`(`category_id`, `name`, `caption`, `value`, `type`, `extra`, `check`, `check_error`, `order`) VALUES
    58. 

  58. (@iCategoryId, CONCAT(@sName, '_footer_bg_color'), '_bx_uni_stg_cpt_option_footer_bg_color', 'rgba(255, 255, 255, 1)', 'rgba', '', '', '', 1),
    59. 

  59. (@iCategoryId, CONCAT(@sName, '_footer_bg_image'), '_bx_uni_stg_cpt_option_footer_bg_image', '', 'image', '', '', '', 2),
    60. 

  60. (@iCategoryId, CONCAT(@sName, '_footer_bg_image_repeat'), '_bx_uni_stg_cpt_option_footer_bg_image_repeat', 'no-repeat', 'select', 'no-repeat,repeat,repeat-x,repeat-y', '', '', 3),
    61. 

  61. (@iCategoryId, CONCAT(@sName, '_footer_bg_image_size'), '_bx_uni_stg_cpt_option_footer_bg_image_size', 'cover', 'select', 'auto,cover,contain', '', '', 4),
    62. 

  62. (@iCategoryId, CONCAT(@sName, '_footer_content_padding'), '_bx_uni_stg_cpt_option_footer_content_padding', '0px', 'digit', '', '', '', 5),
    63. 

  63. (@iCategoryId, CONCAT(@sName, '_footer_border_color'), '_bx_uni_stg_cpt_option_footer_border_color', 'rgba(208, 208, 208, 1)', 'rgba', '', '', '', 6),
    64. 

  64. (@iCategoryId, CONCAT(@sName, '_footer_border_size'), '_bx_uni_stg_cpt_option_footer_border_size', '1px', 'digit', '', '', '', 7),
    65. 

  65. (@iCategoryId, CONCAT(@sName, '_footer_shadow'), '_bx_uni_stg_cpt_option_footer_shadow', 'none', 'digit', '', '', '', 8),
    66. 

  66. (@iCategoryId, CONCAT(@sName, '_footer_font_color'), '_bx_uni_stg_cpt_option_footer_font_color', 'rgba(51, 51, 51, 1)', 'rgba', '', '', '', 9),
    67. 

  67. (@iCategoryId, CONCAT(@sName, '_footer_icon_color'), '_bx_uni_stg_cpt_option_footer_icon_color', 'rgba(62, 134, 133, 1)', 'rgba', '', '', '', 10),
    68. 

  68. (@iCategoryId, CONCAT(@sName, '_footer_icon_color_hover'), '_bx_uni_stg_cpt_option_footer_icon_color_hover', 'rgba(62, 134, 133, 1)', 'rgba', '', '', '', 11),
    69. 

  69. (@iCategoryId, CONCAT(@sName, '_footer_link_color'), '_bx_uni_stg_cpt_option_footer_link_color', 'rgba(62, 134, 133, 1)', 'rgba', '', '', '', 12),
    70. 

  70. (@iCategoryId, CONCAT(@sName, '_footer_link_color_hover'), '_bx_uni_stg_cpt_option_footer_link_color_hover', 'rgba(62, 134, 133, 1)', 'rgba', '', '', '', 13);
    71. 

  71. 

  72. -- SETTINGS: UNI Styles Body
    73. 

  73. INSERT INTO `sys_options_categories`(`type_id`, `name`, `caption`, `order`) VALUES 
    74. 

  74. (@iTypeId, CONCAT(@sName, '_styles_body'), '_bx_uni_stg_cpt_category_styles_body', 5);
    75. 

  75. SET @iCategoryId = LAST_INSERT_ID();
    76. 

  76. 

  77. INSERT INTO `sys_options`(`category_id`, `name`, `caption`, `value`, `type`, `extra`, `check`, `check_error`, `order`) VALUES
    78. 

  78. (@iCategoryId, CONCAT(@sName, '_body_bg_color'), '_bx_uni_stg_cpt_option_body_bg_color', 'rgb(255, 255, 255)', 'rgb', '', '', '', 1),
    79. 

  79. (@iCategoryId, CONCAT(@sName, '_body_bg_image'), '_bx_uni_stg_cpt_option_body_bg_image', '', 'image', '', '', '', 2),
    80. 

  80. (@iCategoryId, CONCAT(@sName, '_body_bg_image_repeat'), '_bx_uni_stg_cpt_option_body_bg_image_repeat', 'no-repeat', 'select', 'no-repeat,repeat,repeat-x,repeat-y', '', '', 3),
    81. 

  81. (@iCategoryId, CONCAT(@sName, '_body_bg_image_size'), '_bx_uni_stg_cpt_option_body_bg_image_size', 'cover', 'select', 'auto,cover,contain', '', '', 4),
    82. 

  82. (@iCategoryId, CONCAT(@sName, '_page_width'), '_bx_uni_stg_cpt_option_page_width', '1000', 'digit', '', '', '', 5),
    83. 

  83. (@iCategoryId, CONCAT(@sName, '_body_icon_color'), '_bx_uni_stg_cpt_option_body_icon_color', 'rgba(62, 134, 133, 1)', 'rgba', '', '', '', 6),
    84. 

  84. (@iCategoryId, CONCAT(@sName, '_body_icon_color_hover'), '_bx_uni_stg_cpt_option_body_icon_color_hover', 'rgba(62, 134, 133, 1)', 'rgba', '', '', '', 7),
    85. 

  85. (@iCategoryId, CONCAT(@sName, '_body_link_color'), '_bx_uni_stg_cpt_option_body_link_color', 'rgba(62, 134, 133, 1)', 'rgba', '', '', '', 8),
    86. 

  86. (@iCategoryId, CONCAT(@sName, '_body_link_color_hover'), '_bx_uni_stg_cpt_option_body_link_color_hover', 'rgba(62, 134, 133, 1)', 'rgba', '', '', '', 9);
    87. 

  87. 

  88. -- SETTINGS: UNI Styles Block
    89. 

  89. INSERT INTO `sys_options_categories`(`type_id`, `name`, `caption`, `order`) VALUES 
    90. 

  90. (@iTypeId, CONCAT(@sName, '_styles_block'), '_bx_uni_stg_cpt_category_styles_block', 6);
    91. 

  91. SET @iCategoryId = LAST_INSERT_ID();
    92. 

  92. 

  93. INSERT INTO `sys_options`(`category_id`, `name`, `caption`, `value`, `type`, `extra`, `check`, `check_error`, `order`) VALUES
    94. 

  94. (@iCategoryId, CONCAT(@sName, '_block_bg_color'), '_bx_uni_stg_cpt_option_block_bg_color', 'rgba(255, 255, 255, 1)', 'rgba', '', '', '', 1),
    95. 

  95. (@iCategoryId, CONCAT(@sName, '_block_bg_image'), '_bx_uni_stg_cpt_option_block_bg_image', '', 'image', '', '', '', 2),
    96. 

  96. (@iCategoryId, CONCAT(@sName, '_block_bg_image_repeat'), '_bx_uni_stg_cpt_option_block_bg_image_repeat', 'no-repeat', 'select', 'no-repeat,repeat,repeat-x,repeat-y', '', '', 3),
    97. 

  97. (@iCategoryId, CONCAT(@sName, '_block_bg_image_size'), '_bx_uni_stg_cpt_option_block_bg_image_size', 'cover', 'select', 'auto,cover,contain', '', '', 4),
    98. 

  98. (@iCategoryId, CONCAT(@sName, '_block_content_padding'), '_bx_uni_stg_cpt_option_block_content_padding', 'inherit', 'digit', '', '', '', 5),
    99. 

  99. (@iCategoryId, CONCAT(@sName, '_block_border_color'), '_bx_uni_stg_cpt_option_block_border_color', 'rgba(208, 208, 208, 1)', 'rgba', '', '', '', 6),
    100. 

  100. (@iCategoryId, CONCAT(@sName, '_block_border_size'), '_bx_uni_stg_cpt_option_block_border_size', '0px', 'digit', '', '', '', 7),
    101. 

  101. (@iCategoryId, CONCAT(@sName, '_block_border_radius'), '_bx_uni_stg_cpt_option_block_border_radius', '0px', 'digit', '', '', '', 8),
    102. 

  102. (@iCategoryId, CONCAT(@sName, '_block_shadow'), '_bx_uni_stg_cpt_option_block_shadow', 'none', 'digit', '', '', '', 9),
    103. 

  103. (@iCategoryId, CONCAT(@sName, '_block_title_padding'), '_bx_uni_stg_cpt_option_block_title_padding', '0px', 'digit', '', '', '', 10),
    104. 

  104. (@iCategoryId, CONCAT(@sName, '_block_title_font_family'), '_bx_uni_stg_cpt_option_block_title_font_family', 'Helvetica, Arial, sans-serif', 'digit', '', '', '', 11),
    105. 

  105. (@iCategoryId, CONCAT(@sName, '_block_title_font_size'), '_bx_uni_stg_cpt_option_block_title_font_size', '1.5rem', 'digit', '', '', '', 12),
    106. 

  106. (@iCategoryId, CONCAT(@sName, '_block_title_font_color'), '_bx_uni_stg_cpt_option_block_title_font_color', 'rgba(0, 0, 20, 1)', 'rgba', '', '', '', 13),
    107. 

  107. (@iCategoryId, CONCAT(@sName, '_block_title_div_height'), '_bx_uni_stg_cpt_option_block_title_div_height', '1px', 'digit', '', '', '', 14),
    108. 

  108. (@iCategoryId, CONCAT(@sName, '_block_title_div_bg_color'), '_bx_uni_stg_cpt_option_block_title_div_bg_color', 'rgba(208, 208, 208, 1)', 'rgba', '', '', '', 15);
    109. 

  109. 

  110. 

  111. -- SETTINGS: UNI Styles Card
    112. 

  112. INSERT INTO `sys_options_categories`(`type_id`, `name`, `caption`, `order`) VALUES 
    113. 

  113. (@iTypeId, CONCAT(@sName, '_styles_card'), '_bx_uni_stg_cpt_category_styles_card', 7);
    114. 

  114. SET @iCategoryId = LAST_INSERT_ID();
    115. 

  115. 

  116. INSERT INTO `sys_options`(`category_id`, `name`, `caption`, `value`, `type`, `extra`, `check`, `check_error`, `order`) VALUES
    117. 

  117. (@iCategoryId, CONCAT(@sName, '_card_bg_color'), '_bx_uni_stg_cpt_option_card_bg_color', 'rgba(242, 242, 242, 1)', 'rgba', '', '', '', 1),
    118. 

  118. (@iCategoryId, CONCAT(@sName, '_card_bg_image'), '_bx_uni_stg_cpt_option_card_bg_image', '', 'image', '', '', '', 2),
    119. 

  119. (@iCategoryId, CONCAT(@sName, '_card_bg_image_repeat'), '_bx_uni_stg_cpt_option_card_bg_image_repeat', 'no-repeat', 'select', 'no-repeat,repeat,repeat-x,repeat-y', '', '', 3),
    120. 

  120. (@iCategoryId, CONCAT(@sName, '_card_bg_image_size'), '_bx_uni_stg_cpt_option_card_bg_image_size', 'cover', 'select', 'auto,cover,contain', '', '', 4),
    121. 

  121. (@iCategoryId, CONCAT(@sName, '_card_content_padding'), '_bx_uni_stg_cpt_option_card_content_padding', '20px', 'digit', '', '', '', 5),
    122. 

  122. (@iCategoryId, CONCAT(@sName, '_card_border_color'), '_bx_uni_stg_cpt_option_card_border_color', 'rgba(208, 208, 208, 1)', 'rgba', '', '', '', 6),
    123. 

  123. (@iCategoryId, CONCAT(@sName, '_card_border_size'), '_bx_uni_stg_cpt_option_card_border_size', '0px', 'digit', '', '', '', 7),
    124. 

  124. (@iCategoryId, CONCAT(@sName, '_card_border_radius'), '_bx_uni_stg_cpt_option_card_border_radius', '3px', 'digit', '', '', '', 8),
    125. 

  125. (@iCategoryId, CONCAT(@sName, '_card_shadow'), '_bx_uni_stg_cpt_option_card_shadow', 'none', 'digit', '', '', '', 9);
    126. 

  126. 

  127. 

  128. -- SETTINGS: UNI Styles Popups
    129. 

  129. INSERT INTO `sys_options_categories`(`type_id`, `name`, `caption`, `order`) VALUES 
    130. 

  130. (@iTypeId, CONCAT(@sName, '_styles_popup'), '_bx_uni_stg_cpt_category_styles_popup', 8);
    131. 

  131. SET @iCategoryId = LAST_INSERT_ID();
    132. 

  132. 

  133. INSERT INTO `sys_options`(`category_id`, `name`, `caption`, `value`, `type`, `extra`, `check`, `check_error`, `order`) VALUES
    134. 

  134. (@iCategoryId, CONCAT(@sName, '_popup_bg_color'), '_bx_uni_stg_cpt_option_popup_bg_color', 'rgba(255, 255, 255, 1)', 'rgba', '', '', '', 1),
    135. 

  135. (@iCategoryId, CONCAT(@sName, '_popup_bg_image'), '_bx_uni_stg_cpt_option_popup_bg_image', '', 'image', '', '', '', 2),
    136. 

  136. (@iCategoryId, CONCAT(@sName, '_popup_bg_image_repeat'), '_bx_uni_stg_cpt_option_popup_bg_image_repeat', 'no-repeat', 'select', 'no-repeat,repeat,repeat-x,repeat-y', '', '', 3),
    137. 

  137. (@iCategoryId, CONCAT(@sName, '_popup_bg_image_size'), '_bx_uni_stg_cpt_option_popup_bg_image_size', 'cover', 'select', 'auto,cover,contain', '', '', 4),
    138. 

  138. (@iCategoryId, CONCAT(@sName, '_popup_content_padding'), '_bx_uni_stg_cpt_option_popup_content_padding', '1.25rem', 'digit', '', '', '', 5),
    139. 

  139. (@iCategoryId, CONCAT(@sName, '_popup_border_color'), '_bx_uni_stg_cpt_option_popup_border_color', 'rgba(56, 61, 102, 1)', 'rgba', '', '', '', 6),
    140. 

  140. (@iCategoryId, CONCAT(@sName, '_popup_border_size'), '_bx_uni_stg_cpt_option_popup_border_size', '1px', 'digit', '', '', '', 7),
    141. 

  141. (@iCategoryId, CONCAT(@sName, '_popup_border_radius'), '_bx_uni_stg_cpt_option_popup_border_radius', '3px', 'digit', '', '', '', 8),
    142. 

  142. (@iCategoryId, CONCAT(@sName, '_popup_shadow'), '_bx_uni_stg_cpt_option_popup_shadow', 'none', 'digit', '', '', '', 9),
    143. 

  143. (@iCategoryId, CONCAT(@sName, '_popup_title_padding'), '_bx_uni_stg_cpt_option_popup_title_padding', '1.25rem', 'digit', '', '', '', 10),
    144. 

  144. (@iCategoryId, CONCAT(@sName, '_popup_title_font_family'), '_bx_uni_stg_cpt_option_popup_title_font_family', 'Helvetica, Arial, sans-serif', 'digit', '', '', '', 11),
    145. 

  145. (@iCategoryId, CONCAT(@sName, '_popup_title_font_size'), '_bx_uni_stg_cpt_option_popup_title_font_size', '1.5rem', 'digit', '', '', '', 12),
    146. 

  146. (@iCategoryId, CONCAT(@sName, '_popup_title_font_color'), '_bx_uni_stg_cpt_option_popup_title_font_color', 'rgba(0, 0, 20, 1)', 'rgba', '', '', '', 13);
    147. 

  147. 

  148. 

  149. -- SETTINGS: UNI Styles Slide Menus
    150. 

  150. INSERT INTO `sys_options_categories`(`type_id`, `name`, `caption`, `order`) VALUES 
    151. 

  151. (@iTypeId, CONCAT(@sName, '_styles_menu_slide'), '_bx_uni_stg_cpt_category_styles_menu_slide', 9);
    152. 

  152. SET @iCategoryId = LAST_INSERT_ID();
    153. 

  153. 

  154. INSERT INTO `sys_options`(`category_id`, `name`, `caption`, `value`, `type`, `extra`, `check`, `check_error`, `order`) VALUES
    155. 

  155. (@iCategoryId, CONCAT(@sName, '_menu_slide_bg_color'), '_bx_uni_stg_cpt_option_menu_slide_bg_color', 'rgba(255, 255, 255, 1)', 'rgba', '', '', '', 1),
    156. 

  156. (@iCategoryId, CONCAT(@sName, '_menu_slide_bg_image'), '_bx_uni_stg_cpt_option_menu_slide_bg_image', '', 'image', '', '', '', 2),
    157. 

  157. (@iCategoryId, CONCAT(@sName, '_menu_slide_bg_image_repeat'), '_bx_uni_stg_cpt_option_menu_slide_bg_image_repeat', 'no-repeat', 'select', 'no-repeat,repeat,repeat-x,repeat-y', '', '', 3),
    158. 

  158. (@iCategoryId, CONCAT(@sName, '_menu_slide_bg_image_size'), '_bx_uni_stg_cpt_option_menu_slide_bg_image_size', 'cover', 'select', 'auto,cover,contain', '', '', 4),
    159. 

  159. (@iCategoryId, CONCAT(@sName, '_menu_slide_content_padding'), '_bx_uni_stg_cpt_option_menu_slide_content_padding', '1.25rem', 'digit', '', '', '', 5),
    160. 

  160. (@iCategoryId, CONCAT(@sName, '_menu_slide_border_color'), '_bx_uni_stg_cpt_option_menu_slide_border_color', 'rgba(208, 208, 208, 1)', 'rgba', '', '', '', 6),
    161. 

  161. (@iCategoryId, CONCAT(@sName, '_menu_slide_border_size'), '_bx_uni_stg_cpt_option_menu_slide_border_size', '0px', 'digit', '', '', '', 7),
    162. 

  162. (@iCategoryId, CONCAT(@sName, '_menu_slide_shadow'), '_bx_uni_stg_cpt_option_menu_slide_shadow', 'none', 'digit', '', '', '', 8);
    163. 

  163. 

  164. 

  165. -- SETTINGS: UNI Styles Page Menu
    166. 

  166. INSERT INTO `sys_options_categories`(`type_id`, `name`, `caption`, `order`) VALUES 
    167. 

  167. (@iTypeId, CONCAT(@sName, '_styles_menu_page'), '_bx_uni_stg_cpt_category_styles_menu_page', 10);
    168. 

  168. SET @iCategoryId = LAST_INSERT_ID();
    169. 

  169. 

  170. INSERT INTO `sys_options`(`category_id`, `name`, `caption`, `value`, `type`, `extra`, `check`, `check_error`, `order`) VALUES
    171. 

  171. (@iCategoryId, CONCAT(@sName, '_menu_page_height'), '_bx_uni_stg_cpt_option_menu_page_height', '2.5rem', 'digit', '', '', '', 1),
    172. 

  172. (@iCategoryId, CONCAT(@sName, '_menu_page_bg_color'), '_bx_uni_stg_cpt_option_menu_page_bg_color', 'rgba(242, 242, 242, 1)', 'rgba', '', '', '', 2),
    173. 

  173. (@iCategoryId, CONCAT(@sName, '_menu_page_bg_image'), '_bx_uni_stg_cpt_option_menu_page_bg_image', '', 'image', '', '', '', 3),
    174. 

  174. (@iCategoryId, CONCAT(@sName, '_menu_page_bg_image_repeat'), '_bx_uni_stg_cpt_option_menu_page_bg_image_repeat', 'no-repeat', 'select', 'no-repeat,repeat,repeat-x,repeat-y', '', '', 3),
    175. 

  175. (@iCategoryId, CONCAT(@sName, '_menu_page_bg_image_size'), '_bx_uni_stg_cpt_option_menu_page_bg_image_size', 'cover', 'select', 'auto,cover,contain', '', '', 4),
    176. 

  176. (@iCategoryId, CONCAT(@sName, '_menu_page_content_padding'), '_bx_uni_stg_cpt_option_menu_page_content_padding', '0px', 'digit', '', '', '', 4),
    177. 

  177. (@iCategoryId, CONCAT(@sName, '_menu_page_border_color'), '_bx_uni_stg_cpt_option_menu_page_border_color', 'rgba(208, 208, 208, 1)', 'rgba', '', '', '', 5),
    178. 

  178. (@iCategoryId, CONCAT(@sName, '_menu_page_border_size'), '_bx_uni_stg_cpt_option_menu_page_border_size', '0px', 'digit', '', '', '', 6),
    179. 

  179. (@iCategoryId, CONCAT(@sName, '_menu_page_shadow'), '_bx_uni_stg_cpt_option_menu_page_shadow', 'none', 'digit', '', '', '', 7);
    180. 

  180. 

  181. 

  182. -- SETTINGS: UNI Styles Forms
    183. 

  183. INSERT INTO `sys_options_categories`(`type_id`, `name`, `caption`, `order`) VALUES 
    184. 

  184. (@iTypeId, CONCAT(@sName, '_styles_form'), '_bx_uni_stg_cpt_category_styles_form', 11);
    185. 

  185. SET @iCategoryId = LAST_INSERT_ID();
    186. 

  186. 

  187. INSERT INTO `sys_options`(`category_id`, `name`, `caption`, `value`, `type`, `extra`, `check`, `check_error`, `order`) VALUES
    188. 

  188. (@iCategoryId, CONCAT(@sName, '_form_input_height'), '_bx_uni_stg_cpt_option_form_input_height', '2.2rem', 'digit', '', '', '', 1),
    189. 

  189. (@iCategoryId, CONCAT(@sName, '_form_input_bg_color'), '_bx_uni_stg_cpt_option_form_input_bg_color', 'rgba(255, 255, 255, 1)', 'rgba', '', '', '', 2),
    190. 

  190. (@iCategoryId, CONCAT(@sName, '_form_input_bg_color_active'), '_bx_uni_stg_cpt_option_form_input_bg_color_active', 'rgba(255, 255, 255, 1)', 'rgba', '', '', '', 3),
    191. 

  191. (@iCategoryId, CONCAT(@sName, '_form_input_border_color'), '_bx_uni_stg_cpt_option_form_input_border_color', 'rgba(121, 189, 154, 1)', 'rgba', '', '', '', 4),
    192. 

  192. (@iCategoryId, CONCAT(@sName, '_form_input_border_color_active'), '_bx_uni_stg_cpt_option_form_input_border_color_active', 'rgba(108, 170, 138, 1)', 'rgba', '', '', '', 5),
    193. 

  193. (@iCategoryId, CONCAT(@sName, '_form_input_border_size'), '_bx_uni_stg_cpt_option_form_input_border_size', '2px', 'digit', '', '', '', 6),
    194. 

  194. (@iCategoryId, CONCAT(@sName, '_form_input_shadow'), '_bx_uni_stg_cpt_option_form_input_shadow', 'none', 'digit', '', '', '', 7),
    195. 

  195. (@iCategoryId, CONCAT(@sName, '_form_input_font_family'), '_bx_uni_stg_cpt_option_form_input_font_family', 'Helvetica, Arial, sans-serif', 'digit', '', '', '', 8),
    196. 

  196. (@iCategoryId, CONCAT(@sName, '_form_input_font_size'), '_bx_uni_stg_cpt_option_form_input_font_size', '1.125rem', 'digit', '', '', '', 9),
    197. 

  197. (@iCategoryId, CONCAT(@sName, '_form_input_font_color'), '_bx_uni_stg_cpt_option_form_input_font_color', 'rgba(51, 51, 51, 1)', 'rgba', '', '', '', 10);
    198. 

  198. 

  199. 

  200. -- SETTINGS: UNI Styles Large Buttons
    201. 

  201. INSERT INTO `sys_options_categories`(`type_id`, `name`, `caption`, `order`) VALUES 
    202. 

  202. (@iTypeId, CONCAT(@sName, '_styles_large_button'), '_bx_uni_stg_cpt_category_styles_large_button', 12);
    203. 

  203. SET @iCategoryId = LAST_INSERT_ID();
    204. 

  204. 

  205. INSERT INTO `sys_options`(`category_id`, `name`, `caption`, `value`, `type`, `extra`, `check`, `check_error`, `order`) VALUES
    206. 

  206. (@iCategoryId, CONCAT(@sName, '_button_lg_height'), '_bx_uni_stg_cpt_option_button_lg_height', '2.25rem', 'digit', '', '', '', 1),
    207. 

  207. (@iCategoryId, CONCAT(@sName, '_button_lg_bg_color'), '_bx_uni_stg_cpt_option_button_lg_bg_color', 'rgba(108, 170, 138, 1)', 'rgba', '', '', '', 2),
    208. 

  208. (@iCategoryId, CONCAT(@sName, '_button_lg_bg_color_hover'), '_bx_uni_stg_cpt_option_button_lg_bg_color_hover', 'rgba(58, 134, 134, 1)', 'rgba', '', '', '', 3),
    209. 

  209. (@iCategoryId, CONCAT(@sName, '_button_lg_border_color'), '_bx_uni_stg_cpt_option_button_lg_border_color', 'rgba(208, 208, 208, 1)', 'rgba', '', '', '', 4),
    210. 

  210. (@iCategoryId, CONCAT(@sName, '_button_lg_border_color_hover'), '_bx_uni_stg_cpt_option_button_lg_border_color_hover', 'rgba(208, 208, 208, 1)', 'rgba', '', '', '', 5),
    211. 

  211. (@iCategoryId, CONCAT(@sName, '_button_lg_border_size'), '_bx_uni_stg_cpt_option_button_lg_border_size', '0px', 'digit', '', '', '', 6),
    212. 

  212. (@iCategoryId, CONCAT(@sName, '_button_lg_border_radius'), '_bx_uni_stg_cpt_option_button_lg_border_radius', '3px', 'digit', '', '', '', 7),
    213. 

  213. (@iCategoryId, CONCAT(@sName, '_button_lg_shadow'), '_bx_uni_stg_cpt_option_button_lg_shadow', 'none', 'digit', '', '', '', 8),
    214. 

  214. (@iCategoryId, CONCAT(@sName, '_button_lg_font_family'), '_bx_uni_stg_cpt_option_button_lg_font_family', '"Helvetica Neue", Helvetica, Arial, "Lucida Grande", sans-serif', 'digit', '', '', '', 9),
    215. 

  215. (@iCategoryId, CONCAT(@sName, '_button_lg_font_size'), '_bx_uni_stg_cpt_option_button_lg_font_size', '1rem', 'digit', '', '', '', 10),
    216. 

  216. (@iCategoryId, CONCAT(@sName, '_button_lg_font_color'), '_bx_uni_stg_cpt_option_button_lg_font_color', 'rgba(255, 255, 255, 1)', 'rgba', '', '', '', 11),
    217. 

  217. (@iCategoryId, CONCAT(@sName, '_button_lg_font_color_hover'), '_bx_uni_stg_cpt_option_button_lg_font_color_hover', 'rgba(255, 255, 255, 1)', 'rgba', '', '', '', 12),
    218. 

  218. (@iCategoryId, CONCAT(@sName, '_button_lg_font_shadow'), '_bx_uni_stg_cpt_option_button_lg_font_shadow', 'none', 'digit', '', '', '', 13),
    219. 

  219. (@iCategoryId, CONCAT(@sName, '_button_lg_font_weight'), '_bx_uni_stg_cpt_option_button_lg_font_weight', '400', 'digit', '', '', '', 14);
    220. 

  220. 

  221. -- SETTINGS: UNI Styles Small Buttons
    222. 

  222. INSERT INTO `sys_options_categories`(`type_id`, `name`, `caption`, `order`) VALUES 
    223. 

  223. (@iTypeId, CONCAT(@sName, '_styles_small_button'), '_bx_uni_stg_cpt_category_styles_small_button', 13);
    224. 

  224. SET @iCategoryId = LAST_INSERT_ID();
    225. 

  225. 

  226. INSERT INTO `sys_options`(`category_id`, `name`, `caption`, `value`, `type`, `extra`, `check`, `check_error`, `order`) VALUES
    227. 

  227. (@iCategoryId, CONCAT(@sName, '_button_sm_height'), '_bx_uni_stg_cpt_option_button_sm_height', '1.5rem', 'digit', '', '', '', 1),
    228. 

  228. (@iCategoryId, CONCAT(@sName, '_button_sm_bg_color'), '_bx_uni_stg_cpt_option_button_sm_bg_color', 'rgba(108, 170, 138, 1)', 'rgba', '', '', '', 2),
    229. 

  229. (@iCategoryId, CONCAT(@sName, '_button_sm_bg_color_hover'), '_bx_uni_stg_cpt_option_button_sm_bg_color_hover', 'rgba(58, 134, 134, 1)', 'rgba', '', '', '', 3),
    230. 

  230. (@iCategoryId, CONCAT(@sName, '_button_sm_border_color'), '_bx_uni_stg_cpt_option_button_sm_border_color', 'rgba(208, 208, 208, 1)', 'rgba', '', '', '', 4),
    231. 

  231. (@iCategoryId, CONCAT(@sName, '_button_sm_border_color_hover'), '_bx_uni_stg_cpt_option_button_sm_border_color_hover', 'rgba(208, 208, 208, 1)', 'rgba', '', '', '', 5),
    232. 

  232. (@iCategoryId, CONCAT(@sName, '_button_sm_border_size'), '_bx_uni_stg_cpt_option_button_sm_border_size', '0px', 'digit', '', '', '', 6),
    233. 

  233. (@iCategoryId, CONCAT(@sName, '_button_sm_border_radius'), '_bx_uni_stg_cpt_option_button_sm_border_radius', '3px', 'digit', '', '', '', 7),
    234. 

  234. (@iCategoryId, CONCAT(@sName, '_button_sm_shadow'), '_bx_uni_stg_cpt_option_button_sm_shadow', 'none', 'digit', '', '', '', 8),
    235. 

  235. (@iCategoryId, CONCAT(@sName, '_button_sm_font_family'), '_bx_uni_stg_cpt_option_button_sm_font_family', '"Helvetica Neue", Helvetica, Arial, "Lucida Grande", sans-serif', 'digit', '', '', '', 9),
    236. 

  236. (@iCategoryId, CONCAT(@sName, '_button_sm_font_size'), '_bx_uni_stg_cpt_option_button_sm_font_size', '0.9rem', 'digit', '', '', '', 10),
    237. 

  237. (@iCategoryId, CONCAT(@sName, '_button_sm_font_color'), '_bx_uni_stg_cpt_option_button_sm_font_color', 'rgba(255, 255, 255, 1)', 'rgba', '', '', '', 11),
    238. 

  238. (@iCategoryId, CONCAT(@sName, '_button_sm_font_color_hover'), '_bx_uni_stg_cpt_option_button_sm_font_color_hover', 'rgba(255, 255, 255, 1)', 'rgba', '', '', '', 12),
    239. 

  239. (@iCategoryId, CONCAT(@sName, '_button_sm_font_shadow'), '_bx_uni_stg_cpt_option_button_sm_font_shadow', 'none', 'digit', '', '', '', 13),
    240. 

  240. (@iCategoryId, CONCAT(@sName, '_button_sm_font_weight'), '_bx_uni_stg_cpt_option_button_sm_font_weight', '400', 'digit', '', '', '', 14);
    241. 

  241. 

  242. -- SETTINGS: UNI Styles Font
    243. 

  243. INSERT INTO `sys_options_categories`(`type_id`, `name`, `caption`, `order`) VALUES 
    244. 

  244. (@iTypeId, CONCAT(@sName, '_styles_font'), '_bx_uni_stg_cpt_category_styles_font', 14);
    245. 

  245. SET @iCategoryId = LAST_INSERT_ID();
    246. 

  246. 

  247. INSERT INTO `sys_options`(`category_id`, `name`, `caption`, `value`, `type`, `extra`, `check`, `check_error`, `order`) VALUES
    248. 

  248. (@iCategoryId, CONCAT(@sName, '_font_family'), '_bx_uni_stg_cpt_option_font_family', '"Helvetica Neue", Helvetica, Arial, "Lucida Grande", sans-serif', 'digit', '', '', '', 1),
    249. 

  249. (@iCategoryId, CONCAT(@sName, '_font_size_default'), '_bx_uni_stg_cpt_option_size_default', '18px', 'digit', '', '', '', 2),
    250. 

  250. (@iCategoryId, CONCAT(@sName, '_font_color_default'), '_bx_uni_stg_cpt_option_color_default', 'rgba(51, 51, 51, 1)', 'rgba', '', '', '', 3),
    251. 

  251. (@iCategoryId, CONCAT(@sName, '_font_size_small'), '_bx_uni_stg_cpt_option_size_small', '14px', 'digit', '', '', '', 4),
    252. 

  252. (@iCategoryId, CONCAT(@sName, '_font_color_small'), '_bx_uni_stg_cpt_option_color_small', 'rgba(51, 51, 51, 1)', 'rgba', '', '', '', 5),
    253. 

  253. (@iCategoryId, CONCAT(@sName, '_font_size_middle'), '_bx_uni_stg_cpt_option_size_middle', '16px', 'digit', '', '', '', 6),
    254. 

  254. (@iCategoryId, CONCAT(@sName, '_font_color_middle'), '_bx_uni_stg_cpt_option_color_middle', 'rgba(51, 51, 51, 1)', 'rgba', '', '', '', 7),
    255. 

  255. (@iCategoryId, CONCAT(@sName, '_font_size_large'), '_bx_uni_stg_cpt_option_size_large', '22px', 'digit', '', '', '', 8),
    256. 

  256. (@iCategoryId, CONCAT(@sName, '_font_color_large'), '_bx_uni_stg_cpt_option_color_large', 'rgba(51, 51, 51, 1)', 'rgba', '', '', '', 9),
    257. 

  257. (@iCategoryId, CONCAT(@sName, '_font_size_h1'), '_bx_uni_stg_cpt_option_size_h1', '38px', 'digit', '', '', '', 10),
    258. 

  258. (@iCategoryId, CONCAT(@sName, '_font_color_h1'), '_bx_uni_stg_cpt_option_color_h1', 'rgba(51, 51, 51, 1)', 'rgba', '', '', '', 11),
    259. 

  259. (@iCategoryId, CONCAT(@sName, '_font_size_h2'), '_bx_uni_stg_cpt_option_size_h2', '24px', 'digit', '', '', '', 12),
    260. 

  260. (@iCategoryId, CONCAT(@sName, '_font_color_h2'), '_bx_uni_stg_cpt_option_color_h2', 'rgba(51, 51, 51, 1)', 'rgba', '', '', '', 13),
    261. 

  261. (@iCategoryId, CONCAT(@sName, '_font_size_h3'), '_bx_uni_stg_cpt_option_size_h3', '18px', 'digit', '', '', '', 14),
    262. 

  262. (@iCategoryId, CONCAT(@sName, '_font_color_h3'), '_bx_uni_stg_cpt_option_color_h3', 'rgba(51, 51, 51, 1)', 'rgba', '', '', '', 15),
    263. 

  263. (@iCategoryId, CONCAT(@sName, '_font_color_grayed'), '_bx_uni_stg_cpt_option_color_grayed', 'rgba(153, 153, 153, 1)', 'rgba', '', '', '', 16),
    264. 

  264. (@iCategoryId, CONCAT(@sName, '_font_color_contrasted'), '_bx_uni_stg_cpt_option_color_contrasted', 'rgba(255, 255, 255, 1)', 'rgba', '', '', '', 17);
    265. 

  265. 

  266. -- SETTINGS: UNI Viewport Tablet
    267. 

  267. INSERT INTO `sys_options_categories`(`type_id`, `name`, `caption`, `order`) VALUES 
    268. 

  268. (@iTypeId, CONCAT(@sName, '_viewport_tablet'), '_bx_uni_stg_cpt_category_viewport_tablet', 15);
    269. 

  269. SET @iCategoryId = LAST_INSERT_ID();
    270. 

  270. 

  271. INSERT INTO `sys_options`(`category_id`, `name`, `caption`, `value`, `type`, `extra`, `check`, `check_error`, `order`) VALUES
    272. 

  272. (@iCategoryId, CONCAT(@sName, '_vpt_font_size_scale'), '_bx_uni_stg_cpt_option_vpt_font_size_scale', '100%', 'digit', '', '', '', 1);
    273. 

  273. 

  274. -- SETTINGS: UNI Viewport Mobile
    275. 

  275. INSERT INTO `sys_options_categories`(`type_id`, `name`, `caption`, `order`) VALUES 
    276. 

  276. (@iTypeId, CONCAT(@sName, '_viewport_mobile'), '_bx_uni_stg_cpt_category_viewport_mobile', 16);
    277. 

  277. SET @iCategoryId = LAST_INSERT_ID();
    278. 

  278. 

  279. INSERT INTO `sys_options`(`category_id`, `name`, `caption`, `value`, `type`, `extra`, `check`, `check_error`, `order`) VALUES
    280. 

  280. (@iCategoryId, CONCAT(@sName, '_vpm_font_size_scale'), '_bx_uni_stg_cpt_option_vpm_font_size_scale', '85%', 'digit', '', '', '', 1);
    281. 

  281. 

  282. 

  283. -- STUDIO PAGE & WIDGET
    284. 

  284. INSERT INTO `sys_std_pages`(`index`, `name`, `header`, `caption`, `icon`) VALUES
    285. 

  285. (3, @sName, '', '', 'bx_uni@modules/boonex/uni/|std-pi.png');
    286. 

  286. SET @iPageId = LAST_INSERT_ID();
    287. 

  287. 

  288. SET @iParentPageId = (SELECT `id` FROM `sys_std_pages` WHERE `name`='home');
    289. 

  289. SET @iParentPageOrder = (SELECT MAX(`order`) FROM `sys_std_pages_widgets` WHERE `page_id`=@iParentPageId);
    290. 

  290. INSERT INTO `sys_std_widgets`(`page_id`, `module`, `url`, `click`, `icon`, `caption`, `cnt_notices`, `cnt_actions`) VALUES
    291. 

  291. (@iPageId, @sName, CONCAT('{url_studio}design.php?name=', @sName), '', 'bx_uni@modules/boonex/uni/|std-wi.png', '_bx_uni_wgt_cpt', '', 'a:4:{s:6:"module";s:6:"system";s:6:"method";s:11:"get_actions";s:6:"params";a:0:{}s:5:"class";s:18:"TemplStudioDesigns";}');
    292. 

  292. INSERT INTO `sys_std_pages_widgets`(`page_id`, `widget_id`, `order`) VALUES
    293. 

  293. (@iParentPageId, LAST_INSERT_ID(), @iParentPageOrder + 1);
    294.