小弟也來個中興的腳本
<?xml version="1.0" encoding="GB2312"?>
<BTSINFO>
<VERSION READONLY="true">0830020500000000</VERSION>
<EDIT_AREA>
<BTS SYSTEM="507" ALIAS="紫云狗場_DO+紫云牛場坡_DO">
<CELL_1X>
<CELL CELLID_READONLY="0" PHYCELLID_READONLY="0" CI="5073" PILOT_PN="90" REG_ZONE="853" LAC="2131" MSCOFFICEID="255" />
<CELL CELLID_READONLY="1" PHYCELLID_READONLY="1" CI="15073" PILOT_PN="258" REG_ZONE="853" LAC="2131" MSCOFFICEID="255" />
<CELL CELLID_READONLY="2" PHYCELLID_READONLY="2" CI="25073" PILOT_PN="54" REG_ZONE="853" LAC="2131" MSCOFFICEID="255" />
</CELL_1X>
<CELL_DO>
<CELL CELLID_READONLY="0" PHYCELLID_READONLY="0" PILOT_PN="90" SUBNETINDEXID="0" SECTORID="00-A8-C0-00-6E-00-00-00-AC-17-BC-2D-1E-03-1F-B0" />
<CELL CELLID_READONLY="1" PHYCELLID_READONLY="1" PILOT_PN="258" SUBNETINDEXID="0" SECTORID="00-A8-C0-00-6E-00-00-00-AC-17-BC-2D-1E-03-1F-B1" />
<CELL CELLID_READONLY="2" PHYCELLID_READONLY="2" PILOT_PN="54" SUBNETINDEXID="0" SECTORID="00-A8-C0-00-6E-00-00-00-AC-17-BC-2D-1E-03-1F-B2" />
</CELL_DO>
</BTS>
</EDIT_AREA>
<READONLY_AREA>
<ASSISTANT_AREA>
<COMMON BTSTYPE="0" BTSVERSION="32" ISINCLUDEDOCELL="true" CELLNUM_DO="3" ISINCLUDEDOCHM="true" CELLNUM_1X="3" FWDPOWER1X="true" BTSPARAMETER="true" CELLNUM="3" />
<CARRIERLIST FREQNUMBER="2" CARRIERIDS="0,1" CARRIERNUM_1X="3" CARRIERNUM_DO="3">
<CARRIER CARRIERID="0" CDMA_FREQ="283" BAND_CLASS="0" />
<CARRIER CARRIERID="1" CDMA_FREQ="37" BAND_CLASS="0" />
</CARRIERLIST>
</ASSISTANT_AREA>
<SQLSCRIPT>
<SQL>update b_sysfunction set flag = 0,starttime = getdate()</SQL>
<!--b_board_face-->
<!--devid_b,system,rackno_face,rackno,shelfno_face,shelfno,slotno_face,slotno,subsystem,unit,unittype_b,racktype,groupid_b-->
<SQL>insert into b_board_face (devid_b,system,rackno_face,rackno,shelfno_face,shelfno,slotno_face,slotno,subsystem,unit,unittype_b,racktype,groupid_b) values (#DEVID_B#,#SYSTEM#,1,1,1,1,2,2,0,0,35200,81,0)</SQL>
<SQL>insert into b_board_face (devid_b,system,rackno_face,rackno,shelfno_face,shelfno,slotno_face,slotno,subsystem,unit,unittype_b,racktype,groupid_b) values (#DEVID_B#,#SYSTEM#,1,1,1,1,4,4,0,13,35220,81,0)</SQL>
<SQL>insert into b_board_face (devid_b,system,rackno_face,rackno,shelfno_face,shelfno,slotno_face,slotno,subsystem,unit,unittype_b,racktype,groupid_b) values (#DEVID_B#,#SYSTEM#,1,1,1,1,7,7,0,5,35211,81,0)</SQL>
<SQL>insert into b_board_face (devid_b,system,rackno_face,rackno,shelfno_face,shelfno,slotno_face,slotno,subsystem,unit,unittype_b,racktype,groupid_b) values (#DEVID_B#,#SYSTEM#,1,1,1,1,8,8,0,6,35280,81,0)</SQL>
<SQL>insert into b_board_face (devid_b,system,rackno_face,rackno,shelfno_face,shelfno,slotno_face,slotno,subsystem,unit,unittype_b,racktype,groupid_b) values (#DEVID_B#,#SYSTEM#,1,1,1,1,13,13,0,11,35230,81,0)</SQL>
<SQL>insert into b_board_face (devid_b,system,rackno_face,rackno,shelfno_face,shelfno,slotno_face,slotno,subsystem,unit,unittype_b,racktype,groupid_b) values (#DEVID_B#,#SYSTEM#,1,1,1,1,15,15,0,16,35250,81,0)</SQL>
<SQL>insert into b_board_face (devid_b,system,rackno_face,rackno,shelfno_face,shelfno,slotno_face,slotno,subsystem,unit,unittype_b,racktype,groupid_b) values (#DEVID_B#,#SYSTEM#,2,2,1,1,1,1,5,0,35260,80,5)</SQL>
<SQL>insert into b_board_face (devid_b,system,rackno_face,rackno,shelfno_face,shelfno,slotno_face,slotno,subsystem,unit,unittype_b,racktype,groupid_b) values (#DEVID_B#,#SYSTEM#,3,3,1,1,1,1,6,0,35260,80,6)</SQL>
<SQL>insert into b_board_face (devid_b,system,rackno_face,rackno,shelfno_face,shelfno,slotno_face,slotno,subsystem,unit,unittype_b,racktype,groupid_b) values (#DEVID_B#,#SYSTEM#,4,4,1,1,1,1,7,0,35260,80,7)</SQL>
<!--b_shelf_face-->
<!--devid_b,system,rackno_face,rackno,shelfno_face,shelfno,racktype,shelftype,shelfpos_b,subsystem_b,groupid_b-->
<SQL>insert into b_shelf_face (devid_b,system,rackno_face,rackno,shelfno_face,shelfno,racktype,shelftype,shelfpos_b,subsystem_b,groupid_b) values (#DEVID_B#,#SYSTEM#,1,1,1,1,81,24,1,0,0)</SQL>
<SQL>insert into b_shelf_face (devid_b,system,rackno_face,rackno,shelfno_face,shelfno,racktype,shelftype,shelfpos_b,subsystem_b,groupid_b) values (#DEVID_B#,#SYSTEM#,2,2,1,1,80,149,1,5,5)</SQL>
<SQL>insert into b_shelf_face (devid_b,system,rackno_face,rackno,shelfno_face,shelfno,racktype,shelftype,shelfpos_b,subsystem_b,groupid_b) values (#DEVID_B#,#SYSTEM#,3,3,1,1,80,149,1,6,6)</SQL>
<SQL>insert into b_shelf_face (devid_b,system,rackno_face,rackno,shelfno_face,shelfno,racktype,shelftype,shelfpos_b,subsystem_b,groupid_b) values (#DEVID_B#,#SYSTEM#,4,4,1,1,80,149,1,7,7)</SQL>
<!--b_rack_face-->
<!--devid_b,system,rackno_face,rackno,racktype,groupid_b-->
<SQL>insert into b_rack_face (devid_b,system,rackno_face,rackno,racktype,groupid_b) values (#DEVID_B#,#SYSTEM#,1,1,81,0)</SQL>
<SQL>insert into b_rack_face (devid_b,system,rackno_face,rackno,racktype,groupid_b) values (#DEVID_B#,#SYSTEM#,2,2,80,5)</SQL>
<SQL>insert into b_rack_face (devid_b,system,rackno_face,rackno,racktype,groupid_b) values (#DEVID_B#,#SYSTEM#,3,3,80,6)</SQL>
<SQL>insert into b_rack_face (devid_b,system,rackno_face,rackno,racktype,groupid_b) values (#DEVID_B#,#SYSTEM#,4,4,80,7)</SQL>
<!--B_SYSTEM-->
<!--DEVID_B,SYSTEM,BTSTYPE,BTSVERSION,LOCATIONNAME,USERdEFINEDsTATE,SWVERSION,ALIAS_B,UCFSNCHECK,ABISMODE,SERIALNUMBER,RESERVED1,RESERVED2,RESERVED3,TESTE1WIDTH,POWERTYPE,ENABLECLOSEFWDRIM,CLOSEFWDRIM,OPENFWDRIM,CFRTIMER,BSMODE,ENABLEDISDELAY,UPSINFO,WORKTIME_START,WORKTIME_END,isAllowAllShutdown,SRACKMODE,ABISALLOCRULE,CRCMODE,MultiPlexing,province,CITY,county,address,PktLen,SndPktNum,SndPktTime,ReportCycle,DetectSwitch,CheckCrRfstatus-->
<SQL>insert into B_SYSTEM (DEVID_B,SYSTEM,BTSTYPE,BTSVERSION,LOCATIONNAME,USERdEFINEDsTATE,SWVERSION,ALIAS_B,UCFSNCHECK,ABISMODE,SERIALNUMBER,RESERVED1,RESERVED2,RESERVED3,TESTE1WIDTH,POWERTYPE,ENABLECLOSEFWDRIM,CLOSEFWDRIM,OPENFWDRIM,CFRTIMER,BSMODE,ENABLEDISDELAY,UPSINFO,WORKTIME_START,WORKTIME_END,isAllowAllShutdown,SRACKMODE,ABISALLOCRULE,CRCMODE,MultiPlexing,province,CITY,county,address,PktLen,SndPktNum,SndPktTime,ReportCycle,DetectSwitch,CheckCrRfstatus) values (#DEVID_B#,#SYSTEM#,0,32,NULL,NULL,NULL,'#BTS_ALIAS_B#',1,0x01,'',NULL,NULL,NULL,0,0,0,7,66,60,0,0,0,0,0,0,0,NULL,0,0,NULL,NULL,NULL,NULL,68,1,20,6,0,0)</SQL>
<!--B_SENSORCFG-->
<!--devid_b,system,subsystem,sensorid,lowlimit,highlimit,isconfigure,cabinettype-->
<SQL>insert into B_SENSORCFG (devid_b,system,subsystem,sensorid,lowlimit,highlimit,isconfigure,cabinettype) values (#DEVID_B#,#SYSTEM#,0,93,-20,55,1,'DSDR B8200')</SQL>
<SQL>insert into B_SENSORCFG (devid_b,system,subsystem,sensorid,lowlimit,highlimit,isconfigure,cabinettype) values (#DEVID_B#,#SYSTEM#,0,94,-5,70,1,'DSDR B8200')</SQL>
<SQL>insert into B_SENSORCFG (devid_b,system,subsystem,sensorid,lowlimit,highlimit,isconfigure,cabinettype) values (#DEVID_B#,#SYSTEM#,0,95,40,58,1,'DSDR B8200')</SQL>
<SQL>insert into B_SENSORCFG (devid_b,system,subsystem,sensorid,lowlimit,highlimit,isconfigure,cabinettype) values (#DEVID_B#,#SYSTEM#,0,107,65,70,1,'DSDR B8200')</SQL>
<!--B_BTSTCP-->
<!--devid_b,system,switch1,switch2,switch3,switch4,switch5,switch6,switch7,switch8,switch9,switch10-->
<SQL>insert into B_BTSTCP (devid_b,system,switch1,switch2,switch3,switch4,switch5,switch6,switch7,switch8,switch9,switch10) values (#DEVID_B#,#SYSTEM#,0,0,0,0,0,0,0,0,0,0)</SQL>
<!--B_SUBSYSTEM-->
<!--DEVID_B,SYSTEM,SUBSYSTEM,MASTERUNITID,WFWDDELAY,WBACKDELAY,RFSWORKMODE,SUBSYSTEMTYPE,RFSID,BSSID,NODE,PORT,PATHNO,ISREMOTERFS,EXCHANGEMODE,SUBSYSSTATUS,GPSConDelay,GPSConMode,CascadeLineLength,dealmode,powerconslot,powertype,PASpsMode,GroupIDFor1588,SerialNoInGroup,MasterFlagFor1588,CastModeFor1588,LMTIP,LMTPort-->
<SQL>insert into B_SUBSYSTEM (DEVID_B,SYSTEM,SUBSYSTEM,MASTERUNITID,WFWDDELAY,WBACKDELAY,RFSWORKMODE,SUBSYSTEMTYPE,RFSID,BSSID,NODE,PORT,PATHNO,ISREMOTERFS,EXCHANGEMODE,SUBSYSSTATUS,GPSConDelay,GPSConMode,CascadeLineLength,dealmode,powerconslot,powertype,PASpsMode,GroupIDFor1588,SerialNoInGroup,MasterFlagFor1588,CastModeFor1588,LMTIP,LMTPort) values (#DEVID_B#,#SYSTEM#,0,0,0,0,255,1,0,0,7,0,1,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0x7f000001,23)</SQL>
<SQL>insert into B_SUBSYSTEM (DEVID_B,SYSTEM,SUBSYSTEM,MASTERUNITID,WFWDDELAY,WBACKDELAY,RFSWORKMODE,SUBSYSTEMTYPE,RFSID,BSSID,NODE,PORT,PATHNO,ISREMOTERFS,EXCHANGEMODE,SUBSYSSTATUS,GPSConDelay,GPSConMode,CascadeLineLength,dealmode,powerconslot,powertype,PASpsMode,GroupIDFor1588,SerialNoInGroup,MasterFlagFor1588,CastModeFor1588,LMTIP,LMTPort) values (#DEVID_B#,#SYSTEM#,5,0,0,0,2,3,0,0,7,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0x7f000001,23)</SQL>
<SQL>insert into B_SUBSYSTEM (DEVID_B,SYSTEM,SUBSYSTEM,MASTERUNITID,WFWDDELAY,WBACKDELAY,RFSWORKMODE,SUBSYSTEMTYPE,RFSID,BSSID,NODE,PORT,PATHNO,ISREMOTERFS,EXCHANGEMODE,SUBSYSSTATUS,GPSConDelay,GPSConMode,CascadeLineLength,dealmode,powerconslot,powertype,PASpsMode,GroupIDFor1588,SerialNoInGroup,MasterFlagFor1588,CastModeFor1588,LMTIP,LMTPort) values (#DEVID_B#,#SYSTEM#,6,0,0,0,2,3,1,0,7,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0x7f000001,23)</SQL>
<SQL>insert into B_SUBSYSTEM (DEVID_B,SYSTEM,SUBSYSTEM,MASTERUNITID,WFWDDELAY,WBACKDELAY,RFSWORKMODE,SUBSYSTEMTYPE,RFSID,BSSID,NODE,PORT,PATHNO,ISREMOTERFS,EXCHANGEMODE,SUBSYSSTATUS,GPSConDelay,GPSConMode,CascadeLineLength,dealmode,powerconslot,powertype,PASpsMode,GroupIDFor1588,SerialNoInGroup,MasterFlagFor1588,CastModeFor1588,LMTIP,LMTPort) values (#DEVID_B#,#SYSTEM#,7,0,0,0,2,3,2,0,7,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0x7f000001,23)</SQL>
<!--b_gnode-->
<!--devid_b,system,subsystem,rackno_face,shelfno_face,slotno_face,rackno,shelfno,slotno,unittype_b,boardname,gnodenumber,GNODE1,CODE1,GNODE2,CODE2,GNODE3,CODE3,GNODE4,CODE4,GNODE5,CODE5,GNODE6,CODE6,GNODE7,CODE7,GNODE8,CODE8,GNODE9,CODE9,GNODE10,CODE10,GNODE11,CODE11,GNODE12,CODE12,GNODE13,CODE13,GNODE14,CODE14,GNODE15,CODE15,GNODE16,CODE16,GNODE17,CODE17,GNODE18,CODE18,GNODE19,CODE19,GNODE20,CODE20-->
<SQL>insert into b_gnode (devid_b,system,subsystem,rackno_face,shelfno_face,slotno_face,rackno,shelfno,slotno,unittype_b,boardname,gnodenumber,GNODE1,CODE1,GNODE2,CODE2,GNODE3,CODE3,GNODE4,CODE4,GNODE5,CODE5,GNODE6,CODE6,GNODE7,CODE7,GNODE8,CODE8,GNODE9,CODE9,GNODE10,CODE10,GNODE11,CODE11,GNODE12,CODE12,GNODE13,CODE13,GNODE14,CODE14,GNODE15,CODE15,GNODE16,CODE16,GNODE17,CODE17,GNODE18,CODE18,GNODE19,CODE19,GNODE20,CODE20) values (#DEVID_B#,#SYSTEM#,0,1,1,13,1,1,13,35230,'SA',8,2,1005001,2,1005001,2,1005001,2,1005001,2,1005001,2,1005001,2,1005001,2,1005001,2,1005001,2,1005001,2,1005001,2,1005001,2,1005001,2,1005001,2,1005001,2,1005001,2,1005001,2,1005001,2,1005001,2,1005001)</SQL>
<SQL>insert into b_gnode (devid_b,system,subsystem,rackno_face,shelfno_face,slotno_face,rackno,shelfno,slotno,unittype_b,boardname,gnodenumber,GNODE1,CODE1,GNODE2,CODE2,GNODE3,CODE3,GNODE4,CODE4,GNODE5,CODE5,GNODE6,CODE6,GNODE7,CODE7,GNODE8,CODE8,GNODE9,CODE9,GNODE10,CODE10,GNODE11,CODE11,GNODE12,CODE12,GNODE13,CODE13,GNODE14,CODE14,GNODE15,CODE15,GNODE16,CODE16,GNODE17,CODE17,GNODE18,CODE18,GNODE19,CODE19,GNODE20,CODE20) values (#DEVID_B#,#SYSTEM#,5,2,1,1,2,1,1,35260,'RTRA',4,2,1005001,2,1005001,2,1005001,2,1005001,2,1005001,2,1005001,2,1005001,2,1005001,2,1005001,2,1005001,2,1005001,2,1005001,2,1005001,2,1005001,2,1005001,2,1005001,2,1005001,2,1005001,2,1005001,2,1005001)</SQL>
<SQL>insert into b_gnode (devid_b,system,subsystem,rackno_face,shelfno_face,slotno_face,rackno,shelfno,slotno,unittype_b,boardname,gnodenumber,GNODE1,CODE1,GNODE2,CODE2,GNODE3,CODE3,GNODE4,CODE4,GNODE5,CODE5,GNODE6,CODE6,GNODE7,CODE7,GNODE8,CODE8,GNODE9,CODE9,GNODE10,CODE10,GNODE11,CODE11,GNODE12,CODE12,GNODE13,CODE13,GNODE14,CODE14,GNODE15,CODE15,GNODE16,CODE16,GNODE17,CODE17,GNODE18,CODE18,GNODE19,CODE19,GNODE20,CODE20) values (#DEVID_B#,#SYSTEM#,6,3,1,1,3,1,1,35260,'RTRA',4,2,1005001,2,1005001,2,1005001,2,1005001,2,1005001,2,1005001,2,1005001,2,1005001,2,1005001,2,1005001,2,1005001,2,1005001,2,1005001,2,1005001,2,1005001,2,1005001,2,1005001,2,1005001,2,1005001,2,1005001)</SQL>
<SQL>insert into b_gnode (devid_b,system,subsystem,rackno_face,shelfno_face,slotno_face,rackno,shelfno,slotno,unittype_b,boardname,gnodenumber,GNODE1,CODE1,GNODE2,CODE2,GNODE3,CODE3,GNODE4,CODE4,GNODE5,CODE5,GNODE6,CODE6,GNODE7,CODE7,GNODE8,CODE8,GNODE9,CODE9,GNODE10,CODE10,GNODE11,CODE11,GNODE12,CODE12,GNODE13,CODE13,GNODE14,CODE14,GNODE15,CODE15,GNODE16,CODE16,GNODE17,CODE17,GNODE18,CODE18,GNODE19,CODE19,GNODE20,CODE20) values (#DEVID_B#,#SYSTEM#,7,4,1,1,4,1,1,35260,'RTRA',4,2,1005001,2,1005001,2,1005001,2,1005001,2,1005001,2,1005001,2,1005001,2,1005001,2,1005001,2,1005001,2,1005001,2,1005001,2,1005001,2,1005001,2,1005001,2,1005001,2,1005001,2,1005001,2,1005001,2,1005001)</SQL>
<!--b_vlanid-->
<!--devid_b,system,subsystem,ServiceType,COS,VLanID-->
<SQL>insert into b_vlanid (devid_b,system,subsystem,ServiceType,COS,VLanID) values (#DEVID_B#,#SYSTEM#,0,0,255,65535)</SQL>
<SQL>insert into b_vlanid (devid_b,system,subsystem,ServiceType,COS,VLanID) values (#DEVID_B#,#SYSTEM#,0,3,255,65535)</SQL>
<SQL>insert into b_vlanid (devid_b,system,subsystem,ServiceType,COS,VLanID) values (#DEVID_B#,#SYSTEM#,0,8,255,65535)</SQL>
<!--B_UNIT-->
<!--DEVID_B,SYSTEM,SUBSYSTEM,UNIT,UNITTYPE,SERIALNO,PP2SDELAY,PUBINFO,BACKMODE,CPUVERSIONINFO,MEDIANETSPEED,vswrthreshold,bscpubinfo-->
<SQL>insert into B_UNIT (DEVID_B,SYSTEM,SUBSYSTEM,UNIT,UNITTYPE,SERIALNO,PP2SDELAY,PUBINFO,BACKMODE,CPUVERSIONINFO,MEDIANETSPEED,vswrthreshold,bscpubinfo) values (#DEVID_B#,#SYSTEM#,0,0,35200,0,0,1,1,0,100,0,352321537)</SQL>
<SQL>insert into B_UNIT (DEVID_B,SYSTEM,SUBSYSTEM,UNIT,UNITTYPE,SERIALNO,PP2SDELAY,PUBINFO,BACKMODE,CPUVERSIONINFO,MEDIANETSPEED,vswrthreshold,bscpubinfo) values (#DEVID_B#,#SYSTEM#,0,5,35211,0,0,0,0,0,100,0,0)</SQL>
<SQL>insert into B_UNIT (DEVID_B,SYSTEM,SUBSYSTEM,UNIT,UNITTYPE,SERIALNO,PP2SDELAY,PUBINFO,BACKMODE,CPUVERSIONINFO,MEDIANETSPEED,vswrthreshold,bscpubinfo) values (#DEVID_B#,#SYSTEM#,0,6,35280,0,0,0,0,0,100,0,0)</SQL>
<SQL>insert into B_UNIT (DEVID_B,SYSTEM,SUBSYSTEM,UNIT,UNITTYPE,SERIALNO,PP2SDELAY,PUBINFO,BACKMODE,CPUVERSIONINFO,MEDIANETSPEED,vswrthreshold,bscpubinfo) values (#DEVID_B#,#SYSTEM#,0,11,35230,0,0,0,0,0,100,0,0)</SQL>
<SQL>insert into B_UNIT (DEVID_B,SYSTEM,SUBSYSTEM,UNIT,UNITTYPE,SERIALNO,PP2SDELAY,PUBINFO,BACKMODE,CPUVERSIONINFO,MEDIANETSPEED,vswrthreshold,bscpubinfo) values (#DEVID_B#,#SYSTEM#,0,13,35220,0,0,0,0,0,100,0,0)</SQL>
<SQL>insert into B_UNIT (DEVID_B,SYSTEM,SUBSYSTEM,UNIT,UNITTYPE,SERIALNO,PP2SDELAY,PUBINFO,BACKMODE,CPUVERSIONINFO,MEDIANETSPEED,vswrthreshold,bscpubinfo) values (#DEVID_B#,#SYSTEM#,0,16,35250,0,0,200,1,0,100,0,0)</SQL>
<SQL>insert into B_UNIT (DEVID_B,SYSTEM,SUBSYSTEM,UNIT,UNITTYPE,SERIALNO,PP2SDELAY,PUBINFO,BACKMODE,CPUVERSIONINFO,MEDIANETSPEED,vswrthreshold,bscpubinfo) values (#DEVID_B#,#SYSTEM#,5,0,35260,0,0,-16514112,0,0,100,250,0)</SQL>
<SQL>insert into B_UNIT (DEVID_B,SYSTEM,SUBSYSTEM,UNIT,UNITTYPE,SERIALNO,PP2SDELAY,PUBINFO,BACKMODE,CPUVERSIONINFO,MEDIANETSPEED,vswrthreshold,bscpubinfo) values (#DEVID_B#,#SYSTEM#,6,0,35260,0,0,-16514112,0,0,100,250,0)</SQL>
<SQL>insert into B_UNIT (DEVID_B,SYSTEM,SUBSYSTEM,UNIT,UNITTYPE,SERIALNO,PP2SDELAY,PUBINFO,BACKMODE,CPUVERSIONINFO,MEDIANETSPEED,vswrthreshold,bscpubinfo) values (#DEVID_B#,#SYSTEM#,7,0,35260,0,0,-16514112,0,0,100,250,0)</SQL>
<!--H_ADCTRL_PARA-->
<!--DEVID_B,SYSTEM,SUBSYSTEM,UNIT,ADCTRLENABLED,ADCTRLCYCLEPERIOD,ACFLTCONSTTIMEUTLZ,ACFLTCONSTAVGTHRPUT,ACFLTCONSTDROPRATE,ACMINDROPRATEEFFLOW1,ACCSCTDROPRATEEFFLOW1,ACMINDROPRATEEFFLOW2,ACMINTIMEUTIEFFLOW2,ACMINTOTALQOSTIMEDGAF,ACMINTHRPTNOTDOWNAF1,ACCSCTTHRPUTDOWNAF1,ACMINTHRPTNOTDOWNAF2,ACMINTIMEUTILZDOWNAF2,ACMAXTIMEUTIADMNEWEF,ACMAXQOSTIMEADMNEWAF,ACMINCYCLEBEFUPGRADE,ACFLTCONSTAVGDRC,ACNEWCALLAVGDRCPERIOD-->
<!--R_3G_T_FWDPOWER_1X-->
<!--BSSID,SYSTEM,OFFICEid,FPC_32XSCH_MIN_PWR,FPC_16XSCH_MIN_PWR,FPC_8XSCH_MIN_PWR,FPC_4XSCH_MIN_PWR,FPC_2XSCH_MIN_PWR,FPC_RCC2_FCH_PWR_V,FPC_RCC2_FCH_PWR_D,NOMINAL_PWR1_VOICE,NOMINAL_PWR1_DATA,NOMINAL_PWR2_VOICE,NOMINAL_PWR2_DATA,NOMINAL_PWR3_VOICE,NOMINAL_PWR3_DATA,DELTA_PWR1_VOICE,DELTA_PWR1_DATA,DELTA_PWR2_VOICE,DELTA_PWR2_DATA,DELTA_PWR3_VOICE,DELTA_PWR3_DATA,PWR_STEPSIZE_UP1,PWR_STEPSIZE_UP2,PWR_STEPSIZE_UP3,PWR_STEPSIZE_DOWN1,PWR_STEPSIZE_DOWN2,PWR_STEPSIZE_DOWN3,FPC_SCH_MIN_PWR,FPC_RCC2_FCHINIT_PWR,FPC_16X8XSCH_MAX_PWR,FPC_4X2XSCH_MAX_PWR,FWDTXPWRREPENABLE,FWDTXPWRREPPERIOD,FCHPWRREPENABLE,FCHPWRREPPERIOD,RSCHECIOREPENABLE,RSCHECIOREPPERIOD,PTT_PWR_STEP_UP1,PTT_PWR_STEP_UP2,PTT_PWR_STEP_UP3,PTT_PWR_STEP_DOWN1,PTT_PWR_STEP_DOWN2,PTT_PWR_STEP_DOWN3,Delta_SCH_MAX_P,P_UP,P_DOWN,FPC_SCH_32X_MAX,SCH_NOM_PWR_1,SCH_NOM_PWR_2,SCH_NOM_PWR_3,SCHDeltalPwr_1,SCHDeltalPwr_2,SCHDeltalPwr_3,SCHPwrStepUp_1,SCHPwrStepUp_2,SCHPwrStepUp_3,SCHPwrStepDown_1,SCHPwrStepDown_2,SCHPwrStepDown_3,SCHFPCSubChanGain_1,SCHFPCSubChanGain_2,SCHFPCSubChanGain_3,FPC_FCH_INI_PWR_PTT,delta_rcc2_fch_ini_p,fch_power_threshold,ExpEnergyPwrOptiEnbl,FCH_INIT_PWR_UP,ExpEnergyEraFrmNum,Switch1,Switch2,Switch3,Switch4,Switch5,Switch6,Switch7,Switch8,Switch9,Switch10,NOMINAL_PWR1_PTT,NOMINAL_PWR2_PTT,NOMINAL_PWR3_PTT,DELTA_PWR1_PTT,DELTA_PWR2_PTT,DELTA_PWR3_PTT,FSNRejectSendAlm,FSNRejectLmt,FSNRejectTimeLmt,T_ABIS_Delta,AllowMinFSCHDurCode,AllowMaxFSCHDurCode,EPNUpdThd,FOLCtrlTactic,Switch11,Switch12,Switch13,Switch14,Switch15,Switch16,Switch17,Switch18,Switch19,Switch20,PTTSNCAMSendPeriod,FPC_16XSCH_MAX_PWR,FPC_8XSCH_MAX_PWR,FPC_4XSCH_MAX_PWR,FPC_2XSCH_MAX_PWR,Delta_FSCH_PWR,MaxPwrThreshold,StartIOCheck,IOPeriod,IOMax,IOMin-->
<SQL>insert into R_3G_T_FWDPOWER_1X (BSSID,SYSTEM,OFFICEid,FPC_32XSCH_MIN_PWR,FPC_16XSCH_MIN_PWR,FPC_8XSCH_MIN_PWR,FPC_4XSCH_MIN_PWR,FPC_2XSCH_MIN_PWR,FPC_RCC2_FCH_PWR_V,FPC_RCC2_FCH_PWR_D,NOMINAL_PWR1_VOICE,NOMINAL_PWR1_DATA,NOMINAL_PWR2_VOICE,NOMINAL_PWR2_DATA,NOMINAL_PWR3_VOICE,NOMINAL_PWR3_DATA,DELTA_PWR1_VOICE,DELTA_PWR1_DATA,DELTA_PWR2_VOICE,DELTA_PWR2_DATA,DELTA_PWR3_VOICE,DELTA_PWR3_DATA,PWR_STEPSIZE_UP1,PWR_STEPSIZE_UP2,PWR_STEPSIZE_UP3,PWR_STEPSIZE_DOWN1,PWR_STEPSIZE_DOWN2,PWR_STEPSIZE_DOWN3,FPC_SCH_MIN_PWR,FPC_RCC2_FCHINIT_PWR,FPC_16X8XSCH_MAX_PWR,FPC_4X2XSCH_MAX_PWR,FWDTXPWRREPENABLE,FWDTXPWRREPPERIOD,FCHPWRREPENABLE,FCHPWRREPPERIOD,RSCHECIOREPENABLE,RSCHECIOREPPERIOD,PTT_PWR_STEP_UP1,PTT_PWR_STEP_UP2,PTT_PWR_STEP_UP3,PTT_PWR_STEP_DOWN1,PTT_PWR_STEP_DOWN2,PTT_PWR_STEP_DOWN3,Delta_SCH_MAX_P,P_UP,P_DOWN,FPC_SCH_32X_MAX,SCH_NOM_PWR_1,SCH_NOM_PWR_2,SCH_NOM_PWR_3,SCHDeltalPwr_1,SCHDeltalPwr_2,SCHDeltalPwr_3,SCHPwrStepUp_1,SCHPwrStepUp_2,SCHPwrStepUp_3,SCHPwrStepDown_1,SCHPwrStepDown_2,SCHPwrStepDown_3,SCHFPCSubChanGain_1,SCHFPCSubChanGain_2,SCHFPCSubChanGain_3,FPC_FCH_INI_PWR_PTT,delta_rcc2_fch_ini_p,fch_power_threshold,ExpEnergyPwrOptiEnbl,FCH_INIT_PWR_UP,ExpEnergyEraFrmNum,Switch1,Switch2,Switch3,Switch4,Switch5,Switch6,Switch7,Switch8,Switch9,Switch10,NOMINAL_PWR1_PTT,NOMINAL_PWR2_PTT,NOMINAL_PWR3_PTT,DELTA_PWR1_PTT,DELTA_PWR2_PTT,DELTA_PWR3_PTT,FSNRejectSendAlm,FSNRejectLmt,FSNRejectTimeLmt,T_ABIS_Delta,AllowMinFSCHDurCode,AllowMaxFSCHDurCode,EPNUpdThd,FOLCtrlTactic,Switch11,Switch12,Switch13,Switch14,Switch15,Switch16,Switch17,Switch18,Switch19,Switch20,PTTSNCAMSendPeriod,FPC_16XSCH_MAX_PWR,FPC_8XSCH_MAX_PWR,FPC_4XSCH_MAX_PWR,FPC_2XSCH_MAX_PWR,Delta_FSCH_PWR,MaxPwrThreshold,StartIOCheck,IOPeriod,IOMax,IOMin) values (#DEVID_B#,#SYSTEM#,NULL,163,163,163,163,163,179,179,169,169,175,175,171,171,80,80,40,40,32,32,4,2,1,4,2,1,163,179,219,215,1,10,0,50,0,50,4,2,1,4,2,1,6,45,60,225,195,195,195,80,80,80,4,2,1,4,2,1,0,0,0,179,0,75,0,24,10,300,0,0,0,0,1,25,0,1,0,169,171,167,68,48,40,0,10,60,2,10,14,3,0,0,0,0,0,0,0,0,0,0,0,5,219,219,215,215,4,199,0,2,22,15)</SQL>
<!--R_3G_T_CELL-->
<!--BSSID,SYSTEM,CELLID,SID,NID,LAC,CI,PILOT_PN,PILOT_INC,SRCH_WIN_A,SRCH_WIN_N,SRCH_WIN_R,NGHBR_MAX_AGE,RESCAN,RLGAIN_TRAFFIC_PILOT,RLGAIN_SCH_PILOT,RADIUS,P_REV,MIN_P_REV,STANDARDP_REV_SUPPORT,BASE_LAT,BASE_LONG,T_MULCHAN,ENC_SUPPORTED,RCCLASS2_SUPPORT,NGHBR_CELL_NUM,HANDOFFMODE,T_COMP_PS,STATUS,Over_LAC_INCL1,Over_LAC1,Over_LAC_INCL2,Over_LAC2,RESERVED1,RESERVED2,STDSYNCCH,GOS_B,BAND_CLASS,CELLMODE,MaxRACHSearchFra,MaxRACHSeparation,DLA_ID,alias_b,Switch1,Switch2,Switch3,Switch4,Switch5,Switch6,Switch7,Switch8,Switch9,Switch10,PTT_BCAST_INDEX,SIGN_SLOT_CYCLE_IND,MAX_PTT_SCI,FIX_SEARCH_WINDOW,PR_LENGTH,TR_LENGTH,MAX_RESEND_NUM,DiversityMode,sectorLoc,MaxCallDistance,CarrierKeepPwr_Voice,CarrierKeepPwr_Data,LoadBalancePwr_Voice,LoadBalancePwr_Data,CarrierKeepFCH_Voice,CarrierKeepFCH_Data,LoadBalanceFCH_Voice,LoadBalanceFCH_Data,mscofficeid,EVRCBOperatingPoint,HARDHANDOFF_COMP,HARDHANDOFF_TIMER,PTT_RLGAIN_ADJ,SIGNAL_PWRSTEP,PTT_RLGAINADJ_NOACK,PTT_RLGAINADJ_EXT,ServiceRestrictMode,phycellID,IsSamePNSector,RefCellId,longlatlock_b,DLA_HIGH,DLA_LOW,PTTBC_PILOT_REPORT,base_lat_b,base_long_b,PTTBC_SNCAMPwrAdj,sceneType-->
<SQL>insert into R_3G_T_CELL (BSSID,SYSTEM,CELLID,SID,NID,LAC,CI,PILOT_PN,PILOT_INC,SRCH_WIN_A,SRCH_WIN_N,SRCH_WIN_R,NGHBR_MAX_AGE,RESCAN,RLGAIN_TRAFFIC_PILOT,RLGAIN_SCH_PILOT,RADIUS,P_REV,MIN_P_REV,STANDARDP_REV_SUPPORT,BASE_LAT,BASE_LONG,T_MULCHAN,ENC_SUPPORTED,RCCLASS2_SUPPORT,NGHBR_CELL_NUM,HANDOFFMODE,T_COMP_PS,STATUS,Over_LAC_INCL1,Over_LAC1,Over_LAC_INCL2,Over_LAC2,RESERVED1,RESERVED2,STDSYNCCH,GOS_B,BAND_CLASS,CELLMODE,MaxRACHSearchFra,MaxRACHSeparation,DLA_ID,alias_b,Switch1,Switch2,Switch3,Switch4,Switch5,Switch6,Switch7,Switch8,Switch9,Switch10,PTT_BCAST_INDEX,SIGN_SLOT_CYCLE_IND,MAX_PTT_SCI,FIX_SEARCH_WINDOW,PR_LENGTH,TR_LENGTH,MAX_RESEND_NUM,DiversityMode,sectorLoc,MaxCallDistance,CarrierKeepPwr_Voice,CarrierKeepPwr_Data,LoadBalancePwr_Voice,LoadBalancePwr_Data,CarrierKeepFCH_Voice,CarrierKeepFCH_Data,LoadBalanceFCH_Voice,LoadBalanceFCH_Data,mscofficeid,EVRCBOperatingPoint,HARDHANDOFF_COMP,HARDHANDOFF_TIMER,PTT_RLGAIN_ADJ,SIGNAL_PWRSTEP,PTT_RLGAINADJ_NOACK,PTT_RLGAINADJ_EXT,ServiceRestrictMode,phycellID,IsSamePNSector,RefCellId,longlatlock_b,DLA_HIGH,DLA_LOW,PTTBC_PILOT_REPORT,base_lat_b,base_long_b,PTTBC_SNCAMPwrAdj,sceneType) values (#DEVID_B#,#SYSTEM#,0,14244,11,#CELL_1X_0_LAC#,#CELL_1X_0_CI#,#CELL_1X_0_PILOT_PN#,3,10,11,12,0,0,0,0,256,6,2,20,372779,1527970,0,0,1,NULL,0,4,0,0,0,0,0,0,0,0,2,0,0,16,80,6689,'#CELL_1X_0_ALIAS_B#',0,0,0,0,0,0,0,0,0,0,6,0,1,1,2,2,2,0,0,65535,50,50,20,20,15,3,3,1,'#CELL_1X_0_MSCOFFICEID#',0,3,3,0,4,4,0,0,0,0,0,0,6,545,0,'25.8874','106.109',8,0)</SQL>
<SQL>insert into R_3G_T_CELL (BSSID,SYSTEM,CELLID,SID,NID,LAC,CI,PILOT_PN,PILOT_INC,SRCH_WIN_A,SRCH_WIN_N,SRCH_WIN_R,NGHBR_MAX_AGE,RESCAN,RLGAIN_TRAFFIC_PILOT,RLGAIN_SCH_PILOT,RADIUS,P_REV,MIN_P_REV,STANDARDP_REV_SUPPORT,BASE_LAT,BASE_LONG,T_MULCHAN,ENC_SUPPORTED,RCCLASS2_SUPPORT,NGHBR_CELL_NUM,HANDOFFMODE,T_COMP_PS,STATUS,Over_LAC_INCL1,Over_LAC1,Over_LAC_INCL2,Over_LAC2,RESERVED1,RESERVED2,STDSYNCCH,GOS_B,BAND_CLASS,CELLMODE,MaxRACHSearchFra,MaxRACHSeparation,DLA_ID,alias_b,Switch1,Switch2,Switch3,Switch4,Switch5,Switch6,Switch7,Switch8,Switch9,Switch10,PTT_BCAST_INDEX,SIGN_SLOT_CYCLE_IND,MAX_PTT_SCI,FIX_SEARCH_WINDOW,PR_LENGTH,TR_LENGTH,MAX_RESEND_NUM,DiversityMode,sectorLoc,MaxCallDistance,CarrierKeepPwr_Voice,CarrierKeepPwr_Data,LoadBalancePwr_Voice,LoadBalancePwr_Data,CarrierKeepFCH_Voice,CarrierKeepFCH_Data,LoadBalanceFCH_Voice,LoadBalanceFCH_Data,mscofficeid,EVRCBOperatingPoint,HARDHANDOFF_COMP,HARDHANDOFF_TIMER,PTT_RLGAIN_ADJ,SIGNAL_PWRSTEP,PTT_RLGAINADJ_NOACK,PTT_RLGAINADJ_EXT,ServiceRestrictMode,phycellID,IsSamePNSector,RefCellId,longlatlock_b,DLA_HIGH,DLA_LOW,PTTBC_PILOT_REPORT,base_lat_b,base_long_b,PTTBC_SNCAMPwrAdj,sceneType) values (#DEVID_B#,#SYSTEM#,1,14244,11,#CELL_1X_1_LAC#,#CELL_1X_1_CI#,#CELL_1X_1_PILOT_PN#,3,10,11,12,0,0,0,0,256,6,2,20,372779,1527970,0,0,1,NULL,0,4,0,0,0,0,0,0,0,0,2,0,0,16,80,6689,'#CELL_1X_1_ALIAS_B#',0,0,0,0,0,0,0,0,0,0,6,0,1,1,2,2,2,0,0,65535,50,50,20,20,15,3,3,1,'#CELL_1X_1_MSCOFFICEID#',0,3,3,0,4,4,0,0,1,0,1,0,6,545,0,'25.8874','106.109',8,0)</SQL>
<SQL>insert into R_3G_T_CELL (BSSID,SYSTEM,CELLID,SID,NID,LAC,CI,PILOT_PN,PILOT_INC,SRCH_WIN_A,SRCH_WIN_N,SRCH_WIN_R,NGHBR_MAX_AGE,RESCAN,RLGAIN_TRAFFIC_PILOT,RLGAIN_SCH_PILOT,RADIUS,P_REV,MIN_P_REV,STANDARDP_REV_SUPPORT,BASE_LAT,BASE_LONG,T_MULCHAN,ENC_SUPPORTED,RCCLASS2_SUPPORT,NGHBR_CELL_NUM,HANDOFFMODE,T_COMP_PS,STATUS,Over_LAC_INCL1,Over_LAC1,Over_LAC_INCL2,Over_LAC2,RESERVED1,RESERVED2,STDSYNCCH,GOS_B,BAND_CLASS,CELLMODE,MaxRACHSearchFra,MaxRACHSeparation,DLA_ID,alias_b,Switch1,Switch2,Switch3,Switch4,Switch5,Switch6,Switch7,Switch8,Switch9,Switch10,PTT_BCAST_INDEX,SIGN_SLOT_CYCLE_IND,MAX_PTT_SCI,FIX_SEARCH_WINDOW,PR_LENGTH,TR_LENGTH,MAX_RESEND_NUM,DiversityMode,sectorLoc,MaxCallDistance,CarrierKeepPwr_Voice,CarrierKeepPwr_Data,LoadBalancePwr_Voice,LoadBalancePwr_Data,CarrierKeepFCH_Voice,CarrierKeepFCH_Data,LoadBalanceFCH_Voice,LoadBalanceFCH_Data,mscofficeid,EVRCBOperatingPoint,HARDHANDOFF_COMP,HARDHANDOFF_TIMER,PTT_RLGAIN_ADJ,SIGNAL_PWRSTEP,PTT_RLGAINADJ_NOACK,PTT_RLGAINADJ_EXT,ServiceRestrictMode,phycellID,IsSamePNSector,RefCellId,longlatlock_b,DLA_HIGH,DLA_LOW,PTTBC_PILOT_REPORT,base_lat_b,base_long_b,PTTBC_SNCAMPwrAdj,sceneType) values (#DEVID_B#,#SYSTEM#,2,14244,11,#CELL_1X_2_LAC#,#CELL_1X_2_CI#,#CELL_1X_2_PILOT_PN#,3,10,11,12,0,0,0,0,256,6,2,20,373207,1528266,0,0,1,NULL,0,4,0,0,0,0,0,0,0,0,2,0,0,16,80,6689,'#CELL_1X_2_ALIAS_B#',0,0,0,0,0,0,0,0,0,0,6,0,1,1,2,2,2,0,0,65535,50,50,20,20,15,3,3,1,'#CELL_1X_2_MSCOFFICEID#',0,3,3,0,4,4,0,0,2,0,2,0,6,545,0,'25.917153','106.129583',8,0)</SQL>
<!--R_3g_T_EcamRepPara-->
<!--BSSID,SYSTEM,CELLID,AcchoEcamRepNum,AccEcamRepOrigDly,AccEcamRepOrigDly0,AccEcamRepOrigDly1,AccEcamRepOrigDly2,AccEcamRepOrigDly3,AccEcamRepOrigDly4,AccEcamRepNOrigDly,AccEcamRepNOrigDly0,AccEcamRepNOrigDly1,AccEcamRepNOrigDly2,AccEcamRepNOrigDly3,AccEcamRepNOrigDly4,EcamRepDly,EcamRepDly0,EcamRepDly1,EcamRepDly2,EcamRepDly3,EcamRepDly4,MAXECAMCAMPwr,ECAMCAMPwrStep-->
<SQL>insert into R_3g_T_EcamRepPara (BSSID,SYSTEM,CELLID,AcchoEcamRepNum,AccEcamRepOrigDly,AccEcamRepOrigDly0,AccEcamRepOrigDly1,AccEcamRepOrigDly2,AccEcamRepOrigDly3,AccEcamRepOrigDly4,AccEcamRepNOrigDly,AccEcamRepNOrigDly0,AccEcamRepNOrigDly1,AccEcamRepNOrigDly2,AccEcamRepNOrigDly3,AccEcamRepNOrigDly4,EcamRepDly,EcamRepDly0,EcamRepDly1,EcamRepDly2,EcamRepDly3,EcamRepDly4,MAXECAMCAMPwr,ECAMCAMPwrStep) values (#DEVID_B#,#SYSTEM#,0,3,900,0,100,300,500,500,1000,600,100,100,200,300,900,0,100,300,500,500,220,1)</SQL>
<SQL>insert into R_3g_T_EcamRepPara (BSSID,SYSTEM,CELLID,AcchoEcamRepNum,AccEcamRepOrigDly,AccEcamRepOrigDly0,AccEcamRepOrigDly1,AccEcamRepOrigDly2,AccEcamRepOrigDly3,AccEcamRepOrigDly4,AccEcamRepNOrigDly,AccEcamRepNOrigDly0,AccEcamRepNOrigDly1,AccEcamRepNOrigDly2,AccEcamRepNOrigDly3,AccEcamRepNOrigDly4,EcamRepDly,EcamRepDly0,EcamRepDly1,EcamRepDly2,EcamRepDly3,EcamRepDly4,MAXECAMCAMPwr,ECAMCAMPwrStep) values (#DEVID_B#,#SYSTEM#,1,3,900,0,100,300,500,500,1000,600,100,100,200,300,900,0,100,300,500,500,220,1)</SQL>
<SQL>insert into R_3g_T_EcamRepPara (BSSID,SYSTEM,CELLID,AcchoEcamRepNum,AccEcamRepOrigDly,AccEcamRepOrigDly0,AccEcamRepOrigDly1,AccEcamRepOrigDly2,AccEcamRepOrigDly3,AccEcamRepOrigDly4,AccEcamRepNOrigDly,AccEcamRepNOrigDly0,AccEcamRepNOrigDly1,AccEcamRepNOrigDly2,AccEcamRepNOrigDly3,AccEcamRepNOrigDly4,EcamRepDly,EcamRepDly0,EcamRepDly1,EcamRepDly2,EcamRepDly3,EcamRepDly4,MAXECAMCAMPwr,ECAMCAMPwrStep) values (#DEVID_B#,#SYSTEM#,2,3,900,0,100,300,500,500,1000,600,100,100,200,300,900,0,100,300,500,500,220,1)</SQL>
關(guān)注樓主