install.sql 2.1 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364
  1. --
  2. -- Table structure for table `bx_data_migration_transfers`
  3. --
  4. CREATE TABLE `[db_prefix]transfers` (
  5. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  6. `module` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  7. `status` enum('not_started','started','finished','error') COLLATE utf8_unicode_ci NOT NULL,
  8. `status_text` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  9. PRIMARY KEY (`id`)
  10. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  11. --
  12. -- Table structure for table `bx_data_migration_config`
  13. --
  14. CREATE TABLE `[db_prefix]config` (
  15. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  16. `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  17. `value` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  18. PRIMARY KEY (`id`)
  19. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  20. --
  21. -- Admin menu ;
  22. --
  23. INSERT INTO
  24. `sys_menu_admin`
  25. SET
  26. `name` = 'Data migration',
  27. `title` = '_bx_data_migration',
  28. `url` = '{siteUrl}modules/?r=data_migration/administration/',
  29. `description` = 'Migration all data from previous Dolphin version',
  30. `icon` = 'modules/boonex/data_migration/|data_migration.gif',
  31. `parent_id` = 2;
  32. --
  33. -- Settings
  34. --
  35. INSERT INTO
  36. `sys_options`
  37. (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`, `AvailableValues`)
  38. VALUES
  39. ('bx_data_migration_permalinks', 'on', 26, 'Enable friendly permalinks in data migration module', 'checkbox', '', '', '0', '');
  40. INSERT INTO
  41. `sys_permalinks`
  42. SET
  43. `standard` = 'modules/?r=data_migration/',
  44. `permalink` = 'm/data_migration/',
  45. `check` = 'bx_data_migration_permalinks';
  46. --
  47. -- Dumping data for table `sys_cron_jobs`
  48. --
  49. INSERT INTO
  50. `sys_cron_jobs`
  51. (`name`, `time`, `class`, `file`)
  52. VALUES
  53. ('bx_data_migration', '*/5 * * * *', 'BxDataMigrationCron', 'modules/boonex/data_migration/classes/BxDataMigrationCron.php');