X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 749B2D1C510 for ; Mon, 11 Aug 2003 14:16:27 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 99059-07 for ; Mon, 11 Aug 2003 11:14:50 -0300 (ADT) Received: from ucsns.ucs.co.za (ucs.co.za [196.23.43.2]) by svr1.postgresql.org (Postfix) with ESMTP id 1A82ED1C4E1 for ; Mon, 11 Aug 2003 11:14:26 -0300 (ADT) Received: from ucspost.ucs.co.za (mailgw1.ucs.co.za [196.23.43.253]) by ucsns.ucs.co.za (Postfix) with ESMTP id 713C72BDF7 for ; Mon, 11 Aug 2003 16:12:26 +0200 (SAST) Received: from jhb.ucs.co.za (jhb.ucs.co.za [172.31.1.3]) by ucspost.ucs.co.za (Postfix) with ESMTP id 2376CDA9F5 for ; Mon, 11 Aug 2003 15:58:42 +0200 (SAST) Received: from svb.ucs.co.za (svb.ucs.co.za [172.31.1.148]) by jhb.ucs.co.za (Postfix) with SMTP id BD2219737E for ; Mon, 11 Aug 2003 15:58:41 +0200 (SAST) Date: Mon, 11 Aug 2003 15:58:41 +0200 From: Stef To: pgsql-performance@postgresql.org Subject: Analyze makes queries slow... Message-Id: <20030811155841.483ffd93.svb@ucs.co.za> X-Mailer: Sylpheed version 0.9.4claws (GTK+ 1.2.10; i386-pc-linux-gnu) User-Agent: sillypheed-claws (anti-aliased) X-Face: LV^-*d3kQlL,6{Y:X)M~tuL#y!p.kO_Qbc!xxqhZC4s}Y]L0g)z^aiLsQGY34d|}Xp:HNm)MRsc?^?ZQ}smznF&jx|w@,a**K&QL.Dc~2~M5V`zb>hExCJDB[[o=M)e"; k-n[7tz2TY7+; *_xX's(5cUEtdw*yG-OmKm}6($zpUz8S`Nz@w X-Operating-System: sid X-X-X: _-^-_ Mime-Version: 1.0 Content-Type: multipart/mixed; boundary="Multipart_Mon__11_Aug_2003_15:58:41_+0200_084bd0a0" X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/167 X-Sequence-Number: 2984 This is a multi-part message in MIME format. --Multipart_Mon__11_Aug_2003_15:58:41_+0200_084bd0a0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Hi all, I posted this problem on the sql list, and was referred to this list in stead. I have attached an sql statement that normally runs under 3 minutes. That is, until I vacuum analyze the database (or just the tables in the query), then the same query runs longer than 12 hours, and I have to kill it. However 90% of queries are faster after analyzing on this database, there are two or three, including this one that takes for ever. I have tried to reverse engineer the explain plan from before analyzing, to come up with an sql statement, using proper joins, to force the planner to do the original join, but although I came close, I never got the same result as the original query. I suspect that this might be caused by some of the crazy indexes that were built on some of these tables, but I can't really do much about that, unless I can come up with a very good reason to nuke them. I also attached the "create table" statements for all the tables, as well as a row count of each. Can somebody help me with guidelines or something similar, to understand exactly what is happening in the explain plan. TIA Stefan --Multipart_Mon__11_Aug_2003_15:58:41_+0200_084bd0a0 Content-Type: text/plain; name="explain_after.txt" Content-Disposition: attachment; filename="explain_after.txt" Content-Transfer-Encoding: 7bit Aggregate (cost=52.00..61.64 rows=32 width=241) -> Group (cost=52.00..57.62 rows=321 width=241) -> Sort (cost=52.00..52.80 rows=321 width=241) Sort Key: m.group_code, m.sku, m.brn_code, m.stktype_code, ss.supplier_price_curr_cost, sk.sku_price_curr_cost -> Merge Join (cost=36.38..38.62 rows=321 width=241) Merge Cond: (("outer".group_cde = "inner".group_cde) AND ("outer".brn_code = "inner".brn_code)) Join Filter: (("outer".price_tmpl_hdr_cde = "inner".price_tmpl_hdr_cde) AND ("outer".price_tmpl_hdr_reg = "inner".price_tmpl_hdr_reg)) -> Nested Loop (cost=0.00..1407212.08 rows=63 width=179) Join Filter: (("inner".sku_mst_cde = "outer".sku) AND ("inner".group_cde = "outer".group_code)) -> Merge Join (cost=0.00..1405644.89 rows=315 width=135) Merge Cond: ("outer".group_code = "inner".group_code) Join Filter: ("outer".sku = "inner".sku) -> Nested Loop (cost=0.00..4826563.70 rows=8694 width=108) -> Index Scan using master_fpp_values_idx2 on master_fpp_values m (cost=0.00..3766902.34 rows=215650 width=54) Filter: (fpp_code = '200307'::text) -> Index Scan using pk_supplier_price on supplier_price ss (cost=0.00..4.90 rows=1 width=54) Index Cond: ((ss.group_cde = "outer".group_code) AND (ss.sku_mst_cde = "outer".sku) AND (ss.supplier_cde = "outer".supplier_code)) -> Index Scan using master_sku_descr_idx3 on master_sku_descr s (cost=0.00..2535.04 rows=10758 width=27) Filter: (control_code = '0'::text) -> Index Scan using idx_sku_price on sku_price sk (cost=0.00..4.96 rows=1 width=44) Index Cond: ((sk.group_cde = "outer".group_cde) AND (sk.sku_mst_cde = "outer".sku_mst_cde) AND (sk.price_tmpl_hdr_cde = "outer".price_tmpl_hdr_cde) AND (sk.price_tmpl_hdr_reg = "outer".price_tmpl_hdr_reg)) -> Sort (cost=36.38..36.87 rows=198 width=62) Sort Key: p.group_cde, p.branch_cde -> Hash Join (cost=18.46..28.82 rows=198 width=62) Hash Cond: ("outer".brn_code = "inner".branch_cde) -> Merge Join (cost=13.94..20.34 rows=198 width=33) Merge Cond: ("outer".country_code = "inner".from_ctry) -> Index Scan using master_branch_descr_idx4 on master_branch_descr b (cost=0.00..33.12 rows=198 width=15) -> Sort (cost=13.94..13.95 rows=4 width=18) Sort Key: f.from_ctry -> Index Scan using forex_idx1 on forex f (cost=0.00..13.90 rows=4 width=18) Index Cond: ((to_ctry = 'ZAF'::text) AND (fpp_code = '200307'::text)) -> Hash (cost=4.02..4.02 rows=202 width=29) -> Seq Scan on price_tmpl_det p (cost=0.00..4.02 rows=202 width=29) (34 rows) --Multipart_Mon__11_Aug_2003_15:58:41_+0200_084bd0a0 Content-Type: text/plain; name="explain_before.txt" Content-Disposition: attachment; filename="explain_before.txt" Content-Transfer-Encoding: 7bit Aggregate (cost=163.58..163.61 rows=1 width=699) -> Group (cost=163.58..163.60 rows=1 width=699) -> Sort (cost=163.58..163.58 rows=1 width=699) Sort Key: m.group_code, m.sku, m.brn_code, m.stktype_code, ss.supplier_price_curr_cost, sk.sku_price_curr_cost -> Nested Loop (cost=115.56..163.57 rows=1 width=699) Join Filter: (("outer".sku = "inner".sku) AND ("outer".group_code = "inner".group_code)) -> Nested Loop (cost=115.56..157.53 rows=1 width=635) Join Filter: (("inner".price_tmpl_hdr_cde = "outer".price_tmpl_hdr_cde) AND ("inner".price_tmpl_hdr_reg = "outer".price_tmpl_hdr_reg) AND ("inner".group_cde = "outer".group_cde)) -> Nested Loop (cost=115.56..152.49 rows=1 width=517) Join Filter: (("inner".group_cde = "outer".group_cde) AND ("inner".price_tmpl_hdr_cde = "outer".price_tmpl_hdr_cde) AND ("inner".price_tmpl_hdr_reg = "outer".price_tmpl_hdr_reg)) -> Hash Join (cost=115.56..147.45 rows=1 width=367) Hash Cond: ("outer".branch_cde = "inner".brn_code) Join Filter: ("inner".group_code = "outer".group_cde) -> Seq Scan on price_tmpl_det p (cost=0.00..20.00 rows=1000 width=100) -> Hash (cost=115.49..115.49 rows=25 width=267) -> Nested Loop (cost=0.00..115.49 rows=25 width=267) -> Nested Loop (cost=0.00..11.50 rows=1 width=115) -> Index Scan using forex_idx1 on forex f (cost=0.00..5.71 rows=1 width=51) Index Cond: ((to_ctry = 'ZAF'::text) AND (fpp_code = '200307'::text)) -> Index Scan using master_branch_descr_idx4 on master_branch_descr b (cost=0.00..5.78 rows=1 width=64) Index Cond: (b.country_code = "outer".from_ctry) -> Index Scan using master_fpp_values_uidx1 on master_fpp_values m (cost=0.00..103.68 rows=25 width=152) Index Cond: ((m.fpp_code = '200307'::text) AND (m.brn_code = "outer".brn_code)) -> Index Scan using pk_supplier_price on supplier_price ss (cost=0.00..5.02 rows=1 width=150) Index Cond: ((ss.group_cde = "outer".group_code) AND (ss.sku_mst_cde = "outer".sku) AND (ss.supplier_cde = "outer".supplier_code)) -> Index Scan using idx_sku_price on sku_price sk (cost=0.00..5.02 rows=1 width=118) Index Cond: ((sk.group_cde = "outer".group_cde) AND (sk.sku_mst_cde = "outer".sku_mst_cde) AND (sk.price_tmpl_hdr_cde = "outer".price_tmpl_hdr_cde) AND (sk.price_tmpl_hdr_reg = "outer".price_tmpl_hdr_reg)) -> Index Scan using master_sku_descr_idx1 on master_sku_descr s (cost=0.00..6.02 rows=1 width=64) Index Cond: (("outer".group_cde = s.group_code) AND ("outer".sku_mst_cde = s.sku) AND (s.control_code = '0'::text)) (29 rows) --Multipart_Mon__11_Aug_2003_15:58:41_+0200_084bd0a0 Content-Type: application/octet-stream; name="forex.sql" Content-Disposition: attachment; filename="forex.sql" Content-Transfer-Encoding: base64 LS0KLS0gUG9zdGdyZVNRTCBkYXRhYmFzZSBkdW1wCi0tCgpcY29ubmVjdCAt IHBvc3RncmVzCgpTRVQgc2VhcmNoX3BhdGggPSBwdWJsaWMsIHBnX2NhdGFs b2c7CgotLQotLSBUT0MgZW50cnkgMiAoT0lEIDgwMjg4MDQpCi0tIE5hbWU6 IGZvcmV4OyBUeXBlOiBUQUJMRTsgU2NoZW1hOiBwdWJsaWM7IE93bmVyOiBw b3N0Z3JlcwotLQoKQ1JFQVRFIFRBQkxFIGZvcmV4ICgKICAgIGZyb21fY3Ry eSB0ZXh0IE5PVCBOVUxMLAogICAgdG9fY3RyeSB0ZXh0IE5PVCBOVUxMLAog ICAgZnBwX2NvZGUgdGV4dCBOT1QgTlVMTCwKICAgIGRlc2NyIHRleHQsCiAg ICBpc19hY3RpdmUgYm9vbGVhbiwKICAgIHNlcSBpbnRlZ2VyLAogICAgcmF0 ZSBudW1lcmljKDE4LDEwKQopOwoKCi0tCi0tIFRPQyBlbnRyeSAzIChPSUQg ODAyODgwNCkKLS0gTmFtZTogZm9yZXg7IFR5cGU6IEFDTDsgU2NoZW1hOiBw dWJsaWM7IE93bmVyOiBwb3N0Z3JlcwotLQoKUkVWT0tFIEFMTCBPTiBUQUJM RSBmb3JleCBGUk9NIFBVQkxJQzsKR1JBTlQgQUxMIE9OIFRBQkxFIGZvcmV4 IFRPIFBVQkxJQzsKCgotLQotLSBUT0MgZW50cnkgNCAoT0lEIDg3ODA3MjIp Ci0tIE5hbWU6IGZvcmV4X2lkeDE7IFR5cGU6IElOREVYOyBTY2hlbWE6IHB1 YmxpYzsgT3duZXI6IHBvc3RncmVzCi0tCgpDUkVBVEUgSU5ERVggZm9yZXhf aWR4MSBPTiBmb3JleCBVU0lORyBidHJlZSAodG9fY3RyeSwgZnBwX2NvZGUp OwoKCi0tCi0tIFRPQyBlbnRyeSA1IChPSUQgODAyODgwOSkKLS0gTmFtZTog Zm9yZXhfcGs7IFR5cGU6IENPTlNUUkFJTlQ7IFNjaGVtYTogcHVibGljOyBP d25lcjogcG9zdGdyZXMKLS0KCkFMVEVSIFRBQkxFIE9OTFkgZm9yZXgKICAg IEFERCBDT05TVFJBSU5UIGZvcmV4X3BrIFBSSU1BUlkgS0VZIChmcm9tX2N0 cnksIHRvX2N0cnksIGZwcF9jb2RlKTsKCgotLQotLSBUT0MgZW50cnkgNiAo T0lEIDgwMjg4MTEpCi0tIE5hbWU6IGZvcmV4X2Zyb21fY3RyeV9mazsgVHlw ZTogQ09OU1RSQUlOVDsgU2NoZW1hOiBwdWJsaWM7IE93bmVyOiBwb3N0Z3Jl cwotLQoKQUxURVIgVEFCTEUgT05MWSBmb3JleAogICAgQUREIENPTlNUUkFJ TlQgZm9yZXhfZnJvbV9jdHJ5X2ZrIEZPUkVJR04gS0VZIChmcm9tX2N0cnkp IFJFRkVSRU5DRVMgY291bnRyeShjb2RlKSBPTiBVUERBVEUgTk8gQUNUSU9O IE9OIERFTEVURSBOTyBBQ1RJT047CgoKLS0KLS0gVE9DIGVudHJ5IDcgKE9J RCA4MDI4ODE1KQotLSBOYW1lOiBmb3JleF90b19jdHJ5X2ZrOyBUeXBlOiBD T05TVFJBSU5UOyBTY2hlbWE6IHB1YmxpYzsgT3duZXI6IHBvc3RncmVzCi0t CgpBTFRFUiBUQUJMRSBPTkxZIGZvcmV4CiAgICBBREQgQ09OU1RSQUlOVCBm b3JleF90b19jdHJ5X2ZrIEZPUkVJR04gS0VZICh0b19jdHJ5KSBSRUZFUkVO Q0VTIGNvdW50cnkoY29kZSkgT04gVVBEQVRFIE5PIEFDVElPTiBPTiBERUxF VEUgTk8gQUNUSU9OOwoKCi0tCi0tIFRPQyBlbnRyeSA4IChPSUQgODAyODgx OSkKLS0gTmFtZTogZm9yZXhfZnBwX2ZrOyBUeXBlOiBDT05TVFJBSU5UOyBT Y2hlbWE6IHB1YmxpYzsgT3duZXI6IHBvc3RncmVzCi0tCgpBTFRFUiBUQUJM RSBPTkxZIGZvcmV4CiAgICBBREQgQ09OU1RSQUlOVCBmb3JleF9mcHBfZmsg Rk9SRUlHTiBLRVkgKGZwcF9jb2RlKSBSRUZFUkVOQ0VTIGZwcChjb2RlKSBP TiBVUERBVEUgTk8gQUNUSU9OIE9OIERFTEVURSBOTyBBQ1RJT047CgoK --Multipart_Mon__11_Aug_2003_15:58:41_+0200_084bd0a0 Content-Type: application/octet-stream; name="master_branch_descr.sql" Content-Disposition: attachment; filename="master_branch_descr.sql" Content-Transfer-Encoding: base64 LS0KLS0gUG9zdGdyZVNRTCBkYXRhYmFzZSBkdW1wCi0tCgpcY29ubmVjdCAt IHBvc3RncmVzCgpTRVQgc2VhcmNoX3BhdGggPSBwdWJsaWMsIHBnX2NhdGFs b2c7CgotLQotLSBUT0MgZW50cnkgMiAoT0lEIDg4Njc0MjcpCi0tIE5hbWU6 IG1hc3Rlcl9icmFuY2hfZGVzY3I7IFR5cGU6IFRBQkxFOyBTY2hlbWE6IHB1 YmxpYzsgT3duZXI6IHBvc3RncmVzCi0tCgpDUkVBVEUgVEFCTEUgbWFzdGVy X2JyYW5jaF9kZXNjciAoCiAgICBicm5fY29kZSB0ZXh0IE5PVCBOVUxMLAog ICAgYnJuX2Rlc2NyIHRleHQsCiAgICBjb3VudHJ5X2NvZGUgdGV4dCwKICAg IGNvdW50cnlfZGVzY3IgdGV4dCwKICAgIGNsdXN0ZXJfY29kZSB0ZXh0LAog ICAgY2x1c3Rlcl9kZXNjciB0ZXh0LAogICAgYnJhbmRfY29kZSB0ZXh0LAog ICAgYnJhbmRfZGVzY3IgdGV4dCwKICAgIGNoYWluX2NvZGUgdGV4dCwKICAg IGNoYWluX2Rlc2NyIHRleHQsCiAgICBzYnVfY29kZSB0ZXh0LAogICAgc2J1 X2Rlc2NyIHRleHQsCiAgICBncm91cF9jb2RlIHRleHQsCiAgICBncm91cF9k ZXNjciB0ZXh0LAogICAgcmVnaW9uX2NvZGUgdGV4dCwKICAgIHJlZ2lvbl9k ZXNjciB0ZXh0LAogICAgZGl2aXNpb25fY29kZSB0ZXh0LAogICAgZGl2aXNp b25fZGVzY3IgdGV4dAopOwoKCi0tCi0tIFRPQyBlbnRyeSAyMyAoT0lEIDg4 Njc2MzIpCi0tIE5hbWU6IG1hc3Rlcl9icmFuY2hfZGVzY3JfdWlkeDE7IFR5 cGU6IElOREVYOyBTY2hlbWE6IHB1YmxpYzsgT3duZXI6IHBvc3RncmVzCi0t CgpDUkVBVEUgVU5JUVVFIElOREVYIG1hc3Rlcl9icmFuY2hfZGVzY3JfdWlk eDEgT04gbWFzdGVyX2JyYW5jaF9kZXNjciBVU0lORyBidHJlZSAoYnJuX2Nv ZGUpOwoKCi0tCi0tIFRPQyBlbnRyeSAyNCAoT0lEIDg4Njc2MzMpCi0tIE5h bWU6IG1hc3Rlcl9icmFuY2hfZGVzY3JfdWlkeDI7IFR5cGU6IElOREVYOyBT Y2hlbWE6IHB1YmxpYzsgT3duZXI6IHBvc3RncmVzCi0tCgpDUkVBVEUgVU5J UVVFIElOREVYIG1hc3Rlcl9icmFuY2hfZGVzY3JfdWlkeDIgT04gbWFzdGVy X2JyYW5jaF9kZXNjciBVU0lORyBidHJlZSAoYnJuX2NvZGUsIGJybl9kZXNj cik7CgoKLS0KLS0gVE9DIGVudHJ5IDMgKE9JRCA4ODY3NjM0KQotLSBOYW1l OiBtYXN0ZXJfYnJhbmNoX2Rlc2NyX2lkeDE7IFR5cGU6IElOREVYOyBTY2hl bWE6IHB1YmxpYzsgT3duZXI6IHBvc3RncmVzCi0tCgpDUkVBVEUgSU5ERVgg bWFzdGVyX2JyYW5jaF9kZXNjcl9pZHgxIE9OIG1hc3Rlcl9icmFuY2hfZGVz Y3IgVVNJTkcgYnRyZWUgKGJybl9jb2RlLCBicm5fZGVzY3IsIGNvdW50cnlf Y29kZSwgY291bnRyeV9kZXNjcik7CgoKLS0KLS0gVE9DIGVudHJ5IDE0IChP SUQgODg2NzYzNSkKLS0gTmFtZTogbWFzdGVyX2JyYW5jaF9kZXNjcl9pZHgy OyBUeXBlOiBJTkRFWDsgU2NoZW1hOiBwdWJsaWM7IE93bmVyOiBwb3N0Z3Jl cwotLQoKQ1JFQVRFIElOREVYIG1hc3Rlcl9icmFuY2hfZGVzY3JfaWR4MiBP TiBtYXN0ZXJfYnJhbmNoX2Rlc2NyIFVTSU5HIGJ0cmVlIChicm5fY29kZSwg YnJuX2Rlc2NyLCBjbHVzdGVyX2NvZGUsIGNsdXN0ZXJfZGVzY3IpOwoKCi0t Ci0tIFRPQyBlbnRyeSAxNSAoT0lEIDg4Njc2MzYpCi0tIE5hbWU6IG1hc3Rl cl9icmFuY2hfZGVzY3JfaWR4MzsgVHlwZTogSU5ERVg7IFNjaGVtYTogcHVi bGljOyBPd25lcjogcG9zdGdyZXMKLS0KCkNSRUFURSBJTkRFWCBtYXN0ZXJf YnJhbmNoX2Rlc2NyX2lkeDMgT04gbWFzdGVyX2JyYW5jaF9kZXNjciBVU0lO RyBidHJlZSAoYnJuX2Rlc2NyLCBicm5fY29kZSk7CgoKLS0KLS0gVE9DIGVu dHJ5IDE2IChPSUQgODg2NzYzNykKLS0gTmFtZTogbWFzdGVyX2JyYW5jaF9k ZXNjcl9pZHg0OyBUeXBlOiBJTkRFWDsgU2NoZW1hOiBwdWJsaWM7IE93bmVy OiBwb3N0Z3JlcwotLQoKQ1JFQVRFIElOREVYIG1hc3Rlcl9icmFuY2hfZGVz Y3JfaWR4NCBPTiBtYXN0ZXJfYnJhbmNoX2Rlc2NyIFVTSU5HIGJ0cmVlIChj b3VudHJ5X2NvZGUsIGJybl9jb2RlKTsKCgotLQotLSBUT0MgZW50cnkgMTcg KE9JRCA4ODY3NjM4KQotLSBOYW1lOiBtYXN0ZXJfYnJhbmNoX2Rlc2NyX2lk eDU7IFR5cGU6IElOREVYOyBTY2hlbWE6IHB1YmxpYzsgT3duZXI6IHBvc3Rn cmVzCi0tCgpDUkVBVEUgSU5ERVggbWFzdGVyX2JyYW5jaF9kZXNjcl9pZHg1 IE9OIG1hc3Rlcl9icmFuY2hfZGVzY3IgVVNJTkcgYnRyZWUgKGNvdW50cnlf ZGVzY3IsIGJybl9jb2RlKTsKCgotLQotLSBUT0MgZW50cnkgMTggKE9JRCA4 ODY3NjM5KQotLSBOYW1lOiBtYXN0ZXJfYnJhbmNoX2Rlc2NyX2lkeDY7IFR5 cGU6IElOREVYOyBTY2hlbWE6IHB1YmxpYzsgT3duZXI6IHBvc3RncmVzCi0t CgpDUkVBVEUgSU5ERVggbWFzdGVyX2JyYW5jaF9kZXNjcl9pZHg2IE9OIG1h c3Rlcl9icmFuY2hfZGVzY3IgVVNJTkcgYnRyZWUgKGNsdXN0ZXJfY29kZSwg YnJuX2NvZGUpOwoKCi0tCi0tIFRPQyBlbnRyeSAxOSAoT0lEIDg4Njc2NDAp Ci0tIE5hbWU6IG1hc3Rlcl9icmFuY2hfZGVzY3JfaWR4NzsgVHlwZTogSU5E RVg7IFNjaGVtYTogcHVibGljOyBPd25lcjogcG9zdGdyZXMKLS0KCkNSRUFU RSBJTkRFWCBtYXN0ZXJfYnJhbmNoX2Rlc2NyX2lkeDcgT04gbWFzdGVyX2Jy YW5jaF9kZXNjciBVU0lORyBidHJlZSAoY2x1c3Rlcl9kZXNjciwgYnJuX2Nv ZGUpOwoKCi0tCi0tIFRPQyBlbnRyeSAyMCAoT0lEIDg4Njc2NDEpCi0tIE5h bWU6IG1hc3Rlcl9icmFuY2hfZGVzY3JfaWR4ODsgVHlwZTogSU5ERVg7IFNj aGVtYTogcHVibGljOyBPd25lcjogcG9zdGdyZXMKLS0KCkNSRUFURSBJTkRF WCBtYXN0ZXJfYnJhbmNoX2Rlc2NyX2lkeDggT04gbWFzdGVyX2JyYW5jaF9k ZXNjciBVU0lORyBidHJlZSAoYnJhbmRfY29kZSwgYnJuX2NvZGUpOwoKCi0t Ci0tIFRPQyBlbnRyeSAyMSAoT0lEIDg4Njc2NDIpCi0tIE5hbWU6IG1hc3Rl cl9icmFuY2hfZGVzY3JfaWR4OTsgVHlwZTogSU5ERVg7IFNjaGVtYTogcHVi bGljOyBPd25lcjogcG9zdGdyZXMKLS0KCkNSRUFURSBJTkRFWCBtYXN0ZXJf YnJhbmNoX2Rlc2NyX2lkeDkgT04gbWFzdGVyX2JyYW5jaF9kZXNjciBVU0lO RyBidHJlZSAoYnJhbmRfZGVzY3IsIGJybl9jb2RlKTsKCgotLQotLSBUT0Mg ZW50cnkgNCAoT0lEIDg4Njc2NDMpCi0tIE5hbWU6IG1hc3Rlcl9icmFuY2hf ZGVzY3JfaWR4MTA7IFR5cGU6IElOREVYOyBTY2hlbWE6IHB1YmxpYzsgT3du ZXI6IHBvc3RncmVzCi0tCgpDUkVBVEUgSU5ERVggbWFzdGVyX2JyYW5jaF9k ZXNjcl9pZHgxMCBPTiBtYXN0ZXJfYnJhbmNoX2Rlc2NyIFVTSU5HIGJ0cmVl IChjaGFpbl9jb2RlLCBicm5fY29kZSk7CgoKLS0KLS0gVE9DIGVudHJ5IDUg KE9JRCA4ODY3NjQ0KQotLSBOYW1lOiBtYXN0ZXJfYnJhbmNoX2Rlc2NyX2lk eDExOyBUeXBlOiBJTkRFWDsgU2NoZW1hOiBwdWJsaWM7IE93bmVyOiBwb3N0 Z3JlcwotLQoKQ1JFQVRFIElOREVYIG1hc3Rlcl9icmFuY2hfZGVzY3JfaWR4 MTEgT04gbWFzdGVyX2JyYW5jaF9kZXNjciBVU0lORyBidHJlZSAoY2hhaW5f ZGVzY3IsIGJybl9jb2RlKTsKCgotLQotLSBUT0MgZW50cnkgNiAoT0lEIDg4 Njc2NDUpCi0tIE5hbWU6IG1hc3Rlcl9icmFuY2hfZGVzY3JfaWR4MTI7IFR5 cGU6IElOREVYOyBTY2hlbWE6IHB1YmxpYzsgT3duZXI6IHBvc3RncmVzCi0t CgpDUkVBVEUgSU5ERVggbWFzdGVyX2JyYW5jaF9kZXNjcl9pZHgxMiBPTiBt YXN0ZXJfYnJhbmNoX2Rlc2NyIFVTSU5HIGJ0cmVlIChzYnVfY29kZSwgYnJu X2NvZGUpOwoKCi0tCi0tIFRPQyBlbnRyeSA3IChPSUQgODg2NzY0NikKLS0g TmFtZTogbWFzdGVyX2JyYW5jaF9kZXNjcl9pZHgxMzsgVHlwZTogSU5ERVg7 IFNjaGVtYTogcHVibGljOyBPd25lcjogcG9zdGdyZXMKLS0KCkNSRUFURSBJ TkRFWCBtYXN0ZXJfYnJhbmNoX2Rlc2NyX2lkeDEzIE9OIG1hc3Rlcl9icmFu Y2hfZGVzY3IgVVNJTkcgYnRyZWUgKHNidV9kZXNjciwgYnJuX2NvZGUpOwoK Ci0tCi0tIFRPQyBlbnRyeSA4IChPSUQgODg2NzY0NykKLS0gTmFtZTogbWFz dGVyX2JyYW5jaF9kZXNjcl9pZHgxNDsgVHlwZTogSU5ERVg7IFNjaGVtYTog cHVibGljOyBPd25lcjogcG9zdGdyZXMKLS0KCkNSRUFURSBJTkRFWCBtYXN0 ZXJfYnJhbmNoX2Rlc2NyX2lkeDE0IE9OIG1hc3Rlcl9icmFuY2hfZGVzY3Ig VVNJTkcgYnRyZWUgKGdyb3VwX2NvZGUsIGJybl9jb2RlKTsKCgotLQotLSBU T0MgZW50cnkgOSAoT0lEIDg4Njc2NDgpCi0tIE5hbWU6IG1hc3Rlcl9icmFu Y2hfZGVzY3JfaWR4MTU7IFR5cGU6IElOREVYOyBTY2hlbWE6IHB1YmxpYzsg T3duZXI6IHBvc3RncmVzCi0tCgpDUkVBVEUgSU5ERVggbWFzdGVyX2JyYW5j aF9kZXNjcl9pZHgxNSBPTiBtYXN0ZXJfYnJhbmNoX2Rlc2NyIFVTSU5HIGJ0 cmVlIChncm91cF9kZXNjciwgYnJuX2NvZGUpOwoKCi0tCi0tIFRPQyBlbnRy eSAxMCAoT0lEIDg4Njc2NDkpCi0tIE5hbWU6IG1hc3Rlcl9icmFuY2hfZGVz Y3JfaWR4MTY7IFR5cGU6IElOREVYOyBTY2hlbWE6IHB1YmxpYzsgT3duZXI6 IHBvc3RncmVzCi0tCgpDUkVBVEUgSU5ERVggbWFzdGVyX2JyYW5jaF9kZXNj cl9pZHgxNiBPTiBtYXN0ZXJfYnJhbmNoX2Rlc2NyIFVTSU5HIGJ0cmVlIChy ZWdpb25fY29kZSwgYnJuX2NvZGUpOwoKCi0tCi0tIFRPQyBlbnRyeSAxMSAo T0lEIDg4Njc2NTApCi0tIE5hbWU6IG1hc3Rlcl9icmFuY2hfZGVzY3JfaWR4 MTc7IFR5cGU6IElOREVYOyBTY2hlbWE6IHB1YmxpYzsgT3duZXI6IHBvc3Rn cmVzCi0tCgpDUkVBVEUgSU5ERVggbWFzdGVyX2JyYW5jaF9kZXNjcl9pZHgx NyBPTiBtYXN0ZXJfYnJhbmNoX2Rlc2NyIFVTSU5HIGJ0cmVlIChyZWdpb25f ZGVzY3IsIGJybl9jb2RlKTsKCgotLQotLSBUT0MgZW50cnkgMTIgKE9JRCA4 ODY3NjUxKQotLSBOYW1lOiBtYXN0ZXJfYnJhbmNoX2Rlc2NyX2lkeDE4OyBU eXBlOiBJTkRFWDsgU2NoZW1hOiBwdWJsaWM7IE93bmVyOiBwb3N0Z3Jlcwot LQoKQ1JFQVRFIElOREVYIG1hc3Rlcl9icmFuY2hfZGVzY3JfaWR4MTggT04g bWFzdGVyX2JyYW5jaF9kZXNjciBVU0lORyBidHJlZSAoZGl2aXNpb25fY29k ZSwgYnJuX2NvZGUpOwoKCi0tCi0tIFRPQyBlbnRyeSAxMyAoT0lEIDg4Njc2 NTIpCi0tIE5hbWU6IG1hc3Rlcl9icmFuY2hfZGVzY3JfaWR4MTk7IFR5cGU6 IElOREVYOyBTY2hlbWE6IHB1YmxpYzsgT3duZXI6IHBvc3RncmVzCi0tCgpD UkVBVEUgSU5ERVggbWFzdGVyX2JyYW5jaF9kZXNjcl9pZHgxOSBPTiBtYXN0 ZXJfYnJhbmNoX2Rlc2NyIFVTSU5HIGJ0cmVlIChkaXZpc2lvbl9kZXNjciwg YnJuX2NvZGUpOwoKCi0tCi0tIFRPQyBlbnRyeSAyMiAoT0lEIDg4Njc0MzIp Ci0tIE5hbWU6IG1hc3Rlcl9icmFuY2hfZGVzY3JfcGtleTsgVHlwZTogQ09O U1RSQUlOVDsgU2NoZW1hOiBwdWJsaWM7IE93bmVyOiBwb3N0Z3JlcwotLQoK QUxURVIgVEFCTEUgT05MWSBtYXN0ZXJfYnJhbmNoX2Rlc2NyCiAgICBBREQg Q09OU1RSQUlOVCBtYXN0ZXJfYnJhbmNoX2Rlc2NyX3BrZXkgUFJJTUFSWSBL RVkgKGJybl9jb2RlKTsKCgo= --Multipart_Mon__11_Aug_2003_15:58:41_+0200_084bd0a0 Content-Type: application/octet-stream; name="master_fpp_values.sql" Content-Disposition: attachment; filename="master_fpp_values.sql" Content-Transfer-Encoding: base64 LS0KLS0gUG9zdGdyZVNRTCBkYXRhYmFzZSBkdW1wCi0tCgpcY29ubmVjdCAt IHBvc3RncmVzCgpTRVQgc2VhcmNoX3BhdGggPSBwdWJsaWMsIHBnX2NhdGFs b2c7CgotLQotLSBUT0MgZW50cnkgMiAoT0lEIDE3MTUwKQotLSBOYW1lOiBt YXN0ZXJfZnBwX3ZhbHVlczsgVHlwZTogVEFCTEU7IFNjaGVtYTogcHVibGlj OyBPd25lcjogcG9zdGdyZXMKLS0KCkNSRUFURSBUQUJMRSBtYXN0ZXJfZnBw X3ZhbHVlcyAoCiAgICBmcHBfY29kZSB0ZXh0IE5PVCBOVUxMLAogICAgYnJu X2NvZGUgdGV4dCBOT1QgTlVMTCwKICAgIHNrdSB0ZXh0IE5PVCBOVUxMLAog ICAgZ3JvdXBfY29kZSB0ZXh0IE5PVCBOVUxMLAogICAgc3RrdHlwZV9jb2Rl IGNoYXJhY3RlciB2YXJ5aW5nKDIpLAogICAgc3VwcGxpZXJfY29kZSB0ZXh0 LAogICAgbXRoX3Nsc19xdHlfMDEgbnVtZXJpYygxNiwzKSwKICAgIG10aF9z bHNfcXR5XzAyIG51bWVyaWMoMTYsMyksCiAgICBtdGhfc2xzX3F0eV8wMyBu dW1lcmljKDE2LDMpLAogICAgbXRoX3Nsc19xdHlfMDQgbnVtZXJpYygxNiwz KSwKICAgIG10aF9zbHNfcXR5XzA1IG51bWVyaWMoMTYsMyksCiAgICBtdGhf c2xzX3F0eV8wNiBudW1lcmljKDE2LDMpLAogICAgbXRoX3Nsc19xdHlfMDcg bnVtZXJpYygxNiwzKSwKICAgIG10aF9zbHNfcXR5XzA4IG51bWVyaWMoMTYs MyksCiAgICBtdGhfc2xzX3F0eV8wOSBudW1lcmljKDE2LDMpLAogICAgbXRo X3Nsc19xdHlfMTAgbnVtZXJpYygxNiwzKSwKICAgIG10aF9zbHNfcXR5XzEx IG51bWVyaWMoMTYsMyksCiAgICBtdGhfc2xzX3F0eV8xMiBudW1lcmljKDE2 LDMpLAogICAgcXR5X29uX2hhbmRfMDEgbnVtZXJpYygxNiwzKSwKICAgIHF0 eV9vbl9oYW5kXzAyIG51bWVyaWMoMTYsMyksCiAgICBxdHlfb25faGFuZF8w MyBudW1lcmljKDE2LDMpLAogICAgcXR5X29uX2hhbmRfMDQgbnVtZXJpYygx NiwzKSwKICAgIHF0eV9vbl9oYW5kXzA1IG51bWVyaWMoMTYsMyksCiAgICBx dHlfb25faGFuZF8wNiBudW1lcmljKDE2LDMpLAogICAgcXR5X29uX2hhbmRf MDcgbnVtZXJpYygxNiwzKSwKICAgIHF0eV9vbl9oYW5kXzA4IG51bWVyaWMo MTYsMyksCiAgICBxdHlfb25faGFuZF8wOSBudW1lcmljKDE2LDMpLAogICAg cXR5X29uX2hhbmRfMTAgbnVtZXJpYygxNiwzKSwKICAgIHF0eV9vbl9oYW5k XzExIG51bWVyaWMoMTYsMyksCiAgICBxdHlfb25faGFuZF8xMiBudW1lcmlj KDE2LDMpLAogICAgbXRoX3Nsc19jc3QgbnVtZXJpYygxNiwzKSwKICAgIG10 aF9zbHNfZGlzYyBudW1lcmljKDE2LDMpLAogICAgbXRoX3Nsc19uZXR0X2V4 Y2wgbnVtZXJpYygxNiwzKSwKICAgIG10aF9xdHlfb25faGFuZF9jc3QgbnVt ZXJpYygxNiwzKSwKICAgIG10aF9zbHNfcXR5X3VuZCBudW1lcmljKDE2LDMp LAogICAgcXR5X2luX2dvb2RzIG51bWVyaWMoMTYsMyksCiAgICBtYXRfc2xz X3F0eSBudW1lcmljKDE2LDMpLAogICAgeXRkX3Nsc19xdHkgbnVtZXJpYygx NiwzKSwKICAgIG1hdF9zbHNfY3N0IG51bWVyaWMoMTYsMyksCiAgICB5dGRf c2xzX2NzdCBudW1lcmljKDE2LDMpLAogICAgbWF0X3Nsc19kaXNjIG51bWVy aWMoMTYsMyksCiAgICB5dGRfc2xzX2Rpc2MgbnVtZXJpYygxNiwzKSwKICAg IG1hdF9zbHNfbmV0dF9leGNsIG51bWVyaWMoMTYsMyksCiAgICB5dGRfc2xz X25ldHRfZXhjbCBudW1lcmljKDE2LDMpLAogICAgbHlfbXRoX3Nsc19uZXR0 X2V4Y2wgbnVtZXJpYygxNiwzKSwKICAgIGx5X3l0ZF9zbHNfbmV0dF9leGNs IG51bWVyaWMoMTYsMyksCiAgICBzdGtfdHVybl9xdHlfb25faGFuZF9jc3Qg bnVtZXJpYygxNiwzKSwKICAgIG5vX210aHNfaGlzdG9yeSBpbnRlZ2VyIERF RkFVTFQgMCwKICAgIGN1cnJlbnRfb3JkZXJzIGludGVnZXIsCiAgICBvdmVy ZHVlX29yZGVycyBpbnRlZ2VyCik7CgoKLS0KLS0gVE9DIGVudHJ5IDMgKE9J RCA4MDIyNDIxKQotLSBOYW1lOiBtYXN0ZXJfZnBwX3ZhbHVlc19pZHgxOyBU eXBlOiBJTkRFWDsgU2NoZW1hOiBwdWJsaWM7IE93bmVyOiBwb3N0Z3Jlcwot LQoKQ1JFQVRFIElOREVYIG1hc3Rlcl9mcHBfdmFsdWVzX2lkeDEgT04gbWFz dGVyX2ZwcF92YWx1ZXMgVVNJTkcgYnRyZWUgKHNrdSk7CgoKLS0KLS0gVE9D IGVudHJ5IDQgKE9JRCA4MDIyNDM5KQotLSBOYW1lOiBtYXN0ZXJfZnBwX3Zh bHVlc19pZHgyOyBUeXBlOiBJTkRFWDsgU2NoZW1hOiBwdWJsaWM7IE93bmVy OiBwb3N0Z3JlcwotLQoKQ1JFQVRFIElOREVYIG1hc3Rlcl9mcHBfdmFsdWVz X2lkeDIgT04gbWFzdGVyX2ZwcF92YWx1ZXMgVVNJTkcgYnRyZWUgKGdyb3Vw X2NvZGUsIGJybl9jb2RlLCBza3UpOwoKCi0tCi0tIFRPQyBlbnRyeSA1IChP SUQgODAyMjQ0MCkKLS0gTmFtZTogbWFzdGVyX2ZwcF92YWx1ZXNfaWR4Mzsg VHlwZTogSU5ERVg7IFNjaGVtYTogcHVibGljOyBPd25lcjogcG9zdGdyZXMK LS0KCkNSRUFURSBJTkRFWCBtYXN0ZXJfZnBwX3ZhbHVlc19pZHgzIE9OIG1h c3Rlcl9mcHBfdmFsdWVzIFVTSU5HIGJ0cmVlIChmcHBfY29kZSk7CgoKLS0K LS0gVE9DIGVudHJ5IDYgKE9JRCA4MDIyNDQyKQotLSBOYW1lOiBtYXN0ZXJf ZnBwX3ZhbHVlc19pZHg0OyBUeXBlOiBJTkRFWDsgU2NoZW1hOiBwdWJsaWM7 IE93bmVyOiBwb3N0Z3JlcwotLQoKQ1JFQVRFIElOREVYIG1hc3Rlcl9mcHBf dmFsdWVzX2lkeDQgT04gbWFzdGVyX2ZwcF92YWx1ZXMgVVNJTkcgYnRyZWUg KGZwcF9jb2RlLCBza3UpOwoKCi0tCi0tIFRPQyBlbnRyeSA3IChPSUQgODAy MjQ0MykKLS0gTmFtZTogbWFzdGVyX2ZwcF92YWx1ZXNfaWR4NTsgVHlwZTog SU5ERVg7IFNjaGVtYTogcHVibGljOyBPd25lcjogcG9zdGdyZXMKLS0KCkNS RUFURSBJTkRFWCBtYXN0ZXJfZnBwX3ZhbHVlc19pZHg1IE9OIG1hc3Rlcl9m cHBfdmFsdWVzIFVTSU5HIGJ0cmVlIChicm5fY29kZSk7CgoKLS0KLS0gVE9D IGVudHJ5IDggKE9JRCA4MDIyNjE3KQotLSBOYW1lOiBtYXN0ZXJfZnBwX3Zh bHVlc19wazsgVHlwZTogQ09OU1RSQUlOVDsgU2NoZW1hOiBwdWJsaWM7IE93 bmVyOiBwb3N0Z3JlcwotLQoKQUxURVIgVEFCTEUgT05MWSBtYXN0ZXJfZnBw X3ZhbHVlcwogICAgQUREIENPTlNUUkFJTlQgbWFzdGVyX2ZwcF92YWx1ZXNf cGsgUFJJTUFSWSBLRVkgKGZwcF9jb2RlLCBicm5fY29kZSwgc2t1KTsKCgot LQotLSBUT0MgZW50cnkgMTIgKE9JRCA4MDIyNjE5KQotLSBOYW1lOiBtYXN0 ZXJfZnBwX3ZhbHVlc19mazsgVHlwZTogQ09OU1RSQUlOVDsgU2NoZW1hOiBw dWJsaWM7IE93bmVyOiBwb3N0Z3JlcwotLQoKQUxURVIgVEFCTEUgT05MWSBt YXN0ZXJfZnBwX3ZhbHVlcwogICAgQUREIENPTlNUUkFJTlQgbWFzdGVyX2Zw cF92YWx1ZXNfZmsgRk9SRUlHTiBLRVkgKGdyb3VwX2NvZGUsIHNrdSkgUkVG RVJFTkNFUyBpdGVtKGdyb3VwX2NvZGUsIHNrdSkgT04gVVBEQVRFIE5PIEFD VElPTiBPTiBERUxFVEUgTk8gQUNUSU9OOwoKCi0tCi0tIFRPQyBlbnRyeSAx MSAoT0lEIDgwMjI2NjkpCi0tIE5hbWU6IG1hc3Rlcl9mcHBfdmFsdWVzX3Vp ZHgzOyBUeXBlOiBDT05TVFJBSU5UOyBTY2hlbWE6IHB1YmxpYzsgT3duZXI6 IHBvc3RncmVzCi0tCgpBTFRFUiBUQUJMRSBPTkxZIG1hc3Rlcl9mcHBfdmFs dWVzCiAgICBBREQgQ09OU1RSQUlOVCBtYXN0ZXJfZnBwX3ZhbHVlc191aWR4 MyBVTklRVUUgKGJybl9jb2RlLCBmcHBfY29kZSwgc2t1KTsKCgotLQotLSBU T0MgZW50cnkgMTAgKE9JRCA4MDIyNjcxKQotLSBOYW1lOiBtYXN0ZXJfZnBw X3ZhbHVlc191aWR4MjsgVHlwZTogQ09OU1RSQUlOVDsgU2NoZW1hOiBwdWJs aWM7IE93bmVyOiBwb3N0Z3JlcwotLQoKQUxURVIgVEFCTEUgT05MWSBtYXN0 ZXJfZnBwX3ZhbHVlcwogICAgQUREIENPTlNUUkFJTlQgbWFzdGVyX2ZwcF92 YWx1ZXNfdWlkeDIgVU5JUVVFIChmcHBfY29kZSwgYnJuX2NvZGUsIHNrdSk7 CgoKLS0KLS0gVE9DIGVudHJ5IDkgKE9JRCA4MDIyNjczKQotLSBOYW1lOiBt YXN0ZXJfZnBwX3ZhbHVlc191aWR4MTsgVHlwZTogQ09OU1RSQUlOVDsgU2No ZW1hOiBwdWJsaWM7IE93bmVyOiBwb3N0Z3JlcwotLQoKQUxURVIgVEFCTEUg T05MWSBtYXN0ZXJfZnBwX3ZhbHVlcwogICAgQUREIENPTlNUUkFJTlQgbWFz dGVyX2ZwcF92YWx1ZXNfdWlkeDEgVU5JUVVFIChmcHBfY29kZSwgYnJuX2Nv ZGUsIHNrdSwgZ3JvdXBfY29kZSk7CgoK --Multipart_Mon__11_Aug_2003_15:58:41_+0200_084bd0a0 Content-Type: application/octet-stream; name="master_sku_descr.sql" Content-Disposition: attachment; filename="master_sku_descr.sql" Content-Transfer-Encoding: base64 LS0KLS0gUG9zdGdyZVNRTCBkYXRhYmFzZSBkdW1wCi0tCgpcY29ubmVjdCAt IHBvc3RncmVzCgpTRVQgc2VhcmNoX3BhdGggPSBwdWJsaWMsIHBnX2NhdGFs b2c7CgotLQotLSBUT0MgZW50cnkgMiAoT0lEIDg4Njc0MDYpCi0tIE5hbWU6 IG1hc3Rlcl9za3VfZGVzY3I7IFR5cGU6IFRBQkxFOyBTY2hlbWE6IHB1Ymxp YzsgT3duZXI6IHBvc3RncmVzCi0tCgpDUkVBVEUgVEFCTEUgbWFzdGVyX3Nr dV9kZXNjciAoCiAgICBncm91cF9jb2RlIHRleHQsCiAgICBza3UgdGV4dCwK ICAgIHNrdV9kZXNjciB0ZXh0LAogICAgZGVwX2NvZGUgdGV4dCwKICAgIGRl cF9kZXNjciB0ZXh0LAogICAgY2F0X2NvZGUgdGV4dCwKICAgIGNhdF9kZXNj ciB0ZXh0LAogICAgc3ViY2F0X2NvZGUgdGV4dCwKICAgIHN1YmNhdF9kZXNj ciB0ZXh0LAogICAgY29udHJvbF9jb2RlIHRleHQsCiAgICBjb250cm9sX2Rl c2NyIHRleHQsCiAgICBzdXBwbGllcl9jb2RlIHRleHQsCiAgICBzdXBwbGll cl9kZXNjciB0ZXh0CikgV0lUSE9VVCBPSURTOwoKCi0tCi0tIFRPQyBlbnRy eSA5IChPSUQgODg2NzQxMSkKLS0gTmFtZTogbWFzdGVyX3NrdV9kZXNjcl9p ZHgyOyBUeXBlOiBJTkRFWDsgU2NoZW1hOiBwdWJsaWM7IE93bmVyOiBwb3N0 Z3JlcwotLQoKQ1JFQVRFIElOREVYIG1hc3Rlcl9za3VfZGVzY3JfaWR4MiBP TiBtYXN0ZXJfc2t1X2Rlc2NyIFVTSU5HIGJ0cmVlIChncm91cF9jb2RlLCBz a3UsIGRlcF9jb2RlLCBjYXRfY29kZSwgc3ViY2F0X2NvZGUsIGNvbnRyb2xf Y29kZSk7CgoKLS0KLS0gVE9DIGVudHJ5IDE4IChPSUQgODg2NzQxMikKLS0g TmFtZTogbWFzdGVyX3NrdV9kZXNjcl91aWR4MzsgVHlwZTogSU5ERVg7IFNj aGVtYTogcHVibGljOyBPd25lcjogcG9zdGdyZXMKLS0KCkNSRUFURSBJTkRF WCBtYXN0ZXJfc2t1X2Rlc2NyX3VpZHgzIE9OIG1hc3Rlcl9za3VfZGVzY3Ig VVNJTkcgYnRyZWUgKHNrdSk7CgoKLS0KLS0gVE9DIGVudHJ5IDMgKE9JRCA4 ODY3NDEzKQotLSBOYW1lOiBtYXN0ZXJfc2t1X2Rlc2NyX2lkeDE7IFR5cGU6 IElOREVYOyBTY2hlbWE6IHB1YmxpYzsgT3duZXI6IHBvc3RncmVzCi0tCgpD UkVBVEUgSU5ERVggbWFzdGVyX3NrdV9kZXNjcl9pZHgxIE9OIG1hc3Rlcl9z a3VfZGVzY3IgVVNJTkcgYnRyZWUgKGdyb3VwX2NvZGUsIHNrdSwgY29udHJv bF9jb2RlKTsKCgotLQotLSBUT0MgZW50cnkgMTMgKE9JRCA4ODY3NDE0KQot LSBOYW1lOiBtYXN0ZXJfc2t1X2Rlc2NyX2lkeDY7IFR5cGU6IElOREVYOyBT Y2hlbWE6IHB1YmxpYzsgT3duZXI6IHBvc3RncmVzCi0tCgpDUkVBVEUgSU5E RVggbWFzdGVyX3NrdV9kZXNjcl9pZHg2IE9OIG1hc3Rlcl9za3VfZGVzY3Ig VVNJTkcgYnRyZWUgKGdyb3VwX2NvZGUsIHNrdSk7CgoKLS0KLS0gVE9DIGVu dHJ5IDE3IChPSUQgODg2NzQxNSkKLS0gTmFtZTogbWFzdGVyX3NrdV9kZXNj cl91aWR4MTsgVHlwZTogSU5ERVg7IFNjaGVtYTogcHVibGljOyBPd25lcjog cG9zdGdyZXMKLS0KCkNSRUFURSBVTklRVUUgSU5ERVggbWFzdGVyX3NrdV9k ZXNjcl91aWR4MSBPTiBtYXN0ZXJfc2t1X2Rlc2NyIFVTSU5HIGJ0cmVlIChz a3UsIGdyb3VwX2NvZGUpOwoKCi0tCi0tIFRPQyBlbnRyeSAxMCAoT0lEIDg4 Njc0MTYpCi0tIE5hbWU6IG1hc3Rlcl9za3VfZGVzY3JfaWR4MzsgVHlwZTog SU5ERVg7IFNjaGVtYTogcHVibGljOyBPd25lcjogcG9zdGdyZXMKLS0KCkNS RUFURSBJTkRFWCBtYXN0ZXJfc2t1X2Rlc2NyX2lkeDMgT04gbWFzdGVyX3Nr dV9kZXNjciBVU0lORyBidHJlZSAoZ3JvdXBfY29kZSk7CgoKLS0KLS0gVE9D IGVudHJ5IDExIChPSUQgODg2NzQxNykKLS0gTmFtZTogbWFzdGVyX3NrdV9k ZXNjcl9pZHg0OyBUeXBlOiBJTkRFWDsgU2NoZW1hOiBwdWJsaWM7IE93bmVy OiBwb3N0Z3JlcwotLQoKQ1JFQVRFIElOREVYIG1hc3Rlcl9za3VfZGVzY3Jf aWR4NCBPTiBtYXN0ZXJfc2t1X2Rlc2NyIFVTSU5HIGJ0cmVlIChza3VfZGVz Y3IpOwoKCi0tCi0tIFRPQyBlbnRyeSAxMiAoT0lEIDg4Njc0MTgpCi0tIE5h bWU6IG1hc3Rlcl9za3VfZGVzY3JfaWR4NTsgVHlwZTogSU5ERVg7IFNjaGVt YTogcHVibGljOyBPd25lcjogcG9zdGdyZXMKLS0KCkNSRUFURSBJTkRFWCBt YXN0ZXJfc2t1X2Rlc2NyX2lkeDUgT04gbWFzdGVyX3NrdV9kZXNjciBVU0lO RyBidHJlZSAoZGVwX2NvZGUpOwoKCi0tCi0tIFRPQyBlbnRyeSAxNCAoT0lE IDg4Njc0MTkpCi0tIE5hbWU6IG1hc3Rlcl9za3VfZGVzY3JfaWR4NzsgVHlw ZTogSU5ERVg7IFNjaGVtYTogcHVibGljOyBPd25lcjogcG9zdGdyZXMKLS0K CkNSRUFURSBJTkRFWCBtYXN0ZXJfc2t1X2Rlc2NyX2lkeDcgT04gbWFzdGVy X3NrdV9kZXNjciBVU0lORyBidHJlZSAoZGVwX2Rlc2NyKTsKCgotLQotLSBU T0MgZW50cnkgMTUgKE9JRCA4ODY3NDIwKQotLSBOYW1lOiBtYXN0ZXJfc2t1 X2Rlc2NyX2lkeDg7IFR5cGU6IElOREVYOyBTY2hlbWE6IHB1YmxpYzsgT3du ZXI6IHBvc3RncmVzCi0tCgpDUkVBVEUgSU5ERVggbWFzdGVyX3NrdV9kZXNj cl9pZHg4IE9OIG1hc3Rlcl9za3VfZGVzY3IgVVNJTkcgYnRyZWUgKGNhdF9j b2RlKTsKCgotLQotLSBUT0MgZW50cnkgMTYgKE9JRCA4ODY3NDIxKQotLSBO YW1lOiBtYXN0ZXJfc2t1X2Rlc2NyX2lkeDk7IFR5cGU6IElOREVYOyBTY2hl bWE6IHB1YmxpYzsgT3duZXI6IHBvc3RncmVzCi0tCgpDUkVBVEUgSU5ERVgg bWFzdGVyX3NrdV9kZXNjcl9pZHg5IE9OIG1hc3Rlcl9za3VfZGVzY3IgVVNJ TkcgYnRyZWUgKHN1YmNhdF9kZXNjcik7CgoKLS0KLS0gVE9DIGVudHJ5IDQg KE9JRCA4ODY3NDIyKQotLSBOYW1lOiBtYXN0ZXJfc2t1X2Rlc2NyX2lkeDEw OyBUeXBlOiBJTkRFWDsgU2NoZW1hOiBwdWJsaWM7IE93bmVyOiBwb3N0Z3Jl cwotLQoKQ1JFQVRFIElOREVYIG1hc3Rlcl9za3VfZGVzY3JfaWR4MTAgT04g bWFzdGVyX3NrdV9kZXNjciBVU0lORyBidHJlZSAoc3ViY2F0X2NvZGUpOwoK Ci0tCi0tIFRPQyBlbnRyeSA1IChPSUQgODg2NzQyMykKLS0gTmFtZTogbWFz dGVyX3NrdV9kZXNjcl9pZHgxMTsgVHlwZTogSU5ERVg7IFNjaGVtYTogcHVi bGljOyBPd25lcjogcG9zdGdyZXMKLS0KCkNSRUFURSBJTkRFWCBtYXN0ZXJf c2t1X2Rlc2NyX2lkeDExIE9OIG1hc3Rlcl9za3VfZGVzY3IgVVNJTkcgYnRy ZWUgKGNvbnRyb2xfY29kZSk7CgoKLS0KLS0gVE9DIGVudHJ5IDYgKE9JRCA4 ODY3NDI0KQotLSBOYW1lOiBtYXN0ZXJfc2t1X2Rlc2NyX2lkeDEyOyBUeXBl OiBJTkRFWDsgU2NoZW1hOiBwdWJsaWM7IE93bmVyOiBwb3N0Z3JlcwotLQoK Q1JFQVRFIElOREVYIG1hc3Rlcl9za3VfZGVzY3JfaWR4MTIgT04gbWFzdGVy X3NrdV9kZXNjciBVU0lORyBidHJlZSAoY29udHJvbF9kZXNjcik7CgoKLS0K LS0gVE9DIGVudHJ5IDcgKE9JRCA4ODY3NDI1KQotLSBOYW1lOiBtYXN0ZXJf c2t1X2Rlc2NyX2lkeDEzOyBUeXBlOiBJTkRFWDsgU2NoZW1hOiBwdWJsaWM7 IE93bmVyOiBwb3N0Z3JlcwotLQoKQ1JFQVRFIElOREVYIG1hc3Rlcl9za3Vf ZGVzY3JfaWR4MTMgT04gbWFzdGVyX3NrdV9kZXNjciBVU0lORyBidHJlZSAo c3VwcGxpZXJfY29kZSk7CgoKLS0KLS0gVE9DIGVudHJ5IDggKE9JRCA4ODY3 NDI2KQotLSBOYW1lOiBtYXN0ZXJfc2t1X2Rlc2NyX2lkeDE0OyBUeXBlOiBJ TkRFWDsgU2NoZW1hOiBwdWJsaWM7IE93bmVyOiBwb3N0Z3JlcwotLQoKQ1JF QVRFIElOREVYIG1hc3Rlcl9za3VfZGVzY3JfaWR4MTQgT04gbWFzdGVyX3Nr dV9kZXNjciBVU0lORyBidHJlZSAoc3VwcGxpZXJfZGVzY3IpOwoKCg== --Multipart_Mon__11_Aug_2003_15:58:41_+0200_084bd0a0 Content-Type: text/plain; name="number_of_rows.txt" Content-Disposition: attachment; filename="number_of_rows.txt" Content-Transfer-Encoding: 7bit Number of rows in master_fpp_values : count --------- 1012252 (1 row) Number of rows in master_sku_descr : count ------- 53219 (1 row) Number of rows in master_branch_descr : count ------- 198 (1 row) Number of rows in supplier_price : count ------- 54670 (1 row) Number of rows in price_tmpl_det : count ------- 202 (1 row) Number of rows in sku_price : count ------- 54670 (1 row) Number of rows in forex : count ------- 576 (1 row) --Multipart_Mon__11_Aug_2003_15:58:41_+0200_084bd0a0 Content-Type: application/octet-stream; name="price_tmpl_det.sql" Content-Disposition: attachment; filename="price_tmpl_det.sql" Content-Transfer-Encoding: base64 LS0KLS0gUG9zdGdyZVNRTCBkYXRhYmFzZSBkdW1wCi0tCgpcY29ubmVjdCAt IHBvc3RncmVzCgpTRVQgc2VhcmNoX3BhdGggPSBwdWJsaWMsIHBnX2NhdGFs b2c7CgotLQotLSBUT0MgZW50cnkgMiAoT0lEIDgwMjkwOTUpCi0tIE5hbWU6 IHByaWNlX3RtcGxfZGV0OyBUeXBlOiBUQUJMRTsgU2NoZW1hOiBwdWJsaWM7 IE93bmVyOiBwb3N0Z3JlcwotLQoKQ1JFQVRFIFRBQkxFIHByaWNlX3RtcGxf ZGV0ICgKICAgIGdyb3VwX2NkZSB0ZXh0IE5PVCBOVUxMLAogICAgcHJpY2Vf dG1wbF9oZHJfY2RlIGludGVnZXIgTk9UIE5VTEwsCiAgICBwcmljZV90bXBs X2hkcl9yZWcgdGV4dCBOT1QgTlVMTCwKICAgIGJyYW5jaF9jZGUgdGV4dCBO T1QgTlVMTCwKICAgIGF1ZGl0X2lkIGludGVnZXIKKTsKCgotLQotLSBUT0Mg ZW50cnkgMyAoT0lEIDgwMjkxMDApCi0tIE5hbWU6IGlkeF9wcmljZV90bXBs X2RldDsgVHlwZTogSU5ERVg7IFNjaGVtYTogcHVibGljOyBPd25lcjogcG9z dGdyZXMKLS0KCkNSRUFURSBJTkRFWCBpZHhfcHJpY2VfdG1wbF9kZXQgT04g cHJpY2VfdG1wbF9kZXQgVVNJTkcgYnRyZWUgKGJyYW5jaF9jZGUpOwoKCg== --Multipart_Mon__11_Aug_2003_15:58:41_+0200_084bd0a0 Content-Type: application/octet-stream; name="sku_price.sql" Content-Disposition: attachment; filename="sku_price.sql" Content-Transfer-Encoding: base64 LS0KLS0gUG9zdGdyZVNRTCBkYXRhYmFzZSBkdW1wCi0tCgpcY29ubmVjdCAt IHBvc3RncmVzCgpTRVQgc2VhcmNoX3BhdGggPSBwdWJsaWMsIHBnX2NhdGFs b2c7CgotLQotLSBUT0MgZW50cnkgMiAoT0lEIDgwMjkxMTUpCi0tIE5hbWU6 IHNrdV9wcmljZTsgVHlwZTogVEFCTEU7IFNjaGVtYTogcHVibGljOyBPd25l cjogcG9zdGdyZXMKLS0KCkNSRUFURSBUQUJMRSBza3VfcHJpY2UgKAogICAg Z3JvdXBfY2RlIHRleHQgTk9UIE5VTEwsCiAgICBza3VfbXN0X2NkZSB0ZXh0 IE5PVCBOVUxMLAogICAgcHJpY2VfdG1wbF9oZHJfY2RlIGludGVnZXIgTk9U IE5VTEwsCiAgICBwcmljZV90bXBsX2hkcl9yZWcgdGV4dCBOT1QgTlVMTCwK ICAgIHNrdV9wcmljZV9jdXJyX2Nvc3QgbnVtZXJpYygxNSwyKSwKICAgIHNr dV9wcmljZV9zdGRjc3RfYXR0ciB0ZXh0LAogICAgc2t1X3ByaWNlX21pc2Nf YXR0ciB0ZXh0LAogICAgc2t1X3ByaWNlX2Nvc3RfZHRlX2VmY3R2IHRpbWVz dGFtcCB3aXRoIHRpbWUgem9uZSwKICAgIHNrdV9wcmljZV9jdXJyX3JzcF9j YSBudW1lcmljKDE1LDIpLAogICAgc2t1X3ByaWNlX2N1cnJfcnNwX2NyIG51 bWVyaWMoMTUsMiksCiAgICBza3VfcHJpY2VfcnNwX2R0ZV9lZmN0diB0aW1l c3RhbXAgd2l0aCB0aW1lIHpvbmUsCiAgICBza3VfcHJpY2VfY3Vycl90YXhf Y2RlIHRleHQsCiAgICBza3VfcHJpY2VfdGF4X2R0ZV9lZmN0diB0aW1lc3Rh bXAgd2l0aCB0aW1lIHpvbmUsCiAgICBza3VfcHJpY2VfY3Vycl9zdGtfdHlw IGNoYXJhY3RlciB2YXJ5aW5nKDIpLAogICAgc2t1X3ByaWNlX3N0a19kdGVf ZWZjdHYgdGltZXN0YW1wIHdpdGggdGltZSB6b25lLAogICAgYXVkaXRfaWQg aW50ZWdlcgopOwoKCi0tCi0tIFRPQyBlbnRyeSAzIChPSUQgODAyOTExNSkK LS0gTmFtZTogc2t1X3ByaWNlOyBUeXBlOiBBQ0w7IFNjaGVtYTogcHVibGlj OyBPd25lcjogcG9zdGdyZXMKLS0KClJFVk9LRSBBTEwgT04gVEFCTEUgc2t1 X3ByaWNlIEZST00gUFVCTElDOwpHUkFOVCBBTEwgT04gVEFCTEUgc2t1X3By aWNlIFRPIFBVQkxJQzsKCgotLQotLSBUT0MgZW50cnkgNCAoT0lEIDgwMjkx MjIpCi0tIE5hbWU6IGlkeF9za3VfcHJpY2U7IFR5cGU6IElOREVYOyBTY2hl bWE6IHB1YmxpYzsgT3duZXI6IHBvc3RncmVzCi0tCgpDUkVBVEUgSU5ERVgg aWR4X3NrdV9wcmljZSBPTiBza3VfcHJpY2UgVVNJTkcgYnRyZWUgKGdyb3Vw X2NkZSwgc2t1X21zdF9jZGUsIHByaWNlX3RtcGxfaGRyX2NkZSwgcHJpY2Vf dG1wbF9oZHJfcmVnKTsKCgotLQotLSBUT0MgZW50cnkgNSAoT0lEIDgwMjkx MjMpCi0tIE5hbWU6IGlkeF9za3VfcHJpY2VfY29zdF9kdGVfZWZjdHY7IFR5 cGU6IElOREVYOyBTY2hlbWE6IHB1YmxpYzsgT3duZXI6IHBvc3RncmVzCi0t CgpDUkVBVEUgSU5ERVggaWR4X3NrdV9wcmljZV9jb3N0X2R0ZV9lZmN0diBP TiBza3VfcHJpY2UgVVNJTkcgYnRyZWUgKHNrdV9wcmljZV9jb3N0X2R0ZV9l ZmN0dik7CgoKLS0KLS0gVE9DIGVudHJ5IDYgKE9JRCA4MDI5MTI0KQotLSBO YW1lOiBpZHhfc2t1X3ByaWNlX3JzcF9kdGVfZWZjdHY7IFR5cGU6IElOREVY OyBTY2hlbWE6IHB1YmxpYzsgT3duZXI6IHBvc3RncmVzCi0tCgpDUkVBVEUg SU5ERVggaWR4X3NrdV9wcmljZV9yc3BfZHRlX2VmY3R2IE9OIHNrdV9wcmlj ZSBVU0lORyBidHJlZSAoc2t1X3ByaWNlX3JzcF9kdGVfZWZjdHYpOwoKCi0t Ci0tIFRPQyBlbnRyeSA4IChPSUQgODAyOTEyNSkKLS0gTmFtZTogaWR4X3Nr dV9wcmljZV90YXhfZHRlX2VmY3R2OyBUeXBlOiBJTkRFWDsgU2NoZW1hOiBw dWJsaWM7IE93bmVyOiBwb3N0Z3JlcwotLQoKQ1JFQVRFIElOREVYIGlkeF9z a3VfcHJpY2VfdGF4X2R0ZV9lZmN0diBPTiBza3VfcHJpY2UgVVNJTkcgYnRy ZWUgKHNrdV9wcmljZV90YXhfZHRlX2VmY3R2KTsKCgotLQotLSBUT0MgZW50 cnkgNyAoT0lEIDgwMjkxMjYpCi0tIE5hbWU6IGlkeF9za3VfcHJpY2Vfc3Rr X2R0ZV9lZmN0djsgVHlwZTogSU5ERVg7IFNjaGVtYTogcHVibGljOyBPd25l cjogcG9zdGdyZXMKLS0KCkNSRUFURSBJTkRFWCBpZHhfc2t1X3ByaWNlX3N0 a19kdGVfZWZjdHYgT04gc2t1X3ByaWNlIFVTSU5HIGJ0cmVlIChza3VfcHJp Y2Vfc3RrX2R0ZV9lZmN0dik7CgoKLS0KLS0gVE9DIGVudHJ5IDEwIChPSUQg ODc4MDcyMSkKLS0gTmFtZTogc2t1X3ByaWNlX2dyb3VwX3NrdV9oZHJfcmVn X3N0azsgVHlwZTogSU5ERVg7IFNjaGVtYTogcHVibGljOyBPd25lcjogcG9z dGdyZXMKLS0KCkNSRUFURSBJTkRFWCBza3VfcHJpY2VfZ3JvdXBfc2t1X2hk cl9yZWdfc3RrIE9OIHNrdV9wcmljZSBVU0lORyBidHJlZSAoZ3JvdXBfY2Rl LCBza3VfbXN0X2NkZSwgcHJpY2VfdG1wbF9oZHJfY2RlLCBwcmljZV90bXBs X2hkcl9yZWcsIHNrdV9wcmljZV9jdXJyX3N0a190eXAgdGV4dF9vcHMpOwoK Ci0tCi0tIFRPQyBlbnRyeSAxMSAoT0lEIDg3ODA3MjMpCi0tIE5hbWU6IHNr dV9wcmljZV9pZHgxOyBUeXBlOiBJTkRFWDsgU2NoZW1hOiBwdWJsaWM7IE93 bmVyOiBwb3N0Z3JlcwotLQoKQ1JFQVRFIElOREVYIHNrdV9wcmljZV9pZHgx IE9OIHNrdV9wcmljZSBVU0lORyBidHJlZSAoc2t1X21zdF9jZGUsIHByaWNl X3RtcGxfaGRyX3JlZyk7CgoKLS0KLS0gVE9DIGVudHJ5IDkgKE9JRCA4MDI5 MTIwKQotLSBOYW1lOiBwa19za3VfcHJpY2U7IFR5cGU6IENPTlNUUkFJTlQ7 IFNjaGVtYTogcHVibGljOyBPd25lcjogcG9zdGdyZXMKLS0KCkFMVEVSIFRB QkxFIE9OTFkgc2t1X3ByaWNlCiAgICBBREQgQ09OU1RSQUlOVCBwa19za3Vf cHJpY2UgUFJJTUFSWSBLRVkgKGdyb3VwX2NkZSwgc2t1X21zdF9jZGUsIHBy aWNlX3RtcGxfaGRyX2NkZSwgcHJpY2VfdG1wbF9oZHJfcmVnKTsKCgo= --Multipart_Mon__11_Aug_2003_15:58:41_+0200_084bd0a0 Content-Type: application/octet-stream; name="sql_statement.sql" Content-Disposition: attachment; filename="sql_statement.sql" Content-Transfer-Encoding: base64 Q1JFQVRFIFRBQkxFIHN0b2NrX3ZhbHVhdGlvbiBBUyAoCgpTRUxFQ1QgbS5n cm91cF9jb2RlOjp0ZXh0ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgIEFTIEdST1VQX0NPREUsCiAgICAg ICBtLnNrdTo6dGV4dCAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgQVMgU0tVLAogICAgICAg bS5icm5fY29kZTo6dGV4dCAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgIEFTIEJSTl9DT0RFLAogICAg ICAgbS5zdGt0eXBlX2NvZGU6OnRleHQgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIEFTIFNUS1RZUEVfQ09E RSwKICAgICAgIHNzLnN1cHBsaWVyX3ByaWNlX2N1cnJfY29zdDo6bnVtZXJp YygxNiwzKSAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBBUyBTVVBQ TElFUl9DVVJSX0NPU1QsCiAgICAgICBzay5za3VfcHJpY2VfY3Vycl9jb3N0 OjpudW1lcmljKDE2LDMpICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgQVMgU0tVX0NVUlJfQ09TVCwKICAgICAgIFNVTShtLnF0eV9vbl9o YW5kXzAxKTo6aW50NCAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICBBUyBRVFlfT05fSEFORCwKICAgICAgIFNVTShzcy5z dXBwbGllcl9wcmljZV9jdXJyX2Nvc3QgKiBtLiBxdHlfb25faGFuZF8wMSk6 Om51bWVyaWMoMTYsMykgICAgICBBUyBRVFlfT05fSEFORF9DT1NULAogICAg ICAgU1VNKHNrLnNrdV9wcmljZV9jdXJyX2Nvc3QgKiBtLnF0eV9vbl9oYW5k XzAxICogZi5yYXRlKTo6bnVtZXJpYygxNiwzKSAgIEFTIFFUWV9PTl9IQU5E X1JTUCwKICAgICAgIChTVU0oc3Muc3VwcGxpZXJfcHJpY2VfY3Vycl9jb3N0 ICogbS5xdHlfb25faGFuZF8wMSkgLQogICAgICAgIFNVTShzay5za3VfcHJp Y2VfY3Vycl9jb3N0ICogbS5xdHlfb25faGFuZF8wMSAqIGYucmF0ZSkpOjpu dW1lcmljKDE2LDMpIEFTIFFUWV9PTl9IQU5EX01BUktVUApGUk9NIG1hc3Rl cl9mcHBfdmFsdWVzIG0sCiAgICAgbWFzdGVyX3NrdV9kZXNjciBzLAogICAg IG1hc3Rlcl9icmFuY2hfZGVzY3IgYiwKICAgICBzdXBwbGllcl9wcmljZSBz cywKICAgICBwcmljZV90bXBsX2RldCBwLAogICAgIHNrdV9wcmljZSBzaywK ICAgICBmb3JleCBmCldIRVJFIG0uZnBwX2NvZGUgPSAnMjAwMzA3JwpBTkQg ICBtLmJybl9jb2RlID0gYi5icm5fY29kZQpBTkQgICBtLnNrdSA9IHMuc2t1 CkFORCAgIG0uZ3JvdXBfY29kZSA9IHMuZ3JvdXBfY29kZQpBTkQgICBzLmNv bnRyb2xfY29kZSA9ICcwJwpBTkQgICBtLmJybl9jb2RlID0gcC5icmFuY2hf Y2RlCkFORCAgIGIuYnJuX2NvZGUgPSBwLmJyYW5jaF9jZGUKQU5EICAgc3Mu Z3JvdXBfY2RlID0gcC5ncm91cF9jZGUKQU5EICAgc3MucHJpY2VfdG1wbF9o ZHJfY2RlID0gcC5wcmljZV90bXBsX2hkcl9jZGUKQU5EICAgc3MucHJpY2Vf dG1wbF9oZHJfcmVnID0gcC5wcmljZV90bXBsX2hkcl9yZWcKQU5EICAgc3Mu Z3JvdXBfY2RlID0gbS5ncm91cF9jb2RlCkFORCAgIHNzLnNrdV9tc3RfY2Rl ID0gbS5za3UKQU5EICAgc3Muc3VwcGxpZXJfY2RlID0gbS5zdXBwbGllcl9j b2RlCkFORCAgIHNrLnByaWNlX3RtcGxfaGRyX2NkZSA9IHAucHJpY2VfdG1w bF9oZHJfY2RlCkFORCAgIHNrLnByaWNlX3RtcGxfaGRyX3JlZyA9IHAucHJp Y2VfdG1wbF9oZHJfcmVnCkFORCAgIHNrLmdyb3VwX2NkZSA9IG0uZ3JvdXBf Y29kZQpBTkQgICBzay5za3VfbXN0X2NkZSA9IG0uc2t1CkFORCAgIGIuY291 bnRyeV9jb2RlID0gZi5mcm9tX2N0cnkKQU5EICAgZi50b19jdHJ5ID0gJ1pB RicKQU5EICAgZi5mcHBfY29kZSA9ICcyMDAzMDcnCkdST1VQIEJZIG0uZ3Jv dXBfY29kZSwKICAgICAgICAgbS5za3UsCiAgICAgICAgIG0uYnJuX2NvZGUs CiAgICAgICAgIG0uc3RrdHlwZV9jb2RlLAogICAgICAgICBzcy5zdXBwbGll cl9wcmljZV9jdXJyX2Nvc3QsCiAgICAgICAgIHNrLnNrdV9wcmljZV9jdXJy X2Nvc3QKKTsK --Multipart_Mon__11_Aug_2003_15:58:41_+0200_084bd0a0 Content-Type: application/octet-stream; name="supplier_price.sql" Content-Disposition: attachment; filename="supplier_price.sql" Content-Transfer-Encoding: base64 LS0KLS0gUG9zdGdyZVNRTCBkYXRhYmFzZSBkdW1wCi0tCgpcY29ubmVjdCAt IHBvc3RncmVzCgpTRVQgc2VhcmNoX3BhdGggPSBwdWJsaWMsIHBnX2NhdGFs b2c7CgotLQotLSBUT0MgZW50cnkgMiAoT0lEIDgwMjg3NTIpCi0tIE5hbWU6 IHN1cHBsaWVyX3ByaWNlOyBUeXBlOiBUQUJMRTsgU2NoZW1hOiBwdWJsaWM7 IE93bmVyOiBwb3N0Z3JlcwotLQoKQ1JFQVRFIFRBQkxFIHN1cHBsaWVyX3By aWNlICgKICAgIGdyb3VwX2NkZSB0ZXh0IE5PVCBOVUxMLAogICAgc2t1X21z dF9jZGUgdGV4dCBOT1QgTlVMTCwKICAgIHN1cHBsaWVyX2NkZSB0ZXh0IE5P VCBOVUxMLAogICAgcHJpY2VfdG1wbF9oZHJfY2RlIGludGVnZXIgTk9UIE5V TEwsCiAgICBwcmljZV90bXBsX2hkcl9yZWcgdGV4dCBOT1QgTlVMTCwKICAg IHN1cHBsaWVyX3NrdV9jZGUgdGV4dCwKICAgIHN1cHBsaWVyX3NrdV9iYXJj ZGUgdGV4dCwKICAgIHN1cHBsaWVyX3ByaWNlX2xlYWR0bV9kYXlzIGludGVn ZXIsCiAgICBzdXBwbGllcl9wcmljZV9jdXJyX2Nvc3QgbnVtZXJpYygxNSwy KSwKICAgIHN1cHBsaWVyX3ByaWNlX2Nvc3RfZHRlX2VmY3R2IHRpbWVzdGFt cCB3aXRoIHRpbWUgem9uZSwKICAgIHN1cHBsaWVyX3ByaWNlX2R0ZV9jcmVh dGVkIHRpbWVzdGFtcCB3aXRoIHRpbWUgem9uZSwKICAgIHN1cHBsaWVyX3By aWNlX2R0ZV9waGFzZWRvdXQgdGltZXN0YW1wIHdpdGggdGltZSB6b25lLAog ICAgc3VwcGxpZXJfcHJpY2VfZGVsZXRlZCB0aW1lc3RhbXAgd2l0aCB0aW1l IHpvbmUsCiAgICBhdWRpdF9pZCBpbnRlZ2VyCik7CgoKLS0KLS0gVE9DIGVu dHJ5IDMgKE9JRCA4NzgwNzI0KQotLSBOYW1lOiBpZHhfc3VwcGxpZXJfcHJp Y2U7IFR5cGU6IElOREVYOyBTY2hlbWE6IHB1YmxpYzsgT3duZXI6IHBvc3Rn cmVzCi0tCgpDUkVBVEUgSU5ERVggaWR4X3N1cHBsaWVyX3ByaWNlIE9OIHN1 cHBsaWVyX3ByaWNlIFVTSU5HIGJ0cmVlIChncm91cF9jZGUsIHNrdV9tc3Rf Y2RlLCBzdXBwbGllcl9jZGUsIHByaWNlX3RtcGxfaGRyX2NkZSwgcHJpY2Vf dG1wbF9oZHJfcmVnKTsKCgotLQotLSBUT0MgZW50cnkgNCAoT0lEIDgwMjg3 NTcpCi0tIE5hbWU6IHBrX3N1cHBsaWVyX3ByaWNlOyBUeXBlOiBDT05TVFJB SU5UOyBTY2hlbWE6IHB1YmxpYzsgT3duZXI6IHBvc3RncmVzCi0tCgpBTFRF UiBUQUJMRSBPTkxZIHN1cHBsaWVyX3ByaWNlCiAgICBBREQgQ09OU1RSQUlO VCBwa19zdXBwbGllcl9wcmljZSBQUklNQVJZIEtFWSAoZ3JvdXBfY2RlLCBz a3VfbXN0X2NkZSwgc3VwcGxpZXJfY2RlLCBwcmljZV90bXBsX2hkcl9jZGUs IHByaWNlX3RtcGxfaGRyX3JlZyk7CgoK --Multipart_Mon__11_Aug_2003_15:58:41_+0200_084bd0a0--