Description:
when I run "show create table ge_usergroupmembers" in phpmyadmin , it return
"CREATE TABLE `ge_usergroupmembers` (
`id` int(10) unsigned NOT NULL auto_increment,
`employee` int(10) unsigned default NULL,
`groupMember` varchar(128) default NULL,
`userGroup` varchar(128) NOT NULL,
`start` datetime NOT NULL default '0000-00-00 00:00:00',
`end` datetime NOT NULL default '0000-00-00 00:00:00',
`role` varchar(127) NOT NULL,
`remark` varchar(255) NOT NULL,
`parse` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `employee_2` (`employee`,`userGroup`,`start`,`parse`),
KEY `userGroup` (`userGroup`),
KEY `employee` (`employee`),
KEY `groupMember` (`groupMember`),
KEY `parse` (`parse`),
CONSTRAINT `ge_usergroupmembers_ibfk_5` FOREIGN KEY (`employee`) REFERENCES `employee` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `ge_usergroupmembers_ibfk_6` FOREIGN KEY (`groupMember`) REFERENCES `ge_usergroups` (`name`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `ge_usergroupmembers_ibfk_7` FOREIGN KEY (`userGroup`) REFERENCES `ge_usergroups` (`name`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=gbk" ;
when I run "show table status like 'ge_usergroupmembers'" , the comment field is
InnoDB free: 8192 kB; (`employee`) REFER `suny3/employee`(`id`) ON UPDATE CASCAD
How to repeat:
every time
