/************************************************************************
 * Name     :inserts.sql						*
 * Issue    :03-09-2003 - H. Korte - Intevation - Osnabrueck		*	
 * Purpose  :insert dummy val's into tables				*
 *	     PLEASE INSERT lo_import(LOCAL FILENAME WITH BINARY DATA)   *
 *	     AT INSERT STMT FOR BIN_OBJ_TAB FOR FILE_OBJ		*
 * Parameter:								*
 * Changes  :								*
 * [ Date   ] - [ Name ] - [ Action ]					*
 ***********************************************************************/
  
Insert into group_tab (name, admin, cre_date, mod_date, status) values ('Admin group', 'Y', '16-JUL-02', '16-JUL-02', 'VALID');
Insert into user_tab (user_id, group_id, cre_date, mod_date, status) values('GREATER200',currval('group_seq'), '16-JUL-02', '16-JUL-02', 'VALID');
Insert into user_tab (user_id, group_id, cre_date, mod_date, status) values('ANONYM',currval('group_seq'), '16-JUL-02', '16-JUL-02', 'VALID');
Insert into user_tab (user_id, group_id, cre_date, mod_date, status) values('ANONYM_GREATER',currval('group_seq'), '16-JUL-02', '16-JUL-02', 'VALID');
Insert into catch_tab (user_id, cre_date, mod_date, privs) values('ANONYM', '23-JUN-03', '23-JUN-03', 6);
Insert into stretch_class_tab values(1, 'DEFAULT', '20;5','1','0.5','7;1','1','1','5','5;2','1','12;2','1','17;3','1','5','0.3','2','4','0','A European continental standard river');
Insert into stretch_tab (stretch_id, catch_id, stretch_class_id, type, q_val, v_val, l, d_val, vol_val) values(1,currval('catch_seq'),1,'1','0.08600; 0.05788','0.13046; 0.10724','2195,851','unknown', '0');
Insert into disch_tab (disch_id, stretch_id, catch_id, disch_class_id, name, pop, dwf, flow_val, flow_dist, flow_dom, flow_nondom, flow_runoff, treated, r_wwtp, remark) values(1, 1, currval('catch_seq'), 20, 'Sesto S.G.', '3.0000000000E+04', '2.3148100000E-01', '2.3148100000E-01', '0', '6.6666666700E+02', '.0000000000E+00', '.0000000000E+00', '1.0000000000E+00','None', 'None');
Insert into bin_obj_tab (object_id, name, user_id, privs, obj_type, obj_sub_type, file_type, file_obj, file_size, cre_date, mod_date) values(1,'RIVERNET.DBF','ANONYM',6,'catchment','db','b',0,215283,'16-JUL-02', '21-MAY-03'); 
Insert into backgrd_join_tab values(currval('catch_seq'),currval('bin_obj_seq'));
Insert into env_tab (name, user_id, cre_date, mod_date, status, privs, is_templ) values ('Nongeo', 'GREATER200', '16-JUL-02', '21-MAY-03', 'DEFAULT SESSION', 6, 'N');
Insert into bin_obj_search_tab values(4, 'POPULATED');
Insert into env_det_tab (env_id, field_id, block_id, block_recno) values(currval('env_seq'), 'WIND_SPEED', 'ENV', 1);
Insert into market_tab (disch_id, catch_id, name, user_id, cre_date, mod_date, status, privs, consumption, flux_nondom, flux_runoff, remark) values(1, currval('catch_seq'), 'Market Data Solingen-Graefrath', 'GREATER200', '22-MAY-03', '25-JUN-03', 'TEST', 6, '1.0000000000E+00', '2.0000000000E+00', '', '');
Insert into message_tab values(101,'E', 'ERR', 'Only the password of the current user can be changed');
Insert into mod_tab (name, user_id, cre_date, mod_date, status, privs, remark) values('Model 2','ANONYM','04-SEP-03','04-SEP-03','TEST','6', 'RS!');
Insert into mod_det_tab (mod_id, field_id, block_id, block_recno, value_mdt, dist_type, remark) values(currval('mod_seq'), 'MODE_SEWER', 'MODPARA', 1, '1000', '0', 'Monte Carlo shots number value');
Insert into para_tree_def_tab values('Ws', 'SUBST', 'ENVIRONMENTAL', 'SUBST', 'FLOAT', 3, 41, 0, 1, 'Wind speed (river)', '', 'NNNNN.NNNNN', 'm/s', '[0;20]', '[0;3e8]', 'Wind speed at 10 m height (overwrites river class settings)');
Insert into phrase_tab (phrase_grp_id, language, sort, value_pt, remark) values(1, 'E', 2, '0', 'acid');
Insert into phrase_tab (phrase_grp_id, language, sort, value_pt, remark) values(101, 'E', 2, 'anon_group', 'phrase2');
Insert into res_tab (river_factor, river_unit, stp_factor, stp_unit, pec_initial, pec_catch, remark) values('1.0000000000e+03','NONE','NONE','NONE','NONE','NONE','NONE');
Insert into res_disch_tab (res_id, disch_id, field_id, block_id, block_recno, value_rdt, dist_type, remark) values(currval('res_seq'), 18, 'CSIMEFFLUENT', 'RES_DISCH', 0, '4.4772489649e-04;0.0000000000e+00', '2', 'None');
Insert into res_stretch_tab (res_id, stretch_id, field_id, block_id, block_recno, value_rst, dist_type, remark) values(currval('res_seq'), 7886, 'CSIMINTERN', 'RES_STRETCH', 0, '0.0000000000e+00;0.0000000000e+00', '2', 'None'); 
Insert into sess_tab (name, user_id, cre_date, mod_date, status, privs, is_temp_sess, sess_disch_id) values('JAN', 'ANONYM','29-01-2003','29-01-2003', 'VALID', 6, 'N',1);
Insert into disch_class_tab values (10,'PRIM','1','5','0','3','0.0005','0.8','0','0','0','0','0','0','0','0','0','0','0','0','0','0','primary only plant');
Insert into sess_disch_tab (disch_id, stretch_id, catch_id, disch_class_id, name, user_id, cre_date, mod_date, status, privs, pop, dwf, flow_val, flow_dist, flow_dom, flow_nondom, flow_runoff, treated, r_wwtp, remark) values(1,1,currval('catch_seq'),10,'sdv','ANONYM', '16-JUL-02', '16-JUL-02','sdfvdv',6, 'ddn','dgdgngh','dghgh','dghdm','dhm','dt','snrdtn','srthsrth','strhsth','strhstrh');
Insert into subst_tab (name, user_id, cre_date, mod_date, status, privs, is_templ, remark) values ('Boron 1', 'ANONYM', '16-JUL-02', '16-JUL-02','VALID',6,'N', 'Test');
Insert into subst_det_tab (subst_id, field_id, block_id, block_recno, value_sdt, dist_type, remark) values(currval('subst_seq'),'Vp','SUBST', 1, '10200','0', 'Water solubility');
