SQLite format 3 @ F ! F -' 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.12020-09-18 17:19:28н˼Ƽ˾
DB
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))
%' 316004207693762020-09-18 17:19:29 ! 1'3
3
/S101916004210198481600420769376S10192020-09-18 17:24:30buy115001500011002020-09-18 17:24:3098628273993119077GmEx++BbRSV9HRObr9oMNr9fHsz2VzVY3jBHBSYX8O3xqZhwiSdQXA==
5'39 3
/S1019W202009181720121600420769376S10192020-09-18 17:20:19{"uid":"S1019W20200918172012","trade_money":1500,"trade_payment":2,"trade_type":1,"project_name":"","trade_count":1,"trade_receive":1500,"trade_time":"2020-09-18 17:20:19","trade_paytime":"2020-09-18 17:20:19","enterprise_uid":"98628273993119001","store_uid":"98628273993119077","dev_id":"S1019","settle_sn":1600420769376,"member_uid":""}buy215001500000002020-09-18 17:20:1998628273993119077ukm0/Sp9LgofLmmP68K9pon0wPNmn3lIf8bAQ7G6i3jxqZh
|
='+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)
5S1019W202009181726021S101916004210198485 S1019W20200918172012
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))
1//E33 / 5A 3eS1019qzx16004208209862827399311900198628273993119077S1019s1019-001-s1019qzx160042082012020-09-18 17:20:202020-09-18 17:20:1998628273993119120S1019W2020091817201215001500ƱЧϡ2020-09-18 17:20:242{"ticket_no":"S1019qzx1600420820","dev_id":"S1019","enterprise_uid":"98628273993119001","store_uid":"98628273993119077","add_time":"2020-09-18 17:20:20","pay_time":"2020-09-18 17:20:19","product_uid":"98628273993119120","product_name":"","product_price":1500,"receive_money":1500,"trade_uid":"S1019W20200918172012","trade_payment":"2","download":"0","queue_number":1,"ticket_status":"0","buyer_id":"ooYIgv_aoTvMzF_xS2_IETQsLtaw","qr_code":"s1019-001-s1019qzx1600420820","enter_date":null,"lock_flag":"0","source":"","remark":"ƱЧϡ","product_quantity":1,"print_time":"2020-09-18 17:20:24"}3EDDJrzlIMvp5d56qxqjwgl5+SIxKODiF3caw11TLYbxqZh
| 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)
1S10194ab16004211703S1019160042107194721 S1019qzx1600420820
# g
systemSetUpϵͳ{"show_line_up":"TT","guide_open":true,"language":"zh-CN","theme":"black","sound_sex":0,"login_mode":1,"print_queue_number":true,"print_qr_code":true,"meal_mode_open":true,"seat_no_open":false,"price_show_plan":"2","call_line_type":"0","money_symbol":"","default_set":true,"guide_type":1,"voice_set":true,"attendanceCode_set":true,"Local_queue_number":"locality"} i)-Y
printFormatSetӡʽ{"print_type":"0","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} i# '
systemSetUpϵͳ{"show_line_up":"TT","guide_open":true,"language":"zh-CN","theme":"black","sound_sex":0,"login_mode":0,"print_queue_number":trueJ)-Y
printFormatSetӡʽ{"print_type":"0","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}# 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
^ ^ 1//E33 / 5A3eS1019qzx16004208209862827399311900198628273993119077S1019s1019-001-s1019qzx160042082012020-09-18 17:20:202020-09-18 17:20:1998628273993119120S1019W2020091817201215001500ƱЧϡ2020-09-18 18:04:542{"ticket_no":"S1019qzx1600420820","dev_id":"S1019","enterprise_uid":"98628273993119001","store_uid":"98628273993119077","add_time":"2020-09-18 17:20:20","pay_time":"2020-09-18 17:20:19","product_uid":"98628273993119120","product_name":"","product_price":1500,"receive_money":1500,"trade_uid":"S1019W20200918172012","trade_payment":"2","download":"0","queue_number":1,"ticket_status":"0","buyer_id":"ooYIgv_aoTvMzF_xS2_IETQsLtaw","qr_code":"s1019-001-s1019qzx1600420820","enter_date":null,"lock_flag":"0","source":"","remark":"ƱЧϡ","product_quantity":1,"print_time":"2020-09-18 18:04:54"}3EDDJrzlIMvp5d56qxqjwgl5+SIxKODiF3caw11TLYbxqZhwiSdQXA==
j j 3//G33 / 1A3MS1019160042107194729862827399311900198628273993119077S1019s1019-001-s10191600421071947222020-09-18 17:24:312020-09-18 17:24:3098628273993119120S1019160042101984815001500ƱЧϡ2020-09-18 18:04:521{"ticket_no":"S101916004210719472","dev_id":"S1019","enterprise_uid":"98628273993119001","store_uid":"98628273993119077","add_time":"2020-09-18 17:24:31","pay_time":"2020-09-18 17:24:30","product_uid":"98628273993119120","product_name":"","product_price":1500,"receive_money":1500,"trade_uid":"S10191600421019848","trade_payment":"1","download":"0","queue_number":2,"ticket_status":"0","buyer_id":"2088822323668734","qr_code":"s1019-001-s101916004210719472","enter_date":null,"lock_flag":"0","source":"","remark":"ƱЧϡ","product_quantity":1,"print_time":"2020-09-18 18:04:52"}3lOAFdZdKXGEVk3F9NMDTyyaovPg5xexMlJddPa89O7xqZhwiSdQXA==
5'39 3
/S1019W202009181720121600420769376S10192020-09-18 17:20:19{"uid":"S1019W20200918172012","trade_money":1500,"trade_payment":2,"trade_type":1,"project_name":"","trade_count":1,"trade_receive":1500,"trade_time":"2020-09-18 17:20:19","trade_paytime":"2020-09-18 17:20:19","enterprise_uid":"98628273993119001","store_uid":"98628273993119077","dev_id":"S1019","settle_sn":1600420769376,"member_uid":""}buy215001500000002020-09-18 17:20:1998628273993119077ukm0/Sp9LgofLmmP68K9pon0wPNmn3lIf8bAQ7G6i3jxqZhwiSdQXA==
# 5'3
3
/S1019W202009181726021600420769376S10192020-09-18 17:26:10buy215001500011002020-09-18 17:26:10986282739931190778BfeafhZk9o6kQHGlomm2SWJV6V5fPc3e+odJGOCZeXxqZhwiSdQXA==
1'35 3
/S101916004210198481600420769376S10192020-09-18 17:24:30{"uid":"S10191600421019848","trade_money":1500,"trade_payment":1,"trade_type":1,"project_name":"","trade_count":1,"trade_receive":1500,"trade_time":"2020-09-18 17:24:30","trade_paytime":"2020-09-18 17:24:30","enterprise_uid":"98628273993119001","store_uid":"98628273993119077","dev_id":"S1019","settle_sn":1600420769376,"member_uid":""}buy115001500000002020-09-18 17:24:3098628273993119077GmEx++BbRSV9HRObr9oMNr9fHsz2VzVY3jBHBSYX8O3xqZhwiSdQXA==
^ ^ 1//E33 / 5A3eS10194ab16004211709862827399311900198628273993119077S1019s1019-001-s10194ab160042117032020-09-18 17:26:102020-09-18 17:26:1098628273993119120S1019W2020091817260215001500ƱЧϡ2020-09-18 18:04:502{"ticket_no":"S10194ab1600421170","dev_id":"S1019","enterprise_uid":"98628273993119001","store_uid":"98628273993119077","add_time":"2020-09-18 17:26:10","pay_time":"2020-09-18 17:26:10","product_uid":"98628273993119120","product_name":"","product_price":1500,"receive_money":1500,"trade_uid":"S1019W20200918172602","trade_payment":"2","download":"0","queue_number":3,"ticket_status":"0","buyer_id":"ooYIgvzV9uoUpcJKizlt8nMvbnqs","qr_code":"s1019-001-s10194ab1600421170","enter_date":null,"lock_flag":"0","source":"","remark":"ƱЧϡ","product_quantity":1,"print_time":"2020-09-18 18:04:50"}7ajf3vjRyg8i/PqRtw1qdBVVyEHBNZUAKd+kM0hHGInxqZhwiSdQXA==
5'39 3
/S1019W202009181726021600420769376S10192020-09-18 17:26:10{"uid":"S1019W20200918172602","trade_money":1500,"trade_payment":2,"trade_type":1,"project_name":"","trade_count":1,"trade_receive":1500,"trade_time":"2020-09-18 17:26:10","trade_paytime":"2020-09-18 17:26:10","enterprise_uid":"98628273993119001","store_uid":"98628273993119077","dev_id":"S1019","settle_sn":1600420769376,"member_uid":""}buy215001500000002020-09-18 17:26:10986282739931190778BfeafhZk9o6kQHGlomm2SWJV6V5fPc3e+odJGOCZeXxqZhwiSdQXA==