lottery_db 60439179197CREATE TABLE `lottery` ( `id` bigint(20) NOT NULL COMMENT 'product_turn', `lottery_detail` blob COMMENT '[transection_id: 1, display_name: Ali, avatar: http://tronsis.com/images/abc.jpg, location: shenzhen guangdong, ip_address: 10.2.3.4, units: 5, time_stamp: 26, 2, 2016 3:45:45 GMT, lottery_numbers {1,2,3,4,5} ', `winner_lottery_number` varchar(20) COLLATE utf8_bin DEFAULT NULL, `winner` bigint(20) DEFAULT NULL, `winner_info` text COLLATE utf8_bin COMMENT 'wining user', `status_` varchar(20) COLLATE utf8_bin DEFAULT NULL, `timestamp_` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), CONSTRAINT `FK_lottery` FOREIGN KEY (`id`) REFERENCES `product_turn` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin 625678137214CREATE TABLE `product` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `name` varchar(100) COLLATE utf8_bin DEFAULT NULL, `icon` text COLLATE utf8_bin, `introduction` text COLLATE utf8_bin, `images` text COLLATE utf8_bin, `category` bigint(20) DEFAULT NULL, `status_` varchar(20) COLLATE utf8_bin DEFAULT 'active', `timestamp_` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_bin 358423143146CREATE TABLE `product_category` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `name` varchar(100) COLLATE utf8_bin DEFAULT NULL, `icon` blob, `status_` varchar(20) COLLATE utf8_bin DEFAULT 'active', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_bin 353581182333CREATE TABLE `product_turn` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `product_id` bigint(20) DEFAULT NULL, `product_name` varchar(100) COLLATE utf8_bin DEFAULT NULL, `product_icon` text COLLATE utf8_bin, `product_introduction` text COLLATE utf8_bin, `product_images` text COLLATE utf8_bin, `product_category` bigint(20) DEFAULT NULL, `turn_count` int(11) DEFAULT '1', `total_units` int(11) DEFAULT '0', `paid_units` int(11) DEFAULT '0', `turn_expiry` date DEFAULT NULL, `status_` varchar(20) COLLATE utf8_bin DEFAULT 'active' COMMENT 'active/computing/closed/expired', `count_down_delay` int(11) DEFAULT NULL COMMENT 'Seconds', `result_time` datetime DEFAULT NULL, `start_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `recommended_order` int(11) DEFAULT NULL, `modified_by` varchar(50) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_bin 677402117214CREATE TABLE `review_post` ( `id` bigint(20) NOT NULL COMMENT 'product_turn', `product_info` text COLLATE utf8_bin NOT NULL COMMENT 'json', `images` text COLLATE utf8_bin NOT NULL COMMENT 'json{images list}', `description` varchar(255) COLLATE utf8_bin NOT NULL, `user` bigint(20) NOT NULL, `liked_by` text COLLATE utf8_bin COMMENT 'json{user_ids}', `status_` varchar(20) COLLATE utf8_bin DEFAULT 'active', `timestamp_` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `FK_review_post_user` (`user`), CONSTRAINT `FK_review_post` FOREIGN KEY (`id`) REFERENCES `product_turn` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `FK_review_post_user` FOREIGN KEY (`user`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin 2726191180CREATE TABLE `sys_activity_and_news` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `preview_image` text COLLATE utf8_bin, `preview_summery` varchar(200) COLLATE utf8_bin DEFAULT NULL, `detail_info` text COLLATE utf8_bin, `type_` varchar(20) COLLATE utf8_bin DEFAULT 'news' COMMENT 'news/activity', `timestamp_` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_bin 35219166146CREATE TABLE `sys_coin_transection` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `coin_holder` bigint(20) DEFAULT NULL, `coin` int(11) DEFAULT NULL, `timestamp_` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin 24824113146CREATE TABLE `sys_faq` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `title` text COLLATE utf8_bin, `detail` text COLLATE utf8_bin, `timestamp_` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_bin 248189140163CREATE TABLE `sys_feedback` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `feedback_text` varchar(200) COLLATE utf8_bin DEFAULT NULL, `feedback_image` text COLLATE utf8_bin, `feedback_by` varchar(100) COLLATE utf8_bin DEFAULT NULL, `timestamp_` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COLLATE=utf8_bin 42013129180CREATE TABLE `sys_message` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `title` varchar(100) COLLATE utf8_bin DEFAULT NULL, `detail` text COLLATE utf8_bin, `icon` text COLLATE utf8_bin COMMENT 'BASE64', `message_type` varchar(20) COLLATE utf8_bin DEFAULT 'system' COMMENT 'system/delivery-message', `timestamp_` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_bin 416203189197CREATE TABLE `sys_payment_transection` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `paid_by` bigint(20) DEFAULT NULL, `thirdparty_name` varchar(50) COLLATE utf8_bin DEFAULT 'n/a' COMMENT 'wechat/alipay', `thirdparty_transection_id` varchar(100) COLLATE utf8_bin DEFAULT NULL, `amount` int(11) DEFAULT NULL COMMENT 'RMB , real money', `coins` int(11) DEFAULT NULL, `timestamp_` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin 1067254133311CREATE TABLE `user` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `username` varchar(20) COLLATE utf8_bin NOT NULL, `password` varchar(50) COLLATE utf8_bin NOT NULL, `real_name` varchar(50) COLLATE utf8_bin DEFAULT NULL, `display_picture` text COLLATE utf8_bin, `dob` date DEFAULT NULL, `gender` int(11) DEFAULT '0', `points` int(11) DEFAULT NULL, `coins` int(11) DEFAULT NULL COMMENT 'real money', `qq_address` varchar(20) COLLATE utf8_bin DEFAULT NULL, `phone_address` varchar(20) COLLATE utf8_bin DEFAULT NULL, `postal_address` text COLLATE utf8_bin COMMENT 'json:{name, phone, province, city, district, address, isDefault}', `status_` varchar(20) COLLATE utf8_bin DEFAULT 'active', `timestamp_` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `username_index` (`username`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_bin 1057593119163CREATE TABLE `user_cart` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `user` bigint(20) DEFAULT NULL, `product_turn` bigint(20) DEFAULT NULL, `units` int(11) DEFAULT NULL, `timestamp_` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `FK_cart` (`product_turn`), CONSTRAINT `FK_cart` FOREIGN KEY (`product_turn`) REFERENCES `product_turn` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_bin 1224367137129CREATE TABLE `user_share_log` ( `user_id` bigint(20) NOT NULL, `last_share_date` date DEFAULT NULL, `timestamp_` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin 1228208113146CREATE TABLE `user_token` ( `token` varchar(100) COLLATE utf8_bin NOT NULL, `user` bigint(20) DEFAULT NULL, `user_agent` varchar(100) COLLATE utf8_bin DEFAULT 'ios-UIODKJIERUI' COMMENT 'UDID/IMEI', `timestamp_` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`token`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin 1232520140180CREATE TABLE `user_wish_list` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `title` varchar(100) COLLATE utf8_bin DEFAULT NULL, `description` varchar(200) COLLATE utf8_bin DEFAULT NULL, `status_` varchar(20) COLLATE utf8_bin DEFAULT 'active', `created_by` bigint(20) DEFAULT NULL, `timestamp_` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COLLATE=utf8_bin 60648190248CREATE TABLE `winner_order` ( `id` bigint(20) NOT NULL COMMENT 'product_turn', `sn` varchar(20) COLLATE utf8_bin NOT NULL, `address` text COLLATE utf8_bin COMMENT 'json{Realname, address, district, city, province}', `units_by_winner` int(11) DEFAULT NULL, `status_` varchar(20) COLLATE utf8_bin DEFAULT 'win' COMMENT 'win/confirmed/shipped/received', `user` bigint(20) DEFAULT NULL COMMENT 'winning user id', `lottery` bigint(20) NOT NULL, `delivery_company_name` varchar(200) COLLATE utf8_bin DEFAULT NULL, `delivery_company_sn` varchar(100) COLLATE utf8_bin DEFAULT NULL, `timestamp_` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), CONSTRAINT `FK_winner_order` FOREIGN KEY (`id`) REFERENCES `product_turn` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin 57518225129CREATE TABLE `sys_search_keyword_frequency` ( `keyword` varchar(200) COLLATE utf8_bin NOT NULL, `frequency` int(11) DEFAULT NULL, `last_time_used` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`keyword`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin