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_version
439DBV1.12025-03-17 08:29:37н˼Ƽ˾
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))
%' 317421713773412025-03-17 08:29:37
|
='+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)
| J c c G[5 indexsqlite_autoindex_js_trade_upload_info_1js_trade_upload_info
--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 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)
x/)3
wirelessNumberSetŶӺ{"init_date":"2025-03-17 08:29:37","min_Line_start_number":1,"line_start_number":1}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}# w
systemSetUpϵͳ{"show_line_up":"WX","guide_open":false,"language":"zh-CN","theme":"default","sound_sex":0,"login_mode":1,"print_queue_number":true,"print_qr_code":true,"meal_mode_open":false,"seat_no_open":false,"price_show_plan":0,"call_line_type":"0","guide_type":0,"voice_set":true,"money_symbol":"","attendanceCode_set":true,"default_set":true,"show_vip":true,"Local_queue_number":"locality","group_redeem":false,"face_pay":0,"print_settle":true,"print_trade_price":true,"print_team_price":true,"led_status":0}# passwordû123456û
/wirelessNumberSet)printFormatSet#systemSetUp password
--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