create table if not exists collection(
  id int not null AUTO_INCREMENT comment '序号ID',
  phoneid varchar(10) not null comment  '设备代号',
  method varchar(20) default '' comment '支付方式', 
  amount int comment '收款金额',  
  ctime int default 1 comment '收款时间',
  paytime varchar(100) default '' comment '支付时间',
  oid varchar(100) default '' comment '订单号',
  memo text default '' comment '备注',
  PRIMARY KEY(id)
)AUTO_INCREMENT=1 DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

create table if not exists payqrcode(
  id int not null AUTO_INCREMENT comment '序号ID',
  phoneid varchar(10) not null comment  '设备代号',
  method varchar(20) default '' comment '支付方式', 
  amount int default 0 comment '收款金额',  
  payurl varchar(100) default '' comment '收款链接',
  show_method int default 0 comment '显示方式:0-原码显示，1-转码显示',
  memo text default '' comment '备注',
  PRIMARY KEY(id)
)AUTO_INCREMENT=1 DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;


create table if not exists soft(
  id int not null AUTO_INCREMENT comment '序号ID',
  softname varchar(50) not null comment  '软件名称', 
  amount int default 0 comment '金额',  
  timeamount varchar(100) default '' comment '收款链接',
  memo text default '' comment '备注',
  PRIMARY KEY(id)
)AUTO_INCREMENT=1 DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
insert into soft(softname,amount,timeamount,memo) values('pdfconvert',100,20,'pdf转换器');