order.lua 1.6 KB

12345678910111213141516171819202122232425262728293031323334353637383940
  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. self.id = id
  13. end
  14. function root:mysql_get_init_columns()
  15. return {
  16. id = "bigint(11) NOT NULL AUTO_INCREMENT COMMENT 'ID'",
  17. payName = "varchar(64) DEFAULT '' COMMENT '支付名称'",
  18. code = "varchar(128) DEFAULT '' COMMENT 'SDK支付方回调错误码'",
  19. uid = "int(11) NOT NULL COMMENT '用户id'",
  20. orderNo = "varchar(64) DEFAULT '' COMMENT '订单号'",
  21. diamond = "int(11) DEFAULT '0' COMMENT '钻石'",
  22. gold = "bigint(20) DEFAULT '0' COMMENT '金币'",
  23. gid = "int(10) DEFAULT NULL COMMENT '商品ID'",
  24. amount = "decimal(5,2) DEFAULT NULL COMMENT '订单金额,单位分'", -- 入库单位元
  25. time = "varchar(32) DEFAULT NULL COMMENT '订单时间'",
  26. createtime = "varchar(50) DEFAULT NULL COMMENT '支付服处理时间'",
  27. status = "tinyint(1) DEFAULT NULL COMMENT '订单状态:0手动发放订单,1游戏逻辑自动发放订单'",
  28. resMsg = "varchar(255) DEFAULT NULL COMMENT '注释'",
  29. channel = "int(11) DEFAULT 0 COMMENT '渠道'",
  30. type = "int(11) DEFAULT 0 COMMENT '支付类型'",
  31. readStatus = "int(11) DEFAULT 0 COMMENT '状态:1客户端是否已经被轮询获取'",
  32. cut = "tinyint(1) DEFAULT 0 COMMENT '状态: 1 订单扣除'",
  33. gameStatus = "tinyint(1) DEFAULT 0 COMMENT '游戏服处理:0未处理,1处理'"
  34. }
  35. end
  36. return root