Changeset 9972 for trunk/modules/boonex/blogs/install/sql/install.sql

Timestamp:

04/06/09 04:21:27 (3 years ago)

Author:

Andrey Prikaznov

Message:

 

File:

• trunk/modules/boonex/blogs/install/sql/install.sql (modified) (2 diffs)

trunk/modules/boonex/blogs/install/sql/install.sql

@@ -145 +145 @@
 INSERT INTO `sys_options_cats` VALUES(NULL, 'Blogs', 9);
 SET @iGlCategID = LAST_INSERT_ID();
-INSERT INTO `GlParams` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES('blogCategoryCaptionMaxLenght', '150', @iGlCategID, 'Maximum length of Blog Category caption', 'digit', '', '', 3);
-INSERT INTO `GlParams` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES('blogCommentMaxLenght', '250', @iGlCategID, 'Maximum length of Blog comment', 'digit', '', '', 2);
-INSERT INTO `GlParams` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES('blogAutoApproval', 'on', @iGlCategID, 'Enable AutoApproval of Blogs', 'checkbox', '', '', 7);
-INSERT INTO `GlParams` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES('blog_step', '10', @iGlCategID, 'How many blogs showing on page', 'digit', '', '', 15);
-INSERT INTO `GlParams` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES('max_blogs_on_home', '3', @iGlCategID, 'Maximum number of Blogs to show on homepage', 'digit', '', '', 2);
-INSERT INTO `GlParams` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES('max_blog_preview', '256', @iGlCategID, 'Maximum length of Blog preview', 'digit', '', '', 3);
-INSERT INTO `GlParams` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES('permalinks_blogs', '', 26, 'Enable friendly blogs permalinks', 'checkbox', '', '', 4);
-INSERT INTO `GlParams` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES('bx_blogs_enabled', 'on', @iGlCategID, 'Enable Boonex Blogs module', 'checkbox', '', '', 4);
-INSERT INTO `GlParams` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES('blogCaptionMaxLenght', '150', @iGlCategID, 'Maximum length of Blog Caption', 'digit', '', '', 5);
-INSERT INTO `GlParams` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES('category_auto_app_blogs', 'on', @iGlCategID, 'Autoapprove categories of blog posts', 'checkbox', '', '', 6);
+INSERT INTO `sys_options` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES('blogCategoryCaptionMaxLenght', '150', @iGlCategID, 'Maximum length of Blog Category caption', 'digit', '', '', 3);
+INSERT INTO `sys_options` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES('blogCommentMaxLenght', '250', @iGlCategID, 'Maximum length of Blog comment', 'digit', '', '', 2);
+INSERT INTO `sys_options` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES('blogAutoApproval', 'on', @iGlCategID, 'Enable AutoApproval of Blogs', 'checkbox', '', '', 7);
+INSERT INTO `sys_options` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES('blog_step', '10', @iGlCategID, 'How many blogs showing on page', 'digit', '', '', 15);
+INSERT INTO `sys_options` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES('max_blogs_on_home', '3', @iGlCategID, 'Maximum number of Blogs to show on homepage', 'digit', '', '', 2);
+INSERT INTO `sys_options` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES('max_blog_preview', '256', @iGlCategID, 'Maximum length of Blog preview', 'digit', '', '', 3);
+INSERT INTO `sys_options` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES('permalinks_blogs', '', 26, 'Enable friendly blogs permalinks', 'checkbox', '', '', 4);
+INSERT INTO `sys_options` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES('bx_blogs_enabled', 'on', @iGlCategID, 'Enable Boonex Blogs module', 'checkbox', '', '', 4);
+INSERT INTO `sys_options` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES('blogCaptionMaxLenght', '150', @iGlCategID, 'Maximum length of Blog Caption', 'digit', '', '', 5);
+INSERT INTO `sys_options` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES('category_auto_app_blogs', 'on', @iGlCategID, 'Autoapprove categories of blog posts', 'checkbox', '', '', 6);
 
 INSERT INTO `PageCompose` (`ID`, `Page`, `PageWidth`, `Desc`, `Caption`, `Column`, `Order`, `Func`, `Content`, `DesignBox`, `ColWidth`, `Visible`, `MinWidth`) VALUES(NULL, 'index', '960px', 'Recently posted blogs', '_Blogs', 1, 4, 'PHP', 'return BxDolService::call(''blogs'', ''blogs_index_page'');', 1, 70, 'non,memb', 0);
@@ -198 +198 @@
 ALTER TABLE `[db_prefix]_posts` ADD FULLTEXT (`PostCaption`, `PostText`, `Tags`);
 
-INSERT INTO `GlParams` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES('permalinks_module_blogs', 'on', 26, 'Enable friendly blogs permalink', 'checkbox', '', '', 0);
+INSERT INTO `sys_options` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES('permalinks_module_blogs', 'on', 26, 'Enable friendly blogs permalink', 'checkbox', '', '', 0);
 
 INSERT INTO `sys_permalinks`(`standard`, `permalink`, `check`) VALUES('modules/boonex/blogs/blogs.php', 'blogs/', 'permalinks_module_blogs');