f5e160010b
PASSWORDS - holds history of passwords for parties ACCESS_CONTROLS - hold page, item / role information for authorization purposes. Modified tables: ENQUIRIES - meter size removed. Replaced by foreign key to METER_SIZE_CODES. COSTS - includes AICO_CODE and DESCRIPTION for use as cost details for Additional Items. General modifications: Yes/No columns modified to VARCHAR2(3) Modules: Added mip_security.pck. Supports Authentication and Authorization (update of the original POC version) Respository: Created new directory structure to hold persistent data. Currently includes Data/Seed for base table values and Data/Demo to populate various party and relationship tables. git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@2838 248e525c-4dfb-0310-94bc-949c084e9493
39 lines
856 B
Plaintext
39 lines
856 B
Plaintext
LOAD DATA
|
|
INFILE *
|
|
INTO TABLE party_roles
|
|
REPLACE
|
|
FIELDS TERMINATED BY '|'
|
|
(
|
|
prty_id
|
|
,rt_code
|
|
,id
|
|
,start_date
|
|
,end_date
|
|
,description
|
|
)
|
|
BEGINDATA
|
|
200|SUPP|2001|08-NOV-07|||
|
|
201|SUPP|2011|08-NOV-07|||
|
|
202|SUPP|2021|08-NOV-07|||
|
|
203|SUPP|2031|08-NOV-07|||
|
|
204|SUPP|2041|08-NOV-07|||
|
|
205|SUPP|2051|08-NOV-07|||
|
|
206|SUPP|2061|08-NOV-07|||
|
|
207|SUPP|2071|08-NOV-07|||
|
|
208|SUPP|2081|08-NOV-07|||
|
|
400|MIPADMIN|4001|08-NOV-07|||
|
|
400|CS|4002|08-NOV-07|||
|
|
400|ICU|4003|08-NOV-07|||
|
|
401|MIPADMIN|4011|08-NOV-07|||
|
|
401|CS|4012|08-NOV-07|||
|
|
401|ICU|4013|08-NOV-07|||
|
|
402|MIPADMIN|4021|08-NOV-07|||
|
|
403|MIPADMIN|4031|08-NOV-07|||
|
|
404|AGENT|4041|08-NOV-07|||
|
|
404|SUPPADMIN|4042|08-NOV-07|||
|
|
405|AGENT|4051|08-NOV-07|||
|
|
405|SUPPADMIN|4052|08-NOV-07|||
|
|
406|AGENT|4061|08-NOV-07|||
|
|
407|AGENT|4071|08-NOV-07|||
|
|
408|AGENT|4081|08-NOV-07|||
|