3fdf82de7f
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3630 248e525c-4dfb-0310-94bc-949c084e9493
68 lines
3.7 KiB
Plaintext
68 lines
3.7 KiB
Plaintext
LOAD DATA
|
|
INFILE *
|
|
INTO TABLE parties
|
|
REPLACE
|
|
FIELDS TERMINATED BY '|'
|
|
(
|
|
manu_ref
|
|
,created_by
|
|
,shortcode
|
|
,name
|
|
,description
|
|
,created_on
|
|
,updated_on
|
|
,updated_by
|
|
,mktp_ref
|
|
,lt_7b_contract_ref
|
|
,gt_7b_contract_ref
|
|
,adversarial_contract_ref
|
|
,username
|
|
,status
|
|
,first_name
|
|
,last_name
|
|
,personal_title
|
|
,comments
|
|
,id
|
|
,prty_type
|
|
)
|
|
BEGINDATA
|
|
|advantica||||08-NOV-07|||||||advantica|OPEN|Advantica|User|Mr|User|1|PERS
|
|
ACTARIS|hardya||ACTARIS||08-NOV-07||||||||||||Manufactures meters|100|MANU
|
|
DRESSER|hardya||DRESSER||08-NOV-07||||||||||||Manufactures meters|101|MANU
|
|
QUINSHIELD|hardya||QUINSHIELD||08-NOV-07||||||||||||Manufactures meters|102|MANU
|
|
|hardya|NS1|Northern Supplies||08-NOV-07||NSUPP|LT7 Contract|GT7 Contract|Adversarial Contract|||||||Supplier of gas to the north of the UK|200|MKTP
|
|
|hardya|NS2|Extreme Northern Supplies||08-NOV-07||ENSUPP|LT7 Contract|GT7 Contract|Adversarial Contract|||||||Supplier of gas to the extreme north of the UK|201|MKTP
|
|
|hardya|WS1|Welsh Supplies||08-NOV-07||WSUPP|LT7 Contract|GT7 Contract|Adversarial Contract|||||||Supplier of gas to Wales|202|MKTP
|
|
|hardya|WS2|Welsh Supplies||08-NOV-07||W2SUPP|LT7 Contract|GT7 Contract|Adversarial Contract|||||||Supplier of gas to Wales|203|MKTP
|
|
|hardya|CE1|Central Gas Supplies||08-NOV-07||CGSUPP|LT7 Contract|GT7 Contract|Adversarial Contract|||||||Supplier of gas to the Central region|204|MKTP
|
|
|hardya|CE2|Centre de Gas Supplies||08-NOV-07||CDSUPP|LT7 Contract|GT7 Contract|Adversarial Contract|||||||Supplier of gas to the Central region|205|MKTP
|
|
|hardya|LON|London Supplies||08-NOV-07||LONSUPP|LT7 Contract|GT7 Contract|Adversarial Contract|||||||Supplier of gas to London|206|MKTP
|
|
|hardya|KER|Kernow Supplies||08-NOV-07||KERSUPP|LT7 Contract|GT7 Contract|Adversarial Contract|||||||Supplier of gas to Cornwall|207|MKTP
|
|
|hardya|BM|Bootiful Gas Supplies||08-NOV-07||BGSUPP|LT7 Contract|GT7 Contract|Adversarial Contract|||||||Supplier of gas to the East|208|MKTP
|
|
|hardya||National Grid||08-NOV-07||||||||||||Internal organization|300|IO
|
|
|hardya||National Grid Metering||08-NOV-07||||||||||||Internal organization|301|IO
|
|
|hardya||Customer Services||08-NOV-07||||||||||||Internal organization|302|IO
|
|
|hardya||Quotations||08-NOV-07||||||||||||Internal organization|303|IO
|
|
|hardya||||08-NOV-07|||||||hardya|OPEN|Andrew|Hardy|Mr|User|400|PERS
|
|
|hardya||||08-NOV-07|||||||priestj|OPEN|Jamie|Priest|Mr|User|401|PERS
|
|
|hardya||||08-NOV-07|||||||kanagasabapathy|OPEN|Dharshani|Kanagasabapathy||User|402|PERS
|
|
|hardya||||08-NOV-07|||||||mullenmd|OPEN|Matt|Mullen||User|403|PERS
|
|
|hardya||||08-NOV-07|||||||agent1|OPEN|Fred|Smith||User|404|PERS
|
|
|hardya||||08-NOV-07|||||||agent2|OPEN|Joe|Bloggs||User|405|PERS
|
|
|hardya||||08-NOV-07|||||||agent3|OPEN|Peter|Piper||User|406|PERS
|
|
|hardya||||08-NOV-07|||||||agent4|OPEN|Nigel|Normal||User|407|PERS
|
|
|hardya||||08-NOV-07|||||||agent5|OPEN|Norah|Batty||User|408|PERS
|
|
|hardya||||08-NOV-07|||||||cs1|OPEN|Henrietta|Helpful||User|409|PERS
|
|
|hardya||||08-NOV-07|||||||cs2|OPEN|Tommy|Atkins||User|410|PERS
|
|
|hardya||||08-NOV-07|||||||cs3|OPEN|Tracy|Beaker||User|411|PERS
|
|
|hardya||||08-NOV-07|||||||ic1|OPEN|Gareth|Thomas||User|412|PERS
|
|
|hardya||||08-NOV-07|||||||ic2|OPEN|Bhavesh|Singh||User|413|PERS
|
|
|hardya||||08-NOV-07|||||||ic3|OPEN|Dave|Smith||User|414|PERS
|
|
|mullenmd||||17-DEC-07|||||||login_test|OPEN|Test|Login||User|415|PERS
|
|
|mullenmd||||17-DEC-07|||||||expired_user|EXPIRED|Test|Login||User|416|PERS
|
|
|mullenmd||||17-DEC-07|||||||locked_user|LOCKED|Test|Login||User|417|PERS
|
|
|mullenmd||||17-DEC-07|||||||old_password|OPEN|Test|Login||User|418|PERS
|
|
|priestj||||08-NOV-07|||||||sa1|OPEN|Supplier|SuppAdmin1||User|419|PERS
|
|
|priestj||||08-NOV-07|||||||sa2|OPEN|Supplier|SuppAdmin2||User|420|PERS
|
|
|priestj||||08-NOV-07|||||||sa3|OPEN|Supplier|SuppAdmin3||User|421|PERS
|