· 7 years ago · Sep 25, 2018, 11:12 AM
1`-- phpMyAdmin SQL Dump
2-- version 3.3.10.5
3-- http://www.phpmyadmin.net
4--
5-- Host: 192.168.220.91
6-- Generation Time: Sep 25, 2018 at 01:06 PM
7-- Server version: 5.6.24
8-- PHP Version: 5.6.29
9
10SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
11
12--
13-- Database: `iw_3264`
14--
15
16-- --------------------------------------------------------
17
18--
19-- Table structure for table `iw_par_bac_vent_groups`
20--
21
22CREATE TABLE IF NOT EXISTS `iw_par_bac_vent_groups` (
23 `row_date` datetime NOT NULL DEFAULT '2004-01-10 00:00:00',
24 `type` varchar(50) NOT NULL DEFAULT '',
25 `view_order` mediumint(6) NOT NULL DEFAULT '0',
26 `ref` varchar(100) NOT NULL DEFAULT '',
27 `value` varchar(200) NOT NULL DEFAULT '',
28 UNIQUE KEY `type` (`type`,`view_order`,`ref`,`value`)
29) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='2.0.0';
30
31-- --------------------------------------------------------
32
33--
34-- Table structure for table `iw_par_bac_vent_param`
35--
36
37CREATE TABLE IF NOT EXISTS `iw_par_bac_vent_param` (
38 `row_date` datetime NOT NULL DEFAULT '2004-01-01 00:00:00',
39 `element_id` varchar(100) NOT NULL DEFAULT '',
40 `driver_id` varchar(100) NOT NULL DEFAULT '',
41 `alias_text` text NOT NULL,
42 `menu` varchar(10) NOT NULL DEFAULT '',
43 `application` text NOT NULL,
44 `parameter_type` text NOT NULL,
45 `factory_setting` text NOT NULL,
46 `grp` text NOT NULL,
47 `att` text NOT NULL,
48 `eng_unit` varchar(50) NOT NULL DEFAULT '',
49 `format` varchar(20) NOT NULL DEFAULT '',
50 `range_min` text NOT NULL,
51 `range_max` text NOT NULL,
52 `scale` varchar(15) NOT NULL DEFAULT '',
53 `raw_min` varchar(15) NOT NULL DEFAULT '',
54 `raw_max` varchar(15) NOT NULL DEFAULT '',
55 `eng_min` varchar(15) NOT NULL DEFAULT '',
56 `eng_max` varchar(15) NOT NULL DEFAULT '',
57 `driver_id_extra` varchar(255) NOT NULL DEFAULT '',
58 `format_extra` text NOT NULL,
59 UNIQUE KEY `element_id` (`element_id`)
60) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='3.2.3';
61
62-- --------------------------------------------------------
63
64--
65-- Table structure for table `iw_set_bac_vent`
66--
67
68CREATE TABLE IF NOT EXISTS `iw_set_bac_vent` (
69 `row_date` datetime NOT NULL DEFAULT '2004-01-10 00:00:00',
70 `element_id` varchar(100) NOT NULL DEFAULT '',
71 `active` enum('0','1') NOT NULL DEFAULT '0',
72 `onl_ind` enum('0','1') NOT NULL DEFAULT '1',
73 `update_freq` set('','fast','norm','slow','once','never') NOT NULL DEFAULT 'norm',
74 `save_data` varchar(20) NOT NULL DEFAULT 'change',
75 `save_freq` varchar(20) NOT NULL DEFAULT '',
76 `plant_pri` char(1) NOT NULL DEFAULT '',
77 `sys_pri` char(1) NOT NULL DEFAULT '',
78 `alarm_type` tinyint(3) NOT NULL DEFAULT '0',
79 PRIMARY KEY (`element_id`)
80) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='3.0.0';