-- MySQL dump 8.21
--
-- Host: localhost    Database: netarch8
---------------------------------------------------------
-- Server version	3.23.49a

--
-- Table structure for table 'EventType'
--

CREATE TABLE EventType (
  evnt_type int(11) NOT NULL default '0',
  event varchar(25) default NULL,
  PRIMARY KEY  (evnt_type)
) TYPE=MyISAM;

--
-- Table structure for table 'Events'
--

CREATE TABLE Events (
  date double(11,9) NOT NULL default '0.000000000',
  program varchar(32) NOT NULL default '',
  val double(11,9) default NULL,
  group_id int(11) NOT NULL default '0',
  target_id int(11) NOT NULL default '0',
  evnt_type int(11) NOT NULL default '0',
  evnt_id int(11) NOT NULL auto_increment,
  PRIMARY KEY  (evnt_id),
  KEY evnt_type (evnt_type),
  KEY date_idx (date),
  KEY prog_idx (program)
) TYPE=MyISAM;

--
-- Table structure for table 'NumVals'
--

CREATE TABLE NumVals (
  evnt_id int(11) NOT NULL default '0',
  name varchar(25) default NULL,
  val double(11,9) default NULL,
  KEY evnt_id_idx (evnt_id)
) TYPE=MyISAM;

--
-- Table structure for table 'StrVals'
--

CREATE TABLE StrVals (
  evnt_id int(11) NOT NULL default '0',
  name varchar(25) default NULL,
  val varchar(25) default NULL,
  KEY evnt_id_idx (evnt_id)
) TYPE=MyISAM;

--
-- Table structure for table 'Targets'
--

CREATE TABLE Targets (
  target_id int(11) NOT NULL auto_increment,
  src varchar(16) default NULL,
  dst varchar(16) default NULL,
  PRIMARY KEY  (target_id)
) TYPE=MyISAM;

