> Can you please do the following within mysql and send the output?
>
> show create table roles;
mysql> show create table roles\G
*************************** 1. row ***************************
Table: roles
Create Table: CREATE TABLE `roles` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(128) NOT NULL,
`fixedname` varchar(16) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `fixedname` (`fixedname`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
1 row in set (0.10 sec)
> show create table monitoringservers;
mysql> show create table monitoringservers\G
*************************** 1. row ***************************
Table: monitoringservers
Create Table: CREATE TABLE `monitoringservers` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(64) NOT NULL,
`host` int(11) default NULL,
`role` enum('Master','Slave') default 'Slave',
`activated` int(11) NOT NULL default '1',
`uncommitted` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`),
KEY `monitoringservers_host_fk` (`host`)
) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=latin1
1 row in set (0.01 sec)
_______________________________________________
Opsview-users mailing list
[email protected]
http://lists.opsview.org/listinfo/opsview-users
