99 lines
3.2 KiB
SQL
99 lines
3.2 KiB
SQL
CREATE DATABASE IF NOT EXISTS `storage_db`;
|
|
USE `storage_db`;
|
|
DROP TABLE IF EXISTS `storage_tbl`;
|
|
CREATE TABLE `storage_tbl`
|
|
(
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`commodity_code` varchar(255) DEFAULT NULL,
|
|
`count` int(11) DEFAULT 0,
|
|
PRIMARY KEY (`id`),
|
|
UNIQUE KEY (`commodity_code`)
|
|
) ENGINE = InnoDB
|
|
DEFAULT CHARSET = utf8;
|
|
INSERT INTO storage_tbl (commodity_code, count)
|
|
VALUES ('P0001', 100);
|
|
INSERT INTO storage_tbl (commodity_code, count)
|
|
VALUES ('B1234', 10);
|
|
|
|
-- 注意此处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;
|
|
|
|
CREATE DATABASE IF NOT EXISTS `order_db`;
|
|
USE `order_db`;
|
|
DROP TABLE IF EXISTS `order_tbl`;
|
|
CREATE TABLE `order_tbl`
|
|
(
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`user_id` varchar(255) DEFAULT NULL,
|
|
`commodity_code` varchar(255) DEFAULT NULL,
|
|
`count` int(11) DEFAULT 0,
|
|
`money` int(11) DEFAULT 0,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE = InnoDB
|
|
DEFAULT CHARSET = utf8;
|
|
-- 注意此处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;
|
|
|
|
CREATE DATABASE IF NOT EXISTS `account_db`;
|
|
USE `account_db`;
|
|
DROP TABLE IF EXISTS `account_tbl`;
|
|
CREATE TABLE `account_tbl`
|
|
(
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`user_id` varchar(255) DEFAULT NULL,
|
|
`money` int(11) DEFAULT 0,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE = InnoDB
|
|
DEFAULT CHARSET = utf8;
|
|
INSERT INTO account_tbl (user_id, money)
|
|
VALUES ('1', 10000);
|
|
-- 注意此处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; |