node type

CREATE TABLE IF NOT EXISTS `node_types` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` char(3) COLLATE utf8_czech_ci NOT NULL,
  `title` varchar(50) COLLATE utf8_czech_ci NOT NULL,
  `description` text COLLATE utf8_czech_ci,
  `readonly` tinyint(1) NOT NULL,
  `writeonly` tinyint(1) NOT NULL,
  `delay` tinyint(1) NOT NULL,
  `data_width` int(11) NOT NULL COMMENT 'sirka v bitech',
  `data_count` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=30 ;

--
-- Vypisuji data pro tabulku `node_types`
--

INSERT INTO `node_types` (`id`, `type`, `title`, `description`, `readonly`, `writeonly`, `delay`, `data_width`, `data_count`) VALUES
(15, '1', 'DV_BUTTON', 'Stisk', 1, 0, 0, 1, 1),
(16, '2', 'DV_SWITCH', 'ON/OFF', 1, 0, 0, 1, 1),
(17, '3', 'DV_LIGHT', 'ON/OFF', 1, 1, 0, 1, 1),
(20, '6', 'DV_THERMOMETER', 'Teplota', 1, 0, 0, 8, 1),
(21, '7', 'DV_PIEZZO', 'Delka pip.', 0, 1, 0, 1, 1),
(29, '11', 'DV_FADER', 'Fader', 1, 0, 0, 8, 1);