addon.sql 826 B

123456789101112131415
  1. INSERT INTO `sys_accounts` (`name`, `email`, `email_confirmed`, `receive_updates`, `receive_news`, `password`, `salt`, `role`, `added`) VALUES
  2. ('{admin_username}', '{admin_email}', 1, 1, 1, '{admin_pwd_hash}', '{admin_pwd_salt}', 3, '{current_timestamp}');
  3. SET @iAccountId = LAST_INSERT_ID();
  4. INSERT INTO `sys_profiles` (`account_id`, `type`, `content_id`, `status`) VALUES
  5. (@iAccountId, 'system', @iAccountId, 'active');
  6. UPDATE `sys_options` SET `VALUE` = '{admin_email}' WHERE `Name` = 'site_email';
  7. UPDATE `sys_options` SET `VALUE` = '{site_title}' WHERE `Name` = 'site_title';
  8. UPDATE `sys_options` SET `VALUE` = '{site_email}' WHERE `Name` = 'site_email_notify';
  9. UPDATE `sys_options` SET `VALUE` = '{time}' WHERE `Name` = 'sys_install_time';
  10. UPDATE `sys_modules` SET `version` = '{version}' WHERE `name` = 'system';