I removed all the data from my script except the "devices" table creation. You can try 3 scripts:
this must work well
# --------------------------------------------------------
# Host: vesprom-2
# Server version: 5.0.67-community-nt
# Server OS: Win32
# HeidiSQL version: 6.0.0.3630
# Date/time: 2011-01-17 15:43:49
# --------------------------------------------------------
;
;
;
;
# Dumping structure for table device_server.devices
CREATE TABLE IF NOT EXISTS `devices` (
`id` int(10) unsigned NOT NULL auto_increment COMMENT 'Идентификатор устройства',
`name` varchar(255) NOT NULL COMMENT 'Имя устройства',
`device_type` text NOT NULL COMMENT 'Тип устройства (vkt_6, vvts_4, ...)',
`config` text COMMENT 'Настройки устройства',
`device_group_id` int(10) unsigned NOT NULL COMMENT 'Идентификатор группы устройств',
`description` text COMMENT 'Описание устройства',
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`),
KEY `devices_ibfk_1` (`device_group_id`),
CONSTRAINT `devices_ibfk_1` FOREIGN KEY (`device_group_id`) REFERENCES `device_groups` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='Таблица устройств';
# Dumping data for table device_server.devices: ~3 rows (approximately)
;
INSERT INTO `devices` (`id`, `name`, `device_type`, `config`, `device_group_id`, `description`) VALUES
(2, 'Кран 23 (24)', 'ВKT "КОВШ" 6', '', 2, ''),
(3, 'Кран 23', 'ВKT "КОВШ" 6', '<DeviceConfig waitTimeout="1000" curStateUpdatePeriod="50" maxFailCount="3" maxRepeatCount="3" address="1" type="vkt-6"/>\n', 3, ''),
(4, 'MBSlave_2', 'ВKT "КОВШ" 6', '<DeviceConfig waitTimeout="1000" curStateUpdatePeriod="100" maxFailCount="3" maxRepeatCount="3" address="2" type="vkt-6"/>\n', 3, '');
;
;
;
;
this will take an error
# Dumping structure for table device_server.devices CREATE TABLE IF NOT EXISTS `devices` ( `id` int(10) unsigned NOT NULL auto_increment COMMENT 'Идентификатор устройства', `name` varchar(255) NOT NULL COMMENT 'Имя устройства', `device_type` text NOT NULL COMMENT 'Тип устройства (vkt_6, vvts_4, ...)', `config` text COMMENT 'Настройки устройства', `device_group_id` int(10) unsigned NOT NULL COMMENT 'Идентификатор группы устройств', `description` text COMMENT 'Описание устройства', PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`), KEY `devices_ibfk_1` (`device_group_id`), CONSTRAINT `devices_ibfk_1` FOREIGN KEY (`device_group_id`) REFERENCES `device_groups` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='Таблица устройств';;
# --------------------------------------------------------
# Host: vesprom-2
# Server version: 5.0.67-community-nt
# Server OS: Win32
# HeidiSQL version: 6.0.0.3630
# Date/time: 2011-01-17 15:43:49
# --------------------------------------------------------
;
;
;
;
DELIMITER ;
# Dumping structure for table device_server.devices
CREATE TABLE IF NOT EXISTS `devices` (
`id` int(10) unsigned NOT NULL auto_increment COMMENT 'Идентификатор устройства',
`name` varchar(255) NOT NULL COMMENT 'Имя устройства',
`device_type` text NOT NULL COMMENT 'Тип устройства (vkt_6, vvts_4, ...)',
`config` text COMMENT 'Настройки устройства',
`device_group_id` int(10) unsigned NOT NULL COMMENT 'Идентификатор группы устройств',
`description` text COMMENT 'Описание устройства',
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`),
KEY `devices_ibfk_1` (`device_group_id`),
CONSTRAINT `devices_ibfk_1` FOREIGN KEY (`device_group_id`) REFERENCES `device_groups` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='Таблица устройств';
# Dumping data for table device_server.devices: ~3 rows (approximately)
;
INSERT INTO `devices` (`id`, `name`, `device_type`, `config`, `device_group_id`, `description`) VALUES
(2, 'Кран 23 (24)', 'ВKT "КОВШ" 6', '', 2, ''),
(3, 'Кран 23', 'ВKT "КОВШ" 6', '<DeviceConfig waitTimeout="1000" curStateUpdatePeriod="50" maxFailCount="3" maxRepeatCount="3" address="1" type="vkt-6"/>\n', 3, ''),
(4, 'MBSlave_2', 'ВKT "КОВШ" 6', '<DeviceConfig waitTimeout="1000" curStateUpdatePeriod="100" maxFailCount="3" maxRepeatCount="3" address="2" type="vkt-6"/>\n', 3, '');
;
;
;
;
and this takes an error:
# Dumping structure for table device_server.devices CREATE TABLE IF NOT EXISTS `devices` ( `id` int(10) unsigned NOT NULL auto_increment COMMENT 'Идентификатор устройства', `name` varchar(255) NOT NULL COMMENT 'Имя устройства', `device_type` text NOT NULL COMMENT 'Тип устройства (vkt_6, vvts_4, ...)', `config` text COMMENT 'Настройки устройства', `device_group_id` int(10) unsigned NOT NULL COMMENT 'Идентификатор группы устройств', `description` text COMMENT 'Описание устройства', PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='Таблица устройств';;
# Dumping data for table device_server.devices: ~3 rows (approximately) ;;
INSERT INTO `devices` (`id`, `name`, `device_type`, `config`, `device_group_id`, `description`) VALUES (2, 'Кран 23 (24)', 'ВKT "КОВШ" 6', '', 2, ''), (3, 'Кран 23', 'ВKT "КОВШ" 6', '<DeviceConfig waitTimeout="1000" curStateUpdatePeriod="50" maxFailCount="3" maxRepeatCount="3" address="1" type="vkt-6"/>\n', 3, ''), (4, 'MBSlave_2', 'ВKT "КОВШ" 6', '<DeviceConfig waitTimeout="1000" curStateUpdatePeriod="100" maxFailCount="3" maxRepeatCount="3" address="2" type="vkt-6"/>\n', 3, '');;
;;
;;
# --------------------------------------------------------
# Host: vesprom-2
# Server version: 5.0.67-community-nt
# Server OS: Win32
# HeidiSQL version: 6.0.0.3630
# Date/time: 2011-01-17 15:43:49
# --------------------------------------------------------
;
;
;
;
DELIMITER ;
# Dumping structure for table device_server.devices
CREATE TABLE IF NOT EXISTS `devices` (
`id` int(10) unsigned NOT NULL auto_increment COMMENT 'Идентификатор устройства',
`name` varchar(255) NOT NULL COMMENT 'Имя устройства',
`device_type` text NOT NULL COMMENT 'Тип устройства (vkt_6, vvts_4, ...)',
`config` text COMMENT 'Настройки устройства',
`device_group_id` int(10) unsigned NOT NULL COMMENT 'Идентификатор группы устройств',
`description` text COMMENT 'Описание устройства',
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='Таблица устройств';
# Dumping data for table device_server.devices: ~3 rows (approximately)
;
INSERT INTO `devices` (`id`, `name`, `device_type`, `config`, `device_group_id`, `description`) VALUES
(2, 'Кран 23 (24)', 'ВKT "КОВШ" 6', '', 2, ''),
(3, 'Кран 23', 'ВKT "КОВШ" 6', '<DeviceConfig waitTimeout="1000" curStateUpdatePeriod="50" maxFailCount="3" maxRepeatCount="3" address="1" type="vkt-6"/>\n', 3, ''),
(4, 'MBSlave_2', 'ВKT "КОВШ" 6', '<DeviceConfig waitTimeout="1000" curStateUpdatePeriod="100" maxFailCount="3" maxRepeatCount="3" address="2" type="vkt-6"/>\n', 3, '');
;
;
;
;