Cacher is the code snippet organizer for pro developers

CREATE TABLE IF NOT EXISTS `meta` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `module_name` varchar(50) NOT NULL,
  `col_name` varchar(50) NOT NULL,
  `col_label` varchar(150) NOT NULL,
  `default` varchar(100) NOT NULL,
  `type` varchar(20) NOT NULL,
  `input` varchar(20) NOT NULL,
  `option` varchar(20) NOT NULL,
  `sorted` tinyint(4) NOT NULL,
  `ps` varchar(250) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `module_col` (`module_name`,`col_name`),
  KEY `module_name` (`module_name`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `targetTable_meta` (
  `meta_id` int(11) NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) NOT NULL,
  `last_ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `k` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `v` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`meta_id`),
  KEY `id` (`parent_id`),
  KEY `k` (`k`),
  KEY`uni_parent_key` ( `parent_id` , `k` ) 
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;