Guest User

Untitled

a guest
Dec 30th, 2014
223
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Plugin Manager database versioning: Plugin "plugin_manager"
  2.  
  3. Plugin Manager has detected required missing adjustments in your database. The following commands will be executed against your database mysql://***masked***:
  4.  
  5. CREATE TABLE IF NOT EXISTS `rc_plugin_manager` (
  6. `id` int(10) NOT NULL AUTO_INCREMENT,
  7. `user_id` int(10) unsigned NOT NULL,
  8. `conf` text NOT NULL,
  9. `value` text,
  10. `type` text,
  11. PRIMARY KEY (`id`),
  12. KEY `user_id` (`user_id`),
  13. KEY `user_id_index` (`user_id`)
  14. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
  15.  
  16. CREATE TABLE IF NOT EXISTS `rc_system` (
  17. `name` varchar(64) NOT NULL,
  18. `value` mediumtext,
  19. PRIMARY KEY(`name`)
  20. );
  21.  
  22. INSERT INTO `rc_system` (name, value) VALUES ('myrc_plugin_manager', 'initial');
  23.  
  24. ALTER TABLE `rc_plugin_manager`
  25. ADD CONSTRAINT `user_id_fk_plugin_manager` FOREIGN KEY (`user_id`) REFERENCES `rc_users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE;
  26. ALTER TABLE `rc_plugin_manager` DROP FOREIGN KEY `user_id_fk_plugin_manager` ;
  27. ALTER TABLE `rc_plugin_manager` DROP `user_id`;
  28. ALTER TABLE `rc_plugin_manager` ENGINE=MyISAM;
  29. UPDATE `rc_system` SET `value`='initial|20131209' WHERE `name`='myrc_plugin_manager';
RAW Paste Data