<?xml version="1.0"?>
<!DOCTYPE database_configuration [
    <!ENTITY SERVER_NAME            SYSTEM       "dbcfg_ServerName.txt"> 
    <!ENTITY PRODUCT_INSTALL_PATH   SYSTEM       "dbcfg_ProductInstallPath.txt">
	<!ENTITY DATABASE_NAME          SYSTEM        "dbcfg_ConfDatabaseName.txt">
	<!ENTITY POSTFIX                SYSTEM        "dbcfg_Postfix.txt">
    <!ENTITY % cfgDefinition SYSTEM "cfgDefinition.dtd">
  %cfgDefinition;
    <!ENTITY % cfgLocalize SYSTEM "cfgLocalize.dtd">     
    %cfgLocalize;
	
	
]>
<database_configuration xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="DBConf.xsd">
    <database_type>SQLSVR</database_type>
    <category>configuration</category>
    <database_name>&DATABASE_NAME;</database_name>
    <table_postfix>&POSTFIX;</table_postfix>
    <database_installation>
        <sql>
            USE [&DATABASE_NAME;]
        </sql>
        <schema_definition src="dbSchema_Conf.xml"/>
		<import_dlp src="Compliance_Template.xml"/>
    </database_installation>
  
    <database_uninstallation>
        <schema_definition src="dbSchema_Conf.xml"/>
		<sql>
		    IF EXISTS (SELECT * FROM fn_listextendedproperty(N'PP_Created', N'SCHEMA', N'dbo', default, default, default, default))
			   AND NOT EXISTS (select * from sys.sysobjects where xtype = 'U')
			BEGIN
                USE master
                ALTER DATABASE [&DATABASE_NAME;] SET  SINGLE_USER WITH ROLLBACK IMMEDIATE
                DROP DATABASE [&DATABASE_NAME;]
			END
		</sql>
    </database_uninstallation>
    
    <database_upgrade>
		<upgrade_schema src="dbSchema_Conf.xml"/>
		<sql>
            USE [&DATABASE_NAME;]
        </sql>
		<sql>
		    Update TM_ManualUpdate&POSTFIX; set MU_TM_AUSERVER_HTTPS = 1 where CFG_INDEX='SMEX_PLC_NULL:SMEX_SUB_CFG_AU_MANUAL'
		</sql>
		<sql>
		    Update TM_ManualUpdate&POSTFIX; set MU_TM_AUSERVER_HTTPS = 1 where CFG_INDEX='SMEX_PLC_NULL:SMEX_SUB_CFG_AU_MANUAL_DEFAULT'
		</sql>
		<sql>
		    Update TM_ScheduledUpdate&POSTFIX; set SU_TM_AUSERVER_HTTPS = 1 where CFG_INDEX='SMEX_PLC_NULL:SMEX_SUB_CFG_AU_SCHEDULED'
		</sql>
		<sql>
		    Update TM_ScheduledUpdate&POSTFIX; set SU_TM_AUSERVER_HTTPS = 1 where CFG_INDEX='SMEX_PLC_NULL:SMEX_SUB_CFG_AU_SCHEDULED_DEFAULT'
		</sql>
    </database_upgrade>
    
    <simple_commands>
        <name_conversion src="dbSchema_Conf.xml"/>
		<command name="UPDATE_OLE_SCAN_OPTIONS">UPDATE [TM_FileBlockingRule&POSTFIX;] SET FB_OLE_LAYER=%d,FB_OLE_TYPE_LIST='%s' WHERE CFG_INDEX = 'SMEX_PLC_NULL:SMEX_SUB_CFG_AB_RS'</command>
		<command name="CHECK_AU_SOURCE">SELECT * FROM [TM_ManualUpdate&POSTFIX;] WHERE MU_AU_LOCATION_TYPE != 1</command>
    </simple_commands>
</database_configuration>
