1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374 |
- SET NAMES utf8;
- SET FOREIGN_KEY_CHECKS = 0;
- DROP TABLE IF EXISTS `medal`;
- CREATE TABLE `medal` (
- `id` bigint(20) NOT NULL AUTO_INCREMENT,
- `name` varchar(255) DEFAULT NULL,
- `description` varchar(255) DEFAULT NULL,
- `img_url` varchar(255) DEFAULT NULL,
- `type` bigint(20) NOT NULL,
- `is_deleted` bit(1) NOT NULL,
- `create_time` datetime DEFAULT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- DROP TABLE IF EXISTS `user_2_integral`;
- CREATE TABLE `user_2_integral` (
- `id` bigint(20) NOT NULL AUTO_INCREMENT,
- `user_id` bigint(20) NOT NULL,
- `points` bigint(20) DEFAULT NULL,
- `type` bigint(20) DEFAULT NULL,
- `source` varchar(255) DEFAULT NULL,
- `create_time` datetime DEFAULT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
- DROP TABLE IF EXISTS `user_2_medal`;
- CREATE TABLE `user_2_medal` (
- `id` bigint(20) NOT NULL AUTO_INCREMENT,
- `user_id` bigint(20) NOT NULL,
- `medal_id` bigint(20) NOT NULL,
- `create_time` datetime DEFAULT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- DROP TABLE IF EXISTS `user_integral`;
- CREATE TABLE `user_integral` (
- `id` bigint(20) NOT NULL AUTO_INCREMENT,
- `user_id` bigint(20) NOT NULL,
- `total` bigint(20) DEFAULT NULL,
- `enabled` bit(1) NOT NULL,
- `create_time` datetime NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- SET FOREIGN_KEY_CHECKS = 1;
|