app运营提示
#数据库 ucs
CREATE TABLE `tb_app_tips` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`company_name_digest` varchar(32) NOT NULL DEFAULT '',
`type` tinyint(1) NOT NULL,
`add_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`lastupdatetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`),
KEY `company_name_digest` (`company_name_digest`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8