Revize 5dc387a8

#10520 - vytvořen db.app_metadata_createTable.sql skript na založení tabulky a vložení základních dat

db/db.app_metadata_createTable.sql

@@ +1 @@
+if not exists (select * from sysobjects where name='app_metadata' and xtype='U')
+
+    create table app_metadata (
+        id int identity(1, 1),
+        appDataKey nvarchar(255),
+        appDataValue nvarchar(max)
+    )
+
+    go
+
+insert into app_metadata (appDataKey, appDataValue)
+    values
+        ('basics', N'[
+          {
+            "version": "1.0.0",
+            "authors": [
+              {
+                "name": "Ondřej Váně",
+                "email": "[e-mail]"
+              }
+            ],
+            "description": "This application is used to detect presence of anti-patterns in project management tools data. Seven selected anti-patterns are implemented in this application."
+          },
+          {
+            "version": "1.1.0",
+            "authors": [
+              {
+                "name": "Ondřej Váně",
+                "email": "[e-mail]"
+              }
+            ],
+            "description": "This application is used to detect presence of anti-patterns in project management tools data. Seven selected anti-patterns are implemented in this application."
+          },
+          {
+            "version": "1.2.0",
+            "authors": [
+              {
+                "name": "Petr Štěpánek",
+                "email": "[e-mail]"
+              }
+            ],
+            "description": "This application is used to detect presence of anti-patterns in project management tools data. Ten selected anti-patterns are implemented in this application."
+          },
+          {
+            "version": "2.0.0",
+            "authors": [
+              {
+                "name": "Petr Štěpánek",
+                "email": "[e-mail]"
+              },
+              {
+                "name": "Petr Urban",
+                "email": "[e-mail]"
+              },
+              {
+                "name": "Jiří Trefil",
+                "email": "[e-mail]"
+              },
+              {
+                "name": "Václav Hrabík",
+                "email": "[e-mail]"
+              }
+            ],
+            "description": "TODO"
+          }
+        ]')
+