groupId: "org.hswebframework",
artifactId: "hsweb-payment-pay",
website: "http://payment.hsweb.io",
version: "1.0.1",//版本升级到1.0.1时执行
upgrade: function (context) {
var database = context.database;
database.createOrAlter("pay_order")
.addColumn().name("channel_provider").varchar(128).notNull().comment("渠道供应商").commit()
.addColumn().name("channel_provider_name").notNull().varchar(128).comment("渠道供应商名称").commit()
.comment("支付订单表").commit();
version: "1.0.2", //版本升级到1.0.2时执行
upgrade: function (context) {
var database = context.database;
database.createOrAlter("pay_order")
.addColumn().name("comment").varchar(2048).comment("说明").commit()
.comment("支付订单表").commit();
var JDBCType = java.sql.JDBCType;
function install(context) {
var database = context.database;
database.createOrAlter("pay_order")
.addColumn().name("id").varchar(32).notNull().primaryKey().comment("ID").commit()
.addColumn().name("order_id").varchar(128).notNull().comment("商户订单号").commit()
.addColumn().name("merchant_id").varchar(128).notNull().comment("商户ID").commit()
.addColumn().name("status").varchar(16).notNull().comment("订单状态").commit()
.index().name("idx_order_id").column("order_id").unique().commit()//订单号唯一索引
.index().name("idx_order_merchant_id").column("merchant_id").commit()
.comment("支付订单表").commit();
.onUpgrade(function (context) { //更新时执行
var upgrader = context.upgrader;
upgrader.filter(versions)
.upgrade(function (newVer) {
.onUninstall(function (context) { //卸载时执行
}).onInitialize(initialize); //初始化