-- MySQL dump 9.11
--
-- Host: granite    Database: sensor
-- ------------------------------------------------------
-- Server version	4.0.11a-gamma

--
-- Table structure for table `application`
--

CREATE TABLE application (
  uid int(11) NOT NULL auto_increment,
  ccount int(11) default NULL,
  name varchar(80) default NULL,
  descr text,
  PRIMARY KEY  (uid)
) TYPE=MyISAM;

--
-- Table structure for table `channel`
--

CREATE TABLE channel (
  uid int(11) NOT NULL auto_increment,
  hwch int(11) default NULL,
  apid int(11) default NULL,
  name varchar(20) default NULL,
  PRIMARY KEY  (uid),
  KEY apid (apid)
) TYPE=MyISAM;

CREATE TABLE dblock (
  uid int(11) NOT NULL auto_increment,
  dbyte int(11) default NULL,
  dmask int(11) default NULL,
  ddir int(11) default NULL,
  apid int(11) default NULL,
  name0 varchar(20) default NULL,
  name1 varchar(20) default NULL,
  name2 varchar(20) default NULL,
  name3 varchar(20) default NULL,
  name4 varchar(20) default NULL,
  name5 varchar(20) default NULL,
  name6 varchar(20) default NULL,
  name7 varchar(20) default NULL,
  PRIMARY KEY  (uid),
  KEY apid (apid)
) TYPE=MyISAM;

--
-- Table structure for table `logitem`
--

CREATE TABLE logitem (
  uid int(11) NOT NULL auto_increment,
  ts timestamp(14) NOT NULL,
  apid int(11) default NULL,
  ldate date default NULL,
  ltime time default NULL,
  ch0 double(8,4) default NULL,
  ch1 double(8,4) default NULL,
  ch2 double(8,4) default NULL,
  ch3 double(8,4) default NULL,
  ch4 double(8,4) default NULL,
  ch5 double(8,4) default NULL,
  ch6 double(8,4) default NULL,
  ch7 double(8,4) default NULL,
  dio0 int(11) default NULL,
  dio1 int(11) default NULL,
  PRIMARY KEY  (uid),
  KEY apid (apid),
  KEY ts (ts)
) TYPE=MyISAM;

--
-- Table structure for table `logitem2`
--

CREATE TABLE logitem2 (
  uid int(11) NOT NULL auto_increment,
  ts timestamp(14) NOT NULL,
  apid int(11) default NULL,
  ldate date default NULL,
  ltime time default NULL,
  ch0 double(8,4) default NULL,
  ch1 double(8,4) default NULL,
  ch2 double(8,4) default NULL,
  ch3 double(8,4) default NULL,
  ch4 double(8,4) default NULL,
  ch5 double(8,4) default NULL,
  ch6 double(8,4) default NULL,
  ch7 double(8,4) default NULL,
  PRIMARY KEY  (uid),
  KEY apid (apid)
) TYPE=MyISAM;

--
-- Table structure for table `thermistor`
--

CREATE TABLE thermistor (
  uid int(11) NOT NULL auto_increment,
  gain double(8,7) default NULL,
  offset double(8,7) default NULL,
  ltid int(11) default NULL,
  mintemp int(11) default NULL,
  maxtemp int(11) default NULL,
  PRIMARY KEY  (uid)
) TYPE=MyISAM;