//$Id: DatabaseSchema.conf,v 1.9 2007/01/22 08:47:26 zhoubin Exp $
#Schema for MYSQL

BeginModules TopoDB-MapDB-EventDB-AlertDB-PollDB-PolicyDB-USERSTORAGEDB

BeginCreateSchema
create table ObjectTypes (
"OBJKEY" varchar( 100 ) NOT NULL , 
"CLASSNAME" varchar( 50 ) )
EndCreateSchema

BeginDropSchema
drop table ObjectTypes
EndDropSchema

BeginCreateSchema
create table ManagedObject( 
"NAME" varchar(100) NOT NULL,
"DISPLAYNAME" varchar(100) NOT NULL,
"PARENTKEY" varchar(100)  NOT NULL,
"TYPE" varchar(100),
"MANAGED" varchar(10),
"STATUS" INTEGER,
"FAILURETHRESHOLD" INTEGER,
"FAILURECOUNT" INTEGER,
"POLLINTERVAL" INTEGER,
"STATUSCHANGETIME" varchar(25),
"STATUSUPDATETIME" varchar(25),
"TESTER" varchar(100),
"UCLASS" varchar(100),
"CLASSNAME" varchar(100),
"WEBNMS" varchar(100),
"OWNERNAME" varchar(25) NOT NULL,
"STATUSPOLLENABLED" varchar(10),
"ISCONTAINER" varchar(10),
"ISGROUP" varchar(10),
PRIMARY KEY ("NAME","OWNERNAME"),
index ManagedObject0_ndx("NAME"),
index ManagedObject1_ndx ("OWNERNAME"),
index ManagedObject2_ndx ("PARENTKEY"))
EndCreateSchema

BeginDropSchema
drop table ManagedObject
drop index ManagedObject0_ndx
drop index ManagedObject1_ndx
EndDropSchema

#BeginIndex
#ALTER TABLE ManagedObject add index ManagedObject0_ndx("NAME")
#ALTER TABLE ManagedObject add index ManagedObject1_ndx ("OWNERNAME")
#EndIndex

BeginCreateSchema
create table MapContainer(
"NAME" varchar(100) NOT NULL,
"OBJNAME" varchar(100)  NOT NULL,
"MAPNAME" varchar(100) NOT NULL,
"OWNERNAME" varchar(25) NOT NULL,
"LABEL" varchar(100),
"ICONNAME" varchar(100),
"MENUNAME" varchar(100),
"WIDTH" INTEGER,
"HEIGHT" INTEGER,
"X" INTEGER,
"Y" INTEGER,
"WEBNMS" varchar(100),
"GROUPNAME" varchar(100),
"ANCHORED" varchar(10),
"CURRENTTOPOLOGY" varchar(100),
"TOPOLOGY" varchar(100),
"CONTAINMENT"	varchar(10),		
"OBJTYPE" INTEGER,
"PARENTNAME" varchar(100),
PRIMARY KEY ( "NAME","MAPNAME","OWNERNAME" ),
index MapContainer0_ndx ("MAPNAME"),
index MapContainer1_ndx ("NAME"),
index MapContainer2_ndx ("OWNERNAME"),
index MapContainer3_ndx ("OBJNAME","OWNERNAME"))
EndCreateSchema

BeginDropSchema
drop table MapContainer
drop index MapContainer0_ndx
drop index MapContainer1_ndx
drop index MapContainer2_ndx
EndDropSchema

BeginCreateSchema
create table TopoObject( 
"NAME" varchar(100) NOT NULL,
"IPADDRESS" varchar(100),
"NETMASK" varchar(100),
"COMMUNITY" varchar(100),
"WRITECOMMUNITY" varchar(100),
"SNMPPORT" INTEGER,
"ISDHCP" varchar(10),
"BASEMIBS" varchar(100),
"OWNERNAME" varchar(25) NOT NULL,
"VERSION" varchar(100),
"USERNAME" varchar(100),
"CONTEXTNAME" varchar(100),
"ISSNMP" varchar(10),
"ISNODE" varchar(10),
"ISNETWORK" varchar(10),
"ISINTERFACE" varchar(10),
PRIMARY KEY ("NAME", "OWNERNAME"),
index TopoObject0_ndx ("NAME"),
index TopoObject1_ndx ("OWNERNAME"))
EndCreateSchema

BeginDropSchema
drop table TopoObject
drop index TopoObject0_ndx
drop index TopoObject1_ndx
EndDropSchema

#BeginIndex
#ALTER TABLE TopoObject add index TopoObject0_ndx ("NAME")
#ALTER TABLE TopoObject add index TopoObject1_ndx ("OWNERNAME")
#EndIndex

BeginCreateSchema
create table Node( 
"NAME" varchar(100) NOT NULL,
"ISROUTER" varchar(10),
"OWNERNAME" varchar(25) NOT NULL,
PRIMARY KEY ("NAME", "OWNERNAME"),
index Node0_ndx ("NAME"),
index Node1_ndx ("OWNERNAME"))
EndCreateSchema

BeginDropSchema
drop table Node
drop index Node0_ndx
EndDropSchema

#BeginIndex
#ALTER TABLE Node add index Node0_ndx ("NAME")
#ALTER TABLE Node add index Node1_ndx ("OWNERNAME")
#EndIndex

BeginCreateSchema
create table Network(
"NAME" varchar(100) NOT NULL,
"DISCOVER" varchar(10),
"DISCOVERYSTATUS" INTEGER,
"OWNERNAME" varchar(25) NOT NULL,
"PARENTNETWORK" varchar(100)  NOT NULL,
"PARENTNETMASK" varchar(100),
PRIMARY KEY ("NAME","OWNERNAME"),
index Network0_ndx ("NAME"),
index Network1_ndx ("OWNERNAME"),
index Network2_ndx ("PARENTNETWORK"))
EndCreateSchema

BeginDropSchema
drop table Network
drop index Network0_ndx
drop index Network1_ndx
EndDropSchema

#BeginIndex
#ALTER TABLE Network add index Network0_ndx ("NAME")
#ALTER TABLE Network add index Network1_ndx ("OWNERNAME")
#EndIndex

BeginCreateSchema
create table IpAddress( 
"NAME" varchar(100) NOT NULL,
"PARENTNODE" varchar(100) NOT NULL,
"PARENTNET" varchar(100) NOT NULL,
"OWNERNAME" varchar(25) NOT NULL,
PRIMARY KEY ("NAME", "OWNERNAME"),
index IpAddress0_ndx ( "NAME "),
index IpAddress1_ndx ( "OWNERNAME "),
index IpAddress2_ndx ( "PARENTNODE"),
index IpAddress3_ndx ( "PARENTNET"))
EndCreateSchema

BeginDropSchema
drop table IpAddress
drop index IpAddress0_ndx
drop index IpAddress1_ndx
drop index IpAddress2_ndx
EndDropSchema

#BeginIndex
#ALTER TABLE IpAddress add index IpAddress0_ndx ( "NAME ")
#ALTER TABLE IpAddress add index IpAddress1_ndx ( "OWNERNAME ")
#ALTER TABLE IpAddress add index IpAddress2_ndx ( "PARENTNODE")
#ALTER TABLE IpAddress add index IpAddress3_ndx ( "PARENTNET")
#EndIndex

BeginCreateSchema
create table SnmpNode( 
"NAME" varchar(100) NOT NULL,
"HOSTNETMASK" varchar(100),
"SYSDESCR" varchar(200),
"SYSNAME" varchar(100),
"SYSOID" varchar(100),
"OWNERNAME" varchar(25) NOT NULL,
PRIMARY KEY ("NAME", "OWNERNAME"),
index SnmpNode0_ndx ("NAME"),
index SnmpNode1_ndx ("OWNERNAME"))
EndCreateSchema

BeginDropSchema
drop table SnmpNode
drop index SnmpNode0_ndx
drop index SnmpNode1_ndx
EndDropSchema

#BeginIndex
#ALTER TABLE SnmpNode add index SnmpNode0_ndx ("NAME")
#ALTER TABLE SnmpNode add index SnmpNode1_ndx ("OWNERNAME")
#EndIndex

BeginCreateSchema
create table SnmpInterface( 
"NAME" varchar(100) NOT NULL,
"HOSTNETMASK" varchar(100),
"IFINDEX" INTEGER,
"PHYSMEDIA" varchar(100),
"PHYSADDR" varchar(100),
"IFSPEED" INTEGER,
"IFDESCR" varchar(200),
"SYSOID" varchar(100),
"OWNERNAME" varchar(25) NOT NULL,
PRIMARY KEY ("NAME", "OWNERNAME"),
index SnmpInterface0_ndx ("NAME"),
index SnmpInterface1_ndx ("OWNERNAME"))
EndCreateSchema

BeginDropSchema
drop table SnmpInterface
drop index SnmpInterface0_ndx
drop index SnmpInterface1_ndx
EndDropSchema

#BeginIndex
#ALTER TABLE SnmpInterface add index SnmpInterface0_ndx ("NAME")
#ALTER TABLE SnmpInterface add index SnmpInterface1_ndx ("OWNERNAME")
#EndIndex

BeginCreateSchema
create table TL1Node (
"LOGINCOMMAND" VARCHAR (254) ,
"INITCOMMAND" VARCHAR (254) ,
"CONNECTIONHANDLER" VARCHAR (150) ,
"INFOCOMMAND" VARCHAR (254) ,
"DICTIONARY" VARCHAR (100) ,
"SESSIONID" VARCHAR (100) ,
"TL1PORT" INTEGER ,
"NOTIFYID" VARCHAR (100) ,
"NAME" VARCHAR (100) NOT NULL ,
"OWNERNAME" VARCHAR (25) NOT NULL ,
PRIMARY KEY ("NAME", "OWNERNAME"))
EndCreateSchema

BeginDropSchema
drop table TL1Node
EndDropSchema

#BeginIndex
#CREATE INDEX TL1Node0_ndx ON TL1Node ("NAME")
#CREATE INDEX TL1Node1_ndx ON TL1Node ("OWNERNAME")
#EndIndex 

BeginCreateSchema
create table TL1Interface (
"STATPOLLCOMMAND" VARCHAR (254) ,
"CONNECTIONHANDLER" VARCHAR (150) ,
"DICTIONARY" VARCHAR (100) ,
"SESSIONID" VARCHAR (100) ,
"TL1PORT" INTEGER ,
"NAME" VARCHAR (100) NOT NULL ,
"OWNERNAME" VARCHAR (25) NOT NULL ,
PRIMARY KEY ("NAME", "OWNERNAME"))
EndCreateSchema

BeginDropSchema
drop table TL1Interface
EndDropSchema

#BeginIndex
#CREATE INDEX TL1Interface0_ndx ON TL1Interface ("NAME")
#CREATE INDEX TL1Interface1_ndx ON TL1Interface ("OWNERNAME")
#EndIndex

BeginCreateSchema
create table TOPOUSERPROPS(
"NAME" varchar( 100 ) NOT NULL, 
"OWNERNAME" varchar(25) NOT NULL,
"PROPNAME" varchar( 150 ) NOT NULL,
"PROPVAL" varchar( 150 ),
index TOPOUSERPROPS0_ndx ( "NAME"),
index TOPOUSERPROPS1_ndx ( "OWNERNAME")
)
EndCreateSchema

BeginDropSchema
drop table TOPOUSERPROPS
drop index TOPOUSERPROPS0_ndx
drop index TOPOUSERPROPS1_ndx
EndDropSchema

#BeginIndex
#ALTER TABLE TOPOUSERPROPS add index TOPOUSERPROPS0_ndx ( "NAME")
#ALTER TABLE TOPOUSERPROPS add index TOPOUSERPROPS1_ndx ( "OWNERNAME")
#EndIndex

BeginCreateSchema
create table ALERTUSERPROPS(
"NAME" varchar( 100 ) NOT NULL,
"OWNERNAME" varchar(25) NOT NULL,
"PROPNAME" varchar( 150 ) NOT  NULL,
"PROPVAL" varchar( 150 ),
index ALERTUSERPROPS0_ndx ( "NAME"),
index ALERTUSERPROPS1_ndx ( "OWNERNAME"))
EndCreateSchema

BeginDropSchema
drop table ALERTUSERPROPS
drop index ALERTUSERPROPS0_ndx
drop index ALERTUSERPROPS1_ndx
EndDropSchema

#BeginIndex
#ALTER TABLE ALERTUSERPROPS add index ALERTUSERPROPS0_ndx ( "NAME")
#ALTER TABLE ALERTUSERPROPS add index ALERTUSERPROPS1_ndx ( "OWNERNAME")
#EndIndex

BeginCreateSchema
create table EVENTUSERPROPS(
"NAME" INTEGER NOT NULL,
"OWNERNAME" varchar(25) NOT NULL,
"PROPNAME" varchar( 150 ) NOT NULL,
"PROPVAL" varchar( 150 ),
index EVENTUSERPROPS0_ndx  ( "NAME"),
index EVENTUSERPROPS1_ndx  ( "OWNERNAME"))
EndCreateSchema

BeginDropSchema
drop table EVENTUSERPROPS
drop index EVENTUSERPROPS0_ndx
drop index EVENTUSERPROPS1_ndx
EndDropSchema

#BeginIndex
#ALTER TABLE EVENTUSERPROPS add index EVENTUSERPROPS0_ndx  ( "NAME")
#ALTER TABLE EVENTUSERPROPS add index EVENTUSERPROPS1_ndx  ( "OWNERNAME")
#EndIndex

BeginCreateSchema
create table USERTABLE(
"DBKEY" varchar(105) NOT NULL,
"HOST" varchar(50),
"PORT" varchar(5),
"ENGINENAME" varchar(50), 
"USERNAME" varchar(50), 
"AUTHPROTOCOL" varchar(10), 
"AUTHPASSWORD" varchar(50),
"PRIVPROTOCOL" varchar(10), 
"PRIVPASSWORD" varchar(50),
PRIMARY KEY ("DBKEY"))
EndCreateSchema

BeginCreateSchema
create table HOSTS(
"HOSTNAMES" varchar(100) NOT NULL,
PRIMARY KEY ("HOSTNAMES"))
EndCreateSchema

BeginCreateSchema
create table PORTS(
"PORTS" varchar(100) NOT NULL,
PRIMARY KEY ("PORTS"))
EndCreateSchema

BeginCreateSchema
create table ENGINES(
"ENGINENAMES" varchar(100) NOT NULL,
PRIMARY KEY ("ENGINENAMES"))
EndCreateSchema

BeginCreateSchema
create table USERS(
"USERNAMES" varchar(100) NOT NULL,
PRIMARY KEY("USERNAMES"))
EndCreateSchema

BeginCreateSchema
create table POLLUSERPROPS(
"NAME" varchar( 100 ) NOT NULL,
"AGENT" varchar( 100 ) NOT NULL,
"OID" varchar( 200 ) NOT NULL,
"OWNERNAME" varchar(25) NOT NULL,
"PROPNAME" varchar( 150 ) NOT NULL,
"PROPVAL" varchar( 150 ),
index POLLUSERPROPS0_ndx ( "NAME"),
index POLLUSERPROPS1_ndx ( "AGENT"),
index POLLUSERPROPS2_ndx ( "OID"),
index POLLUSERPROPS3_ndx ( "OWNERNAME"))
EndCreateSchema

BeginDropSchema
drop table POLLUSERPROPS
drop index POLLUSERPROPS0_ndx
drop index POLLUSERPROPS1_ndx
drop index POLLUSERPROPS2_ndx
drop index POLLUSERPROPS3_ndx
EndDropSchema

#BeginIndex
#ALTER TABLE POLLUSERPROPS add index POLLUSERPROPS0_ndx ( "NAME")
#ALTER TABLE POLLUSERPROPS add index POLLUSERPROPS1_ndx ( "AGENT")
#ALTER TABLE POLLUSERPROPS add index POLLUSERPROPS2_ndx ( "OID")
#ALTER TABLE POLLUSERPROPS add index POLLUSERPROPS3_ndx ( "OWNERNAME")
#EndIndex

BeginCreateSchema
create table ANNOTATION (
"ENTITY" varchar( 100 ) NOT NULL, 
"WHO" varchar( 50 ) , 
"MODTIME" BIGINT , 
"OWNERNAME" varchar(25) NOT NULL,
"NOTES"  varchar(250 ),
index ANNOTATION0_ndx ( "ENTITY"),
index ANNOTATION1_ndx ( "OWNERNAME"))
EndCreateSchema

BeginDropSchema
drop table ANNOTATION
drop index ANNOTATION0_ndx
drop index ANNOTATION1_ndx
EndDropSchema

#BeginIndex
#ALTER TABLE ANNOTATION add index ANNOTATION0_ndx ( "ENTITY")
#ALTER TABLE ANNOTATION add index ANNOTATION1_ndx ( "OWNERNAME")
#EndIndex

BeginCreateSchema
create table Alert ( 
"ID" INTEGER,
"GROUPNAME" varchar(100),
"CATEGORY" varchar(100),
"SEVERITY" INTEGER,
"PREVIOUSSEVERITY" INTEGER,
"ENTITY" varchar(100) NOT NULL,
"CREATETIME" BIGINT,
"MODTIME" BIGINT,
"MMESSAGE" varchar(200),
"SOURCE" varchar(100),
"MAPNAME" varchar(100),
"WHO" varchar(100),
"STAGE" INTEGER,
"WEBNMS" varchar(100),
"OWNERNAME" varchar(25) NOT NULL,
"PRIORITY" INTEGER,
PRIMARY KEY ("ENTITY", "OWNERNAME"),
index Alert0_ndx ("ENTITY"),
index Alert1_ndx ("OWNERNAME"))
EndCreateSchema

BeginDropSchema
drop table Alert
drop index Alert0_ndx
drop index Alert1_ndx
EndDropSchema

#BeginIndex
#ALTER TABLE Alert add index Alert0_ndx ("ENTITY")
#ALTER TABLE Alert add index Alert1_ndx ("OWNERNAME")
#EndIndex

BeginCreateSchema
create table MapDB( 
"NAME" varchar(100) NOT NULL,
"OWNERNAME" varchar(25) NOT NULL,
"PARENT" varchar(100),
"LABEL" varchar(100),
"MENUNAME" varchar(100),
"IMAGENAME" varchar(100),
"TREEICONFILENAME" varchar(100),
"AUTOPLACEMENT" varchar(10),
"ANCHORED" varchar(10),
"HELPDOC" varchar(100),
"TOPOLOGY" varchar(100),
"CURRENTTOPOLOGY" varchar(100),
"WEBNMS" varchar(100),
"GROUPNAME" varchar(100),
"MAPSYMBOLRENDERER" varchar(100),
"MAPLINKRENDERER" varchar(100),
"MAPLISTENER" varchar(100),
PRIMARY KEY ("NAME","OWNERNAME"),
index MapDB0_ndx ("NAME"),
index MapDB1_ndx ("OWNERNAME"))
EndCreateSchema

BeginDropSchema
drop table MapDB
drop index MapDB0_ndx
drop index MapDB1_ndx
EndDropSchema

#BeginIndex
#ALTER TABLE MapDB add index MapDB0_ndx ("NAME")
#EndIndex

BeginCreateSchema
create table MapSymbol( 
"NAME" varchar(100) NOT NULL,
"OBJNAME" varchar(100)  NOT NULL,
"MAPNAME" varchar(100) NOT NULL,
"OWNERNAME" varchar(25) NOT NULL,
"LABEL" varchar(100),
"ICONNAME" varchar(100),
"MENUNAME" varchar(100),
"WIDTH" varchar(25),
"HEIGHT" varchar(25),
"X" varchar(25),
"Y" varchar(25),
"OBJTYPE" INTEGER,	
"WEBNMS" varchar(100),
"GROUPNAME" varchar(100),
"PARENTNAME" varchar(100),
"ANCHORED" varchar(10),
PRIMARY KEY ("NAME","MAPNAME","OWNERNAME"),
index MapSymbol0_ndx ("NAME"),
index MapSymbol1_ndx ("MAPNAME"),
index MapSymbol2_ndx ("OWNERNAME"),
index MapSymbol3_ndx ("OBJNAME","OWNERNAME"))
EndCreateSchema

BeginDropSchema
drop table MapSymbol
drop index MapSymbol0_ndx
drop index MapSymbol1_ndx
drop index MapSymbol2_ndx
EndDropSchema

#BeginIndex
#ALTER TABLE MapSymbol add index MapSymbol0_ndx ("NAME")
#EndIndex

#BeginIndex
#ALTER TABLE MapSymbol add index MapSymbol1_ndx ("MAPNAME")
#EndIndex

BeginCreateSchema
create table MapLink( 
"NAME" varchar(100) NOT NULL,
"SOURCE" varchar(100) NOT NULL ,
"DEST" varchar(100) NOT NULL ,
"MAPNAME" varchar(100) NOT NULL,
"OWNERNAME" varchar(25) NOT NULL,
"THICKNESS" INTEGER,
"LINKTYPE" INTEGER,
"LABEL" varchar(100),
"MENUNAME" varchar(100),
"NX" varchar(25),
"NY" varchar(25),
"X" varchar(25),
"Y" varchar(25),
"OBJNAME" varchar(100)  NOT NULL,
"STATUS"  varchar(25),	
"WEBNMS" varchar(100),
"GROUPNAME" varchar(100),
PRIMARY KEY ("NAME","MAPNAME","OWNERNAME"),
index MapLink0_ndx ("NAME"),
index MapLink1_ndx ("MAPNAME"),
index MapLink2_ndx ("OWNERNAME"),
index MapLink3_ndx ("OBJNAME","OWNERNAME"))
EndCreateSchema

BeginDropSchema
drop table MapLink
drop index MapLink0_ndx
drop index MapLink1_ndx
drop index MapLink2_ndx
EndDropSchema

#BeginIndex
#ALTER TABLE MapLink add index MapLink0_ndx ("NAME")
#EndIndex

#BeginIndex
#ALTER TABLE MapLink add index MapLink1_ndx ("MAPNAME")
#EndIndex

BeginCreateSchema
create table MAPUSERPROPS(
"NAME" varchar( 100 ) NOT NULL,
"MAPNAME" varchar(100) NOT NULL,
"OWNERNAME" varchar(25) NOT NULL,
"PROPNAME" varchar( 150 ) NOT NULL,
"PROPVAL" varchar( 150 ),
index MAPUSERPROPS0_ndx ("NAME"),
index MAPUSERPROPS1_ndx ("MAPNAME"),
index MAPUSERPROPS2_ndx ("OWNERNAME"))

EndCreateSchema

BeginDropSchema
drop table MAPUSERPROPS
drop index MAPUSERPROPS0_ndx
drop index MAPUSERPROPS1_ndx
drop index MAPUSERPROPS2_ndx
EndDropSchema

#BeginIndex
#ALTER TABLE MAPUSERPROPS add index MAPUSERPROPS0_ndx ("NAME")
#ALTER TABLE MAPUSERPROPS add index MAPUSERPROPS1_ndx ("MAPNAME")
#ALTER TABLE MAPUSERPROPS add index MAPUSERPROPS2_ndx ("OWNERNAME")
#EndIndex

BeginCreateSchema
create table Event( 
"ID" INTEGER NOT NULL,
"TEXT" varchar(200),
"CATEGORY" varchar(100),
"DDOMAIN" varchar(100),
"NETWORK" varchar(100),
"NODE" varchar(100),
"ENTITY" varchar(100),
"SEVERITY" INTEGER,
"TTIME" BIGINT, 
"SOURCE" varchar(100),
"HELPURL" varchar(100),
"WEBNMS" varchar(100),
"GROUPNAME" varchar(100),
"OWNERNAME" varchar(25) NOT NULL,
PRIMARY KEY ("ID","OWNERNAME"),
index Event0_ndx ("ID"),
index Event1_ndx ("OWNERNAME"))
EndCreateSchema

BeginDropSchema
drop table Event
drop index Event0_ndx
drop index Event1_ndx
EndDropSchema

#BeginIndex
#ALTER TABLE Event add index Event0_ndx ("ID")
#ALTER TABLE Event add index Event1_ndx ("OWNERNAME")
#EndIndex

BeginCreateSchema
create table PolledData( 
"NAME" varchar(50) NOT NULL ,
"ID" BIGINT NOT NULL ,
"AGENT" varchar(50) NOT NULL ,
"COMMUNITY" varchar(100) NOT NULL ,
"PERIOD" INTEGER NOT NULL,
"ACTIVE" varchar(10),
"OID" varchar(200) NOT NULL,
"LOGDIRECTLY" varchar(10),
"LOGFILE" varchar(100),
"SSAVE" varchar(10),
"THRESHOLD" varchar(10),
"ISMULTIPLEPOLLEDDATA" varchar(10),
"PREVIOUSSEVERITY" INTEGER,
"NUMERICTYPE" INTEGER,
"SAVEABSOLUTES" varchar(10),
"TIMEAVG" varchar(10),
"PORT" INTEGER,
"WEBNMS" varchar(100),
"GROUPNAME" varchar(100),
"LASTCOUNTERVALUE" BIGINT ,
"LASTTIMEVALUE" BIGINT ,
"TIMEVAL" BIGINT NOT NULL ,
"POLICYNAME" varchar(100),
"THRESHOLDLIST" varchar(200),
"DNSNAME" varchar(100),
"SUFFIX" varchar(20),
"STATSDATATABLENAME" varchar(100),
"POLLERNAME" varchar(200),
"FAILURECOUNT" INTEGER,
"FAILURETHRESHOLD" INTEGER,
"OWNERNAME" varchar(25) NOT NULL,
"PARENTOBJ" varchar(100),
"PROTOCOL" varchar(50),
"SAVEPOLLCOUNT" INTEGER,
"CURRENTSAVECOUNT" INTEGER,
"SAVEONTHRESHOLD" varchar(10),
"SNMPVERSION" varchar(10),
"USERNAME" varchar(30),
"CONTEXTNAME" varchar(30),
PRIMARY KEY ("NAME","AGENT","OID","OWNERNAME"),
index PolledData0_ndx ( "NAME"),
index PolledData1_ndx ( "AGENT"),
index PolledData2_ndx ( "OID"),
index PolledData3_ndx ( "ID"),
index PolledData4_ndx ( "COMMUNITY"),
index PolledData5_ndx ( "PERIOD"),
index PolledData6_ndx ( "TIMEVAL"),
index PolledData7_ndx ( "OWNERNAME"))
EndCreateSchema

BeginDropSchema
drop table PolledData
drop index PolledData0_ndx
drop index PolledData1_ndx
drop index PolledData2_ndx
drop index PolledData3_ndx
drop index PolledData4_ndx
drop index PolledData5_ndx
drop index PolledData6_ndx
drop index PolledData7_ndx
EndDropSchema

#BeginIndex
#ALTER TABLE PolledData add index PolledData0_ndx ( "NAME")
#EndIndex

#BeginIndex
#ALTER TABLE PolledData add index PolledData1_ndx ( "AGENT")
#EndIndex

#BeginIndex
#ALTER TABLE PolledData add index PolledData2_ndx ( "OID")
#EndIndex

#BeginIndex
#ALTER TABLE PolledData add index PolledData3_ndx ( "ID")
#EndIndex

#BeginIndex
#ALTER TABLE PolledData add index PolledData4_ndx ( "COMMUNITY")
#EndIndex

#BeginIndex
#ALTER TABLE PolledData add index PolledData5_ndx ( "PERIOD")
#EndIndex

#BeginIndex
#ALTER TABLE PolledData add index PolledData6_ndx ( "TIMEVAL")
#EndIndex

#BeginIndex
#ALTER TABLE PolledData add index PolledData7_ndx ( "OWNERNAME")
#EndIndex

BeginCreateSchema
create table  ALERTLOGGER (
"VALUESTRING" varchar( 250 ))
EndCreateSchema

BeginDropSchema
drop table ALERTLOGGER
EndDropSchema

BeginCreateSchema
create table  EVENTLOGGER (
"VALUESTRING" BIGINT NOT NULL,
"POSITION" INTEGER NOT NULL,
index EVENTLOGGER0_ndx ("POSITION"))
EndCreateSchema

BeginDropSchema
drop table EVENTLOGGER
drop index EVENTLOGGER0_ndx
EndDropSchema

#BeginIndex
#ALTER TABLE EVENTLOGGER add index EVENTLOGGER0_ndx ("POSITION")
#EndIndex

BeginCreateSchema
create table  CUSTOMMAPS (
"VALUESTRING" varchar( 250 ))
EndCreateSchema

BeginDropSchema
drop table CUSTOMMAPS
EndDropSchema

BeginCreateSchema
create table  DBINTERFACES (
"VALUESTRING" varchar( 250 ))
EndCreateSchema

BeginDropSchema
drop table DBINTERFACES
EndDropSchema

BeginCreateSchema
create table  DEFAULTMAPS (
"VALUESTRING" varchar( 250 ))
EndCreateSchema

BeginDropSchema
drop table DEFAULTMAPS
EndDropSchema

BeginCreateSchema
create table  TrapDisabledMO (
"Name" VARCHAR(250) NOT NULL,
"Type" varchar( 250 ),
PRIMARY KEY ("Name"))
EndCreateSchema

BeginDropSchema
drop table TrapDisabledMO
EndDropSchema

BeginCreateSchema
create table  CHILDRENSTATUS (
"KEYSTRING" VARCHAR(250) NOT NULL,
"VALUESTRING" varchar( 250 ),
PRIMARY KEY ("KEYSTRING"),
index CHILDRENSTATUS0_ndx ("KEYSTRING"))
EndCreateSchema

BeginDropSchema
drop table CHILDRENSTATUS
drop index CHILDRENSTATUS0_ndx
EndDropSchema

#BeginIndex
#ALTER TABLE CHILDRENSTATUS add index CHILDRENSTATUS0_ndx ("KEYSTRING")
#EndIndex

BeginCreateSchema
create table CUSTOMPROPS (
"KEYSTRING" VARCHAR( 250 ) NOT NULL,
"PROPKEY" varchar( 250 ) ,
"PROPVALUE" varchar ( 250 ),
index CUSTOMPROPS0_ndx ("KEYSTRING") )
EndCreateSchema

#BeginIndex
#ALTER TABLE CUSTOMPROPS add index CUSTOMPROPS0_ndx ("KEYSTRING")
#EndIndex

BeginDropSchema
drop table CUSTOMPROPS
drop index CUSTOMPROPS0_ndx
EndDropSchema

BeginCreateSchema
create table  OBJECTSTOLINK (
"KEYSTRING" VARCHAR(250) NOT NULL,
"VALUESTRING" varchar( 250 ),
index OBJECTSTOLINK0_ndx ("KEYSTRING"))
EndCreateSchema

#BeginIndex
#ALTER TABLE OBJECTSTOLINK add index OBJECTSTOLINK0_ndx ("KEYSTRING")
#EndIndex

BeginDropSchema
drop table OBJECTSTOLINK
drop index OBJECTSTOLINK0_ndx
EndDropSchema


BeginCreateSchema
create table  TOPODBSPECIALKEY (
"KEYSTRING" VARCHAR(250) NOT NULL,
"VALUESTRING" varchar( 250 ),
PRIMARY KEY ("KEYSTRING"),
index TOPODBSPECIALKEY0_ndx ("KEYSTRING"))
EndCreateSchema

BeginDropSchema
drop table TOPODBSPECIALKEY
drop index TOPODBSPECIALKEY0_ndx
EndDropSchema

#BeginIndex
#ALTER TABLE TOPODBSPECIALKEY add index TOPODBSPECIALKEY0_ndx ("KEYSTRING")
#EndIndex

BeginCreateSchema
create table  DBMAP (
"KEYSTRING" VARCHAR(250) NOT NULL,
"VALUESTRING" varchar( 250 ),
PRIMARY KEY ("KEYSTRING"),
index DBMAP0_ndx ("KEYSTRING"))
EndCreateSchema

BeginDropSchema
drop table DBMAP
drop index DBMAP0_ndx
EndDropSchema

#BeginIndex
#ALTER TABLE DBMAP add index DBMAP0_ndx ("KEYSTRING")
#EndIndex

BeginCreateSchema
create table  DBEVENT (
"KEYSTRING" VARCHAR(250) NOT NULL,
"VALUESTRING" varchar( 250 ),
PRIMARY KEY ("KEYSTRING"),
index DBEVENT0_ndx ("KEYSTRING"))
EndCreateSchema

BeginDropSchema
drop table DBEVENT
drop index DBEVENT0_ndx
EndDropSchema

#BeginIndex
#ALTER TABLE DBEVENT add index DBEVENT0_ndx ("KEYSTRING")
#EndIndex

BeginCreateSchema
create table  DBALERT (
"KEYSTRING" VARCHAR(250) NOT NULL,
"VALUESTRING" varchar( 250 ),
PRIMARY KEY ("KEYSTRING"),
index DBALERT0_ndx ("KEYSTRING"))
EndCreateSchema

BeginDropSchema
drop table DBALERT
drop index DBALERT0_ndx
EndDropSchema

#BeginIndex
#ALTER TABLE DBALERT add index DBALERT0_ndx ("KEYSTRING")
#EndIndex

BeginCreateSchema
create table  DBPOLL (
"KEYSTRING" VARCHAR(250) NOT NULL,
"VALUESTRING" varchar( 250 ),
PRIMARY KEY ("KEYSTRING"),
index DBPOLL0_ndx ("KEYSTRING"))
EndCreateSchema

BeginDropSchema
drop table DBPOLL
drop index DBPOLL0_ndx
EndDropSchema

#BeginIndex
#ALTER TABLE DBPOLL add index DBPOLL0_ndx ("KEYSTRING")
#EndIndex

BeginCreateSchema
create table  ObjectSchedulerRUNNABLE (
"VALUESTRING" varchar( 250 ) NOT NULL,
"TIMEVAL" BIGINT NOT NULL,
PRIMARY KEY ("VALUESTRING"),
index ObjectSchedulerRUNNABLE0_ndx ("TIMEVAL"),
index ObjectSchedulerRUNNABLE1_ndx ("VALUESTRING"))
EndCreateSchema

BeginDropSchema
drop table ObjectSchedulerRUNNABLE
drop index ObjectSchedulerRUNNABLE0_ndx
drop index ObjectSchedulerRUNNABLE1_ndx
EndDropSchema

#BeginIndex
#ALTER TABLE ObjectSchedulerRUNNABLE add index ObjectSchedulerRUNNABLE0_ndx ("TIMEVAL")
#EndIndex

#BeginIndex
#ALTER TABLE ObjectSchedulerRUNNABLE add index ObjectSchedulerRUNNABLE1_ndx ("VALUESTRING")
#EndIndex

BeginCreateSchema
create table MapGroup(
"NAME" varchar(100) NOT NULL,
"OBJNAME" varchar(100)  NOT NULL,
"MAPNAME" varchar(100) NOT NULL,
"OWNERNAME" varchar(25) NOT NULL,
"LABEL" varchar(100),
"ICONNAME" varchar(100),
"MENUNAME" varchar(100),
"WIDTH" INTEGER,
"HEIGHT" INTEGER,
"X" INTEGER,
"Y" INTEGER,
"WEBNMS" varchar(100),
"GROUPNAME" varchar(100),
"OBJTYPE" INTEGER,
"ANCHORED" varchar(10),
PRIMARY KEY ("NAME","MAPNAME","OWNERNAME"),
index MapGroup0_ndx ("MAPNAME"),
index MapGroup1_ndx ("NAME"),
index MapGroup2_ndx ("OWNERNAME"),
index MapGroup3_ndx ("OBJNAME","OWNERNAME"))
EndCreateSchema

BeginDropSchema
drop table MapGroup
drop index MapGroup0_ndx
drop index MapGroup1_ndx
drop index MapGroup2_ndx
EndDropSchema

#BeginIndex
#ALTER TABLE MapGroup add index MapGroup0_ndx ("MAPNAME")
#EndIndex

#BeginIndex
#ALTER TABLE MapGroup add index MapGroup1_ndx ("NAME")
#EndIndex

BeginCreateSchema
create table ManagedGroupObject(
"NAME" varchar(100) NOT NULL PRIMARY KEY,
index ManagedGroupObject0_ndx ("NAME"))
EndCreateSchema

BeginDropSchema
drop table ManagedGroupObject
EndDropSchema

#BeginIndex
#ALTER TABLE ManagedGroupObject add index ManagedGroupObject0_ndx ("NAME")
#EndIndex

BeginCreateSchema
create table GroupTable (
"NAME" varchar(100) NOT NULL,
"OWNERNAME" varchar(25) NOT NULL,
"MEMBERNAME" varchar(100) NOT NULL,
"MEMBEROWNERNAME" varchar(25) NOT NULL )
EndCreateSchema

BeginDropSchema
drop table GroupTable
EndDropSchema

BeginCreateSchema
create table TaskAudit (
"EXECUTIONID" INTEGER,
"USERNAME" varchar(50),
"TASKNAME" varchar(50),
"DEVICELIST" text,
"DATASOURCE" varchar(50),
"EXECUTEDTIME" varchar(30))
EndCreateSchema

BeginDropSchema
drop table TaskAudit
EndDropSchema


BeginCreateSchema
create table DeviceAudit (
"ID" INTEGER,
"USERNAME" varchar(50),
"TASKNAME" varchar(50),
"SUBTASKNAME" varchar(50),
"DEVICENAME" varchar(50),
"TIMEOFSTART" varchar(30),
"TIMEOFFINISH" varchar(30),
"STATUS" varchar(15),
"ROLLBACKSTATUS" varchar(15),
"EXECUTIONID" INTEGER,
"DEVICELIST" varchar(50))
EndCreateSchema

BeginDropSchema
drop table DeviceAudit
EndDropSchema

BeginCreateSchema
create table AttributeAudit(
"ID" INTEGER,
"IDENTIFIER" varchar(100),
"TIMEOFFINISH" varchar(30),
"RETRIES" INTEGER,
"STATUS" varchar(200))
EndCreateSchema

BeginDropSchema
drop table AttributeAudit
EndDropSchema

BeginCreateSchema
create table ConfigTasks(
USERNAME varchar(50),
TASKNAME varchar(50),
PROTOCOL varchar(10),
VERSION varchar(10),
SUBTASKS varchar(200),
ROLLBACKNEEDED varchar(5),
ROLLBACKTYPE integer,
ROLLBACKDOCUMENT varchar(50),
MIBSTOBELOADED varchar(100),
DESCRIPTION text,
ISTEMPLATE varchar(5))
EndCreateSchema

BeginDropSchema
drop table ConfigTasks
EndDropSchema

BeginCreateSchema
create table ConfigTaskDetails(
AKEY  integer, 
USERNAME varchar(50),
TASKNAME varchar(50),
TYPE varchar(2),
PARENTKEY integer)
EndCreateSchema

BeginDropSchema
drop table ConfigTaskDetails
EndDropSchema

BeginCreateSchema
create table ConfigAttributes(
AKEY  varchar(120), 
NAME varchar(100),
VALUE varchar(250))
EndCreateSchema

BeginDropSchema
drop table ConfigAttributes
EndDropSchema

BeginCreateSchema
create table PendingTasks(
USERNAME varchar(50), 
TASKNAME varchar(50),
SUBTASKNAME varchar(50),
DEVICENAME varchar(50),
STATUS varchar(20),
PORT varchar(5),
RETRIES INTEGER,
TIMEOUT INTEGER,
AINDEX INTEGER,
EXECUTIONID INTEGER)
EndCreateSchema

BeginDropSchema
drop table PendingTasks
EndDropSchema

BeginCreateSchema
create table PendingDevices(
DKEY varchar(200), 
NAME varchar(200),
VALUE varchar(200))
EndCreateSchema

BeginDropSchema
drop table PendingDevices
EndDropSchema

BeginCreateSchema
create table DeviceList(
USERNAME varchar(50),
PROTOCOL varchar(10),
DEVICELISTNAME VARCHAR(50))
EndCreateSchema

BeginDropSchema
drop table DeviceList
EndDropSchema

BeginCreateSchema
create table DeviceListDetails(
DKEY VARCHAR(200),
DEVICENAME VARCHAR(50),
PORT varchar(5),
RETRIES INTEGER,
TIMEOUT INTEGER,
DEVICESEQUENCE INTEGER)
EndCreateSchema

BeginDropSchema
drop table DeviceListDetails
EndDropSchema


BeginCreateSchema
create table DeviceUserProps(
DKEY varchar(200), 
NAME varchar(200),
VALUE varchar(200))
EndCreateSchema

BeginDropSchema
drop table DeviceUserProps
EndDropSchema

BeginCreateSchema
create table TaskToDeviceListMap(
USERNAME VARCHAR(50),
TASKNAME VARCHAR(50),
DEVICELISTNAMES VARCHAR(200))
EndCreateSchema

BeginDropSchema
drop table TaskToDeviceListMap
EndDropSchema

BeginCreateSchema
create table PollingObjects(
NAME varchar(50) NOT NULL,
STATUS varchar(10),
PRIMARY KEY("NAME"))
EndCreateSchema

BeginCreateSchema
create table ConfigProvider (
PROTOCOL varchar(100) NOT NULL,
CONFIGPROVIDER varchar(100) NOT NULL )
EndCreateSchema

BeginDropSchema
drop table ConfigProvider
EndDropSchema

BeginDropSchema
drop table PollingObjects
EndDropSchema

BeginCreateSchema
create table PollingAttributes(
"NAME" varchar(50),
"TYPE" varchar(10),
"PROPERTY" varchar(20),
"CONDITION" varchar(50),
"VALUE" varchar(100))
EndCreateSchema

BeginDropSchema
drop table PollingAttributes
EndDropSchema

BeginCreateSchema
create table Providers(
"PROVIDERNAME" varchar(15) NOT NULL,
"VALUE" varchar(100),
PRIMARY KEY("PROVIDERNAME"))
EndCreateSchema

BeginDropSchema
drop table Providers
EndDropSchema

BeginCreateSchema
create table StatsTables(
TableName varchar(100) NOT NULL,
CreateSchema varchar(255),
PRIMARY KEY("TableName"))
EndCreateSchema

BeginDropSchema
drop table StatsTables
EndDropSchema


BeginCreateSchema
create table ThresholdObjects(
"NAME" varchar(20) NOT NULL,
"KIND" varchar(15),
"SEVERITY" INTEGER,
"TRIGGERSEVERITY" INTEGER,
"RESETSEVERITY" INTEGER,
"THRESHOLDTYPE" varchar(5),
"CATEGORY" varchar(20),
"THRESHOLDVALUE" BIGINT,
"REARMVALUE" BIGINT,
"MMESSAGE" varchar(100),
"CLEARMESSAGE" varchar(100),
"SENDCLEAR" varchar(10),
"ALLOWED" varchar(50),
"DISALLOWED" varchar(50),
"OID" varchar(50),
"OIDTYPE" varchar(10),
PRIMARY KEY("NAME"))
EndCreateSchema

BeginDropSchema
drop table ThresholdObjects
EndDropSchema

BeginCreateSchema
create table CustomView(
"MODULE" varchar(25) NOT NULL,
"VIEWID" varchar(50) NOT NULL,
"USERNAME" varchar(50) NOT NULL,
"VIEWNAME" varchar(100) NOT NULL,
"PARENT" varchar(50) NOT NULL,
"CONSTRAIN" varchar(200),
"SQLSTRING" text,
PRIMARY KEY ("VIEWID","USERNAME" ),
index CustomView0_ndx ("MODULE","USERNAME","VIEWNAME","PARENT"),
index CustomView1_ndx ("VIEWID","USERNAME" ))
EndCreateSchema

#BeginIndex
#ALTER TABLE CustomView add index CustomView0_ndx ("MODULE","USERNAME","VIEWNAME","PARENT")
#ALTER TABLE CustomView add index CustomView1_ndx ("VIEWID","USERNAME")
#EndIndex

BeginDropConfigSchema
drop table CustomView
drop index CustomView0_ndx
drop index CustomView1_ndx
EndDropConfigSchema

BeginCreateSchema
create table CustomViewProps(
"MODULE" varchar(25) NOT NULL,
"VIEWID" varchar(50) NOT NULL,
"USERNAME" varchar(50) NOT NULL,
"CRITERIAID" INTEGER NOT NULL,
"PROPKEY" varchar(100),
"OPERATOR" varchar(15),
"PROPVALUE1" varchar(100),
"PROPVALUE2" varchar(100),
PRIMARY KEY ("VIEWID","USERNAME","CRITERIAID"),
index CustomViewProps0_ndx ("VIEWID","USERNAME" ))
EndCreateSchema

#BeginIndex
#ALTER TABLE CustomViewProps add index CustomViewProps0_ndx ("VIEWID","USERNAME")
#EndIndex

BeginDropConfigSchema
drop table CustomViewProps
drop index CustomViewProps0_ndx
EndDropConfigSchema

BeginCreateSchema
create table CustomViewColumns(
"MODULE" varchar(25) NOT NULL,
"VIEWID" varchar(50) NOT NULL,
"USERNAME" varchar(50) NOT NULL,
"DISPLAYNAME" varchar(50),
"COLUMNNAME" varchar(50) NOT NULL,
"WIDTH" INTEGER,
"COLUMNINDEX" INTEGER,
PRIMARY KEY ("VIEWID","USERNAME","COLUMNNAME"),
index CustomViewColumns0_ndx ("VIEWID","USERNAME" ))
EndCreateSchema

#BeginIndex
#ALTER TABLE CustomViewColumns add index CustomViewColumns0_ndx ("VIEWID", "USERNAME")
#EndIndex

BeginDropConfigSchema
drop table CustomViewColumns
drop index CustomViewColumns0_ndx
EndDropConfigSchema

BeginCreateSchema
create table PanelTree (
"NODEID" VARCHAR(100) NOT NULL,
"NODETYPE" VARCHAR(100) NOT NULL,
"USERNAME" VARCHAR(50) NOT NULL,
"PARENT" VARCHAR(100),
"PREVIOUSNODE" VARCHAR(100), 
"MODULENAME" varchar(30),
PRIMARY KEY ("NODEID","USERNAME"))
EndCreateSchema

BeginDropConfigSchema
drop table PanelTree 
EndDropConfigSchema

BeginCreateSchema
create table PanelProps (
"NODEID" VARCHAR(100) NOT NULL,
"USERNAME" VARCHAR(50) NOT NULL,
"ATTRIBNAME" VARCHAR(30) NOT NULL,
"ATTRIBVALUE" VARCHAR(100),
PRIMARY KEY ("NODEID","USERNAME","ATTRIBNAME"))
EndCreateSchema

BeginDropConfigSchema
drop table PanelProps
EndDropConfigSchema

BeginCreateSchema
create table PollFilters(
CLASSNAME varchar(100) NOT NULL,
PRIMARY KEY("CLASSNAME"))
EndCreateSchema

BeginDropSchema
drop table PollFilters
EndDropSchema

BeginCreateSchema
create table GenericFaultTable ( 
"TYPE" varchar(100) NOT NULL,
"NAME" varchar(100) NOT NULL,
PRIMARY KEY ("TYPE","NAME"))
EndCreateSchema

BeginDropSchema
drop table GenericFaultTable
EndDropSchema

BeginCreateSchema
create table TrapFilter ( 
"NAME" varchar(100),
"ENTERPRISEOID" varchar(100),
"GT" varchar(10),
"ST" varchar(10),
"TRAPOID" varchar(100),
"CLASSNAME" varchar(100),
"STATE" varchar(50))
EndCreateSchema

BeginDropSchema
drop table TrapFilter
EndDropSchema

BeginCreateSchema
create table TrapEventParser ( 
"TYPE" varchar(100) NOT NULL,
"NAME" varchar(100) NOT NULL,
"PROPKEY" varchar(100),
"PROPVALUE" blob)
EndCreateSchema

BeginDropSchema
drop table TrapEventParser
EndDropSchema

BeginCreateSchema
create table EventAlertFilter ( 
"TYPE" varchar(100) NOT NULL,
"FILTERNAME" varchar(100) NOT NULL,
"ACTIONNAME" varchar(100),
"PROPKEY" varchar(100),
"PROPVALUE" blob)
EndCreateSchema

BeginDropSchema
drop table EventAlertFilter
EndDropSchema

BeginCreateSchema
create table Reports(
"CLASSNAME" varchar(100) NOT NULL,
"DAILY" varchar(10),
"WEEKLY" varchar(10),
"HOUR" varchar(100),
"MONTHDAYS" varchar(50),
"WEEKDAYS" varchar(50),
"TIMEVAL" BIGINT,
PRIMARY KEY("CLASSNAME"))
EndCreateSchema

BeginDropSchema
drop table Reports
EndDropSchema

BeginCreateSchema
create table DataCollectionAttributes(
"NAME" varchar(50),
"PROPKEY" varchar(50),
"PROPNAME" varchar(30),
"PROPVAL" varchar(200))
EndCreateSchema

BeginDropSchema
drop table DataCollectionAttributes
EndDropSchema

BeginCreateSchema
create table UserPasswordTable(
"USERNAME" varchar(50) NOT NULL,
"PASSWORD" varchar(50),
"OWNERNAME" varchar(50) NOT NULL,
PRIMARY KEY ("USERNAME","OWNERNAME"),
index UserPasswordTable0_ndx ("USERNAME"))
EndCreateSchema

BeginDropSchema
drop table UserPasswordTable
drop index UserPasswordTable0_ndx
EndDropSchema

BeginCreateSchema
create table UserGroupTable(
"USERNAME" varchar(50) NOT NULL,
"GROUPNAME" varchar(100) NOT NULL,
"OWNERNAME" varchar(50) NOT NULL,
PRIMARY KEY ("USERNAME","GROUPNAME","OWNERNAME"),
index UserGroupTable0_ndx ("USERNAME","GROUPNAME" ),
index UserGroupTable1_ndx ("USERNAME"),
index UserGroupTable2_ndx ("GROUPNAME"))
EndCreateSchema

BeginDropSchema
drop table UserGroupTable
drop index UserGroupTable0_ndx
drop index UserGroupTable1_ndx
drop index UserGroupTable2_ndx
EndDropSchema

BeginCreateSchema
create table ViewPropertiesTable(
"VIEWNAME" varchar(150) NOT NULL,
"PROPERTYNAME" varchar(50) NOT NULL,
"PROPERTYVALUE" varchar(50),
PRIMARY KEY ("VIEWNAME","PROPERTYNAME"),
index ViewPropertiesTable0_ndx ("VIEWNAME"))
EndCreateSchema

BeginDropSchema
drop table ViewPropertiesTable
drop index ViewPropertiesTable0_ndx
EndDropSchema

BeginCreateSchema
create table ViewsToGroupTable(
"VIEWNAME" varchar(150) NOT NULL,
"GROUPNAME" varchar(100) NOT NULL,
"OWNERNAME" varchar(50) NOT NULL,
PRIMARY KEY ("VIEWNAME","GROUPNAME","OWNERNAME"),
index ViewsToGroupTable0_ndx ("VIEWNAME","GROUPNAME"),
index ViewsToGroupTable1_ndx ("GROUPNAME"))
EndCreateSchema

BeginDropSchema
drop table ViewsToGroupTable
drop index ViewsToGroupTable0_ndx
drop index ViewsToGroupTable1_ndx
EndDropSchema

BeginCreateSchema
create table ViewToOperationsTable(
"VIEWNAME" varchar(50) NOT NULL,
"OPERATIONSNAME" varchar(50) NOT NULL,
"OPERATIONSTYPE" INTEGER,
PRIMARY KEY ("VIEWNAME","OPERATIONSNAME"))
EndCreateSchema

BeginDropSchema
drop table ViewToOperationsTable
EndDropSchema

BeginCreateSchema
create table OperationsTreeTable(
"PARENTOPERATION" varchar(50) NOT NULL,
"CHILDOPERATION" varchar(50) NOT NULL,
"LEAFNODE" INTEGER,
PRIMARY KEY ("PARENTOPERATION","CHILDOPERATION"),
index OperationsTreeTable0_ndx ("PARENTOPERATION"),
index OperationsTreeTable1_ndx ("CHILDOPERATION"))
EndCreateSchema

BeginDropSchema
drop table OperationsTreeTable
drop index OperationsTreeTable0_ndx
drop index OperationsTreeTable1_ndx
EndDropSchema

BeginCreateSchema
create table NamedViewToAuthorizedViewTable(
"NAMEDVIEWNAME" varchar(50) NOT NULL,
"AUTHORIZEDVIEWNAME" varchar(150) NOT NULL)
EndCreateSchema

BeginDropSchema
drop table NamedViewToAuthorizedViewTable
EndDropSchema
        
BeginCreateSchema
create table AuthAudit(
"USERNAME" varchar(30) NOT NULL,
"OPERATION" varchar(100) NOT NULL,
"AUDITTIME" varchar(30) NOT NULL,
"STATUS" varchar(10) NOT NULL)
EndCreateSchema

BeginDropSchema
drop table AuthAudit
EndDropSchema

#by senthil
BeginCreateSchema
create table NotificationLog(
"NOTIINDEX" INTEGER NOT NULL,
"LOGTIME" BIGINT,
"NOVARBINDS" INTEGER,
"NOTIOID" varchar(100),
PRIMARY KEY ("NOTIINDEX"),
index NotificationLog0_ndx ("NOTIINDEX"))
EndCreateSchema

BeginDropSchema
drop table NotificationLog
drop index NotificationLog0_ndx
EndDropSchema

#BeginIndex
#ALTER TABLE NotificationLog add index NotificationLog0_ndx ("NOTIINDEX")
#EndIndex

BeginCreateSchema
create table VarBindLog(
"NOTIINDEX" INTEGER NOT NULL,
"VARINDEX" INTEGER NOT NULL,
"VARTYPE" INTEGER,
"VARVALUE" VARCHAR(200),
PRIMARY KEY ("NOTIINDEX","VARINDEX"),
index VarBindLog0_ndx ("NOTIINDEX"),
index VarBindLog1_ndx ("VARINDEX"))
EndCreateSchema

BeginDropSchema
drop table VarBindLog
drop index VarBindLog0_ndx
drop index VarBindLog1_ndx
EndDropSchema

#BeginIndex
#ALTER TABLE VarBindLog add index VarBindLog0_ndx ("NOTIINDEX")
#ALTER TABLE VarBindLog add index VarBindLog1_ndx ("VARINDEX")
#EndIndex

BeginCreateSchema
create table AgentDefValObject (
"NAME" VARCHAR (100) NOT NULL ,
"VALUE" VARCHAR (100) ,
PRIMARY KEY ("NAME"),
index AgentDefValObject0_ndx ("NAME"))
EndCreateSchema

BeginDropSchema
drop table AgentDefValObject
EndDropSchema

#BeginIndex
#CREATE INDEX AgentDefValObject0_ndx ON AgentDefValObject ("NAME")
#EndIndex 

BeginCreateSchema
create table PolicyObject(
"NAME" varchar(100) NOT NULL,
"GROUPNAME" varchar(100),
"STATUS" INTEGER,
"PERIOD" INTEGER,
"POLICYOBJECTCUSTOMIZER" varchar(50),
"HELPURL" varchar(100),
 PRIMARY KEY("NAME"),
index PolicyObject0_ndx ("NAME"))
EndCreateSchema

BeginDropSchema
drop table PolicyObject
EndDropSchema

#BeginIndex
#ALTER TABLE PolicyObject add index PolicyObject0_ndx ("NAME")
#EndIndex

BeginCreateSchema
create table PolicyActionCondition(
"NAME" varchar(100) NOT NULL,
"OBJKEY" varchar(100) NOT NULL,
"POLICYACTION" varchar(100),
"POLICYCONDITION" varchar(100),
PRIMARY KEY("NAME" , "OBJKEY"),
index PolicyActionCondition0_ndx ("NAME"))
EndCreateSchema

BeginDropSchema
drop table PolicyActionCondition
EndDropSchema

#BeginIndex
#ALTER TABLE PolicyActionCondition add index PolicyActionCondition0_ndx ("NAME")
#EndIndex

BeginCreateSchema
create table POLICYUSERPROPS(
"NAME" varchar( 100 ) NOT NULL, 
"OWNERNAME" varchar(25) NOT NULL,
"PROPNAME" varchar( 150 ) NOT NULL,
"PROPVAL" varchar( 150 ),
index POLICYUSERPROPS0_ndx ("NAME"),
index POLICYUSERPROPS1_ndx ("OWNERNAME"))
EndCreateSchema

BeginDropSchema
drop table POLICYUSERPROPS
drop index POLICYUSERPROPS0_ndx
drop index POLICYUSERPROPS1_ndx
EndDropSchema

#BeginIndex
#ALTER TABLE POLICYUSERPROPS add index POLICYUSERPROPS0_ndx ("NAME")
#ALTER TABLE POLICYUSERPROPS add index POLICYUSERPROPS1_ndx ("OWNERNAME")
#EndIndex

BeginCreateSchema
create table  DBPOLICY (
"KEYSTRING" VARCHAR(250) NOT NULL,
"VALUESTRING" varchar( 250 ),
PRIMARY KEY ("KEYSTRING"),
index dbpolicy0_ndx ("KEYSTRING"))
EndCreateSchema

BeginDropSchema
drop table DBPOLICY
drop index dbpolicy0_ndx
EndDropSchema

#BeginIndex
#ALTER TABLE DBPOLICY add index dbpolicy0_ndx ("KEYSTRING")
#EndIndex

BeginCreateSchema
create table  PolicyScheduleTime (
"TIMEKEY" varchar( 250 ) NOT NULL,
"NAME" VARCHAR(250) NOT NULL )
EndCreateSchema

BeginDropSchema
drop table PolicyScheduleTime
EndDropSchema

BeginCreateSchema
create table AlertPolicyObject ( 
"NAME" varchar(80) NOT NULL,
"ACTIONNAME" varchar(80) NOT NULL,
"PROPKEY" varchar(80) NOT NULL,
"PROPVALUE" varchar(100),
PRIMARY KEY("NAME" , "ACTIONNAME" , "PROPKEY") )
EndCreateSchema

BeginDropSchema
drop table AlertPolicyObject
EndDropSchema

BeginCreateSchema
create table ENGINETABLE( 
"DBKEY" varchar(57) NOT NULL,
"HOST" varchar(50),
"PORT" varchar(5),
"ENGINENAME" varchar(50),
"ENGINEID" varchar(64),
"ENGINETIME" varchar(10),
"ENGINEBOOTS" varchar(10),
PRIMARY KEY ("DBKEY"))
EndCreateSchema

BeginDropSchema
drop table ENGINETABLE
EndDropSchema

BeginCreateSchema
create table USMTABLE( 
"DBKEY" varchar(116) NOT NULL,
"HOST" varchar(50),
"PORT" varchar(5), 
"ENGINENAME" varchar(50),
"ENGINEID" varchar(64), 
"USERNAME" varchar(50), 
"SECURITYLEVEL" varchar(5),
"SECURITYNAME" varchar(50), 
"AUTHPROTOCOL" varchar(10), 
"AUTHPASSWORD" varchar(255),
"AUTHKEY" varchar(255),
"PRIVPROTOCOL" varchar(10), 
"PRIVPASSWORD" varchar(255),
"PRIVKEY" varchar(255),
"ENGINETIME" varchar(10), 
"ENGINEBOOTS" varchar(10),
"LATESTRCVDENGTIME" varchar(10),
"LOCALTIME" varchar(30),
PRIMARY KEY ("DBKEY"))
EndCreateSchema

BeginDropSchema
drop table USMTABLE
EndDropSchema

BeginCreateSchema
create table SwitchObject ( 
"NAME" VARCHAR (100) NOT NULL , 
"OWNERNAME" VARCHAR (25) NOT NULL , 
"ROOTPORT" INTEGER , 
"ROOTCOST" INTEGER , 
"NUMPORTS" INTEGER , 
PRIMARY KEY ("NAME","OWNERNAME"),
index SwitchObject0_ndx  ("NAME"),
index SwitchObject1_ndx  ("OWNERNAME"))
EndCreateSchema

BeginDropSchema
drop table SwitchObject  
drop index SwitchObject0_ndx
drop index SwitchObject1_ndx
EndDropSchema

#BeginIndex
#ALTER TABLE SwitchObject add index SwitchObject0_ndx  ("NAME") 
#ALTER TABLE SwitchObject add index SwitchObject1_ndx  ("OWNERNAME") 
#EndIndex

BeginCreateSchema
create table PortObject ( 
"NAME" VARCHAR (100) NOT NULL , 
"OWNERNAME" VARCHAR (25) NOT NULL , 
"PORTIFINDEX" INTEGER , 
"PORTIFDESCR" VARCHAR (100) , 
"PORTSTATE" VARCHAR (100) , 
"PORTIFSPEED" INTEGER , 
PRIMARY KEY ("NAME","OWNERNAME"),
index PortObject0_ndx  ("NAME"), 
index PortObject1_ndx  ("OWNERNAME"))
EndCreateSchema

BeginDropSchema
drop table PortObject  
drop index PortObject0_ndx
drop index PortObject1_ndx
EndDropSchema

#BeginIndex
#ALTER TABLE PortObject add index PortObject0_ndx  ("NAME") 
#ALTER TABLE PortObject add index PortObject1_ndx  ("OWNERNAME")
#EndIndex

BeginCreateSchema
create table Printer (
"NAME" VARCHAR (100) NOT NULL ,
"OWNERNAME" VARCHAR (25) NOT NULL , 
"DEVICESTATUS" INTEGER ,
"PRINTERSTATUS" INTEGER ,
"PRINTERDETECTEDERRSTATUS" INTEGER ,
"CONSOLEDISPBUFFERTEXT" VARCHAR (100) ,
PRIMARY KEY ("NAME"),
index Printer0_ndx  ("NAME"),
index Printer1_ndx  ("OWNERNAME"))
EndCreateSchema

BeginDropSchema
drop table Printer
EndDropSchema

#BeginIndex
#ALTER TABLE Printer add index Printer0_ndx  ("NAME")
#ALTER TABLE Printer add index Printer1_ndx  ("OWNERNAME")
#EndIndex

BeginDropConfigSchema
drop table ENGINES
EndDropConfigSchema

BeginDropConfigSchema
drop table HOSTS
EndDropConfigSchema

BeginDropConfigSchema
drop table PORTS
EndDropConfigSchema

BeginDropConfigSchema
drop table USERS
EndDropConfigSchema

BeginDropConfigSchema
drop table USERTABLE
EndDropConfigSchema



BeginCreateSchema
create table  OperationsTable ("USERNAME" VARCHAR(50) NOT NULL,
"OPERATIONID" BIGINT NOT NULL,
"TEMPLATENAME" VARCHAR(50),
"SCHEDULEDTIME" VARCHAR(50),
"STAGE" VARCHAR(50),
"STATUS" VARCHAR(50),
PRIMARY KEY ("USERNAME",
"OPERATIONID"))
EndCreateSchema

BeginDropSchema
drop table OperationsTable
EndDropSchema


BeginCreateSchema
create table BEFailOver (
"HOSTADDRESS" VARCHAR(50) NOT NULL,
"NMSBEPORT" INTEGER NOT NULL,
"RMIREGISTRYPORT" INTEGER,
"LASTCOUNT" BIGINT,
"SERVERROLE" VARCHAR(10),
"STANDBYSERVERNAME" VARCHAR(50),
index BEFailOver0_ndx ("HOSTADDRESS"),
index BEFailOver1_ndx ("NMSBEPORT"))
EndCreateSchema

BeginDropSchema
drop table BEFailOver
EndDropSchema


BeginCreateSchema
create table PollIDToKeyMap(
"NAME" VARCHAR(50),
"ID" BIGINT,
"AGENT" VARCHAR(50),
"OID" VARCHAR(200),
"STATSDATATABLENAME" VARCHAR(100),
"OWNERNAME" VARCHAR(25))
EndCreateSchema

BeginDropSchema
drop table PollIDToKeyMap
EndDropSchema


BeginCreateSchema
create table ProvisioningVariantProps (
"VARIANTID"  varchar(50)  NOT NULL,
"PROPNAME"  varchar(50),
"PROPVAL"  varchar(50))
EndCreateSchema

BeginDropSchema
drop table ProvisioningVariantProps
EndDropSchema


BeginCreateSchema
create table ProvisioningVariant (
"DESCRIPTION"  varchar(50),
"VARIANTID"  varchar(50)  NOT NULL,
PRIMARY KEY ("VARIANTID"),
index ProvisioningVariant0_ndx ("VARIANTID"))
EndCreateSchema

BeginDropSchema
drop table ProvisioningVariant
EndDropSchema


BeginCreateSchema
create table UserConfTable(
"USERNAME" varchar(50) NOT NULL,
"OWNERNAME" varchar(50) NOT NULL,
"STATUS" varchar(20) NOT NULL,
"PASSWORDEXPIRYTIME" BIGINT,
"USEREXPIRYTIME" BIGINT,
"PASSWORDAGE" INTEGER,
"USERAGE" INTEGER,
PRIMARY KEY ("USERNAME",
"OWNERNAME"),
index UserConfTable0_ndx("STATUS"))
EndCreateSchema

BeginDropSchema
drop table UserConfTable
EndDropSchema


BeginCreateSchema
create table CORBANode(
"NAME" varchar(100) NOT NULL,
"OWNERNAME" varchar(100) NOT NULL,
"ORBCLASSNAME" varchar(100),
"NAMESERVICEHOST" varchar(100) NOT NULL,
"NAMESERVICEPORT" INTEGER,
"NAMEREF" VARCHAR(100),
"INTERFACENAME" VARCHAR(100),
"DICTIONARY" VARCHAR(100),
"STATUSPOLLCOMMAND" VARCHAR(100),
"STATUSPOLLIOR" BLOB,
"DATAPOLLIOR" BLOB,
PRIMARY KEY ("NAME",
"OWNERNAME" ),
index CORBANode0_ndx("NAME"),
index CORBANode1_ndx ("OWNERNAME"))
EndCreateSchema

BeginDropSchema
drop table CORBANode
EndDropSchema


BeginCreateSchema
create table NetworkInventory (
"LASTMODIFIEDTIME" varchar(25),
"MODEL"  varchar(50),
"TYPE"  varchar(50),
"CONTACT"  varchar(50),
"CLASSNAME"  varchar(50),
"MANAGEDOBJECTNAME"  varchar(50),
"OPERATIONALSTATUS"  varchar(50),
"NAME"  varchar(50)  NOT NULL,
"LOCATION"  varchar(50),
"ADMINSTATUS"  varchar(50),
"VENDOR"  varchar(50),
"DESCRIPTION"  varchar(50),
PRIMARY KEY ("NAME"),
index NetworkInventory0_ndx ("NAME"))
EndCreateSchema

BeginDropSchema
drop table NetworkInventory
EndDropSchema


BeginCreateSchema
create table REPORTS_DAILY(
   "POLLID" BIGINT,
"INSTANCE" varchar(100),
"TTIME" BIGINT,
"VAL" BIGINT,
"MINVALUE" BIGINT,
"MAXVALUE" BIGINT,
"TINTERVAL"  BIGINT,
index REPORTS_DAILY0_ndx("POLLID"),
index REPORTS_DAILY2_ndx("TTIME"))
EndCreateSchema

BeginDropSchema
drop table REPORTS_DAILY
EndDropSchema


BeginCreateSchema
create table REPORTS_HOURLY(
   "POLLID" BIGINT,
"INSTANCE" varchar(100),
"TTIME" BIGINT,
"VAL" BIGINT,
"MINVALUE" BIGINT,
"MAXVALUE" BIGINT,
"TINTERVAL"  BIGINT,
index REPORTS_HOURLY0_ndx("POLLID"),
index REPORTS_HOURLY2_ndx("TTIME"))
EndCreateSchema

BeginDropSchema
drop table REPORTS_HOURLY
EndDropSchema


BeginCreateSchema
create table AuthAuditExt(
                 "AUTHAUDITID" INTEGER,
"USERNAME" varchar(30),
"OPERATION" varchar(100),
"AUDITTIME" varchar(30),
"STATUS" varchar(10),
"CATEGORY" varchar(25),
"AUDITEDOBJ"  varchar(100),
index AuthAuditExt0_ndx("AUTHAUDITID"))
EndCreateSchema

BeginDropSchema
drop table AuthAuditExt
EndDropSchema

BeginCreateSchema
create table IPDSLAMDevice ( 
"NAME"  VARCHAR(50)  NOT NULL , 
"OWNERNAME"  VARCHAR(50)  NOT NULL , 
"DEVICETYPE"  INTEGER , 
PRIMARY KEY ("NAME", "OWNERNAME"))
EndCreateSchema

BeginDropSchema
drop table IPDSLAMDevice
EndDropSchema

BeginCreateSchema
create table DslamAlarm ( 
"ALARMSEVERITY"  INTEGER , 
"PORTINDEX"  INTEGER , 
"PLANNEDVENDERTYPE"  INTEGER , 
"ALARMLIST"  BIGINT , 
"ONLINEVENDERTYPE"  INTEGER , 
"SHELFINDEX"  INTEGER , 
"PHYSICALINDEX"  INTEGER , 
"ALARMLASTCHANGE"  BIGINT , 
"SLOTINDEX"  INTEGER , 
"NAME"  VARCHAR(50)  NOT NULL , 
"OWNERNAME"  VARCHAR(50)  NOT NULL , 
PRIMARY KEY ("NAME", "OWNERNAME"))
EndCreateSchema


BeginDropSchema
drop table DslamAlarm
EndDropSchema

BeginCreateSchema
create table MapLocation ( 
"NAME"  VARCHAR(50)  NOT NULL , 
"OWNERNAME"  VARCHAR(50)  NOT NULL , 
"FULLLOCATIONNAME"  VARCHAR(255), 
"CONTACTPERSONTELEPHONE"  VARCHAR(50), 
"CONTACTPERSONNAME"  VARCHAR(50), 
"CONTACTPERSONEMAIL"  VARCHAR(50), 
"COMMENT"  VARCHAR(50), 
"CONTACTPERSONMOBILE"  VARCHAR(50), 
PRIMARY KEY ("NAME", "OWNERNAME"))
EndCreateSchema


BeginDropSchema
drop table MapLocation
EndDropSchema

BeginIndex
CREATE INDEX MapLocation0_ndx ON MapLocation ("NAME") 
EndIndex 



BeginIndex
CREATE INDEX MapLocation1_ndx ON MapLocation ("OWNERNAME") 
EndIndex

BeginCreateSchema
create table MiniDslamLinePort ( 
"NAME"  VARCHAR(100)  NOT NULL , 
"OWNERNAME"  VARCHAR(25)  NOT NULL , 
PRIMARY KEY ("NAME", "OWNERNAME"))
EndCreateSchema

BeginDropSchema
drop table MiniDslamLinePort
EndDropSchema

BeginCreateSchema
create table MiniDslamEthernetPort ( 
"NAME"  VARCHAR(100)  NOT NULL , 
"OWNERNAME"  VARCHAR(25)  NOT NULL , 
PRIMARY KEY ("NAME", "OWNERNAME"))
EndCreateSchema

BeginDropSchema
drop table MiniDslamEthernetPort
EndDropSchema



BeginCreateSchema
create table NEBackup ( 
"BKNENAME"  VARCHAR(50)  NOT NULL , 
"FILENAME"  VARCHAR(50)  NOT NULL , 
"MODULENAME"  VARCHAR(50)  NOT NULL , 
"BACKUPTIME"  BIGINT   NOT NULL , 
"PARAMETERS"  BLOB, 
"DESCRIPTION"  VARCHAR(50), 
PRIMARY KEY ("BKNENAME", "FILENAME", "MODULENAME", "BACKUPTIME"))
EndCreateSchema


BeginDropSchema
drop table NEBackup
EndDropSchema

BeginIndex
CREATE INDEX NEBackup0_ndx ON NEBackup ("BKNENAME") 
EndIndex 



BeginIndex
CREATE INDEX NEBackup1_ndx ON NEBackup ("FILENAME") 
EndIndex 



BeginIndex
CREATE INDEX NEBackup2_ndx ON NEBackup ("MODULENAME") 
EndIndex 



BeginIndex
CREATE INDEX NEBackup3_ndx ON NEBackup ("BACKUPTIME") 
EndIndex

BeginCreateSchema
create table AlarmDefinition ( 
"NAME"  VARCHAR(50)  NOT NULL , 
"VENDERTYPE"  INTEGER   NOT NULL , 
"ALARMTYPE"  INTEGER   NOT NULL , 
"ALARMNAME"  VARCHAR(50), 
"ALARMDESCRIPTION"  TEXT, 
"ALARMSEVERITY"  INTEGER , 
"ALARMFILTERED"  INTEGER , 
"ALARMSUPPRESSEDBY"  BIGINT , 
PRIMARY KEY ("NAME", "VENDERTYPE", "ALARMTYPE"))
EndCreateSchema


BeginDropSchema
drop table AlarmDefinition
EndDropSchema

BeginIndex
CREATE INDEX AlarmDefinition0_ndx ON AlarmDefinition ("NAME") 
EndIndex 



BeginIndex
CREATE INDEX AlarmDefinition1_ndx ON AlarmDefinition ("VENDERTYPE") 
EndIndex 



BeginIndex
CREATE INDEX AlarmDefinition2_ndx ON AlarmDefinition ("ALARMTYPE") 
EndIndex

BeginCreateSchema
create table IPTrafficProfileTemplate ( 
"PROFILENAME"  VARCHAR(50)  NOT NULL , 
"PROFILEDSBCASTFILTER"  INTEGER , 
"PROFILEUSRATELIMIT"  INTEGER , 
"PROFILEDSPRIORITY"  INTEGER , 
"PROFILEMAXDSRATE"  INTEGER , 
PRIMARY KEY ("PROFILENAME"))
EndCreateSchema


BeginDropSchema
drop table IPTrafficProfileTemplate
EndDropSchema

BeginIndex
CREATE INDEX IPTrafficProfileTemplate0_ndx ON IPTrafficProfileTemplate ("PROFILENAME") 
EndIndex

BeginCreateSchema
create table LineProfileTemplate ( 
"ATUCCONFRATECHANRATIO"  INTEGER , 
"ATURCONFMINUPSHIFTTIME"  INTEGER , 
"ATURCONFUPSHIFTSNRMGN"  INTEGER , 
"ATURCHANCONFMAXINTERLEAVEDELAY"  INTEGER , 
"ATUCCONFMINUPSHIFTTIME"  INTEGER , 
"CPEL3STATE"  INTEGER , 
"ATURCHANCONFINTERLEAVEMINTXRATE"  INTEGER , 
"ATUCCONFRATEMODE"  INTEGER , 
"ATURCONFTARGETSNRMGN"  INTEGER , 
"ATUCCONFDOWNSHIFTSNRMGN"  INTEGER , 
"ATURCHANCONFINTERLEAVEMAXTXRATE"  INTEGER , 
"ATURCONFDOWNSHIFTSNRMGN"  INTEGER , 
"ATURCONFMINDOWNSHIFTTIME"  INTEGER , 
"ATURCONFMAXNOMINALPSD"  INTEGER , 
"ATURMININP"  INTEGER , 
"ATUCCHANCONFFASTMINTXRATE"  INTEGER , 
"PROFILENAME"  VARCHAR(50)  NOT NULL , 
"ATURCONFRATEMODE"  INTEGER , 
"ATURCHANCONFFASTMAXTXRATE"  INTEGER , 
"ATURCHANCONFFASTMINTXRATE"  INTEGER , 
"ATUCCONFUPSHIFTSNRMGN"  INTEGER , 
"ATUCCONFTARGETSNRMGN"  INTEGER , 
"ATUCCHANCONFFASTMAXTXRATE"  INTEGER , 
"ATUCCHANCONFINTERLEAVEMINTXRATE"  INTEGER , 
"POWERL2TIME"  INTEGER , 
"ATURCONFMAXSNRMGN"  INTEGER , 
"ATURCONFMINSNRMGN"  INTEGER , 
"ATUCCHANCONFINTERLEAVEMAXTXRATE"  INTEGER , 
"ATUCCONFMINSNRMGN"  INTEGER , 
"ATUCCONFMAXNOMINALPSD"  INTEGER , 
"POWERL2MAXRATE"  INTEGER , 
"ATUCCONFMAXSNRMGN"  INTEGER , 
"ATUCCHANCONFMAXINTERLEAVEDELAY"  INTEGER , 
"CONFPROFILELINETYPE"  INTEGER , 
"POWERMODE"  INTEGER , 
"ATURCONFRATECHANRATIO"  INTEGER , 
"POWERL0TIME"  INTEGER , 
"ATUCCONFMINDOWNSHIFTTIME"  INTEGER , 
"ATUCMININP"  INTEGER , 
"POWERL2MINRATE"  INTEGER , 
PRIMARY KEY ("PROFILENAME"))
EndCreateSchema


BeginDropSchema
drop table LineProfileTemplate
EndDropSchema

BeginIndex
CREATE INDEX LineProfileTemplate0_ndx ON LineProfileTemplate ("PROFILENAME") 
EndIndex

BeginCreateSchema
create table TrafficPolicingProfileTemplate ( 
"PROFILENAME"  VARCHAR(50)  NOT NULL , 
"PIR"  INTEGER , 
"CIR"  INTEGER , 
"ACTION"  INTEGER , 
PRIMARY KEY ("PROFILENAME"))
EndCreateSchema


BeginDropSchema
drop table TrafficPolicingProfileTemplate
EndDropSchema

BeginIndex
CREATE INDEX TrafficPolicingProfileTemplate0_ndx ON TrafficPolicingProfileTemplate ("PROFILENAME") 
EndIndex

BeginCreateSchema
create table MulticastProfileTemplate ( 
"PROFILEID"  INTEGER   NOT NULL , 
"PROFILENAME"  VARCHAR(32), 
"PROFILEIPADDRESS"  VARCHAR(15), 
"PROFILERATE"  INTEGER , 
"PROFILEPRIORITY"  INTEGER , 
PRIMARY KEY ("PROFILEID"))
EndCreateSchema


BeginDropSchema
drop table MulticastProfileTemplate
EndDropSchema

BeginIndex
CREATE INDEX MulticastProfileTemplate0_ndx ON MulticastProfileTemplate ("PROFILEID") 
EndIndex

BeginCreateSchema
create table MulticastServiceProfileTemplate ( 
"PROFILENAME"  VARCHAR(32)  NOT NULL , 
"PROFILEBITMAP"  TEXT, 
PRIMARY KEY ("PROFILENAME"))
EndCreateSchema


BeginDropSchema
drop table MulticastServiceProfileTemplate
EndDropSchema

BeginIndex
CREATE INDEX MulticastServiceProfileTemplate0_ndx ON MulticastServiceProfileTemplate ("PROFILENAME") 
EndIndex

BeginCreateSchema
create table PMProfileTemplate ( 
"PROFILENAME"  VARCHAR(32)  NOT NULL , 
"ATUC15MINES"  INTEGER , 
"ATUC15MINSES"  INTEGER , 
"ATUC15MINUAS"  INTEGER , 
"ATUC1DAYES"  INTEGER , 
"ATUC1DAYSES"  INTEGER , 
"ATUC1DAYUAS"  INTEGER , 
"ATUR15MINES"  INTEGER , 
"ATUR15MINSES"  INTEGER , 
"ATUR15MINUAS"  INTEGER , 
"ATUR1DAYES"  INTEGER , 
"ATUR1DAYSES"  INTEGER , 
"ATUR1DAYUAS"  INTEGER , 
PRIMARY KEY ("PROFILENAME"))
EndCreateSchema


BeginDropSchema
drop table PMProfileTemplate
EndDropSchema

BeginIndex
CREATE INDEX PMProfileTemplate0_ndx ON PMProfileTemplate ("PROFILENAME") 
EndIndex

BeginCreateSchema
create table AlarmDefinitionTemplate ( 
"DEVICETYPE"  INTEGER   NOT NULL ,
"VENDERTYPE"  INTEGER   NOT NULL , 
"ALARMTYPE"  INTEGER   NOT NULL , 
"ALARMNAME"  VARCHAR(32), 
"ALARMDESCRIPTION"  TEXT, 
"ALARMSEVERITY"  INTEGER , 
"ALARMFILTERED"  INTEGER , 
"ALARMSUPPRESSEDBY"  BIGINT, 
PRIMARY KEY ("DEVICETYPE", "VENDERTYPE", "ALARMTYPE"))
EndCreateSchema


BeginDropSchema
drop table AlarmDefinitionTemplate
EndDropSchema

BeginIndex
CREATE INDEX AlarmDefinitionTemplate0_ndx ON AlarmDefinitionTemplate ("DEVICETYPE") 
EndIndex 

BeginIndex
CREATE INDEX AlarmDefinitionTemplate0_ndx ON AlarmDefinitionTemplate ("VENDERTYPE") 
EndIndex 


BeginIndex
CREATE INDEX AlarmDefinitionTemplate1_ndx ON AlarmDefinitionTemplate ("ALARMTYPE") 
EndIndex

BeginCreateSchema
create table Subscriber ( 
"SUBSRIBERIP"  VARCHAR(50)  NOT NULL , 
"SHELF"  VARCHAR(50)  NOT NULL , 
"SLOT"  VARCHAR(50)  NOT NULL , 
"PORT"  VARCHAR(50)  NOT NULL , 
"SUBID"  VARCHAR(50), 
"SUBCLASS"  VARCHAR(50), 
"EMAIL"  VARCHAR(50), 
"TEL"  VARCHAR(50), 
"MOBILE"  VARCHAR(50), 
"SERVICETYPE"  VARCHAR(50), 
"ADDRESS"  VARCHAR(50), 
PRIMARY KEY ("SUBSRIBERIP", "SHELF", "SLOT", "PORT"))
EndCreateSchema


BeginDropSchema
drop table Subscriber
EndDropSchema

BeginIndex
CREATE INDEX Subscriber0_ndx ON Subscriber ("SUBSRIBERIP") 
EndIndex 



BeginIndex
CREATE INDEX Subscriber1_ndx ON Subscriber ("SHELF") 
EndIndex 



BeginIndex
CREATE INDEX Subscriber2_ndx ON Subscriber ("SLOT") 
EndIndex 



BeginIndex
CREATE INDEX Subscriber3_ndx ON Subscriber ("PORT") 
EndIndex

BeginCreateSchema
create table SubscriberManagement ( 
"SUBID"  VARCHAR(50)  NOT NULL , 
"SUBNAME"  VARCHAR(50), 
"SUBTEL"  VARCHAR(50), 
"SUBNEIP"  VARCHAR(50), 
"SUBSHELF"  VARCHAR(50), 
"SUBSLOT"  VARCHAR(50), 
"SUBPORT"  VARCHAR(50), 
PRIMARY KEY ("SUBID"))
EndCreateSchema


BeginDropSchema
drop table SubscriberManagement
EndDropSchema

BeginIndex
CREATE INDEX SubscriberManagement0_ndx ON SubscriberManagement ("SUBID") 
EndIndex

BeginCreateSchema
create table SHDSLLineProfileTemplate ( 
"PROFILENAME"  VARCHAR(50)  NOT NULL , 
"RATEMODE"  INTEGER , 
"MINRATE"  INTEGER , 
"MAXRATE"  INTEGER , 
"CURRENTTARGETMARGINUP"  INTEGER , 
"WORSTTARGETMARINUP"  INTEGER , 
"CURRENTTARGETMARGINDOWN"  INTEGER , 
"WORSTTARGETMARINDOWN"  INTEGER , 
"TXMODE"  VARCHAR(50), 
"LINEPROBE"  INTEGER , 
"USEDTARGETMARGINS"  VARCHAR(50), 
"PSDMASK"  INTEGER , 
PRIMARY KEY ("PROFILENAME"))
EndCreateSchema


BeginDropSchema
drop table SHDSLLineProfileTemplate
EndDropSchema

BeginIndex
CREATE INDEX SHDSLLineProfileTemplate0_ndx ON SHDSLLineProfileTemplate ("PROFILENAME") 
EndIndex

BeginCreateSchema
create table SHDSLPMProfileTemplate ( 
"PROFILENAME"  VARCHAR(50)  NOT NULL , 
"MINSNRMARGIN"  INTEGER , 
"MAXLOOPATTENUATION"  INTEGER , 
"ES"  INTEGER , 
"SES"  INTEGER , 
"UAS"  INTEGER , 
"LOSWS"  INTEGER , 
"CRC"  INTEGER , 
PRIMARY KEY ("PROFILENAME"))
EndCreateSchema


BeginDropSchema
drop table SHDSLPMProfileTemplate
EndDropSchema

BeginIndex
CREATE INDEX SHDSLPMProfileTemplate0_ndx ON SHDSLPMProfileTemplate ("PROFILENAME") 
EndIndex

BeginCreateSchema
create table AutoSchedule ( 
"NENAME"  VARCHAR(50)  NOT NULL , 
"MODULE"  VARCHAR(50)  NOT NULL , 
"WEEKDAY"  INTEGER , 
"HOURS"  INTEGER , 
"MINUTE"  INTEGER , 
"LATESTBACKUPTIME"  BIGINT , 
PRIMARY KEY ("NENAME", "MODULE"))
EndCreateSchema


BeginDropSchema
drop table AutoSchedule
EndDropSchema

BeginIndex
CREATE INDEX AutoSchedule0_ndx ON AutoSchedule ("NENAME") 
EndIndex 



BeginIndex
CREATE INDEX AutoSchedule1_ndx ON AutoSchedule ("MODULE") 
EndIndex

BeginCreateSchema
create table InventoryInserviceManagement ( 
"NEIP"  VARCHAR(50)  NOT NULL , 
"SLOT"  INTEGER   NOT NULL , 
"PLANCARDTYPE"  INTEGER , 
"ASSGINCARDTYPE"  INTEGER , 
"STATUS"  INTEGER , 
"ASSGINFROM"  VARCHAR(255), 
"ASSIGNCARDNO"  VARCHAR(50), 
"NENAME"  VARCHAR(255), 
"LOCATION"  VARCHAR(255), 
"DEVICETYPE"  INTEGER , 
"ONLINECARDTYPE"  INTEGER , 
"ONLINECARDNO"  VARCHAR(50), 
PRIMARY KEY ("NEIP", "SLOT"))
EndCreateSchema


BeginDropSchema
drop table InventoryInserviceManagement
EndDropSchema

BeginIndex
CREATE INDEX InventoryInserviceManagement0_ndx ON InventoryInserviceManagement ("NEIP") 
EndIndex 



BeginIndex
CREATE INDEX InventoryInserviceManagement1_ndx ON InventoryInserviceManagement ("SLOT") 
EndIndex

BeginCreateSchema
create table InventoryInstorageManagement ( 
"SERIALNO"  VARCHAR(50)  NOT NULL , 
"CARDTYPE"  INTEGER , 
"LOCATION"  VARCHAR(255), 
"STATUS"  INTEGER , 
PRIMARY KEY ("SERIALNO"))
EndCreateSchema


BeginDropSchema
drop table InventoryInstorageManagement
EndDropSchema

BeginIndex
CREATE INDEX InventoryInstorageManagement0_ndx ON InventoryInstorageManagement ("SERIALNO") 
EndIndex

BeginCreateSchema
create table AMAACL ( 
"DEVICETYPE"  INTEGER   NOT NULL , 
"NAME"  VARCHAR(50)  NOT NULL , 
"BRIDGEID"  INTEGER   NOT NULL , 
"MACADDRESS"  VARCHAR(50)  NOT NULL , 
PRIMARY KEY ("DEVICETYPE", "NAME", "BRIDGEID", "MACADDRESS"))
EndCreateSchema

BeginDropSchema
drop table AMAACL
EndDropSchema

BeginIndex
CREATE INDEX AMAACL0_ndx ON AMAACL ("DEVICETYPE") 
EndIndex 

BeginIndex
CREATE INDEX AMAACL1_ndx ON AMAACL ("NAME") 
EndIndex 

BeginIndex
CREATE INDEX AMAACL2_ndx ON AMAACL ("BRIDGEID") 
EndIndex 

BeginIndex
CREATE INDEX AMAACL3_ndx ON AMAACL ("MACADDRESS") 
EndIndex





BeginCreateSchema
create table AMAIGMPSnooping ( 
"DEVICETYPE"  INTEGER   NOT NULL , 
"DEVICENAME"  VARCHAR(50)  NOT NULL , 
"BRIDGEID"  INTEGER   NOT NULL , 
"LEAVEMODE"  INTEGER , 
"VPI"  INTEGER , 
"PORTINDEX"  INTEGER , 
"VCI"  INTEGER , 
"IGMPSTATUS"  INTEGER , 
PRIMARY KEY ("DEVICETYPE", "DEVICENAME", "BRIDGEID"))
EndCreateSchema

BeginDropSchema
drop table AMAIGMPSnooping
EndDropSchema

BeginIndex
CREATE INDEX AMAIGMPSnooping0_ndx ON AMAIGMPSnooping ("DEVICETYPE") 
EndIndex 

BeginIndex
CREATE INDEX AMAIGMPSnooping1_ndx ON AMAIGMPSnooping ("DEVICENAME") 
EndIndex 

BeginIndex
CREATE INDEX AMAIGMPSnooping2_ndx ON AMAIGMPSnooping ("BRIDGEID") 
EndIndex





BeginCreateSchema
create table AMAIndexEntry ( 
"NETYPE"  INTEGER   NOT NULL , 
"NENAME"  VARCHAR(50)  NOT NULL , 
"EOAALLINDEX"  VARCHAR(50), 
"AAL5ALLINDEX"  VARCHAR(50), 
"BRIDGEALLINDEX"  VARCHAR(50), 
PRIMARY KEY ("NETYPE", "NENAME"))
EndCreateSchema

BeginDropSchema
drop table AMAIndexEntry
EndDropSchema

BeginIndex
CREATE INDEX AMAIndexEntry0_ndx ON AMAIndexEntry ("NETYPE") 
EndIndex 

BeginIndex
CREATE INDEX AMAIndexEntry1_ndx ON AMAIndexEntry ("NENAME") 
EndIndex


BeginCreateSchema
create table AMAProfileTemplate ( 
"PROFILENAME"  VARCHAR(50)  NOT NULL , 
"L2ENTRYRATEMINTIME"  BIGINT , 
"STANDARD"  VARCHAR(50), 
"ATURDOWNTIME"  BIGINT , 
"LINETYPE"  VARCHAR(50), 
"ATUCMINMARGIN"  INTEGER , 
"ATUCDOWNMARGIN"  INTEGER , 
"ATUCMAXMARGIN"  INTEGER , 
"L2ATPR"  INTEGER , 
"ATURUPMARGIN"  INTEGER , 
"ATUCMAXDELAY"  INTEGER , 
"PROFILEDESCRIPTION"  VARCHAR(50), 
"ATUCUPTIME"  BIGINT , 
"DMTTRELLISOP"  VARCHAR(50), 
"L2ENTRYTHRESHOLDRATE"  BIGINT , 
"ATUCDOWNTIME"  BIGINT , 
"RATEMODE"  VARCHAR(50), 
"PSDMASKTYPE"  VARCHAR(50), 
"ATUCUPMARGIN"  INTEGER , 
"L2TIME"  INTEGER , 
"ATURMINTXRATE"  BIGINT , 
"DMTCFGMODE"  VARCHAR(50), 
"ATURMAXTXRATE"  BIGINT , 
"L2MINRATE"  BIGINT , 
"ATURMAXMARGIN"  INTEGER , 
"ATURMINMARGIN"  INTEGER , 
"ATURDOWNMARGIN"  INTEGER , 
"ATURUPTIME"  BIGINT , 
"ATUCTARGETMARGIN"  INTEGER , 
"ATURTARGETMARGIN"  INTEGER , 
"ATUCMINTXRATE"  BIGINT , 
"PMSTATE"  VARCHAR(50), 
"ATURMAXDELAY"  INTEGER , 
"L2EXITTHRESHOLDRATE"  BIGINT , 
"L0TIME"  INTEGER , 
"ATUCMAXTXRATE"  BIGINT , 
PRIMARY KEY ("PROFILENAME"))
EndCreateSchema

BeginDropSchema
drop table AMAProfileTemplate
EndDropSchema

BeginIndex
CREATE INDEX AMAProfileTemplate0_ndx ON AMAProfileTemplate ("PROFILENAME") 
EndIndex




BeginCreateSchema
create table AMAPVC ( 
"NETYPE"  INTEGER   NOT NULL , 
"NENAME"  VARCHAR(50)  NOT NULL , 
"AAL5IFINDEX"  INTEGER   NOT NULL , 
"BRIDGEINDEX"  INTEGER , 
"STATUS"  INTEGER , 
"EOAIFINDEX"  INTEGER , 
"VPI"  INTEGER , 
"PORTINDEX"  INTEGER , 
"VCI"  INTEGER , 
"ENCAPTYPE"  INTEGER , 
PRIMARY KEY ("NETYPE", "NENAME", "AAL5IFINDEX"))
EndCreateSchema

BeginDropSchema
drop table AMAPVC
EndDropSchema

BeginIndex
CREATE INDEX AMAPVC0_ndx ON AMAPVC ("NETYPE") 
EndIndex 

BeginIndex
CREATE INDEX AMAPVC1_ndx ON AMAPVC ("NENAME") 
EndIndex 

BeginIndex
CREATE INDEX AMAPVC2_ndx ON AMAPVC ("AAL5IFINDEX") 
EndIndex




BeginCreateSchema
create table AMAStaticVlan ( 
"DEVICETYPE"  INTEGER   NOT NULL , 
"DEVICENAME"  VARCHAR(50)  NOT NULL , 
"VLANINDEX"  INTEGER   NOT NULL , 
"VLANNAME"  VARCHAR(50), 
"FORBIDDENPORTS"  VARCHAR(50), 
"FULLBRIDGESTATUS"  INTEGER , 
"EGRESSPORTS"  BLOB, 
"BCASTSUPPORTSTATUS"  INTEGER , 
"UNTAGGEDPORTS"  BLOB, 
"FLOODSUPPORTSTATUS"  INTEGER , 
PRIMARY KEY ("DEVICETYPE", "DEVICENAME", "VLANINDEX"))
EndCreateSchema

BeginDropSchema
drop table AMAStaticVlan
EndDropSchema

BeginIndex
CREATE INDEX AMAStaticVlan0_ndx ON AMAStaticVlan ("DEVICETYPE") 
EndIndex 

BeginIndex
CREATE INDEX AMAStaticVlan1_ndx ON AMAStaticVlan ("DEVICENAME") 
EndIndex 

BeginIndex
CREATE INDEX AMAStaticVlan2_ndx ON AMAStaticVlan ("VLANINDEX") 
EndIndex




BeginCreateSchema
create table AMASystemTrap ( 
"DEVICETYPE"  INTEGER   NOT NULL , 
"DEVICENAME"  VARCHAR(50)  NOT NULL , 
"PORTID"  INTEGER   NOT NULL , 
"FAILTRAP"  INTEGER , 
"LINKTRAP"  INTEGER , 
"POWERTRAP"  INTEGER , 
"OPTRAP"  INTEGER , 
PRIMARY KEY ("DEVICETYPE", "DEVICENAME", "PORTID"))
EndCreateSchema

BeginDropSchema
drop table AMASystemTrap
EndDropSchema

BeginIndex
CREATE INDEX AMASystemTrap0_ndx ON AMASystemTrap ("DEVICETYPE") 
EndIndex 

BeginIndex
CREATE INDEX AMASystemTrap1_ndx ON AMASystemTrap ("DEVICENAME") 
EndIndex 

BeginIndex
CREATE INDEX AMASystemTrap2_ndx ON AMASystemTrap ("PORTID") 
EndIndex



BeginCreateSchema
create table AMAVlanGvrp ( 
"DEVICETYPE"  INTEGER   NOT NULL , 
"DEVICENAME"  VARCHAR(50)  NOT NULL , 
"BRIDGEID"  INTEGER   NOT NULL , 
"PORTID"  INTEGER , 
"VCI"  INTEGER , 
"VPI"  INTEGER , 
"GVRPSTATE"  INTEGER , 
"LASTPDUORIGIN"  VARCHAR(50), 
"FAILEDREGISTRATIONS"  INTEGER , 
PRIMARY KEY ("DEVICETYPE", "DEVICENAME", "BRIDGEID"))
EndCreateSchema

BeginDropSchema
drop table AMAVlanGvrp
EndDropSchema

BeginIndex
CREATE INDEX AMAVlanGvrp0_ndx ON AMAVlanGvrp ("DEVICETYPE") 
EndIndex 

BeginIndex
CREATE INDEX AMAVlanGvrp1_ndx ON AMAVlanGvrp ("DEVICENAME") 
EndIndex 

BeginIndex
CREATE INDEX AMAVlanGvrp2_ndx ON AMAVlanGvrp ("BRIDGEID") 
EndIndex




BeginCreateSchema
create table AMAVlanPorts ( 
"DEVICETYPE"  INTEGER   NOT NULL , 
"DEVICENAME"  VARCHAR(50)  NOT NULL , 
"BRIDGEID"  INTEGER   NOT NULL , 
"PORTID"  INTEGER , 
"INGRESSFILTER"  INTEGER , 
"FRAMETYPE"  INTEGER , 
"VPI"  INTEGER , 
"VCI"  INTEGER , 
"PVID"  INTEGER , 
PRIMARY KEY ("DEVICETYPE", "DEVICENAME", "BRIDGEID"))
EndCreateSchema

BeginDropSchema
drop table AMAVlanPorts
EndDropSchema

BeginIndex
CREATE INDEX AMAVlanPorts0_ndx ON AMAVlanPorts ("DEVICETYPE") 
EndIndex 

BeginIndex
CREATE INDEX AMAVlanPorts1_ndx ON AMAVlanPorts ("DEVICENAME") 
EndIndex 

BeginIndex
CREATE INDEX AMAVlanPorts2_ndx ON AMAVlanPorts ("BRIDGEID") 
EndIndex


BeginCreateSchema
create table AMAPVCRefresh ( 
"NETYPE"  INTEGER   NOT NULL , 
"NENAME"  VARCHAR(50)  NOT NULL , 
"TABLENAME"  VARCHAR(50)  NOT NULL , 
"NEEDREFRESH"  INTEGER , 
PRIMARY KEY ("NETYPE", "NENAME", "TABLENAME"))
EndCreateSchema

BeginDropSchema
drop table AMAPVCRefresh
EndDropSchema

BeginIndex
CREATE INDEX AMAPVCRefresh0_ndx ON AMAPVCRefresh ("NETYPE") 
EndIndex 

BeginIndex
CREATE INDEX AMAPVCRefresh1_ndx ON AMAPVCRefresh ("NENAME") 
EndIndex 

BeginIndex
CREATE INDEX AMAPVCRefresh2_ndx ON AMAPVCRefresh ("TABLENAME") 
EndIndex


BeginCreateSchema
create table AMA1021SDProxyPort ( 
"NETYPE"  INTEGER   NOT NULL , 
"NENAME"  VARCHAR(50)  NOT NULL , 
"SNMPTFTPPROXY"  VARCHAR(50)  NOT NULL , 
"PORT"  VARCHAR(50), 
PRIMARY KEY ("NETYPE", "NENAME", "SNMPTFTPPROXY"))
EndCreateSchema

BeginDropSchema
drop table AMA1021SDProxyPort
EndDropSchema

BeginIndex
CREATE INDEX AMA1021SDProxyPort0_ndx ON AMA1021SDProxyPort ("NETYPE") 
EndIndex 

BeginIndex
CREATE INDEX AMA1021SDProxyPort1_ndx ON AMA1021SDProxyPort ("NENAME") 
EndIndex 

BeginIndex
CREATE INDEX AMA1021SDProxyPort2_ndx ON AMA1021SDProxyPort ("SNMPTFTPPROXY") 
EndIndex


BeginCreateSchema
create table UserClientObject ( 
"CLIENTSESSIONID"  VARCHAR(50)  NOT NULL , 
"CLIENTUSERNAME"  VARCHAR(50), 
"CLIENTIPADDRESS"  VARCHAR(100), 
"CLIENTLOGINTIME"  VARCHAR(50), 
PRIMARY KEY ("CLIENTSESSIONID"))
EndCreateSchema


BeginDropSchema
drop table UserClientObject
EndDropSchema

BeginIndex
CREATE INDEX UserClientObject0_ndx ON UserClientObject ("CLIENTSESSIONID") 
EndIndex



EndModules TopoDB-MapDB-EventDB-AlertDB-PollDB-PolicyDB-USERSTORAGEDB

#Do not edit the below lines. They are used for statistical data collection.

<STATS>
create table STATSDATA%(
POLLID BIGINT,
INSTANCE varchar(100),
TTIME BIGINT,
VAL BIGINT)
</STATS>

<STRING>
create table STRINGDATA%(
POLLID BIGINT,
INSTANCE varchar(100),
TTIME BIGINT,
VALUE varchar(200))
</STRING>
