gistfile1.sql

CREATE TABLE IF NOT EXISTS `agent_filter` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `people_id` int(10) unsigned NOT NULL default '0',
  `filter_set_id` int(10) unsigned NOT NULL default '0',
  `filter_id` int(10) unsigned NOT NULL default '0',
  `operator` enum('eq','ne','ge','le','nop') NOT NULL,
  `value` varchar(32) NOT NULL default '',
  `created_stamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
  PRIMARY KEY  (`id`),
  KEY `people_id` (`people_id`),
  KEY `filter_set_id` (`filter_set_id`),
  KEY `filter_id` (`filter_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=38339 ;