diff options
author | Bob Arnson <bob@firegiant.com> | 2021-09-19 22:29:32 -0400 |
---|---|---|
committer | Bob Arnson <bob@firegiant.com> | 2021-09-19 22:58:34 -0400 |
commit | 3a4dffe9feb62ea383e767ba903ff1edc8234f0e (patch) | |
tree | c5a0d63cff6ee880db0ef93b622791c572a835aa /src/ext/Iis/ca/scasched.cpp | |
parent | befda7bad8a90f43d7f9ca419e91f79613e0effb (diff) | |
download | wix-3a4dffe9feb62ea383e767ba903ff1edc8234f0e.tar.gz wix-3a4dffe9feb62ea383e767ba903ff1edc8234f0e.tar.bz2 wix-3a4dffe9feb62ea383e767ba903ff1edc8234f0e.zip |
Table ids per https://github.com/wixtoolset/issues/issues/5933.
Diffstat (limited to 'src/ext/Iis/ca/scasched.cpp')
-rw-r--r-- | src/ext/Iis/ca/scasched.cpp | 34 |
1 files changed, 17 insertions, 17 deletions
diff --git a/src/ext/Iis/ca/scasched.cpp b/src/ext/Iis/ca/scasched.cpp index de021275..14fa97ac 100644 --- a/src/ext/Iis/ca/scasched.cpp +++ b/src/ext/Iis/ca/scasched.cpp | |||
@@ -7,58 +7,58 @@ const int WriteMetabaseChangesCost = 20; | |||
7 | const int WriteIIS7ConfigChangesCost = 20; | 7 | const int WriteIIS7ConfigChangesCost = 20; |
8 | 8 | ||
9 | // sql queries | 9 | // sql queries |
10 | LPCWSTR vcsUserDeferredQuery = L"SELECT `User`, `Component_`, `Name`, `Domain`, `Password` FROM `User`"; | 10 | LPCWSTR vcsUserDeferredQuery = L"SELECT `User`, `Component_`, `Name`, `Domain`, `Password` FROM `Wix4User`"; |
11 | 11 | ||
12 | LPCWSTR vcsWebSvcExtQuery = L"SELECT `Component_`, `File`, `Description`, `Group`, `Attributes` FROM `IIsWebServiceExtension`"; | 12 | LPCWSTR vcsWebSvcExtQuery = L"SELECT `Component_`, `File`, `Description`, `Group`, `Attributes` FROM `Wix4IIsWebServiceExtension`"; |
13 | 13 | ||
14 | LPCWSTR vcsAppPoolQuery = L"SELECT `AppPool`, `Name`, `Component_`, `Attributes`, `User_`, `RecycleMinutes`, `RecycleRequests`, `RecycleTimes`, `VirtualMemory`, `PrivateMemory`, `IdleTimeout`, `QueueLimit`, `CPUMon`, `MaxProc`, `ManagedRuntimeVersion`, `ManagedPipelineMode` FROM `IIsAppPool`"; | 14 | LPCWSTR vcsAppPoolQuery = L"SELECT `AppPool`, `Name`, `Component_`, `Attributes`, `User_`, `RecycleMinutes`, `RecycleRequests`, `RecycleTimes`, `VirtualMemory`, `PrivateMemory`, `IdleTimeout`, `QueueLimit`, `CPUMon`, `MaxProc`, `ManagedRuntimeVersion`, `ManagedPipelineMode` FROM `Wix4IIsAppPool`"; |
15 | 15 | ||
16 | LPCWSTR vcsComponentAttrQuery = L"SELECT `Component`,`Attributes` FROM `Component`"; | 16 | LPCWSTR vcsComponentAttrQuery = L"SELECT `Component`,`Attributes` FROM `Component`"; |
17 | 17 | ||
18 | LPCWSTR vcsMimeMapQuery = L"SELECT `MimeMap`, `ParentType`, `ParentValue`, `MimeType`, `Extension` FROM `IIsMimeMap`"; | 18 | LPCWSTR vcsMimeMapQuery = L"SELECT `MimeMap`, `ParentType`, `ParentValue`, `MimeType`, `Extension` FROM `Wix4IIsMimeMap`"; |
19 | 19 | ||
20 | LPCWSTR vcsHttpHeaderQuery = L"SELECT `Name`, `ParentType`, `ParentValue`, `Value`, `Attributes` FROM `IIsHttpHeader` ORDER BY `Sequence`"; | 20 | LPCWSTR vcsHttpHeaderQuery = L"SELECT `Name`, `ParentType`, `ParentValue`, `Value`, `Attributes` FROM `Wix4IIsHttpHeader` ORDER BY `Sequence`"; |
21 | 21 | ||
22 | LPCWSTR vcsWebErrorQuery = | 22 | LPCWSTR vcsWebErrorQuery = |
23 | L"SELECT `ErrorCode`, `SubCode`, `ParentType`, `ParentValue`, `File`, `URL` " | 23 | L"SELECT `ErrorCode`, `SubCode`, `ParentType`, `ParentValue`, `File`, `URL` " |
24 | L"FROM `IIsWebError` ORDER BY `ErrorCode`, `SubCode`"; | 24 | L"FROM `Wix4IIsWebError` ORDER BY `ErrorCode`, `SubCode`"; |
25 | 25 | ||
26 | LPCWSTR vcsWebDirPropertiesQuery = L"SELECT `DirProperties`, `Access`, `Authorization`, `AnonymousUser_`, `IIsControlledPassword`, `LogVisits`, `Index`, `DefaultDoc`, `AspDetailedError`, `HttpExpires`, `CacheControlMaxAge`, `CacheControlCustom`, `NoCustomError`, `AccessSSLFlags`, `AuthenticationProviders` " | 26 | LPCWSTR vcsWebDirPropertiesQuery = L"SELECT `DirProperties`, `Access`, `Authorization`, `AnonymousUser_`, `IIsControlledPassword`, `LogVisits`, `Index`, `DefaultDoc`, `AspDetailedError`, `HttpExpires`, `CacheControlMaxAge`, `CacheControlCustom`, `NoCustomError`, `AccessSSLFlags`, `AuthenticationProviders` " |
27 | L"FROM `IIsWebDirProperties`"; | 27 | L"FROM `Wix4IIsWebDirProperties`"; |
28 | 28 | ||
29 | LPCWSTR vcsSslCertificateQuery = L"SELECT `Certificate`.`StoreName`, `CertificateHash`.`Hash`, `IIsWebSiteCertificates`.`Web_` FROM `Certificate`, `CertificateHash`, `IIsWebSiteCertificates` WHERE `Certificate`.`Certificate`=`CertificateHash`.`Certificate_` AND `CertificateHash`.`Certificate_`=`IIsWebSiteCertificates`.`Certificate_`"; | 29 | LPCWSTR vcsSslCertificateQuery = L"SELECT `Wix4Certificate`.`StoreName`, `Wix4CertificateHash`.`Hash`, `Wix4IIsWebSiteCertificates`.`Web_` FROM `Wix4Certificate`, `Wix4CertificateHash`, `Wix4IIsWebSiteCertificates` WHERE `Wix4Certificate`.`Certificate`=`Wix4CertificateHash`.`Certificate_` AND `Wix4CertificateHash`.`Certificate_`=`Wix4IIsWebSiteCertificates`.`Certificate_`"; |
30 | 30 | ||
31 | LPCWSTR vcsWebLogQuery = L"SELECT `Log`, `Format` " | 31 | LPCWSTR vcsWebLogQuery = L"SELECT `Log`, `Format` " |
32 | L"FROM `IIsWebLog`"; | 32 | L"FROM `Wix4IIsWebLog`"; |
33 | 33 | ||
34 | LPCWSTR vcsWebApplicationQuery = L"SELECT `Name`, `Isolation`, `AllowSessions`, `SessionTimeout`, " | 34 | LPCWSTR vcsWebApplicationQuery = L"SELECT `Name`, `Isolation`, `AllowSessions`, `SessionTimeout`, " |
35 | L"`Buffer`, `ParentPaths`, `DefaultScript`, `ScriptTimeout`, " | 35 | L"`Buffer`, `ParentPaths`, `DefaultScript`, `ScriptTimeout`, " |
36 | L"`ServerDebugging`, `ClientDebugging`, `AppPool_`, `Application` " | 36 | L"`ServerDebugging`, `ClientDebugging`, `AppPool_`, `Application` " |
37 | L"FROM `IIsWebApplication`"; | 37 | L"FROM `Wix4IIsWebApplication`"; |
38 | 38 | ||
39 | LPCWSTR vcsWebAppExtensionQuery = L"SELECT `Extension`, `Verbs`, `Executable`, `Attributes`, `Application_` FROM `IIsWebApplicationExtension`"; | 39 | LPCWSTR vcsWebAppExtensionQuery = L"SELECT `Extension`, `Verbs`, `Executable`, `Attributes`, `Application_` FROM `Wix4IIsWebApplicationExtension`"; |
40 | 40 | ||
41 | LPCWSTR vcsWebQuery = L"SELECT `Web`, `Component_`, `Id`, `Description`, `ConnectionTimeout`, `Directory_`, `State`, `Attributes`, `DirProperties_`, `Application_`, " | 41 | LPCWSTR vcsWebQuery = L"SELECT `Web`, `Component_`, `Id`, `Description`, `ConnectionTimeout`, `Directory_`, `State`, `Attributes`, `DirProperties_`, `Application_`, " |
42 | L"`Address`, `IP`, `Port`, `Header`, `Secure`, `Log_` FROM `IIsWebSite`, `IIsWebAddress` " | 42 | L"`Address`, `IP`, `Port`, `Header`, `Secure`, `Log_` FROM `Wix4IIsWebSite`, `Wix4IIsWebAddress` " |
43 | L"WHERE `KeyAddress_`=`Address` ORDER BY `Sequence`"; | 43 | L"WHERE `KeyAddress_`=`Address` ORDER BY `Sequence`"; |
44 | 44 | ||
45 | LPCWSTR vcsWebAddressQuery = L"SELECT `Address`, `Web_`, `IP`, `Port`, `Header`, `Secure` " | 45 | LPCWSTR vcsWebAddressQuery = L"SELECT `Address`, `Web_`, `IP`, `Port`, `Header`, `Secure` " |
46 | L"FROM `IIsWebAddress`"; | 46 | L"FROM `Wix4IIsWebAddress`"; |
47 | 47 | ||
48 | LPCWSTR vcsWebBaseQuery = L"SELECT `Web`, `Id`, `IP`, `Port`, `Header`, `Secure`, `Description` " | 48 | LPCWSTR vcsWebBaseQuery = L"SELECT `Web`, `Id`, `IP`, `Port`, `Header`, `Secure`, `Description` " |
49 | L"FROM `IIsWebSite`, `IIsWebAddress` " | 49 | L"FROM `Wix4IIsWebSite`, `Wix4IIsWebAddress` " |
50 | L"WHERE `KeyAddress_`=`Address`"; | 50 | L"WHERE `KeyAddress_`=`Address`"; |
51 | 51 | ||
52 | LPCWSTR vcsWebDirQuery = L"SELECT `Web_`, `WebDir`, `Component_`, `Path`, `DirProperties_`, `Application_` " | 52 | LPCWSTR vcsWebDirQuery = L"SELECT `Web_`, `WebDir`, `Component_`, `Path`, `DirProperties_`, `Application_` " |
53 | L"FROM `IIsWebDir`"; | 53 | L"FROM `Wix4IIsWebDir`"; |
54 | 54 | ||
55 | LPCWSTR vcsVDirQuery = L"SELECT `Web_`, `VirtualDir`, `Component_`, `Alias`, `Directory_`, `DirProperties_`, `Application_` " | 55 | LPCWSTR vcsVDirQuery = L"SELECT `Web_`, `VirtualDir`, `Component_`, `Alias`, `Directory_`, `DirProperties_`, `Application_` " |
56 | L"FROM `IIsWebVirtualDir`"; | 56 | L"FROM `IIsWebVirtualDir`"; |
57 | 57 | ||
58 | LPCWSTR vcsFilterQuery = L"SELECT `Web_`, `Name`, `Component_`, `Path`, `Description`, `Flags`, `LoadOrder` FROM `IIsFilter` ORDER BY `Web_`"; | 58 | LPCWSTR vcsFilterQuery = L"SELECT `Web_`, `Name`, `Component_`, `Path`, `Description`, `Flags`, `LoadOrder` FROM `Wix4IIsFilter` ORDER BY `Web_`"; |
59 | 59 | ||
60 | LPCWSTR vcsPropertyQuery = L"SELECT `Property`, `Component_`, `Attributes`, `Value` " | 60 | LPCWSTR vcsPropertyQuery = L"SELECT `Property`, `Component_`, `Attributes`, `Value` " |
61 | L"FROM `IIsProperty`"; | 61 | L"FROM `Wix4IIsProperty`"; |
62 | 62 | ||
63 | #define IIS7CONDITION L"VersionNT >= 600" | 63 | #define IIS7CONDITION L"VersionNT >= 600" |
64 | #define USEIIS7CONDITION IIS7CONDITION L"AND NOT UseIis6Compatibility" | 64 | #define USEIIS7CONDITION IIS7CONDITION L"AND NOT UseIis6Compatibility" |