wry.sql

企业污染源在线监控软件（delphi7.0+mysql）可以按说明文件自行扩充驱动（用DDE数据交换技术）来实现任意多个信号的可视化监控及报警。

# MySQL-Front Dump 2.5
#
# Host: localhost   Database: wry
# --------------------------------------------------------
# Server version 3.23.56-nt

USE wry;


#
# Table structure for table 'chaijiqi'
#

CREATE TABLE chaijiqi (
  id tinyint(3) NOT NULL auto_increment,
  mc char(12) NOT NULL default '',
  bh tinyint(3) unsigned NOT NULL default '0',
  dk tinyint(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (id),
  UNIQUE KEY id (id,mc,bh,dk),
  KEY id_2 (id)
) TYPE=MyISAM;



#
# Dumping data for table 'chaijiqi'
#



#
# Table structure for table 'danweiqingkuang'
#

CREATE TABLE danweiqingkuang (
  id int(3) unsigned NOT NULL auto_increment,
  dwmc char(40) NOT NULL default '',
  qydz char(40) default NULL,
  djrq date default NULL,
  sshy char(30) default NULL,
  lsly char(30) default NULL,
  fzr char(12) NOT NULL default '',
  wrw char(100) NOT NULL default '',
  edfs int(10) unsigned NOT NULL default '0',
  zlss int(10) unsigned default NULL,
  kzlss tinyint(3) unsigned NOT NULL default '0',
  zed int(10) unsigned default '0',
  yxsj int(3) unsigned NOT NULL default '0',
  pfks tinyint(3) unsigned NOT NULL default '0',
  azrq datetime default NULL,
  PRIMARY KEY  (id),
  UNIQUE KEY id (id,dwmc),
  KEY id_2 (id,dwmc)
) TYPE=MyISAM;



#
# Dumping data for table 'danweiqingkuang'
#



#
# Table structure for table 'dde'
#

CREATE TABLE dde (
  id tinyint(3) unsigned NOT NULL auto_increment,
  servername char(20) default NULL,
  itemname char(20) default NULL,
  start tinyint(3) unsigned default NULL,
  num tinyint(3) unsigned default NULL,
  application_name char(20) default NULL,
  PRIMARY KEY  (id),
  UNIQUE KEY id (id),
  KEY id_2 (id)
) TYPE=MyISAM;



#
# Dumping data for table 'dde'
#

INSERT INTO dde VALUES("1", "cjq_hj01", "cjq_hj01item", "8", "5", "cjq_hj01");


#
# Table structure for table 'jishuantongdao'
#

CREATE TABLE jishuantongdao (
  id tinyint(3) unsigned NOT NULL auto_increment,
  data_id tinyint(3) unsigned default NULL,
  num_td tinyint(3) unsigned default NULL,
  jishuan char(48) default NULL,
  PRIMARY KEY  (id),
  UNIQUE KEY id (id),
  KEY id_2 (id)
) TYPE=MyISAM;



#
# Dumping data for table 'jishuantongdao'
#



#
# Table structure for table 'linshi'
#

CREATE TABLE linshi (
  id int(4) unsigned NOT NULL auto_increment,
  td_id tinyint(3) unsigned default NULL,
  sj datetime default NULL,
  data float default NULL,
  PRIMARY KEY  (id),
  UNIQUE KEY id (id),
  KEY id_2 (td_id,sj)
) TYPE=MyISAM;



#
# Dumping data for table 'linshi'
#



#
# Table structure for table 'panfangkouqingkuang'
#

CREATE TABLE panfangkouqingkuang (
  id tinyint(3) unsigned NOT NULL auto_increment,
  pukmc char(20) NOT NULL default '',
  pukdz char(40) NOT NULL default '',
  rzdsl tinyint(3) unsigned NOT NULL default '0',
  sszdsl tinyint(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (id),
  UNIQUE KEY id (id,pukmc),
  KEY id_2 (id)
) TYPE=MyISAM;



#
# Dumping data for table 'panfangkouqingkuang'
#



#
# Table structure for table 'report'
#

CREATE TABLE report (
  id int(3) unsigned NOT NULL auto_increment,
  td_id int(3) unsigned default NULL,
  td_name char(12) default NULL,
  report_type int(3) unsigned default NULL,
  tdsum char(2) default NULL,
  tdmax char(2) default NULL,
  tdmin char(2) default NULL,
  tdavg char(2) default NULL,
  tdmemo char(2) default NULL,
  tdpic char(2) default NULL,
  pictype char(12) default NULL,
  tdleiji char(2) default NULL,
  tdsumsub char(12) default NULL,
  PRIMARY KEY  (id),
  UNIQUE KEY id (id),
  KEY id_2 (id)
) TYPE=MyISAM;



#
# Dumping data for table 'report'
#



#
# Table structure for table 'rp_type'
#

CREATE TABLE rp_type (
  id int(3) unsigned NOT NULL auto_increment,
  name char(12) default NULL,
  PRIMARY KEY  (id),
  UNIQUE KEY id (id),
  KEY id_2 (id)
) TYPE=MyISAM;



#
# Dumping data for table 'rp_type'
#



#
# Table structure for table 'sewarming'
#

CREATE TABLE sewarming (
  id tinyint(3) unsigned NOT NULL auto_increment,
  td_id tinyint(3) unsigned default NULL,
  ma float default NULL,
  imax char(2) default NULL,
  mi float default '0',
  imin char(2) default NULL,
  maday float default NULL,
  miday float default '0',
  iday char(2) default NULL,
  mamonth float default NULL,
  mimonth float default '0',
  imonth char(2) default NULL,
  mayear float default NULL,
  miyear float default '0',
  iyear char(2) default NULL,
  iyouxiao char(2) default NULL,
  xuhao tinyint(3) unsigned default NULL,
  PRIMARY KEY  (id),
  UNIQUE KEY id (id),
  KEY id_2 (id)
) TYPE=MyISAM;



#
# Dumping data for table 'sewarming'
#



#
# Table structure for table 'shebei'
#

CREATE TABLE shebei (
  id tinyint(3) unsigned NOT NULL auto_increment,
  sbmc char(30) default NULL,
  sccs char(30) default NULL,
  gzrq date default NULL,
  yxrq date default NULL,
  azdd char(20) default NULL,
  eddl float default '0',
  fzr char(10) default NULL,
  yxzk char(30) default NULL,
  jstd int(3) unsigned default NULL,
  PRIMARY KEY  (id),
  UNIQUE KEY sbmc (sbmc)
) TYPE=MyISAM;



#
# Dumping data for table 'shebei'
#



#
# Table structure for table 'shebeiyunxing'
#

CREATE TABLE shebeiyunxing (
  id int(4) unsigned NOT NULL auto_increment,
  sj_id int(3) unsigned NOT NULL default '0',
  kj datetime default NULL,
  gj datetime default NULL,
  yunxing timestamp(14) NOT NULL,
  PRIMARY KEY  (id),
  UNIQUE KEY id (id),
  KEY id_2 (id)
) TYPE=MyISAM;



#
# Dumping data for table 'shebeiyunxing'
#



#
# Table structure for table 'sys_users'
#

CREATE TABLE sys_users (
  id int(3) unsigned NOT NULL auto_increment,
  user_name char(12) NOT NULL default '',
  user_code char(4) NOT NULL default '',
  user_password char(12) NOT NULL default '888888',
  user_jibie char(12) NOT NULL default '',
  user_power char(12) default NULL,
  user_miaoshu char(40) default NULL,
  PRIMARY KEY  (id),
  UNIQUE KEY id (id,user_name,user_code),
  KEY id_2 (id)
) TYPE=MyISAM;



#
# Dumping data for table 'sys_users'
#



#
# Table structure for table 'tongdao'
#

CREATE TABLE tongdao (
  id tinyint(3) unsigned NOT NULL auto_increment,
  name char(20) default NULL,
  sj_id tinyint(3) unsigned default NULL,
  sj_type char(4) default '实型',
  max float default NULL,
  min float default NULL,
  save char(2) default '是',
  if_wrw char(2) default '否',
  if_time char(2) default '是',
  data_dw char(16) default NULL,
  total_dw char(16) default NULL,
  bili float default '1',
  warming char(2) default '否',
  day float default '0',
  month float default '0',
  year float default '0',
  PRIMARY KEY  (id),
  UNIQUE KEY id (id),
  KEY id_2 (id)
) TYPE=MyISAM;



#
# Dumping data for table 'tongdao'
#

INSERT INTO tongdao VALUES("1", "污水流量", "8", "实型", "300", "0", "是", "是", "是", "升/30秒", "方", "1000", "否", "0.217", "0.217", "0.217");
INSERT INTO tongdao VALUES("2", "氨氮", "9", "实型", "2000", "0", "是", "是", "是", "mg/L", NULL, "1", "否", "0", "0", "0");
INSERT INTO tongdao VALUES("3", "COD", "10", "实型", "1000", "0", "是", "是", "是", "mg/L", NULL, "1", "否", "0", "0", "0");
INSERT INTO tongdao VALUES("4", "氨氮量", "11", "实型", "2000", "0", "是", "是", "是", "mg/L", "kg", "1e+006", "否", "0", "0", "0");
INSERT INTO tongdao VALUES("5", "COD量", "12", "实型", "1000", "0", "是", "是", "是", "mg/L", "kg", "1e+006", "否", "0", "0", "0");


#
# Table structure for table 'tongdaoshuju'
#

CREATE TABLE tongdaoshuju (
  id int(4) unsigned NOT NULL auto_increment,
  td_id tinyint(3) unsigned default NULL,
  sj datetime default NULL,
  data float default NULL,
  PRIMARY KEY  (id),
  UNIQUE KEY id (id),
  KEY id_2 (td_id,sj)
) TYPE=MyISAM;



#
# Dumping data for table 'tongdaoshuju'
#



#
# Table structure for table 'warming'
#

CREATE TABLE warming (
  id int(3) unsigned NOT NULL auto_increment,
  td_id int(3) default '-1',
  td_name char(20) default NULL,
  warming_time datetime default NULL,
  warming_type char(20) default NULL,
  memo char(60) default NULL,
  if_cy char(2) default NULL,
  cy_time datetime default NULL,
  jc_time datetime default NULL,
  jc_name char(12) default NULL,
  if_jc char(2) NOT NULL default '',
  PRIMARY KEY  (id),
  UNIQUE KEY id (id),
  KEY id_2 (id)
) TYPE=MyISAM;



#
# Dumping data for table 'warming'
#



#
# Table structure for table 'youxiao'
#

CREATE TABLE youxiao (
  id tinyint(3) unsigned NOT NULL auto_increment,
  td_id tinyint(3) default '-1',
  name char(18) default NULL,
  xuhao tinyint(3) unsigned default NULL,
  ztz char(20) default NULL,
  warming char(2) default NULL,
  day float default NULL,
  month float default NULL,
  year float default NULL,
  PRIMARY KEY  (id),
  UNIQUE KEY id (id),
  KEY id_2 (id)
) TYPE=MyISAM;



#
# Dumping data for table 'youxiao'
#