tcmorris

name: Build and deploy to Azure

on: [push]

env:
  PROJECT_DIR: yourapp/path
  AZURE_WEBAPP_NAME: yourapp-name  
  DOTNET_VERSION: '2.2.402'

jobs:

tcmorris

name: Build node.js

on: [push]

env:
  NODE_VERSION: '10.x'               

jobs:
  build-assets:
    runs-on: ubuntu-latest

tcmorris

SELECT cv.id
INTO #toDelete
FROM umbracoDocumentVersion dv
INNER JOIN umbracoContentVersion cv ON dv.id = cv.id
WHERE cv.[current] != 1 AND dv.published != 1 AND cv.VersionDate < '2021-01-01'

DELETE FROM umbracoPropertyData WHERE versionId IN (select id from #toDelete)
DELETE FROM umbracoDocumentVersion WHERE id IN (select id from #toDelete)
DELETE FROM umbracoContentVersionCultureVariation WHERE versionId IN (select id from #toDelete)
DELETE FROM umbracoContentVersion WHERE id IN (select id from #toDelete)