-
Notifications
You must be signed in to change notification settings - Fork 32
/
seed.sql
44 lines (35 loc) · 6.78 KB
/
seed.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
SET QUOTED_IDENTIFIER ON;
use Directory;
delete from UserEmails;
delete from AspNetUsers;
insert into AspNetUsers(AccessFailedCount,LockoutEnabled,TwoFactorEnabled,UserName,NormalizedUserName,PasswordHash,SecurityStamp,ConcurrencyStamp,AccountCreateTime,Id,NickName,PreferedLanguage,Email,IconFilePath)
VALUES(0,1,0,'admin@{{domain}}','ADMIN@{{domainUpper}}','AQAAAAEAACcQAAAAEHswFfciW8m5p2De3KzBd7ha0OX04Dav4jRy3CL/M/L54nWtMOGLwDZF1qo211KVRg==','3BO4UKYBY2GJVGNTBM756HO6NQLUAKGQ','89f42d2b-1af9-416a-8953-5abb02b523a1','2020-01-01 12:34:56','{{userId}}','Admin','en-US','admin@{{domain}}','usericon/default.png');
insert into UserEmails(EmailAddress,OwnerId,Priority,Validated,LastSendTime)
VALUES('admin@{{domain}}','{{userId}}',1,1,'2020-01-01 12:34:56')
use Developer;
delete from AspNetUsers;
delete from Apps;
insert into AspNetUsers(AccessFailedCount,LockoutEnabled,TwoFactorEnabled,UserName,NormalizedUserName,PasswordHash,SecurityStamp,ConcurrencyStamp,AccountCreateTime,Id,NickName,PreferedLanguage,Email,EmailConfirmed,IconFilePath)
VALUES(0,1,0,'admin@{{domain}}','ADMIN@{{domainUpper}}','AQAAAAEAACcQAAAAEHswFfciW8m5p2De3KzBd7ha0OX04Dav4jRy3CL/M/L54nWtMOGLwDZF1qo211KVRg==','3BO4UKYBY2GJVGNTBM756HO6NQLUAKGQ','89f42d2b-1af9-416a-8953-5abb02b523a1','2020-01-01 12:34:56','{{userId}}','Admin','en-US','admin@{{domain}}',1,'usericon/default.png');
insert into Apps(AppId,AppSecret,AppName,AppCreateTime,IconPath,AppDescription,AppCategory,AppPlatform,EnableOAuth,ForceConfirmation,ForceInputPassword,DebugMode,[AppDomain],ViewOpenId,CreatorId,ViewPhoneNumber,ChangePhoneNumber,ConfirmEmail,ChangeBasicInfo,ChangePassword,TrustedApp)
values('{{developerAppId}}','{{developerAppSecret}}','{{Instance}} Developer Center','2020-01-01 12:34:56','aiursoft-app-icons/appdefaulticon.png','Aiursoft Developer Center',0,7,1,0,0,0,'developer.{{domain}}',1,'{{userId}}',0,0,0,0,0,1);
insert into Apps(AppId,AppSecret,AppName,AppCreateTime,IconPath,AppDescription,AppCategory,AppPlatform,EnableOAuth,ForceConfirmation,ForceInputPassword,DebugMode,[AppDomain],ViewOpenId,CreatorId,ViewPhoneNumber,ChangePhoneNumber,ConfirmEmail,ChangeBasicInfo,ChangePassword,TrustedApp)
values('{{directoryAppId}}','{{directoryAppSecret}}','{{Instance}} Directory','2020-01-01 12:34:56','aiursoft-app-icons/appdefaulticon.png','Aiursoft Directory',0,7,1,0,0,0,'directory.{{domain}}',1,'{{userId}}',0,0,0,0,0,1);
insert into Apps(AppId,AppSecret,AppName,AppCreateTime,IconPath,AppDescription,AppCategory,AppPlatform,EnableOAuth,ForceConfirmation,ForceInputPassword,DebugMode,[AppDomain],ViewOpenId,CreatorId,ViewPhoneNumber,ChangePhoneNumber,ConfirmEmail,ChangeBasicInfo,ChangePassword,TrustedApp)
values('{{stargateAppId}}','{{stargateAppSecret}}','{{Instance}} Stargate','2020-01-01 12:34:56','aiursoft-app-icons/appdefaulticon.png','Aiursoft Stargate',0,7,1,0,0,0,'stargate.{{domain}}',1,'{{userId}}',0,0,0,0,0,1);
insert into Apps(AppId,AppSecret,AppName,AppCreateTime,IconPath,AppDescription,AppCategory,AppPlatform,EnableOAuth,ForceConfirmation,ForceInputPassword,DebugMode,[AppDomain],ViewOpenId,CreatorId,ViewPhoneNumber,ChangePhoneNumber,ConfirmEmail,ChangeBasicInfo,ChangePassword,TrustedApp)
values('{{observerAppId}}','{{observerAppSecret}}','{{Instance}} Observer','2020-01-01 12:34:56','aiursoft-app-icons/appdefaulticon.png','Aiursoft Observer',0,7,1,0,0,0,'observer.{{domain}}',1,'{{userId}}',0,0,0,0,0,1);
insert into Apps(AppId,AppSecret,AppName,AppCreateTime,IconPath,AppDescription,AppCategory,AppPlatform,EnableOAuth,ForceConfirmation,ForceInputPassword,DebugMode,[AppDomain],ViewOpenId,CreatorId,ViewPhoneNumber,ChangePhoneNumber,ConfirmEmail,ChangeBasicInfo,ChangePassword,TrustedApp)
values('{{probeAppId}}','{{probeAppSecret}}','{{Instance}} Probe','2020-01-01 12:34:56','aiursoft-app-icons/appdefaulticon.png','Aiursoft Probe',0,7,1,0,0,0,'probe.{{domain}}',1,'{{userId}}',0,0,0,0,0,1);
insert into Apps(AppId,AppSecret,AppName,AppCreateTime,IconPath,AppDescription,AppCategory,AppPlatform,EnableOAuth,ForceConfirmation,ForceInputPassword,DebugMode,[AppDomain],ViewOpenId,CreatorId,ViewPhoneNumber,ChangePhoneNumber,ConfirmEmail,ChangeBasicInfo,ChangePassword,TrustedApp)
values('{{warpgateAppId}}','{{warpgateAppSecret}}','{{Instance}} Warpgate','2020-01-01 12:34:56','aiursoft-app-icons/appdefaulticon.png','Aiursoft Warpgate',0,7,1,0,0,0,'warpgate.{{domain}}',1,'{{userId}}',0,0,0,0,0,1);
insert into Apps(AppId,AppSecret,AppName,AppCreateTime,IconPath,AppDescription,AppCategory,AppPlatform,EnableOAuth,ForceConfirmation,ForceInputPassword,DebugMode,[AppDomain],ViewOpenId,CreatorId,ViewPhoneNumber,ChangePhoneNumber,ConfirmEmail,ChangeBasicInfo,ChangePassword,TrustedApp)
values('{{wwwAppId}}','{{wwwAppSecret}}','{{Instance}} Home','2020-01-01 12:34:56','aiursoft-app-icons/appdefaulticon.png','Aiursoft Home',0,7,1,0,0,0,'www.{{domain}}',1,'{{userId}}',0,0,0,0,0,1);
insert into Apps(AppId,AppSecret,AppName,AppCreateTime,IconPath,AppDescription,AppCategory,AppPlatform,EnableOAuth,ForceConfirmation,ForceInputPassword,DebugMode,[AppDomain],ViewOpenId,CreatorId,ViewPhoneNumber,ChangePhoneNumber,ConfirmEmail,ChangeBasicInfo,ChangePassword,TrustedApp)
values('{{wikiAppId}}','{{wikiAppSecret}}','{{Instance}} Wiki Center','2020-01-01 12:34:56','aiursoft-app-icons/appdefaulticon.png','Aiursoft Wiki Center',0,7,1,0,0,0,'wiki.{{domain}}',1,'{{userId}}',0,0,0,0,0,1);
insert into Apps(AppId,AppSecret,AppName,AppCreateTime,IconPath,AppDescription,AppCategory,AppPlatform,EnableOAuth,ForceConfirmation,ForceInputPassword,DebugMode,[AppDomain],ViewOpenId,CreatorId,ViewPhoneNumber,ChangePhoneNumber,ConfirmEmail,ChangeBasicInfo,ChangePassword,ViewAuditLog,ManageSocialAccount,ChangeGrantInfo,TrustedApp)
values('{{accountAppId}}','{{accountAppSecret}}','{{Instance}} Account Center','2020-01-01 12:34:56','aiursoft-app-icons/appdefaulticon.png','Aiursoft Account Center',0,7,1,0,0,0,'account.{{domain}}',1,'{{userId}}',1,1,1,1,1,1,1,1,1);
insert into Apps(AppId,AppSecret,AppName,AppCreateTime,IconPath,AppDescription,AppCategory,AppPlatform,EnableOAuth,ForceConfirmation,ForceInputPassword,DebugMode,[AppDomain],ViewOpenId,CreatorId,ViewPhoneNumber,ChangePhoneNumber,ConfirmEmail,ChangeBasicInfo,ChangePassword,TrustedApp)
values('{{statusAppId}}','{{statusAppSecret}}','{{Instance}} Status Center','2020-01-01 12:34:56','aiursoft-app-icons/appdefaulticon.png','Aiursoft Status Center',0,7,1,0,0,0,'status.{{domain}}',1,'{{userId}}',0,0,0,0,0,1);
insert into Apps(AppId,AppSecret,AppName,AppCreateTime,IconPath,AppDescription,AppCategory,AppPlatform,EnableOAuth,ForceConfirmation,ForceInputPassword,DebugMode,[AppDomain],ViewOpenId,CreatorId,ViewPhoneNumber,ChangePhoneNumber,ConfirmEmail,ChangeBasicInfo,ChangePassword,TrustedApp)
values('{{eeAppId}}','{{eeAppSecret}}','{{Instance}} EE','2020-01-01 12:34:56','aiursoft-app-icons/appdefaulticon.png','Aiursoft EE',0,7,1,0,0,0,'ee.{{domain}}',1,'{{userId}}',0,0,0,0,0,1);