2023-07-26 10:14:27 异常 sqlite error!,msg=,sql=create table js_db_version (appid text PRIMARY KEY not null,version text NOT NULL,updatetime text,remark text)
2023-07-26 10:14:27 异常 sqlite error!,msg=,sql=CREATE TABLE js_dev_info (dev_id TEXT,data TEXT, add_time TEXT)
2023-07-26 10:14:27 异常 sqlite error!,msg=,sql=CREATE TABLE js_trade_receive (rv_guid TEXT,td_guid TEXT,settle_sn TEXT,dev_id TEXT, money_val INTEGER,money_qty INTEGER,ins_date TEXT,ins_user TEXT)
2023-07-26 10:14:27 异常 sqlite error!,msg=,sql=CREATE UNIQUE INDEX 'pk_js_trade_receive_rv_guid' on js_trade_receive (rv_guid ASC)
2023-07-26 10:14:27 异常 sqlite error!,msg=,sql=CREATE TABLE js_trade_settle (dev_id TEXT,settle_sn TEXT,settle_time TEXT,start_time TEXT,end_time TEXT,trade_count INTEGER DEFAULT(0),trade_qty INTEGER DEFAULT(0),trade_money INTEGER DEFAULT(0),trade_receive INTEGER DEFAULT(0),cash_receive INTEGER DEFAULT(0),bank_receive INTEGER DEFAULT(0),ali_receive INTEGER DEFAULT(0),wechat_receive INTEGER DEFAULT(0),member_receive INTEGER DEFAULT(0),trade_change INTEGER DEFAULT(0),ins_date TEXT,ins_user TEXT)
2023-07-26 10:14:27 异常 sqlite error!,msg=,sql=CREATE UNIQUE INDEX 'pk_js_trade_settle_sn' on js_trade_settle (dev_id ASC, settle_sn ASC)
2023-07-26 10:14:27 异常 sqlite error!,msg=,sql=CREATE TABLE js_settle (settle_sn TEXT,settle_time TEXT,create_time TEXT,status INTEGER DEFAULT(0))
2023-07-26 10:14:27 异常 sqlite error!,msg=,sql=CREATE TABLE js_trade_info (td_guid TEXT NOT NULL,settle_sn TEXT,dev_id TEXT,td_time TEXT,td_object TEXT,td_param TEXT,td_qty INTEGER,td_tradetype TEXT,td_paytype TEXT,td_money TEXT,td_receive TEXT,td_change TEXT,td_status TEXT DEFAULT('1100'),td_errcode TEXT,td_errmsg TEXT,ins_date TEXT,ins_user TEXT,settle_date TEXT,upload INTEGER DEFAULT (0),tautology INTEGER DEFAULT (0),store_uid TEXT,sign TEXT DEFAULT(null))
2023-07-26 10:14:27 异常 sqlite error!,msg=,sql=CREATE UNIQUE INDEX 'pk_js_trade_info_td_guid' ON js_trade_info ('td_guid' ASC)
2023-07-26 10:14:27 异常 sqlite error!,msg=,sql=CREATE TABLE js_client_trade_settle (td_guid TEXT NOT NULL,dev_id text,settle_sn text,settle_time text,start_time text,end_time text,trade_count INTEGER DEFAULT(0),trade_qty INTEGER DEFAULT(0),trade_money INTEGER DEFAULT(0),trade_receive INTEGER DEFAULT(0),trade_change INTEGER DEFAULT(0),add_time INTEGER DEFAULT(0),add_man text,wx_receive INTEGER DEFAULT(0),ali_receive INTEGER DEFAULT(0),mobile_receive INTEGER DEFAULT(0),cash_receive INTEGER DEFAULT(0),other_receive INTEGER DEFAULT(0),wx_refund INTEGER DEFAULT(0),ali_refund INTEGER DEFAULT(0),cash_refund INTEGER DEFAULT(0),mobile_refund INTEGER DEFAULT(0),other_refund INTEGER DEFAULT(0),refund_count INTEGER DEFAULT(0), all_refund INTEGER DEFAULT(0),member_refund INTEGER DEFAULT(0),upload INTEGER DEFAULT(0))
2023-07-26 10:14:27 异常 sqlite error!,msg=,sql=CREATE UNIQUE INDEX 'pk_js_client_trade_settle_td_guid' ON js_client_trade_settle ('td_guid' ASC)
2023-07-26 10:14:28 异常 sqlite error!,msg=,sql=CREATE TABLE js_trade_ticket (ticket_no text not null,enterprise_uid TEXT NOT NULL,store_uid TEXT,dev_id TEXT,qr_code text,queue_number text,add_time TEXT,pay_time TEXT,download_time TEXT,product_uid TEXT,product_quantity INTEGER DEFAULT(1),product_name text,trade_uid TEXT,product_price TEXT,receive_money TEXT,remark TEXT,source text,print_count INTEGER DEFAULT(0),print_time text,trade_payment text,data text,sign TEXT DEFAULT(null))
2023-07-26 10:14:28 异常 sqlite error!,msg=,sql=CREATE UNIQUE INDEX 'pk_js_trade_ticket_no' ON js_trade_ticket ('ticket_no' ASC)
2023-07-26 10:14:28 异常 sqlite error!,msg=,sql=create table js_parameter_set (name char(20) PRIMARY KEY NOT NULL,ch_name char(20),value text,notes char(50))
2023-07-26 10:14:28 异常 sqlite error!,msg=,sql=insert into js_parameter_set(name,ch_name,value,notes)values('password','用户密码','123456','用户密码')
2023-07-26 10:14:28 异常 sqlite error!,msg=,sql=CREATE TABLE js_trade_upload_info (trade_uid text PRIMARY KEY not null,upload_status text,dev_id TEXT, add_time TEXT,upload_time text)
2023-07-26 10:14:28 异常 sqlite error!,msg=,sql=CREATE TABLE js_product_sell_lock (td_guid text PRIMARY KEY NOT NULL,product_uid text,dev_id text,trade_uid text,ticket_count text,lock_flag text,enter_date text,add_time text,upload text)