addon.sql 1003 B

1234567891011121314151617
  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` = '{admin_email}' WHERE `Name` = 'site_email_bug_report';
  10. UPDATE `sys_options` SET `VALUE` = '{site_desc}' WHERE `Name` = 'MetaDescription';
  11. UPDATE `sys_options` SET `VALUE` = '{version}' WHERE `Name` = 'sys_version';
  12. UPDATE `sys_options` SET `VALUE` = '{time}' WHERE `Name` = 'sys_install_time';