order.lua 1.6 KB

123456789101112131415161718192021222324252627282930313233343536373839
  1. --[[
  2. Descripttion:支付订单模块
  3. version:
  4. Author: Neo,Huang
  5. Date: 2022-08-17 16:04:20
  6. LastEditors: Neo,Huang
  7. LastEditTime: 2022-09-05 10:05:30
  8. --]]
  9. local root = class("order", require("base.baseModule"))
  10. function root:ctor(id)
  11. root.super.ctor(self, id, "order", "id", true, false)
  12. end
  13. function root:mysql_get_init_columns()
  14. return {
  15. id = "bigint(11) NOT NULL AUTO_INCREMENT COMMENT 'ID'",
  16. payName = "varchar(64) DEFAULT '' COMMENT '支付名称'",
  17. code = "varchar(128) DEFAULT '' COMMENT 'SDK支付方回调错误码'",
  18. uid = "int(11) NOT NULL COMMENT '用户id'",
  19. orderNo = "varchar(64) DEFAULT '' COMMENT '订单号'",
  20. diamond = "int(11) DEFAULT '0' COMMENT '钻石'",
  21. gold = "bigint(20) DEFAULT '0' COMMENT '金币'",
  22. gid = "int(10) DEFAULT NULL COMMENT '商品ID'",
  23. amount = "decimal(5,2) DEFAULT NULL COMMENT '订单金额,单位分'", -- 入库单位元
  24. time = "varchar(32) DEFAULT NULL COMMENT '订单时间'",
  25. createtime = "varchar(50) DEFAULT NULL COMMENT '支付服处理时间'",
  26. status = "tinyint(1) DEFAULT NULL COMMENT '订单状态:0手动发放订单,1游戏逻辑自动发放订单'",
  27. resMsg = "varchar(255) DEFAULT NULL COMMENT '注释'",
  28. channel = "int(11) DEFAULT 0 COMMENT '渠道'",
  29. type = "int(11) DEFAULT 0 COMMENT '支付类型'",
  30. readStatus = "int(11) DEFAULT 0 COMMENT '状态:1客户端是否已经被轮询获取'",
  31. cut = "tinyint(1) DEFAULT 0 COMMENT '状态: 1 订单扣除'",
  32. gameStatus = "tinyint(1) DEFAULT 0 COMMENT '游戏服处理:0未处理,1处理'"
  33. }
  34. end
  35. return root