SSDM-13578 : 2PT : Database and V3 Implementation - include the new AFS "free"...

SSDM-13578 : 2PT : Database and V3 Implementation - include the new AFS "free" method with js-tests and TypeScript support

server-application-server/source/sql/postgresql/migration/migration-195-196.sql

@@ -3,28 +3,28 @@
 
 
 ALTER TABLE IF EXISTS EXPERIMENT_TYPES
- ADD COLUMN IS_MANAGED_INTERNALLY BOOLEAN_CHAR NOT NULL DEFAULT 'F';
+ ADD COLUMN IF NOT EXISTS IS_MANAGED_INTERNALLY BOOLEAN_CHAR NOT NULL DEFAULT 'F';
 
 
 ALTER TABLE IF EXISTS MATERIAL_TYPES
- ADD COLUMN IS_MANAGED_INTERNALLY BOOLEAN_CHAR NOT NULL DEFAULT 'F';
+ ADD COLUMN IF NOT EXISTS IS_MANAGED_INTERNALLY BOOLEAN_CHAR NOT NULL DEFAULT 'F';
 
 ALTER TABLE IF EXISTS DATA_SET_TYPES
- ADD COLUMN IS_MANAGED_INTERNALLY BOOLEAN_CHAR NOT NULL DEFAULT 'F';
+ ADD COLUMN IF NOT EXISTS IS_MANAGED_INTERNALLY BOOLEAN_CHAR NOT NULL DEFAULT 'F';
 
 ALTER TABLE IF EXISTS SAMPLE_TYPES
- ADD COLUMN IS_MANAGED_INTERNALLY BOOLEAN_CHAR NOT NULL DEFAULT 'F';
+ ADD COLUMN IF NOT EXISTS IS_MANAGED_INTERNALLY BOOLEAN_CHAR NOT NULL DEFAULT 'F';
 
 
 ALTER TABLE IF EXISTS EXPERIMENT_TYPE_PROPERTY_TYPES
- ADD COLUMN IS_MANAGED_INTERNALLY_NAMESPACE BOOLEAN_CHAR NOT NULL DEFAULT 'F';
+ ADD COLUMN IF NOT EXISTS IS_MANAGED_INTERNALLY_NAMESPACE BOOLEAN_CHAR NOT NULL DEFAULT 'F';
 
 ALTER TABLE IF EXISTS EXPERIMENT_TYPE_PROPERTY_TYPES
-ADD COLUMN IS_MANAGED_INTERNALLY_NAMESPACE BOOLEAN_CHAR NOT NULL DEFAULT 'F';
+ADD COLUMN IF NOT EXISTS IS_MANAGED_INTERNALLY_NAMESPACE BOOLEAN_CHAR NOT NULL DEFAULT 'F';
 
 ALTER TABLE IF EXISTS EXPERIMENT_TYPE_PROPERTY_TYPES
-ADD COLUMN IS_MANAGED_INTERNALLY_NAMESPACE BOOLEAN_CHAR NOT NULL DEFAULT 'F';
+ADD COLUMN IF NOT EXISTS IS_MANAGED_INTERNALLY_NAMESPACE BOOLEAN_CHAR NOT NULL DEFAULT 'F';
 
 ALTER TABLE IF EXISTS EXPERIMENT_TYPE_PROPERTY_TYPES
-ADD COLUMN IS_MANAGED_INTERNALLY_NAMESPACE BOOLEAN_CHAR NOT NULL DEFAULT 'F';
+ADD COLUMN IF NOT EXISTS IS_MANAGED_INTERNALLY_NAMESPACE BOOLEAN_CHAR NOT NULL DEFAULT 'F';