SQLite format 3 @ " " -' C-3indexpk_js_trade_receive_rv_guidjs_trade_receiveCREATE UNIQUE INDEX 'pk_js_trade_receive_rv_guid' on js_trade_receive (rv_guid ASC)B--7tablejs_trade_receivejs_trade_receiveCREATE 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)b## tablejs_dev_infojs_dev_infoCREATE TABLE js_dev_info (dev_id TEXT,data TEXT, add_time TEXT)''ktablejs_db_versionjs_db_versionCREATE TABLE js_db_version (appid text PRIMARY KEY not null,version text NOT NULL,updatetime text,remark text)9M' indexsqlite_autoindex_js_db_ve
439DBV1.12021-02-26 15:09:53н˼Ƽ˾
DB
U 33' 3
JS00051614323411747JS000516143234058491614323393860JS00052021-02-26 15:10:11
3 JS00051614323411747
u uIr ''ktablejs_db_versionjs_db_versionCREATE TABLE js_db_version (appid text PRIMARY KEY not null,version text NOT NULL,updatetime text,remark text)9M' indexsqlite_autoindex_js_db_version_1js_db_versionb## tablejs_dev_infojs_dev_infoCREATE TABLE js_dev_info (dev_id TEXT,data TEXT, add_time TEXT)B--7tablejs_trade_receivejs_trade_receiveCREATE 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) C-3indexpk_js_trade_receive_rv_guidjs_trade_receiveCREATE UNIQUE INDEX 'pk_js_trade_receive_rv_guid' on js_trade_receive (rv_guid ASC)
{ n++tablejs_trade_settlejs_trade_settleCREATE 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) 7+Aindexpk_js_trade_settle_snjs_trade_settle
CREATE UNIQUE INDEX 'pk_js_trade_settle_sn' on js_trade_settle (dev_id ASC, settle_sn ASC) Stablejs_settlejs_settle CREATE TABLE js_settle (settle_sn TEXT,settle_time TEXT,create_time TEXT,status INTEGER DEFAULT(0))
%' 316143233938602021-02-26 15:09:53
pi3'3] 3
/JS000516143234058491614323393860JS00052021-02-26 15:10:05ladyX1{"uid":"JS00051614323405849","trade_count":1,"trade_money":1,"trade_receive":100,"pay_status":1,"trade_status":1,"trade_payment":0,"trade_paytime":"2021-02-26 15:10:05","trade_type":1,"project_uid":"98628273991711677","project_name":"ladyX1","source":"","enterprise_uid":"24281991536967700","store_uid":"24281991536967701","dev_id":"JS0005","trade_time":"2021-02-26 15:10:05","settle_sn":1614323393860,"member_uid":""}buy01100000002021-02-26 15:10:0524281991536967701ERJlg/7/nIwARGvO9uew3HiEsgVryOM146E1OvOOROnxqZhwiSdQXA==
|
='+indexpk_js_trade_info_td_guidjs_trade_infoCREATE UNIQUE INDEX 'pk_js_trade_info_td_guid' ON js_trade_info ('td_guid' ASC)[ ''utablejs_trade_infojs_trade_info 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))
='+indexpk_js_trade_info_td_guidjs_trade_infoCREATE UNIQUE INDEX 'pk_js_trade_info_td_guid' ON js_trade_info ('td_guid' ASC)
3 JS00051614323405849
X 9 99
tablejs_client_trade_settlejs_client_trade_settleCREATE TABLE js_client_trade_settle (td_guid TEXT NOT NULL,dev_id text,settle_sn text,settle_time text,star9 99
tablejs_client_trade_settlejs_client_trade_settleCREATE 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))
m5//K33 1 3
3/JS0005161432341121002428199153696770024281991536967701JS0005js0005-001-js000516143234112100212021-02-26 15:10:112021-02-26 15:10:1198628273991711676fladyJS0005161432340584911002021-02-26 15:10:120{"ticket_no":"JS000516143234112100","trade_uid":"JS00051614323405849","product_uid":"98628273991711676f","product_name":"lady","product_quantity":1,"remark":"","product_price":1,"receive_money":100,"trade_payment":0,"ticket_status":1,"source":"","ticket_category":"0","use_timer":1,"expire_time":"2021-02-26 23:59:59","queue_number":21,"qr_code":"js0005-001-js000516143234112100","original_price":1,"enterprise_uid":"24281991536967700","store_uid":"24281991536967701","dev_id":"JS0005","add_time":"2021-02-26 15:10:11","print_time":"2021-02-26 15:10:12","pay_time":"2021-02-26 15:10:11"}c+OwWhEhE6mUzw3nvFRntff+4hWcqmE9pGjQNNz8W5jxqZhwiSdQXA==
| c c G[5 indexsqlite_autoindex_js_trade_upload_info_1js_trade_upload_info j
++ tablejs_trade_ticketjs_trade_ticketCREATE TA% O9Oindexpk_js_client_trade_settle_td_guidjs_client_trade_settleCREATE UNIQUE INDEX 'pk_js_client_trade_settle_td_guid' ON js_client_trade_settle ('td_guid' ASC)j
++ tablejs_trade_ticketjs_trade_ticketCREATE 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))7+-indexpk_js_trade_ticket_nojs_trade_ticketCREATE UNIQUE INDEX 'pk_js_trade_ticket_no' ON js_trade_ticket ('ticket_no' ASC)
5 JS000516143234112100
J)-Y
printFormatSetӡʽ{"print_type":"3","print_store_print_title":true,"print_qr_code":true,"print_queue_number":true,"print_product_name":true,"print_pay_type":true,"print_trade_no":true}l# 3
systemSetUpϵͳ{"show_line_up":"LL","guide_open":true,"language":"zh-CN","theme":"black","sound_sex":0,"login_mode":0,"print_queue_number":true,"print_qr_code":true,"meal_mode_open":true,"seat_no_open":false,"price_show_plan":1,"ali_send_key":{"instanceId":"post-cn-09k20cnrl07","accessKey":"LTAI4GJcAFcEowJ4hXMu7yAo","secretKey":"Eg08vVJUFUMaCZAp2BwLAzqUSm2H0i"},"call_line_type":"0","money_symbol":"","default_set":true,"guide_type":1,"voice_set":true,"attendanceCode_set":true}# passwordû123456û
)printFormatSet#systemSetUp password
q55tablejs_product_sell_lockjs_product_sell_lockCREATE 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)G[5 indexsqlite_autoindex_js_product_sell_lock_1js_product_sell_lock --itablejs_parameter_setjs_parameter_setCREATE TABLE js_parameter_set (name char(20) PRIMARY KEY NOT NULL,ch_name char(20),value text,notes char(50))?S- indexsqlite_autoindex_js_parameter_set_1js_parameter_set;55tablejs_trade_upload_infojs_trade_upload_infoCREATE TABLE js_trade_upload_info (trade_uid text PRIMARY KEY not null,upload_status text,dev_id TEXT, add_time TEXT,upload_time text)G[5 indexsqlite_autoindex_js_trade_upload_info_1js_trade_upload_info