text: ﻿PRAGMA foreign_keys=OFF;
  BEGIN TRANSACTION;
  CREATE TABLE general_params ( "name" text, "value" text );
  INSERT INTO "general_params" VALUES('entry_sproc','AddRequestedRunFractions');
  INSERT INTO "general_params" VALUES('entry_page_data_table','V_Requested_Run_Fraction_Entry');
  INSERT INTO "general_params" VALUES('entry_page_data_id_col','Source_Request_ID');
  INSERT INTO "general_params" VALUES('post_submission_link','{"link":"requested_run/report/StartsWith__", "label":"Show new requested runs"}');
  INSERT INTO "general_params" VALUES('post_submission_detail_id','Source_Request_Name');
  CREATE TABLE form_fields ( id INTEGER PRIMARY KEY, "name"  text, "label" text, "type" text, "size" text, "maxlength" text, "rows" text, "cols" text, "default" text, "rules" text);
  INSERT INTO "form_fields" VALUES(1,'Source_Request_ID','Source Request','non-edit','','','','','0','trim');
  INSERT INTO "form_fields" VALUES(2,'Source_Request_Name','Source Request Name','non-edit','','','','','','trim');
  INSERT INTO "form_fields" VALUES(3,'Experiment','Experiment Name','non-edit','','','','','','trim');
  INSERT INTO "form_fields" VALUES(4,'Instrument_Group','Instrument Group','non-edit','','','','','','trim');
  INSERT INTO "form_fields" VALUES(5,'Run_Type','Run Type','non-edit','','','','','','trim');
  INSERT INTO "form_fields" VALUES(6,'Source_Separation_Group','Source Separation Group','non-edit','','','','','','trim');
  INSERT INTO "form_fields" VALUES(7,'Separation_Group','Separation Group','text','25','80','','','','trim|required|max_length[64]');
  INSERT INTO "form_fields" VALUES(8,'Requestor','Requestor (Username)','text','35','80','','','','trim|required|max_length[80]');
  INSERT INTO "form_fields" VALUES(9,'Instrument_Settings','Instrument Settings','area','','','6','60','','trim|max_length[512]');
  INSERT INTO "form_fields" VALUES(10,'Staging_Location','Staging Location','text','40','64','','','','trim|max_length[64]');
  INSERT INTO "form_fields" VALUES(11,'Wellplate','Wellplate','text','40','80','','','(lookup)','trim|max_length[64]');
  INSERT INTO "form_fields" VALUES(12,'Well','Well','text','40','80','','','(lookup)','trim|max_length[24]');
  INSERT INTO "form_fields" VALUES(13,'Vialing_Concentration','Vialing Concentration','text','25','80','','','','trim|max_length[32]');
  INSERT INTO "form_fields" VALUES(14,'Vialing_Volume','Vialing Volume','text','25','80','','','','trim|max_length[32]');
  INSERT INTO "form_fields" VALUES(15,'Comment','Comment','area','','','6','80','','trim|max_length[1024]');
  INSERT INTO "form_fields" VALUES(16,'Work_Package','Work Package','text','15','50','','','(lookup)','trim|max_length[50]|required');
  INSERT INTO "form_fields" VALUES(17,'EUS_Usage_Type','EMSL Usage Type','text','15','50','','','(lookup)','trim|required|max_length[50]|not_contain[(unknown)]');
  INSERT INTO "form_fields" VALUES(18,'EUS_Proposal_ID','EMSL Proposal ID','text','10','10','','','(lookup)','trim|max_length[10]');
  INSERT INTO "form_fields" VALUES(19,'EUS_User','EMSL Proposal User','text','25','1024','','','(lookup)','trim|max_length[1024]');
  INSERT INTO "form_fields" VALUES(20,'MRM_Attachment','MRM Transition List Attachment','text','60','128','','','','trim|max_length[128]');
  CREATE TABLE form_field_choosers ( id INTEGER PRIMARY KEY,  "field" text, "type" text, "PickListName" text, "Target" text, "XRef" text, "Delimiter" text, "Label" text);
  INSERT INTO "form_field_choosers" VALUES(1,'Separation_Group','picker.replace','separationGroupNoFractionsPickList','','',',','');
  INSERT INTO "form_field_choosers" VALUES(2,'Requestor','picker.replace','userPRNPickList','','',',','');
  INSERT INTO "form_field_choosers" VALUES(3,'Staging_Location','list-report.helper','','helper_material_location','',',','');
  INSERT INTO "form_field_choosers" VALUES(4,'Wellplate','picker.replace','wellplatePickList','','',',','');
  INSERT INTO "form_field_choosers" VALUES(5,'Work_Package','list-report.helper','','helper_charge_code/report','',',','');
  INSERT INTO "form_field_choosers" VALUES(6,'EUS_Usage_Type','picker.replace','eusUsageTypePickList','','',',','');
  INSERT INTO "form_field_choosers" VALUES(7,'EUS_Proposal_ID','list-report.helper','','helper_eus_proposal/report','',',','Select Proposal...');
  INSERT INTO "form_field_choosers" VALUES(8,'EUS_Proposal_ID','list-report.helper','','helper_eus_proposal_ex/report','',',','Select Proposal (by dataset)...');
  INSERT INTO "form_field_choosers" VALUES(9,'EUS_User','list-report.helper','','helper_eus_user/report','EUS_Proposal_ID',',','Select User...');
  INSERT INTO "form_field_choosers" VALUES(10,'MRM_Attachment','list-report.helper','','helper_mrm_attachment/report','',',','');
  INSERT INTO "form_field_choosers" VALUES(11,'Comment','link.list','multiDatasetRequestCommentTmpl','','',',','Use Template:');
  CREATE TABLE list_report_hotlinks ( id INTEGER PRIMARY KEY,  "name" text, "LinkType" text, "WhichArg" text, "Target" text, "Options" text );
  INSERT INTO "list_report_hotlinks" VALUES(1,'Request','invoke_entity','value','requested_run/show/','');
  INSERT INTO "list_report_hotlinks" VALUES(2,'Campaign','invoke_entity','value','campaign/show','');
  INSERT INTO "list_report_hotlinks" VALUES(3,'Experiment','invoke_entity','value','experiment/show','');
  INSERT INTO "list_report_hotlinks" VALUES(4,'Dataset','invoke_entity','value','dataset/show','');
  INSERT INTO "list_report_hotlinks" VALUES(5,'Days In Queue','color_label','#DaysInQueue','','{"30":"clr_30","60":"clr_60","90":"clr_90","120":"clr_120"}');
  INSERT INTO "list_report_hotlinks" VALUES(6,'Batch','invoke_entity','value','requested_run_batch/show','');
  INSERT INTO "list_report_hotlinks" VALUES(7,'Work Package','invoke_entity','value','charge_code/show','');
  INSERT INTO "list_report_hotlinks" VALUES(8,'WP State','color_label','#WPActivationState','','{"0":"clr_30","1":"clr_45","2":"clr_60","3":"clr_90","4":"clr_120","5":"clr_120","10":"clr_120"}');
  INSERT INTO "list_report_hotlinks" VALUES(9,'Proposal','invoke_entity','value','eus_proposals/show','');
  INSERT INTO "list_report_hotlinks" VALUES(10,'Comment','markup','Comment','60','');
  INSERT INTO "list_report_hotlinks" VALUES(11,'Proposal State','color_label','value','','{"Active":"clr_30", "Permanently Active":"clr_60", "Closed":"clr_90", "Inactive":"clr_90"}');
  INSERT INTO "list_report_hotlinks" VALUES(12,'Queue State','invoke_entity','Campaign','requested_run_admin/report/-/-/-/-/~@/-/-/-','');
  CREATE TABLE detail_report_hotlinks ( idx INTEGER PRIMARY KEY,  "name" text, "LinkType" text, "WhichArg" text, "Target" text, "Placement" text, "id" text, "options" text );
  INSERT INTO "detail_report_hotlinks" VALUES(1,'Experiment','detail-report','Experiment','experiment/show','labelCol','experiment','');
  INSERT INTO "detail_report_hotlinks" VALUES(2,'Campaign','detail-report','Campaign','campaign/show','labelCol','campaign','');
  INSERT INTO "detail_report_hotlinks" VALUES(3,'Batch','detail-report','Batch','requested_run_batch/show','labelCol','batch','');
  INSERT INTO "detail_report_hotlinks" VALUES(4,'Block','detail-report','Batch','requested_run_batch_blocking/param','valueCol','block','');
  INSERT INTO "detail_report_hotlinks" VALUES(5,'Dataset','detail-report','Dataset','dataset/show','valueCol','dataset','');
  INSERT INTO "detail_report_hotlinks" VALUES(6,'Factors','detail-report','Request','custom_factors/report/-','labelCol','dl_show_factors','');
  INSERT INTO "detail_report_hotlinks" VALUES(7,'+Factors','detail-report','Request','requested_run_factors/param/@/Requested_Run_ID','valueCol','dl_edit_factors','');
  INSERT INTO "detail_report_hotlinks" VALUES(8,'Instrument Group','detail-report','Instrument Group','instrument_group/show/','valueCol','dl_instrument_group','');
  INSERT INTO "detail_report_hotlinks" VALUES(9,'Instrument Used','detail-report','Instrument Used','instrument/show/','valueCol','dl_instrument','');
  INSERT INTO "detail_report_hotlinks" VALUES(10,'EUS Proposal','detail-report','EUS Proposal','eus_proposals/show','valueCol','dl_eus_proposal','');
  INSERT INTO "detail_report_hotlinks" VALUES(11,'Work Package','detail-report','Work Package','charge_code/show','labelCol','dl_Work_Package','');
  INSERT INTO "detail_report_hotlinks" VALUES(12,'Work Package State','color_label','#WPActivationState','','valueCol','dl_Work_Package_State','{"3":"clr_90","4":"clr_120", "5":"clr_120","10":"clr_120"}');
  INSERT INTO "detail_report_hotlinks" VALUES(13,'Requestor','detail-report','Requestor','user/report/-/~','labelCol','dl_Requestor','{"RemoveRegEx":" [(].*[)]"}');
  INSERT INTO "detail_report_hotlinks" VALUES(14,'Separation Group','detail-report','Separation Group','separation_group/show','labelCol','dl_separation_group','');
  INSERT INTO "detail_report_hotlinks" VALUES(15,'Staging Location','detail-report','Staging Location','material_location/report/~@','valueCol','dl_staging_location','');
  INSERT INTO "detail_report_hotlinks" VALUES(16,'Comment','markup','Comment','','valueCol','dl_comment','');
  INSERT INTO "detail_report_hotlinks" VALUES(17,'EUS Proposal State','color_label','EUS Proposal State','','valueCol','dl_eus_proposal_state','{"Active":"clr_30", "Permanently Active":"clr_60", "Closed":"clr_90", "Inactive":"clr_90"}
  
  ');
  INSERT INTO "detail_report_hotlinks" VALUES(18,'Queue State','detail-report','Campaign','requested_run_admin/report/-/-/-/-/~@/-/-/-','labelCol','dl_requested_run_admin','');
  INSERT INTO "detail_report_hotlinks" VALUES(19,'Days In Queue','detail-report','Instrument Group','run_planning/report/~@/-/-/-/-/-/-/-','labelCol','dl_run_planning','');
  CREATE TABLE sproc_args ( id INTEGER PRIMARY KEY, "field" text, "name" text, "type" text, "dir" text, "size" text, "procedure" text);
  INSERT INTO "sproc_args" VALUES(1,'Source_Request_ID','sourceRequestID','int','input','','AddRequestedRunFractions');
  INSERT INTO "sproc_args" VALUES(2,'Separation_Group','separationGroup','varchar','input','64','AddRequestedRunFractions');
  INSERT INTO "sproc_args" VALUES(3,'Requestor','requestorPRN','varchar','input','80','AddRequestedRunFractions');
  INSERT INTO "sproc_args" VALUES(4,'Instrument_Settings','instrumentSettings','varchar','input','512','AddRequestedRunFractions');
  INSERT INTO "sproc_args" VALUES(5,'Staging_Location','stagingLocation','varchar','input','64','AddRequestedRunFractions');
  INSERT INTO "sproc_args" VALUES(6,'Wellplate','wellplateName','varchar','input','64','AddRequestedRunFractions');
  INSERT INTO "sproc_args" VALUES(7,'Well','wellNumber','varchar','input','24','AddRequestedRunFractions');
  INSERT INTO "sproc_args" VALUES(8,'Vialing_Concentration','vialingConc','varchar','input','32','AddRequestedRunFractions');
  INSERT INTO "sproc_args" VALUES(9,'Vialing_Volume','vialingVol','varchar','input','32','AddRequestedRunFractions');
  INSERT INTO "sproc_args" VALUES(10,'Comment','comment','varchar','input','1024','AddRequestedRunFractions');
  INSERT INTO "sproc_args" VALUES(11,'Work_Package','workPackage','varchar','input','50','AddRequestedRunFractions');
  INSERT INTO "sproc_args" VALUES(12,'EUS_Usage_Type','eusUsageType','varchar','input','50','AddRequestedRunFractions');
  INSERT INTO "sproc_args" VALUES(13,'EUS_Proposal_ID','eusProposalID','varchar','input','10','AddRequestedRunFractions');
  INSERT INTO "sproc_args" VALUES(14,'EUS_User','eusUserID','varchar','input','512','AddRequestedRunFractions');
  INSERT INTO "sproc_args" VALUES(15,'MRM_Attachment','mrmAttachment','varchar','input','128','AddRequestedRunFractions');
  INSERT INTO "sproc_args" VALUES(16,'<local>','mode','varchar','input','12','AddRequestedRunFractions');
  INSERT INTO "sproc_args" VALUES(17,'<local>','message','varchar','output','1024','AddRequestedRunFractions');
  INSERT INTO "sproc_args" VALUES(18,'<local>','callingUser','varchar','input','128','AddRequestedRunFractions');
  CREATE TABLE external_sources ( id INTEGER PRIMARY KEY,  "source_page" text, "field" text, "type" text, "value" text );
  INSERT INTO "external_sources" VALUES(1,'requested_run','Source_Request_ID','ColName','Request');
  INSERT INTO "external_sources" VALUES(2,'requested_run','Source_Request_Name','ColName','Name');
  INSERT INTO "external_sources" VALUES(3,'requested_run','Experiment','ColName','Experiment');
  INSERT INTO "external_sources" VALUES(4,'requested_run','Instrument_Group','ColName','Instrument Group');
  INSERT INTO "external_sources" VALUES(5,'requested_run','Run_Type','ColName','Type');
  INSERT INTO "external_sources" VALUES(6,'requested_run','Source_Separation_Group','ColName','Separation Group');
  INSERT INTO "external_sources" VALUES(7,'requested_run','Requestor','ColName','Requestor');
  INSERT INTO "external_sources" VALUES(8,'requested_run','Instrument_Settings','ColName','Instrument Settings');
  INSERT INTO "external_sources" VALUES(9,'requested_run','Staging_Location','ColName','Staging Location');
  INSERT INTO "external_sources" VALUES(10,'requested_run','Wellplate','ColName','Well Plate');
  INSERT INTO "external_sources" VALUES(11,'requested_run','Well','ColName','Well');
  INSERT INTO "external_sources" VALUES(12,'requested_run','Vialing_Concentration','ColName','Vialing Concentration');
  INSERT INTO "external_sources" VALUES(13,'requested_run','Vialing_Volume','ColName','Vialing Volume');
  INSERT INTO "external_sources" VALUES(14,'requested_run','Comment','ColName','Comment');
  INSERT INTO "external_sources" VALUES(15,'requested_run','Work_Package','ColName','Work Package');
  INSERT INTO "external_sources" VALUES(16,'requested_run','EUS_Usage_Type','ColName','EUS Usage Type');
  INSERT INTO "external_sources" VALUES(17,'requested_run','EUS_Proposal_ID','ColName','EUS Proposal');
  INSERT INTO "external_sources" VALUES(18,'requested_run','EUS_User','ColName','EUS User');
  INSERT INTO "external_sources" VALUES(19,'requested_run','MRM_Attachment','ColName','MRM Transistion List');
  CREATE TABLE entry_commands ( id INTEGER PRIMARY KEY,  "name" text, "type" text, "label" text, "tooltip" text, "target" text );
  INSERT INTO "entry_commands" VALUES(1,'preview','cmd','Preview','Validate options and show the requested runs that would be created','');
  COMMIT;
  