| /* |
| Navicat MySQL Data Transfer |
| |
| Source Server : account |
| Source Server Version : 50614 |
| Source Host : localhost:3306 |
| Source Database : db_gts_fescar |
| |
| Target Server Type : MYSQL |
| Target Server Version : 50614 |
| File Encoding : 65001 |
| |
| Date: 2019-01-26 10:23:10 |
| */ |
| |
| SET FOREIGN_KEY_CHECKS=0; |
| |
| -- ---------------------------- |
| -- Table structure for t_account |
| -- ---------------------------- |
| DROP TABLE IF EXISTS `t_account`; |
| CREATE TABLE `t_account` ( |
| `id` int(11) NOT NULL AUTO_INCREMENT, |
| `user_id` varchar(255) DEFAULT NULL, |
| `amount` double(14,2) DEFAULT '0.00', |
| PRIMARY KEY (`id`) |
| ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; |
| |
| -- ---------------------------- |
| -- Records of t_account |
| -- ---------------------------- |
| INSERT INTO `t_account` VALUES ('1', '1', '4000.00'); |
| |
| -- ---------------------------- |
| -- Table structure for t_order |
| -- ---------------------------- |
| DROP TABLE IF EXISTS `t_order`; |
| CREATE TABLE `t_order` ( |
| `id` int(11) NOT NULL AUTO_INCREMENT, |
| `order_no` varchar(255) DEFAULT NULL, |
| `user_id` varchar(255) DEFAULT NULL, |
| `commodity_code` varchar(255) DEFAULT NULL, |
| `count` int(11) DEFAULT '0', |
| `amount` double(14,2) DEFAULT '0.00', |
| PRIMARY KEY (`id`) |
| ) ENGINE=InnoDB AUTO_INCREMENT=64 DEFAULT CHARSET=utf8; |
| |
| -- ---------------------------- |
| -- Records of t_order |
| -- ---------------------------- |
| |
| -- ---------------------------- |
| -- Table structure for t_stock |
| -- ---------------------------- |
| DROP TABLE IF EXISTS `t_stock`; |
| CREATE TABLE `t_stock` ( |
| `id` int(11) NOT NULL AUTO_INCREMENT, |
| `commodity_code` varchar(255) DEFAULT NULL, |
| `name` varchar(255) DEFAULT NULL, |
| `count` int(11) DEFAULT '0', |
| PRIMARY KEY (`id`), |
| UNIQUE KEY `commodity_code` (`commodity_code`) |
| ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; |
| |
| -- ---------------------------- |
| -- Records of t_stock |
| -- ---------------------------- |
| INSERT INTO `t_stock` VALUES ('1', 'C201901140001', '水杯', '1000'); |
| |
| -- ---------------------------- |
| -- Table structure for undo_log |
| -- 注意此处0.3.0+ 增加唯一索引 ux_undo_log |
| -- ---------------------------- |
| DROP TABLE IF EXISTS `undo_log`; |
| CREATE TABLE `undo_log` ( |
| `id` bigint(20) NOT NULL AUTO_INCREMENT, |
| `branch_id` bigint(20) NOT NULL, |
| `xid` varchar(100) NOT NULL, |
| `context` varchar(128) NOT NULL, |
| `rollback_info` longblob NOT NULL, |
| `log_status` int(11) NOT NULL, |
| `log_created` datetime NOT NULL, |
| `log_modified` datetime NOT NULL, |
| `ext` varchar(100) DEFAULT NULL, |
| PRIMARY KEY (`id`), |
| UNIQUE KEY `ux_undo_log` (`xid`,`branch_id`) |
| ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8; |
| |
| -- ---------------------------- |
| -- Records of undo_log |
| -- ---------------------------- |
| SET FOREIGN_KEY_CHECKS=1; |