home *** CD-ROM | disk | FTP | other *** search
/ PC Professionell 2007 April / PCpro_2007_04.ISO / files / dsl / ManageEngineWiFiManager.exe / Disk1 / data1.cab / SourceFiles / WiFiManager.exe / conf / DatabaseSchema.conf < prev    next >
Encoding:
Text File  |  2007-01-17  |  102.9 KB  |  4,353 lines
  1. #$Id: DatabaseSchema.conf,v 1.157 2006/12/11 08:39:27 elumalais Exp $
  2. #Schema for MYSQL
  3.  
  4. BeginModules TopoDB-MapDB-EventDB-AlertDB-PollDB-PolicyDB-USERSTORAGEDB
  5.  
  6. BeginCreateSchema
  7. create table ObjectTypes (
  8. "OBJKEY" varchar( 100 ) NOT NULL , 
  9. "CLASSNAME" varchar( 50 ) )
  10. EndCreateSchema
  11.  
  12. BeginDropSchema
  13. drop table ObjectTypes
  14. EndDropSchema
  15.  
  16. BeginCreateSchema
  17. create table FirmwareTaskDeviceMap(
  18. "TASKNAME" varchar( 100 ) NOT NULL , 
  19. "DEVICENAME" varchar( 50 ),
  20. PRIMARY KEY ("TASKNAME","DEVICENAME") )
  21. EndCreateSchema
  22.  
  23. BeginDropSchema
  24. drop table FirmwareTaskDeviceMap
  25. EndDropSchema
  26.  
  27. BeginCreateSchema
  28. create table FirmwareTaskImageMap(
  29. "TASKNAME" varchar( 100 ) NOT NULL , 
  30. "IMAGENAME" varchar( 50 ), 
  31. "IMAGETYPE" INTEGER,
  32. PRIMARY KEY("TASKNAME","IMAGENAME","IMAGETYPE"))
  33. EndCreateSchema
  34.  
  35. BeginDropSchema
  36. drop table FirmwareTaskImageMap
  37. EndDropSchema
  38.  
  39. BeginCreateSchema
  40. create table DeviceConfigHistory(
  41. "RECORDID" BIGINT NOT NULL AUTO_INCREMENT,
  42. "DEVICENAME" varchar( 50 ),
  43. "TIMEVALUE" BIGINT,
  44. "TEMPLATETYPE" INTEGER,
  45. "ATTRNAME" VARCHAR(150),
  46. "STATUS"  INTEGER,
  47. "OLDVALUE"  VARCHAR(50),
  48. "NEWVALUE"  VARCHAR(50),
  49. "MESSAGE"  VARCHAR(200),
  50. PRIMARY KEY ("RECORDID"),
  51. index DeviceConfigHistory0_ndx ("RECORDID"))
  52. EndCreateSchema
  53.  
  54. BeginDropSchema
  55. drop table DeviceConfigHistory
  56. drop index DeviceConfigHistory0_ndx
  57. EndDropSchema
  58.  
  59.  
  60.  
  61. BeginCreateSchema
  62. create table ManagedObject( 
  63. "NAME" varchar(100) NOT NULL,
  64. "DISPLAYNAME" varchar(100) NOT NULL,
  65. "PARENTKEY" varchar(100)  NOT NULL,
  66. "TYPE" varchar(100),
  67. "MANAGED" varchar(10),
  68. "STATUS" INTEGER,
  69. "FAILURETHRESHOLD" INTEGER,
  70. "FAILURECOUNT" INTEGER,
  71. "POLLINTERVAL" INTEGER,
  72. "STATUSCHANGETIME" varchar(25),
  73. "STATUSUPDATETIME" varchar(25),
  74. "TESTER" varchar(100),
  75. "UCLASS" varchar(100),
  76. "CLASSNAME" varchar(100),
  77. "WEBNMS" varchar(100),
  78. "OWNERNAME" varchar(25) NOT NULL,
  79. "STATUSPOLLENABLED" varchar(10),
  80. "ISCONTAINER" varchar(10),
  81. "ISGROUP" varchar(10),
  82. "CUSTOMDISPLAYNAME" varchar(100),
  83. PRIMARY KEY ("NAME","OWNERNAME"),
  84. index ManagedObject0_ndx("NAME"),
  85. index ManagedObject1_ndx ("OWNERNAME"),
  86. index ManagedObject2_ndx ("PARENTKEY"),
  87. index ManagedObject3_ndx ("STATUS"))
  88. TYPE=InnoDB
  89. EndCreateSchema
  90.  
  91.  
  92. BeginCreateSchema
  93. create table FavouriteLinks(
  94. "RECORDID" INTEGER NOT NULL UNIQUE,
  95. "USERNAME" varchar(50) NOT NULL,
  96. "LINKNAME" varchar(50) NOT NULL,
  97. "LINKURL" blob NOT NULL,
  98. CONSTRAINT FavLinks_PK PRIMARY KEY (USERNAME,LINKNAME))
  99. EndCreateSchema
  100.  
  101. #BeginDropSchema
  102. #drop table FavouriteLinks
  103. #EndDropSchema
  104.  
  105. BeginCreateSchema
  106. create table MapContainer(
  107. "NAME" varchar(100) NOT NULL,
  108. "OBJNAME" varchar(100)  NOT NULL,
  109. "MAPNAME" varchar(100) NOT NULL,
  110. "OWNERNAME" varchar(25) NOT NULL,
  111. "LABEL" varchar(100),
  112. "ICONNAME" varchar(100),
  113. "MENUNAME" varchar(100),
  114. "WIDTH" INTEGER,
  115. "HEIGHT" INTEGER,
  116. "X" INTEGER,
  117. "Y" INTEGER,
  118. "WEBNMS" varchar(100),
  119. "GROUPNAME" varchar(100),
  120. "ANCHORED" varchar(10),
  121. "CURRENTTOPOLOGY" varchar(100),
  122. "TOPOLOGY" varchar(100),
  123. "CONTAINMENT"   varchar(10),        
  124. "OBJTYPE" INTEGER,
  125. "RENDERINGCODE" varchar(10),
  126. "PARENTNAME" varchar(100),
  127. PRIMARY KEY ( "NAME","MAPNAME","OWNERNAME" ),
  128. index MapContainer0_ndx ("MAPNAME"),
  129. index MapContainer1_ndx ("NAME"),
  130. index MapContainer2_ndx ("OWNERNAME"),
  131. index MapContainer3_ndx ("OBJNAME","OWNERNAME"))
  132. EndCreateSchema
  133.  
  134. BeginDropSchema
  135. drop table MapContainer
  136. drop index MapContainer0_ndx
  137. drop index MapContainer1_ndx
  138. drop index MapContainer2_ndx
  139. drop index MapContainer3_ndx
  140. EndDropSchema
  141.  
  142. BeginCreateSchema
  143. create table VLANDetails ( 
  144. "VLANID"  INTEGER NOT NULL,
  145. "VLANNAME"  VARCHAR(50), 
  146. "VLANSSID"  VARCHAR(50), 
  147. "NATIVEVLAN"  VARCHAR(10), 
  148. "SERVICEPRIORITY"  VARCHAR(50), 
  149. "MAXCLIENTSALLOWED"  INTEGER , 
  150. PRIMARY KEY ("VLANID"),
  151. index VLANDetails0_ndx ("VLANID"))
  152. EndCreateSchema
  153.  
  154. #users change perdsistance
  155. #BeginDropSchema
  156. #drop table VLANDetails
  157. #EndDropSchema
  158.  
  159. BeginCreateSchema
  160. create table RADIUSServer ( 
  161. "NAME"  VARCHAR(50) NOT NULL, 
  162. "MAXRETRIES"  INTEGER , 
  163. "AUTHPORT"  INTEGER , 
  164. "TIMEOUT"  INTEGER , 
  165. "SHAREDSECRET"  VARCHAR(50), 
  166. "OWNERNAME"  VARCHAR(50)  NOT NULL , 
  167. PRIMARY KEY ("NAME", "OWNERNAME"),
  168. index RADIUSServer0_ndx ("NAME"),
  169. index RADIUSServer1_ndx ("OWNERNAME"))
  170. EndCreateSchema
  171.  
  172. BeginDropSchema
  173. drop table RADIUSServer
  174. drop index RADIUSServer0_ndx
  175. drop index RADIUSServer1_ndx
  176. EndDropSchema
  177.  
  178. BeginCreateSchema
  179. create table MAILSETTINGS (
  180. "ID" INTEGER NOT NULL,
  181. "HOST" varchar(100),
  182. "PORT" INTEGER NOT NULL,
  183. "USERNAME" varchar(25),
  184. "PASSWORD" varchar(25))
  185. EndCreateSchema
  186.  
  187. BeginCreateSchema
  188. create table WiFiSettings (
  189. "WIFI_TYPE" VARCHAR(50) NOT NULL,
  190. "WIFI_KEY" VARCHAR(50) NOT NULL,
  191. "WIFI_VALUE" VARCHAR(150),
  192. PRIMARY KEY ("WIFI_TYPE","WIFI_KEY"))
  193. EndCreateSchema
  194.  
  195. #BeginDropConfigSchema
  196. #drop table MAILSETTINGS
  197. #EndDropConfigSchema
  198.  
  199. BeginCreateSchema
  200. create table TopoObject( 
  201. "NAME" varchar(100) NOT NULL,
  202. "IPADDRESS" varchar(100),
  203. "NETMASK" varchar(100),
  204. "COMMUNITY" varchar(100),
  205. "WRITECOMMUNITY" varchar(100),
  206. "SNMPPORT" INTEGER,
  207. "ISDHCP" varchar(10),
  208. "BASEMIBS" varchar(100),
  209. "OWNERNAME" varchar(25) NOT NULL,
  210. "VERSION" varchar(100),
  211. "USERNAME" varchar(100),
  212. "CONTEXTNAME" varchar(100),
  213. "ISSNMP" varchar(10),
  214. "ISNODE" varchar(10),
  215. "ISNETWORK" varchar(10),
  216. "ISINTERFACE" varchar(10),
  217. PRIMARY KEY ("NAME", "OWNERNAME"),
  218. index TopoObject0_ndx ("NAME"),
  219. index TopoObject1_ndx ("OWNERNAME"),
  220. index TopoObject2_ndx ("IPADDRESS"))
  221. EndCreateSchema
  222.  
  223. BeginDropSchema
  224. drop table TopoObject
  225. drop index TopoObject0_ndx
  226. drop index TopoObject1_ndx
  227. EndDropSchema
  228.  
  229. BeginCreateSchema
  230. create table Node( 
  231. "NAME" varchar(100) NOT NULL,
  232. "ISROUTER" varchar(10),
  233. "OWNERNAME" varchar(25) NOT NULL,
  234. PRIMARY KEY ("NAME", "OWNERNAME"),
  235. index Node0_ndx ("NAME"),
  236. index Node1_ndx ("OWNERNAME"))
  237. EndCreateSchema
  238.  
  239. BeginDropSchema
  240. drop table Node
  241. drop index Node0_ndx
  242. drop index Node1_ndx
  243. EndDropSchema
  244.  
  245. BeginCreateSchema
  246. create table Network(
  247. "NAME" varchar(100) NOT NULL,
  248. "DISCOVER" varchar(10),
  249. "DISCOVERYSTATUS" INTEGER,
  250. "OWNERNAME" varchar(25) NOT NULL,
  251. "PARENTNETWORK" varchar(100)  NOT NULL,
  252. "PARENTNETMASK" varchar(100),
  253. PRIMARY KEY ("NAME","OWNERNAME"),
  254. index Network0_ndx ("NAME"),
  255. index Network1_ndx ("OWNERNAME"),
  256. index Network2_ndx ("PARENTNETWORK"))
  257. EndCreateSchema
  258.  
  259. BeginDropSchema
  260. drop table Network
  261. drop index Network0_ndx
  262. drop index Network1_ndx
  263. drop index Network2_ndx
  264. EndDropSchema
  265.  
  266. BeginCreateSchema
  267. create table IpAddress( 
  268. "NAME" varchar(100) NOT NULL,
  269. "PARENTNODE" varchar(100) NOT NULL,
  270. "PARENTNET" varchar(100) NOT NULL,
  271. "OWNERNAME" varchar(25) NOT NULL,
  272. PRIMARY KEY ("NAME", "OWNERNAME"),
  273. index IpAddress0_ndx ( "NAME "),
  274. index IpAddress1_ndx ( "OWNERNAME "),
  275. index IpAddress2_ndx ( "PARENTNODE"),
  276. index IpAddress3_ndx ( "PARENTNET"))
  277. EndCreateSchema
  278.  
  279. BeginDropSchema
  280. drop table IpAddress
  281. drop index IpAddress0_ndx
  282. drop index IpAddress1_ndx
  283. drop index IpAddress2_ndx
  284. drop index IpAddress3_ndx
  285. EndDropSchema
  286.  
  287. BeginCreateSchema
  288. create table SnmpNode( 
  289. "NAME" varchar(100) NOT NULL,
  290. "HOSTNETMASK" varchar(100),
  291. "SYSDESCR" varchar(200),
  292. "SYSNAME" varchar(100),
  293. "SYSOID" varchar(100),
  294. "OWNERNAME" varchar(25) NOT NULL,
  295. PRIMARY KEY ("NAME", "OWNERNAME"),
  296. index SnmpNode0_ndx ("NAME"),
  297. index SnmpNode1_ndx ("OWNERNAME"))
  298. EndCreateSchema
  299.  
  300. BeginDropSchema
  301. drop table SnmpNode
  302. drop index SnmpNode0_ndx
  303. drop index SnmpNode1_ndx
  304. EndDropSchema
  305.  
  306. BeginCreateSchema
  307. create table SnmpInterface( 
  308. "NAME" varchar(100) NOT NULL,
  309. "HOSTNETMASK" varchar(100),
  310. "IFINDEX" INTEGER,
  311. "PHYSMEDIA" varchar(100),
  312. "PHYSADDR" varchar(100),
  313. "IFSPEED" INTEGER,
  314. "IFDESCR" varchar(200),
  315. "SYSOID" varchar(100),
  316. "OWNERNAME" varchar(25) NOT NULL,
  317. PRIMARY KEY ("NAME", "OWNERNAME"),
  318. index SnmpInterface0_ndx ("NAME"),
  319. index SnmpInterface1_ndx ("OWNERNAME"))
  320. EndCreateSchema
  321.  
  322. BeginDropSchema
  323. drop table SnmpInterface
  324. drop index SnmpInterface0_ndx
  325. drop index SnmpInterface1_ndx
  326. EndDropSchema
  327.  
  328. BeginCreateSchema
  329. create table TOPOUSERPROPS(
  330. "NAME" varchar( 100 ) NOT NULL, 
  331. "OWNERNAME" varchar(25) NOT NULL,
  332. "PROPNAME" varchar( 150 ) NOT NULL,
  333. "PROPVAL" varchar( 150 ),
  334. index TOPOUSERPROPS0_ndx ( "NAME"),
  335. index TOPOUSERPROPS1_ndx ( "OWNERNAME")
  336. )
  337. EndCreateSchema
  338.  
  339. BeginDropSchema
  340. drop table TOPOUSERPROPS
  341. drop index TOPOUSERPROPS0_ndx
  342. drop index TOPOUSERPROPS1_ndx
  343. EndDropSchema
  344.  
  345. BeginCreateSchema
  346. create table ALERTUSERPROPS(
  347. "NAME" varchar( 100 ) NOT NULL,
  348. "OWNERNAME" varchar(25) NOT NULL,
  349. "PROPNAME" varchar( 150 ) NOT  NULL,
  350. "PROPVAL" varchar( 150 ),
  351. index ALERTUSERPROPS0_ndx ( "NAME"),
  352. index ALERTUSERPROPS1_ndx ( "OWNERNAME"))
  353. EndCreateSchema
  354.  
  355. BeginDropSchema
  356. drop table ALERTUSERPROPS
  357. drop index ALERTUSERPROPS0_ndx
  358. drop index ALERTUSERPROPS1_ndx
  359. EndDropSchema
  360.  
  361. BeginCreateSchema
  362. create table EVENTUSERPROPS(
  363. "NAME" INTEGER NOT NULL,
  364. "OWNERNAME" varchar(25) NOT NULL,
  365. "PROPNAME" varchar( 150 ) NOT NULL,
  366. "PROPVAL" varchar( 150 ),
  367. index EVENTUSERPROPS0_ndx  ( "NAME"),
  368. index EVENTUSERPROPS1_ndx  ( "OWNERNAME"))
  369. EndCreateSchema
  370.  
  371. BeginDropSchema
  372. drop table EVENTUSERPROPS
  373. drop index EVENTUSERPROPS0_ndx
  374. drop index EVENTUSERPROPS1_ndx
  375. EndDropSchema
  376.  
  377. BeginCreateSchema
  378. create table USERTABLE(
  379. "DBKEY" varchar(105) NOT NULL,
  380. "HOST" varchar(50),
  381. "PORT" varchar(5),
  382. "ENGINENAME" varchar(50), 
  383. "USERNAME" varchar(50), 
  384. "AUTHPROTOCOL" varchar(10), 
  385. "AUTHPASSWORD" varchar(50),
  386. "PRIVPROTOCOL" varchar(10), 
  387. "PRIVPASSWORD" varchar(50),
  388. PRIMARY KEY ("DBKEY"))
  389. EndCreateSchema
  390.  
  391. BeginCreateSchema
  392. create table HOSTS(
  393. "HOSTNAMES" varchar(100) NOT NULL,
  394. PRIMARY KEY ("HOSTNAMES"))
  395. EndCreateSchema
  396.  
  397. BeginCreateSchema
  398. create table PORTS(
  399. "PORTS" varchar(100) NOT NULL,
  400. PRIMARY KEY ("PORTS"))
  401. EndCreateSchema
  402.  
  403. BeginCreateSchema
  404. create table ENGINES(
  405. "ENGINENAMES" varchar(100) NOT NULL,
  406. PRIMARY KEY ("ENGINENAMES"))
  407. EndCreateSchema
  408.  
  409. BeginCreateSchema
  410. create table USERS(
  411. "USERNAMES" varchar(100) NOT NULL,
  412. PRIMARY KEY("USERNAMES"))
  413. EndCreateSchema
  414.  
  415. BeginCreateSchema
  416. create table POLLUSERPROPS(
  417. "NAME" varchar( 100 ) NOT NULL,
  418. "AGENT" varchar( 100 ) NOT NULL,
  419. "OID" varchar( 100 ) NOT NULL,
  420. "OWNERNAME" varchar(25) NOT NULL,
  421. "PROPNAME" varchar( 150 ) NOT NULL,
  422. "PROPVAL" varchar( 150 ),
  423. index POLLUSERPROPS0_ndx ( "NAME"),
  424. index POLLUSERPROPS1_ndx ( "AGENT"),
  425. index POLLUSERPROPS2_ndx ( "OID"),
  426. index POLLUSERPROPS3_ndx ( "OWNERNAME"))
  427. EndCreateSchema
  428.  
  429. BeginDropSchema
  430. drop table POLLUSERPROPS
  431. drop index POLLUSERPROPS0_ndx
  432. drop index POLLUSERPROPS1_ndx
  433. drop index POLLUSERPROPS2_ndx
  434. drop index POLLUSERPROPS3_ndx
  435. EndDropSchema
  436.  
  437. BeginCreateSchema
  438. create table ANNOTATION (
  439. "ENTITY" varchar( 100 ) NOT NULL, 
  440. "WHO" varchar( 50 ) , 
  441. "MODTIME" BIGINT , 
  442. "OWNERNAME" varchar(25) NOT NULL,
  443. "NOTES"  varchar(250 ),
  444. index ANNOTATION0_ndx ( "ENTITY"),
  445. index ANNOTATION1_ndx ( "OWNERNAME"))
  446. EndCreateSchema
  447.  
  448. BeginDropSchema
  449. drop table ANNOTATION
  450. drop index ANNOTATION0_ndx
  451. drop index ANNOTATION1_ndx
  452. EndDropSchema
  453.  
  454. BeginCreateSchema
  455. create table AlertExpert(
  456. "ID" INTEGER NOT NULL,
  457. "NAME" varchar(100) NOT NULL,
  458. "ENABLED" BOOL  NOT NULL,
  459. "SEVERITY" SMALLINT(1) NOT NULL,
  460. "CLASS" varchar(25)  NOT NULL,
  461. "SUMMARY" varchar(255),
  462. "DETAILSURL" varchar(255),
  463. "MMESSAGE" varchar(255),
  464. "DESCRIPTION" TEXT,
  465. "ACTION" varchar(255),
  466. "CUSTOMPROTECT" BOOL,
  467. "GROUPNAME" varchar(100),
  468. "ALARMSBYPOLL" BOOL NOT NULL,
  469. "CLEARMSG" varchar(255),
  470. CONSTRAINT AlertExpert_PK PRIMARY KEY (ID),
  471. index AlertExpert1_ndx ("ID"),
  472. index AlertExpert2_ndx ("CLASS"),
  473. index AlertExpert3_ndx ("NAME"))
  474. TYPE=InnoDB
  475. EndCreateSchema
  476.  
  477. BeginCreateSchema
  478. create table Alert ( 
  479. "ID" INTEGER,
  480. "GROUPNAME" varchar(100),
  481. "CATEGORY" varchar(100),
  482. "SEVERITY" INTEGER,
  483. "PREVIOUSSEVERITY" INTEGER,
  484. "ENTITY" varchar(100) NOT NULL,
  485. "CREATETIME" BIGINT,
  486. "MODTIME" BIGINT,
  487. "MMESSAGE" varchar(200),
  488. "SOURCE" varchar(100),
  489. "MAPNAME" varchar(100),
  490. "WHO" varchar(100),
  491. "STAGE" INTEGER,
  492. "WEBNMS" varchar(100),
  493. "OWNERNAME" varchar(25) NOT NULL,
  494. "PRIORITY" INTEGER,
  495. "ALARMCODE" varchar(50),
  496. "ALARMTYPE" varchar(50),
  497. "ALARMID" INTEGER,
  498. "DISPLAYNAME" varchar(100),
  499. PRIMARY KEY ("ENTITY", "OWNERNAME"),
  500. CONSTRAINT Alert_AlertExpert_FK1 FOREIGN KEY (ALARMID) REFERENCES AlertExpert(ID) ON DELETE CASCADE,
  501. index Alert0_ndx ("ENTITY"),
  502. index Alert1_ndx ("OWNERNAME"),
  503. index Alert2_ndx ("ALARMID"),
  504. index Alert3_ndx ("SOURCE"))
  505. TYPE=InnoDB
  506. EndCreateSchema
  507.  
  508. BeginDropSchema
  509. drop table Alert
  510. drop index Alert0_ndx
  511. drop index Alert1_ndx
  512. drop index Alert2_ndx
  513. EndDropSchema
  514.  
  515. #users change perdsistance
  516. #BeginDropSchema
  517. #drop table CustomAlertExpert
  518. #EndDropSchema
  519.  
  520. #users change perdsistance
  521. #BeginDropSchema
  522. #drop table AlertExpertThresholds
  523. #EndDropSchema
  524.  
  525. #BeginDropSchema
  526. #drop table MailIds
  527. #EndDropSchema
  528.  
  529. #users change perdsistance
  530. #BeginDropSchema
  531. #drop table EmailNotification
  532. #EndDropSchema
  533.  
  534. #BeginDropSchema
  535. #drop table ExpertToNotification
  536. #EndDropSchema
  537.  
  538. #BeginDropSchema
  539. #drop table AlertExpert
  540. #drop index AlertExpert1_ndx
  541. #drop index AlertExpert2_ndx
  542. #drop index AlertExpert3_ndx
  543. #EndDropSchema
  544.  
  545. BeginCreateSchema
  546. create table MACToIP (
  547. "MACADDRESS" VARCHAR(17) NOT NULL,
  548. "IPADDRESS" VARCHAR(15),
  549. "DNSNAME" VARCHAR(100),
  550. "CUSTOMDISPLAYNAME" VARCHAR(100),
  551. PRIMARY KEY ("MACADDRESS"),
  552. index MACToIP0_ndx ("MACADDRESS"),
  553. index MACToIP1_ndx ("IPADDRESS"))
  554. EndCreateSchema
  555.  
  556.  
  557. BeginCreateSchema
  558. create table MapDB( 
  559. "NAME" varchar(100) NOT NULL,
  560. "OWNERNAME" varchar(25) NOT NULL,
  561. "PARENT" varchar(100),
  562. "LABEL" varchar(100),
  563. "MENUNAME" varchar(100),
  564. "IMAGENAME" varchar(100),
  565. "TREEICONFILENAME" varchar(100),
  566. "AUTOPLACEMENT" varchar(10),
  567. "ANCHORED" varchar(10),
  568. "HELPDOC" varchar(100),
  569. "TOPOLOGY" varchar(100),
  570. "CURRENTTOPOLOGY" varchar(100),
  571. "WEBNMS" varchar(100),
  572. "GROUPNAME" varchar(100),
  573. "MAPSYMBOLRENDERER" varchar(100),
  574. "MAPLINKRENDERER" varchar(100),
  575. "MAPLISTENER" varchar(100),
  576. PRIMARY KEY ("NAME","OWNERNAME"),
  577. index MapDB0_ndx ("NAME"),
  578. index MapDB1_ndx ("OWNERNAME"))
  579. TYPE=InnoDB
  580. EndCreateSchema
  581.  
  582. BeginCreateSchema
  583. create table MapSymbol( 
  584. "NAME" varchar(100) NOT NULL,
  585. "OBJNAME" varchar(100)  NOT NULL,
  586. "MAPNAME" varchar(100) NOT NULL,
  587. "OWNERNAME" varchar(25) NOT NULL,
  588. "LABEL" varchar(100),
  589. "ICONNAME" varchar(100),
  590. "MENUNAME" varchar(100),
  591. "WIDTH" varchar(25),
  592. "HEIGHT" varchar(25),
  593. "X" varchar(25),
  594. "Y" varchar(25),
  595. "OBJTYPE" INTEGER,  
  596. "WEBNMS" varchar(100),
  597. "GROUPNAME" varchar(100),
  598. "PARENTNAME" varchar(100),
  599. "ANCHORED" varchar(10),
  600. "RENDERINGCODE" varchar(10),
  601. "SUBVIEWNAME" varchar(100),
  602. PRIMARY KEY ("NAME","MAPNAME","OWNERNAME"),
  603. index MapSymbol0_ndx ("NAME"),
  604. index MapSymbol1_ndx ("MAPNAME"),
  605. index MapSymbol2_ndx ("OWNERNAME"),
  606. index MapSymbol3_ndx ("OBJNAME","OWNERNAME"))
  607. EndCreateSchema
  608.  
  609. BeginDropSchema
  610. drop table MapSymbol
  611. drop index MapSymbol0_ndx
  612. drop index MapSymbol1_ndx
  613. drop index MapSymbol2_ndx
  614. drop index MapSymbol3_ndx
  615. EndDropSchema
  616.  
  617. BeginCreateSchema
  618. create table MapLink( 
  619. "NAME" varchar(100) NOT NULL,
  620. "SOURCE" varchar(100) NOT NULL ,
  621. "DEST" varchar(100) NOT NULL ,
  622. "MAPNAME" varchar(50) NOT NULL ,
  623. "OWNERNAME" varchar(25) NOT NULL,
  624. "THICKNESS" INTEGER,
  625. "LINKTYPE" INTEGER,
  626. "LABEL" varchar(100),
  627. "MENUNAME" varchar(100),
  628. "NX" varchar(25),
  629. "NY" varchar(25),
  630. "X" varchar(25),
  631. "Y" varchar(25),
  632. "OBJNAME" varchar(100)  NOT NULL,
  633. "STATUS"  varchar(25),  
  634. "WEBNMS" varchar(100),
  635. "GROUPNAME" varchar(100),
  636. PRIMARY KEY ("NAME","MAPNAME","OWNERNAME"),
  637. index MapLink0_ndx ("NAME"),
  638. index MapLink1_ndx ("MAPNAME"),
  639. index MapLink2_ndx ("OWNERNAME"),
  640. index MapLink3_ndx ("OBJNAME","OWNERNAME"))
  641. EndCreateSchema
  642.  
  643. BeginDropSchema
  644. drop table MapLink
  645. drop index MapLink0_ndx
  646. drop index MapLink1_ndx
  647. drop index MapLink2_ndx
  648. drop index MapLink3_ndx
  649. EndDropSchema
  650.  
  651. BeginCreateSchema
  652. create table MAPUSERPROPS(
  653. "NAME" varchar( 100 ) NOT NULL,
  654. "MAPNAME" varchar(100) NOT NULL,
  655. "OWNERNAME" varchar(25) NOT NULL,
  656. "PROPNAME" varchar( 150 ) NOT NULL,
  657. "PROPVAL" varchar( 150 ),
  658. index MAPUSERPROPS0_ndx ("NAME"),
  659. index MAPUSERPROPS1_ndx ("MAPNAME"),
  660. index MAPUSERPROPS2_ndx ("OWNERNAME"))
  661.  
  662. EndCreateSchema
  663.  
  664. BeginDropSchema
  665. drop table MAPUSERPROPS
  666. drop index MAPUSERPROPS0_ndx
  667. drop index MAPUSERPROPS1_ndx
  668. drop index MAPUSERPROPS2_ndx
  669. EndDropSchema
  670.  
  671. BeginCreateSchema
  672. create table Event( 
  673. "ID" INTEGER NOT NULL,
  674. "TEXT" varchar(200),
  675. "CATEGORY" varchar(100),
  676. "DDOMAIN" varchar(100),
  677. "NETWORK" varchar(100),
  678. "NODE" varchar(100),
  679. "ENTITY" varchar(100),
  680. "SEVERITY" INTEGER,
  681. "TTIME" BIGINT, 
  682. "SOURCE" varchar(100),
  683. "HELPURL" varchar(100),
  684. "WEBNMS" varchar(100),
  685. "GROUPNAME" varchar(100),
  686. "OWNERNAME" varchar(25) NOT NULL,
  687. "ALARMCODE" varchar(50),
  688. "ALARMTYPE" varchar(50),
  689. "ALARMID" INTEGER,
  690. "DISPLAYNAME" varchar(100),
  691. PRIMARY KEY ("ID","OWNERNAME"),
  692. index Event0_ndx ("ID"),
  693. index Event1_ndx ("OWNERNAME"),
  694. index Event2_ndx ("ENTITY","ID"))
  695. EndCreateSchema
  696.  
  697. BeginDropSchema
  698. drop table Event
  699. drop index Event0_ndx
  700. drop index Event1_ndx
  701. EndDropSchema
  702.  
  703. BeginDropSchema
  704. drop table PdThresholdState
  705. EndDropSchema
  706.  
  707. BeginCreateSchema
  708. create table PolledData( 
  709. "NAME" varchar(50) NOT NULL ,
  710. "ID" BIGINT NOT NULL ,
  711. "AGENT" varchar(50) NOT NULL ,
  712. "COMMUNITY" varchar(100) NOT NULL ,
  713. "PERIOD" INTEGER NOT NULL,
  714. "ACTIVE" varchar(10),
  715. "OID" varchar(250) NOT NULL ,
  716. "LOGDIRECTLY" varchar(10),
  717. "LOGFILE" varchar(100),
  718. "SSAVE" varchar(10),
  719. "THRESHOLD" varchar(10),
  720. "ISMULTIPLEPOLLEDDATA" varchar(10),
  721. "PREVIOUSSEVERITY" INTEGER,
  722. "NUMERICTYPE" INTEGER,
  723. "SAVEABSOLUTES" varchar(10),
  724. "TIMEAVG" varchar(10),
  725. "PORT" INTEGER,
  726. "WEBNMS" varchar(100),
  727. "GROUPNAME" varchar(100),
  728. "LASTCOUNTERVALUE" BIGINT,
  729. "LASTTIMEVALUE" BIGINT,
  730. "TIMEVAL" BIGINT NOT NULL,
  731. "POLICYNAME" varchar(100),
  732. "THRESHOLDLIST" varchar(200),
  733. "DNSNAME" varchar(100),
  734. "SUFFIX" varchar(20),
  735. "STATSDATATABLENAME" varchar(100),
  736. "POLLERNAME" varchar(200),
  737. "FAILURECOUNT" INTEGER,
  738. "FAILURETHRESHOLD" INTEGER,
  739. "OWNERNAME" varchar(25) NOT NULL,
  740. "PARENTOBJ" varchar(100),
  741. "PROTOCOL" varchar(50),
  742. "SAVEPOLLCOUNT" INTEGER,
  743. "CURRENTSAVECOUNT" INTEGER,
  744. "SAVEONTHRESHOLD" varchar(10),
  745. "SNMPVERSION" varchar(10),
  746. "USERNAME" varchar(30),
  747. "CONTEXTNAME" varchar(30),
  748. PRIMARY KEY ("NAME","AGENT","OID","OWNERNAME"),
  749. index PolledData0_ndx ( "NAME"),
  750. index PolledData1_ndx ( "AGENT"),
  751. index PolledData2_ndx ( "OID"),
  752. index PolledData3_ndx ( "ID"),
  753. index PolledData6_ndx ( "TIMEVAL"),
  754. index PolledData7_ndx ( "OWNERNAME"),
  755. index PolledData8_ndx ( "POLICYNAME"))
  756. EndCreateSchema
  757.  
  758. BeginDropSchema
  759. drop table PolledData
  760. drop index PolledData0_ndx
  761. drop index PolledData1_ndx
  762. drop index PolledData2_ndx
  763. drop index PolledData3_ndx
  764. drop index PolledData6_ndx
  765. drop index PolledData7_ndx
  766. drop index PolledData8_ndx
  767. EndDropSchema
  768.  
  769. BeginCreateSchema
  770. create table  ALERTLOGGER (
  771. "VALUESTRING" varchar( 250 ))
  772. EndCreateSchema
  773.  
  774. BeginDropSchema
  775. drop table ALERTLOGGER
  776. EndDropSchema
  777.  
  778. BeginCreateSchema
  779. create table  EVENTLOGGER (
  780. "VALUESTRING" BIGINT NOT NULL,
  781. "POSITION" INTEGER NOT NULL,
  782. index EVENTLOGGER0_ndx ("POSITION"))
  783. EndCreateSchema
  784.  
  785. BeginDropSchema
  786. drop table EVENTLOGGER
  787. drop index EVENTLOGGER0_ndx
  788. EndDropSchema
  789.  
  790. BeginCreateSchema
  791. create table  CUSTOMMAPS (
  792. "VALUESTRING" varchar( 250 ))
  793. EndCreateSchema
  794.  
  795. BeginDropSchema
  796. drop table CUSTOMMAPS
  797. EndDropSchema
  798.  
  799. BeginCreateSchema
  800. create table  DBINTERFACES (
  801. "VALUESTRING" varchar( 250 ))
  802. EndCreateSchema
  803.  
  804. BeginDropSchema
  805. drop table DBINTERFACES
  806. EndDropSchema
  807.  
  808. BeginCreateSchema
  809. create table  DEFAULTMAPS (
  810. "VALUESTRING" varchar( 250 ))
  811. EndCreateSchema
  812.  
  813. BeginDropSchema
  814. drop table DEFAULTMAPS
  815. EndDropSchema
  816.  
  817. BeginCreateSchema
  818. create table  TrapDisabledMO (
  819. "Name" VARCHAR(250) NOT NULL,
  820. "Type" varchar( 250 ),
  821. PRIMARY KEY ("Name"))
  822. EndCreateSchema
  823.  
  824. BeginDropSchema
  825. drop table TrapDisabledMO
  826. EndDropSchema
  827.  
  828. BeginCreateSchema
  829. create table  CHILDRENSTATUS (
  830. "KEYSTRING" VARCHAR(250) NOT NULL,
  831. "VALUESTRING" varchar( 250 ),
  832. PRIMARY KEY ("KEYSTRING"),
  833. index CHILDRENSTATUS0_ndx ("KEYSTRING"))
  834. EndCreateSchema
  835.  
  836. BeginDropSchema
  837. drop table CHILDRENSTATUS
  838. drop index CHILDRENSTATUS0_ndx
  839. EndDropSchema
  840.  
  841. BeginCreateSchema
  842. create table CUSTOMPROPS (
  843. "KEYSTRING" VARCHAR( 250 ) NOT NULL,
  844. "PROPKEY" varchar( 250 ) ,
  845. "PROPVALUE" varchar ( 250 ),
  846. index CUSTOMPROPS0_ndx ("KEYSTRING") )
  847. EndCreateSchema
  848.  
  849. BeginDropSchema
  850. drop table CUSTOMPROPS
  851. drop index CUSTOMPROPS0_ndx
  852. EndDropSchema
  853.  
  854. BeginCreateSchema
  855. create table  OBJECTSTOLINK (
  856. "KEYSTRING" VARCHAR(250) NOT NULL,
  857. "VALUESTRING" varchar( 250 ),
  858. index OBJECTSTOLINK0_ndx ("KEYSTRING"))
  859. EndCreateSchema
  860.  
  861. BeginDropSchema
  862. drop table OBJECTSTOLINK
  863. drop index OBJECTSTOLINK0_ndx
  864. EndDropSchema
  865.  
  866.  
  867. BeginCreateSchema
  868. create table  TOPODBSPECIALKEY (
  869. "KEYSTRING" VARCHAR(250) NOT NULL,
  870. "VALUESTRING" varchar( 250 ),
  871. PRIMARY KEY ("KEYSTRING"),
  872. index TOPODBSPECIALKEY0_ndx ("KEYSTRING"))
  873. EndCreateSchema
  874.  
  875. BeginDropSchema
  876. drop table TOPODBSPECIALKEY
  877. drop index TOPODBSPECIALKEY0_ndx
  878. EndDropSchema
  879.  
  880. BeginCreateSchema
  881. create table  DBMAP (
  882. "KEYSTRING" VARCHAR(250) NOT NULL,
  883. "VALUESTRING" varchar( 250 ),
  884. PRIMARY KEY ("KEYSTRING"),
  885. index DBMAP0_ndx ("KEYSTRING"))
  886. EndCreateSchema
  887.  
  888. BeginDropSchema
  889. drop table DBMAP
  890. drop index DBMAP0_ndx
  891. EndDropSchema
  892.  
  893. BeginCreateSchema
  894. create table  DBEVENT (
  895. "KEYSTRING" VARCHAR(250) NOT NULL,
  896. "VALUESTRING" varchar( 250 ),
  897. PRIMARY KEY ("KEYSTRING"),
  898. index DBEVENT0_ndx ("KEYSTRING"))
  899. EndCreateSchema
  900.  
  901. BeginDropSchema
  902. drop table DBEVENT
  903. drop index DBEVENT0_ndx
  904. EndDropSchema
  905.  
  906. BeginCreateSchema
  907. create table  DBALERT (
  908. "KEYSTRING" VARCHAR(250) NOT NULL,
  909. "VALUESTRING" varchar( 250 ),
  910. PRIMARY KEY ("KEYSTRING"),
  911. index DBALERT0_ndx ("KEYSTRING"))
  912. EndCreateSchema
  913.  
  914. BeginDropSchema
  915. drop table DBALERT
  916. drop index DBALERT0_ndx
  917. EndDropSchema
  918.  
  919. BeginCreateSchema
  920. create table  DBPOLL (
  921. "KEYSTRING" VARCHAR(250) NOT NULL,
  922. "VALUESTRING" varchar( 250 ),
  923. PRIMARY KEY ("KEYSTRING"),
  924. index DBPOLL0_ndx ("KEYSTRING"))
  925. EndCreateSchema
  926.  
  927. BeginDropSchema
  928. drop table DBPOLL
  929. drop index DBPOLL0_ndx
  930. EndDropSchema
  931.  
  932. BeginCreateSchema
  933. create table  ObjectSchedulerRUNNABLE (
  934. "VALUESTRING" varchar( 250 ) NOT NULL,
  935. "TIMEVAL" BIGINT NOT NULL,
  936. PRIMARY KEY ("VALUESTRING"),
  937. index ObjectSchedulerRUNNABLE0_ndx ("TIMEVAL"),
  938. index ObjectSchedulerRUNNABLE1_ndx ("VALUESTRING"))
  939. EndCreateSchema
  940.  
  941. BeginDropSchema
  942. drop table ObjectSchedulerRUNNABLE
  943. drop index ObjectSchedulerRUNNABLE0_ndx
  944. drop index ObjectSchedulerRUNNABLE1_ndx
  945. EndDropSchema
  946.  
  947. BeginCreateSchema
  948. create table MapGroup(
  949. "NAME" varchar(100) NOT NULL,
  950. "OBJNAME" varchar(100)  NOT NULL,
  951. "MAPNAME" varchar(100) NOT NULL,
  952. "OWNERNAME" varchar(25) NOT NULL,
  953. "LABEL" varchar(100),
  954. "ICONNAME" varchar(100),
  955. "MENUNAME" varchar(100),
  956. "WIDTH" INTEGER,
  957. "HEIGHT" INTEGER,
  958. "X" INTEGER,
  959. "Y" INTEGER,
  960. "WEBNMS" varchar(100),
  961. "GROUPNAME" varchar(100),
  962. "OBJTYPE" INTEGER,
  963. "ANCHORED" varchar(10),
  964. PRIMARY KEY ("NAME","MAPNAME","OWNERNAME"),
  965. index MapGroup0_ndx ("MAPNAME"),
  966. index MapGroup1_ndx ("NAME"),
  967. index MapGroup2_ndx ("OWNERNAME"),
  968. index MapGroup3_ndx ("OBJNAME","OWNERNAME"))
  969. EndCreateSchema
  970.  
  971. BeginDropSchema
  972. drop table MapGroup
  973. drop index MapGroup0_ndx
  974. drop index MapGroup1_ndx
  975. drop index MapGroup2_ndx
  976. drop index MapGroup3_ndx
  977. EndDropSchema
  978.  
  979. BeginCreateSchema
  980. create table ManagedGroupObject(
  981. "NAME" varchar(100) NOT NULL PRIMARY KEY,
  982. index ManagedGroupObject0_ndx ("NAME"))
  983. EndCreateSchema
  984.  
  985. BeginDropSchema
  986. drop table ManagedGroupObject
  987. drop index ManagedGroupObject0_ndx
  988. EndDropSchema
  989.  
  990. BeginCreateSchema
  991. create table GroupTable (
  992. "NAME" varchar(100) NOT NULL,
  993. "OWNERNAME" varchar(25) NOT NULL,
  994. "MEMBERNAME" varchar(100) NOT NULL,
  995. "MEMBEROWNERNAME" varchar(25) NOT NULL )
  996. EndCreateSchema
  997.  
  998. BeginDropSchema
  999. drop table GroupTable
  1000. EndDropSchema
  1001.  
  1002. BeginCreateSchema
  1003. create table TaskAudit(
  1004. "EXECUTIONID" INTEGER,
  1005. "USERNAME" varchar(50),
  1006. "TASKNAME" varchar(50),
  1007. "DEVICELIST" text,
  1008. "DATASOURCE" varchar(50),
  1009. "EXECUTEDTIME" varchar(30),
  1010. "STATUS" varchar(10))
  1011. EndCreateSchema
  1012.  
  1013. BeginDropSchema
  1014. drop table TaskAudit
  1015. EndDropSchema
  1016.  
  1017.  
  1018. BeginCreateSchema
  1019. create table DeviceAudit (
  1020. "ID" INTEGER,
  1021. "USERNAME" varchar(50),
  1022. "TASKNAME" varchar(50),
  1023. "SUBTASKNAME" varchar(50),
  1024. "DEVICENAME" varchar(50),
  1025. "TIMEOFSTART" varchar(30),
  1026. "TIMEOFFINISH" varchar(30),
  1027. "STATUS" varchar(100),
  1028. "ROLLBACKSTATUS" varchar(15),
  1029. "EXECUTIONID" INTEGER,
  1030. "DEVICELIST" varchar(100))
  1031. EndCreateSchema
  1032.  
  1033. BeginDropSchema
  1034. drop table DeviceAudit
  1035. EndDropSchema
  1036.  
  1037. BeginCreateSchema
  1038. create table AttributeAudit(
  1039. "ID" INTEGER,
  1040. "IDENTIFIER" varchar(100),
  1041. "TIMEOFFINISH" varchar(30),
  1042. "RETRIES" INTEGER,
  1043. "STATUS" varchar(200))
  1044. EndCreateSchema
  1045.  
  1046. BeginDropSchema
  1047. drop table AttributeAudit
  1048. EndDropSchema
  1049.  
  1050. BeginCreateSchema
  1051. create table ConfigTasks(
  1052. USERNAME varchar(50),
  1053. TASKNAME varchar(50),
  1054. PROTOCOL varchar(10),
  1055. VERSION varchar(10),
  1056. SUBTASKS varchar(200),
  1057. ROLLBACKNEEDED varchar(5),
  1058. ROLLBACKTYPE integer,
  1059. ROLLBACKDOCUMENT varchar(50),
  1060. MIBSTOBELOADED varchar(100),
  1061. DESCRIPTION text,
  1062. ISTEMPLATE varchar(5))
  1063. EndCreateSchema
  1064.  
  1065. BeginDropSchema
  1066. drop table ConfigTasks
  1067. EndDropSchema
  1068.  
  1069. BeginCreateSchema
  1070. create table ConfigTaskDetails(
  1071. AKEY  integer, 
  1072. USERNAME varchar(50),
  1073. TASKNAME varchar(50),
  1074. TYPE varchar(2),
  1075. PARENTKEY integer)
  1076. EndCreateSchema
  1077.  
  1078. BeginDropSchema
  1079. drop table ConfigTaskDetails
  1080. EndDropSchema
  1081.  
  1082. BeginCreateSchema
  1083. create table ConfigAttributes(
  1084. AKEY  varchar(120), 
  1085. NAME varchar(100),
  1086. VALUE text)
  1087. EndCreateSchema
  1088.  
  1089. BeginDropSchema
  1090. drop table ConfigAttributes
  1091. EndDropSchema
  1092.  
  1093. BeginCreateSchema
  1094. create table PendingTasks(
  1095. USERNAME varchar(50), 
  1096. TASKNAME varchar(50),
  1097. SUBTASKNAME varchar(50),
  1098. DEVICENAME varchar(50),
  1099. STATUS varchar(20),
  1100. PORT varchar(5),
  1101. RETRIES INTEGER,
  1102. TIMEOUT INTEGER,
  1103. AINDEX INTEGER,
  1104. EXECUTIONID INTEGER)
  1105. EndCreateSchema
  1106.  
  1107. BeginDropSchema
  1108. drop table PendingTasks
  1109. EndDropSchema
  1110.  
  1111. BeginCreateSchema
  1112. create table PendingDevices(
  1113. DKEY varchar(200), 
  1114. NAME varchar(200),
  1115. VALUE varchar(200))
  1116. EndCreateSchema
  1117.  
  1118. BeginDropSchema
  1119. drop table PendingDevices
  1120. EndDropSchema
  1121.  
  1122. BeginCreateSchema
  1123. create table DeviceList(
  1124. USERNAME varchar(50),
  1125. PROTOCOL varchar(10),
  1126. DEVICELISTNAME VARCHAR(100))
  1127. EndCreateSchema
  1128.  
  1129. BeginDropSchema
  1130. drop table DeviceList
  1131. EndDropSchema
  1132.  
  1133. BeginCreateSchema
  1134. create table DeviceListDetails(
  1135. DKEY VARCHAR(200),
  1136. DEVICENAME VARCHAR(50),
  1137. PORT varchar(5),
  1138. RETRIES INTEGER,
  1139. TIMEOUT INTEGER,
  1140. DEVICESEQUENCE INTEGER)
  1141. EndCreateSchema
  1142.  
  1143. BeginDropSchema
  1144. drop table DeviceListDetails
  1145. EndDropSchema
  1146.  
  1147.  
  1148. BeginCreateSchema
  1149. create table DeviceUserProps(
  1150. DKEY varchar(200), 
  1151. NAME varchar(200),
  1152. VALUE varchar(200))
  1153. EndCreateSchema
  1154.  
  1155. BeginDropSchema
  1156. drop table DeviceUserProps
  1157. EndDropSchema
  1158.  
  1159. BeginCreateSchema
  1160. create table TaskToDeviceListMap(
  1161. USERNAME VARCHAR(50),
  1162. TASKNAME VARCHAR(50),
  1163. DEVICELISTNAMES VARCHAR(200))
  1164. EndCreateSchema
  1165.  
  1166. BeginDropSchema
  1167. drop table TaskToDeviceListMap
  1168. EndDropSchema
  1169.  
  1170. BeginCreateSchema
  1171. create table PollingObjects(
  1172. NAME varchar(50) NOT NULL,
  1173. STATUS varchar(10),
  1174. PRIMARY KEY("NAME"))
  1175. EndCreateSchema
  1176.  
  1177. BeginCreateSchema
  1178. create table CustomAlertExpert(
  1179. "ID" INTEGER NOT NULL,
  1180. "ISTHRESHOLD" BOOL,
  1181. "POLLINGNAME" varchar(100) NOT NULL,
  1182. CONSTRAINT CustomAlertExpert_PK PRIMARY KEY (ID),
  1183. CONSTRAINT CustomAlertExpert_Threshold_FK1 FOREIGN KEY (ID) REFERENCES AlertExpert(ID) ON DELETE CASCADE,
  1184. index CustomAlertExpert_ind1 (ID),
  1185. index CustomAlertExpert_ind2 (POLLINGNAME))
  1186. TYPE=InnoDB
  1187. EndCreateSchema
  1188.  
  1189. BeginCreateSchema
  1190. create table ConfigProvider (
  1191. PROTOCOL varchar(100) NOT NULL,
  1192. CONFIGPROVIDER varchar(100) NOT NULL )
  1193. EndCreateSchema
  1194.  
  1195. BeginDropSchema
  1196. drop table ConfigProvider
  1197. EndDropSchema
  1198.  
  1199. BeginDropSchema
  1200. drop table PollingObjects
  1201. EndDropSchema
  1202.  
  1203. BeginCreateSchema
  1204. create table PollingAttributes(
  1205. "NAME" varchar(50),
  1206. "TYPE" varchar(10),
  1207. "PROPERTY" varchar(20),
  1208. "CONDITION" varchar(50),
  1209. "VALUE" varchar(100))
  1210. EndCreateSchema
  1211.  
  1212. BeginDropSchema
  1213. drop table PollingAttributes
  1214. EndDropSchema
  1215.  
  1216. BeginCreateSchema
  1217. create table Providers(
  1218. "PROVIDERNAME" varchar(15) NOT NULL,
  1219. "VALUE" varchar(100),
  1220. PRIMARY KEY("PROVIDERNAME"))
  1221. EndCreateSchema
  1222.  
  1223. BeginDropSchema
  1224. drop table Providers
  1225. EndDropSchema
  1226.  
  1227. BeginCreateSchema
  1228. create table StatsTables(
  1229. TableName varchar(100) NOT NULL,
  1230. CreateSchema varchar(255),
  1231. PRIMARY KEY("TableName"))
  1232. EndCreateSchema
  1233.  
  1234. BeginDropSchema
  1235. drop table StatsTables
  1236. EndDropSchema
  1237.  
  1238.  
  1239. BeginCreateSchema
  1240. create table ThresholdObjects(
  1241. "NAME" varchar(100) NOT NULL,
  1242. "KIND" varchar(15),
  1243. "SEVERITY" INTEGER,
  1244. "FAILURETHRESHOLD" INTEGER,
  1245. "TRIGGERSEVERITY" INTEGER,
  1246. "RESETSEVERITY" INTEGER,
  1247. "THRESHOLDTYPE" varchar(5),
  1248. "CATEGORY" varchar(20),
  1249. "THRESHOLDVALUE" BIGINT,
  1250. "REARMVALUE" BIGINT,
  1251. "MMESSAGE" varchar(100),
  1252. "CLEARMESSAGE" varchar(100),
  1253. "SENDCLEAR" varchar(10),
  1254. "ALLOWED" varchar(50),
  1255. "DISALLOWED" varchar(50),
  1256. "OID" varchar(50),
  1257. "OIDTYPE" varchar(10),
  1258. PRIMARY KEY("NAME"))
  1259. EndCreateSchema
  1260.  
  1261. #users change perdsistance
  1262. #BeginDropSchema
  1263. #drop table ThresholdObjects
  1264. #EndDropSchema
  1265.  
  1266. BeginCreateSchema
  1267. create table PdThresholdState(
  1268. "POLLEDDATAID" BIGINT NOT NULL ,
  1269. "POLLEDDATAINSTANCE" varchar(50) NOT NULL,
  1270. "THRESHOLDNAME" varchar(100) NOT NULL,
  1271. "FAILURECOUNT" INTEGER NOT NULL,
  1272. "CURRENTTHRESHOLD" BOOL NOT NULL, 
  1273. CONSTRAINT PdThresholdState_PK PRIMARY KEY (POLLEDDATAID,POLLEDDATAINSTANCE,THRESHOLDNAME),
  1274. INDEX (POLLEDDATAID),
  1275. INDEX (THRESHOLDNAME))
  1276. EndCreateSchema
  1277.  
  1278.  
  1279. BeginCreateSchema
  1280. create table AlertExpertThresholds(
  1281. "ID" INTEGER NOT NULL,
  1282. "THRESHOLDNAME" varchar(100) NOT NULL,
  1283. "THRESHOLDTYPE" varchar(25),
  1284. "THRESHOLDVALUE" varchar(100) NOT NULL,
  1285. CONSTRAINT AlertExpertThresholds_PK PRIMARY KEY (ID),
  1286. CONSTRAINT AlertExpertThresholds_AE_FK1 FOREIGN KEY (ID) REFERENCES AlertExpert(ID) ON DELETE CASCADE,
  1287. index AlertExpertThresholds_Indx0(ID))
  1288. TYPE=InnoDB
  1289. EndCreateSchema
  1290.  
  1291.  
  1292. BeginCreateSchema
  1293. create table CustomView(
  1294. "MODULE" varchar(25) NOT NULL,
  1295. "VIEWID" varchar(50) NOT NULL,
  1296. "USERNAME" varchar(25) NOT NULL,
  1297. "VIEWNAME" varchar(100) NOT NULL,
  1298. "PARENT" varchar(50) NOT NULL,
  1299. "CONSTRAIN" varchar(200),
  1300. "SQLSTRING" text,
  1301. PRIMARY KEY ("VIEWID","USERNAME"),
  1302. index CustomView0_ndx ("MODULE","USERNAME","VIEWNAME","PARENT"),
  1303. index CustomView1_ndx ("VIEWID","USERNAME"))
  1304. EndCreateSchema
  1305.  
  1306. BeginDropConfigSchema
  1307. drop table CustomView
  1308. drop index CustomView0_ndx
  1309. drop index CustomView1_ndx
  1310. EndDropConfigSchema
  1311.  
  1312. BeginCreateSchema
  1313. create table CustomViewProps(
  1314. "MODULE" varchar(25) NOT NULL,
  1315. "VIEWID" varchar(50) NOT NULL,
  1316. "USERNAME" varchar(25) NOT NULL,
  1317. "CRITERIAID" INTEGER NOT NULL,
  1318. "PROPKEY" varchar(100),
  1319. "OPERATOR" varchar(15),
  1320. "PROPVALUE1" varchar(100),
  1321. "PROPVALUE2" varchar(100),
  1322. PRIMARY KEY ("VIEWID","USERNAME","CRITERIAID"),
  1323. index CustomViewProps0_ndx ("VIEWID","USERNAME"))
  1324. EndCreateSchema
  1325.  
  1326. BeginDropConfigSchema
  1327. drop table CustomViewProps
  1328. drop index CustomViewProps0_ndx
  1329. EndDropConfigSchema
  1330.  
  1331. BeginCreateSchema
  1332. create table CustomViewColumns(
  1333. "MODULE" varchar(25) NOT NULL,
  1334. "VIEWID" varchar(50) NOT NULL,
  1335. "USERNAME" varchar(25) NOT NULL,
  1336. "DISPLAYNAME" varchar(50),
  1337. "COLUMNNAME" varchar(50) NOT NULL,
  1338. "WIDTH" INTEGER,
  1339. "COLUMNINDEX" INTEGER,
  1340. PRIMARY KEY ("VIEWID","USERNAME","COLUMNNAME"),
  1341. index CustomViewColumns0_ndx ("VIEWID", "USERNAME"))
  1342. EndCreateSchema
  1343.  
  1344. BeginDropConfigSchema
  1345. drop table CustomViewColumns
  1346. drop index CustomViewColumns0_ndx
  1347. EndDropConfigSchema
  1348.  
  1349. BeginCreateSchema
  1350. create table PanelTree (
  1351. "NODEID" VARCHAR(100) NOT NULL,
  1352. "NODETYPE" VARCHAR(100) NOT NULL,
  1353. "USERNAME" VARCHAR(50) NOT NULL,
  1354. "PARENT" VARCHAR(100),
  1355. "PREVIOUSNODE" VARCHAR(100), 
  1356. "MODULENAME" varchar(30),
  1357. PRIMARY KEY ("NODEID","USERNAME"),
  1358. index PanelTree0_ndx ("USERNAME"))
  1359. EndCreateSchema
  1360.  
  1361. BeginDropConfigSchema
  1362. drop table PanelTree
  1363. drop index PanelTree0_ndx 
  1364. EndDropConfigSchema
  1365.  
  1366. BeginCreateSchema
  1367. create table PanelProps (
  1368. "NODEID" VARCHAR(100) NOT NULL,
  1369. "USERNAME" VARCHAR(50) NOT NULL,
  1370. "ATTRIBNAME" VARCHAR(30) NOT NULL,
  1371. "ATTRIBVALUE" VARCHAR(100),
  1372. PRIMARY KEY ("NODEID","USERNAME","ATTRIBNAME"),
  1373. index PanelProps0_ndx ("USERNAME"))
  1374. EndCreateSchema
  1375.  
  1376. BeginDropConfigSchema
  1377. drop table PanelProps
  1378. drop index PanelProps0_ndx 
  1379. EndDropConfigSchema
  1380.  
  1381. BeginCreateSchema
  1382. create table PollFilters(
  1383. CLASSNAME varchar(100) NOT NULL,
  1384. PRIMARY KEY("CLASSNAME"))
  1385. EndCreateSchema
  1386.  
  1387. BeginDropSchema
  1388. drop table PollFilters
  1389. EndDropSchema
  1390.  
  1391. BeginCreateSchema
  1392. create table GenericFaultTable ( 
  1393. "TYPE" varchar(100) NOT NULL,
  1394. "NAME" varchar(100) NOT NULL,
  1395. PRIMARY KEY ("TYPE","NAME"))
  1396. EndCreateSchema
  1397.  
  1398. BeginDropSchema
  1399. drop table GenericFaultTable
  1400. EndDropSchema
  1401.  
  1402. BeginCreateSchema
  1403. create table TrapFilter ( 
  1404. "NAME" varchar(100),
  1405. "ENTERPRISEOID" varchar(100),
  1406. "GT" varchar(10),
  1407. "ST" varchar(10),
  1408. "TRAPOID" varchar(100),
  1409. "CLASSNAME" varchar(100),
  1410. "STATE" varchar(50))
  1411. EndCreateSchema
  1412.  
  1413. BeginDropSchema
  1414. drop table TrapFilter
  1415. EndDropSchema
  1416.  
  1417. BeginCreateSchema
  1418. create table TrapEventParser ( 
  1419. "TYPE" varchar(100) NOT NULL,
  1420. "NAME" varchar(100) NOT NULL,
  1421. "PROPKEY" varchar(100),
  1422. "PROPVALUE" blob)
  1423. EndCreateSchema
  1424.  
  1425. BeginDropSchema
  1426. drop table TrapEventParser
  1427. EndDropSchema
  1428.  
  1429. BeginCreateSchema
  1430. create table EventAlertFilter ( 
  1431. "TYPE" varchar(100) NOT NULL,
  1432. "FILTERNAME" varchar(100) NOT NULL,
  1433. "ACTIONNAME" varchar(100),
  1434. "PROPKEY" varchar(100),
  1435. "PROPVALUE" blob)
  1436. EndCreateSchema
  1437.  
  1438. BeginDropSchema
  1439. drop table EventAlertFilter
  1440. EndDropSchema
  1441.  
  1442. BeginCreateSchema
  1443. create table Reports(
  1444. "CLASSNAME" varchar(100) NOT NULL,
  1445. "DAILY" varchar(10),
  1446. "WEEKLY" varchar(10),
  1447. "HOUR" varchar(100),
  1448. "MONTHDAYS" varchar(50),
  1449. "WEEKDAYS" varchar(50),
  1450. "TIMEVAL" BIGINT,
  1451. PRIMARY KEY("CLASSNAME"))
  1452. EndCreateSchema
  1453.  
  1454. BeginDropSchema
  1455. drop table Reports
  1456. EndDropSchema
  1457.  
  1458. BeginCreateSchema
  1459. create table DataCollectionAttributes(
  1460. "NAME" varchar(50),
  1461. "PROPKEY" varchar(50),
  1462. "PROPNAME" varchar(30),
  1463. "PROPVAL" varchar(200))
  1464. EndCreateSchema
  1465.  
  1466. BeginDropSchema
  1467. drop table DataCollectionAttributes
  1468. EndDropSchema
  1469.  
  1470. BeginCreateSchema
  1471. create table UserPasswordTable(
  1472. "USERNAME" varchar(50) NOT NULL,
  1473. "PASSWORD" varchar(50),
  1474. "OWNERNAME" varchar(50) NOT NULL,
  1475. PRIMARY KEY ("USERNAME","OWNERNAME"),
  1476. index UserPasswordTable0_ndx ("USERNAME"))
  1477. EndCreateSchema
  1478.  
  1479. #users change perdsistance
  1480. #BeginDropSchema
  1481. #drop table UserPasswordTable
  1482. #drop index UserPasswordTable0_ndx
  1483. #EndDropSchema
  1484.  
  1485. BeginCreateSchema
  1486. create table UserGroupTable(
  1487. "USERNAME" varchar(50) NOT NULL,
  1488. "GROUPNAME" varchar(50) NOT NULL,
  1489. "OWNERNAME" varchar(50) NOT NULL,
  1490. PRIMARY KEY ("USERNAME","GROUPNAME","OWNERNAME"),
  1491. index UserGroupTable0_ndx ("USERNAME","GROUPNAME"),
  1492. index UserGroupTable1_ndx ("USERNAME"),
  1493. index UserGroupTable2_ndx ("GROUPNAME"))
  1494. EndCreateSchema
  1495.  
  1496. #users change perdsistance
  1497. #BeginDropSchema
  1498. #drop table UserGroupTable
  1499. #drop index UserGroupTable0_ndx
  1500. #drop index UserGroupTable1_ndx
  1501. #drop index UserGroupTable2_ndx
  1502. #EndDropSchema
  1503.  
  1504. BeginCreateSchema
  1505. create table ViewPropertiesTable(
  1506. "VIEWNAME" varchar(50) NOT NULL,
  1507. "PROPERTYNAME" varchar(50) NOT NULL,
  1508. "PROPERTYVALUE" varchar(50),
  1509. PRIMARY KEY ("VIEWNAME","PROPERTYNAME"),
  1510. index ViewPropertiesTable0_ndx ("VIEWNAME"))
  1511. EndCreateSchema
  1512.  
  1513. BeginDropSchema
  1514. drop table ViewPropertiesTable
  1515. drop index ViewPropertiesTable0_ndx
  1516. EndDropSchema
  1517.  
  1518. BeginCreateSchema
  1519. create table ViewsToGroupTable(
  1520. "VIEWNAME" varchar(50) NOT NULL,
  1521. "GROUPNAME" varchar(50) NOT NULL,
  1522. "OWNERNAME" varchar(50) NOT NULL,
  1523. PRIMARY KEY ("VIEWNAME","GROUPNAME","OWNERNAME"),
  1524. index ViewsToGroupTable0_ndx ("VIEWNAME","GROUPNAME"),
  1525. index ViewsToGroupTable1_ndx ("GROUPNAME"))
  1526. EndCreateSchema
  1527.  
  1528. BeginDropSchema
  1529. drop table ViewsToGroupTable
  1530. drop index ViewsToGroupTable0_ndx
  1531. drop index ViewsToGroupTable1_ndx
  1532. EndDropSchema
  1533.  
  1534. BeginCreateSchema
  1535. create table ViewToOperationsTable(
  1536. "VIEWNAME" varchar(50) NOT NULL,
  1537. "OPERATIONSNAME" varchar(50) NOT NULL,
  1538. "OPERATIONSTYPE" INTEGER,
  1539. PRIMARY KEY ("VIEWNAME","OPERATIONSNAME"))
  1540. EndCreateSchema
  1541.  
  1542. BeginDropSchema
  1543. drop table ViewToOperationsTable
  1544. EndDropSchema
  1545.  
  1546. BeginCreateSchema
  1547. create table OperationsTreeTable(
  1548. "PARENTOPERATION" varchar(50) NOT NULL,
  1549. "CHILDOPERATION" varchar(50) NOT NULL,
  1550. "LEAFNODE" INTEGER,
  1551. PRIMARY KEY ("PARENTOPERATION","CHILDOPERATION"),
  1552. index OperationsTreeTable0_ndx ("PARENTOPERATION"),
  1553. index OperationsTreeTable1_ndx ("CHILDOPERATION"))
  1554. EndCreateSchema
  1555.  
  1556. BeginDropSchema
  1557. drop table OperationsTreeTable
  1558. drop index OperationsTreeTable0_ndx
  1559. drop index OperationsTreeTable1_ndx
  1560. EndDropSchema
  1561.  
  1562. BeginCreateSchema
  1563. create table NamedViewToAuthorizedViewTable(
  1564. "NAMEDVIEWNAME" varchar(50) NOT NULL,
  1565. "AUTHORIZEDVIEWNAME" varchar(50) NOT NULL)
  1566. EndCreateSchema
  1567.  
  1568. BeginDropSchema
  1569. drop table NamedViewToAuthorizedViewTable
  1570. EndDropSchema
  1571.         
  1572. BeginCreateSchema
  1573. create table AuthAudit(
  1574. "USERNAME" varchar(30) NOT NULL,
  1575. "OPERATION" varchar(30) NOT NULL,
  1576. "AUDITTIME" varchar(30) NOT NULL,
  1577. "STATUS" varchar(10) NOT NULL)
  1578. EndCreateSchema
  1579.  
  1580. BeginDropSchema
  1581. drop table AuthAudit
  1582. EndDropSchema
  1583.  
  1584. BeginCreateSchema
  1585. create table NotificationLog(
  1586. "NOTIINDEX" INTEGER NOT NULL,
  1587. "LOGTIME" BIGINT,
  1588. "NOVARBINDS" INTEGER,
  1589. "NOTIOID" varchar(100),
  1590. PRIMARY KEY ("NOTIINDEX"),
  1591. index NotificationLog0_ndx ("NOTIINDEX"))
  1592. EndCreateSchema
  1593.  
  1594. BeginDropSchema
  1595. drop table NotificationLog
  1596. drop index NotificationLog0_ndx
  1597. EndDropSchema
  1598.  
  1599. BeginCreateSchema
  1600. create table VarBindLog(
  1601. "NOTIINDEX" INTEGER NOT NULL,
  1602. "VARINDEX" INTEGER NOT NULL,
  1603. "VARTYPE" INTEGER,
  1604. "VARVALUE" VARCHAR(200),
  1605. PRIMARY KEY ("NOTIINDEX","VARINDEX"),
  1606. index VarBindLog0_ndx ("NOTIINDEX"),
  1607. index VarBindLog1_ndx ("VARINDEX"))
  1608. EndCreateSchema
  1609.  
  1610. BeginDropSchema
  1611. drop table VarBindLog
  1612. drop index VarBindLog0_ndx
  1613. drop index VarBindLog1_ndx
  1614. EndDropSchema
  1615.  
  1616. BeginCreateSchema
  1617. create table AgentDefValObject (
  1618. "NAME" VARCHAR (100) NOT NULL ,
  1619. "VALUE" VARCHAR (100) ,
  1620. PRIMARY KEY ("NAME"),
  1621. index AgentDefValObject0_ndx ("NAME"))
  1622. EndCreateSchema
  1623.  
  1624. BeginDropSchema
  1625. drop table AgentDefValObject
  1626. drop index AgentDefValObject0_ndx 
  1627. EndDropSchema
  1628.  
  1629. BeginCreateSchema
  1630. create table PolicyObject(
  1631. "NAME" varchar(100) NOT NULL,
  1632. "GROUPNAME" varchar(100),
  1633. "STATUS" INTEGER,
  1634. "PERIOD" INTEGER,
  1635. "POLICYOBJECTCUSTOMIZER" varchar(50),
  1636. "HELPURL" varchar(100),
  1637.  PRIMARY KEY("NAME"),
  1638. index PolicyObject0_ndx ("NAME"))
  1639. EndCreateSchema
  1640.  
  1641. BeginDropSchema
  1642. drop table PolicyObject
  1643. drop index PolicyObject0_ndx
  1644. EndDropSchema
  1645.  
  1646. BeginCreateSchema
  1647. create table PolicyActionCondition(
  1648. "NAME" varchar(100) NOT NULL,
  1649. "OBJKEY" varchar(100) NOT NULL,
  1650. "POLICYACTION" varchar(100),
  1651. "POLICYCONDITION" varchar(100),
  1652. PRIMARY KEY("NAME" , "OBJKEY"),
  1653. index PolicyActionCondition0_ndx ("NAME"))
  1654. EndCreateSchema
  1655.  
  1656. BeginDropSchema
  1657. drop table PolicyActionCondition
  1658. drop index PolicyActionCondition0_ndx
  1659. EndDropSchema
  1660.  
  1661. BeginCreateSchema
  1662. create table POLICYUSERPROPS(
  1663. "NAME" varchar( 100 ) NOT NULL, 
  1664. "OWNERNAME" varchar(25) NOT NULL,
  1665. "PROPNAME" varchar( 150 ) NOT NULL,
  1666. "PROPVAL" varchar( 150 ),
  1667. index POLICYUSERPROPS0_ndx ("NAME"),
  1668. index POLICYUSERPROPS1_ndx ("OWNERNAME"))
  1669. EndCreateSchema
  1670.  
  1671. BeginDropSchema
  1672. drop table POLICYUSERPROPS
  1673. drop index POLICYUSERPROPS0_ndx
  1674. drop index POLICYUSERPROPS1_ndx
  1675. EndDropSchema
  1676.  
  1677. BeginCreateSchema
  1678. create table  DBPOLICY (
  1679. "KEYSTRING" VARCHAR(250) NOT NULL,
  1680. "VALUESTRING" varchar( 250 ),
  1681. PRIMARY KEY ("KEYSTRING"),
  1682. index dbpolicy0_ndx ("KEYSTRING"))
  1683. EndCreateSchema
  1684.  
  1685. BeginDropSchema
  1686. drop table DBPOLICY
  1687. drop index dbpolicy0_ndx
  1688. EndDropSchema
  1689.  
  1690. BeginCreateSchema
  1691. create table  PolicyScheduleTime (
  1692. "TIMEKEY" varchar( 250 ) NOT NULL,
  1693. "NAME" VARCHAR(250) NOT NULL )
  1694. EndCreateSchema
  1695.  
  1696. BeginDropSchema
  1697. drop table PolicyScheduleTime
  1698. EndDropSchema
  1699.  
  1700. BeginCreateSchema
  1701. create table AlertPolicyObject ( 
  1702. "NAME" varchar(80) NOT NULL,
  1703. "ACTIONNAME" varchar(80) NOT NULL,
  1704. "PROPKEY" varchar(80) NOT NULL,
  1705. "PROPVALUE" varchar(100),
  1706. PRIMARY KEY("NAME" , "ACTIONNAME" , "PROPKEY") )
  1707. EndCreateSchema
  1708.  
  1709. BeginDropSchema
  1710. drop table AlertPolicyObject
  1711. EndDropSchema
  1712.  
  1713. BeginCreateSchema
  1714. create table ENGINETABLE( 
  1715. "DBKEY" varchar(57) NOT NULL,
  1716. "HOST" varchar(50),
  1717. "PORT" varchar(5),
  1718. "ENGINENAME" varchar(50),
  1719. "ENGINEID" varchar(64),
  1720. "ENGINETIME" varchar(10),
  1721. "ENGINEBOOTS" varchar(10),
  1722. PRIMARY KEY ("DBKEY"))
  1723. EndCreateSchema
  1724.  
  1725. BeginDropSchema
  1726. drop table ENGINETABLE
  1727. EndDropSchema
  1728.  
  1729. BeginCreateSchema
  1730. create table USMTABLE( 
  1731. "DBKEY" varchar(116) NOT NULL,
  1732. "HOST" varchar(50),
  1733. "PORT" varchar(5), 
  1734. "ENGINENAME" varchar(50),
  1735. "ENGINEID" varchar(64), 
  1736. "USERNAME" varchar(50), 
  1737. "SECURITYLEVEL" varchar(5),
  1738. "SECURITYNAME" varchar(50), 
  1739. "AUTHPROTOCOL" varchar(10), 
  1740. "AUTHPASSWORD" varchar(50), 
  1741. "AUTHKEY" varchar(40), 
  1742. "PRIVPROTOCOL" varchar(10), 
  1743. "PRIVPASSWORD" varchar(50), 
  1744. "PRIVKEY" varchar(32),
  1745. "ENGINETIME" varchar(10), 
  1746. "ENGINEBOOTS" varchar(10),
  1747. "LATESTRCVDENGTIME" varchar(10),
  1748. "USMLOCALTIME" varchar(30),
  1749. PRIMARY KEY ("DBKEY"))
  1750. EndCreateSchema
  1751.  
  1752. BeginDropSchema
  1753. drop table USMTABLE
  1754. EndDropSchema
  1755.  
  1756. BeginCreateSchema
  1757. create table SwitchObject ( 
  1758. "NAME" VARCHAR (100) NOT NULL , 
  1759. "OWNERNAME" VARCHAR (25) NOT NULL , 
  1760. "MACADDRESS" VARCHAR (17),
  1761. "ROOTPORT" INTEGER , 
  1762. "ROOTCOST" INTEGER , 
  1763. "NUMPORTS" INTEGER , 
  1764. PRIMARY KEY ("NAME","OWNERNAME"),
  1765. index SwitchObject0_ndx  ("NAME"),
  1766. index SwitchObject1_ndx  ("OWNERNAME"))
  1767. EndCreateSchema
  1768.  
  1769. BeginDropSchema
  1770. drop table SwitchObject  
  1771. drop index SwitchObject0_ndx
  1772. drop index SwitchObject1_ndx
  1773. EndDropSchema
  1774.  
  1775. BeginCreateSchema
  1776. create table PortObject ( 
  1777. "NAME" VARCHAR (100) NOT NULL , 
  1778. "OWNERNAME" VARCHAR (25) NOT NULL , 
  1779. "PORTIFINDEX" INTEGER , 
  1780. "PORTIFDESCR" VARCHAR (100) , 
  1781. "PORTSTATE" VARCHAR (100) , 
  1782. "PORTIFSPEED" INTEGER , 
  1783. "PORTMACADDRESS" VARCHAR(20),
  1784. "PORTADMINSTATUS" VARCHAR(10), 
  1785. "ISFORWARD" VARCHAR(5), 
  1786. PRIMARY KEY ("NAME","OWNERNAME"),
  1787. index PortObject0_ndx  ("NAME"), 
  1788. index PortObject1_ndx  ("OWNERNAME"))
  1789. TYPE=InnoDB
  1790. EndCreateSchema
  1791.  
  1792. BeginCreateSchema
  1793. create table PortObjectToDevice ( 
  1794. "NAME" VARCHAR (100) NOT NULL , 
  1795. "OWNERNAME" VARCHAR (25) NOT NULL , 
  1796. "MACADDRESS" VARCHAR (17) NOT NULL ,
  1797. CONSTRAINT PortObjectToDevice_PK1 PRIMARY KEY ("NAME","OWNERNAME","MACADDRESS"),
  1798. CONSTRAINT PortObjectToDevice_FK1 FOREIGN KEY ("NAME","OWNERNAME") REFERENCES PortObject("NAME","OWNERNAME") ON DELETE CASCADE,
  1799. index PortObjectToDevice0_ndx  ("NAME"), 
  1800. index PortObjectToDevice1_ndx  ("OWNERNAME"),
  1801. index PortObjectToDevice2_ndx  ("MACADDRESS"))
  1802. TYPE=InnoDB
  1803. EndCreateSchema
  1804.  
  1805. BeginDropSchema
  1806. drop table PortObjectToDevice  
  1807. drop index PortObjectToDevice0_ndx
  1808. drop index PortObjectToDevice1_ndx
  1809. drop index PortObjectToDevice2_ndx
  1810. EndDropSchema
  1811.  
  1812. BeginDropSchema
  1813. drop table PortObject  
  1814. drop index PortObject0_ndx
  1815. drop index PortObject1_ndx
  1816. EndDropSchema
  1817.  
  1818.  
  1819. BeginCreateSchema
  1820. create table Printer (
  1821. "NAME" VARCHAR (100) NOT NULL ,
  1822. "OWNERNAME" VARCHAR (25) NOT NULL , 
  1823. "DEVICESTATUS" INTEGER ,
  1824. "PRINTERSTATUS" INTEGER ,
  1825. "PRINTERDETECTEDERRSTATUS" INTEGER ,
  1826. "CONSOLEDISPBUFFERTEXT" VARCHAR (100) ,
  1827. PRIMARY KEY ("NAME"),
  1828. index Printer0_ndx  ("NAME"),
  1829. index Printer1_ndx  ("OWNERNAME"))
  1830. EndCreateSchema
  1831.  
  1832. BeginDropSchema
  1833. drop table Printer
  1834. drop index Printer0_ndx
  1835. drop index Printer1_ndx
  1836. EndDropSchema
  1837.  
  1838. BeginDropConfigSchema
  1839. drop table ENGINES
  1840. EndDropConfigSchema
  1841.  
  1842. BeginDropConfigSchema
  1843. drop table HOSTS
  1844. EndDropConfigSchema
  1845.  
  1846. BeginDropConfigSchema
  1847. drop table PORTS
  1848. EndDropConfigSchema
  1849.  
  1850. BeginDropConfigSchema
  1851. drop table USERS
  1852. EndDropConfigSchema
  1853.  
  1854. BeginDropConfigSchema
  1855. drop table USERTABLE
  1856. EndDropConfigSchema
  1857.  
  1858.  
  1859.  
  1860. BeginCreateSchema
  1861. create table  OperationsTable ("USERNAME" VARCHAR(50) NOT NULL,
  1862. "OPERATIONID" BIGINT NOT NULL,
  1863. "TEMPLATENAME" VARCHAR(50),
  1864. "SCHEDULEDTIME" VARCHAR(50),
  1865. "STAGE" VARCHAR(50),
  1866. "STATUS" VARCHAR(50),
  1867. PRIMARY KEY ("USERNAME",
  1868. "OPERATIONID"))
  1869. EndCreateSchema
  1870.  
  1871. BeginDropSchema
  1872. drop table OperationsTable
  1873. EndDropSchema
  1874.  
  1875.  
  1876. BeginCreateSchema
  1877. create table BEFailOver (
  1878. "HOSTADDRESS" VARCHAR(50) NOT NULL,
  1879. "NMSBEPORT" INTEGER NOT NULL,
  1880. "RMIREGISTRYPORT" INTEGER,
  1881. "LASTCOUNT" BIGINT,
  1882. "SERVERROLE" VARCHAR(10),
  1883. "STANDBYSERVERNAME" VARCHAR(50),
  1884. index BEFailOver0_ndx ("HOSTADDRESS"),
  1885. index BEFailOver1_ndx ("NMSBEPORT"))
  1886. EndCreateSchema
  1887.  
  1888. BeginDropSchema
  1889. drop table BEFailOver
  1890. drop index BEFailOver0_ndx
  1891. drop index BEFailOver1_ndx
  1892. EndDropSchema
  1893.  
  1894.  
  1895. BeginCreateSchema
  1896. create table PollIDToKeyMap(
  1897. "NAME" VARCHAR(50),
  1898. "ID" BIGINT,
  1899. "AGENT" VARCHAR(50),
  1900. "OID" VARCHAR(100),
  1901. "STATSDATATABLENAME" VARCHAR(100),
  1902. "OWNERNAME" VARCHAR(25))
  1903. EndCreateSchema
  1904.  
  1905. BeginDropSchema
  1906. drop table PollIDToKeyMap
  1907. EndDropSchema
  1908.  
  1909.  
  1910. BeginCreateSchema
  1911. create table ProvisioningVariantProps (
  1912. "VARIANTID"  varchar(50)  NOT NULL,
  1913. "PROPNAME"  varchar(50),
  1914. "PROPVAL"  varchar(50))
  1915. EndCreateSchema
  1916.  
  1917. BeginDropSchema
  1918. drop table ProvisioningVariantProps
  1919. EndDropSchema
  1920.  
  1921.  
  1922. BeginCreateSchema
  1923. create table ProvisioningVariant (
  1924. "DESCRIPTION"  varchar(50),
  1925. "VARIANTID"  varchar(50)  NOT NULL,
  1926. PRIMARY KEY ("VARIANTID"),
  1927. index ProvisioningVariant0_ndx ("VARIANTID"))
  1928. EndCreateSchema
  1929.  
  1930. BeginDropSchema
  1931. drop table ProvisioningVariant
  1932. drop index ProvisioningVariant0_ndx
  1933. EndDropSchema
  1934.  
  1935.  
  1936. BeginCreateSchema
  1937. create table UserConfTable(
  1938. "USERNAME" varchar(50) NOT NULL,
  1939. "OWNERNAME" varchar(50) NOT NULL,
  1940. "STATUS" varchar(20) NOT NULL,
  1941. "PASSWORDEXPIRYTIME" BIGINT,
  1942. "USEREXPIRYTIME" BIGINT,
  1943. "PASSWORDAGE" INTEGER,
  1944. "USERAGE" INTEGER,
  1945. PRIMARY KEY ("USERNAME",
  1946. "OWNERNAME"),
  1947. index UserConfTable0_ndx("STATUS"))
  1948. EndCreateSchema
  1949.  
  1950. #users change perdsistance
  1951. #BeginDropSchema
  1952. #drop table UserConfTable
  1953. #EndDropSchema
  1954.  
  1955.  
  1956. BeginCreateSchema
  1957. create table NetworkInventory (
  1958. "LASTMODIFIEDTIME" varchar(25),
  1959. "MODEL"  varchar(50),
  1960. "TYPE"  varchar(50),
  1961. "CONTACT"  varchar(50),
  1962. "CLASSNAME"  varchar(50),
  1963. "MANAGEDOBJECTNAME"  varchar(50),
  1964. "OPERATIONALSTATUS"  varchar(50),
  1965. "NAME"  varchar(50)  NOT NULL,
  1966. "LOCATION"  varchar(50),
  1967. "ADMINSTATUS"  varchar(50),
  1968. "VENDOR"  varchar(50),
  1969. "DESCRIPTION"  varchar(50),
  1970. PRIMARY KEY ("NAME"),
  1971. index NetworkInventory0_ndx ("NAME"))
  1972. EndCreateSchema
  1973.  
  1974. BeginDropSchema
  1975. drop table NetworkInventory
  1976. drop index NetworkInventory0_ndx
  1977. EndDropSchema
  1978.  
  1979.  
  1980. BeginCreateSchema
  1981. create table TableSpaceStatus (
  1982. "RESOURCENAME" VARCHAR(100) NOT NULL,
  1983. "COMPONENTNAME" VARCHAR(50) NOT NULL,
  1984. "TABLESPACENAME" VARCHAR(25),
  1985. "STATUS" VARCHAR(50),
  1986. "FREEBYTES" INTEGER,
  1987. "FREEBLOCKS" INTEGER,
  1988. "READS" INTEGER,
  1989. "WRITES" INTEGER,
  1990. "READTIME" BIGINT,
  1991. "WRITETIME" BIGINT,
  1992. "COLLECTIONTIME" BIGINT)
  1993. EndCreateSchema
  1994.  
  1995. BeginDropSchema
  1996. drop table TableSpaceStatus
  1997. EndDropSchema
  1998.  
  1999.  
  2000. BeginCreateSchema
  2001. create table CollectData (
  2002. "RESOURCENAME" VARCHAR(100) NOT NULL,
  2003. "COMPONENTNAME" VARCHAR(50) NOT NULL,
  2004. "DISPLAYNAME" VARCHAR(100),
  2005. "TARGETADDRESS" VARCHAR(50),
  2006. "RESOURCETYPE" VARCHAR(50),
  2007. "CONFIGCLASS" VARCHAR(100),
  2008. "DCCLASS" VARCHAR(100),
  2009. "DCXMLNAME" VARCHAR(50),
  2010. "DCDTDNAME" VARCHAR(50),
  2011. "ACTIVE" VARCHAR(10),
  2012. "STOREDATA" VARCHAR(10),
  2013. "CONFIGURED" VARCHAR(10),
  2014. "POLLINTERVAL" INTEGER,
  2015. "APPLNDISCPORT" INTEGER,
  2016. "WEBNMS" VARCHAR(50),
  2017. PRIMARY KEY ("RESOURCENAME",
  2018. "COMPONENTNAME"))
  2019. EndCreateSchema
  2020.  
  2021. BeginDropSchema
  2022. drop table CollectData
  2023. EndDropSchema
  2024.  
  2025.  
  2026.  
  2027. BeginCreateSchema
  2028. create table HostDataCollected (
  2029. "RESOURCENAME" VARCHAR(100) NOT NULL,
  2030. "COMPONENTNAME" VARCHAR(50) NOT NULL,
  2031. "CATEGORY" VARCHAR(250),
  2032. "ENTITY" VARCHAR(50),
  2033. "CURVALUE" BIGINT,
  2034. "COLLECTIONTIME" BIGINT,
  2035. index HostDataCollected0_ndx("COLLECTIONTIME"),
  2036. index HostDataCollected1_ndx("RESOURCENAME",
  2037. "CATEGORY",
  2038. "ENTITY",
  2039. "COLLECTIONTIME"),
  2040. index HostDataCollected2_ndx("RESOURCENAME",
  2041. "COMPONENTNAME",
  2042. "CATEGORY",
  2043. "COLLECTIONTIME"),
  2044. index HostDataCollected3_ndx("RESOURCENAME",
  2045. "COMPONENTNAME",
  2046. "CATEGORY"),
  2047. index HostDataCollected4_ndx("RESOURCENAME",
  2048. "COMPONENTNAME",
  2049. "CATEGORY",
  2050. "ENTITY"))
  2051. EndCreateSchema
  2052.  
  2053. BeginDropSchema
  2054. drop table HostDataCollected
  2055. drop index HostDataCollected0_ndx
  2056. drop index HostDataCollected1_ndx
  2057. drop index HostDataCollected2_ndx
  2058. drop index HostDataCollected3_ndx
  2059. drop index HostDataCollected4_ndx
  2060. EndDropSchema
  2061.  
  2062.  
  2063. BeginCreateSchema
  2064. create table InetService (
  2065. "NAME" VARCHAR(100) NOT NULL,
  2066. "OWNERNAME" VARCHAR(50) NOT NULL,
  2067. "INTERFACENAME" VARCHAR(100),
  2068. "TARGETNAME" VARCHAR(100),
  2069. "TARGETADDRESS" VARCHAR(100),
  2070. "PORTNO" INTEGER,
  2071. "PROTOCOL" VARCHAR(50),
  2072. "PROTOCOLVERSION" VARCHAR(50),
  2073. CONSTRAINT InetService_PK PRIMARY KEY ("NAME","OWNERNAME"),
  2074. INDEX (NAME),
  2075. INDEX (OWNERNAME))
  2076. EndCreateSchema
  2077.  
  2078. BeginDropSchema
  2079. drop table InetService
  2080. EndDropSchema
  2081.  
  2082.  
  2083. BeginCreateSchema
  2084. create table TableSpaceDetails (
  2085. "RESOURCENAME" VARCHAR(100) NOT NULL,
  2086. "COMPONENTNAME" VARCHAR(50) NOT NULL,
  2087. "TABLESPACENAME" VARCHAR(50),
  2088. "ALLOCATEDBYTES" INTEGER,
  2089. "ALLOCATEDBLOCKS" INTEGER,
  2090. "DATAFILES" INTEGER,
  2091. "COLLECTIONTIME" BIGINT)
  2092. EndCreateSchema
  2093.  
  2094. BeginDropSchema
  2095. drop table TableSpaceDetails
  2096. EndDropSchema
  2097.  
  2098.  
  2099. BeginCreateSchema
  2100. create table RollbackData (
  2101. "RESOURCENAME" VARCHAR(100) NOT NULL,
  2102. "COMPONENTNAME" VARCHAR(50) NOT NULL,
  2103. "SEGMENTNAME" VARCHAR(25),
  2104. "TABLESPACENAME" VARCHAR(20),
  2105. "INITIALEXTENT" INTEGER,
  2106. "NEXTEXTENT" INTEGER,
  2107. "MINEXTENT" INTEGER,
  2108. "MAXEXTENT" INTEGER,
  2109. "STATUS" VARCHAR(50),
  2110. "CURRENTSIZE" INTEGER,
  2111. "BLOCKS" INTEGER,
  2112. "GETS" INTEGER,
  2113. "WAITS" INTEGER,
  2114. "HWMSIZE" INTEGER,
  2115. "SHRINKS" INTEGER,
  2116. "WRAPS" INTEGER,
  2117. "EXTEND" INTEGER,
  2118. "COLLECTIONTIME" BIGINT)
  2119. EndCreateSchema
  2120.  
  2121. BeginDropSchema
  2122. drop table RollbackData
  2123. EndDropSchema
  2124.  
  2125.  
  2126. BeginCreateSchema
  2127. create table HostDetails (
  2128. "RESOURCENAME" VARCHAR(100) NOT NULL,
  2129. "COMPONENTNAME" VARCHAR(50) NOT NULL,
  2130. "USERNAME" VARCHAR(25),
  2131. "PASSWORD" VARCHAR(15),
  2132. "PROMPT" VARCHAR(50),
  2133. "CATEGORY" VARCHAR(250),
  2134. "ERRORMSG" VARCHAR(200),
  2135. "LOGINPROMPT" VARCHAR(50),
  2136. "PASSWORDPROMPT" VARCHAR(50),
  2137. PRIMARY KEY ("RESOURCENAME",
  2138. "COMPONENTNAME"))
  2139. EndCreateSchema
  2140.  
  2141. BeginDropSchema
  2142. drop table HostDetails
  2143. EndDropSchema
  2144.  
  2145.  
  2146. BeginCreateSchema
  2147. create table InstanceDetails (
  2148. "RESOURCENAME" VARCHAR(100) NOT NULL,
  2149. "COMPONENTNAME" VARCHAR(50) NOT NULL,
  2150. "VERSION" VARCHAR(17),
  2151. "STARTUPTIME" VARCHAR(50),
  2152. "CREATED" VARCHAR(50),
  2153. "OPENMODE" VARCHAR(20),
  2154. "LOGMODE" VARCHAR(50),
  2155. "COLLECTIONTIME" BIGINT,
  2156. PRIMARY KEY ("RESOURCENAME",
  2157. "COMPONENTNAME"))
  2158. EndCreateSchema
  2159.  
  2160. BeginDropSchema
  2161. drop table InstanceDetails
  2162. EndDropSchema
  2163.  
  2164.  
  2165. BeginCreateSchema
  2166. create table InstanceStatus (
  2167. "RESOURCENAME" VARCHAR(100) NOT NULL,
  2168. "COMPONENTNAME" VARCHAR(50) NOT NULL,
  2169. "DBSIZE" BIGINT,
  2170. "AVGEXECS" INTEGER,
  2171. "AVGUSERS" INTEGER,
  2172. "READS" INTEGER,
  2173. "WRITES" INTEGER,
  2174. "BLOCKSIZE" INTEGER,
  2175. "COLLECTIONTIME" BIGINT)
  2176. EndCreateSchema
  2177.  
  2178. BeginDropSchema
  2179. drop table InstanceStatus
  2180. EndDropSchema
  2181.  
  2182.  
  2183. BeginCreateSchema
  2184. create table SgaStatus (
  2185. "RESOURCENAME" VARCHAR(100) NOT NULL,
  2186. "COMPONENTNAME" VARCHAR(50) NOT NULL,
  2187. "FREEMEMORYSIZE" INTEGER,
  2188. "BUFFERHITRATIO" INTEGER,
  2189. "DICTIONARYHITRATIO" INTEGER,
  2190. "LIBRARYHITRATIO" INTEGER,
  2191. "COLLECTIONTIME" BIGINT)
  2192. EndCreateSchema
  2193.  
  2194. BeginDropSchema
  2195. drop table SgaStatus
  2196. EndDropSchema
  2197.  
  2198.  
  2199. BeginCreateSchema
  2200. create table SessionInfo (
  2201. "RESOURCENAME" VARCHAR(100) NOT NULL,
  2202. "COMPONENTNAME" VARCHAR(50) NOT NULL,
  2203. "SESSIONID" INTEGER,
  2204. "STATUS" VARCHAR(25),
  2205. "MACHINE" VARCHAR(50),
  2206. "USERNAME" VARCHAR(25),
  2207. "ELAPSEDTIME" INTEGER,
  2208. "CPUUSED" INTEGER,
  2209. "MEMORYSORTS" INTEGER,
  2210. "TABLESCANS" INTEGER,
  2211. "PHYSICALREADS" INTEGER,
  2212. "LOGICALREADS" INTEGER,
  2213. "DISKSORTS" INTEGER,
  2214. "BLOCKSCHANGED" INTEGER,
  2215. "CHAINEDROWS" INTEGER,
  2216. "COMMITS" INTEGER,
  2217. "CURSORS" INTEGER,
  2218. "BUFFERCACHEHITRATIO" VARCHAR(50),
  2219. "COLLECTIONTIME" BIGINT)
  2220. EndCreateSchema
  2221.  
  2222. BeginDropSchema
  2223. drop table SessionInfo
  2224. EndDropSchema
  2225.  
  2226.  
  2227. BeginCreateSchema
  2228. create table SgaDetails (
  2229. "RESOURCENAME" VARCHAR(100) NOT NULL,
  2230. "COMPONENTNAME" VARCHAR(50) NOT NULL,
  2231. "BUFFERCACHESIZE" INTEGER,
  2232. "SHAREDPOOLSIZE" INTEGER,
  2233. "REDOLOGBUFFERSIZE" INTEGER,
  2234. "LIBRARYCACHESIZE" INTEGER,
  2235. "DATADICTCACHESIZE" INTEGER,
  2236. "SQLAREASIZE" INTEGER,
  2237. "FIXEDSIZE" INTEGER,
  2238. "COLLECTIONTIME" BIGINT)
  2239. EndCreateSchema
  2240.  
  2241. BeginDropSchema
  2242. drop table SgaDetails
  2243. EndDropSchema
  2244.  
  2245.  
  2246. BeginCreateSchema
  2247. create table RedoLogs (
  2248. "RESOURCENAME" VARCHAR(100) NOT NULL,
  2249. "COMPONENTNAME" VARCHAR(50) NOT NULL,
  2250. "GROUPNAME" VARCHAR(25),
  2251. "THREAD" VARCHAR(20),
  2252. "SEQUENCE" INTEGER,
  2253. "BYTES" INTEGER,
  2254. "MEMBERS" INTEGER,
  2255. "ARCHIVE" VARCHAR(10),
  2256. "STATUS" VARCHAR(20),
  2257. "FIRSTTIME" VARCHAR(50),
  2258. "MEMBER" VARCHAR(100),
  2259. "MSTATUS" VARCHAR(50),
  2260. "COLLECTIONTIME" BIGINT)
  2261. EndCreateSchema
  2262.  
  2263. BeginDropSchema
  2264. drop table RedoLogs
  2265. EndDropSchema
  2266.  
  2267.  
  2268. BeginCreateSchema
  2269. create table OracleCollectData (
  2270. "RESOURCENAME" VARCHAR(100) NOT NULL,
  2271. "COMPONENTNAME" VARCHAR(100) NOT NULL,
  2272. "USERNAME" VARCHAR(50),
  2273. "PASSWORD" VARCHAR(50),
  2274. "INSTANCENAME" VARCHAR(50),
  2275. "DRIVERNAME" VARCHAR(100),
  2276. "STATE" INTEGER,
  2277. "COLLECTSTATICDATA" VARCHAR(10),
  2278. "ERRORMSG" VARCHAR(250),
  2279. PRIMARY KEY ("RESOURCENAME",
  2280. "COMPONENTNAME"))
  2281. EndCreateSchema
  2282.  
  2283. BeginDropSchema
  2284. drop table OracleCollectData
  2285. EndDropSchema
  2286.  
  2287.  
  2288. BeginCreateSchema
  2289. create table RegionalServerToMOMap (
  2290. "REGIONALSERVERNAME" VARCHAR(100) NOT NULL,
  2291. "MONAME" VARCHAR(100) NOT NULL,
  2292. PRIMARY KEY ("REGIONALSERVERNAME","MONAME"),
  2293. index RegionalServerToMOMap0_ndx("REGIONALSERVERNAME"),
  2294. index RegionalServerToMOMap1_ndx("MONAME"))
  2295. EndCreateSchema
  2296.  
  2297. BeginDropSchema
  2298. drop table RegionalServerToMOMap
  2299. drop index RegionalServerToMOMap0_ndx
  2300. drop index RegionalServerToMOMap1_ndx
  2301. EndDropSchema
  2302.  
  2303.  
  2304. BeginCreateSchema
  2305. create table DataFiles (
  2306. "RESOURCENAME" VARCHAR(100) NOT NULL,
  2307. "COMPONENTNAME" VARCHAR(50) NOT NULL,
  2308. "FILE_NAME" VARCHAR(100),
  2309. "TABLESPACENAME" VARCHAR(25),
  2310. "STATUS" VARCHAR(50),
  2311. "CREATEBYTES" INTEGER,
  2312. "READS" INTEGER,
  2313. "WRITES" INTEGER,
  2314. "AVGRDTIME" INTEGER,
  2315. "AVGWRTIME" INTEGER,
  2316. "COLLECTIONTIME" BIGINT)
  2317. EndCreateSchema
  2318.  
  2319. BeginDropSchema
  2320. drop table DataFiles
  2321. EndDropSchema
  2322.  
  2323.  
  2324. BeginCreateSchema
  2325. create table OpManagerObject ( 
  2326. "NAME"  VARCHAR(100)  NOT NULL , 
  2327. "OWNERNAME"  VARCHAR(25)  NOT NULL , 
  2328. "DEPENDENT"  VARCHAR(50), 
  2329. "DEBOUNCECOUNT"  INTEGER   , 
  2330. "RAMSIZE"  INTEGER   , 
  2331. "HARDDISKSIZE"  INTEGER   , 
  2332. "UPDEPENDENCY"  VARCHAR(10), 
  2333. "CATEGORY"  VARCHAR(50), 
  2334. "OS"  VARCHAR(50), 
  2335. "PROFILE"  VARCHAR(255), 
  2336. "ENCODING" VARCHAR(50),
  2337. PRIMARY KEY ("NAME", "OWNERNAME"),
  2338. index OpManagerObject0_ndx ("NAME"),
  2339. index OpManagerObject1_ndx ("OWNERNAME"),
  2340. index OpManagerObject2_ndx ("CATEGORY"))
  2341. EndCreateSchema
  2342.  
  2343. BeginDropSchema
  2344. drop table OpManagerObject
  2345. EndDropSchema
  2346.  
  2347. BeginCreateSchema
  2348. create table HRDetails ( 
  2349. "AGENTNAME"  VARCHAR(100)  NOT NULL , 
  2350. "TYPE"  VARCHAR(25), 
  2351. "USERNAME"  VARCHAR(50), 
  2352. "PASSWORD"  VARCHAR(50), 
  2353. PRIMARY KEY ("AGENTNAME"),
  2354. index HRDetails0_ndx ("AGENTNAME"))
  2355. EndCreateSchema
  2356.  
  2357. BeginDropSchema
  2358. drop table HRDetails
  2359. drop index HRDetails0_ndx 
  2360. EndDropSchema
  2361.  
  2362.  
  2363. BeginCreateSchema
  2364. create table CLIDetails (
  2365. "AGENTNAME" VARCHAR(100) NOT NULL,
  2366. "PROMPT" VARCHAR(50),
  2367. "LOGINPROMPT" VARCHAR(50),
  2368. "PASSWORDPROMPT" VARCHAR(50),
  2369. "PROTOCOL" VARCHAR(50),
  2370. PRIMARY KEY ("AGENTNAME"),
  2371. index CLIDetails0_ndx ("AGENTNAME"))
  2372. EndCreateSchema
  2373.  
  2374. BeginDropSchema
  2375. drop table CLIDetails
  2376. drop index CLIDetails0_ndx
  2377. EndDropSchema
  2378.  
  2379.  
  2380. BeginCreateSchema
  2381. create table availability_statistics (
  2382. "POLLID" BIGINT,
  2383. "INSTANCE" varchar(100),
  2384. "DOWNTIME" BIGINT,
  2385. "UPTIME" BIGINT,
  2386. index availability0_ndx(POLLID,INSTANCE,UPTIME))
  2387. EndCreateSchema
  2388.  
  2389. BeginDropSchema
  2390. drop table availability_statistics
  2391. drop index availability0_ndx
  2392. EndDropSchema
  2393.  
  2394.  
  2395. # Drop table is not needed for STATSDATA_DAILY and STATSDATA_HOURLY. 
  2396. # Because it will be considered as statsdata tables and deleted by NMS itself along with statsdata_<date> tables.
  2397.  
  2398. BeginCreateSchema
  2399. create table STATSDATA_DAILY(
  2400. "POLLID" BIGINT,
  2401. "INSTANCE" varchar(100),
  2402. "TTIME" BIGINT,
  2403. "VAL" BIGINT,
  2404. "MINVALUE" BIGINT,
  2405. "MAXVALUE" BIGINT,
  2406. "TINTERVAL"  BIGINT, 
  2407. index STATSDATA_DAILY0_ndx("POLLID"),
  2408. index STATSDATA_DAILY1_ndx("INSTANCE"),
  2409. index STATSDATA_DAILY2_ndx("TTIME"),
  2410. index STATSDATA_DAILY3_ndx("VAL"))
  2411. EndCreateSchema
  2412.  
  2413. BeginDropSchema
  2414. drop index STATSDATA_DAILY0_ndx
  2415. drop index STATSDATA_DAILY1_ndx
  2416. drop index STATSDATA_DAILY2_ndx
  2417. drop index STATSDATA_DAILY3_ndx
  2418. EndDropSchema
  2419.  
  2420.  
  2421. BeginCreateSchema
  2422. create table STATSDATA_HOURLY(
  2423. "POLLID" BIGINT,
  2424. "INSTANCE" varchar(100),
  2425. "TTIME" BIGINT,
  2426. "VAL" BIGINT,
  2427. "MINVALUE" BIGINT,
  2428. "MAXVALUE" BIGINT,
  2429. "TINTERVAL"  BIGINT,
  2430. index STATSDATA_HOURLY0_ndx("POLLID"),
  2431. index STATSDATA_HOURLY1_ndx("INSTANCE"),
  2432. index STATSDATA_HOURLY2_ndx("TTIME"),
  2433. index STATSDATA_HOURLY3_ndx("VAL"))
  2434. EndCreateSchema
  2435.  
  2436. BeginDropSchema
  2437. drop index STATSDATA_HOURLY0_ndx
  2438. drop index STATSDATA_HOURLY1_ndx
  2439. drop index STATSDATA_HOURLY2_ndx
  2440. drop index STATSDATA_HOURLY3_ndx
  2441. EndDropSchema
  2442.  
  2443. BeginCreateSchema
  2444. create table STATSDATA_HTML(
  2445. "NAME" varchar(100) NOT NULL,
  2446. "AGENT" varchar(100) NOT NULL,
  2447. "DISPLAYNAME" varchar(100),
  2448. "CATEGORY" varchar(50) NOT NULL,
  2449. "INSTANCE" varchar(50),
  2450. "TTIME" BIGINT NOT NULL,
  2451. "AVG"  BIGINT,
  2452. PRIMARY KEY ("NAME","AGENT", "CATEGORY", "TTIME", "INSTANCE"),
  2453. index STATSDATA_HTML0_ndx("NAME"),
  2454. index STATSDATA_HTML1_ndx("AGENT"),
  2455. index STATSDATA_HTML2_ndx("CATEGORY"),
  2456. index STATSDATA_HTMl3_ndx("TTIME"))
  2457. EndCreateSchema
  2458.  
  2459. BeginCreateSchema
  2460. create table AccessPoint (
  2461. "NAME"  VARCHAR(50)  NOT NULL,
  2462. "OWNERNAME"  VARCHAR(50)  NOT NULL,
  2463. "MACADDRESS"  VARCHAR(30),
  2464. "SYSLOCATION" VARCHAR(50),
  2465. "SYSUPTIME" VARCHAR(50),
  2466. "VENDOR"  VARCHAR(50),
  2467. "DHCPSERVER"  VARCHAR(50),
  2468. "MODEL"  VARCHAR(50),
  2469. "FIRMWAREVERSION" VARCHAR(50),
  2470. "APROLE"  INTEGER,
  2471. "APDISCOVERYTYPE"  VARCHAR(30),
  2472. "APTYPE"  VARCHAR(20),
  2473. PRIMARY KEY ("NAME","OWNERNAME"),
  2474. index AccessPoint0_ndx("NAME"),
  2475. index AccessPoint1_ndx("OWNERNAME"))
  2476. TYPE=InnoDB
  2477. EndCreateSchema
  2478.  
  2479.  
  2480. BeginCreateSchema
  2481. create table NeighborAPs (
  2482. "NAME"  VARCHAR(50)  NOT NULL,
  2483. "NEIGHBORAP"  VARCHAR(50)  NOT NULL,
  2484. "TYPE"  VARCHAR(30),
  2485. PRIMARY KEY ("NAME","NEIGHBORAP"),
  2486. index NeighborAPs0_ndx ("NAME"),
  2487. index NeighborAPs1_ndx ("NEIGHBORAP"),
  2488. CONSTRAINT NeighborAPs_FK1 FOREIGN KEY (NAME) REFERENCES AccessPoint(NAME) ON DELETE CASCADE,
  2489. CONSTRAINT NeighborAPs_FK2 FOREIGN KEY (NEIGHBORAP) REFERENCES AccessPoint(NAME) ON DELETE CASCADE
  2490. )
  2491. TYPE=InnoDB
  2492. EndCreateSchema
  2493.  
  2494. BeginDropSchema
  2495. drop table NeighborAPs
  2496. drop index NeighborAPs0_ndx
  2497. drop index NeighborAPs1_ndx
  2498. EndDropSchema
  2499.  
  2500.  
  2501. BeginCreateSchema
  2502. create table RadioInterface(
  2503. "NAME" VARCHAR(50) NOT NULL,
  2504. "OWNERNAME" VARCHAR(50)  NOT NULL,
  2505. "INTERFACEMACADDRESS" VARCHAR(30),
  2506. "INTERFACENAME" VARCHAR(30),
  2507. "INTERFACEINDEX" VARCHAR(50),
  2508. "INTERFACESTATUS"  INTEGER,
  2509. "PARENTNODE"  VARCHAR(50),
  2510. "OPERATIONMODE"  VARCHAR(20),
  2511. "CHANNEL" INTEGER,
  2512. "BEACONRATE"  INTEGER,
  2513. "PREAMBLE" VARCHAR(20),
  2514. "TRANSMITPOWER" INTEGER,
  2515. "MODULATION"  VARCHAR(10),
  2516. "DATARATE"  VARCHAR(100),
  2517. "PHYTYPE"  VARCHAR(10),
  2518. "FIRSTSEEN" BIGINT NOT NULL,
  2519. "LASTSEEN" BIGINT NOT NULL,
  2520. "NEARESTSENSOR" VARCHAR(50) NOT NULL,
  2521. "SIGNALSTRENGTH" INTEGER NOT NULL,
  2522. "NOISELEVEL" INTEGER NOT NULL,
  2523. CONSTRAINT RadioInterface_PK PRIMARY KEY ("NAME","OWNERNAME"),
  2524. index RadioInterface0_ndx ("NAME"),
  2525. index RadioInterface1_ndx ("OWNERNAME"),
  2526. index RadioInterface2_ndx ("PARENTNODE"),
  2527. index RadioInterface3_ndx ("CHANNEL"))
  2528. TYPE=InnoDB
  2529. EndCreateSchema
  2530.  
  2531. BeginDropSchema
  2532. drop table DeviceCLIDetails
  2533. drop index DeviceCLIDetails0_ndx
  2534. drop index DeviceCLIDetails1_ndx
  2535. EndDropSchema
  2536.  
  2537. BeginDropSchema
  2538. drop table DeviceHTTPDetails
  2539. drop index DeviceHTTPDetails0_ndx
  2540. EndDropSchema
  2541.  
  2542. #BeginDropSchema
  2543. #drop table WPAEncryptionType
  2544. #EndDropSchema
  2545.  
  2546. #BeginDropSchema
  2547. #drop table WEPEncryptionType
  2548. #EndDropSchema
  2549.  
  2550. #BeginDropSchema
  2551. #drop table RSNEncryptionType
  2552. #EndDropSchema
  2553.  
  2554. #BeginDropSchema
  2555. #drop table PSKDetails
  2556. #EndDropSchema
  2557.  
  2558. #BeginDropSchema
  2559. #drop table ServiceRadioRelationship
  2560. #EndDropSchema
  2561.  
  2562. BeginDropSchema
  2563. drop table ServiceProfile
  2564. drop index ServiceProfile_FK1
  2565. drop index ServiceProfile_FK2
  2566. drop index ServiceProfile_FK3
  2567. EndDropSchema
  2568.  
  2569. BeginDropSchema
  2570. drop table SSIDDetails
  2571. drop index SSIDDetails0_ndx
  2572. drop index SSIDDetails1_ndx
  2573. EndDropSchema
  2574.  
  2575. BeginDropSchema
  2576. drop table RadioInterface
  2577. drop index RadioInterface0_ndx
  2578. drop index RadioInterface1_ndx
  2579. drop index RadioInterface2_ndx
  2580. drop index RadioInterface3_ndx
  2581. EndDropSchema
  2582.  
  2583. BeginDropSchema
  2584. drop table AccessPoint
  2585. drop index AccessPoint0_ndx
  2586. drop index AccessPoint1_ndx
  2587. EndDropSchema
  2588.  
  2589. BeginCreateSchema
  2590. create table DeviceCLIDetails (
  2591. "CREDENTIALID" INTEGER  NOT NULL, 
  2592. "NAME"  VARCHAR(50)  NOT NULL,
  2593. "PROTOCOL"  VARCHAR(10),
  2594. "PORT"  INTEGER,
  2595. "USERNAME" VARCHAR(50),
  2596. "PASSWORD" VARCHAR(50),
  2597. "ENABLEPASSWORD" VARCHAR(50),
  2598. "PROMPT" VARCHAR(10),
  2599. "LOGINPROMPT"  VARCHAR(10),
  2600. "PASSWORDPROMPT"  VARCHAR(10),
  2601. "ENABLEPROMPT"  VARCHAR(10),
  2602. PRIMARY KEY ("CREDENTIALID"),
  2603. index  DeviceCLIDetails0_ndx ("NAME"),
  2604. index  DeviceCLIDetails1_ndx ("CREDENTIALID"))
  2605. TYPE=InnoDB
  2606. EndCreateSchema
  2607.  
  2608. BeginCreateSchema
  2609. create table DeviceHTTPDetails (
  2610. "CREDENTIALID" INTEGER  NOT NULL,
  2611. "NAME"  VARCHAR(50)  NOT NULL,
  2612. "PORT"  INTEGER,
  2613. "USERNAME" VARCHAR(50),
  2614. "PASSWORD" VARCHAR(50),
  2615. PRIMARY KEY ("CREDENTIALID"),
  2616. index  DeviceHTTPDetails0_ndx ("CREDENTIALID")
  2617. )
  2618. EndCreateSchema
  2619.  
  2620. BeginCreateSchema
  2621. create table GroupDetails (
  2622. "GROUPID" BIGINT  NOT NULL,
  2623. "GROUPNAME"  VARCHAR(50) NOT NULL,
  2624. "GROUPDESCRIPTION"  VARCHAR(200),
  2625. "USERNAME" VARCHAR(50) NOT NULL,
  2626. "GROUPTYPE" VARCHAR(15),
  2627. "CRITERIAID" VARCHAR(50),
  2628. "CONDITION" INT NOT NULL,
  2629. PRIMARY KEY ("GROUPID","USERNAME"),
  2630. index GroupDetails0_ndx ("GROUPID"))
  2631. EndCreateSchema
  2632.  
  2633.  
  2634. BeginDropSchema
  2635. drop table GroupDetails
  2636. drop index GroupDetails0_ndx
  2637. EndDropSchema
  2638.  
  2639.  
  2640. BeginCreateSchema
  2641. create table GroupTree (
  2642. "PARENTID" BIGINT,
  2643. "CHILDID"  BIGINT NOT NULL,
  2644. "USERNAME" VARCHAR(50) NOT NULL,
  2645. PRIMARY KEY ("CHILDID","USERNAME"),
  2646. index GroupTree0_ndx ("CHILDID"))
  2647. EndCreateSchema
  2648.  
  2649. BeginDropSchema
  2650. drop table GroupTree
  2651. drop index GroupTree0_ndx
  2652. EndDropSchema
  2653.  
  2654. BeginCreateSchema
  2655. create table FirmwareImage (
  2656. "NAME"  VARCHAR(50) NOT NULL,
  2657. "DESCRIPTION" VARCHAR(200),
  2658. "DEVICETYPE" VARCHAR(50),
  2659. "DEVICEMODEL" VARCHAR(50),
  2660. "VERSION" VARCHAR(20),
  2661. "BOOTFILENAME" VARCHAR(50),
  2662. PRIMARY KEY ("NAME"),
  2663. index FirmwareImage0_ndx ("NAME"))
  2664. EndCreateSchema
  2665.  
  2666. #users change perdsistance
  2667. #BeginDropSchema
  2668. #drop table FirmwareImage
  2669. #EndDropSchema
  2670.  
  2671. BeginCreateSchema
  2672. create table MobileUnit (
  2673. "NAME"  VARCHAR(50)  NOT NULL,
  2674. "OWNERNAME"   VARCHAR(50)  NOT NULL,
  2675. "MUMACADDRESS"  VARCHAR(30),
  2676. "POWERMODE"  INTEGER,
  2677. "MUVENDOR"  VARCHAR(50),
  2678. "MUMODEL"  VARCHAR(50),
  2679. "MUDATARATE"  VARCHAR(100),
  2680. "ASSOCIATIONSTATUS" INTEGER,
  2681. "SSID"  VARCHAR(50),
  2682. "APNAME"  VARCHAR(50),
  2683. "NEARESTSENSOR"  VARCHAR(50),
  2684. "SIGNALSTRENGTH" INTEGER NOT NULL,
  2685. "NOISELEVEL" INTEGER NOT NULL,
  2686. "ASSOCIATIONTIME"  BIGINT,
  2687. "FIRSTSEENTIME"  BIGINT,
  2688. "LASTSEENTIME"  BIGINT,
  2689. "MUTYPE"  VARCHAR(20),
  2690. PRIMARY KEY ("NAME","OWNERNAME"),
  2691. index MobileUnit0_ndx ("NAME"),
  2692. index MobileUnit1_ndx ("OWNERNAME"),
  2693. index MobileUnit2_ndx ("APNAME"),
  2694. index MobileUnit3_ndx ("MUMACADDRESS"))
  2695. EndCreateSchema
  2696.  
  2697. BeginDropSchema
  2698. drop table MobileUnit
  2699. drop index MobileUnit0_ndx
  2700. drop index MobileUnit1_ndx
  2701. drop index MobileUnit2_ndx
  2702. drop index MobileUnit3_ndx
  2703. EndDropSchema
  2704.  
  2705. BeginCreateSchema
  2706. create table SensorObject(
  2707. "NAME"  VARCHAR(50)  NOT NULL,
  2708. "OWNERNAME"   VARCHAR(50)  NOT NULL,
  2709. "MACADDRESS"  VARCHAR(30),
  2710. "SYSLOCATION" VARCHAR(50),
  2711. "SYSUPTIME" VARCHAR(50),
  2712. "DISCARDERRORS" INTEGER,
  2713. "SENDPROBE" INTEGER,
  2714. "SNAPSHOTLENGTH" INTEGER,
  2715. "STATISTICALINTERVAL" INTEGER,
  2716. "CHANNELDWELLTIME" INTEGER,
  2717. "WEBKEY1" INTEGER,
  2718. "VALUE1" VARCHAR(30),
  2719. "WEBKEY2" INTEGER,
  2720. "VALUE2" VARCHAR(30),
  2721. "WEBKEY3" INTEGER,
  2722. "VALUE3" VARCHAR(30),
  2723. "WEBKEY4" INTEGER,
  2724. "VALUE4" VARCHAR(30),
  2725. "CHANNELBITMAP" INTEGER,
  2726. "CHANNELSURF" INTEGER,
  2727. "WEBDECRYPT" INTEGER,
  2728. PRIMARY KEY ("NAME","OWNERNAME"),
  2729. index SensorObject0_ndx("NAME"),
  2730. index SensorObject1_ndx("OWNERNAME"))
  2731. EndCreateSchema
  2732.  
  2733. BeginDropSchema
  2734. drop table SensorObject
  2735. drop index SensorObject0_ndx
  2736. drop index SensorObject1_ndx
  2737. EndDropSchema
  2738.  
  2739.  
  2740. BeginCreateSchema
  2741. create table MUSignalStrengthHistory (
  2742. "RECORDID" BIGINT NOT NULL,
  2743. "MUNAME"  VARCHAR(50) NOT NULL,
  2744. "ASSOCIATEDAP"  VARCHAR(50),
  2745. "SIGNALSTRENGTH" INTEGER ,
  2746. "NOISELEVEL" INTEGER ,
  2747. "SIGNALQUALITY" INTEGER ,
  2748. "ASSOCIATIONTIME" BIGINT ,
  2749. PRIMARY KEY ("RECORDID"),
  2750. index MUSignalStrengthHistory0_ndx ("RECORDID"))
  2751. EndCreateSchema
  2752.  
  2753. BeginDropSchema
  2754. drop table MUSignalStrengthHistory
  2755. drop index MUSignalStrengthHistory0_ndx
  2756. EndDropSchema
  2757.  
  2758. BeginCreateSchema
  2759. create table AssociationHistory (
  2760. "RECORDID" BIGINT  NOT NULL,
  2761. "MUNAME"  VARCHAR(50),
  2762. "APNAME"  VARCHAR(50),
  2763. "ASSOCIATIONTIME" BIGINT,
  2764. "DISASSOCIATIONTIME" BIGINT,
  2765. "SSID"  VARCHAR(50),
  2766. PRIMARY KEY ("RECORDID"),
  2767. index AssociationHistory0_ndx ("RECORDID"),
  2768. index AssociationHistory1_ndx ("MUNAME"),
  2769. index AssociationHistory2_ndx ("APNAME"),
  2770. index AssociationHistory3_ndx ("DISASSOCIATIONTIME"))
  2771. EndCreateSchema
  2772.  
  2773. BeginDropSchema
  2774. drop table AssociationHistory
  2775. drop index AssociationHistory0_ndx
  2776. drop index AssociationHistory1_ndx
  2777. drop index AssociationHistory2_ndx
  2778. drop index AssociationHistory3_ndx
  2779. EndDropSchema
  2780.  
  2781. BeginCreateSchema
  2782. create table ActiveAssociationCountHistory (
  2783. "ATIME" BIGINT,
  2784. "ACTIVECOUNT" BIGINT)
  2785. EndCreateSchema
  2786.  
  2787. BeginDropSchema
  2788. drop table ActiveAssociationCountHistory
  2789. EndDropSchema
  2790.  
  2791. BeginCreateSchema
  2792. create table ActiveAssociationCountHistory_Hourly (
  2793. "ATIME" BIGINT,
  2794. "MINVALUE" BIGINT,
  2795. "MAXVALUE" BIGINT,
  2796. "AVGACTIVECOUNT" DOUBLE,
  2797. "AINTERVAL" BIGINT)
  2798. EndCreateSchema
  2799.       
  2800. BeginDropSchema
  2801. drop table ActiveAssociationCountHistory_Hourly
  2802. EndDropSchema
  2803.  
  2804. BeginCreateSchema
  2805. create table FirmwareTaskDetails (
  2806. "TASKNAME"  VARCHAR(50) NOT NULL,
  2807. "SCHEDULETYPE" VARCHAR(20),
  2808. "SCHEDULETIME" BIGINT,
  2809. "RESTORECONFIGURATION" VARCHAR(10),
  2810. "DESCRIPTION" text,
  2811. PRIMARY KEY ("TASKNAME"),
  2812. index FirmwareTaskDetails0_ndx ("TASKNAME"))
  2813. EndCreateSchema
  2814.  
  2815. BeginDropSchema
  2816. drop table FirmwareTaskDetails
  2817. drop index FirmwareTaskDetails0_ndx
  2818. EndDropSchema
  2819.  
  2820.  
  2821. BeginCreateSchema
  2822. create table SSIDDetails (
  2823. "NAME"  VARCHAR(50)  NOT NULL,
  2824. "APSSID"  VARCHAR(50)  NOT NULL,
  2825. "ENCRYPTIONTYPE"  INTEGER,
  2826. "AUTHTYPE" INTEGER,
  2827. "MODE" INTEGER,
  2828. "VLANID"  INTEGER,
  2829. "ISPRIMARY" BOOL NOT NULL,
  2830. PRIMARY KEY ("NAME","APSSID"),
  2831. CONSTRAINT ssidDetails_FK1 FOREIGN KEY (NAME) REFERENCES RadioInterface(NAME) ON DELETE CASCADE,
  2832. index SSIDDetails0_ndx ("NAME"),
  2833. index SSIDDetails1_ndx ("APSSID"))
  2834. TYPE=InnoDB
  2835. EndCreateSchema
  2836.  
  2837. BeginCreateSchema
  2838. create table ConfigHistory (
  2839. "RECORDID" BIGINT  NOT NULL,
  2840. "HISTORYTYPE"  INTEGER,
  2841. "DEVICENAME"  VARCHAR(50),
  2842. "TIMEVALUE" BIGINT,
  2843. "STATUS"  INTEGER,
  2844. "MMESSAGE"  VARCHAR(200),
  2845. PRIMARY KEY ("RECORDID"),
  2846. index ConfigHistory0_ndx ("RECORDID"))
  2847. EndCreateSchema
  2848.  
  2849. BeginDropSchema
  2850. drop table ConfigHistory
  2851. drop index ConfigHistory0_ndx
  2852. EndDropSchema
  2853.  
  2854. BeginCreateSchema
  2855. create table StationStats(
  2856. "RECORDID" BIGINT  NOT NULL,
  2857. "TIMEVALUE" BIGINT  NOT NULL,
  2858. "MACADDRESS" VARCHAR(17)  NOT NULL,
  2859. "CHANNEL" INTEGER,
  2860. "TYPE" INTEGER,
  2861. "AVERAGESIGNAL" INTEGER,
  2862. "AVERAGENOISE" INTEGER,
  2863. "NEARESTSENSOR" VARCHAR(17),
  2864. "SECURITY" BOOL  NOT NULL,
  2865. "NUMBYTESINPERIOD" INTEGER,
  2866. "NUMPACKETSIN" INTEGER,
  2867. "NUMBYTES" INTEGER,
  2868. "NUMPACKETS" INTEGER,
  2869. "UTILIZATION" INTEGER,
  2870. PRIMARY KEY ("RECORDID"))
  2871. EndCreateSchema
  2872.  
  2873. BeginDropSchema
  2874. drop table StationStats
  2875. EndDropSchema
  2876.  
  2877.  
  2878.  
  2879. BeginCreateSchema
  2880. create table StationPacketSpeedStats(
  2881. "RECORDID" BIGINT  NOT NULL,
  2882. "TIMEVALUE" BIGINT  NOT NULL,
  2883. "MACADDRESS"  VARCHAR(50)  NOT NULL,
  2884. "SPEED1PACKETS" INTEGER,
  2885. "SPEED2PACKETS" INTEGER,
  2886. "SPEED5PACKETS" INTEGER,
  2887. "SPEED6PACKETS" INTEGER,
  2888. "SPEED9PACKETS" INTEGER,
  2889. "SPEED11PACKETS" INTEGER,
  2890. "SPEED12PACKETS" INTEGER,
  2891. "SPEED18PACKETS" INTEGER,
  2892. "SPEED24PACKETS" INTEGER,
  2893. "SPEED36PACKETS" INTEGER,
  2894. "SPEED48PACKETS" INTEGER,
  2895. "SPEED54PACKETS" INTEGER,
  2896. "SPEED1BYTES" INTEGER,
  2897. "SPEED2BYTES" INTEGER,
  2898. "SPEED5BYTES" INTEGER,
  2899. "SPEED6BYTES" INTEGER,
  2900. "SPEED9BYTES" INTEGER,
  2901. "SPEED11BYTES" INTEGER,
  2902. "SPEED12BYTES" INTEGER,
  2903. "SPEED18BYTES" INTEGER,
  2904. "SPEED24BYTES" INTEGER,
  2905. "SPEED36BYTES" INTEGER,
  2906. "SPEED48BYTES" INTEGER,
  2907. "SPEED54BYTES" INTEGER,
  2908. PRIMARY KEY ("RECORDID"))
  2909. EndCreateSchema
  2910.  
  2911. BeginDropSchema
  2912. drop table StationPacketSpeedStats
  2913. EndDropSchema
  2914.  
  2915.  
  2916. BeginCreateSchema
  2917. create table StationFrameStats(
  2918. "RECORDID" BIGINT  NOT NULL,
  2919. "TIMEVALUE" BIGINT  NOT NULL,
  2920. "MACADDRESS"  VARCHAR(50)  NOT NULL,
  2921. "ASSOCREQPACKETS" INTEGER,
  2922. "ASSOCREQBYTES" INTEGER,                
  2923. "ASSOCRESPPACKETS" INTEGER,
  2924. "ASSOCRESPBYTES" INTEGER,
  2925. "REASSOCREQPACKETS" INTEGER,
  2926. "REASSOCREQBYTES" INTEGER,
  2927. "REASSOCRESPPACKETS" INTEGER,
  2928. "REASSOCRESPBYTES" INTEGER,
  2929. "PROBEREQPACKETS" INTEGER,
  2930. "PROBEREQBYTES" INTEGER,
  2931. "PROBERESPPACKETS" INTEGER,
  2932. "PROBERESPBYTES" INTEGER,
  2933. "BEACONPACKETS" INTEGER,
  2934. "BEACONBYTES" INTEGER,
  2935. "ATIMPACKETS" INTEGER,
  2936. "ATIMBYTES" INTEGER,
  2937. "DISSOCPACKETS" INTEGER,
  2938. "DISSOCBYTES" INTEGER,
  2939. "AUTHPACKETS" INTEGER,
  2940. "AUTHBYTES" INTEGER,
  2941. "DEAUTHPACKETS" INTEGER,
  2942. "DEAUTHBYTES" INTEGER,
  2943. "PSPOLLPACKETS" INTEGER,
  2944. "PSPOLLBYTES" INTEGER,
  2945. "RTSPACKETS" INTEGER,
  2946. "RTSBYTES" INTEGER,
  2947. "CTSPACKETS" INTEGER,
  2948. "CTSBYTES" INTEGER,
  2949. "ACKPACKETS" INTEGER,
  2950. "ACKBYTES" INTEGER,
  2951. "CFENDPACKETS" INTEGER,
  2952. "CFENDBYTES" INTEGER,
  2953. "CFENDCFACKPACKETS" INTEGER,
  2954. "CFENDCFACKBYTES" INTEGER,
  2955. "DATAPACKETS" INTEGER,
  2956. "DATABYTES" INTEGER,
  2957. "DATACFACKPACKETS" INTEGER,
  2958. "DATACFACKBYTES" INTEGER,
  2959. "DATACFPOLLPACKETS" INTEGER,
  2960. "DATACFPOLLBYTES" INTEGER,
  2961. "DATACFACKCFPOLLPACKETs" INTEGER,
  2962. "DATACFACKCFPOLLBYTES" INTEGER,
  2963. "NULLPACKETS" INTEGER,
  2964. "NULLBYTES" INTEGER,
  2965. "CFACKPACKETS" INTEGER,
  2966. "CFACKBYTES" INTEGER,
  2967. "CFPOLLPACKETS" INTEGER,
  2968. "CFPOLLBYTES" INTEGER,
  2969. "CFACKCFPOLLPACKETS" INTEGER,
  2970. "CFACKCFPOLLBYTES" INTEGER,
  2971. PRIMARY KEY ("RECORDID"))
  2972. EndCreateSchema
  2973.  
  2974. BeginDropSchema
  2975. drop table StationFrameStats
  2976. EndDropSchema
  2977.  
  2978. ###############################  Base Object  ##################################################
  2979.  
  2980.  
  2981. BeginCreateSchema
  2982. create table WifiObject ( 
  2983. "NAME"  VARCHAR(100)  NOT NULL , 
  2984. "OWNERNAME"  VARCHAR(25)  NOT NULL , 
  2985. "WIFI_VENDOR" VARCHAR(255),
  2986. "WIFI_MODEL" VARCHAR(255),
  2987. "WIFI_FIRMWAREVERSION" VARCHAR(20),
  2988. "WIFI_LOCATION" VARCHAR(255),
  2989. "WIFI_FIRSTSEENTIME" BIGINT,
  2990. "WIFI_LASTSEENTIME" BIGINT,
  2991. "WIFI_LASTSYNCTIME" BIGINT,
  2992. "WIFI_SYSUPTIME" VARCHAR(50), 
  2993. PRIMARY KEY ("NAME", "OWNERNAME"),
  2994. CONSTRAINT WifiObject_FK1 FOREIGN KEY (NAME,OWNERNAME) REFERENCES ManagedObject(NAME,OWNERNAME) ON DELETE CASCADE)
  2995. TYPE=InnoDB
  2996. EndCreateSchema
  2997.  
  2998.  
  2999. ###############################  Gateway Devices..  ##################################################
  3000.  
  3001. BeginCreateSchema
  3002. create table VernierGateway ( 
  3003. "NAME"  VARCHAR(100)  NOT NULL , 
  3004. "OWNERNAME"  VARCHAR(50)  NOT NULL , 
  3005. "GWNOOFCLIENTS"  INTEGER , 
  3006. "GWNOOFAUTHUSERS"  INTEGER , 
  3007. "GWNOOFUNAUTHUSERS"  INTEGER , 
  3008. PRIMARY KEY ("NAME", "OWNERNAME"),
  3009. CONSTRAINT VernierGateway_FK1 FOREIGN KEY (NAME,OWNERNAME) REFERENCES WifiObject(NAME,OWNERNAME) ON DELETE CASCADE,
  3010. index VernierGateway0_ndx ("NAME"),
  3011. index VernierGateway1_ndx ("OWNERNAME"))
  3012. EndCreateSchema
  3013.  
  3014. BeginCreateSchema
  3015. create table VernierGatewayPort ( 
  3016. "NAME"  VARCHAR(50)  NOT NULL , 
  3017. "OWNERNAME"  VARCHAR(50)  NOT NULL , 
  3018. "GWPORTINDEX"  INTEGER , 
  3019. "GWPORTMACADDRESS"  VARCHAR(50), 
  3020. "GWPORTDESCRIPTOR"  VARCHAR(50), 
  3021. "GWPORTSPEED"  BIGINT , 
  3022. PRIMARY KEY ("NAME", "OWNERNAME"),
  3023. CONSTRAINT VernierGatewayPort_FK1 FOREIGN KEY (NAME,OWNERNAME) REFERENCES ManagedObject(NAME,OWNERNAME) ON DELETE CASCADE,
  3024. index VernierGatewayPort0_ndx ("NAME"),
  3025. index VernierGatewayPort1_ndx ("OWNERNAME"))
  3026. EndCreateSchema
  3027.  
  3028.  
  3029. BeginDropSchema
  3030. drop table VernierGatewayPort
  3031. drop index VernierGatewayPort0_ndx
  3032. drop index VernierGatewayPort1_ndx
  3033. EndDropSchema
  3034.  
  3035.  
  3036. BeginDropSchema
  3037. drop table VernierGateway
  3038. drop index VernierGateway0_ndx
  3039. drop index VernierGateway1_ndx
  3040. EndDropSchema
  3041.  
  3042.  
  3043. ###############################  Gateway Devices..  ##################################################
  3044.  
  3045.  
  3046. ###############################  Nomadix Gateway Devices  ##################################################
  3047.  
  3048.  
  3049.  
  3050. BeginCreateSchema
  3051. create table NomadixGateway ( 
  3052. "NAME"  VARCHAR(100)  NOT NULL , 
  3053. "OWNERNAME"  VARCHAR(25)  NOT NULL , 
  3054. "NM_TYPE" VARCHAR(25) NOT NULL,
  3055. "NM_GATEWAYID" VARCHAR(100) NOT NULL,
  3056. "NM_BRIDGEMODE" INTEGER NOT NULL,
  3057. PRIMARY KEY ("NAME", "OWNERNAME"),
  3058. CONSTRAINT     NomadixGateway_FK1 FOREIGN KEY (NAME,OWNERNAME) REFERENCES WifiObject(NAME,OWNERNAME) ON DELETE CASCADE)
  3059. TYPE=InnoDB
  3060. EndCreateSchema
  3061.  
  3062. BeginCreateSchema
  3063. create table SubscriberCurrentTable ( 
  3064. "NAME"  VARCHAR(100)  NOT NULL , 
  3065. "OWNERNAME"  VARCHAR(25)  NOT NULL , 
  3066. "SCT_SUBINDEX" INTEGER NOT NULL,
  3067. "SCT_SUBNAME" VARCHAR(255),
  3068. "SCT_MACADDRESS" VARCHAR(50),
  3069. "SCT_IPADDRESS" VARCHAR(50),
  3070. "SCT_PORT" INTEGER,
  3071. "SCT_UPLOADBANDWIDTH" INTEGER,
  3072. "SCT_DOWNLOADNBANDWIDTH" INTEGER,
  3073. "SCT_EXPIRATION" VARCHAR(255),
  3074. "SCT_STATE" VARCHAR(255),
  3075. "SCT_TIMEOUT" VARCHAR(255),
  3076. "SCT_BYTESSENT" BIGINT,
  3077. "SCT_BYTESRECEIVED" BIGINT,
  3078. "SCT_PROXY" VARCHAR(255),
  3079. "SCT_KEY" VARCHAR(255),
  3080. PRIMARY KEY ("NAME", "OWNERNAME","SCT_SUBINDEX"),
  3081. CONSTRAINT SubscriberCurrentTable_FK1 FOREIGN KEY (NAME,OWNERNAME) REFERENCES NomadixGateway(NAME,OWNERNAME) ON DELETE CASCADE)
  3082. TYPE=InnoDB
  3083. EndCreateSchema
  3084.  
  3085.  
  3086. BeginCreateSchema
  3087. create table NMStaticPortMappingTable ( 
  3088. "NAME"  VARCHAR(100)  NOT NULL , 
  3089. "OWNERNAME"  VARCHAR(25)  NOT NULL , 
  3090. "NMSPM_INDEX" INTEGER NOT NULL,
  3091. "NMSPM_INTERNALMAC" VARCHAR(100) NOT NULL,
  3092. "NMSPM_INTERNALIP" VARCHAR(50) NOT NULL,
  3093. "NMSPM_INTERNALPORT" INTEGER NOT NULL,
  3094. "NMSPM_EXTERNALIP" VARCHAR(50) NOT NULL,
  3095. "NMSPM_EXTERNALPORT" INTEGER NOT NULL,
  3096. "NMSPM_REMOTEIP" VARCHAR(50),
  3097. "NMSPM_REMOTEPORT" INTEGER,
  3098. "NMSPM_PROTOCOL" INTEGER NOT NULL,
  3099. PRIMARY KEY ("NAME", "OWNERNAME","NMSPM_INDEX"),
  3100. CONSTRAINT     NMStaticPortMappingTable_FK1 FOREIGN KEY (NAME,OWNERNAME) REFERENCES NomadixGateway(NAME,OWNERNAME) ON DELETE CASCADE)
  3101. TYPE=InnoDB
  3102. EndCreateSchema
  3103.  
  3104.  
  3105. BeginCreateSchema
  3106. create table NomadixRI ( 
  3107. "NAME"  VARCHAR(100)  NOT NULL , 
  3108. "OWNERNAME"  VARCHAR(25)  NOT NULL , 
  3109. "NM_BROADCASTON" INTEGER NOT NULL,
  3110. "NM_CHANNEL" INTEGER NOT NULL,
  3111. "NM_DATARATE" INTEGER NOT NULL,
  3112. "NM_BEACONINTERVAL" INTEGER  NOT NULL,
  3113. "NM_DTIM" INTEGER NOT NULL,
  3114. "NM_TRANSMITPOWER"  INTEGER NOT NULL,
  3115. "NM_FRAGMENTLENGTH" INTEGER NOT NULL,
  3116. "NM_RTSLENGTH" INTEGER NOT NULL,
  3117. "NM_SHORTPREAMBLEON" INTEGER NOT NULL,
  3118. "NM_SSID" VARCHAR(255) NOT NULL,
  3119. "NM_NEARESTSENSOR" VARCHAR(50),
  3120. "NM_SIGNALSTRENGTH" INTEGER,
  3121. "NM_NOISELEVEL" INTEGER,
  3122. PRIMARY KEY ("NAME", "OWNERNAME"),
  3123. CONSTRAINT     NomadixRI_FK1 FOREIGN KEY (NAME,OWNERNAME) REFERENCES ManagedObject(NAME,OWNERNAME) ON DELETE CASCADE)
  3124. TYPE=InnoDB
  3125. EndCreateSchema
  3126.  
  3127. BeginDropSchema
  3128. drop table NomadixRI
  3129. EndDropSchema
  3130.  
  3131. BeginCreateSchema
  3132. create table DatSessionTable (
  3133. "NAME"  VARCHAR(100)  NOT NULL ,
  3134. "OWNERNAME"  VARCHAR(25)  NOT NULL ,
  3135. "DAT_SUBIP" VARCHAR(50) ,
  3136. "DAT_SUBPORT" INTEGER,
  3137. "DAT_SUBMAC" VARCHAR(50),
  3138. "DAT_NETIP" VARCHAR(50),
  3139. "DAT_NETPORT" INTEGER NOT NULL,
  3140. "DAT_DESTIP" VARCHAR(50),
  3141. "DAT_DESTPORT" INTEGER,
  3142. "DAT_PROTO" VARCHAR(50),
  3143. "DAT_SESSSTATE" VARCHAR(25),
  3144. "DAT_TIMEOUT" INTEGER,
  3145. CONSTRAINT  DatSessionTable_FK1 FOREIGN KEY (NAME,OWNERNAME) REFERENCES NomadixGateway(NAME,OWNERNAME) ON DELETE CASCADE)
  3146. TYPE=InnoDB
  3147. EndCreateSchema
  3148.       
  3149. BeginCreateSchema
  3150. create table NomadixWirelessDetails (
  3151. "NAME"  VARCHAR(100)  NOT NULL ,
  3152. "OWNERNAME"  VARCHAR(25)  NOT NULL ,
  3153. "NM_BROADCASTON" INTEGER NOT NULL,
  3154. "NM_CHANNEL" INTEGER NOT NULL,
  3155. "NM_DATARATE" INTEGER NOT NULL,
  3156. "NM_BEACONINTERVAL" INTEGER  NOT NULL,
  3157. "NM_DTIM" INTEGER NOT NULL,
  3158. "NM_TRANSMITPOWER"  INTEGER NOT NULL,
  3159. "NM_FRAGMENTLENGTH" INTEGER NOT NULL,
  3160. "NM_RTSLENGTH" INTEGER NOT NULL,
  3161. "NM_SHORTPREAMBLEON" INTEGER NOT NULL,
  3162. "NM_SSID" VARCHAR(255) NOT NULL,
  3163. "NM_NEARESTSENSOR" VARCHAR(50),
  3164. "NM_SIGNALSTRENGTH" INTEGER,
  3165. "NM_NOISELEVEL" INTEGER,
  3166. PRIMARY KEY ("NAME", "OWNERNAME"),
  3167. CONSTRAINT  NomadixWirelessDetails_FK1 FOREIGN KEY (NAME,OWNERNAME) REFERENCES ManagedObject(NAME,OWNERNAME) ON DELETE CASCADE)
  3168. TYPE=InnoDB
  3169. EndCreateSchema
  3170.       
  3171. BeginCreateSchema
  3172. create table NM_SMTP (
  3173. "NAME"  VARCHAR(100)  NOT NULL ,
  3174. "OWNERNAME"  VARCHAR(25)  NOT NULL ,
  3175. "SMTP_REDIRECT" INTEGER ,
  3176. "SMTP_SERVERIP" VARCHAR(50),
  3177. "SMTP_PCREDIRECT" INTEGER,
  3178. "SMTP_USERNAME" VARCHAR(50),
  3179. "SMTP_PASSWORD" VARCHAR(50),
  3180. PRIMARY KEY ("NAME", "OWNERNAME"),
  3181. CONSTRAINT  NM_SMTP_FK1 FOREIGN KEY (NAME,OWNERNAME) REFERENCES NomadixGateway(NAME,OWNERNAME) ON DELETE CASCADE)
  3182. TYPE=InnoDB
  3183. EndCreateSchema
  3184.       
  3185. BeginCreateSchema
  3186. create table NM_SNMP (
  3187. "NAME"  VARCHAR(100)  NOT NULL ,
  3188. "OWNERNAME"  VARCHAR(25)  NOT NULL ,
  3189. "SNMP" INTEGER,
  3190. "SNMP_CONTACT" VARCHAR(255),
  3191. "SNMP_LOCATION" VARCHAR(255),
  3192. "SNMP_GETCOMMUNITY" VARCHAR(255),
  3193. "SNMP_SETCOMMUNITY" VARCHAR(255),
  3194. "SNMP_TRAPCOMMUNITY" VARCHAR(255),
  3195. "SNMP_TRAPIP" VARCHAR(50),
  3196. PRIMARY KEY ("NAME", "OWNERNAME"),
  3197. CONSTRAINT  NM_SNMP_FK1 FOREIGN KEY (NAME,OWNERNAME) REFERENCES NomadixGateway(NAME,OWNERNAME) ON DELETE CASCADE)
  3198. TYPE=InnoDB
  3199. EndCreateSchema
  3200.       
  3201. BeginCreateSchema
  3202. create table NM_DNS (
  3203. "NAME"  VARCHAR(100)  NOT NULL ,
  3204. "OWNERNAME"  VARCHAR(25)  NOT NULL ,
  3205. "DNS_HOSTNAME" varchar(64),
  3206. "DNS_DOMAIN" VARCHAR(64),
  3207. "DNS_PRIMARYSERVER" VARCHAR(50),
  3208. "DNS_SECONDARYSERVER" VARCHAR(50),
  3209. "DNS_TERTIARYSERVER" VARCHAR(50),
  3210. PRIMARY KEY ("NAME", "OWNERNAME"),
  3211. CONSTRAINT  NM_DNS_FK1 FOREIGN KEY (NAME,OWNERNAME) REFERENCES NomadixGateway(NAME,OWNERNAME) ON DELETE CASCADE)
  3212. TYPE=InnoDB
  3213. EndCreateSchema
  3214.      
  3215. BeginCreateSchema
  3216. create table NM_HPR (
  3217. "NAME"  VARCHAR(100)  NOT NULL ,
  3218. "OWNERNAME"  VARCHAR(25)  NOT NULL ,
  3219. "HPR_ON" INTEGER,
  3220. "HPR_URL" VARCHAR(255),
  3221. "HPR_PARAMETERPASSING" INTEGER,
  3222. "HPR_FREQUENCY" INTEGER,
  3223. PRIMARY KEY ("NAME", "OWNERNAME"),
  3224. CONSTRAINT  NM_HPR_FK1 FOREIGN KEY (NAME,OWNERNAME) REFERENCES NomadixGateway(NAME,OWNERNAME) ON DELETE CASCADE)
  3225. TYPE=InnoDB
  3226. EndCreateSchema
  3227.       
  3228. BeginCreateSchema
  3229. create table NM_INAT (
  3230. "NAME"  VARCHAR(100)  NOT NULL ,
  3231. "OWNERNAME"  VARCHAR(25)  NOT NULL ,
  3232. "INAT_ON" INTEGER,
  3233. "INAT_PPTPON" INTEGER,
  3234. "INAT_IPSECON" INTEGER,
  3235. "INAT_PPTPIDON" INTEGER,
  3236. PRIMARY KEY ("NAME", "OWNERNAME"),
  3237. CONSTRAINT NM_INAT_FK1 FOREIGN KEY (NAME,OWNERNAME) REFERENCES NomadixGateway(NAME,OWNERNAME) ON DELETE CASCADE)
  3238. TYPE=InnoDB
  3239. EndCreateSchema
  3240.       
  3241. BeginCreateSchema
  3242. create table NM_INATIP (
  3243. "NAME"  VARCHAR(100)  NOT NULL ,
  3244. "OWNERNAME"  VARCHAR(25)  NOT NULL ,
  3245. "INAT_INDEX" INTEGER,
  3246. "INAT_STARTADDRESS" VARCHAR(50),
  3247. "INAT_ENDADDRESS" VARCHAR(50),
  3248. PRIMARY KEY ("NAME", "OWNERNAME","INAT_INDEX"),
  3249. CONSTRAINT  NM_INATIP_FK1 FOREIGN KEY (NAME,OWNERNAME) REFERENCES NomadixGateway(NAME,OWNERNAME) ON DELETE CASCADE)
  3250. TYPE=InnoDB
  3251. EndCreateSchema
  3252.       
  3253. BeginCreateSchema
  3254. create table NM_URL_DNS_TABLE (
  3255. "NAME"  VARCHAR(100)  NOT NULL ,
  3256. "OWNERNAME"  VARCHAR(25)  NOT NULL ,
  3257. "DNS_INDEX" INTEGER,
  3258. "DNS_NAME" VARCHAR(255),
  3259. PRIMARY KEY ("NAME", "OWNERNAME","DNS_INDEX"),
  3260. CONSTRAINT  NM_URL_DNS_FK1 FOREIGN KEY (NAME,OWNERNAME) REFERENCES NomadixGateway(NAME,OWNERNAME) ON DELETE CASCADE)
  3261. TYPE=InnoDB
  3262. EndCreateSchema
  3263.       
  3264. BeginDropSchema
  3265. drop table NM_URL_DNS_TABLE
  3266. EndDropSchema
  3267.  
  3268. BeginDropSchema
  3269. drop table NM_INATIP
  3270. EndDropSchema
  3271.       
  3272. BeginDropSchema
  3273. drop table NM_INAT
  3274. EndDropSchema
  3275.       
  3276. BeginDropSchema
  3277. drop table NM_HPR
  3278. EndDropSchema
  3279.       
  3280. BeginDropSchema
  3281. drop table NM_DNS
  3282. EndDropSchema
  3283.       
  3284. BeginDropSchema
  3285. drop table NM_SNMP
  3286. EndDropSchema
  3287.  
  3288. BeginDropSchema
  3289. drop table NM_SMTP
  3290. EndDropSchema
  3291.       
  3292. BeginDropSchema
  3293. drop table NomadixWirelessDetails
  3294. EndDropSchema
  3295.  
  3296. BeginDropSchema
  3297. drop table DatSessionTable
  3298. EndDropSchema
  3299.  
  3300. BeginDropSchema
  3301. drop table SubscriberCurrentTable
  3302. EndDropSchema
  3303.  
  3304. BeginDropSchema
  3305. drop table NMStaticPortMappingTable
  3306. EndDropSchema
  3307.  
  3308. BeginDropSchema
  3309. drop table NomadixGateway
  3310. EndDropSchema
  3311.  
  3312. BeginDropSchema
  3313. drop table WifiObject
  3314. EndDropSchema
  3315.  
  3316.  
  3317. ###############################  Nomadix Gateway Devices  ##################################################
  3318.  
  3319.  
  3320. ###############################  Wireless Switch Devices  ##################################################
  3321.  
  3322.  
  3323. BeginCreateSchema
  3324. create table DiscoveryType (
  3325. "DISC_ID" INTEGER NOT NULL,
  3326. "DISC_DESCRIPTION" VARCHAR(30) NOT NULL,
  3327. PRIMARY KEY ("DISC_ID") )
  3328. EndCreateSchema
  3329.  
  3330.  
  3331. BeginCreateSchema
  3332. create table Vendor (
  3333. "VENDOR_ID" INTEGER NOT NULL,
  3334. "VENDOR_DESCRIPTION" VARCHAR(30) NOT NULL,
  3335. PRIMARY KEY ("VENDOR_ID") )
  3336. EndCreateSchema
  3337.  
  3338.  
  3339. BeginCreateSchema
  3340. create table Model(
  3341. "MODEL_ID" INTEGER NOT NULL,
  3342. "MODEL_DESCRIPTION" VARCHAR(30) NOT NULL,
  3343. PRIMARY KEY ("MODEL_ID"))
  3344. EndCreateSchema
  3345.  
  3346.  
  3347. BeginCreateSchema
  3348. create table WirelessSwitch (
  3349. "NAME" VARCHAR(100) NOT NULL,
  3350. "OWNERNAME" VARCHAR(25) NOT NULL,
  3351. "WS_ID" INTEGER NOT NULL UNIQUE AUTO_INCREMENT,
  3352. "WS_MACADDRESS"  VARCHAR(30) NOT NULL,
  3353. "WS_VENDOR"  VARCHAR(50) NOT NULL,
  3354. "WS_MODEL"  VARCHAR(50) NOT NULL,
  3355. "WS_FIRMWAREVERSION" VARCHAR(50) NOT NULL,
  3356. "WS_LOCATION" VARCHAR(50) NOT NULL,
  3357. "WS_UPTIME" VARCHAR(50) NOT NULL,
  3358. "WS_DISCOVERYTYPE"  INTEGER NOT NULL,
  3359. PRIMARY KEY ("NAME","OWNERNAME"))
  3360. TYPE=InnoDB
  3361. EndCreateSchema
  3362.  
  3363.  
  3364. BeginCreateSchema
  3365. create table WirelessSwitchPort(
  3366. "NAME" VARCHAR(100) NOT NULL,
  3367. "OWNERNAME" VARCHAR(25) NOT NULL,
  3368. "WS_ID" INTEGER NOT NULL UNIQUE AUTO_INCREMENT, 
  3369. "WS_POE" INTEGER NOT NULL,
  3370. "WS_PARENTSWITCH" INTEGER NOT NULL,
  3371. "WS_TYPE" INTEGER NOT NULL,
  3372. "WS_DUPLEX" INTEGER NOT NULL,
  3373. "WS_CONFIGSPEED" INTEGER NOT NULL,
  3374. "WS_POWER" VARCHAR (25) NOT NULL,
  3375. PRIMARY KEY ("NAME","OWNERNAME"),
  3376. CONSTRAINT WirelessSwitchPort_FK1 FOREIGN KEY (WS_PARENTSWITCH) REFERENCES WirelessSwitch(WS_ID) ON DELETE CASCADE)
  3377. TYPE=InnoDB
  3378. EndCreateSchema
  3379.  
  3380.  
  3381. BeginCreateSchema
  3382. create table ThinAP(
  3383. "NAME" VARCHAR(100) NOT NULL,
  3384. "OWNERNAME" VARCHAR(25) NOT NULL,
  3385. "WS_PORTNAME" VARCHAR(100) NOT NULL UNIQUE, 
  3386. "WS_ID" INTEGER NOT NULL UNIQUE AUTO_INCREMENT, 
  3387. PRIMARY KEY ("NAME","OWNERNAME"))
  3388. TYPE=InnoDB
  3389. EndCreateSchema
  3390.  
  3391. #purpose of the following three tables replaced by WS_TYPE in WirelessSwitchPort 
  3392. BeginCreateSchema
  3393. create table WirelessSwitchAPPort(
  3394. "WS_ID" INTEGER NOT NULL,
  3395. PRIMARY KEY ("WS_ID"),
  3396. CONSTRAINT WirelessSwitchAPPort_FK1 FOREIGN KEY (WS_ID) REFERENCES WirelessSwitchPort(WS_ID) ON DELETE CASCADE)
  3397. TYPE=InnoDB
  3398. EndCreateSchema
  3399.  
  3400.  
  3401.  
  3402.  
  3403. BeginCreateSchema
  3404. create table WirelessSwitchWAPort(
  3405. "WS_ID" INTEGER NOT NULL,
  3406. PRIMARY KEY ("WS_ID"),
  3407. CONSTRAINT WirelessSwitchWAPort_FK1 FOREIGN KEY (WS_ID) REFERENCES WirelessSwitchPort(WS_ID) ON DELETE CASCADE)
  3408. TYPE=InnoDB
  3409. EndCreateSchema
  3410.  
  3411.  
  3412.  
  3413. BeginCreateSchema
  3414. create table WirelessSwitchNetPort(
  3415. "WS_ID" INTEGER NOT NULL,
  3416. PRIMARY KEY ("WS_ID"),
  3417. CONSTRAINT WirelessSwitchNetPort_FK1 FOREIGN KEY (WS_ID) REFERENCES WirelessSwitchPort(WS_ID) ON DELETE CASCADE)
  3418. TYPE=InnoDB
  3419. EndCreateSchema
  3420.  
  3421.  
  3422.  
  3423.  
  3424. BeginCreateSchema
  3425. create table ThinAPMACPointer(
  3426. "WS_ID" INTEGER NOT NULL,
  3427. "WS_MAC" VARCHAR(25) NOT NULL,
  3428. PRIMARY KEY ("WS_MAC"),
  3429. CONSTRAINT ThinAPMACPointer_FK1 FOREIGN KEY (WS_ID) REFERENCES ThinAP(WS_ID) ON DELETE CASCADE)
  3430. TYPE=InnoDB
  3431. EndCreateSchema
  3432.  
  3433.  
  3434. BeginCreateSchema
  3435. create table ThinAPConnection(
  3436. "WS_ID" INTEGER NOT NULL,
  3437. "WS_APID" INTEGER NOT NULL,
  3438. "WS_SWITCHID" INTEGER NOT NULL,
  3439. PRIMARY KEY ("WS_ID"),
  3440. CONSTRAINT ThinAPConnection_FK1 FOREIGN KEY (WS_APID) REFERENCES ThinAP(WS_ID) ON DELETE CASCADE,
  3441. CONSTRAINT ThinAPConnection_FK2 FOREIGN KEY (WS_SWITCHID) REFERENCES WirelessSwitch(WS_ID) ON DELETE CASCADE)
  3442. TYPE=InnoDB
  3443. EndCreateSchema
  3444.  
  3445.  
  3446. BeginCreateSchema
  3447. create table ThinAPDirectConnection(
  3448. "WS_ID" INTEGER NOT NULL,
  3449. "WS_PORTID" INTEGER NOT NULL,
  3450. PRIMARY KEY ("WS_ID"),
  3451. CONSTRAINT ThinAPDirectConnection_FK1 FOREIGN KEY (WS_ID) REFERENCES ThinAPConnection(WS_ID) ON DELETE CASCADE,
  3452. CONSTRAINT ThinAPDirectConnection_FK2 FOREIGN KEY (WS_PORTID) REFERENCES WirelessSwitchAPPort(WS_ID) ON DELETE CASCADE)
  3453. TYPE=InnoDB
  3454. EndCreateSchema
  3455.  
  3456.  
  3457.  
  3458. BeginCreateSchema
  3459. create table ThinAPDistributedConnection(
  3460. "WS_ID" INTEGER NOT NULL,
  3461. PRIMARY KEY ("WS_ID"),
  3462. CONSTRAINT ThinAPDistributedConnection_FK1 FOREIGN KEY (WS_ID) REFERENCES ThinAPConnection(WS_ID) ON DELETE CASCADE)
  3463. TYPE=InnoDB
  3464. EndCreateSchema
  3465.  
  3466. BeginCreateSchema
  3467. create table WirelessSwitchPortGroup(
  3468. "WS_ID" INTEGER NOT NULL,
  3469. "WS_PORTID" INTEGER NOT NULL,
  3470. PRIMARY KEY ("WS_ID","WS_PORTID"),
  3471. CONSTRAINT WirelessSwitchPortGroup_FK1 FOREIGN KEY (WS_PORTID) REFERENCES WirelessSwitchNetPort(WS_ID) ON DELETE CASCADE)
  3472. TYPE=InnoDB
  3473. EndCreateSchema
  3474.  
  3475.  
  3476. BeginCreateSchema
  3477. create table WirelessSwitchVLANPort(
  3478. "WS_VLANID" INTEGER NOT NULL,
  3479. "WS_PORTID" INTEGER NOT NULL,
  3480. PRIMARY KEY ("WS_VLANID","WS_PORTID"),
  3481. CONSTRAINT WirelessSwitchVLANPort_FK1 FOREIGN KEY (WS_PORTID) REFERENCES WirelessSwitchNetPort(WS_ID) ON DELETE CASCADE)
  3482. TYPE=InnoDB
  3483. EndCreateSchema
  3484.  
  3485. BeginDropSchema
  3486. drop table WirelessSwitchVLANPort
  3487. EndDropSchema
  3488.  
  3489. BeginDropSchema
  3490. drop table WirelessSwitchPortGroup
  3491. EndDropSchema
  3492.  
  3493. BeginDropSchema
  3494. drop table ThinAPDirectConnection
  3495. EndDropSchema
  3496.  
  3497.  
  3498. BeginDropSchema
  3499. drop table ThinAPDistributedConnection
  3500. EndDropSchema
  3501.  
  3502. BeginDropSchema
  3503. drop table ThinAPConnection
  3504. EndDropSchema
  3505.  
  3506. BeginDropSchema
  3507. drop table ThinAPMACPointer
  3508. EndDropSchema
  3509.  
  3510. BeginDropSchema
  3511. drop table WirelessSwitchAPPort
  3512. EndDropSchema
  3513.  
  3514. BeginDropSchema
  3515. drop table WirelessSwitchNetPort
  3516. EndDropSchema
  3517.  
  3518. BeginDropSchema
  3519. drop table WirelessSwitchWAPort
  3520. EndDropSchema
  3521.  
  3522. BeginDropSchema
  3523. drop table WirelessSwitchPort
  3524. EndDropSchema
  3525.  
  3526. BeginDropSchema
  3527. drop table ThinAP
  3528. EndDropSchema
  3529.  
  3530. BeginDropSchema
  3531. drop table RadioProfile 
  3532. EndDropSchema
  3533.  
  3534. BeginDropSchema
  3535. drop table WirelessSwitch
  3536. EndDropSchema
  3537.  
  3538. BeginDropSchema
  3539. drop table CounterMeasures 
  3540. EndDropSchema
  3541.  
  3542. BeginDropSchema
  3543. drop table Model 
  3544. EndDropSchema
  3545.  
  3546. BeginDropSchema
  3547. drop table DiscoveryType
  3548. EndDropSchema
  3549.  
  3550. BeginDropSchema
  3551. drop table Vendor
  3552. EndDropSchema
  3553.  
  3554.  
  3555. BeginCreateSchema
  3556. create table AuthType(
  3557. "WS_ID" INTEGER NOT NULL,
  3558. "WS_DESCRIPTION" VARCHAR(20) NOT NULL, 
  3559. PRIMARY KEY ("WS_ID"))
  3560. EndCreateSchema
  3561.  
  3562.  
  3563. BeginCreateSchema
  3564. create table CounterMeasures(
  3565. "WS_ID" INTEGER NOT NULL,
  3566. "WS_DESCRIPTION" VARCHAR(10) NOT NULL,
  3567. PRIMARY KEY ("WS_ID"))
  3568. EndCreateSchema
  3569.  
  3570.  
  3571.  
  3572. BeginCreateSchema
  3573. create table EncryptionType(
  3574. "WS_ID" INTEGER NOT NULL,
  3575. "WS_DESCRIPTION" VARCHAR(20) NOT NULL,
  3576. PRIMARY KEY ("WS_ID"))
  3577. EndCreateSchema
  3578.  
  3579.  
  3580. BeginCreateSchema
  3581. create table ServiceProfile(
  3582. "WS_NAME" VARCHAR(100) NOT NULL,
  3583. "WS_OWNERNAME" VARCHAR(25) NOT NULL,
  3584. "WS_PROFILENAME" VARCHAR(50) NOT NULL,
  3585. "WS_SSID" VARCHAR(25) NOT NULL,
  3586. "WS_AUTHTYPE" INTEGER NOT NULL,
  3587. "WS_ENCRYPTIONTYPE" INTEGER NOT NULL,
  3588. "WS_BROADCAST" BOOL NOT NULL,
  3589. PRIMARY KEY ("WS_NAME","WS_OWNERNAME","WS_PROFILENAME"),
  3590. CONSTRAINT ServiceProfile_FK1 FOREIGN KEY (WS_NAME,WS_OWNERNAME) REFERENCES WirelessSwitch(NAME,OWNERNAME) ON DELETE CASCADE)
  3591. TYPE=InnoDB
  3592. EndCreateSchema
  3593.  
  3594. BeginCreateSchema
  3595. create table RadioProfile(
  3596. "WS_NAME" VARCHAR(100) NOT NULL,
  3597. "WS_OWNERNAME" VARCHAR(25) NOT NULL,
  3598. "WS_PROFILENAME" VARCHAR(50) NOT NULL,
  3599. "WS_FRAGTHRESHOLD" INTEGER NOT NULL,
  3600. "WS_RTSTHRESHOLD" INTEGER NOT NULL,
  3601. "WS_RTSCTSRETRIES" INTEGER NOT NULL,
  3602. "WS_DATARETRIES" INTEGER NOT NULL,
  3603. "WS_BEACONPERIOD" INTEGER NOT NULL,
  3604. "WS_DTIMPERIOD" INTEGER NOT NULL,
  3605. "WS_ACTIVESCAN" BOOL NOT NULL,
  3606. "WS_COUNTERMEASURES" INTEGER NOT NULL,
  3607. "WS_MAXRXLIFETIME" INTEGER NOT NULL,
  3608. "WS_MAXTXLIFETIME" INTEGER NOT NULL,
  3609. "WS_LONGPREAMBLE" BOOL NOT NULL,
  3610. "WS_GONLY" BOOL NOT NULL,
  3611. "WS_WMM" BOOL NOT NULL,
  3612. PRIMARY KEY ("WS_NAME","WS_OWNERNAME","WS_PROFILENAME"),
  3613. CONSTRAINT RadioProfile_FK1 FOREIGN KEY (WS_NAME,WS_OWNERNAME) REFERENCES WirelessSwitch(NAME,OWNERNAME) ON DELETE CASCADE)
  3614. TYPE=InnoDB
  3615. EndCreateSchema
  3616.  
  3617.  
  3618. BeginCreateSchema
  3619. create table DataRateStatus(
  3620. "WS_ID" INTEGER NOT NULL,
  3621. "WS_DESCRIPTION" VARCHAR(10) NOT NULL,
  3622. PRIMARY KEY ("WS_ID"))
  3623. EndCreateSchema
  3624.  
  3625.  
  3626. #BeginCreateSchema
  3627. #create table DataRate(
  3628. #"WS_PROFILEID" INTEGER NOT NULL,
  3629. #"WS_DATARATE" FLOAT NOT NULL,
  3630. #"WS_STATUS" INTEGER NOT NULL,
  3631. #PRIMARY KEY ("WS_PROFILEID","WS_DATARATE"),
  3632. #CONSTRAINT DataRate_FK1 FOREIGN KEY (WS_PROFILEID) REFERENCES RadioProfile(WS_ID) ON DELETE CASCADE,
  3633. #CONSTRAINT DataRate_FK2 FOREIGN KEY (WS_STATUS) REFERENCES DataRateStatus(WS_ID))
  3634. #TYPE=InnoDB
  3635. #EndCreateSchema
  3636. #
  3637. #
  3638. #BeginCreateSchema
  3639. #create table RSNEncryptionType(
  3640. #"WS_ID" INTEGER NOT NULL,
  3641. #"WS_RSNIE" BOOL NOT NULL,
  3642. #PRIMARY KEY ("WS_ID"),
  3643. #CONSTRAINT RSNEncryptionType_FK1 FOREIGN KEY (WS_ID) REFERENCES ServiceProfile(WS_ID))
  3644. #TYPE=InnoDB
  3645. #EndCreateSchema
  3646.  
  3647.  
  3648.  
  3649.  
  3650. #BeginCreateSchema
  3651. #create table PSKDetails(
  3652. #"WS_PROFILEID" INTEGER NOT NULL,
  3653. #"WS_PSKKEY" VARCHAR(64) NOT NULL,
  3654. #PRIMARY KEY ("WS_PROFILEID","WS_PSKKEY"),
  3655. #CONSTRAINT PSKDetails_FK1 FOREIGN KEY (WS_PROFILEID) REFERENCES ServiceProfile(WS_ID))
  3656. #TYPE=InnoDB
  3657. #EndCreateSchema
  3658.  
  3659.  
  3660.  
  3661.  
  3662. #BeginCreateSchema
  3663. #create table WEPEncryptionType(
  3664. #"WS_ID" INTEGER NOT NULL,
  3665. #"WS_DYNAMICWEP" BOOL NOT NULL,
  3666. #"WS_UNICASTINDEX" INTEGER NOT NULL,
  3667. #"WS_MULTICASTINDEX"  INTEGER NOT NULL,
  3668. #PRIMARY KEY ("WS_ID"),
  3669. #CONSTRAINT WEPEncryptionType_FK1 FOREIGN KEY (WS_ID) REFERENCES ServiceProfile(WS_ID))
  3670. #TYPE=InnoDB
  3671. #EndCreateSchema
  3672. #
  3673. #
  3674. #
  3675. #BeginCreateSchema
  3676. #create table WPAEncryptionType(
  3677. #"WS_ID" INTEGER NOT NULL,
  3678. #"WS_WPAIE" BOOL NOT NULL,
  3679. #"WS_TKIPMCTIME" INTEGER NOT NULL,
  3680. #PRIMARY KEY ("WS_ID"),
  3681. #CONSTRAINT WPAEncryptionType_FK1 FOREIGN KEY (WS_ID) REFERENCES ServiceProfile(WS_ID))
  3682. #TYPE=InnoDB
  3683. #EndCreateSchema
  3684. #
  3685. #
  3686. #
  3687. #BeginCreateSchema
  3688. #create table ServiceRadioRelationship(
  3689. #"WS_RADIOPROFILE" INTEGER NOT NULL,
  3690. #"WS_SERVICEPROFILE" INTEGER NOT NULL,
  3691. #PRIMARY KEY ("WS_RADIOPROFILE","WS_SERVICEPROFILE"),
  3692. #CONSTRAINT ServiceRadioRelationship_FK1 FOREIGN KEY (WS_SERVICEPROFILE) REFERENCES ServiceProfile(WS_ID),
  3693. #CONSTRAINT ServiceRadioRelationship_FK2 FOREIGN KEY (WS_RADIOPROFILE) REFERENCES RadioProfile(WS_ID))
  3694. #TYPE=InnoDB
  3695. #EndCreateSchema
  3696. #
  3697. #
  3698. #
  3699. BeginDropSchema
  3700. drop table DataRateStatus 
  3701. EndDropSchema
  3702.  
  3703.  
  3704. BeginDropSchema
  3705. drop table AuthType
  3706. EndDropSchema
  3707.  
  3708. BeginDropSchema
  3709. drop table EncryptionType
  3710. EndDropSchema
  3711. ###############################  Wireless Switch Devices  ##################################################
  3712.  
  3713.  
  3714.  
  3715. BeginCreateSchema
  3716. create table CFData (
  3717. "NAME"  VARCHAR(100)  NOT NULL,
  3718. "OWNERNAME"  VARCHAR(25)  NOT NULL,
  3719. PRIMARY KEY ("NAME","OWNERNAME"),
  3720. index CFData0_ndx ("NAME"),
  3721. index CFData1_ndx ("OWNERNAME"))
  3722. EndCreateSchema
  3723.       
  3724. #Removed FK, handled in NetDiscoveryStatusHandler, to avoid removal of CFData on rediscovery
  3725. #CONSTRAINT  CFData_FK1 FOREIGN KEY (NAME,OWNERNAME) REFERENCES ManagedObject(NAME,OWNERNAME) ON DELETE CASCADE,
  3726.      
  3727. BeginCreateSchema
  3728. create table CFMetaData (
  3729. "CFID"  INTEGER NOT NULL,
  3730. "FIELDNAME"  VARCHAR(20) NOT NULL,
  3731. "FIELDTYPE"  VARCHAR(20) NOT NULL,
  3732. "FIELDLENGTH" INTEGER NOT NULL,
  3733. "DESCRIPTION" VARCHAR(250),
  3734. PRIMARY KEY ("CFID"),
  3735. index CFMetaData0_ndx ("CFID"))
  3736. EndCreateSchema
  3737.       
  3738. #BeginDropSchema
  3739. #drop table CFMetaData
  3740. #drop index CFMetaData0_ndx
  3741. #EndDropSchema
  3742.       
  3743. BeginDropSchema
  3744. drop table CFData
  3745. drop index CFData0_ndx
  3746. drop index CFData1_ndx
  3747. EndDropSchema
  3748.  
  3749. BeginCreateSchema
  3750. create table PollAdminSettings ( 
  3751. "PAS_ID"  INTEGER  NOT NULL , 
  3752. "PAS_CATEGORY" VARCHAR(50) NOT NULL,
  3753. PRIMARY KEY ("PAS_ID"))
  3754. TYPE=InnoDB
  3755. EndCreateSchema
  3756.  
  3757. BeginCreateSchema
  3758. create table PollTypes ( 
  3759. "PT_ID"  INTEGER  NOT NULL , 
  3760. "PT_TYPE" VARCHAR(100) NOT NULL,
  3761. "PT_ENABLE" VARCHAR(10) NOT NULL,
  3762. "PT_DISPLAYNAME" VARCHAR(100) NOT NULL,
  3763. PRIMARY KEY ("PT_ID","PT_TYPE"),
  3764. CONSTRAINT     PT_FK1 FOREIGN KEY (PT_ID) REFERENCES PollAdminSettings(PAS_ID) ON DELETE CASCADE)
  3765. TYPE=InnoDB
  3766. EndCreateSchema
  3767.  
  3768.  
  3769. BeginCreateSchema
  3770. create table PollProtocol ( 
  3771. "PP_ID"  INTEGER  NOT NULL , 
  3772. "PP_TYPE" VARCHAR(100) NOT NULL,
  3773. "PP_PROTOCOL" VARCHAR(50) NOT NULL,
  3774. PRIMARY KEY ("PP_ID","PP_TYPE","PP_PROTOCOL"),
  3775. CONSTRAINT     PP_FK1 FOREIGN KEY (PP_ID,PP_TYPE) REFERENCES PollTypes(PT_ID,PT_TYPE) ON DELETE CASCADE)
  3776. TYPE=InnoDB
  3777. EndCreateSchema
  3778.  
  3779.  
  3780. BeginDropSchema
  3781. drop table PollProtocol
  3782. EndDropSchema
  3783.  
  3784. BeginDropSchema
  3785. drop table PollTypes
  3786. EndDropSchema
  3787.  
  3788. BeginDropSchema
  3789. drop table PollAdminSettings
  3790. EndDropSchema
  3791.  
  3792. BeginCreateSchema
  3793. create table ConfigProps( 
  3794. "CP_TYPE" VARCHAR(50) NOT NULL,
  3795. "CP_KEY" VARCHAR(50) NOT NULL,
  3796. "CP_VALUE" VARCHAR(150) NOT NULL,
  3797. PRIMARY KEY ("CP_TYPE","CP_KEY","CP_VALUE"))
  3798. EndCreateSchema
  3799.  
  3800. #BeginDropSchema
  3801. #drop table ConfigProps
  3802. #EndDropSchema
  3803.  
  3804.  
  3805. ###############################  Scheduling Tables  ##################################################
  3806.  
  3807. BeginCreateSchema
  3808. create table Schedule ( 
  3809. "S_SCHEDULEID"  BIGINT  NOT NULL , 
  3810. "S_SCHEDULENAME" VARCHAR(250) NOT NULL UNIQUE,
  3811. "S_DESCRIPTION" TEXT,
  3812. "S_ADMINSTATUS" VARCHAR(20) NOT NULL,
  3813. PRIMARY KEY ("S_SCHEDULEID"))
  3814. TYPE=InnoDB
  3815. EndCreateSchema
  3816.  
  3817. BeginCreateSchema
  3818. create table PeriodicSchedule ( 
  3819. "PS_SCHEDULEID"  BIGINT  NOT NULL , 
  3820. "PS_STARTDATE" DATETIME ,
  3821. "PS_ENDDATE" DATETIME,
  3822. "PS_TIMEPERIOD" BIGINT NOT NULL,
  3823. "PS_UNITOFTIME" VARCHAR(20) NOT NULL,
  3824. PRIMARY KEY ("PS_SCHEDULEID"),
  3825. CONSTRAINT     PS_FK1 FOREIGN KEY (PS_SCHEDULEID) REFERENCES Schedule(S_SCHEDULEID) ON DELETE CASCADE)
  3826. TYPE=InnoDB
  3827. EndCreateSchema
  3828.  
  3829.  
  3830. BeginCreateSchema
  3831. create table CalendarSchedule ( 
  3832. "CS_SCHEDULEID"  BIGINT  NOT NULL , 
  3833. "CS_REPEAT_FREQUENCY" VARCHAR(20) NOT NULL,
  3834. "CS_TIME_OF_DAY" BIGINT NOT NULL,
  3835. "CS_UNIT_OF_TIME" VARCHAR(20) NOT NULL,
  3836. "CS_DAY_OF_WEEK" INTEGER NOT NULL,
  3837. "CS_WEEK_OF_MONTH" INTEGER NOT NULL,
  3838. "CS_DATE_OF_MONTH" INTEGER NOT NULL,
  3839. "CS_MONTH_OF_YEAR" INTEGER NOT NULL,
  3840. "CS_YEAR_OF_LEAP_YEAR" INTEGER NOT NULL,
  3841. "CS_YEAR_OF_DECADE" INTEGER NOT NULL,
  3842. PRIMARY KEY ("CS_SCHEDULEID"),
  3843. CONSTRAINT     CS_FK1 FOREIGN KEY (CS_SCHEDULEID) REFERENCES Schedule(S_SCHEDULEID) ON DELETE CASCADE)
  3844. TYPE=InnoDB
  3845. EndCreateSchema
  3846.  
  3847.  
  3848. BeginCreateSchema
  3849. create table CompositeSchedule ( 
  3850. "COS_SCHEDULEID"  BIGINT  NOT NULL , 
  3851. "COS_SUB_SCHEDULEID1"  BIGINT  NOT NULL , 
  3852. "COS_OPERATOR"  VARCHAR(150)  NOT NULL , 
  3853. "COS_SUB_SCHEDULEID2"  BIGINT  NOT NULL , 
  3854. "COS_PARENT_SCHEDULEID" BIGINT NOT NULL,
  3855. PRIMARY KEY ("COS_SCHEDULEID"),
  3856. INDEX COS_INDEX1(COS_SUB_SCHEDULEID1),
  3857. INDEX COS_INDEX2(COS_SUB_SCHEDULEID2),
  3858. INDEX COS_INDEX3(COS_PARENT_SCHEDULEID),
  3859. CONSTRAINT     COS_FK1 FOREIGN KEY (COS_SUB_SCHEDULEID1) REFERENCES Schedule(S_SCHEDULEID) ON DELETE CASCADE,
  3860. CONSTRAINT     COS_FK2 FOREIGN KEY (COS_SUB_SCHEDULEID2) REFERENCES Schedule(S_SCHEDULEID) ON DELETE CASCADE,
  3861. CONSTRAINT     COS_FK3 FOREIGN KEY (COS_PARENT_SCHEDULEID) REFERENCES Schedule(S_SCHEDULEID) ON DELETE CASCADE)
  3862. TYPE=InnoDB
  3863. EndCreateSchema
  3864.  
  3865. BeginCreateSchema
  3866. create table TaskInput ( 
  3867. "TI_INSTANCEID"  BIGINT  NOT NULL , 
  3868. "TI_SCHEDULEID"  BIGINT  NOT NULL , 
  3869. "TI_SCHEDULETIME" DATETIME,
  3870. "TI_EXECUTION_START_TIME" DATETIME,
  3871. "TI_EXECUTION_FINISH_TIME" DATETIME,
  3872. "TI_ADMIN_STATUS" INTEGER,
  3873. "TI_OPERATIONAL_STATUS" INTEGER,
  3874. "TI_TYPE" INTEGER ,
  3875. PRIMARY KEY ("TI_INSTANCEID"),
  3876. INDEX TI_INDEX1(TI_SCHEDULEID),
  3877. CONSTRAINT     TI_FK1 FOREIGN KEY (TI_SCHEDULEID) REFERENCES Schedule(S_SCHEDULEID) ON DELETE CASCADE)
  3878. TYPE=InnoDB
  3879. EndCreateSchema
  3880.  
  3881. BeginCreateSchema
  3882. create table MaintenanceTask ( 
  3883. "MS_INSTANCEID"  BIGINT  NOT NULL , 
  3884. "MS_NAME" VARCHAR(250) NOT NULL UNIQUE,
  3885. "MS_DESCRIPTION" TEXT,
  3886. "MS_STATUS" VARCHAR(10),
  3887. "MS_MANAGE_SCHEDULEID" BIGINT NOT NULL,
  3888. "MS_UNMANAGE_SCHEDULEID" BIGINT NOT NULL,
  3889. PRIMARY KEY ("MS_INSTANCEID"))
  3890. TYPE=InnoDB
  3891. EndCreateSchema
  3892.  
  3893. BeginCreateSchema
  3894. create table CsvImportTask ( 
  3895. "FILE_NAME" VARCHAR(250) NOT NULL ,
  3896. "FILE_DESCRIPTION" TEXT,
  3897. "FILE_OPTION" VARCHAR(20),
  3898. "SCHEDULEID" BIGINT NOT NULL,
  3899. PRIMARY KEY ("FILE_NAME"),
  3900. CONSTRAINT IM_FK FOREIGN KEY (SCHEDULEID) REFERENCES Schedule(S_SCHEDULEID) ON DELETE CASCADE) 
  3901. TYPE=InnoDB
  3902. EndCreateSchema
  3903.  
  3904. #INDEX MS_INDEX1(MS_MANAGE_SCHEDULEID),
  3905. #INDEX MS_INDEX2(MS_UNMANAGE_SCHEDULEID),
  3906. #CONSTRAINT MS_FK1 FOREIGN KEY (MS_MANAGE_SCHEDULEID) REFERENCES Schedule(S_SCHEDULEID) ON DELETE CASCADE,
  3907. #CONSTRAINT MS_FK2 FOREIGN KEY  ( MS_UNMANAGE_SCHEDULEID)REFERENCES Schedule(S_SCHEDULEID) ON DELETE CASCADE)
  3908.  
  3909. BeginCreateSchema
  3910. create table MaintenanceDevices ( 
  3911. "MD_INSTANCEID"  BIGINT  NOT NULL , 
  3912. "MD_NAME"  VARCHAR(100)  NOT NULL , 
  3913. "MD_OWNERNAME"  VARCHAR(25)  NOT NULL , 
  3914. "MD_DISPLAYNAME" VARCHAR(100) NOT NULL,
  3915. PRIMARY KEY ("MD_INSTANCEID","MD_NAME","MD_OWNERNAME"),
  3916. INDEX MD_INDEX1(MD_NAME,MD_OWNERNAME),
  3917. CONSTRAINT MD_FK1 FOREIGN KEY (MD_INSTANCEID) REFERENCES MaintenanceTask(MS_INSTANCEID) ON DELETE CASCADE,
  3918. CONSTRAINT     MD_FK2 FOREIGN KEY (MD_NAME,MD_OWNERNAME) REFERENCES ManagedObject(NAME,OWNERNAME) ON DELETE CASCADE)
  3919. TYPE=InnoDB
  3920. EndCreateSchema
  3921.  
  3922. BeginDropSchema
  3923. drop table MaintenanceDevices
  3924. EndDropSchema
  3925.  
  3926. BeginDropSchema
  3927. drop table MaintenanceTask
  3928. EndDropSchema
  3929.  
  3930. BeginDropSchema
  3931. drop table CsvImportTask
  3932. EndDropSchema
  3933.  
  3934. BeginDropSchema
  3935. drop table TaskInput
  3936. EndDropSchema
  3937.  
  3938. BeginDropSchema
  3939. drop table CompositeSchedule
  3940. EndDropSchema
  3941.  
  3942. BeginDropSchema
  3943. drop table CalendarSchedule
  3944. EndDropSchema
  3945.  
  3946. BeginDropSchema
  3947. drop table PeriodicSchedule
  3948. EndDropSchema
  3949.  
  3950. BeginDropSchema
  3951. drop table Schedule
  3952. EndDropSchema
  3953.  
  3954.  
  3955. ###############################  Notification Tables  ##################################################
  3956.  
  3957. BeginCreateSchema
  3958. create table ProfileType ( 
  3959. "ID" INTEGER  NOT NULL , 
  3960. "DESCRIPTION" VARCHAR(25),
  3961. CONSTRAINT ProfileType_PK PRIMARY KEY ("ID") ,
  3962. index ProfileType_ind1 (ID))
  3963. TYPE=InnoDB
  3964. EndCreateSchema
  3965.  
  3966. BeginCreateSchema
  3967. create table DeviceMappingType ( 
  3968. "ID" INTEGER  NOT NULL , 
  3969. "MAPPING_TYPE" VARCHAR(25),
  3970. CONSTRAINT DeviceMappingType_PK PRIMARY KEY ("ID") ,
  3971. index DeviceMappingType_ind1 (ID))
  3972. TYPE=InnoDB
  3973. EndCreateSchema
  3974.  
  3975. BeginCreateSchema
  3976. create table AvailAlarmCode ( 
  3977. "ID" INTEGER  NOT NULL , 
  3978. "ACODE" VARCHAR(25),
  3979. CONSTRAINT AvailAlarmCode_PK PRIMARY KEY ("ID") ,
  3980. index AvailAlarmCode_ind1 (ID))
  3981. TYPE=InnoDB
  3982. EndCreateSchema
  3983.  
  3984. BeginCreateSchema
  3985. create table CriteriaComparator ( 
  3986. "ID" INTEGER  NOT NULL , 
  3987. "COMPARATOR" VARCHAR(25),
  3988. "COMPARATOR_TYPE" INTEGER NOT NULL,
  3989. CONSTRAINT CriteriaComparator_PK PRIMARY KEY ("ID") ,
  3990. index CriteriaComparator_ind1 (ID))
  3991. TYPE=InnoDB
  3992. EndCreateSchema
  3993.  
  3994. BeginCreateSchema
  3995. create table CriteriaExpression ( 
  3996. "ID" INTEGER  NOT NULL , 
  3997. "COLUMN_NAME"  VARCHAR(255)  NOT NULL , 
  3998. "COMPARATOR_ID" INTEGER  NOT NULL , 
  3999. "VALUE"  VARCHAR(255)  NOT NULL , 
  4000. CONSTRAINT CriteriaExpression_PK PRIMARY KEY ("ID") ,
  4001. CONSTRAINT CriteriaExpression_FK1 FOREIGN KEY (COMPARATOR_ID) REFERENCES CriteriaComparator(ID) ON DELETE CASCADE,
  4002. index CriteriaExpression_ind1 (ID))
  4003. TYPE=InnoDB
  4004. EndCreateSchema
  4005.  
  4006. BeginCreateSchema
  4007. create table Criteria ( 
  4008. "ID" INTEGER  NOT NULL , 
  4009. "MATCH_ALL" BOOLEAN NOT NULL,  
  4010. CONSTRAINT Criteria_PK PRIMARY KEY ("ID") ,
  4011. index Criteria_ind1 (ID))
  4012. TYPE=InnoDB
  4013. EndCreateSchema
  4014.  
  4015.  
  4016. BeginCreateSchema
  4017. create table CriteriaToExpressionMapping ( 
  4018. "CRITERIA_ID" INTEGER  NOT NULL, 
  4019. "EXP_ID"  INTEGER  NOT NULL , 
  4020. CONSTRAINT CriteriaToExpressionMapping_PK PRIMARY KEY ("CRITERIA_ID","EXP_ID") ,
  4021. CONSTRAINT CriteriaToExpressionMapping_FK1 FOREIGN KEY (EXP_ID) REFERENCES CriteriaExpression(ID) ON DELETE CASCADE,
  4022. CONSTRAINT CriteriaToExpressionMapping_FK2 FOREIGN KEY (CRITERIA_ID) REFERENCES Criteria(ID) ON DELETE CASCADE,
  4023. index CriteriaToExpressionMapping_ind1 (CRITERIA_ID,EXP_ID))
  4024. TYPE=InnoDB
  4025. EndCreateSchema
  4026.  
  4027.  
  4028. BeginCreateSchema
  4029. create table NotificationProfile( 
  4030. "PROFILETYPE"  INTEGER  NOT NULL , 
  4031. "PROFILE_ID" INTEGER  NOT NULL , 
  4032. "PROFILE_NAME" VARCHAR(100)  NOT NULL UNIQUE , 
  4033. "PROFILE_DESC" VARCHAR(255), 
  4034. "NOTIFY_CLEAR" BOOLEAN,
  4035. CONSTRAINT Profile_PK PRIMARY KEY ("PROFILE_ID") ,
  4036. CONSTRAINT ProfileType_FK1 FOREIGN KEY (PROFILETYPE) REFERENCES ProfileType(ID) ON DELETE CASCADE,
  4037. index Notification_ind1 (PROFILE_ID),
  4038. index Notification_ind2 (PROFILETYPE))
  4039. TYPE=InnoDB
  4040. EndCreateSchema
  4041.  
  4042. BeginCreateSchema
  4043. create table ExpertToNotification ( 
  4044. "ALARMID"  INTEGER  NOT NULL , 
  4045. "PROFILE_ID" INTEGER  NOT NULL , 
  4046. CONSTRAINT Notification_PK PRIMARY KEY ("ALARMID","PROFILE_ID") ,
  4047. CONSTRAINT Notification_FK1 FOREIGN KEY (ALARMID) REFERENCES AlertExpert(ID) ON DELETE CASCADE,
  4048. CONSTRAINT Notification_FK2 FOREIGN KEY (PROFILE_ID) REFERENCES  NotificationProfile(PROFILE_ID) ON DELETE CASCADE,
  4049. index Notification_ind1 (ALARMID,PROFILE_ID),
  4050. index Notification_ind2 (ALARMID),
  4051. index Notification_ind3 (PROFILE_ID))
  4052. TYPE=InnoDB
  4053. EndCreateSchema
  4054.  
  4055. BeginCreateSchema
  4056. create table AvailExpertNotifyOption ( 
  4057. "PROFILE_ID" INTEGER  NOT NULL, 
  4058. "ALARM_CODE" INTEGER NOT NULL,
  4059. CONSTRAINT AvailExpertNotification_PK PRIMARY KEY ("PROFILE_ID","ALARM_CODE") ,
  4060. CONSTRAINT AvailExpertNotification_FK1 FOREIGN KEY (ALARM_CODE) REFERENCES AvailAlarmCode(ID) ON DELETE CASCADE,
  4061. CONSTRAINT AvailExpertNotification_FK2 FOREIGN KEY (PROFILE_ID) REFERENCES  ExpertToNotification(PROFILE_ID) ON DELETE CASCADE,
  4062. index AvailExpertNotification_ind1 (PROFILE_ID,ALARM_CODE))
  4063. TYPE=InnoDB
  4064. EndCreateSchema
  4065.  
  4066. BeginCreateSchema
  4067. create table NotificationToDevice( 
  4068. "PROFILE_ID" INTEGER  NOT NULL , 
  4069. "DEVICE_MAPPING_TYPE"  INTEGER  NOT NULL , 
  4070. CONSTRAINT NotificationToDevice_PK PRIMARY KEY ("PROFILE_ID") ,
  4071. CONSTRAINT NotificationToDevice_FK1 FOREIGN KEY (DEVICE_MAPPING_TYPE) REFERENCES DeviceMappingType(ID) ON DELETE CASCADE,
  4072. CONSTRAINT NotificationToDevice_FK2 FOREIGN KEY (PROFILE_ID) REFERENCES  NotificationProfile(PROFILE_ID) ON DELETE CASCADE,
  4073. index NotificationToDevice_ind1 (PROFILE_ID))
  4074. TYPE=InnoDB
  4075. EndCreateSchema
  4076.  
  4077. BeginCreateSchema
  4078. create table NotificationToDeviceList( 
  4079. "PROFILE_ID" INTEGER  NOT NULL , 
  4080. "DEVICE_NAME"  VARCHAR(255)  NOT NULL , 
  4081. CONSTRAINT NotificationToDeviceList_PK PRIMARY KEY ("PROFILE_ID","DEVICE_NAME") ,
  4082. CONSTRAINT NotificationToDeviceList_FK1 FOREIGN KEY (DEVICE_NAME) REFERENCES ManagedObject(NAME) ON DELETE CASCADE,
  4083. CONSTRAINT NotificationToDeviceList_FK2 FOREIGN KEY (PROFILE_ID) REFERENCES  NotificationToDevice(PROFILE_ID) ON DELETE CASCADE,
  4084. index NotificationToDeviceList_ind1 (PROFILE_ID))
  4085. TYPE=InnoDB
  4086. EndCreateSchema
  4087.  
  4088. BeginCreateSchema
  4089. create table NotificationToDeviceCriteria( 
  4090. "PROFILE_ID" INTEGER  NOT NULL , 
  4091. "CRITERIA_ID" INTEGER  NOT NULL ,
  4092. CONSTRAINT NotificationToDeviceCriteria_PK PRIMARY KEY ("PROFILE_ID"),
  4093. CONSTRAINT NotificationToDeviceCriteria_FK1 FOREIGN KEY (CRITERIA_ID) REFERENCES Criteria(ID) ON DELETE CASCADE,
  4094. CONSTRAINT NotificationToDeviceCriteria_FK2 FOREIGN KEY (PROFILE_ID) REFERENCES  NotificationToDevice(PROFILE_ID) ON DELETE CASCADE,
  4095. index NotificationToDeviceCriteria_ind1 (PROFILE_ID))
  4096. TYPE=InnoDB
  4097. EndCreateSchema
  4098.  
  4099. BeginCreateSchema
  4100. create table EmailNotification( 
  4101. "PROFILE_ID" INTEGER  NOT NULL , 
  4102. "MAIL_FROM" VARCHAR(100) NOT NULL,
  4103. "SUBJECT" VARCHAR(100) NOT NULL,
  4104. "MAIL_MESSAGE" VARCHAR(250) NOT NULL,
  4105. CONSTRAINT Email_PK PRIMARY KEY ("PROFILE_ID") ,
  4106. CONSTRAINT EmailNotification_FK1 FOREIGN KEY (PROFILE_ID) REFERENCES NotificationProfile(PROFILE_ID) ON DELETE CASCADE,
  4107. index Email_ind1 (PROFILE_ID))
  4108. TYPE=InnoDB
  4109. EndCreateSchema
  4110.  
  4111. BeginCreateSchema
  4112. create table MailIds ( 
  4113. "PROFILE_ID" INTEGER  NOT NULL , 
  4114. "ID" INTEGER  NOT NULL , 
  4115. "MAIL_TO" VARCHAR(100) NOT NULL,
  4116. CONSTRAINT MailIds_PK PRIMARY KEY ("ID") ,
  4117. CONSTRAINT MailIds_FK1 FOREIGN KEY (PROFILE_ID) REFERENCES  EmailNotification(PROFILE_ID) ON DELETE CASCADE,
  4118. index MailIds_ind1 (ID),
  4119. index MailIds_ind2 (PROFILE_ID))
  4120. TYPE=InnoDB
  4121. EndCreateSchema
  4122.  
  4123. BeginCreateSchema
  4124. create table PlaySoundNotification ( 
  4125. "PROFILE_ID" INTEGER  NOT NULL , 
  4126. "SOUNDFILENAME" VARCHAR(100) NOT NULL,
  4127. CONSTRAINT PlaySound_PK PRIMARY KEY ("PROFILE_ID") ,
  4128. CONSTRAINT PlaySound_FK1 FOREIGN KEY (PROFILE_ID) REFERENCES  NotificationProfile(PROFILE_ID) ON DELETE CASCADE,
  4129. index PlaySound_ind1 (PROFILE_ID))
  4130. TYPE=InnoDB
  4131. EndCreateSchema
  4132.  
  4133. BeginCreateSchema
  4134. create table RunSystemCommand  ( 
  4135. "PROFILE_ID" INTEGER  NOT NULL , 
  4136. "COMMAND" VARCHAR(250) NOT NULL,
  4137. CONSTRAINT RunSystemCommand_PK PRIMARY KEY ("PROFILE_ID") ,
  4138. CONSTRAINT RunSystemCommand_FK1 FOREIGN KEY (PROFILE_ID) REFERENCES  NotificationProfile(PROFILE_ID) ON DELETE CASCADE,
  4139. index RunSystemCommand_ind1 (PROFILE_ID))
  4140. TYPE=InnoDB
  4141. EndCreateSchema
  4142.  
  4143. BeginCreateSchema
  4144. create table TrapNotification  ( 
  4145. "PROFILE_ID" INTEGER  NOT NULL , 
  4146. "MANAGERNAME" VARCHAR(100) NOT NULL,
  4147. "ENTERPRISEOID" varchar(100),
  4148. "GT" INTEGER,
  4149. "ST" INTEGER,
  4150. "COMMUNITY" varchar(100),
  4151. "PORT" INTEGER,
  4152. CONSTRAINT TrapNotification_PK PRIMARY KEY ("PROFILE_ID") ,
  4153. CONSTRAINT TrapNotification_FK1 FOREIGN KEY (PROFILE_ID) REFERENCES  NotificationProfile(PROFILE_ID) ON DELETE CASCADE,
  4154. index TrapNotification_ind1 (PROFILE_ID))
  4155. TYPE=InnoDB
  4156. EndCreateSchema
  4157.  
  4158. BeginCreateSchema
  4159. create table TrapVarBindings ( 
  4160. "PROFILE_ID" INTEGER  NOT NULL , 
  4161. "OID" varchar(100),
  4162. "TYPE" varchar(20),
  4163. "VALUE" varchar(25),
  4164. CONSTRAINT TrapVarBinding_PK PRIMARY KEY ("PROFILE_ID","OID") ,
  4165. CONSTRAINT TrapVarBinding_FK1 FOREIGN KEY (PROFILE_ID) REFERENCES  TrapNotification(PROFILE_ID) ON DELETE CASCADE,
  4166. index TrapVarBinding_ind1 (PROFILE_ID,OID),
  4167. index TrapVarBinding_ind2 (PROFILE_ID))
  4168. TYPE=InnoDB
  4169. EndCreateSchema
  4170.  
  4171. #BeginDropSchema
  4172. #drop table TrapVarBindings
  4173. #EndDropSchema
  4174.  
  4175. #BeginDropSchema
  4176. #drop table TrapNotification
  4177. #EndDropSchema
  4178.  
  4179.  
  4180. #BeginDropSchema
  4181. #drop table PlaySoundNotification
  4182. #EndDropSchema
  4183.  
  4184. #BeginDropSchema
  4185. #drop table RunSystemCommand
  4186. #EndDropSchema
  4187.  
  4188. #users change perdsistance
  4189. #BeginDropSchema
  4190. #drop table NotificationProfile
  4191. #EndDropSchema
  4192.  
  4193. #BeginDropSchema
  4194. #drop table ProfileType
  4195. #EndDropSchema
  4196.  
  4197. BeginDropSchema
  4198. drop table NotificationToDeviceList
  4199. EndDropSchema
  4200. ###############################  Notification Tables End ##################################################
  4201.  
  4202. BeginCreateSchema
  4203. create table ViewMappingType ( 
  4204. "ID" INTEGER NOT NULL,
  4205. "TYPE" VARCHAR(50) NOT NULL,
  4206. CONSTRAINT ViewMappingType_PK PRIMARY KEY ("ID"),
  4207. index ViewMappingType_ind1 (ID))
  4208. TYPE=InnoDB
  4209. EndCreateSchema
  4210.  
  4211. BeginCreateSchema
  4212. create table UserToBViewMapping ( 
  4213. "USERNAME" VARCHAR(50)  NOT NULL , 
  4214. "VIEW_MAPPING" INTEGER NOT NULL,
  4215. CONSTRAINT UserToBViewMapping_PK PRIMARY KEY ("USERNAME") ,
  4216. CONSTRAINT UserToBViewMapping_FK1 FOREIGN KEY (VIEW_MAPPING) REFERENCES ViewMappingType(ID) ON DELETE CASCADE,
  4217. index UserToBViewMapping_ind1 (USERNAME))
  4218. TYPE=InnoDB
  4219. EndCreateSchema
  4220.  
  4221. BeginCreateSchema
  4222. create table UserToBViewList ( 
  4223. "USERNAME" VARCHAR(50)  NOT NULL , 
  4224. "BVIEWNAME" VARCHAR(255) NOT NULL,
  4225. CONSTRAINT UserToBViewList_PK PRIMARY KEY ("USERNAME","BVIEWNAME"),
  4226. CONSTRAINT UserToBViewList_FK1 FOREIGN KEY (BVIEWNAME) REFERENCES MapDB(NAME) ON DELETE CASCADE,
  4227. CONSTRAINT UserToBViewList_FK2 FOREIGN KEY (USERNAME) REFERENCES UserToBViewMapping(USERNAME) ON DELETE CASCADE,
  4228. index UserToBViewList_ind1 (USERNAME,BVIEWNAME))
  4229. TYPE=InnoDB
  4230. EndCreateSchema
  4231.  
  4232. BeginDropSchema
  4233. drop table UserToBViewList
  4234. drop index UserToBViewList_ind1
  4235. EndDropSchema
  4236.  
  4237. BeginDropSchema
  4238. drop table MapDB
  4239. drop index MapDB0_ndx
  4240. drop index MapDB1_ndx
  4241. EndDropSchema
  4242.  
  4243. BeginCreateSchema
  4244. create table AlarmWatchList(
  4245. "NAME" varchar(100) NOT NULL,
  4246. "USERNAME" varchar(50) NOT NULL,
  4247. CONSTRAINT AlarmWatchList_PK PRIMARY KEY (USERNAME,NAME),
  4248. CONSTRAINT AlarmWatchList_FK2 FOREIGN KEY (NAME) REFERENCES ManagedObject(NAME) ON DELETE CASCADE)
  4249. TYPE=InnoDB
  4250. EndCreateSchema
  4251.  
  4252. BeginDropSchema
  4253. drop table AlarmWatchList
  4254. EndDropSchema
  4255.  
  4256. ###############################  UserBview mapping Tables  ##################################################
  4257.  
  4258. BeginCreateSchema
  4259. create table DiscoveryStatus ( 
  4260. "ID" INTEGER  NOT NULL , 
  4261. "DESCRIPTION" VARCHAR(50) NOT NULL,
  4262. CONSTRAINT DiscoveryStatus_PK PRIMARY KEY ("ID") ,
  4263. index DiscoveryStatus_ind1 (ID))
  4264. TYPE=InnoDB
  4265. EndCreateSchema
  4266.  
  4267. BeginCreateSchema
  4268. create table ImportStatus ( 
  4269. "ID" INTEGER  NOT NULL , 
  4270. "DESCRIPTION" VARCHAR(50) NOT NULL,
  4271. CONSTRAINT ImportStatus_PK PRIMARY KEY ("ID") ,
  4272. index ImportStatus_ind1 (ID))
  4273. TYPE=InnoDB
  4274. EndCreateSchema
  4275.  
  4276. BeginCreateSchema
  4277. create table ImportLog ( 
  4278. "IMPORTID" BIGINT  NOT NULL , 
  4279. "STARTTIME" BIGINT NOT NULL,
  4280. "ENDTIME" BIGINT NOT NULL,
  4281. "FILENAME" VARCHAR(50) NOT NULL,
  4282. "STATUS" INTEGER NOT NULL,
  4283. CONSTRAINT ImportLog_PK PRIMARY KEY ("IMPORTID") ,
  4284. CONSTRAINT ImportLog_FK1 FOREIGN KEY (STATUS) REFERENCES ImportStatus(ID) ON DELETE CASCADE,
  4285. index ImportLog_ind1 (IMPORTID))
  4286. TYPE=InnoDB
  4287. EndCreateSchema
  4288.  
  4289.  
  4290. BeginCreateSchema
  4291. create table DiscoveryLog ( 
  4292. "LOGID" BIGINT  NOT NULL , 
  4293. "IMPORTID" BIGINT NOT NULL,
  4294. "IPADDRESS" VARCHAR(50) NOT NULL,
  4295. "STATUS" INTEGER NOT NULL,
  4296. CONSTRAINT DiscoveryLog_PK PRIMARY KEY ("LOGID") ,
  4297. CONSTRAINT DiscoveryLog_FK1 FOREIGN KEY (IMPORTID) REFERENCES  ImportLog(IMPORTID) ON DELETE CASCADE,
  4298. CONSTRAINT DiscoveryLog_FK2 FOREIGN KEY (STATUS) REFERENCES  DiscoveryStatus(ID) ON DELETE CASCADE,
  4299. index DiscoveryLog_ind1 (LOGID))
  4300. TYPE=InnoDB
  4301. EndCreateSchema
  4302.  
  4303.  
  4304. BeginDropSchema
  4305. drop table DiscoveryLog
  4306. EndDropSchema
  4307.  
  4308. BeginDropSchema
  4309. drop table ImportLog
  4310. EndDropSchema
  4311.  
  4312.  
  4313. BeginDropSchema
  4314. drop table DiscoveryStatus
  4315. EndDropSchema
  4316.  
  4317. BeginDropSchema
  4318. drop table ImportStatus
  4319. EndDropSchema
  4320.  
  4321.  
  4322. ###############################  Import Result Tables  ##################################################
  4323. BeginDropSchema
  4324. drop table ManagedObject
  4325. drop index ManagedObject0_ndx
  4326. drop index ManagedObject1_ndx
  4327. drop index ManagedObject2_ndx
  4328. EndDropSchema
  4329.  
  4330.  
  4331.  
  4332. EndModules TopoDB-MapDB-EventDB-AlertDB-PollDB-PolicyDB-USERSTORAGEDB
  4333.  
  4334. #Do not edit the below lines. They are used for statistical data collection.
  4335.  
  4336. <STATS>
  4337. create table STATSDATA%(
  4338. POLLID BIGINT,
  4339. INSTANCE varchar(100),
  4340. TTIME BIGINT,
  4341. VAL BIGINT,
  4342. index statsdata_ind1 (POLLID),
  4343. index statsdata_ind2 (INSTANCE))
  4344. </STATS>
  4345.  
  4346. <STRING>
  4347. create table STRINGDATA%(
  4348. POLLID BIGINT,
  4349. INSTANCE varchar(100),
  4350. TTIME BIGINT,
  4351. VALUE varchar(200))
  4352. </STRING>
  4353.