/*#ifndef NBDBPOP_SQL_HEADER
**#define NBDBPOP_SQL_HEADER
**static char SCCS_ID[] = @(#) LIV  2001/10/23 14:17:48   nbdbpop.sql \main\callpilot2.0\6 ~
** MLAMOV 2005/05/13 12:50      nbdbpop.sql
** Activity: cp_50_Propagate_mlamov.1
** Q01080841 MTF - Need AppBuilder version interlock to prevent access from older clients
**
** LIV  2001/10/23 14:17:48   nbdbpop.sql \main\callpilot2.0\6 ~
** [liv/Database/nbdb0089]
** Correct DB datafills for NBFltSysSettings, NMCPMApplication, Loopback mailbox
**
** LIV  2001/09/20 16:38:47   nbdbpop.sql \main\callpilot2.0\5 ~
** [liv/Database/nbdb0084]
** DB Changes for 2.01.19.01 (new defaults, new columns for AddressBook, new system events, add loopback mailbox, ...)
**
** LIV  2001/09/06 11:31:16   nbdbpop.sql \main\callpilot2.0\4 ~
** [liv/Database/nbdb0083]
** DB changes for 2.01.18.08
**
** LIV  2001/07/12 15:24:17   nbdbpop.sql \main\callpilot2.0\3 ~
** [liv/Database/nbdb0075]
** Remove NBUser, NBPCUser, NBUserTemplate, NBUserStation, NMUserMBoxRelation tables
**
** vobadm  2000/06/28 02:03:39   nbdbpop.sql \main\callpilot2.0\1 ~
** [callpilot2.0_setup]
**
** vobadm  2000/06/28 02:03:38   nbdbpop.sql \main\callpilot2.0\1 ~
** [callpilot2.0_setup]
**
** shingsc  2000/04/26 15:51:30   nbdbpop.sql \main\callpilot\b010707\3 ~
** [TC00334_b010707]
**
** shingsc  2000/04/26 15:51:28   nbdbpop.sql \main\callpilot\b010707\3 ~
** [TC00334_b010707]
**
** shingsc  2000/04/26 15:51:27   nbdbpop.sql \main\callpilot\b010707\3 ~
** [TC00334_b010707]
**
** shingsc  2000/04/26 15:10:25   nbdbpop.sql \main\callpilot\b010707\2 ~
** [TC00334_b010707]
**
** shingsc  2000/04/26 15:10:24   nbdbpop.sql \main\callpilot\b010707\2 ~
** [TC00334_b010707]
**
** shingsc  2000/04/26 15:10:23   nbdbpop.sql \main\callpilot\b010707\2 ~
** [TC00334_b010707]
**
** krejcm  2000/04/17 12:22:56   nbdbpop.sql \main\callpilot\b010707\1 ~
** [TC01832_b010709]
**
** krejcm  2000/04/17 12:22:55   nbdbpop.sql \main\callpilot\b010707\1 ~
** [TC01832_b010709]
**
** krejcm  2000/04/17 12:22:54   nbdbpop.sql \main\callpilot\b010707\1 ~
** [TC01832_b010709]
**
** acicb  98/6/10 14:12:36   nbdbpop.sql \main\r2\9 ~
** [BV79149] Changed password for default system admin.
**
** acicb  98/5/15 16:58:14   nbdbpop.sql \main\r2\8 ~
**
** johnlee  98/5/8 17:36:50   nbdbpop.sql \main\r2\7 ~
** remove comm port datafill.
**
** nbsbuild  98/4/8 18:56:5   nbdbpop.sql \main\r2\6 ~
**
** johnlee  98/4/6 10:56:13   nbdbpop.sql \main\r2\5 ~
** update with latest datafill
**
**#endif
*/

insert into NBCustomer
	(CustID, CustomerName, CustomerDescription) 
	values (1, 'Customer1', 'Initial Customer')
go

insert into NBTenant
	(TenantID, CustID, TenantName, TenantDescription) 
	values (1, 1, 'Tenant1', 'Initial Tenant')
go

insert into NBSecurity
	(IdlePCSession, MaxPCLoginTry, MinPCUserID, MaxPCUserID, MinPCPassword, MaxPCPassword, SPCustID,
		PCPasswordExp, PCPasswordWarn) 
	values (28800e0, 3, 1, 
		30, 6, 30, 1, 180, 7)
go







insert into NBGroup
	(GroupID, GroupName, GroupComment, CustID) 
	values (0x20e2b463f919cf11abfd000000000001, 'adminGroup', 'Blue system administration group', 1)
go

insert into NBGroup
	(GroupID, GroupName, GroupComment, CustID) 
	values (0x00000000000000000000000000000000, 'NilGroup', 'reserved Nil group', 1)
go

insert into NBGroupUserMapping
	(GroupID, UserID) 
	values (0x20e2b463f919cf11abfd000000000001, 0x20e2b463f919cf11abfd0020af3dfd34)
go


insert into NBOrg
	(OrgName) 
	values ('Nortel')
go

insert into NBConDesc
        (PromptID, PromptName, TabName, IndexPrompt, OpGroup, ValueGroup) 
        values (1, 'EQUAL', '=', 0, 0, 0)
go

insert into NBConDesc
        (PromptID, PromptName, TabName, IndexPrompt, OpGroup, ValueGroup) 
        values (2, 'NOTEQUAL', '<>', 0, 0, 0)
go

insert into NBConDesc
        (PromptID, PromptName, TabName, IndexPrompt, OpGroup, ValueGroup) 
        values (3, 'GREATER THAN', '>', 0, 0, 0)
go

insert into NBConDesc
        (PromptID, PromptName, TabName, IndexPrompt, OpGroup, ValueGroup) 
        values (4, 'LESS THAN', '<', 0, 0, 0)
go

insert into NBConDesc
        (PromptID, PromptName, TabName, IndexPrompt, OpGroup, ValueGroup) 
        values (500, 'LOCKED OUT', '1', 0, 0, 0)
go

insert into NBConDesc
        (PromptID, PromptName, TabName, IndexPrompt, OpGroup, ValueGroup) 
        values (501, 'NOT LOCKED OUT', '0', 0, 0, 0)
go

insert into NBConDesc
        (PromptID, PromptName, TabName, IndexPrompt, OpGroup, ValueGroup) 
        values (998, 'NOT LIKE', 'NOT LIKE', 0, 0, 0)
go

insert into NBConDesc
        (PromptID, PromptName, TabName, IndexPrompt, OpGroup, ValueGroup) 
        values (999, 'LIKE', 'LIKE', 0, 0, 0)
go

insert into NBConDesc
        (PromptID, PromptName, TabName, IndexPrompt, OpGroup, ValueGroup, ExportsPR) 
        values (1001, 'UserSurName', 'NBUser', 22001, 2, 0, 22001)
go

insert into NBConDesc
        (PromptID, PromptName, TabName, IndexPrompt, OpGroup, ValueGroup, ExportsPR) 
        values (1002, 'UserGivenName', 'NBUser', 22001, 2, 0, 22001)
go

insert into NBConDesc
        (PromptID, PromptName, TabName, IndexPrompt, OpGroup, ValueGroup, ExportsPR) 
        values (1003, 'UserDepartment', 'NBUser', 22001, 2, 0, 22001)
go

insert into NBConDesc
        (PromptID, PromptName, TabName, IndexPrompt, OpGroup, ValueGroup, ExportsPR) 
        values (1004, 'UserTitle', 'NBUser', 22001, 2, 0, 22001)
go

insert into NBConDesc
        (PromptID, PromptName, TabName, IndexPrompt, OpGroup, ValueGroup, ExportsPR) 
        values (1005, 'UserComment', 'NBUser', 22001, 2, 0, 22001)
go

insert into NBConDesc
        (PromptID, PromptName, TabName, IndexPrompt, OpGroup, ValueGroup, ExportsPR) 
        values (1006, 'PCUserID', 'NBPCUser', 22001, 2, 0, 22001)
go

insert into NBConDesc
        (PromptID, PromptName, TabName, IndexPrompt, OpGroup, ValueGroup, ExportsPR) 
        values (1007, 'PCLoginTry', 'NBPCUser', 22001, 3, 0, 22001)
go

insert into NBConDesc
        (PromptID, PromptName, TabName, IndexPrompt, OpGroup, ValueGroup, ExportsPR) 
        values (1008, 'PCLockout', 'NBPCUser', 22001, 1, 1000, 22001)
go

insert into NBConDesc
        (PromptID, PromptName, TabName, IndexPrompt, OpGroup, ValueGroup, ExportsPR) 
        values (1010, 'UserMiddleName', 'NBUser', 22001, 2, 0, 22001)
go

insert into NBConDesc
        (PromptID, PromptName, TabName, IndexPrompt, OpGroup, ValueGroup) 
        values (20000, 'Desktop Access Class', 'NBGroupUserMapping,NBGroup', 22000, 2, 0)
go

insert into NBConDesc
        (PromptID, PromptName, TabName, IndexPrompt, OpGroup, ValueGroup, ExportsPR) 
        values (22000, 'GroupName', 'NBGroup', 22002, 2, 0, 22001)
go

insert into NBConDesc
        (PromptID, PromptName, TabName, IndexPrompt, OpGroup, ValueGroup, ExportsPR) 
        values (22001, 'UserID', 'NBUser', 22001, 2, 0, 22001)
go

insert into NBConDesc
        (PromptID, PromptName, TabName, IndexPrompt, OpGroup, ValueGroup, ExportsPR) 
        values (22002, 'GroupID', 'NBGroup', 22002, 2, 0, 22001)
go

insert into NBConDesc
        (PromptID, PromptName, TabName, IndexPrompt, OpGroup, ValueGroup, ExportsPR) 
        values (22003, 'GroupID', 'NBGroupUserMapping', 22001, 2, 0, 22003)
go

insert into NBConDesc
        (PromptID, PromptName, TabName, IndexPrompt, OpGroup, ValueGroup, ExportsPR) 
        values (22004, 'UserID', 'NBGroupUserMapping', 22001, 2, 0, 22003)
go

if not exists (select 1 from NBConGroup where GroupID=1 and PromptID=1) then
   insert into NBConGroup (GroupID, PromptID) values (1, 1);
end if
go

if not exists (select 1 from NBConGroup where GroupID=2 and PromptID=1) then
   insert into NBConGroup (GroupID, PromptID) values (2, 1);
end if
go

if not exists (select 1 from NBConGroup where GroupID=2 and PromptID=2) then
   insert into NBConGroup (GroupID, PromptID) values (2, 2);
end if
go

if not exists (select 1 from NBConGroup where GroupID=3 and PromptID=1) then
   insert into NBConGroup (GroupID, PromptID) values (3, 1);
end if
go

if not exists (select 1 from NBConGroup where GroupID=3 and PromptID=2) then
   insert into NBConGroup (GroupID, PromptID) values (3, 2);
end if
go

if not exists (select 1 from NBConGroup where GroupID=3 and PromptID=3) then
   insert into NBConGroup (GroupID, PromptID) values (3, 3);
end if
go

if not exists (select 1 from NBConGroup where GroupID=3 and PromptID=4) then
   insert into NBConGroup (GroupID, PromptID) values (3, 4);
end if
go

if not exists (select 1 from NBConGroup where GroupID=1000 and PromptID=500) then
   insert into NBConGroup (GroupID, PromptID) values (1000, 500);
end if
go

if not exists (select 1 from NBConGroup where GroupID=1000 and PromptID=501) then
   insert into NBConGroup (GroupID, PromptID) values (1000, 501);
end if
go

insert into NBResDesc
        (ResID, CustID, ResData, ResDesc) 
        values (1, 1, '1001,1002,20000,1006,22001','Administration')
go

insert into NBResDesc
        (ResID, CustID, ResData, ResDesc) 
        values (2, 1, '1001,1002,1003,1004,1005,22001','General')
go

insert into NBSystemScheduleJob
	(NBJbID, CustId, JbRceTime, MilScnds, MthDay, TimeExt, Flags, JobDescrip, Command, ModifyNum, JobFreq, JobEndTime, JobLRTime)
	values (1, 1, 999900000, 4500000, 0, 180, 4352, 'OM Server daily audit', 'nbomcu.exe', 0, 0, 0, 0)
go

insert into NBSystemScheduleJob
	(NBJbID, CustId, JbRceTime, MilScnds, MthDay, TimeExt, Flags, JobDescrip, Command, ModifyNum, JobFreq, JobEndTime, JobLRTime)
	values (2, 1, 999900000, 0, 0, 15, 4352, 'OM Server daily broadcast [00:00:00]', 'nbombc.exe', 0, 0, 0, 0)
go

insert into NBSystemScheduleJob
	(NBJbID, CustId, JbRceTime, MilScnds, MthDay, TimeExt, Flags, JobDescrip, Command, ModifyNum, JobFreq, JobEndTime, JobLRTime)
	values (3, 1, 999900000, 3600000, 0, 15, 4352, 'OM Server daily broadcast [01:00:00]', 'nbombc.exe', 0, 0, 0, 0)
go

insert into NBSystemScheduleJob
	(NBJbID, CustId, JbRceTime, MilScnds, MthDay, TimeExt, Flags, JobDescrip, Command, ModifyNum, JobFreq, JobEndTime, JobLRTime)
	values (4, 1, 999900000, 7200000, 0, 15, 4352, 'OM Server daily broadcast [02:00:00]', 'nbombc.exe', 0, 0, 0, 0)
go

insert into NBSystemScheduleJob
	(NBJbID, CustId, JbRceTime, MilScnds, MthDay, TimeExt, Flags, JobDescrip, Command, ModifyNum, JobFreq, JobEndTime, JobLRTime)
	values (5, 1, 999900000, 10800000, 0, 15, 4352, 'OM Server daily broadcast [03:00:00]', 'nbombc.exe', 0, 0, 0, 0)
go

insert into NBSystemScheduleJob
	(NBJbID, CustId, JbRceTime, MilScnds, MthDay, TimeExt, Flags, JobDescrip, Command, ModifyNum, JobFreq, JobEndTime, JobLRTime)
	values (6, 1, 999900000, 14400000, 0, 15, 4352, 'OM Server daily broadcast [04:00:00]', 'nbombc.exe', 0, 0, 0, 0)
go

insert into NBSystemScheduleJob
	(NBJbID, CustId, JbRceTime, MilScnds, MthDay, TimeExt, Flags, JobDescrip, Command, ModifyNum, JobFreq, JobEndTime, JobLRTime)
	values (7, 1, 999900000, 18000000, 0, 15, 4352, 'OM Server daily broadcast [05:00:00]', 'nbombc.exe', 0, 0, 0, 0)
go

insert into NBSystemScheduleJob
	(NBJbID, CustId, JbRceTime, MilScnds, MthDay, TimeExt, Flags, JobDescrip, Command, ModifyNum, JobFreq, JobEndTime, JobLRTime)
	values (8, 1, 999900000, 21600000, 0, 15, 4352, 'OM Server daily broadcast [06:00:00]', 'nbombc.exe', 0, 0, 0, 0)
go

insert into NBSystemScheduleJob
	(NBJbID, CustId, JbRceTime, MilScnds, MthDay, TimeExt, Flags, JobDescrip, Command, ModifyNum, JobFreq, JobEndTime, JobLRTime)
	values (9, 1, 999900000, 25200000, 0, 15, 4352, 'OM Server daily broadcast [07:00:00]', 'nbombc.exe', 0, 0, 0, 0)
go

insert into NBSystemScheduleJob
	(NBJbID, CustId, JbRceTime, MilScnds, MthDay, TimeExt, Flags, JobDescrip, Command, ModifyNum, JobFreq, JobEndTime, JobLRTime)
	values (10, 1, 999900000, 28800000, 0, 15, 4352, 'OM Server daily broadcast [08:00:00]', 'nbombc.exe', 0, 0, 0, 0)
go

insert into NBSystemScheduleJob
	(NBJbID, CustId, JbRceTime, MilScnds, MthDay, TimeExt, Flags, JobDescrip, Command, ModifyNum, JobFreq, JobEndTime, JobLRTime)
	values (11, 1, 999900000, 32400000, 0, 15, 4352, 'OM Server daily broadcast [09:00:00]', 'nbombc.exe', 0, 0, 0, 0)
go

insert into NBSystemScheduleJob
	(NBJbID, CustId, JbRceTime, MilScnds, MthDay, TimeExt, Flags, JobDescrip, Command, ModifyNum, JobFreq, JobEndTime, JobLRTime)
	values (12, 1, 999900000, 36000000, 0, 15, 4352, 'OM Server daily broadcast [10:00:00]', 'nbombc.exe', 0, 0, 0, 0)
go

insert into NBSystemScheduleJob
	(NBJbID, CustId, JbRceTime, MilScnds, MthDay, TimeExt, Flags, JobDescrip, Command, ModifyNum, JobFreq, JobEndTime, JobLRTime)
	values (13, 1, 999900000, 39600000, 0, 15, 4352, 'OM Server daily broadcast [11:00:00]', 'nbombc.exe', 0, 0, 0, 0)
go

insert into NBSystemScheduleJob
	(NBJbID, CustId, JbRceTime, MilScnds, MthDay, TimeExt, Flags, JobDescrip, Command, ModifyNum, JobFreq, JobEndTime, JobLRTime)
	values (14, 1, 999900000, 43200000, 0, 15, 4352, 'OM Server daily broadcast [12:00:00]', 'nbombc.exe', 0, 0, 0, 0)
go

insert into NBSystemScheduleJob
	(NBJbID, CustId, JbRceTime, MilScnds, MthDay, TimeExt, Flags, JobDescrip, Command, ModifyNum, JobFreq, JobEndTime, JobLRTime)
	values (15, 1, 999900000, 46800000, 0, 15, 4352, 'OM Server daily broadcast [13:00:00]', 'nbombc.exe', 0, 0, 0, 0)
go

insert into NBSystemScheduleJob
	(NBJbID, CustId, JbRceTime, MilScnds, MthDay, TimeExt, Flags, JobDescrip, Command, ModifyNum, JobFreq, JobEndTime, JobLRTime)
	values (16, 1, 999900000, 50400000, 0, 15, 4352, 'OM Server daily broadcast [14:00:00]', 'nbombc.exe', 0, 0, 0, 0)
go

insert into NBSystemScheduleJob
	(NBJbID, CustId, JbRceTime, MilScnds, MthDay, TimeExt, Flags, JobDescrip, Command, ModifyNum, JobFreq, JobEndTime, JobLRTime)
	values (17, 1, 999900000, 54000000, 0, 15, 4352, 'OM Server daily broadcast [15:00:00]', 'nbombc.exe', 0, 0, 0, 0)
go

insert into NBSystemScheduleJob
	(NBJbID, CustId, JbRceTime, MilScnds, MthDay, TimeExt, Flags, JobDescrip, Command, ModifyNum, JobFreq, JobEndTime, JobLRTime)
	values (18, 1, 999900000, 57600000, 0, 15, 4352, 'OM Server daily broadcast [16:00:00]', 'nbombc.exe', 0, 0, 0, 0)
go

insert into NBSystemScheduleJob
	(NBJbID, CustId, JbRceTime, MilScnds, MthDay, TimeExt, Flags, JobDescrip, Command, ModifyNum, JobFreq, JobEndTime, JobLRTime)
	values (19, 1, 999900000, 61200000, 0, 15, 4352, 'OM Server daily broadcast [17:00:00]', 'nbombc.exe', 0, 0, 0, 0)
go

insert into NBSystemScheduleJob
	(NBJbID, CustId, JbRceTime, MilScnds, MthDay, TimeExt, Flags, JobDescrip, Command, ModifyNum, JobFreq, JobEndTime, JobLRTime)
	values (20, 1, 999900000, 64800000, 0, 15, 4352, 'OM Server daily broadcast [18:00:00]', 'nbombc.exe', 0, 0, 0, 0)
go

insert into NBSystemScheduleJob
	(NBJbID, CustId, JbRceTime, MilScnds, MthDay, TimeExt, Flags, JobDescrip, Command, ModifyNum, JobFreq, JobEndTime, JobLRTime)
	values (21, 1, 999900000, 68400000, 0, 15, 4352, 'OM Server daily broadcast [19:00:00]', 'nbombc.exe', 0, 0, 0, 0)
go

insert into NBSystemScheduleJob
	(NBJbID, CustId, JbRceTime, MilScnds, MthDay, TimeExt, Flags, JobDescrip, Command, ModifyNum, JobFreq, JobEndTime, JobLRTime)
	values (22, 1, 999900000, 72000000, 0, 15, 4352, 'OM Server daily broadcast [20:00:00]', 'nbombc.exe', 0, 0, 0, 0)
go

insert into NBSystemScheduleJob
	(NBJbID, CustId, JbRceTime, MilScnds, MthDay, TimeExt, Flags, JobDescrip, Command, ModifyNum, JobFreq, JobEndTime, JobLRTime)
	values (23, 1, 999900000, 75600000, 0, 15, 4352, 'OM Server daily broadcast [21:00:00]', 'nbombc.exe', 0, 0, 0, 0)
go

insert into NBSystemScheduleJob
	(NBJbID, CustId, JbRceTime, MilScnds, MthDay, TimeExt, Flags, JobDescrip, Command, ModifyNum, JobFreq, JobEndTime, JobLRTime)
	values (24, 1, 999900000, 79200000, 0, 15, 4352, 'OM Server daily broadcast [22:00:00]', 'nbombc.exe', 0, 0, 0, 0)
go

insert into NBSystemScheduleJob
	(NBJbID, CustId, JbRceTime, MilScnds, MthDay, TimeExt, Flags, JobDescrip, Command, ModifyNum, JobFreq, JobEndTime, JobLRTime)
	values (25, 1, 999900000, 82800000, 0, 15, 4352, 'OM Server daily broadcast [23:00:00]', 'nbombc.exe', 0, 0, 0, 0)
go

insert into NBSystemScheduleJob
	(NBJbID, CustId, JbRceTime, MilScnds, MthDay, TimeExt, Flags, JobDescrip, Command, ModifyNum, JobFreq, JobEndTime, JobLRTime)
	values (26, 1, 999900000, 8100000, 0, 180, 4352, 'Audio Conference daily audit', 'confaudit.exe', 0, 0, 0, 0)
go

insert into NBSystemScheduleJob
	(NBJbID, CustId, JbRceTime, MilScnds, MthDay, TimeExt, Flags, JobDescrip, Command, ModifyNum, JobFreq, JobEndTime, JobLRTime)
	values (27, 1, 999900000, 900000, 1, 180, 5120, 'Email master key changed synchronization', 'nmcrypt_updtkey.exe', 0, 0, 0, 0)
go

insert into NBFltSysSettings (SysSettingsName, SysEventLogCheckPeriod) values ('Default', 2)
go

insert into NMClientApps (ClientAppID, ClientAppName) values (1, 'Application Builder')
go

insert into NMClientApps (ClientAppID, ClientAppName) values (2, 'CallPilot Manager')
go