Annotation of /mambo/branches/4.6/installation/sql/upgrade45_109to451.sql
Parent Directory
| 
Revision Log
Revision 3 - (view) (download)
| 1 : | root | 1 | # $Id: upgrade45_109to451.sql,v 1.1 2005/07/22 01:57:43 eddieajau Exp $ |
| 2 : | |||
| 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 : | CREATE TABLE `mos_templates_menu` ( | ||
| 63 : | `template` varchar(50) NOT NULL default '', | ||
| 64 : | `menuid` int(11) NOT NULL default '0', | ||
| 65 : | `client_id` tinyint(4) NOT NULL default '0', | ||
| 66 : | PRIMARY KEY (`template`,`menuid`) | ||
| 67 : | ) TYPE=MyISAM; | ||
| 68 : | |||
| 69 : | ALTER TABLE `mos_users` ADD `activation` varchar(100) NOT NULL default '' AFTER `lastvisitDate`; | ||
| 70 : | ALTER TABLE `mos_users` ADD `params` TEXT NOT NULL; | ||
| 71 : | |||
| 72 : | ALTER TABLE `mos_weblinks` ADD `params` TEXT NOT NULL; | ||
| 73 : | |||
| 74 : | INSERT INTO `mos_modules` VALUES ('', 'Search', '', 7, 'right', 0, '0000-00-00 00:00:00', 1, 'mod_search', 0, 0, 1, '', 1, 0); | ||
| 75 : | 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); | ||
| 76 : | 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); | ||
| 77 : | 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); | ||
| 78 : | |||
| 79 : | DELETE FROM `mos_modules` WHERE `module` = 'mod_counter'; | ||
| 80 : | DELETE FROM `mos_modules` WHERE `module` = 'mod_online'; | ||
| 81 : | |||
| 82 : | DELETE FROM `mos_components` WHERE name='Media Manager'; | ||
| 83 : | DELETE FROM `mos_components` WHERE `option`='com_newsflash'; | ||
| 84 : | |||
| 85 : | INSERT INTO mos_modules VALUES (0,'Components','',1,'cpanel',0,'0000-00-00 00:00:00',1,'mod_components',0,99,1,'',2,1); | ||
| 86 : | INSERT INTO mos_modules VALUES (0,'Popular','',2,'cpanel',0,'0000-00-00 00:00:00',1,'mod_popular',0,99,1,'',2,1); | ||
| 87 : | 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); | ||
| 88 : | 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); | ||
| 89 : | 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); | ||
| 90 : | 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); | ||
| 91 : | 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); | ||
| 92 : | INSERT INTO mos_modules VALUES (0,'Pathway','',1,'pathway',0,'0000-00-00 00:00:00',1,'mod_pathway',0,99,1,'',2,1); | ||
| 93 : | INSERT INTO mos_modules VALUES (0,'Toolbar','',1,'toolbar',0,'0000-00-00 00:00:00',1,'mod_toolbar',0,99,1,'',2,1); | ||
| 94 : | 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); | ||
| 95 : | 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); | ||
| 96 : | |||
| 97 : | INSERT INTO `mos_templates_menu` VALUES ('rhuk_solarflare_ii', '0', '0'); | ||
| 98 : | INSERT INTO `mos_templates_menu` VALUES ('mambo_admin_blue', '0', '1'); | ||
| 99 : | |||
| 100 : | INSERT INTO `mos_template_positions` VALUES (0, 'left', 'Left Column'); | ||
| 101 : | INSERT INTO `mos_template_positions` VALUES (0, 'right', 'Right Column'); | ||
| 102 : | INSERT INTO `mos_template_positions` VALUES (0, 'top', ''); | ||
| 103 : | INSERT INTO `mos_template_positions` VALUES (0, 'bottom', ''); | ||
| 104 : | INSERT INTO `mos_template_positions` VALUES (0, 'inset', ''); | ||
| 105 : | INSERT INTO `mos_template_positions` VALUES (0, 'banner', ''); | ||
| 106 : | INSERT INTO `mos_template_positions` VALUES (0, 'header', ''); | ||
| 107 : | INSERT INTO `mos_template_positions` VALUES (0, 'footer', ''); | ||
| 108 : | INSERT INTO `mos_template_positions` VALUES (0, 'newsflash', ''); | ||
| 109 : | INSERT INTO `mos_template_positions` VALUES (0, 'legals', ''); | ||
| 110 : | INSERT INTO `mos_template_positions` VALUES (0, 'pathway', ''); | ||
| 111 : | INSERT INTO `mos_template_positions` VALUES (0, 'toolbar', ''); | ||
| 112 : | INSERT INTO `mos_template_positions` VALUES (0, 'cpanel', ''); | ||
| 113 : | INSERT INTO `mos_template_positions` VALUES (0, 'user1', ''); | ||
| 114 : | INSERT INTO `mos_template_positions` VALUES (0, 'user2', ''); | ||
| 115 : | INSERT INTO `mos_template_positions` VALUES (0, 'user3', ''); | ||
| 116 : | INSERT INTO `mos_template_positions` VALUES (0, 'user4', ''); | ||
| 117 : | INSERT INTO `mos_template_positions` VALUES (0, 'user5', ''); | ||
| 118 : | INSERT INTO `mos_template_positions` VALUES (0, 'user6', ''); | ||
| 119 : | INSERT INTO `mos_template_positions` VALUES (0, 'user7', ''); | ||
| 120 : | INSERT INTO `mos_template_positions` VALUES (0, 'user8', ''); | ||
| 121 : | INSERT INTO `mos_template_positions` VALUES (0, 'user9', ''); | ||
| 122 : | INSERT INTO `mos_template_positions` VALUES (0, 'advert1', ''); | ||
| 123 : | INSERT INTO `mos_template_positions` VALUES (0, 'advert2', ''); | ||
| 124 : | INSERT INTO `mos_template_positions` VALUES (0, 'advert3', ''); | ||
| 125 : | INSERT INTO `mos_template_positions` VALUES (0, 'icon', ''); | ||
| 126 : | INSERT INTO `mos_template_positions` VALUES (0, 'debug', ''); | ||
| 127 : | |||
| 128 : | UPDATE `mos_components` SET `link` = '', `admin_menu_link` = '' WHERE `id` = '6' LIMIT 1; | ||
| 129 : | INSERT INTO `mos_components` VALUES ('', 'Contact Categories', '', 0, 6, 'option=categories§ion=com_contact_details', 'Manage contact categories', '', 2, 'js/ThemeOffice/categories.png', 1, ''); | ||
| 130 : | 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, ''); | ||
| 131 : | INSERT INTO `mos_components` VALUES ('', 'Syndicate', '', 0, 0, 'option=com_syndicate', 'Manage Syndication Settings', 'com_syndicate', 0, 'js/ThemeOffice/component.png', 0, ''); | ||
| 132 : | |||
| 133 : | INSERT INTO mos_mambots VALUES (1,'MOS Image','mosimage','content',0,-10000,1,1,0,0,'0000-00-00 00:00:00',''); | ||
| 134 : | INSERT INTO mos_mambots VALUES (2,'MOS Pagination','mospaging','content',0,10000,1,1,0,0,'0000-00-00 00:00:00',''); | ||
| 135 : | INSERT INTO mos_mambots VALUES (3,'Legacy Mambot Includer','legacybots','content',0,1,1,1,0,0,'0000-00-00 00:00:00',''); | ||
| 136 : | INSERT INTO mos_mambots VALUES (4,'SEF','mossef','content',0,3,1,0,0,0,'0000-00-00 00:00:00',''); | ||
| 137 : | INSERT INTO mos_mambots VALUES (5,'MOS Rating','mosvote','content',0,4,1,1,0,0,'0000-00-00 00:00:00',''); | ||
| 138 : | INSERT INTO mos_mambots VALUES (6,'Search Content','content.searchbot','search',0,1,1,1,0,0,'0000-00-00 00:00:00',''); | ||
| 139 : | INSERT INTO mos_mambots VALUES (7,'Search Weblinks','weblinks.searchbot','search',0,2,1,1,0,0,'0000-00-00 00:00:00',''); | ||
| 140 : | INSERT INTO mos_mambots VALUES (8,'Code support','moscode','content',0,2,1,0,0,0,'0000-00-00 00:00:00',''); | ||
| 141 : | INSERT INTO mos_mambots VALUES (9,'No WYSIWYG Editor','none','editors',0,1,1,1,0,0,'0000-00-00 00:00:00',''); | ||
| 142 : | INSERT INTO mos_mambots VALUES (10,'TinyMCE WYSIWYG Editor','tinymce','editors',0,2,1,0,0,0,'0000-00-00 00:00:00',''); | ||
| 143 : | 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',''); | ||
| 144 : | 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',''); | ||
| 145 : | INSERT INTO mos_mambots VALUES (13,'Search Contacts','contacts.searchbot','search',0,3,1,1,0,0,'0000-00-00 00:00:00',''); |
| ViewVC Help | |
| Powered by ViewVC 1.0.0 |
Web Hosting provided by Network Redux.