The ASP.NET Core blog system of https://edi.wang, runs on Microsoft Azure
ALTER TABLE Post DROP COLUMN ExposedToSiteMap
ALTER TABLE Post DROP COLUMN ExposedToSiteMap
ALTER TABLE Post DROP COLUMN ExposedToSiteMap
/ping
endpointIF NOT EXISTS(SELECT TOP 1 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = N'BlogTheme')
CREATE TABLE [BlogTheme](
[Id] [int] PRIMARY KEY CLUSTERED NOT NULL IDENTITY(1,1),
[ThemeName] [varchar](32) NULL,
[CssRules] [nvarchar](max) NULL,
[AdditionalProps] [nvarchar](max) NULL,
[ThemeType] [int] NOT NULL)
GO
INSERT INTO BlogTheme (ThemeName, CssRules, ThemeType)
VALUES ('Word Blue', '{"--accent-color1": "#2a579a","--accent-color2": "#1a365f","--accent-color3": "#3e6db5"}', 0)
INSERT INTO BlogTheme (ThemeName, CssRules, ThemeType)
VALUES ('Excel Green', '{"--accent-color1": "#165331","--accent-color2": "#0E351F","--accent-color3": "#0E703A"}', 0)
INSERT INTO BlogTheme (ThemeName, CssRules, ThemeType)
VALUES ('PowerPoint Orange', '{"--accent-color1": "#983B22","--accent-color2": "#622616","--accent-color3": "#C43E1C"}', 0)
INSERT INTO BlogTheme (ThemeName, CssRules, ThemeType)
VALUES ('OneNote Purple', '{"--accent-color1": "#663276","--accent-color2": "#52285E","--accent-color3": "#7719AA"}', 0)
INSERT INTO BlogTheme (ThemeName, CssRules, ThemeType)
VALUES ('Outlook Blue', '{"--accent-color1": "#035AA6","--accent-color2": "#032B51","--accent-color3": "#006CBF"}', 0)
INSERT INTO BlogTheme (ThemeName, CssRules, ThemeType)
VALUES ('China Red', '{"--accent-color1": "#800900","--accent-color2": "#5d120d","--accent-color3": "#c5170a"}', 0)
INSERT INTO BlogTheme (ThemeName, CssRules, ThemeType)
VALUES ('Indian Curry', '{"--accent-color1": "rgb(128 84 3)","--accent-color2": "rgb(95 62 0)","--accent-color3": "rgb(208 142 19)"}', 0)
INSERT INTO BlogTheme (ThemeName, CssRules, ThemeType)
VALUES ('Metal Blue', '{"--accent-color1": "#4E5967","--accent-color2": "#333942","--accent-color3": "#6e7c8e"}', 0)
GO
UPDATE BlogConfiguration SET CfgKey = 'ImageSettings' WHERE CfgKey = 'WatermarkSettings'
GO
Manually set "Image" settings from admin portal again.
AppSettings:Pride
to show a pride mouse cursor and a flag. #561FeatureManagement:Widgets_FriendLink
ALTER TABLE Post ADD [Author] [nvarchar](64) NULL
ALTER TABLE Post ADD HeroImageUrl NVARCHAR(256) NULL
ALTER TABLE Post ADD IsOriginal BIT
ALTER TABLE Post ADD OriginLink nvarchar(256) NULL
UPDATE Post SET IsOriginal = 1
GO
ALTER TABLE Post ALTER COLUMN IsOriginal BIT NOT NULL
GO