/adei/trunk : contents of sql/zeus71.sql at revision 551

: (revision 551)

To get this branch, use:

bzr branch
http://darksoft.org/webbzr/adei/trunk

-- phpMyAdmin SQL Dump
-- version 2.7.0-pl1
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Erstellungszeit: 21. Juni 2006 um 23:46
-- Server Version: 4.1.11
-- PHP-Version: 4.3.10-16
-- 
-- Datenbank: `zeus71`
-- 

-- --------------------------------------------------------

-- 
-- Tabellenstruktur für Tabelle `blocks`
-- 

CREATE TABLE `blocks` (
  `bid` int(10) NOT NULL default '0',
  `name` varchar(50) collate latin1_general_ci NOT NULL default '',
  `oid` int(10) NOT NULL default '0',
  `oindex` int(10) NOT NULL default '0',
  `length` int(10) NOT NULL default '0',
  `datatype` tinyint(3) NOT NULL default '0',
  `scalefactor` double NOT NULL default '0',
  `itemnames` text collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`bid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

-- 
-- Tabellenstruktur für Tabelle `config`
-- 

CREATE TABLE `config` (
  `facility` varchar(255) collate latin1_general_ci NOT NULL default '',
  `host` varchar(255) collate latin1_general_ci NOT NULL default '',
  `hmis` text collate latin1_general_ci NOT NULL,
  `lclb` tinyblob NOT NULL,
  `port` smallint(5) unsigned NOT NULL default '0',
  `mode` tinyint(4) NOT NULL default '0',
  `password` varchar(20) collate latin1_general_ci NOT NULL default 'wsdb!00',
  PRIMARY KEY  (`facility`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

-- 
-- Tabellenstruktur für Tabelle `g2id`
-- 

CREATE TABLE `g2id` (
  `gid` int(10) NOT NULL default '0',
  `id` int(10) NOT NULL default '0',
  `deadband` double NOT NULL default '0',
  `pos` int(10) NOT NULL default '0',
  KEY `gid` (`gid`,`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

-- 
-- Tabellenstruktur für Tabelle `groups`
-- 

CREATE TABLE `groups` (
  `gid` int(10) NOT NULL default '0',
  `name` varchar(100) collate latin1_general_ci NOT NULL default '',
  `comment` text collate latin1_general_ci NOT NULL,
  `grouptype` tinyint(3) NOT NULL default '0',
  `interval` int(10) NOT NULL default '0',
  `mode` tinyint(3) NOT NULL default '0',
  PRIMARY KEY  (`gid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

-- 
-- Tabellenstruktur für Tabelle `items`
-- 

CREATE TABLE `items` (
  `iid` int(10) NOT NULL default '0',
  `name` varchar(50) collate latin1_general_ci NOT NULL default '',
  `formular` varchar(255) collate latin1_general_ci NOT NULL default '',
  `inputs` blob NOT NULL,
  PRIMARY KEY  (`iid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

-- 
-- Tabellenstruktur für Tabelle `loginfo`
-- 

CREATE TABLE `loginfo` (
  `gid` int(11) NOT NULL default '0',
  `name` varchar(100) NOT NULL default '',
  `comment` text NOT NULL,
  `size` int(10) NOT NULL default '0',
  `itemnames` text NOT NULL,
  PRIMARY KEY  (`gid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- 
-- Tabellenstruktur für Tabelle `marker`
-- 

CREATE TABLE `marker` (
  `start` double NOT NULL default '0',
  `name` varchar(50) collate latin1_general_ci NOT NULL default '',
  `stop` double NOT NULL default '0',
  `experiment` varchar(50) collate latin1_general_ci NOT NULL default '',
  `text` text collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`start`),
  KEY `experiment` (`experiment`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

-- 
-- Tabellenstruktur für Tabelle `masks`
-- 

CREATE TABLE `masks` (
  `maskid` int(10) NOT NULL default '0',
  `name` varchar(50) collate latin1_general_ci NOT NULL default '',
  `gid` int(10) NOT NULL default '0',
  `mask` blob NOT NULL,
  PRIMARY KEY  (`maskid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

-- 
-- Tabellenstruktur für Tabelle `messagelog`
-- 

CREATE TABLE `messagelog` (
  `lid` bigint(20) NOT NULL auto_increment,
  `messageid` int(10) NOT NULL default '0',
  `name` text collate latin1_general_ci NOT NULL,
  `mtype` tinyint(4) NOT NULL default '0',
  `cond` text collate latin1_general_ci NOT NULL,
  `ack` tinyint(4) NOT NULL default '0',
  `come` double NOT NULL default '0',
  `go` double NOT NULL default '0',
  `acked` double NOT NULL default '0',
  PRIMARY KEY  (`lid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=13 ;

-- --------------------------------------------------------

-- 
-- Tabellenstruktur für Tabelle `messages`
-- 

CREATE TABLE `messages` (
  `messageid` int(10) NOT NULL default '0',
  `name` text collate latin1_general_ci NOT NULL,
  `mtype` tinyint(3) NOT NULL default '0',
  `bid` int(10) NOT NULL default '0',
  `bindex` smallint(5) NOT NULL default '0',
  `trigger` tinyint(3) NOT NULL default '0',
  `threshold` double NOT NULL default '0',
  `hyst` double NOT NULL default '0',
  `ack` tinyint(3) NOT NULL default '0',
  `signal` tinyint(3) NOT NULL default '0',
  PRIMARY KEY  (`messageid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

-- 
-- Tabellenstruktur für Tabelle `opc`
-- 

CREATE TABLE `opc` (
  `oid` int(10) NOT NULL default '0',
  `name` varchar(50) collate latin1_general_ci NOT NULL default '',
  `hardware` text collate latin1_general_ci NOT NULL,
  `length` int(10) NOT NULL default '0',
  `opcurl` text collate latin1_general_ci NOT NULL,
  `mode` tinyint(3) NOT NULL default '0',
  `must_updat` int(10) NOT NULL default '0',
  PRIMARY KEY  (`oid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

-- 
-- Tabellenstruktur für Tabelle `syslog`
-- 

CREATE TABLE `syslog` (
  `lid` bigint(20) NOT NULL auto_increment,
  `ts` double NOT NULL default '0',
  `source` varchar(250) collate latin1_general_ci NOT NULL default '',
  `message` text collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`lid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=126 ;

205.1.1 by Suren A. Chilingaryan Support for ZEUS backup for MSSQL-based installations, still backed-up in MySQL	1	-- phpMyAdmin SQL Dump
	2	-- version 2.7.0-pl1
	3	-- http://www.phpmyadmin.net
	4	--
	5	-- Host: localhost
	6	-- Erstellungszeit: 21. Juni 2006 um 23:46
	7	-- Server Version: 4.1.11
	8	-- PHP-Version: 4.3.10-16
	9	--
	10	-- Datenbank: `zeus71`
	11	--
	12
	13	-- --------------------------------------------------------
	14
	15	--
	16	-- Tabellenstruktur für Tabelle `blocks`
	17	--
	18
	19	CREATE TABLE `blocks` (
	20	`bid` int(10) NOT NULL default '0',
	21	`name` varchar(50) collate latin1_general_ci NOT NULL default '',
	22	`oid` int(10) NOT NULL default '0',
	23	`oindex` int(10) NOT NULL default '0',
	24	`length` int(10) NOT NULL default '0',
	25	`datatype` tinyint(3) NOT NULL default '0',
	26	`scalefactor` double NOT NULL default '0',
	27	`itemnames` text collate latin1_general_ci NOT NULL,
	28	PRIMARY KEY (`bid`)
	29	) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
	30
	31	-- --------------------------------------------------------
	32
	33	--
	34	-- Tabellenstruktur für Tabelle `config`
	35	--
	36
	37	CREATE TABLE `config` (
	38	`facility` varchar(255) collate latin1_general_ci NOT NULL default '',
	39	`host` varchar(255) collate latin1_general_ci NOT NULL default '',
	40	`hmis` text collate latin1_general_ci NOT NULL,
	41	`lclb` tinyblob NOT NULL,
	42	`port` smallint(5) unsigned NOT NULL default '0',
	43	`mode` tinyint(4) NOT NULL default '0',
	44	`password` varchar(20) collate latin1_general_ci NOT NULL default 'wsdb!00',
	45	PRIMARY KEY (`facility`)
	46	) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
	47
	48	-- --------------------------------------------------------
	49
	50	--
	51	-- Tabellenstruktur für Tabelle `g2id`
	52	--
	53
	54	CREATE TABLE `g2id` (
	55	`gid` int(10) NOT NULL default '0',
	56	`id` int(10) NOT NULL default '0',
	57	`deadband` double NOT NULL default '0',
	58	`pos` int(10) NOT NULL default '0',
	59	KEY `gid` (`gid`,`id`)
	60	) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
	61
	62	-- --------------------------------------------------------
	63
	64	--
65	-- Tabellenstruktur für Tabelle `groups`
66	--
67
68	CREATE TABLE `groups` (
69	`gid` int(10) NOT NULL default '0',
70	`name` varchar(100) collate latin1_general_ci NOT NULL default '',
71	`comment` text collate latin1_general_ci NOT NULL,
72	`grouptype` tinyint(3) NOT NULL default '0',
73	`interval` int(10) NOT NULL default '0',
74	`mode` tinyint(3) NOT NULL default '0',
75	PRIMARY KEY (`gid`)
76	) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
77
78	-- --------------------------------------------------------
79
80	--
81	-- Tabellenstruktur für Tabelle `items`
82	--
83
84	CREATE TABLE `items` (
85	`iid` int(10) NOT NULL default '0',
86	`name` varchar(50) collate latin1_general_ci NOT NULL default '',
87	`formular` varchar(255) collate latin1_general_ci NOT NULL default '',
88	`inputs` blob NOT NULL,
89	PRIMARY KEY (`iid`)
90	) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
91
92	-- --------------------------------------------------------
93
94	--
95	-- Tabellenstruktur für Tabelle `loginfo`
96	--
97
98	CREATE TABLE `loginfo` (
99	`gid` int(11) NOT NULL default '0',
100	`name` varchar(100) NOT NULL default '',
101	`comment` text NOT NULL,
102	`size` int(10) NOT NULL default '0',
103	`itemnames` text NOT NULL,
104	PRIMARY KEY (`gid`)
105	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
106
107	-- --------------------------------------------------------
108
109	--
110	-- Tabellenstruktur für Tabelle `marker`
111	--
112
113	CREATE TABLE `marker` (
114	`start` double NOT NULL default '0',
115	`name` varchar(50) collate latin1_general_ci NOT NULL default '',
116	`stop` double NOT NULL default '0',
117	`experiment` varchar(50) collate latin1_general_ci NOT NULL default '',
118	`text` text collate latin1_general_ci NOT NULL,
119	PRIMARY KEY (`start`),
120	KEY `experiment` (`experiment`)
121	) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
122
123	-- --------------------------------------------------------
124
125	--
126	-- Tabellenstruktur für Tabelle `masks`
127	--
128
129	CREATE TABLE `masks` (
130	`maskid` int(10) NOT NULL default '0',
131	`name` varchar(50) collate latin1_general_ci NOT NULL default '',
132	`gid` int(10) NOT NULL default '0',
133	`mask` blob NOT NULL,
134	PRIMARY KEY (`maskid`)
135	) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
136
137	-- --------------------------------------------------------
138
139	--
140	-- Tabellenstruktur für Tabelle `messagelog`
141	--
142
143	CREATE TABLE `messagelog` (
144	`lid` bigint(20) NOT NULL auto_increment,
145	`messageid` int(10) NOT NULL default '0',
146	`name` text collate latin1_general_ci NOT NULL,
147	`mtype` tinyint(4) NOT NULL default '0',
148	`cond` text collate latin1_general_ci NOT NULL,
149	`ack` tinyint(4) NOT NULL default '0',
150	`come` double NOT NULL default '0',
151	`go` double NOT NULL default '0',
152	`acked` double NOT NULL default '0',
153	PRIMARY KEY (`lid`)
154	) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=13 ;
155
156	-- --------------------------------------------------------
157
158	--
159	-- Tabellenstruktur für Tabelle `messages`
160	--
161
162	CREATE TABLE `messages` (
163	`messageid` int(10) NOT NULL default '0',
164	`name` text collate latin1_general_ci NOT NULL,
165	`mtype` tinyint(3) NOT NULL default '0',
166	`bid` int(10) NOT NULL default '0',
167	`bindex` smallint(5) NOT NULL default '0',
168	`trigger` tinyint(3) NOT NULL default '0',
169	`threshold` double NOT NULL default '0',
170	`hyst` double NOT NULL default '0',
171	`ack` tinyint(3) NOT NULL default '0',
172	`signal` tinyint(3) NOT NULL default '0',
173	PRIMARY KEY (`messageid`)
174	) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
175
176	-- --------------------------------------------------------
177
178	--
179	-- Tabellenstruktur für Tabelle `opc`
180	--
181
182	CREATE TABLE `opc` (
183	`oid` int(10) NOT NULL default '0',
184	`name` varchar(50) collate latin1_general_ci NOT NULL default '',
185	`hardware` text collate latin1_general_ci NOT NULL,
186	`length` int(10) NOT NULL default '0',
187	`opcurl` text collate latin1_general_ci NOT NULL,
188	`mode` tinyint(3) NOT NULL default '0',
189	`must_updat` int(10) NOT NULL default '0',
190	PRIMARY KEY (`oid`)
191	) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
192
193	-- --------------------------------------------------------
194
195	--
196	-- Tabellenstruktur für Tabelle `syslog`
197	--
198
199	CREATE TABLE `syslog` (
200	`lid` bigint(20) NOT NULL auto_increment,
201	`ts` double NOT NULL default '0',
202	`source` varchar(250) collate latin1_general_ci NOT NULL default '',
203	`message` text collate latin1_general_ci NOT NULL,
204	PRIMARY KEY (`lid`)
205	) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=126 ;