From 9ecabe704c2bc05a3836cc713aa5bc75ee6480d7 Mon Sep 17 00:00:00 2001 From: Sweidan Omar Date: Thu, 24 Mar 2022 08:42:46 +0000 Subject: [PATCH] git-tfs-id: [http://tfs.userrendszerhaz.hu:8080/tfs/DefaultCollection]$/MediaCube;C33100 --- .../039_amc_prores_create_store_entry.sql | 17 +++++++++++++++++ 1 file changed, 17 insertions(+) create mode 100644 server/user.jobengine.osgi.db/migrations/scripts/039_amc_prores_create_store_entry.sql diff --git a/server/user.jobengine.osgi.db/migrations/scripts/039_amc_prores_create_store_entry.sql b/server/user.jobengine.osgi.db/migrations/scripts/039_amc_prores_create_store_entry.sql new file mode 100644 index 00000000..b8be77a8 --- /dev/null +++ b/server/user.jobengine.osgi.db/migrations/scripts/039_amc_prores_create_store_entry.sql @@ -0,0 +1,17 @@ +-- // Creates a store entry in STORE table +-- Migration SQL that makes the change goes here. + +INSERT INTO STORE(NAME,ISSYSTEM,ISLOWRES) VALUES +('AMC_LOCAL','N','N') +@ + +INSERT INTO STOREURI(STOREID,PROTOCOL,DELIVERY,URI,ISSTREAM,ISSOURCE,ISTARGET,USERNAME,PASSWORD,ROOTPATH,PORTNUMBER) VALUES +((SELECT ID FROM STORE WHERE NAME='AMC_LOCAL'),'LOCAL',null,'/mediacube/data','N','Y','Y',null,null,null,null) +@ + +-- //@UNDO +-- SQL to undo the change goes here. +DELETE FROM STOREURI WHERE STOREID=(SELECT ID FROM STORE WHERE NAME='AMC_LOCAL') +@ +DELETE FROM STORE WHERE NAME='AMC_LOCAL' +@ -- 2.54.0