OptionCode.sql 41 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026
  1. /*
  2. Navicat SQL Server Data Transfer
  3. Source Server : 9000
  4. Source Server Version : 105000
  5. Source Host : .\sqlexpress:1433
  6. Source Database : LHBMS
  7. Source Schema : dbo
  8. Target Server Type : SQL Server
  9. Target Server Version : 105000
  10. File Encoding : 65001
  11. Date: 2021-05-11 15:33:37
  12. */
  13. -- ----------------------------
  14. -- Table structure for OptionCode
  15. -- ----------------------------
  16. DROP TABLE [dbo].[OptionCode]
  17. GO
  18. CREATE TABLE [dbo].[OptionCode] (
  19. [ID] int NOT NULL IDENTITY(1,1) ,
  20. [OptionID] int NULL ,
  21. [ItemName] nvarchar(50) NULL ,
  22. [ItemValue] int NULL
  23. )
  24. GO
  25. DBCC CHECKIDENT(N'[dbo].[OptionCode]', RESEED, 325)
  26. GO
  27. -- ----------------------------
  28. -- Records of OptionCode
  29. -- ----------------------------
  30. SET IDENTITY_INSERT [dbo].[OptionCode] ON
  31. GO
  32. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'1', N'0', N'1', N'1')
  33. GO
  34. GO
  35. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'2', N'0', N'2', N'2')
  36. GO
  37. GO
  38. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'3', N'0', N'3', N'3')
  39. GO
  40. GO
  41. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'4', N'0', N'4', N'4')
  42. GO
  43. GO
  44. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'5', N'0', N'5', N'5')
  45. GO
  46. GO
  47. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'6', N'0', N'6', N'6')
  48. GO
  49. GO
  50. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'7', N'0', N'7', N'7')
  51. GO
  52. GO
  53. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'8', N'0', N'8', N'8')
  54. GO
  55. GO
  56. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'9', N'0', N'9', N'9')
  57. GO
  58. GO
  59. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'10', N'1', N'ConntentID', N'5')
  60. GO
  61. GO
  62. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'11', N'1', N'4+1', N'10')
  63. GO
  64. GO
  65. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'12', N'2', N'报警输出', N'1')
  66. GO
  67. GO
  68. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'13', N'2', N'火警输出', N'2')
  69. GO
  70. GO
  71. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'14', N'2', N'布防输出', N'3')
  72. GO
  73. GO
  74. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'15', N'3', N'出入防区', N'1')
  75. GO
  76. GO
  77. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'16', N'3', N'活动防区', N'2')
  78. GO
  79. GO
  80. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'17', N'3', N'周边防区', N'3')
  81. GO
  82. GO
  83. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'18', N'3', N'求助防区', N'4')
  84. GO
  85. GO
  86. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'19', N'3', N'火警防区', N'5')
  87. GO
  88. GO
  89. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'20', N'3', N'煤气防区', N'6')
  90. GO
  91. GO
  92. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'21', N'3', N'防拆防区', N'7')
  93. GO
  94. GO
  95. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'22', N'3', N'挟持防区', N'8')
  96. GO
  97. GO
  98. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'23', N'0', N'不远程控制', N'153')
  99. GO
  100. GO
  101. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'24', N'4', N'中心1,2都发一遍', N'1')
  102. GO
  103. GO
  104. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'25', N'4', N'中心1发成功不再发', N'2')
  105. GO
  106. GO
  107. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'26', N'5', N'外出布防', N'1')
  108. GO
  109. GO
  110. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'27', N'5', N'留守布防', N'2')
  111. GO
  112. GO
  113. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'28', N'5', N'表示撤防', N'3')
  114. GO
  115. GO
  116. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'29', N'7', N'15分钟', N'1')
  117. GO
  118. GO
  119. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'30', N'7', N'30分钟', N'2')
  120. GO
  121. GO
  122. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'31', N'7', N'1小时', N'3')
  123. GO
  124. GO
  125. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'32', N'7', N'2小时', N'4')
  126. GO
  127. GO
  128. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'33', N'7', N'4小时', N'5')
  129. GO
  130. GO
  131. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'34', N'7', N'6小时', N'6')
  132. GO
  133. GO
  134. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'35', N'7', N'8小时', N'7')
  135. GO
  136. GO
  137. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'36', N'7', N'12小时', N'8')
  138. GO
  139. GO
  140. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'37', N'7', N'16小时', N'9')
  141. GO
  142. GO
  143. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'38', N'7', N'24小时', N'10')
  144. GO
  145. GO
  146. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'39', N'8', N'15分钟', N'1')
  147. GO
  148. GO
  149. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'40', N'8', N'30分钟', N'2')
  150. GO
  151. GO
  152. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'41', N'8', N'1小时', N'3')
  153. GO
  154. GO
  155. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'42', N'8', N'2小时', N'4')
  156. GO
  157. GO
  158. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'43', N'8', N'4小时', N'5')
  159. GO
  160. GO
  161. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'44', N'8', N'12小时', N'6')
  162. GO
  163. GO
  164. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'45', N'8', N'24小时', N'7')
  165. GO
  166. GO
  167. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'46', N'8', N'不发送', N'0')
  168. GO
  169. GO
  170. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'47', N'8', N'7天', N'8')
  171. GO
  172. GO
  173. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'48', N'8', N'14天', N'9')
  174. GO
  175. GO
  176. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'49', N'8', N'21天', N'10')
  177. GO
  178. GO
  179. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'50', N'8', N'30天', N'11')
  180. GO
  181. GO
  182. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'51', N'8', N'布防状态1小时', N'80')
  183. GO
  184. GO
  185. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'52', N'8', N'布防状态2小时', N'81')
  186. GO
  187. GO
  188. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'53', N'8', N'布防状态4小时', N'82')
  189. GO
  190. GO
  191. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'54', N'8', N'布防状态12小时', N'83')
  192. GO
  193. GO
  194. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'55', N'8', N'布防状态24小时', N'84')
  195. GO
  196. GO
  197. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'56', N'9', N'15分钟', N'1')
  198. GO
  199. GO
  200. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'57', N'9', N'30分钟', N'2')
  201. GO
  202. GO
  203. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'58', N'9', N'1小时', N'3')
  204. GO
  205. GO
  206. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'59', N'9', N'2小时', N'4')
  207. GO
  208. GO
  209. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'60', N'9', N'4小时', N'5')
  210. GO
  211. GO
  212. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'61', N'10', N'ConntentID', N'85')
  213. GO
  214. GO
  215. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'62', N'10', N'4+1', N'170')
  216. GO
  217. GO
  218. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'63', N'11', N'延时1', N'1')
  219. GO
  220. GO
  221. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'64', N'11', N'延时2', N'2')
  222. GO
  223. GO
  224. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'65', N'11', N'即报', N'3')
  225. GO
  226. GO
  227. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'66', N'11', N'内部', N'4')
  228. GO
  229. GO
  230. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'67', N'11', N'内部/在家/出外设防', N'5')
  231. GO
  232. GO
  233. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'68', N'11', N'延时/在家/出外设防', N'6')
  234. GO
  235. GO
  236. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'69', N'11', N'24小时火警延时(有线)', N'7')
  237. GO
  238. GO
  239. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'70', N'11', N'标准24小时火警(有线)', N'8')
  240. GO
  241. GO
  242. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'71', N'11', N'24小时盗警', N'9')
  243. GO
  244. GO
  245. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'72', N'11', N'24小时劫持', N'10')
  246. GO
  247. GO
  248. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'73', N'11', N'24小时气体', N'11')
  249. GO
  250. GO
  251. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'74', N'11', N'24小时热感应', N'12')
  252. GO
  253. GO
  254. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'75', N'11', N'24小时医疗', N'13')
  255. GO
  256. GO
  257. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'76', N'11', N'24小时惊慌', N'14')
  258. GO
  259. GO
  260. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'77', N'11', N'24小时紧急', N'15')
  261. GO
  262. GO
  263. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'78', N'11', N'24小时喷淋', N'16')
  264. GO
  265. GO
  266. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'79', N'11', N'24小时水感应', N'17')
  267. GO
  268. GO
  269. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'80', N'11', N'24小时冻结感应器', N'18')
  270. GO
  271. GO
  272. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'81', N'11', N'24小时防拆', N'19')
  273. GO
  274. GO
  275. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'82', N'11', N'24小时监测', N'20')
  276. GO
  277. GO
  278. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'83', N'11', N'24小时监测蜂鸣器', N'21')
  279. GO
  280. GO
  281. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'84', N'11', N'24小时小时火警延时(无线)', N'71')
  282. GO
  283. GO
  284. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'85', N'11', N'标准24小时火警(无线)', N'72')
  285. GO
  286. GO
  287. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'86', N'12', N'分区/系统设防状态', N'1')
  288. GO
  289. GO
  290. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'87', N'12', N'备妥输出', N'2')
  291. GO
  292. GO
  293. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'88', N'12', N'系统故障输出', N'3')
  294. GO
  295. GO
  296. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'89', N'12', N'跟随键盘蜂鸣器', N'4')
  297. GO
  298. GO
  299. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'90', N'12', N'跟随报警输出', N'5')
  300. GO
  301. GO
  302. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'91', N'12', N'命令输出1', N'6')
  303. GO
  304. GO
  305. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'92', N'12', N'命令输出2', N'7')
  306. GO
  307. GO
  308. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'93', N'12', N'命令输出3', N'8')
  309. GO
  310. GO
  311. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'94', N'12', N'命令输出4', N'9')
  312. GO
  313. GO
  314. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'95', N'12', N'烟感探测器复位', N'10')
  315. GO
  316. GO
  317. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'96', N'12', N'跟随脉冲', N'11')
  318. GO
  319. GO
  320. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'97', N'12', N'跟随警号', N'12')
  321. GO
  322. GO
  323. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'98', N'12', N'系统防拆', N'13')
  324. GO
  325. GO
  326. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'99', N'12', N'电话线故障和报警', N'14')
  327. GO
  328. GO
  329. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'100', N'12', N'断开连接', N'15')
  330. GO
  331. GO
  332. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'101', N'12', N'拨号', N'16')
  333. GO
  334. GO
  335. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'102', N'12', N'远程操作', N'17')
  336. GO
  337. GO
  338. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'103', N'13', N'常闭回路', N'1')
  339. GO
  340. GO
  341. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'104', N'13', N'单线尾电阻回路', N'2')
  342. GO
  343. GO
  344. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'105', N'13', N'双线尾电阻回路', N'3')
  345. GO
  346. GO
  347. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'106', N'13', N'双防区', N'4')
  348. GO
  349. GO
  350. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'107', N'14', N'静音', N'224')
  351. GO
  352. GO
  353. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'108', N'14', N'第一级音量', N'225')
  354. GO
  355. GO
  356. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'109', N'14', N'第二级音量', N'226')
  357. GO
  358. GO
  359. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'110', N'14', N'第三级音量', N'227')
  360. GO
  361. GO
  362. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'111', N'14', N'第四级音量', N'228')
  363. GO
  364. GO
  365. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'112', N'14', N'第五级音量', N'229')
  366. GO
  367. GO
  368. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'113', N'14', N'第六级音量', N'230')
  369. GO
  370. GO
  371. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'114', N'14', N'第七级音量', N'231')
  372. GO
  373. GO
  374. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'115', N'15', N'禁用', N'0')
  375. GO
  376. GO
  377. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'116', N'15', N'无线防区1报警', N'1')
  378. GO
  379. GO
  380. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'117', N'15', N'无线防区2报警', N'2')
  381. GO
  382. GO
  383. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'118', N'15', N'无线防区3报警', N'3')
  384. GO
  385. GO
  386. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'119', N'15', N'无线防区4报警', N'4')
  387. GO
  388. GO
  389. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'120', N'15', N'无线防区5报警', N'5')
  390. GO
  391. GO
  392. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'121', N'15', N'无线防区6报警', N'6')
  393. GO
  394. GO
  395. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'122', N'15', N'无线防区7报警', N'7')
  396. GO
  397. GO
  398. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'123', N'15', N'无线防区8报警', N'8')
  399. GO
  400. GO
  401. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'124', N'15', N'无线防区9报警', N'9')
  402. GO
  403. GO
  404. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'125', N'15', N'无线防区10报警', N'16')
  405. GO
  406. GO
  407. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'126', N'15', N'无线防区11报警', N'17')
  408. GO
  409. GO
  410. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'127', N'15', N'无线防区12报警', N'18')
  411. GO
  412. GO
  413. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'128', N'15', N'无线防区13报警', N'19')
  414. GO
  415. GO
  416. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'129', N'15', N'无线防区14报警', N'20')
  417. GO
  418. GO
  419. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'130', N'15', N'无线防区15报警', N'21')
  420. GO
  421. GO
  422. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'131', N'15', N'无线防区16报警', N'22')
  423. GO
  424. GO
  425. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'132', N'15', N'防区17报警', N'23')
  426. GO
  427. GO
  428. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'133', N'15', N'防区18报警', N'24')
  429. GO
  430. GO
  431. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'134', N'15', N'防区19报警', N'25')
  432. GO
  433. GO
  434. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'135', N'15', N'有线防区1报警', N'33')
  435. GO
  436. GO
  437. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'136', N'15', N'有线防区2报警', N'34')
  438. GO
  439. GO
  440. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'137', N'15', N'防区30主机防拆', N'48')
  441. GO
  442. GO
  443. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'138', N'15', N'1和2键同时按下', N'128')
  444. GO
  445. GO
  446. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'139', N'15', N'电话线故障后开启10秒', N'129')
  447. GO
  448. GO
  449. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'140', N'15', N'外出布防', N'130')
  450. GO
  451. GO
  452. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'141', N'15', N'留守布防', N'131')
  453. GO
  454. GO
  455. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'142', N'15', N'撤防', N'132')
  456. GO
  457. GO
  458. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'143', N'15', N'跟随警号', N'133')
  459. GO
  460. GO
  461. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'144', N'15', N'出入防区报警', N'145')
  462. GO
  463. GO
  464. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'145', N'15', N'活动防区报警', N'146')
  465. GO
  466. GO
  467. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'146', N'15', N'周界防区报警', N'147')
  468. GO
  469. GO
  470. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'147', N'15', N'求助防区报警', N'148')
  471. GO
  472. GO
  473. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'148', N'15', N'火警防区报警', N'149')
  474. GO
  475. GO
  476. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'149', N'15', N'煤气防区报警', N'150')
  477. GO
  478. GO
  479. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'150', N'15', N'防拆防区报警', N'151')
  480. GO
  481. GO
  482. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'151', N'15', N'挟持防区报警', N'152')
  483. GO
  484. GO
  485. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'152', N'16', N'任何时候', N'0')
  486. GO
  487. GO
  488. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'153', N'16', N'撤防时', N'1')
  489. GO
  490. GO
  491. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'154', N'16', N'不可用', N'2')
  492. GO
  493. GO
  494. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'155', N'17', N'中心1,2都发一遍', N'85')
  495. GO
  496. GO
  497. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'156', N'17', N'中心1发成功不再发', N'170')
  498. GO
  499. GO
  500. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'157', N'18', N'不发送测试', N'0')
  501. GO
  502. GO
  503. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'158', N'18', N'15分钟', N'15')
  504. GO
  505. GO
  506. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'159', N'18', N'30分钟', N'30')
  507. GO
  508. GO
  509. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'160', N'18', N'撤防状态下1小时/布防状态下1小时', N'60')
  510. GO
  511. GO
  512. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'161', N'18', N'撤防状态下2小时/布防状态下2小时', N'120')
  513. GO
  514. GO
  515. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'162', N'18', N'撤防状态下4小时/布防状态下4小时', N'240')
  516. GO
  517. GO
  518. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'163', N'18', N'撤防状态下12小时/布防状态下12小时', N'720')
  519. GO
  520. GO
  521. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'164', N'18', N'撤防状态下24小时/布防状态下24小时', N'1440')
  522. GO
  523. GO
  524. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'165', N'18', N'7天', N'10080')
  525. GO
  526. GO
  527. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'166', N'18', N'14天', N'20160')
  528. GO
  529. GO
  530. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'167', N'18', N'21天', N'30240')
  531. GO
  532. GO
  533. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'168', N'18', N'30天', N'43200')
  534. GO
  535. GO
  536. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'169', N'19', N'不发送测试', N'0')
  537. GO
  538. GO
  539. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'170', N'19', N'15分钟', N'15')
  540. GO
  541. GO
  542. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'171', N'19', N'30分钟', N'30')
  543. GO
  544. GO
  545. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'172', N'19', N'1小时', N'60')
  546. GO
  547. GO
  548. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'173', N'19', N'2小时', N'120')
  549. GO
  550. GO
  551. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'174', N'19', N'4小时', N'240')
  552. GO
  553. GO
  554. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'175', N'19', N'12小时', N'720')
  555. GO
  556. GO
  557. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'176', N'19', N'24小时', N'1440')
  558. GO
  559. GO
  560. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'177', N'19', N'7天', N'10080')
  561. GO
  562. GO
  563. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'178', N'19', N'14天', N'20160')
  564. GO
  565. GO
  566. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'179', N'19', N'21天', N'30240')
  567. GO
  568. GO
  569. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'180', N'19', N'30天', N'43200')
  570. GO
  571. GO
  572. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'181', N'19', N'6小时', N'360')
  573. GO
  574. GO
  575. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'182', N'19', N'8小时', N'480')
  576. GO
  577. GO
  578. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'183', N'19', N'16小时', N'960')
  579. GO
  580. GO
  581. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'184', N'20', N'布防时发送', N'85')
  582. GO
  583. GO
  584. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'185', N'20', N'撤防时发送', N'170')
  585. GO
  586. GO
  587. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'186', N'21', N'全局布防', N'2')
  588. GO
  589. GO
  590. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'187', N'21', N'周界布防', N'4')
  591. GO
  592. GO
  593. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'188', N'21', N'撤防', N'0')
  594. GO
  595. GO
  596. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'189', N'22', N'关闭', N'0')
  597. GO
  598. GO
  599. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'190', N'22', N'活动防区', N'1')
  600. GO
  601. GO
  602. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'191', N'22', N'周边防区', N'2')
  603. GO
  604. GO
  605. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'192', N'22', N'求助防区', N'3')
  606. GO
  607. GO
  608. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'193', N'22', N'24小时防区', N'4')
  609. GO
  610. GO
  611. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'194', N'22', N'延时1', N'5')
  612. GO
  613. GO
  614. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'195', N'22', N'延时2', N'6')
  615. GO
  616. GO
  617. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'196', N'22', N'内部出入口跟随', N'7')
  618. GO
  619. GO
  620. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'197', N'22', N'内部留守外出', N'8')
  621. GO
  622. GO
  623. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'198', N'22', N'白昼即时', N'9')
  624. GO
  625. GO
  626. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'199', N'22', N'布撤防防区', N'10')
  627. GO
  628. GO
  629. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'200', N'22', N'防火防区(带校验)', N'11')
  630. GO
  631. GO
  632. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'201', N'22', N'防火防区(无校验)', N'12')
  633. GO
  634. GO
  635. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'202', N'22', N'防拆防区', N'13')
  636. GO
  637. GO
  638. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'203', N'22', N'挟持防区', N'14')
  639. GO
  640. GO
  641. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'204', N'22', N'24小时周界', N'15')
  642. GO
  643. GO
  644. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'205', N'23', N'分区1', N'0')
  645. GO
  646. GO
  647. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'206', N'23', N'分区2', N'1')
  648. GO
  649. GO
  650. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'207', N'23', N'分区3', N'2')
  651. GO
  652. GO
  653. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'208', N'23', N'分区4', N'3')
  654. GO
  655. GO
  656. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'209', N'23', N'分区5', N'4')
  657. GO
  658. GO
  659. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'210', N'23', N'分区6', N'5')
  660. GO
  661. GO
  662. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'211', N'23', N'分区7', N'6')
  663. GO
  664. GO
  665. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'212', N'23', N'分区8', N'7')
  666. GO
  667. GO
  668. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'213', N'23', N'分区9', N'8')
  669. GO
  670. GO
  671. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'214', N'23', N'分区10', N'9')
  672. GO
  673. GO
  674. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'215', N'23', N'分区11', N'10')
  675. GO
  676. GO
  677. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'216', N'23', N'分区12', N'11')
  678. GO
  679. GO
  680. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'217', N'23', N'分区13', N'12')
  681. GO
  682. GO
  683. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'218', N'23', N'分区14', N'13')
  684. GO
  685. GO
  686. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'219', N'23', N'分区15', N'14')
  687. GO
  688. GO
  689. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'220', N'23', N'分区16', N'15')
  690. GO
  691. GO
  692. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'221', N'24', N'1A', N'0')
  693. GO
  694. GO
  695. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'222', N'24', N'2A', N'1')
  696. GO
  697. GO
  698. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'223', N'24', N'2A', N'2')
  699. GO
  700. GO
  701. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'224', N'24', N'8A', N'3')
  702. GO
  703. GO
  704. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'225', N'24', N'8A', N'4')
  705. GO
  706. GO
  707. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'226', N'24', N'8A', N'5')
  708. GO
  709. GO
  710. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'227', N'24', N'8A', N'6')
  711. GO
  712. GO
  713. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'228', N'24', N'8A', N'7')
  714. GO
  715. GO
  716. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'229', N'24', N'8A', N'8')
  717. GO
  718. GO
  719. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'230', N'24', N'8A', N'9')
  720. GO
  721. GO
  722. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'231', N'24', N'8A', N'10')
  723. GO
  724. GO
  725. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'232', N'24', N'无效', N'255')
  726. GO
  727. GO
  728. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'233', N'25', N'取消功能', N'0')
  729. GO
  730. GO
  731. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'234', N'25', N'盗警', N'1')
  732. GO
  733. GO
  734. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'235', N'25', N'火警', N'2')
  735. GO
  736. GO
  737. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'236', N'25', N'求助警', N'3')
  738. GO
  739. GO
  740. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'237', N'25', N'盗警火警求助警', N'4')
  741. GO
  742. GO
  743. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'238', N'25', N'任意报警', N'5')
  744. GO
  745. GO
  746. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'239', N'26', N'布防时不响警号', N'0')
  747. GO
  748. GO
  749. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'240', N'26', N'布防2声,撤防1声', N'1')
  750. GO
  751. GO
  752. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'241', N'27', N'分区1', N'1')
  753. GO
  754. GO
  755. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'242', N'27', N'分区2', N'2')
  756. GO
  757. GO
  758. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'243', N'27', N'分区3', N'3')
  759. GO
  760. GO
  761. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'244', N'27', N'分区4', N'4')
  762. GO
  763. GO
  764. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'245', N'27', N'分区5', N'5')
  765. GO
  766. GO
  767. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'246', N'27', N'分区6', N'6')
  768. GO
  769. GO
  770. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'247', N'27', N'分区7', N'7')
  771. GO
  772. GO
  773. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'248', N'27', N'分区8', N'8')
  774. GO
  775. GO
  776. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'249', N'27', N'分区9', N'9')
  777. GO
  778. GO
  779. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'250', N'27', N'分区10', N'10')
  780. GO
  781. GO
  782. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'251', N'27', N'分区11', N'11')
  783. GO
  784. GO
  785. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'252', N'27', N'分区12', N'12')
  786. GO
  787. GO
  788. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'253', N'27', N'分区13', N'13')
  789. GO
  790. GO
  791. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'254', N'27', N'分区14', N'14')
  792. GO
  793. GO
  794. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'255', N'27', N'分区15', N'15')
  795. GO
  796. GO
  797. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'256', N'27', N'分区16', N'16')
  798. GO
  799. GO
  800. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'257', N'27', N'全部分区', N'17')
  801. GO
  802. GO
  803. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'258', N'27', N'取消', N'0')
  804. GO
  805. GO
  806. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'259', N'28', N'系统主人', N'1')
  807. GO
  808. GO
  809. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'260', N'28', N'分区主人', N'2')
  810. GO
  811. GO
  812. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'261', N'28', N'访客码', N'3')
  813. GO
  814. GO
  815. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'262', N'28', N'劫持码', N'4')
  816. GO
  817. GO
  818. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'263', N'28', N'工程码', N'5')
  819. GO
  820. GO
  821. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'264', N'28', N'禁用', N'6')
  822. GO
  823. GO
  824. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'265', N'29', N'禁用', N'0')
  825. GO
  826. GO
  827. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'266', N'29', N'系统外出布防', N'1')
  828. GO
  829. GO
  830. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'267', N'29', N'系统周界布防', N'2')
  831. GO
  832. GO
  833. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'268', N'29', N'撤防', N'3')
  834. GO
  835. GO
  836. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'269', N'30', N'分区12', N'12')
  837. GO
  838. GO
  839. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'270', N'30', N'分区13', N'13')
  840. GO
  841. GO
  842. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'271', N'30', N'分区14', N'14')
  843. GO
  844. GO
  845. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'272', N'30', N'分区15', N'15')
  846. GO
  847. GO
  848. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'273', N'30', N'分区1', N'1')
  849. GO
  850. GO
  851. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'274', N'30', N'分区2', N'2')
  852. GO
  853. GO
  854. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'275', N'30', N'分区3', N'3')
  855. GO
  856. GO
  857. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'276', N'30', N'分区4', N'4')
  858. GO
  859. GO
  860. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'277', N'30', N'分区5', N'5')
  861. GO
  862. GO
  863. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'278', N'30', N'分区6', N'6')
  864. GO
  865. GO
  866. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'279', N'30', N'分区7', N'7')
  867. GO
  868. GO
  869. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'280', N'30', N'分区8', N'8')
  870. GO
  871. GO
  872. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'281', N'30', N'分区9', N'9')
  873. GO
  874. GO
  875. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'282', N'30', N'分区10', N'10')
  876. GO
  877. GO
  878. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'283', N'30', N'分区11', N'11')
  879. GO
  880. GO
  881. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'284', N'30', N'分区16', N'16')
  882. GO
  883. GO
  884. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'285', N'30', N'取消', N'0')
  885. GO
  886. GO
  887. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'286', N'31', N'禁用', N'0')
  888. GO
  889. GO
  890. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'287', N'31', N'防区01', N'1')
  891. GO
  892. GO
  893. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'288', N'31', N'防区02', N'2')
  894. GO
  895. GO
  896. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'289', N'31', N'防区03', N'3')
  897. GO
  898. GO
  899. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'290', N'31', N'防区04', N'4')
  900. GO
  901. GO
  902. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'291', N'31', N'防区05', N'5')
  903. GO
  904. GO
  905. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'292', N'31', N'防区06', N'6')
  906. GO
  907. GO
  908. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'293', N'31', N'防区07', N'7')
  909. GO
  910. GO
  911. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'294', N'31', N'防区08', N'8')
  912. GO
  913. GO
  914. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'295', N'31', N'防区09', N'9')
  915. GO
  916. GO
  917. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'296', N'31', N'防区10', N'10')
  918. GO
  919. GO
  920. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'297', N'31', N'防区11', N'11')
  921. GO
  922. GO
  923. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'298', N'31', N'防区12', N'12')
  924. GO
  925. GO
  926. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'299', N'31', N'防区13', N'13')
  927. GO
  928. GO
  929. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'300', N'31', N'防区14', N'14')
  930. GO
  931. GO
  932. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'301', N'31', N'布防', N'82')
  933. GO
  934. GO
  935. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'302', N'31', N'周界布防', N'83')
  936. GO
  937. GO
  938. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'303', N'31', N'撤防', N'84')
  939. GO
  940. GO
  941. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'304', N'31', N'任意报警', N'90')
  942. GO
  943. GO
  944. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'305', N'31', N'出入防区', N'91')
  945. GO
  946. GO
  947. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'306', N'31', N'活动防区', N'92')
  948. GO
  949. GO
  950. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'307', N'31', N'周边防区', N'93')
  951. GO
  952. GO
  953. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'308', N'31', N'求助防区', N'94')
  954. GO
  955. GO
  956. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'309', N'31', N'火警防区', N'95')
  957. GO
  958. GO
  959. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'310', N'31', N'气警防区', N'96')
  960. GO
  961. GO
  962. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'311', N'31', N'防拆防区', N'97')
  963. GO
  964. GO
  965. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'312', N'31', N'挟持防区', N'98')
  966. GO
  967. GO
  968. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'313', N'31', N'24小时防区', N'99')
  969. GO
  970. GO
  971. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'314', N'32', N'关闭', N'0')
  972. GO
  973. GO
  974. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'315', N'32', N'出入防区', N'1')
  975. GO
  976. GO
  977. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'316', N'32', N'活动防区', N'2')
  978. GO
  979. GO
  980. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'317', N'32', N'周边防区', N'3')
  981. GO
  982. GO
  983. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'318', N'32', N'紧急防区', N'4')
  984. GO
  985. GO
  986. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'319', N'32', N'火警防区', N'5')
  987. GO
  988. GO
  989. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'320', N'32', N'气警防区', N'6')
  990. GO
  991. GO
  992. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'321', N'32', N'防拆防区', N'7')
  993. GO
  994. GO
  995. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'322', N'32', N'胁持防区', N'8')
  996. GO
  997. GO
  998. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'323', N'32', N'24小时防区', N'9')
  999. GO
  1000. GO
  1001. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'324', N'32', N'钥匙布撤防防区', N'14')
  1002. GO
  1003. GO
  1004. INSERT INTO [dbo].[OptionCode] ([ID], [OptionID], [ItemName], [ItemValue]) VALUES (N'325', N'32', N'巡更防区', N'15')
  1005. GO
  1006. GO
  1007. SET IDENTITY_INSERT [dbo].[OptionCode] OFF
  1008. GO
  1009. -- ----------------------------
  1010. -- Indexes structure for table OptionCode
  1011. -- ----------------------------
  1012. -- ----------------------------
  1013. -- Primary Key structure for table OptionCode
  1014. -- ----------------------------
  1015. ALTER TABLE [dbo].[OptionCode] ADD PRIMARY KEY ([ID])
  1016. GO