Mambo API

[Summary view] [Print] [Text view]

   1  # $Id: upgrade45_109to451.sql,v 1.1 2006/08/24 Chanh OngExp $

   2  # Fix to run in mysql 5 and remove duplicate - Chanh Ong

   3  # Mambo 4.5 (1.0.9) to Mambo 4.5.1

   4  
   5  ALTER TABLE `mos_banner` CHANGE `checked_out_time` `checked_out_time` DATETIME DEFAULT '0000-00-00 00:00:00' NOT NULL;
   6  
   7  ALTER TABLE `mos_categories` ADD `parent_id` int(11) NOT NULL default 0 AFTER `id`;
   8  ALTER TABLE `mos_categories` CHANGE `section` `section` varchar(50) NOT NULL default '';
   9  ALTER TABLE `mos_categories` ADD `params` TEXT NOT NULL;
  10  
  11  ALTER TABLE `mos_components` CHANGE `ordering` `ordering` int(11) NOT NULL default '0';
  12  ALTER TABLE `mos_components` ADD `params` TEXT NOT NULL;
  13  
  14  ALTER TABLE `mos_contact_details` ADD `params` TEXT NOT NULL;
  15  ALTER TABLE `mos_contact_details` ADD `user_id` int(11) NOT NULL default '0';
  16  ALTER TABLE `mos_contact_details` ADD `catid` int(11) NOT NULL default '0';
  17  ALTER TABLE `mos_contact_details` ADD `access` tinyint(3) unsigned NOT NULL default '0';
  18  
  19  ALTER TABLE `mos_content` CHANGE `ordering` `ordering` int(11) NOT NULL default '0';
  20  
  21  ALTER TABLE `mos_content_frontpage` CHANGE `ordering` `ordering` int(11) NOT NULL default '0';
  22  
  23  DROP TABLE IF EXISTS mos_help;
  24  
  25  CREATE TABLE `mos_mambots` (
  26    `id` int(11) NOT NULL auto_increment,
  27    `name` varchar(100) NOT NULL default '',
  28    `element` varchar(100) NOT NULL default '',
  29    `folder` varchar(100) NOT NULL default '',
  30    `access` tinyint(3) unsigned NOT NULL default '0',
  31    `ordering` int(11) NOT NULL default '0',
  32    `published` tinyint(3) NOT NULL default '0',
  33    `iscore` tinyint(3) NOT NULL default '0',
  34    `client_id` tinyint(3) NOT NULL default '0',
  35    `checked_out` int(11) unsigned NOT NULL default '0',
  36    `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
  37    `params` text NOT NULL,
  38    PRIMARY KEY  (`id`),
  39    KEY `idx_folder` (`published`,`client_id`,`access`,`folder`)
  40  ) TYPE=MyISAM;
  41  
  42  ALTER TABLE `mos_modules` CHANGE `ordering` `ordering` int(11) NOT NULL default '0';
  43  ALTER TABLE `mos_modules` ADD `client_id` tinyint(4) NOT NULL default '0';
  44  
  45  ALTER TABLE `mos_newsfeeds` CHANGE `ordering` `ordering` int(11) NOT NULL default '0';
  46  
  47  DROP TABLE IF EXISTS mos_newsfeedscache;
  48  
  49  DROP TABLE IF EXISTS mos_newsflash;
  50  
  51  ALTER TABLE `mos_sections` ADD `params` TEXT NOT NULL;
  52  
  53  DROP TABLE IF EXISTS mos_templates;
  54  
  55  CREATE TABLE `mos_template_positions` (
  56    `id` int(11) NOT NULL auto_increment,
  57    `position` varchar(10) NOT NULL default '',
  58    `description` varchar(255) NOT NULL default '',
  59    PRIMARY KEY  (`id`)
  60  ) TYPE=MyISAM;
  61  
  62  ALTER TABLE `mos_users` ADD `params` TEXT NOT NULL;
  63  
  64  ALTER TABLE `mos_weblinks` ADD `params` TEXT NOT NULL;
  65  
  66  INSERT INTO `mos_modules` VALUES ('', 'Search', '', 7, 'right', 0, '0000-00-00 00:00:00', 1, 'mod_search', 0, 0, 1, '', 1, 0);
  67  INSERT INTO `mos_modules` VALUES ('', 'Random Image', '', 2, 'user1', 0, '0000-00-00 00:00:00', 1, 'mod_random_image', 0, 0, 1, '', 1, 0);
  68  INSERT INTO `mos_modules` VALUES ('', 'Random Image', '', 2, 'user1', 0, '0000-00-00 00:00:00', 1, 'mod_random_image', 0, 0, 1, '', 1, 0);
  69  INSERT INTO `mos_modules` VALUES ('', 'Banners', '', 1, 'banner', 0, '0000-00-00 00:00:00', 1, 'mod_banners', 0, 0, 0, 'banner_cids=\nmoduleclass_sfx=\n', 1, 0);
  70  
  71  DELETE FROM `mos_modules` WHERE `module` = 'mod_counter';
  72  DELETE FROM `mos_modules` WHERE `module` = 'mod_online';
  73  
  74  DELETE FROM `mos_components` WHERE name='Media Manager';
  75  DELETE FROM `mos_components` WHERE `option`='com_newsflash';
  76  
  77  INSERT INTO mos_modules VALUES (0,'Components','',1,'cpanel',0,'0000-00-00 00:00:00',1,'mod_components',0,99,1,'',2,1);
  78  INSERT INTO mos_modules VALUES (0,'Popular','',2,'cpanel',0,'0000-00-00 00:00:00',1,'mod_popular',0,99,1,'',2,1);
  79  INSERT INTO mos_modules VALUES (0,'Latest Items','',3,'cpanel',0,'0000-00-00 00:00:00',1,'mod_latest',0,99,1,'',2,1);
  80  INSERT INTO mos_modules VALUES (0,'Menu Stats','',4,'cpanel',0,'0000-00-00 00:00:00',1,'mod_stats',0,99,1,'',2,1);
  81  INSERT INTO mos_modules VALUES (0,'Unread Messages','',1,'header',0,'0000-00-00 00:00:00',1,'mod_unread',0,99,1,'',2,1);
  82  INSERT INTO mos_modules VALUES (0,'Online Users','',2,'header',0,'0000-00-00 00:00:00',1,'mod_online',0,99,1,'',2,1);
  83  INSERT INTO mos_modules VALUES (0,'Full Menu','',1,'top',0,'0000-00-00 00:00:00',1,'mod_fullmenu',0,99,1,'',2,1);
  84  INSERT INTO mos_modules VALUES (0,'Pathway','',1,'pathway',0,'0000-00-00 00:00:00',1,'mod_pathway',0,99,1,'',2,1);
  85  INSERT INTO mos_modules VALUES (0,'Toolbar','',1,'toolbar',0,'0000-00-00 00:00:00',1,'mod_toolbar',0,99,1,'',2,1);
  86  INSERT INTO mos_modules VALUES (0,'System Message','',1,'inset',0,'0000-00-00 00:00:00',1,'mod_mosmsg',0,99,1,'',2,1);
  87  INSERT INTO mos_modules VALUES (0,'Quick Icons','',1,'icon',0,'0000-00-00 00:00:00',1,'mod_quickicon',0,99,1,'',1,1);
  88  
  89  INSERT INTO `mos_templates_menu` VALUES ('rhuk_solarflare_ii', '0', '0');
  90  INSERT INTO `mos_templates_menu` VALUES ('mambo_admin_blue', '0', '1');
  91  
  92  INSERT INTO `mos_template_positions` VALUES (0, 'left', 'Left Column');
  93  INSERT INTO `mos_template_positions` VALUES (0, 'right', 'Right Column');
  94  INSERT INTO `mos_template_positions` VALUES (0, 'top', '');
  95  INSERT INTO `mos_template_positions` VALUES (0, 'bottom', '');
  96  INSERT INTO `mos_template_positions` VALUES (0, 'inset', '');
  97  INSERT INTO `mos_template_positions` VALUES (0, 'banner', '');
  98  INSERT INTO `mos_template_positions` VALUES (0, 'header', '');
  99  INSERT INTO `mos_template_positions` VALUES (0, 'footer', '');
 100  INSERT INTO `mos_template_positions` VALUES (0, 'newsflash', '');
 101  INSERT INTO `mos_template_positions` VALUES (0, 'legals', '');
 102  INSERT INTO `mos_template_positions` VALUES (0, 'pathway', '');
 103  INSERT INTO `mos_template_positions` VALUES (0, 'toolbar', '');
 104  INSERT INTO `mos_template_positions` VALUES (0, 'cpanel', '');
 105  INSERT INTO `mos_template_positions` VALUES (0, 'user1', '');
 106  INSERT INTO `mos_template_positions` VALUES (0, 'user2', '');
 107  INSERT INTO `mos_template_positions` VALUES (0, 'user3', '');
 108  INSERT INTO `mos_template_positions` VALUES (0, 'user4', '');
 109  INSERT INTO `mos_template_positions` VALUES (0, 'user5', '');
 110  INSERT INTO `mos_template_positions` VALUES (0, 'user6', '');
 111  INSERT INTO `mos_template_positions` VALUES (0, 'user7', '');
 112  INSERT INTO `mos_template_positions` VALUES (0, 'user8', '');
 113  INSERT INTO `mos_template_positions` VALUES (0, 'user9', '');
 114  INSERT INTO `mos_template_positions` VALUES (0, 'advert1', '');
 115  INSERT INTO `mos_template_positions` VALUES (0, 'advert2', '');
 116  INSERT INTO `mos_template_positions` VALUES (0, 'advert3', '');
 117  INSERT INTO `mos_template_positions` VALUES (0, 'icon', '');
 118  INSERT INTO `mos_template_positions` VALUES (0, 'debug', '');
 119  
 120  UPDATE `mos_components` SET `link` = '', `admin_menu_link` = '' WHERE `id` = '6' LIMIT 1;
 121  INSERT INTO `mos_components` VALUES ('', 'Contact Categories', '', 0, 6, 'option=com_categories&section=com_contact_details', 'Manage contact categories', '', 2, 'js/ThemeOffice/categories.png', 1, '');
 122  INSERT INTO `mos_components` VALUES ('', 'Manage Contacts', 'option=com_contact', 0, 6, 'option=com_contact', 'Edit contact details', 'com_contact', 0, 'js/ThemeOffice/component.png', 1, '');
 123  INSERT INTO `mos_components` VALUES ('', 'Syndicate', '', 0, 0, 'option=com_syndicate', 'Manage Syndication Settings', 'com_syndicate', 0, 'js/ThemeOffice/component.png', 0, '');
 124  
 125  INSERT INTO mos_mambots VALUES (1,'MOS Image','mosimage','content',0,-10000,1,1,0,0,'0000-00-00 00:00:00','');
 126  INSERT INTO mos_mambots VALUES (2,'MOS Pagination','mospaging','content',0,10000,1,1,0,0,'0000-00-00 00:00:00','');
 127  INSERT INTO mos_mambots VALUES (3,'Legacy Mambot Includer','legacybots','content',0,1,1,1,0,0,'0000-00-00 00:00:00','');
 128  INSERT INTO mos_mambots VALUES (4,'SEF','mossef','content',0,3,1,0,0,0,'0000-00-00 00:00:00','');
 129  INSERT INTO mos_mambots VALUES (5,'MOS Rating','mosvote','content',0,4,1,1,0,0,'0000-00-00 00:00:00','');
 130  INSERT INTO mos_mambots VALUES (6,'Search Content','content.searchbot','search',0,1,1,1,0,0,'0000-00-00 00:00:00','');
 131  INSERT INTO mos_mambots VALUES (7,'Search Weblinks','weblinks.searchbot','search',0,2,1,1,0,0,'0000-00-00 00:00:00','');
 132  INSERT INTO mos_mambots VALUES (8,'Code support','moscode','content',0,2,1,0,0,0,'0000-00-00 00:00:00','');
 133  INSERT INTO mos_mambots VALUES (9,'No WYSIWYG Editor','none','editors',0,1,1,1,0,0,'0000-00-00 00:00:00','');
 134  INSERT INTO mos_mambots VALUES (10,'TinyMCE WYSIWYG Editor','tinymce','editors',0,2,1,0,0,0,'0000-00-00 00:00:00','');
 135  INSERT INTO mos_mambots VALUES (11,'MOS Image Editor Button','mosimage.btn','editors-xtd',0,0,1,0,0,0,'0000-00-00 00:00:00','');
 136  INSERT INTO mos_mambots VALUES (12,'MOS Pagebreak Editor Button','mospage.btn','editors-xtd',0,0,1,0,0,0,'0000-00-00 00:00:00','');
 137  INSERT INTO mos_mambots VALUES (13,'Search Contacts','contacts.searchbot','search',0,3,1,1,0,0,'0000-00-00 00:00:00','');