text: ﻿PRAGMA foreign_keys=OFF;
  BEGIN TRANSACTION;
  CREATE TABLE general_params ( "name" text, "value" text );
  INSERT INTO "general_params" VALUES('list_report_data_table','V_Capture_Jobs_List_Report');
  INSERT INTO "general_params" VALUES('list_report_data_sort_dir','DESC');
  INSERT INTO "general_params" VALUES('detail_report_data_table','V_Capture_Jobs_Detail_Report');
  INSERT INTO "general_params" VALUES('detail_report_data_id_col','Job');
  INSERT INTO "general_params" VALUES('detail_report_data_id_type','integer');
  INSERT INTO "general_params" VALUES('my_db_group','capture');
  INSERT INTO "general_params" VALUES('entry_page_data_table','V_Capture_Jobs_Entry');
  INSERT INTO "general_params" VALUES('entry_page_data_id_col','Job');
  INSERT INTO "general_params" VALUES('entry_sproc','AddUpdateLocalJobInBroker');
  CREATE TABLE list_report_primary_filter ( id INTEGER PRIMARY KEY,  "name" text, "label" text, "size" text, "value" text, "col" text, "cmp" text, "type" text, "maxlength" text, "rows" text, "cols" text );
  INSERT INTO "list_report_primary_filter" VALUES(1,'pf_job','Job','6','','Job','Equals','text','80','','');
  INSERT INTO "list_report_primary_filter" VALUES(2,'pf_job_state_b','Job_State_B','6','','Job_State_B','ContainsText','text','80','','');
  INSERT INTO "list_report_primary_filter" VALUES(3,'pf_dataset','Dataset','45!','','Dataset','ContainsText','text','80','','');
  INSERT INTO "list_report_primary_filter" VALUES(4,'pf_script','Script','6','','Script','ContainsText','text','80','','');
  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,'Job','invoke_entity','value','capture_jobs/show/','');
  INSERT INTO "list_report_hotlinks" VALUES(2,'Steps','invoke_entity','Job','capture_job_steps/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,'Steps','detail-report','Job','capture_job_steps/report','labelCol','job',NULL);
  INSERT INTO "detail_report_hotlinks" VALUES(2,'Dataset','detail-report','Dataset','dataset/show','labelCol','dataset',NULL);
  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,'job','Job','non-edit','','','','','0','trim|max_length[12]');
  INSERT INTO "form_fields" VALUES(2,'scriptName','Script Name','text','50','64','','','','trim|max_length[64]');
  INSERT INTO "form_fields" VALUES(3,'priority','Priority','text','12','12','','','3','trim|max_length[12]');
  INSERT INTO "form_fields" VALUES(4,'jobParam','Job Param','area','','','15','120','','trim|max_length[8000]');
  INSERT INTO "form_fields" VALUES(5,'comment','Comment','area','','','4','120','','trim|max_length[512]');
  INSERT INTO "form_fields" VALUES(6,'resultsFolderName','Results Folder Name','non-edit','50','128','','','','trim|max_length[128]');
  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,'job','job','int','output','','AddUpdateLocalJobInBroker');
  INSERT INTO "sproc_args" VALUES(2,'scriptName','scriptName','varchar','input','64','AddUpdateLocalJobInBroker');
  INSERT INTO "sproc_args" VALUES(3,'priority','priority','int','input','','AddUpdateLocalJobInBroker');
  INSERT INTO "sproc_args" VALUES(4,'jobParam','jobParam','varchar','input','8000','AddUpdateLocalJobInBroker');
  INSERT INTO "sproc_args" VALUES(5,'comment','comment','varchar','input','512','AddUpdateLocalJobInBroker');
  INSERT INTO "sproc_args" VALUES(6,'resultsFolderName','resultsFolderName','varchar','output','128','AddUpdateLocalJobInBroker');
  INSERT INTO "sproc_args" VALUES(7,'<local>','mode','varchar','input','12','AddUpdateLocalJobInBroker');
  INSERT INTO "sproc_args" VALUES(8,'<local>','message','varchar','output','512','AddUpdateLocalJobInBroker');
  INSERT INTO "sproc_args" VALUES(9,'<local>','callingUser','varchar','input','128','AddUpdateLocalJobInBroker');
  CREATE TABLE form_field_options ( id INTEGER PRIMARY KEY,  "field" text, "type" text, "parameter" text );
  INSERT INTO "form_field_options" VALUES(1,'jobParam','auto_format','xml');
  COMMIT;
  