/*#ifndef NBOMDB_SQL_HEADER
**#define NBOMDB_SQL_HEADER
**static char SCCS_ID[] = @(#) LIV  2001/06/05 14:52:17   nbomdb.sql \main\callpilot2.0\3 ~
** LIV  2001/06/05 14:52:17   nbomdb.sql \main\callpilot2.0\3 ~
** [liv/Database/nbdb0061]
** Support upgrade from 1.07 (or earlier) to 2.0
**
** liv  2000/07/25 14:27:20   nbomdb.sql \main\callpilot2.0\2 ~
** [nbdb0015] + Add OM fields for release 2.1
**
** liv  2000/07/25 14:27:13   nbomdb.sql \main\callpilot2.0\2 ~
** [nbdb0015] + Add OM fields for release 2.1
**
** liv  2000/07/25 14:27:01   nbomdb.sql \main\callpilot2.0\2 ~
** [nbdb0015] + Add OM fields for release 2.1
**
** vobadm  2000/06/28 02:04:26   nbomdb.sql \main\callpilot2.0\1 ~
** [callpilot2.0_setup]
**
** vobadm  2000/06/28 02:04:25   nbomdb.sql \main\callpilot2.0\1 ~
** [callpilot2.0_setup]
**
** suj  99/3/2 9:45:41   nbomdb.sql \main\r2\6 ~
** [TM10241] OM: Data Collection Type does not show the correct default
**
** acicb  98/8/25 18:5:0   nbomdb.sql \main\r2\5 ~
** [9T18_TM3069]
**
** acicb  98/3/25 9:59:10   nbomdb.sql \main\r2\4 ~
**
** acicb  98/3/19 14:23:38   nbomdb.sql \main\r2\3 ~
**
**#endif
*/

/********************************************************/
/*   !!!!!   OBSOLETED   !!!!!                          */
/*                                                      */
/* This data has been moved to nmom\dbscript\nmomdb.sql */
/* This file should be removed from nbpoptab.txt        */
/********************************************************/

insert into NBomConfig
	(ModifyNum, ServiceID, StartHr, StartMin, EndHr, EndMin, CollectOM, KeepOM,
        AuditHr, AuditMin, ColInterval, omCallIDRange)
	values (1, 1, 8, 0, 8, 0, 3, 7, 3, 0, 60, 1000)
go

insert into NBomRules
	(omID, omTableName, omReportLevel, omTableCleanUp, omDisableOverride, NumberOfFields, 
	Field1Name, Field1Type, Field1Size, Field2Name, Field2Type, Field2Size,
	Field3Name, Field3Type, Field3Size, Field4Name, Field4Type, Field4Size,
	Field5Name, Field5Type, Field5Size, Field6Name, Field6Type, Field6Size,
	Field7Name, Field7Type, Field7Size, Field8Name, Field8Type, Field8Size,
	Field9Name, Field9Type, Field9Size, Field10Name, Field10Type, Field10Size)
	values (1, 'NBomCallQueue', 1, 0, 0, 10,
		'InQStart',		3, 4, 
		'InQEnd',		3, 4, 
		'Reason',		0, 4, 
		'CallAbandon',	0, 4, 
		'ASDN',			1, 68,
		'ServiceID',	0, 4,
		'AppID',		5, 4,
		'CustID',		5, 4, 
		'TenantID',		0, 4,
		'MediaType',	0, 4)
go


insert into NBomRules
	(omID, omTableName, omReportLevel, omTableCleanUp, omDisableOverride, NumberOfFields, 
	Field1Name, Field1Type, Field1Size, Field2Name, Field2Type, Field2Size,
	Field3Name, Field3Type, Field3Size, Field4Name, Field4Type, Field4Size,
	Field5Name, Field5Type, Field5Size, Field6Name, Field6Type, Field6Size,
	Field7Name, Field7Type, Field7Size, Field8Name, Field8Type, Field8Size,
	Field9Name, Field9Type, Field9Size, Field10Name, Field10Type, Field10Size,
	Field11Name, Field11Type, Field11Size, Field12Name, Field12Type, Field12Size,
	Field13Name, Field13Type, Field13Size, Field14Name, Field14Type, Field14Size,
	Field15Name, Field15Type, Field15Size, Field16Name, Field16Type, Field16Size,
	Field17Name, Field17Type, Field17Size, Field18Name, Field18Type, Field18Size,
	Field19Name, Field19Type, Field19Size )
	values (2, 'NBomPort', 1, 0, 0, 15,
		'CustID',				5, 4, 
		'TenantID',				5, 4,
		'PortNumber',			5, 4, 
		'CallStart',			3, 4, 
		'CallEnd',				3, 4,
       	'CallDirection',		5, 4, 
		'CallingDNType',		5, 4, 
		'CallingDN',			1, 68, 
		'CalledDN',				1, 68, 
		'ServiceID',			5, 4,
		'AppID',				5, 4,
		'LastCallHistory',		5, 4,
		'M1CallID',				0, 4,
		'RequestedMediaType',	0, 4,
		'AcquiredMediaType',	0, 4,
	/* CP 2.0 */
		'VoiceUsage',			0, 4,
		'FaxUsage',				0, 4,
		'SRUsage',				0, 4,
		'ConfUsage',			0, 4)
go


insert into NBomRules
	(omID, omTableName, omReportLevel, omTableCleanUp, omDisableOverride, NumberOfFields, 
	Field1Name, Field1Type, Field1Size, Field2Name, Field2Type, Field2Size)
	values (3, 'NBomAllPortBusy', 1, 0, 0, 2,
		'AllBusyStart',		3, 4,
		'AllBusyEnd',		3, 4)
go


insert into NBomRules
	(omID, omTableName, omReportLevel, omTableCleanUp, omDisableOverride, NumberOfFields, 
	Field1Name, Field1Type, Field1Size, Field2Name, Field2Type, Field2Size, Field3Name, Field3Type, Field3Size)
	values (4, 'NBomNTDisk', 1, 0, 0, 3,
		'DiskSize',		0, 4,
		'DiskAvail',	0, 4,
		'DiskID',	1, 10)
go


insert into NBomRules
	(omID, omTableName, omReportLevel, omTableCleanUp, omDisableOverride, NumberOfFields, 
	Field1Name, Field1Type, Field1Size, Field2Name, Field2Type, Field2Size,
	Field3Name, Field3Type, Field3Size, Field4Name, Field4Type, Field4Size,
	Field5Name, Field5Type, Field5Size, Field6Name, Field6Type, Field6Size,
	Field7Name, Field7Type, Field7Size, Field8Name, Field8Type, Field8Size,
	Field9Name, Field9Type, Field9Size, Field10Name, Field10Type, Field10Size,
	Field11Name, Field11Type, Field11Size, Field12Name, Field12Type, Field12Size)
	values (5, 'NBomMMFS', 1, 0, 0, 12, 
		'VolumeID',					0, 4, 
		'NumRegisterUser',			0, 4, 
		'omTextSize',				0, 4, 
		'VoiceSize',				0, 4, 
		'TextAvail',				0, 4,
		'VoiceAvail',				0, 4,
		'TextMinFreeBlock',			0, 4,
		'VoiceMinFreeBlock',		0, 4, 
		'TextVirtualAllocated',		0, 4, 
		'VoiceVirtualAllocated',	0, 4,
		'TextVirtualUsed',			0, 4, 
		'VoiceVirtualUsed',			0, 4)
go