V202410101051__v2.8x_ResourceSharing_CodeGenMetadata.sql

/* SQL generated to create new entity Resource Permissions */
INSERT INTO [${flyway:defaultSchema}].Entity (
   ID, 
   Name, 
   Description,
   NameSuffix,
   BaseTable, 
   BaseView, 
   SchemaName, 
   IncludeInAPI, 
   AllowUserSearchAPI
   , TrackRecordChanges
   , AuditRecordAccess
   , AuditViewRuns
   , AllowAllRowsAPI
   , AllowCreateAPI
   , AllowUpdateAPI
   , AllowDeleteAPI
   , UserViewMaxRows
) 
VALUES (
   '201852E1-4587-EF11-8473-6045BDF077EE', -- hardcoded for the migration script to the entity id generated by the original CodeGen run in dev setting
   'Resource Permissions', 
   NULL,
   NULL,
   'ResourcePermission', 
   'vwResourcePermissions', 
   '${flyway:defaultSchema}',
   1, 
   0
   , 1
   , 0
   , 0
   , 0
   , 1
   , 1
   , 1
   , 1000
)
 

/* SQL generated to add new entity Resource Permissions to application Admin */
INSERT INTO [${flyway:defaultSchema}].ApplicationEntity 
                                                            (ApplicationID, EntityID, Sequence) VALUES 
                                                            ('EBA5CCEC-6A37-EF11-86D4-000D3A4E707E', '201852E1-4587-EF11-8473-6045BDF077EE', (SELECT ISNULL(MAX(Sequence),0)+1 FROM [${flyway:defaultSchema}].ApplicationEntity WHERE ApplicationID = 'EBA5CCEC-6A37-EF11-86D4-000D3A4E707E'))

/* SQL generated to add new permission for entity Resource Permissions for role UI */
INSERT INTO [${flyway:defaultSchema}].EntityPermission 
                                                   (EntityID, RoleID, CanRead, CanCreate, CanUpdate, CanDelete) VALUES 
                                                   ('201852E1-4587-EF11-8473-6045BDF077EE', 'E0AFCCEC-6A37-EF11-86D4-000D3A4E707E', 1, 0, 0, 0)

/* SQL generated to add new permission for entity Resource Permissions for role Developer */
INSERT INTO [${flyway:defaultSchema}].EntityPermission 
                                                   (EntityID, RoleID, CanRead, CanCreate, CanUpdate, CanDelete) VALUES 
                                                   ('201852E1-4587-EF11-8473-6045BDF077EE', 'DEAFCCEC-6A37-EF11-86D4-000D3A4E707E', 1, 1, 1, 0)

/* SQL generated to add new permission for entity Resource Permissions for role Integration */
INSERT INTO [${flyway:defaultSchema}].EntityPermission 
                                                   (EntityID, RoleID, CanRead, CanCreate, CanUpdate, CanDelete) VALUES 
                                                   ('201852E1-4587-EF11-8473-6045BDF077EE', 'DFAFCCEC-6A37-EF11-86D4-000D3A4E707E', 1, 1, 1, 1)

/* SQL text to update existing entities from schema */
EXEC [${flyway:defaultSchema}].spUpdateExistingEntitiesFromSchema @ExcludedSchemaNames='sys,staging'

/* SQL text to add special date field __mj_CreatedAt to entity [${flyway:defaultSchema}].ResourcePermission */
ALTER TABLE [${flyway:defaultSchema}].[ResourcePermission] ADD __mj_CreatedAt DATETIMEOFFSET NOT NULL DEFAULT GETUTCDATE()

/* SQL text to add special date field __mj_UpdatedAt to entity [${flyway:defaultSchema}].ResourcePermission */
ALTER TABLE [${flyway:defaultSchema}].[ResourcePermission] ADD __mj_UpdatedAt DATETIMEOFFSET NOT NULL DEFAULT GETUTCDATE()

/* SQL text to delete unneeded entity fields */
EXEC [${flyway:defaultSchema}].spDeleteUnneededEntityFields @ExcludedSchemaNames='sys,staging'

/* SQL text to update existingg entity fields from schema */
EXEC [${flyway:defaultSchema}].spUpdateExistingEntityFieldsFromSchema @ExcludedSchemaNames='sys,staging'

/* SQL text to insert new entity field */

      INSERT INTO [${flyway:defaultSchema}].EntityField
      (
         EntityID,
         Sequence,
         Name,
         DisplayName,
         Description,
         Type,
         Length,
         Precision,
         Scale,
         AllowsNull,
         DefaultValue,
         AutoIncrement,
         AllowUpdateAPI,
         IsVirtual,
         RelatedEntityID,
         RelatedEntityFieldName,
         IsNameField,
         IncludeInUserSearchAPI,
         IncludeRelatedEntityNameFieldInBaseView,
         DefaultInView,
         IsPrimaryKey,
         IsUnique,
         RelatedEntityDisplayType
      )
      VALUES
      (
         '201852E1-4587-EF11-8473-6045BDF077EE',
         1,
         'ID',
         'ID',
         NULL,
         'uniqueidentifier',
         16,
         0,
         0,
         0,
         'NEWSEQUENTIALID()',
         0,
         0,
         0,
         NULL,
         NULL,
         0,
         1,
         0,
         1,
         1,
         1,
         'Search'
      )

/* SQL text to insert new entity field */

      INSERT INTO [${flyway:defaultSchema}].EntityField
      (
         EntityID,
         Sequence,
         Name,
         DisplayName,
         Description,
         Type,
         Length,
         Precision,
         Scale,
         AllowsNull,
         DefaultValue,
         AutoIncrement,
         AllowUpdateAPI,
         IsVirtual,
         RelatedEntityID,
         RelatedEntityFieldName,
         IsNameField,
         IncludeInUserSearchAPI,
         IncludeRelatedEntityNameFieldInBaseView,
         DefaultInView,
         IsPrimaryKey,
         IsUnique,
         RelatedEntityDisplayType
      )
      VALUES
      (
         '201852E1-4587-EF11-8473-6045BDF077EE',
         2,
         'ResourceTypeID',
         'Resource Type ID',
         'Reference to the type of resource being shared (View, Dashboard, Report, etc.)',
         'uniqueidentifier',
         16,
         0,
         0,
         0,
         'null',
         0,
         1,
         0,
         '0B248F34-2837-EF11-86D4-6045BDEE16E6',
         'ID',
         0,
         0,
         1,
         1,
         0,
         0,
         'Search'
      )

/* SQL text to insert new entity field */

      INSERT INTO [${flyway:defaultSchema}].EntityField
      (
         EntityID,
         Sequence,
         Name,
         DisplayName,
         Description,
         Type,
         Length,
         Precision,
         Scale,
         AllowsNull,
         DefaultValue,
         AutoIncrement,
         AllowUpdateAPI,
         IsVirtual,
         RelatedEntityID,
         RelatedEntityFieldName,
         IsNameField,
         IncludeInUserSearchAPI,
         IncludeRelatedEntityNameFieldInBaseView,
         DefaultInView,
         IsPrimaryKey,
         IsUnique,
         RelatedEntityDisplayType
      )
      VALUES
      (
         '201852E1-4587-EF11-8473-6045BDF077EE',
         3,
         'ResourceRecordID',
         'Resource Record ID',
         'ID of the specific resource being shared',
         'nvarchar',
         510,
         0,
         0,
         0,
         'null',
         0,
         1,
         0,
         NULL,
         NULL,
         0,
         0,
         0,
         1,
         0,
         0,
         'Search'
      )

/* SQL text to insert new entity field */

      INSERT INTO [${flyway:defaultSchema}].EntityField
      (
         ID,
         EntityID,
         Sequence,
         Name,
         DisplayName,
         Description,
         Type,
         Length,
         Precision,
         Scale,
         AllowsNull,
         DefaultValue,
         AutoIncrement,
         AllowUpdateAPI,
         IsVirtual,
         RelatedEntityID,
         RelatedEntityFieldName,
         IsNameField,
         IncludeInUserSearchAPI,
         IncludeRelatedEntityNameFieldInBaseView,
         DefaultInView,
         IsPrimaryKey,
         IsUnique,
         RelatedEntityDisplayType
      )
      VALUES
      (
        'DE344718-4687-EF11-8473-6045BDF077EE',
         '201852E1-4587-EF11-8473-6045BDF077EE',
         4,
         'Type',
         'Type',
         'The level of sharing either Role or User',
         'nvarchar',
         20,
         0,
         0,
         0,
         'null',
         0,
         1,
         0,
         NULL,
         NULL,
         0,
         0,
         0,
         1,
         0,
         0,
         'Search'
      )

/* SQL text to insert new entity field */

      INSERT INTO [${flyway:defaultSchema}].EntityField
      (
         EntityID,
         Sequence,
         Name,
         DisplayName,
         Description,
         Type,
         Length,
         Precision,
         Scale,
         AllowsNull,
         DefaultValue,
         AutoIncrement,
         AllowUpdateAPI,
         IsVirtual,
         RelatedEntityID,
         RelatedEntityFieldName,
         IsNameField,
         IncludeInUserSearchAPI,
         IncludeRelatedEntityNameFieldInBaseView,
         DefaultInView,
         IsPrimaryKey,
         IsUnique,
         RelatedEntityDisplayType
      )
      VALUES
      (
         '201852E1-4587-EF11-8473-6045BDF077EE',
         5,
         'StartSharingAt',
         'Start Sharing At',
         'Optional: Date when sharing starts',
         'datetimeoffset',
         10,
         34,
         7,
         1,
         null,
         0,
         1,
         0,
         NULL,
         NULL,
         0,
         0,
         0,
         1,
         0,
         0,
         'Search'
      )

/* SQL text to insert new entity field */

      INSERT INTO [${flyway:defaultSchema}].EntityField
      (
         EntityID,
         Sequence,
         Name,
         DisplayName,
         Description,
         Type,
         Length,
         Precision,
         Scale,
         AllowsNull,
         DefaultValue,
         AutoIncrement,
         AllowUpdateAPI,
         IsVirtual,
         RelatedEntityID,
         RelatedEntityFieldName,
         IsNameField,
         IncludeInUserSearchAPI,
         IncludeRelatedEntityNameFieldInBaseView,
         DefaultInView,
         IsPrimaryKey,
         IsUnique,
         RelatedEntityDisplayType
      )
      VALUES
      (
         '201852E1-4587-EF11-8473-6045BDF077EE',
         6,
         'EndSharingAt',
         'End Sharing At',
         'Optional: Date when sharing ends',
         'datetimeoffset',
         10,
         34,
         7,
         1,
         null,
         0,
         1,
         0,
         NULL,
         NULL,
         0,
         0,
         0,
         0,
         0,
         0,
         'Search'
      )

/* SQL text to insert new entity field */

      INSERT INTO [${flyway:defaultSchema}].EntityField
      (
         EntityID,
         Sequence,
         Name,
         DisplayName,
         Description,
         Type,
         Length,
         Precision,
         Scale,
         AllowsNull,
         DefaultValue,
         AutoIncrement,
         AllowUpdateAPI,
         IsVirtual,
         RelatedEntityID,
         RelatedEntityFieldName,
         IsNameField,
         IncludeInUserSearchAPI,
         IncludeRelatedEntityNameFieldInBaseView,
         DefaultInView,
         IsPrimaryKey,
         IsUnique,
         RelatedEntityDisplayType
      )
      VALUES
      (
         '201852E1-4587-EF11-8473-6045BDF077EE',
         7,
         'RoleID',
         'Role ID',
         NULL,
         'uniqueidentifier',
         16,
         0,
         0,
         1,
         'null',
         0,
         1,
         0,
         'DA238F34-2837-EF11-86D4-6045BDEE16E6',
         'ID',
         0,
         0,
         1,
         0,
         0,
         0,
         'Search'
      )

/* SQL text to insert new entity field */

      INSERT INTO [${flyway:defaultSchema}].EntityField
      (
         EntityID,
         Sequence,
         Name,
         DisplayName,
         Description,
         Type,
         Length,
         Precision,
         Scale,
         AllowsNull,
         DefaultValue,
         AutoIncrement,
         AllowUpdateAPI,
         IsVirtual,
         RelatedEntityID,
         RelatedEntityFieldName,
         IsNameField,
         IncludeInUserSearchAPI,
         IncludeRelatedEntityNameFieldInBaseView,
         DefaultInView,
         IsPrimaryKey,
         IsUnique,
         RelatedEntityDisplayType
      )
      VALUES
      (
         '201852E1-4587-EF11-8473-6045BDF077EE',
         8,
         'UserID',
         'User ID',
         NULL,
         'uniqueidentifier',
         16,
         0,
         0,
         1,
         'null',
         0,
         1,
         0,
         'E1238F34-2837-EF11-86D4-6045BDEE16E6',
         'ID',
         0,
         0,
         1,
         0,
         0,
         0,
         'Search'
      )

/* SQL text to insert new entity field */

      INSERT INTO [${flyway:defaultSchema}].EntityField
      (
         ID,
         EntityID,
         Sequence,
         Name,
         DisplayName,
         Description,
         Type,
         Length,
         Precision,
         Scale,
         AllowsNull,
         DefaultValue,
         AutoIncrement,
         AllowUpdateAPI,
         IsVirtual,
         RelatedEntityID,
         RelatedEntityFieldName,
         IsNameField,
         IncludeInUserSearchAPI,
         IncludeRelatedEntityNameFieldInBaseView,
         DefaultInView,
         IsPrimaryKey,
         IsUnique,
         RelatedEntityDisplayType
      )
      VALUES
      (
         'E3344718-4687-EF11-8473-6045BDF077EE',
         '201852E1-4587-EF11-8473-6045BDF077EE',
         9,
         'PermissionLevel',
         'Permission Level',
         'Permission level defining the type of access (View, Edit, Owner)',
         'nvarchar',
         40,
         0,
         0,
         1,
         'null',
         0,
         1,
         0,
         NULL,
         NULL,
         0,
         0,
         0,
         0,
         0,
         0,
         'Search'
      )

/* SQL text to insert new entity field */

      INSERT INTO [${flyway:defaultSchema}].EntityField
      (
         EntityID,
         Sequence,
         Name,
         DisplayName,
         Description,
         Type,
         Length,
         Precision,
         Scale,
         AllowsNull,
         DefaultValue,
         AutoIncrement,
         AllowUpdateAPI,
         IsVirtual,
         RelatedEntityID,
         RelatedEntityFieldName,
         IsNameField,
         IncludeInUserSearchAPI,
         IncludeRelatedEntityNameFieldInBaseView,
         DefaultInView,
         IsPrimaryKey,
         IsUnique,
         RelatedEntityDisplayType
      )
      VALUES
      (
         '201852E1-4587-EF11-8473-6045BDF077EE',
         10,
         '__mj_CreatedAt',
         'Created At',
         NULL,
         'datetimeoffset',
         10,
         34,
         7,
         0,
         'getutcdate()',
         0,
         0,
         0,
         NULL,
         NULL,
         0,
         0,
         0,
         0,
         0,
         0,
         'Search'
      )

/* SQL text to insert new entity field */

      INSERT INTO [${flyway:defaultSchema}].EntityField
      (
         EntityID,
         Sequence,
         Name,
         DisplayName,
         Description,
         Type,
         Length,
         Precision,
         Scale,
         AllowsNull,
         DefaultValue,
         AutoIncrement,
         AllowUpdateAPI,
         IsVirtual,
         RelatedEntityID,
         RelatedEntityFieldName,
         IsNameField,
         IncludeInUserSearchAPI,
         IncludeRelatedEntityNameFieldInBaseView,
         DefaultInView,
         IsPrimaryKey,
         IsUnique,
         RelatedEntityDisplayType
      )
      VALUES
      (
         '201852E1-4587-EF11-8473-6045BDF077EE',
         11,
         '__mj_UpdatedAt',
         'Updated At',
         NULL,
         'datetimeoffset',
         10,
         34,
         7,
         0,
         'getutcdate()',
         0,
         0,
         0,
         NULL,
         NULL,
         0,
         0,
         0,
         0,
         0,
         0,
         'Search'
      )
       

/* SQL text to set default column width where needed */
EXEC [${flyway:defaultSchema}].spSetDefaultColumnWidthWhereNeeded @ExcludedSchemaNames='sys,staging'

/* SQL text to update ValueListType for entity field ID 42DE5E8E-A83B-EF11-86D4-0022481D1B23 */
UPDATE [${flyway:defaultSchema}].EntityField SET ValueListType='List' WHERE ID='42DE5E8E-A83B-EF11-86D4-0022481D1B23'

/* SQL text to update ValueListType for entity field ID 3FDE5E8E-A83B-EF11-86D4-0022481D1B23 */
UPDATE [${flyway:defaultSchema}].EntityField SET ValueListType='List' WHERE ID='3FDE5E8E-A83B-EF11-86D4-0022481D1B23'

/* SQL text to update ValueListType for entity field ID 270644A9-0A3C-EF11-86D4-0022481D1B23 */
UPDATE [${flyway:defaultSchema}].EntityField SET ValueListType='List' WHERE ID='270644A9-0A3C-EF11-86D4-0022481D1B23'

/* SQL text to update ValueListType for entity field ID F573433E-F36B-1410-883E-00D02208DC50 */
UPDATE [${flyway:defaultSchema}].EntityField SET ValueListType='List' WHERE ID='F573433E-F36B-1410-883E-00D02208DC50'

/* SQL text to update ValueListType for entity field ID 0074433E-F36B-1410-883E-00D02208DC50 */
UPDATE [${flyway:defaultSchema}].EntityField SET ValueListType='List' WHERE ID='0074433E-F36B-1410-883E-00D02208DC50'

/* SQL text to update entity field value sequence */
UPDATE [${flyway:defaultSchema}].EntityFieldValue SET Sequence=1 WHERE ID='C051302D-7236-EF11-86D4-6045BDEE16E6'

/* SQL text to update entity field value sequence */
UPDATE [${flyway:defaultSchema}].EntityFieldValue SET Sequence=3 WHERE ID='BE51302D-7236-EF11-86D4-6045BDEE16E6'

/* SQL text to update ValueListType for entity field ID C64D17F0-6F36-EF11-86D4-6045BDEE16E6 */
UPDATE [${flyway:defaultSchema}].EntityField SET ValueListType='List' WHERE ID='C64D17F0-6F36-EF11-86D4-6045BDEE16E6'

/* SQL text to update ValueListType for entity field ID B04C17F0-6F36-EF11-86D4-6045BDEE16E6 */
UPDATE [${flyway:defaultSchema}].EntityField SET ValueListType='List' WHERE ID='B04C17F0-6F36-EF11-86D4-6045BDEE16E6'

/* SQL text to update ValueListType for entity field ID C64D17F0-6F36-EF11-86D4-6045BDEE16E6 */
UPDATE [${flyway:defaultSchema}].EntityField SET ValueListType='List' WHERE ID='C64D17F0-6F36-EF11-86D4-6045BDEE16E6'

/* SQL text to update ValueListType for entity field ID F64217F0-6F36-EF11-86D4-6045BDEE16E6 */
UPDATE [${flyway:defaultSchema}].EntityField SET ValueListType='List' WHERE ID='F64217F0-6F36-EF11-86D4-6045BDEE16E6'

/* SQL text to update ValueListType for entity field ID 055817F0-6F36-EF11-86D4-6045BDEE16E6 */
UPDATE [${flyway:defaultSchema}].EntityField SET ValueListType='List' WHERE ID='055817F0-6F36-EF11-86D4-6045BDEE16E6'

/* SQL text to update ValueListType for entity field ID 115917F0-6F36-EF11-86D4-6045BDEE16E6 */
UPDATE [${flyway:defaultSchema}].EntityField SET ValueListType='List' WHERE ID='115917F0-6F36-EF11-86D4-6045BDEE16E6'

/* SQL text to update ValueListType for entity field ID F75817F0-6F36-EF11-86D4-6045BDEE16E6 */
UPDATE [${flyway:defaultSchema}].EntityField SET ValueListType='List' WHERE ID='F75817F0-6F36-EF11-86D4-6045BDEE16E6'

/* SQL text to update ValueListType for entity field ID 334D17F0-6F36-EF11-86D4-6045BDEE16E6 */
UPDATE [${flyway:defaultSchema}].EntityField SET ValueListType='List' WHERE ID='334D17F0-6F36-EF11-86D4-6045BDEE16E6'

/* SQL text to update ValueListType for entity field ID 304D17F0-6F36-EF11-86D4-6045BDEE16E6 */
UPDATE [${flyway:defaultSchema}].EntityField SET ValueListType='List' WHERE ID='304D17F0-6F36-EF11-86D4-6045BDEE16E6'

/* SQL text to update ValueListType for entity field ID 614D17F0-6F36-EF11-86D4-6045BDEE16E6 */
UPDATE [${flyway:defaultSchema}].EntityField SET ValueListType='List' WHERE ID='614D17F0-6F36-EF11-86D4-6045BDEE16E6'

/* SQL text to update ValueListType for entity field ID 2F4D17F0-6F36-EF11-86D4-6045BDEE16E6 */
UPDATE [${flyway:defaultSchema}].EntityField SET ValueListType='List' WHERE ID='2F4D17F0-6F36-EF11-86D4-6045BDEE16E6'

/* SQL text to update ValueListType for entity field ID C34217F0-6F36-EF11-86D4-6045BDEE16E6 */
UPDATE [${flyway:defaultSchema}].EntityField SET ValueListType='List' WHERE ID='C34217F0-6F36-EF11-86D4-6045BDEE16E6'

/* SQL text to update ValueListType for entity field ID 3670D30B-8A55-EF11-991A-000D3A9D8BF3 */
UPDATE [${flyway:defaultSchema}].EntityField SET ValueListType='List' WHERE ID='3670D30B-8A55-EF11-991A-000D3A9D8BF3'

/* SQL text to update ValueListType for entity field ID D44217F0-6F36-EF11-86D4-6045BDEE16E6 */
UPDATE [${flyway:defaultSchema}].EntityField SET ValueListType='List' WHERE ID='D44217F0-6F36-EF11-86D4-6045BDEE16E6'

/* SQL text to update ValueListType for entity field ID 144F17F0-6F36-EF11-86D4-6045BDEE16E6 */
UPDATE [${flyway:defaultSchema}].EntityField SET ValueListType='List' WHERE ID='144F17F0-6F36-EF11-86D4-6045BDEE16E6'

/* SQL text to update ValueListType for entity field ID B75717F0-6F36-EF11-86D4-6045BDEE16E6 */
UPDATE [${flyway:defaultSchema}].EntityField SET ValueListType='List' WHERE ID='B75717F0-6F36-EF11-86D4-6045BDEE16E6'

/* SQL text to update ValueListType for entity field ID B85717F0-6F36-EF11-86D4-6045BDEE16E6 */
UPDATE [${flyway:defaultSchema}].EntityField SET ValueListType='List' WHERE ID='B85717F0-6F36-EF11-86D4-6045BDEE16E6'

/* SQL text to update ValueListType for entity field ID B24D17F0-6F36-EF11-86D4-6045BDEE16E6 */
UPDATE [${flyway:defaultSchema}].EntityField SET ValueListType='List' WHERE ID='B24D17F0-6F36-EF11-86D4-6045BDEE16E6'

/* SQL text to update ValueListType for entity field ID E74217F0-6F36-EF11-86D4-6045BDEE16E6 */
UPDATE [${flyway:defaultSchema}].EntityField SET ValueListType='List' WHERE ID='E74217F0-6F36-EF11-86D4-6045BDEE16E6'

/* SQL text to update ValueListType for entity field ID F04217F0-6F36-EF11-86D4-6045BDEE16E6 */
UPDATE [${flyway:defaultSchema}].EntityField SET ValueListType='List' WHERE ID='F04217F0-6F36-EF11-86D4-6045BDEE16E6'

/* SQL text to update ValueListType for entity field ID D74D17F0-6F36-EF11-86D4-6045BDEE16E6 */
UPDATE [${flyway:defaultSchema}].EntityField SET ValueListType='List' WHERE ID='D74D17F0-6F36-EF11-86D4-6045BDEE16E6'

/* SQL text to update ValueListType for entity field ID D94D17F0-6F36-EF11-86D4-6045BDEE16E6 */
UPDATE [${flyway:defaultSchema}].EntityField SET ValueListType='List' WHERE ID='D94D17F0-6F36-EF11-86D4-6045BDEE16E6'

/* SQL text to update ValueListType for entity field ID DC4D17F0-6F36-EF11-86D4-6045BDEE16E6 */
UPDATE [${flyway:defaultSchema}].EntityField SET ValueListType='List' WHERE ID='DC4D17F0-6F36-EF11-86D4-6045BDEE16E6'

/* SQL text to update ValueListType for entity field ID F34D17F0-6F36-EF11-86D4-6045BDEE16E6 */
UPDATE [${flyway:defaultSchema}].EntityField SET ValueListType='List' WHERE ID='F34D17F0-6F36-EF11-86D4-6045BDEE16E6'

/* SQL text to update ValueListType for entity field ID 124E17F0-6F36-EF11-86D4-6045BDEE16E6 */
UPDATE [${flyway:defaultSchema}].EntityField SET ValueListType='List' WHERE ID='124E17F0-6F36-EF11-86D4-6045BDEE16E6'

/* SQL text to update ValueListType for entity field ID 544317F0-6F36-EF11-86D4-6045BDEE16E6 */
UPDATE [${flyway:defaultSchema}].EntityField SET ValueListType='List' WHERE ID='544317F0-6F36-EF11-86D4-6045BDEE16E6'

/* SQL text to update ValueListType for entity field ID 524317F0-6F36-EF11-86D4-6045BDEE16E6 */
UPDATE [${flyway:defaultSchema}].EntityField SET ValueListType='List' WHERE ID='524317F0-6F36-EF11-86D4-6045BDEE16E6'

/* SQL text to update ValueListType for entity field ID 5C4317F0-6F36-EF11-86D4-6045BDEE16E6 */
UPDATE [${flyway:defaultSchema}].EntityField SET ValueListType='List' WHERE ID='5C4317F0-6F36-EF11-86D4-6045BDEE16E6'

/* SQL text to update ValueListType for entity field ID 734E17F0-6F36-EF11-86D4-6045BDEE16E6 */
UPDATE [${flyway:defaultSchema}].EntityField SET ValueListType='List' WHERE ID='734E17F0-6F36-EF11-86D4-6045BDEE16E6'

/* SQL text to update ValueListType for entity field ID E54317F0-6F36-EF11-86D4-6045BDEE16E6 */
UPDATE [${flyway:defaultSchema}].EntityField SET ValueListType='List' WHERE ID='E54317F0-6F36-EF11-86D4-6045BDEE16E6'

/* SQL text to update ValueListType for entity field ID F74317F0-6F36-EF11-86D4-6045BDEE16E6 */
UPDATE [${flyway:defaultSchema}].EntityField SET ValueListType='List' WHERE ID='F74317F0-6F36-EF11-86D4-6045BDEE16E6'

/* SQL text to update ValueListType for entity field ID EE4E17F0-6F36-EF11-86D4-6045BDEE16E6 */
UPDATE [${flyway:defaultSchema}].EntityField SET ValueListType='List' WHERE ID='EE4E17F0-6F36-EF11-86D4-6045BDEE16E6'

/* SQL text to update ValueListType for entity field ID 1B4F17F0-6F36-EF11-86D4-6045BDEE16E6 */
UPDATE [${flyway:defaultSchema}].EntityField SET ValueListType='List' WHERE ID='1B4F17F0-6F36-EF11-86D4-6045BDEE16E6'

/* SQL text to update ValueListType for entity field ID 1D4F17F0-6F36-EF11-86D4-6045BDEE16E6 */
UPDATE [${flyway:defaultSchema}].EntityField SET ValueListType='List' WHERE ID='1D4F17F0-6F36-EF11-86D4-6045BDEE16E6'

/* SQL text to update ValueListType for entity field ID 2E4417F0-6F36-EF11-86D4-6045BDEE16E6 */
UPDATE [${flyway:defaultSchema}].EntityField SET ValueListType='List' WHERE ID='2E4417F0-6F36-EF11-86D4-6045BDEE16E6'

/* SQL text to update ValueListType for entity field ID 2F4417F0-6F36-EF11-86D4-6045BDEE16E6 */
UPDATE [${flyway:defaultSchema}].EntityField SET ValueListType='List' WHERE ID='2F4417F0-6F36-EF11-86D4-6045BDEE16E6'

/* SQL text to update ValueListType for entity field ID 3F4F17F0-6F36-EF11-86D4-6045BDEE16E6 */
UPDATE [${flyway:defaultSchema}].EntityField SET ValueListType='List' WHERE ID='3F4F17F0-6F36-EF11-86D4-6045BDEE16E6'

/* SQL text to update ValueListType for entity field ID 384F17F0-6F36-EF11-86D4-6045BDEE16E6 */
UPDATE [${flyway:defaultSchema}].EntityField SET ValueListType='List' WHERE ID='384F17F0-6F36-EF11-86D4-6045BDEE16E6'

/* SQL text to update ValueListType for entity field ID 3B4F17F0-6F36-EF11-86D4-6045BDEE16E6 */
UPDATE [${flyway:defaultSchema}].EntityField SET ValueListType='List' WHERE ID='3B4F17F0-6F36-EF11-86D4-6045BDEE16E6'

/* SQL text to update ValueListType for entity field ID 384417F0-6F36-EF11-86D4-6045BDEE16E6 */
UPDATE [${flyway:defaultSchema}].EntityField SET ValueListType='List' WHERE ID='384417F0-6F36-EF11-86D4-6045BDEE16E6'

/* SQL text to update ValueListType for entity field ID 3B4417F0-6F36-EF11-86D4-6045BDEE16E6 */
UPDATE [${flyway:defaultSchema}].EntityField SET ValueListType='List' WHERE ID='3B4417F0-6F36-EF11-86D4-6045BDEE16E6'

/* SQL text to update ValueListType for entity field ID 505717F0-6F36-EF11-86D4-6045BDEE16E6 */
UPDATE [${flyway:defaultSchema}].EntityField SET ValueListType='List' WHERE ID='505717F0-6F36-EF11-86D4-6045BDEE16E6'

/* SQL text to update ValueListType for entity field ID 7A4C17F0-6F36-EF11-86D4-6045BDEE16E6 */
UPDATE [${flyway:defaultSchema}].EntityField SET ValueListType='List' WHERE ID='7A4C17F0-6F36-EF11-86D4-6045BDEE16E6'

/* SQL text to update ValueListType for entity field ID 7E4C17F0-6F36-EF11-86D4-6045BDEE16E6 */
UPDATE [${flyway:defaultSchema}].EntityField SET ValueListType='List' WHERE ID='7E4C17F0-6F36-EF11-86D4-6045BDEE16E6'

/* SQL text to update ValueListType for entity field ID 545717F0-6F36-EF11-86D4-6045BDEE16E6 */
UPDATE [${flyway:defaultSchema}].EntityField SET ValueListType='List' WHERE ID='545717F0-6F36-EF11-86D4-6045BDEE16E6'

/* SQL text to update ValueListType for entity field ID 595717F0-6F36-EF11-86D4-6045BDEE16E6 */
UPDATE [${flyway:defaultSchema}].EntityField SET ValueListType='List' WHERE ID='595717F0-6F36-EF11-86D4-6045BDEE16E6'

/* SQL text to update ValueListType for entity field ID F95817F0-6F36-EF11-86D4-6045BDEE16E6 */
UPDATE [${flyway:defaultSchema}].EntityField SET ValueListType='List' WHERE ID='F95817F0-6F36-EF11-86D4-6045BDEE16E6'

/* SQL text to update ValueListType for entity field ID 5E5717F0-6F36-EF11-86D4-6045BDEE16E6 */
UPDATE [${flyway:defaultSchema}].EntityField SET ValueListType='List' WHERE ID='5E5717F0-6F36-EF11-86D4-6045BDEE16E6'

/* SQL text to update ValueListType for entity field ID 964C17F0-6F36-EF11-86D4-6045BDEE16E6 */
UPDATE [${flyway:defaultSchema}].EntityField SET ValueListType='List' WHERE ID='964C17F0-6F36-EF11-86D4-6045BDEE16E6'

/* SQL text to update ValueListType for entity field ID A24C17F0-6F36-EF11-86D4-6045BDEE16E6 */
UPDATE [${flyway:defaultSchema}].EntityField SET ValueListType='List' WHERE ID='A24C17F0-6F36-EF11-86D4-6045BDEE16E6'

/* SQL text to update ValueListType for entity field ID A34C17F0-6F36-EF11-86D4-6045BDEE16E6 */
UPDATE [${flyway:defaultSchema}].EntityField SET ValueListType='List' WHERE ID='A34C17F0-6F36-EF11-86D4-6045BDEE16E6'

/* SQL text to update ValueListType for entity field ID A34C17F0-6F36-EF11-86D4-6045BDEE16E6 */
UPDATE [${flyway:defaultSchema}].EntityField SET ValueListType='List' WHERE ID='A34C17F0-6F36-EF11-86D4-6045BDEE16E6'

/* SQL text to update ValueListType for entity field ID 755717F0-6F36-EF11-86D4-6045BDEE16E6 */
UPDATE [${flyway:defaultSchema}].EntityField SET ValueListType='List' WHERE ID='755717F0-6F36-EF11-86D4-6045BDEE16E6'

/* SQL text to update ValueListType for entity field ID B44C17F0-6F36-EF11-86D4-6045BDEE16E6 */
UPDATE [${flyway:defaultSchema}].EntityField SET ValueListType='List' WHERE ID='B44C17F0-6F36-EF11-86D4-6045BDEE16E6'

/* SQL text to update ValueListType for entity field ID 805717F0-6F36-EF11-86D4-6045BDEE16E6 */
UPDATE [${flyway:defaultSchema}].EntityField SET ValueListType='List' WHERE ID='805717F0-6F36-EF11-86D4-6045BDEE16E6'

/* SQL text to update ValueListType for entity field ID 815717F0-6F36-EF11-86D4-6045BDEE16E6 */
UPDATE [${flyway:defaultSchema}].EntityField SET ValueListType='List' WHERE ID='815717F0-6F36-EF11-86D4-6045BDEE16E6'

/* SQL text to update ValueListType for entity field ID 875717F0-6F36-EF11-86D4-6045BDEE16E6 */
UPDATE [${flyway:defaultSchema}].EntityField SET ValueListType='List' WHERE ID='875717F0-6F36-EF11-86D4-6045BDEE16E6'

/* SQL text to update ValueListType for entity field ID BA4C17F0-6F36-EF11-86D4-6045BDEE16E6 */
UPDATE [${flyway:defaultSchema}].EntityField SET ValueListType='List' WHERE ID='BA4C17F0-6F36-EF11-86D4-6045BDEE16E6'

/* SQL text to update ValueListType for entity field ID BC4C17F0-6F36-EF11-86D4-6045BDEE16E6 */
UPDATE [${flyway:defaultSchema}].EntityField SET ValueListType='List' WHERE ID='BC4C17F0-6F36-EF11-86D4-6045BDEE16E6'

/* SQL text to update ValueListType for entity field ID 9C5717F0-6F36-EF11-86D4-6045BDEE16E6 */
UPDATE [${flyway:defaultSchema}].EntityField SET ValueListType='List' WHERE ID='9C5717F0-6F36-EF11-86D4-6045BDEE16E6'

/* SQL text to update ValueListType for entity field ID FC5817F0-6F36-EF11-86D4-6045BDEE16E6 */
UPDATE [${flyway:defaultSchema}].EntityField SET ValueListType='List' WHERE ID='FC5817F0-6F36-EF11-86D4-6045BDEE16E6'

/* SQL text to update ValueListType for entity field ID A55717F0-6F36-EF11-86D4-6045BDEE16E6 */
UPDATE [${flyway:defaultSchema}].EntityField SET ValueListType='List' WHERE ID='A55717F0-6F36-EF11-86D4-6045BDEE16E6'

/* SQL text to update ValueListType for entity field ID F74C17F0-6F36-EF11-86D4-6045BDEE16E6 */
UPDATE [${flyway:defaultSchema}].EntityField SET ValueListType='List' WHERE ID='F74C17F0-6F36-EF11-86D4-6045BDEE16E6'

/* SQL text to update ValueListType for entity field ID FD4C17F0-6F36-EF11-86D4-6045BDEE16E6 */
UPDATE [${flyway:defaultSchema}].EntityField SET ValueListType='List' WHERE ID='FD4C17F0-6F36-EF11-86D4-6045BDEE16E6'

/* SQL text to update ValueListType for entity field ID F65717F0-6F36-EF11-86D4-6045BDEE16E6 */
UPDATE [${flyway:defaultSchema}].EntityField SET ValueListType='List' WHERE ID='F65717F0-6F36-EF11-86D4-6045BDEE16E6'

/* SQL text to update ValueListType for entity field ID 995817F0-6F36-EF11-86D4-6045BDEE16E6 */
UPDATE [${flyway:defaultSchema}].EntityField SET ValueListType='List' WHERE ID='995817F0-6F36-EF11-86D4-6045BDEE16E6'

/* SQL text to insert entity field values */
INSERT INTO [${flyway:defaultSchema}].EntityFieldValue 
                                       (EntityFieldID, Sequence, Value, Code) 
                                    VALUES 
                                       ('DE344718-4687-EF11-8473-6045BDF077EE', 1, 'Role', 'Role')

/* SQL text to insert entity field values */
INSERT INTO [${flyway:defaultSchema}].EntityFieldValue 
                                       (EntityFieldID, Sequence, Value, Code) 
                                    VALUES 
                                       ('DE344718-4687-EF11-8473-6045BDF077EE', 2, 'User', 'User')

/* SQL text to update ValueListType for entity field ID DE344718-4687-EF11-8473-6045BDF077EE */
UPDATE [${flyway:defaultSchema}].EntityField SET ValueListType='List' WHERE ID='DE344718-4687-EF11-8473-6045BDF077EE'

/* SQL text to insert entity field values */
INSERT INTO [${flyway:defaultSchema}].EntityFieldValue 
                                       (EntityFieldID, Sequence, Value, Code) 
                                    VALUES 
                                       ('E3344718-4687-EF11-8473-6045BDF077EE', 1, 'View', 'View')

/* SQL text to insert entity field values */
INSERT INTO [${flyway:defaultSchema}].EntityFieldValue 
                                       (EntityFieldID, Sequence, Value, Code) 
                                    VALUES 
                                       ('E3344718-4687-EF11-8473-6045BDF077EE', 2, 'Edit', 'Edit')

/* SQL text to insert entity field values */
INSERT INTO [${flyway:defaultSchema}].EntityFieldValue 
                                       (EntityFieldID, Sequence, Value, Code) 
                                    VALUES 
                                       ('E3344718-4687-EF11-8473-6045BDF077EE', 3, 'Owner', 'Owner')

/* SQL text to update ValueListType for entity field ID E3344718-4687-EF11-8473-6045BDF077EE */
UPDATE [${flyway:defaultSchema}].EntityField SET ValueListType='List' WHERE ID='E3344718-4687-EF11-8473-6045BDF077EE'

/* SQL text to create Entitiy Relationships */
INSERT INTO [${flyway:defaultSchema}].EntityRelationship (EntityID, RelatedEntityID, RelatedEntityJoinField, Type, BundleInAPI, DisplayInForm, DisplayName, Sequence) 
                                          VALUES ('DA238F34-2837-EF11-86D4-6045BDEE16E6', '201852E1-4587-EF11-8473-6045BDF077EE', 'RoleID', 'One To Many', 1, 1, 'Resource Permissions', 1);
                              

/* SQL text to create Entitiy Relationships */
INSERT INTO [${flyway:defaultSchema}].EntityRelationship (EntityID, RelatedEntityID, RelatedEntityJoinField, Type, BundleInAPI, DisplayInForm, DisplayName, Sequence) 
                                          VALUES ('E1238F34-2837-EF11-86D4-6045BDEE16E6', '201852E1-4587-EF11-8473-6045BDF077EE', 'UserID', 'One To Many', 1, 1, 'Resource Permissions', 2);
                              

/* SQL text to create Entitiy Relationships */
INSERT INTO [${flyway:defaultSchema}].EntityRelationship (EntityID, RelatedEntityID, RelatedEntityJoinField, Type, BundleInAPI, DisplayInForm, DisplayName, Sequence) 
                                          VALUES ('0B248F34-2837-EF11-86D4-6045BDEE16E6', '201852E1-4587-EF11-8473-6045BDF077EE', 'ResourceTypeID', 'One To Many', 1, 1, 'Resource Permissions', 3);
                              

/****************************************************
****************************************************
****************************************************
MANUAL REVIEW COMPLETED FOR ABOVE
****************************************************
****************************************************
*************************************************/