ubHL2ny0

1CREATE TABLE IF NOT EXISTS `agent_filter` (
2  `id` int(10) unsigned NOT NULL auto_increment,
3  `people_id` int(10) unsigned NOT NULL default '0',
4  `filter_set_id` int(10) unsigned NOT NULL default '0',
5  `filter_id` int(10) unsigned NOT NULL default '0',
6  `operator` enum('eq','ne','ge','le','nop') NOT NULL,
7  `value` varchar(32) NOT NULL default '',
8  `created_stamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
9  PRIMARY KEY  (`id`),
10  KEY `people_id` (`people_id`),
11  KEY `filter_set_id` (`filter_set_id`),
12  KEY `filter_id` (`filter_id`)
13) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=38339 ;