1036_2651_dump.sql

--
-- PostgreSQL database dump
--

SET statement_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = off;
SET check_function_bodies = false;
SET client_min_messages = warning;
SET escape_string_warning = off;

SET search_path = public, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- Name: advance_assignment; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE advance_assignment (
    id bigint NOT NULL,
    version bigint NOT NULL,
    report_global_advance boolean,
    advance_type_id bigint
);


ALTER TABLE public.advance_assignment OWNER TO naval;

--
-- Name: advance_assignment_template; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE advance_assignment_template (
    id bigint NOT NULL,
    version bigint NOT NULL,
    advance_type_id bigint,
    order_element_template_id bigint,
    report_global_advance boolean,
    max_value numeric(19,2)
);


ALTER TABLE public.advance_assignment_template OWNER TO naval;

--
-- Name: advance_measurement; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE advance_measurement (
    id bigint NOT NULL,
    version bigint NOT NULL,
    date date,
    value numeric(19,2),
    advance_assignment_id bigint,
    communication_date timestamp with time zone
);


ALTER TABLE public.advance_measurement OWNER TO naval;

--
-- Name: advance_type; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE advance_type (
    id bigint NOT NULL,
    version bigint NOT NULL,
    unit_name character varying(255),
    default_max_value numeric(19,4),
    updatable boolean,
    unit_precision numeric(19,4),
    active boolean,
    percentage boolean,
    quality_form boolean
);


ALTER TABLE public.advance_type OWNER TO naval;

--
-- Name: all_criterions; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE all_criterions (
    generic_resource_allocation_id bigint NOT NULL,
    criterion_id bigint NOT NULL
);


ALTER TABLE public.all_criterions OWNER TO naval;

--
-- Name: assignment_function; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE assignment_function (
    id bigint NOT NULL,
    version bigint NOT NULL
);


ALTER TABLE public.assignment_function OWNER TO naval;

--
-- Name: base_calendar; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE base_calendar (
    id bigint NOT NULL,
    version bigint NOT NULL,
    code character varying(255) NOT NULL,
    name character varying(255),
    code_autogenerated boolean,
    last_sequence_code integer
);


ALTER TABLE public.base_calendar OWNER TO naval;

--
-- Name: calendar_availability; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE calendar_availability (
    id bigint NOT NULL,
    version bigint NOT NULL,
    code character varying(255) NOT NULL,
    start_date date,
    end_date date,
    base_calendar_id bigint,
    position_in_calendar integer
);


ALTER TABLE public.calendar_availability OWNER TO naval;

--
-- Name: calendar_data; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE calendar_data (
    id bigint NOT NULL,
    version bigint NOT NULL,
    code character varying(255) NOT NULL,
    parent bigint,
    expiring_date date,
    base_calendar_id bigint,
    position_in_calendar integer
);


ALTER TABLE public.calendar_data OWNER TO naval;

--
-- Name: calendar_exception; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE calendar_exception (
    id bigint NOT NULL,
    version bigint NOT NULL,
    code character varying(255) NOT NULL,
    date date,
    standard_effort integer,
    calendar_exception_id bigint,
    base_calendar_id bigint,
    allowed_extra_effort integer
);


ALTER TABLE public.calendar_exception OWNER TO naval;

--
-- Name: calendar_exception_type; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE calendar_exception_type (
    id bigint NOT NULL,
    version bigint NOT NULL,
    code character varying(255) NOT NULL,
    code_autogenerated boolean NOT NULL,
    name character varying(255),
    color character varying(255),
    standard_effort integer,
    allowed_extra_effort integer
);


ALTER TABLE public.calendar_exception_type OWNER TO naval;

--
-- Name: capacity_per_day; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE capacity_per_day (
    base_calendar_id bigint NOT NULL,
    standard_effort integer,
    day_id integer NOT NULL,
    allowed_extra_effort integer
);


ALTER TABLE public.capacity_per_day OWNER TO naval;

--
-- Name: configuration; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE configuration (
    id bigint NOT NULL,
    version bigint NOT NULL,
    configuration_id bigint,
    company_code character varying(255),
    generate_code_for_cost_category boolean NOT NULL,
    generate_code_for_calendar_exception_type boolean NOT NULL,
    generate_code_for_work_report_type boolean NOT NULL,
    generate_code_for_criterion boolean NOT NULL,
    generate_code_for_label boolean NOT NULL,
    generate_code_for_work_report boolean NOT NULL,
    generate_code_for_resources boolean NOT NULL,
    generate_code_for_types_of_work_hours boolean NOT NULL,
    generate_code_for_material_categories boolean NOT NULL,
    generate_code_for_unit_types boolean NOT NULL,
    generate_code_for_base_calendars boolean NOT NULL,
    expand_company_planning_view_charts boolean NOT NULL,
    expand_order_planning_view_charts boolean NOT NULL,
    expand_resource_load_view_charts boolean NOT NULL,
    monte_carlo_method_tab_visible boolean NOT NULL,
    progress_type integer,
    company_logo_url character varying(255),
    scenarios_visible boolean,
    changed_default_admin_password boolean DEFAULT false NOT NULL,
    changed_default_user_password boolean DEFAULT false NOT NULL,
    changed_default_wsreader_password boolean DEFAULT false NOT NULL,
    changed_default_wswriter_password boolean DEFAULT false NOT NULL
);


ALTER TABLE public.configuration OWNER TO naval;

--
-- Name: consolidated_value; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE consolidated_value (
    id bigint NOT NULL,
    consolidated_value_type character varying(255) NOT NULL,
    version bigint NOT NULL,
    date date,
    value numeric(19,2),
    task_end_date date,
    consolidation_id bigint,
    advance_measurement_id bigint
);


ALTER TABLE public.consolidated_value OWNER TO naval;

--
-- Name: consolidation; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE consolidation (
    id bigint NOT NULL,
    consolidation_type character varying(255) NOT NULL,
    version bigint NOT NULL,
    dir_advance_assignment_id bigint,
    ind_advance_assignment_id bigint
);


ALTER TABLE public.consolidation OWNER TO naval;

--
-- Name: cost_category; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE cost_category (
    id bigint NOT NULL,
    version bigint NOT NULL,
    code character varying(255) NOT NULL,
    name character varying(255),
    code_autogenerated boolean NOT NULL,
    last_hour_cost_sequence_code integer NOT NULL,
    enabled boolean
);


ALTER TABLE public.cost_category OWNER TO naval;

--
-- Name: criterion; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE criterion (
    id bigint NOT NULL,
    version bigint NOT NULL,
    code character varying(255) NOT NULL,
    name character varying(255),
    predefined_criterion_internal_name character varying(255),
    active boolean,
    id_criterion_type bigint NOT NULL,
    parent bigint
);


ALTER TABLE public.criterion OWNER TO naval;

--
-- Name: criterion_requirement; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE criterion_requirement (
    id bigint NOT NULL,
    criterion_requirement_type character varying(255) NOT NULL,
    version bigint NOT NULL,
    hours_group_id bigint,
    order_element_id bigint,
    order_element_template_id bigint,
    criterion_id bigint,
    parent bigint,
    valid boolean
);


ALTER TABLE public.criterion_requirement OWNER TO naval;

--
-- Name: criterion_satisfaction; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE criterion_satisfaction (
    id bigint NOT NULL,
    version bigint NOT NULL,
    code character varying(255) NOT NULL,
    start_date date NOT NULL,
    finish_date date,
    is_deleted boolean,
    criterion bigint NOT NULL,
    resource bigint NOT NULL
);


ALTER TABLE public.criterion_satisfaction OWNER TO naval;

--
-- Name: criterion_type; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE criterion_type (
    id bigint NOT NULL,
    version bigint NOT NULL,
    code character varying(255) NOT NULL,
    name character varying(255),
    predefined_type_internal_name character varying(255),
    description character varying(255),
    allow_simultaneous_criterions_per_resource boolean,
    allow_hierarchy boolean,
    last_criterion_sequence_code integer,
    enabled boolean,
    code_autogenerated boolean NOT NULL,
    resource integer
);


ALTER TABLE public.criterion_type OWNER TO naval;

--
-- Name: databasechangelog; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE databasechangelog (
    id character varying(63) NOT NULL,
    author character varying(63) NOT NULL,
    filename character varying(200) NOT NULL,
    dateexecuted timestamp with time zone NOT NULL,
    orderexecuted integer NOT NULL,
    exectype character varying(10) NOT NULL,
    md5sum character varying(35),
    description character varying(255),
    comments character varying(255),
    tag character varying(255),
    liquibase character varying(20)
);


ALTER TABLE public.databasechangelog OWNER TO naval;

--
-- Name: databasechangeloglock; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE databasechangeloglock (
    id integer NOT NULL,
    locked boolean NOT NULL,
    lockgranted timestamp with time zone,
    lockedby character varying(255)
);


ALTER TABLE public.databasechangeloglock OWNER TO naval;

--
-- Name: day_assignment; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE day_assignment (
    id bigint NOT NULL,
    day_assignment_type character varying(255) NOT NULL,
    version bigint NOT NULL,
    duration integer NOT NULL,
    consolidated boolean,
    day date NOT NULL,
    resource_id bigint NOT NULL,
    specific_container_id bigint,
    generic_container_id bigint,
    derived_container_id bigint
);


ALTER TABLE public.day_assignment OWNER TO naval;

--
-- Name: dependency; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE dependency (
    id bigint NOT NULL,
    version bigint NOT NULL,
    origin bigint,
    destination bigint,
    queue_dependency bigint,
    type integer
);


ALTER TABLE public.dependency OWNER TO naval;

--
-- Name: derived_allocation; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE derived_allocation (
    id bigint NOT NULL,
    version bigint NOT NULL,
    resource_allocation_id bigint,
    configurationunit bigint NOT NULL
);


ALTER TABLE public.derived_allocation OWNER TO naval;

--
-- Name: derived_day_assignments_container; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE derived_day_assignments_container (
    id bigint NOT NULL,
    version bigint NOT NULL,
    derived_allocation_id bigint,
    scenario bigint
);


ALTER TABLE public.derived_day_assignments_container OWNER TO naval;

--
-- Name: description_values; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE description_values (
    description_value_id bigint NOT NULL,
    fieldname character varying(255),
    value character varying(255)
);


ALTER TABLE public.description_values OWNER TO naval;

--
-- Name: description_values_in_line; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE description_values_in_line (
    description_value_id bigint NOT NULL,
    field_name character varying(255),
    value character varying(255)
);


ALTER TABLE public.description_values_in_line OWNER TO naval;

--
-- Name: direct_advance_assignment; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE direct_advance_assignment (
    advance_assignment_id bigint NOT NULL,
    direct_order_element_id bigint,
    max_value numeric(19,2)
);


ALTER TABLE public.direct_advance_assignment OWNER TO naval;

--
-- Name: entity_sequence; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE entity_sequence (
    id bigint NOT NULL,
    version bigint NOT NULL,
    entity_name integer,
    prefix character varying(255),
    last_value integer,
    number_of_digits integer,
    active boolean
);


ALTER TABLE public.entity_sequence OWNER TO naval;

--
-- Name: external_company; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE external_company (
    id bigint NOT NULL,
    version bigint NOT NULL,
    name character varying(255),
    nif character varying(255),
    client boolean,
    subcontractor boolean,
    interacts_with_applications boolean,
    app_uri character varying(255),
    our_company_login character varying(255),
    our_company_password character varying(255),
    company_user bigint
);


ALTER TABLE public.external_company OWNER TO naval;

--
-- Name: generic_day_assignments_container; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE generic_day_assignments_container (
    id bigint NOT NULL,
    version bigint NOT NULL,
    resource_allocation_id bigint,
    scenario bigint,
    start_date date,
    duration_start_in_first_day integer,
    end_date date,
    duration_in_last_day integer
);


ALTER TABLE public.generic_day_assignments_container OWNER TO naval;

--
-- Name: generic_resource_allocation; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE generic_resource_allocation (
    resource_allocation_id bigint NOT NULL,
    resource_type integer
);


ALTER TABLE public.generic_resource_allocation OWNER TO naval;

--
-- Name: heading_field; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE heading_field (
    heading_id bigint NOT NULL,
    fieldname character varying(255),
    length integer,
    positionnumber integer
);


ALTER TABLE public.heading_field OWNER TO naval;

--
-- Name: hibernate_unique_key; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE hibernate_unique_key (
    next_hi integer
);


ALTER TABLE public.hibernate_unique_key OWNER TO naval;

--
-- Name: hour_cost; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE hour_cost (
    id bigint NOT NULL,
    version bigint NOT NULL,
    code character varying(255) NOT NULL,
    price_cost numeric(19,2),
    init_date date,
    end_date date,
    type_of_work_hours_id bigint,
    cost_category_id bigint
);


ALTER TABLE public.hour_cost OWNER TO naval;

--
-- Name: hours_group; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE hours_group (
    id bigint NOT NULL,
    version bigint NOT NULL,
    code character varying(255) NOT NULL,
    resource_type character varying(255),
    working_hours integer NOT NULL,
    percentage numeric(19,2),
    fixed_percentage boolean,
    parent_order_line bigint,
    order_line_template bigint
);


ALTER TABLE public.hours_group OWNER TO naval;

--
-- Name: indirect_advance_assignment; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE indirect_advance_assignment (
    advance_assignment_id bigint NOT NULL,
    indirect_order_element_id bigint
);


ALTER TABLE public.indirect_advance_assignment OWNER TO naval;

--
-- Name: label; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE label (
    id bigint NOT NULL,
    version bigint NOT NULL,
    code character varying(255) NOT NULL,
    name character varying(255),
    label_type_id bigint
);


ALTER TABLE public.label OWNER TO naval;

--
-- Name: label_type; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE label_type (
    id bigint NOT NULL,
    version bigint NOT NULL,
    code character varying(255) NOT NULL,
    name character varying(255),
    code_autogenerated boolean NOT NULL,
    last_label_sequence_code integer
);


ALTER TABLE public.label_type OWNER TO naval;

--
-- Name: limiting_resource_queue; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE limiting_resource_queue (
    id bigint NOT NULL,
    version bigint NOT NULL,
    resource_id bigint
);


ALTER TABLE public.limiting_resource_queue OWNER TO naval;

--
-- Name: limiting_resource_queue_dependency; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE limiting_resource_queue_dependency (
    id bigint NOT NULL,
    type integer,
    origin_queue_element_id bigint,
    destiny_queue_element_id bigint
);


ALTER TABLE public.limiting_resource_queue_dependency OWNER TO naval;

--
-- Name: limiting_resource_queue_element; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE limiting_resource_queue_element (
    id bigint NOT NULL,
    version bigint NOT NULL,
    resource_allocation_id bigint,
    limiting_resource_queue_id bigint,
    earlier_start_date_because_of_gantt timestamp with time zone,
    earliest_end_date_because_of_gantt timestamp with time zone,
    creation_timestamp bigint,
    start_date date,
    start_hour integer,
    end_date date,
    end_hour integer
);


ALTER TABLE public.limiting_resource_queue_element OWNER TO naval;

--
-- Name: line_field; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE line_field (
    heading_id bigint NOT NULL,
    fieldname character varying(255),
    length integer,
    positionnumber integer
);


ALTER TABLE public.line_field OWNER TO naval;

--
-- Name: machine; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE machine (
    machine_id bigint NOT NULL,
    name character varying(255),
    description character varying(255)
);


ALTER TABLE public.machine OWNER TO naval;

--
-- Name: machine_configuration_unit_required_criterions; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE machine_configuration_unit_required_criterions (
    id bigint NOT NULL,
    criterion_id bigint NOT NULL
);


ALTER TABLE public.machine_configuration_unit_required_criterions OWNER TO naval;

--
-- Name: machine_worker_assignment; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE machine_worker_assignment (
    id bigint NOT NULL,
    version bigint NOT NULL,
    start_date timestamp with time zone,
    finish_date timestamp with time zone,
    configuration_id bigint NOT NULL,
    worker_id bigint
);


ALTER TABLE public.machine_worker_assignment OWNER TO naval;

--
-- Name: machine_workers_configuration_unit; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE machine_workers_configuration_unit (
    id bigint NOT NULL,
    version bigint NOT NULL,
    name character varying(255) NOT NULL,
    alpha numeric(19,2) NOT NULL,
    machine bigint NOT NULL
);


ALTER TABLE public.machine_workers_configuration_unit OWNER TO naval;

--
-- Name: material; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE material (
    id bigint NOT NULL,
    version bigint NOT NULL,
    code character varying(255) NOT NULL,
    description character varying(255),
    default_unit_price numeric(19,2),
    unit_type bigint,
    disabled boolean,
    category_id bigint
);


ALTER TABLE public.material OWNER TO naval;

--
-- Name: material_assigment; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE material_assigment (
    id bigint NOT NULL,
    version bigint NOT NULL,
    units numeric(19,2),
    unit_price numeric(19,2),
    material_id bigint,
    estimated_availability timestamp with time zone,
    status integer,
    order_element_id bigint
);


ALTER TABLE public.material_assigment OWNER TO naval;

--
-- Name: material_assigment_template; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE material_assigment_template (
    id bigint NOT NULL,
    version bigint NOT NULL,
    units numeric(19,2),
    unit_price numeric(19,2),
    material_id bigint,
    order_element_template_id bigint
);


ALTER TABLE public.material_assigment_template OWNER TO naval;

--
-- Name: material_category; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE material_category (
    id bigint NOT NULL,
    version bigint NOT NULL,
    code character varying(255) NOT NULL,
    name character varying(255),
    code_autogenerated boolean NOT NULL,
    last_material_sequence_code integer NOT NULL,
    parent_id bigint
);


ALTER TABLE public.material_category OWNER TO naval;

--
-- Name: order_authorization; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE order_authorization (
    id bigint NOT NULL,
    order_authorization_subclass character varying(255) NOT NULL,
    version bigint NOT NULL,
    authorization_type character varying(255) NOT NULL,
    order_id bigint,
    user_id bigint,
    profile_id bigint
);


ALTER TABLE public.order_authorization OWNER TO naval;

--
-- Name: order_element; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE order_element (
    id bigint NOT NULL,
    version bigint NOT NULL,
    name character varying(255),
    description character varying(255),
    code character varying(255),
    init_date timestamp with time zone,
    deadline timestamp with time zone,
    last_advance_meausurement_for_spreading numeric(19,2),
    dirty_last_advance_measurement_for_spreading boolean,
    parent bigint,
    template bigint,
    external_code character varying(255),
    sum_charged_hours_id bigint,
    position_in_container integer
);


ALTER TABLE public.order_element OWNER TO naval;

--
-- Name: order_element_label; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE order_element_label (
    order_element_id bigint NOT NULL,
    label_id bigint NOT NULL
);


ALTER TABLE public.order_element_label OWNER TO naval;

--
-- Name: order_element_template; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE order_element_template (
    id bigint NOT NULL,
    version bigint NOT NULL,
    name character varying(255),
    description character varying(255),
    code character varying(255),
    start_as_days_from_beginning integer,
    deadline_as_days_from_beginning integer,
    scheduling_state_type integer,
    parent bigint,
    position_in_container integer
);


ALTER TABLE public.order_element_template OWNER TO naval;

--
-- Name: order_element_template_label; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE order_element_template_label (
    order_element_template_id bigint NOT NULL,
    label_id bigint NOT NULL
);


ALTER TABLE public.order_element_template_label OWNER TO naval;

--
-- Name: order_element_template_quality_form; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE order_element_template_quality_form (
    order_element_template_id bigint NOT NULL,
    quality_form_id bigint NOT NULL
);


ALTER TABLE public.order_element_template_quality_form OWNER TO naval;

--
-- Name: order_line; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE order_line (
    order_element_id bigint NOT NULL,
    last_hours_group_sequence_code integer
);


ALTER TABLE public.order_line OWNER TO naval;

--
-- Name: order_line_group; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE order_line_group (
    order_element_id bigint NOT NULL
);


ALTER TABLE public.order_line_group OWNER TO naval;

--
-- Name: order_line_group_template; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE order_line_group_template (
    group_template_id bigint NOT NULL
);


ALTER TABLE public.order_line_group_template OWNER TO naval;

--
-- Name: order_line_template; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE order_line_template (
    order_line_template_id bigint NOT NULL,
    last_hours_group_sequence_code integer
);


ALTER TABLE public.order_line_template OWNER TO naval;

--
-- Name: order_table; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE order_table (
    order_element_id bigint NOT NULL,
    responsible character varying(255),
    dependencies_constraints_have_priority boolean,
    code_autogenerated boolean,
    last_order_element_sequence_code integer,
    work_budget numeric(19,2),
    materials_budget numeric(19,2),
    total_hours integer,
    customer_reference character varying(255),
    external_code character varying(255),
    state integer,
    customer bigint,
    base_calendar_id bigint,
    scheduling_mode integer
);


ALTER TABLE public.order_table OWNER TO naval;

--
-- Name: order_template; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE order_template (
    order_template_id bigint NOT NULL,
    base_calendar_id bigint
);


ALTER TABLE public.order_template OWNER TO naval;

--
-- Name: order_version; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE order_version (
    id bigint NOT NULL,
    version bigint NOT NULL,
    modification_by_owner_timestamp timestamp with time zone,
    ownerscenario bigint
);


ALTER TABLE public.order_version OWNER TO naval;

--
-- Name: planning_data; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE planning_data (
    planning_data_id bigint NOT NULL,
    progress_by_duration numeric(19,6),
    progress_by_num_hours numeric(19,6)
);


ALTER TABLE public.planning_data OWNER TO naval;

--
-- Name: profile_roles; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE profile_roles (
    profile_id bigint NOT NULL,
    elt character varying(255)
);


ALTER TABLE public.profile_roles OWNER TO naval;

--
-- Name: profile_table; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE profile_table (
    id bigint NOT NULL,
    version bigint NOT NULL,
    profile_name character varying(255) NOT NULL
);


ALTER TABLE public.profile_table OWNER TO naval;

--
-- Name: quality_form; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE quality_form (
    id bigint NOT NULL,
    version bigint NOT NULL,
    name character varying(255),
    description character varying(255),
    quality_form_type integer,
    report_advance boolean,
    advance_type_id bigint
);


ALTER TABLE public.quality_form OWNER TO naval;

--
-- Name: quality_form_items; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE quality_form_items (
    quality_form_id bigint NOT NULL,
    name character varying(255),
    percentage numeric(19,2),
    "position" integer,
    idx integer NOT NULL
);


ALTER TABLE public.quality_form_items OWNER TO naval;

--
-- Name: resource; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE resource (
    id bigint NOT NULL,
    version bigint NOT NULL,
    code character varying(255) NOT NULL,
    code_autogenerated boolean NOT NULL,
    base_calendar_id bigint,
    resource_type character varying(64) NOT NULL
);


ALTER TABLE public.resource OWNER TO naval;

--
-- Name: resource_allocation; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE resource_allocation (
    id bigint NOT NULL,
    version bigint NOT NULL,
    resources_per_day numeric(19,2),
    intended_total_hours integer,
    task bigint,
    assignment_function bigint,
    intended_resources_per_day numeric(19,2),
    intended_total_assignment integer DEFAULT 0,
    intended_non_consolidated_effort integer DEFAULT 0
);


ALTER TABLE public.resource_allocation OWNER TO naval;

--
-- Name: resource_calendar; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE resource_calendar (
    base_calendar_id bigint NOT NULL,
    capacity integer NOT NULL
);


ALTER TABLE public.resource_calendar OWNER TO naval;

--
-- Name: resources_cost_category_assignment; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE resources_cost_category_assignment (
    id bigint NOT NULL,
    version bigint NOT NULL,
    code character varying(255) NOT NULL,
    init_date date,
    end_date date,
    cost_category_id bigint,
    resource_id bigint
);


ALTER TABLE public.resources_cost_category_assignment OWNER TO naval;

--
-- Name: roles_table; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE roles_table (
    user_id bigint NOT NULL,
    elt character varying(255)
);


ALTER TABLE public.roles_table OWNER TO naval;

--
-- Name: scenario; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE scenario (
    id bigint NOT NULL,
    version bigint NOT NULL,
    name character varying(255),
    description character varying(255),
    last_not_owned_reassignations_time_stamp timestamp with time zone,
    predecessor bigint
);


ALTER TABLE public.scenario OWNER TO naval;

--
-- Name: scenario_orders; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE scenario_orders (
    order_id bigint NOT NULL,
    order_version_id bigint NOT NULL,
    scenario_id bigint NOT NULL
);


ALTER TABLE public.scenario_orders OWNER TO naval;

--
-- Name: scheduling_data_for_version; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE scheduling_data_for_version (
    id bigint NOT NULL,
    version bigint NOT NULL,
    scheduling_state_type integer,
    order_element_id bigint
);


ALTER TABLE public.scheduling_data_for_version OWNER TO naval;

--
-- Name: scheduling_states_by_order_version; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE scheduling_states_by_order_version (
    order_element_id bigint NOT NULL,
    scheduling_state_for_version_id bigint NOT NULL,
    order_version_id bigint NOT NULL
);


ALTER TABLE public.scheduling_states_by_order_version OWNER TO naval;

--
-- Name: sigmoid_function; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE sigmoid_function (
    assignment_function_id bigint NOT NULL
);


ALTER TABLE public.sigmoid_function OWNER TO naval;

--
-- Name: specific_day_assignments_container; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE specific_day_assignments_container (
    id bigint NOT NULL,
    version bigint NOT NULL,
    resource_allocation_id bigint,
    scenario bigint,
    start_date date,
    duration_start_in_first_day integer,
    end_date date,
    duration_in_last_day integer
);


ALTER TABLE public.specific_day_assignments_container OWNER TO naval;

--
-- Name: specific_resource_allocation; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE specific_resource_allocation (
    resource_allocation_id bigint NOT NULL,
    resource bigint
);


ALTER TABLE public.specific_resource_allocation OWNER TO naval;

--
-- Name: stretches; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE stretches (
    assignment_function_id bigint NOT NULL,
    date date NOT NULL,
    length_percentage numeric(19,2) NOT NULL,
    amount_work_percentage numeric(19,2) NOT NULL,
    stretch_position integer NOT NULL
);


ALTER TABLE public.stretches OWNER TO naval;

--
-- Name: stretches_function; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE stretches_function (
    assignment_function_id bigint NOT NULL,
    type integer
);


ALTER TABLE public.stretches_function OWNER TO naval;

--
-- Name: subcontracted_task_data; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE subcontracted_task_data (
    id bigint NOT NULL,
    version bigint NOT NULL,
    external_company bigint,
    subcontratation_date timestamp with time zone,
    subcontract_communication_date timestamp with time zone,
    work_description character varying(255),
    subcontract_price numeric(19,2),
    subcontracted_code character varying(255),
    node_without_children_exported boolean,
    labels_exported boolean,
    material_assignments_exported boolean,
    hours_groups_exported boolean,
    state integer
);


ALTER TABLE public.subcontracted_task_data OWNER TO naval;

--
-- Name: sum_charged_hours; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE sum_charged_hours (
    id bigint NOT NULL,
    version bigint NOT NULL,
    direct_charged_hours integer,
    indirect_charged_hours integer
);


ALTER TABLE public.sum_charged_hours OWNER TO naval;

--
-- Name: task; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE task (
    task_element_id bigint NOT NULL,
    calculated_value integer,
    constraint_type integer,
    constraint_date date,
    workable_days integer,
    allocation_direction integer,
    subcontrated_task_data_id bigint,
    priority integer
);


ALTER TABLE public.task OWNER TO naval;

--
-- Name: task_element; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE task_element (
    id bigint NOT NULL,
    version bigint NOT NULL,
    name character varying(255),
    notes character varying(255),
    start_date date NOT NULL,
    start_day_duration integer,
    end_date date NOT NULL,
    end_day_duration integer,
    deadline date,
    advance_percentage numeric(19,4),
    sum_of_hours_allocated integer,
    parent bigint,
    base_calendar_id bigint,
    position_in_parent integer
);


ALTER TABLE public.task_element OWNER TO naval;

--
-- Name: task_group; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE task_group (
    task_element_id bigint NOT NULL
);


ALTER TABLE public.task_group OWNER TO naval;

--
-- Name: task_milestone; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE task_milestone (
    task_element_id bigint NOT NULL,
    constraint_type integer,
    constraint_date date
);


ALTER TABLE public.task_milestone OWNER TO naval;

--
-- Name: task_quality_form; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE task_quality_form (
    id bigint NOT NULL,
    version bigint NOT NULL,
    quality_form_id bigint,
    order_element_id bigint,
    report_advance boolean
);


ALTER TABLE public.task_quality_form OWNER TO naval;

--
-- Name: task_quality_form_items; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE task_quality_form_items (
    task_quality_form_id bigint NOT NULL,
    name character varying(255),
    percentage numeric(19,2),
    "position" integer,
    passed boolean,
    date timestamp with time zone,
    idx integer NOT NULL
);


ALTER TABLE public.task_quality_form_items OWNER TO naval;

--
-- Name: task_source; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE task_source (
    id bigint NOT NULL,
    version bigint NOT NULL,
    schedulingdata bigint
);


ALTER TABLE public.task_source OWNER TO naval;

--
-- Name: task_source_hours_groups; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE task_source_hours_groups (
    task_source_id bigint NOT NULL,
    hours_group_id bigint NOT NULL
);


ALTER TABLE public.task_source_hours_groups OWNER TO naval;

--
-- Name: type_of_work_hours; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE type_of_work_hours (
    id bigint NOT NULL,
    version bigint NOT NULL,
    name character varying(255),
    code character varying(255),
    default_price numeric(19,2),
    enabled boolean,
    code_autogenerated boolean NOT NULL
);


ALTER TABLE public.type_of_work_hours OWNER TO naval;

--
-- Name: unit_type; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE unit_type (
    id bigint NOT NULL,
    version bigint NOT NULL,
    code character varying(255) NOT NULL,
    measure character varying(255),
    code_autogenerated boolean NOT NULL
);


ALTER TABLE public.unit_type OWNER TO naval;

--
-- Name: user_profiles; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE user_profiles (
    user_id bigint NOT NULL,
    profile_id bigint NOT NULL
);


ALTER TABLE public.user_profiles OWNER TO naval;

--
-- Name: user_table; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE user_table (
    id bigint NOT NULL,
    version bigint NOT NULL,
    login_name character varying(255) NOT NULL,
    password character varying(255) NOT NULL,
    email character varying(255),
    disabled boolean,
    lastconnectedscenario bigint
);


ALTER TABLE public.user_table OWNER TO naval;

--
-- Name: virtual_worker; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE virtual_worker (
    virtual_worker_id bigint NOT NULL,
    observations character varying(255)
);


ALTER TABLE public.virtual_worker OWNER TO naval;

--
-- Name: work_report; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE work_report (
    id bigint NOT NULL,
    version bigint NOT NULL,
    code character varying(255) NOT NULL,
    date timestamp with time zone,
    code_autogenerated boolean NOT NULL,
    last_work_report_line_sequence_code integer,
    ork_report_type_id bigint NOT NULL,
    resource_id bigint,
    order_element_id bigint
);


ALTER TABLE public.work_report OWNER TO naval;

--
-- Name: work_report_label_type_assigment; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE work_report_label_type_assigment (
    id bigint NOT NULL,
    version bigint NOT NULL,
    labels_shared_by_lines boolean,
    position_number integer,
    label_type_id bigint,
    label_id bigint,
    work_report_type_id bigint
);


ALTER TABLE public.work_report_label_type_assigment OWNER TO naval;

--
-- Name: work_report_line; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE work_report_line (
    id bigint NOT NULL,
    version bigint NOT NULL,
    code character varying(255) NOT NULL,
    num_hours integer,
    date timestamp with time zone,
    clock_start integer,
    clock_finish integer,
    work_report_id bigint,
    resource_id bigint NOT NULL,
    order_element_id bigint NOT NULL,
    type_work_hours_id bigint NOT NULL
);


ALTER TABLE public.work_report_line OWNER TO naval;

--
-- Name: work_report_type; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE work_report_type (
    id bigint NOT NULL,
    version bigint NOT NULL,
    name character varying(255),
    code character varying(255),
    date_is_shared_by_lines boolean,
    resource_is_shared_in_lines boolean,
    order_element_is_shared_in_lines boolean,
    code_autogenerated boolean NOT NULL,
    hours_management integer
);


ALTER TABLE public.work_report_type OWNER TO naval;

--
-- Name: worker; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE worker (
    worker_id bigint NOT NULL,
    first_name character varying(255),
    surname character varying(255),
    nif character varying(255)
);


ALTER TABLE public.worker OWNER TO naval;

--
-- Name: workreports_labels; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE workreports_labels (
    work_report_id bigint NOT NULL,
    label_id bigint NOT NULL
);


ALTER TABLE public.workreports_labels OWNER TO naval;

--
-- Name: workreportslines_labels; Type: TABLE; Schema: public; Owner: naval; Tablespace: 
--

CREATE TABLE workreportslines_labels (
    work_report_line_id bigint NOT NULL,
    label_id bigint NOT NULL
);


ALTER TABLE public.workreportslines_labels OWNER TO naval;

--
-- Data for Name: advance_assignment; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY advance_assignment (id, version, report_global_advance, advance_type_id) FROM stdin;
2525	11	t	1112
2526	11	t	1113
2527	11	t	1112
2528	11	t	1112
2529	11	t	1112
2530	10	f	1112
2531	10	t	1111
2532	11	t	1112
2533	11	t	1112
2534	11	t	1112
2535	10	t	1111
2536	10	f	1112
2537	11	t	1112
2538	10	f	1112
2539	10	t	1111
2600	2	f	1113
6165	7	f	1112
6166	7	t	1111
6161	9	t	1112
6162	9	t	1112
6163	7	t	1111
6164	7	f	1112
2601	4	t	1112
2603	4	t	1111
2602	4	f	1112
\.


--
-- Data for Name: advance_assignment_template; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY advance_assignment_template (id, version, advance_type_id, order_element_template_id, report_global_advance, max_value) FROM stdin;
\.


--
-- Data for Name: advance_measurement; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY advance_measurement (id, version, date, value, advance_assignment_id, communication_date) FROM stdin;
4264	2	2011-03-01	25.00	2525	\N
4265	2	2011-03-25	3.00	2526	\N
4266	2	2011-03-11	2.00	2526	\N
4267	2	2011-03-04	1.00	2526	\N
7689	0	2011-05-02	20.00	6162	\N
7491	1	2011-05-02	20.00	6161	\N
\.


--
-- Data for Name: advance_type; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY advance_type (id, version, unit_name, default_max_value, updatable, unit_precision, active, percentage, quality_form) FROM stdin;
1111	4	children	100.0000	f	0.0100	t	t	f
1112	3	percentage	100.0000	f	0.0100	t	t	f
1113	2	units	2147483647.0000	f	1.0000	t	f	f
1114	1	subcontractor	100.0000	f	0.0100	t	t	f
\.


--
-- Data for Name: all_criterions; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY all_criterions (generic_resource_allocation_id, criterion_id) FROM stdin;
3135	611
3136	610
3136	614
3137	614
3137	610
3141	613
3141	610
3142	610
3142	613
3143	610
3143	613
3145	612
3146	611
7171	6363
7172	6363
\.


--
-- Data for Name: assignment_function; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY assignment_function (id, version) FROM stdin;
\.


--
-- Data for Name: base_calendar; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY base_calendar (id, version, code, name, code_autogenerated, last_sequence_code) FROM stdin;
202	2	CALENDAR00001	España	t	1
204	1	CALENDAR00005	Galicia	t	4
205	2	CALENDAR00006	Comunidad Valenciana	t	4
206	4	RESOURCE_CALENDAR00001	\N	t	26
207	3	RESOURCE_CALENDAR00002	\N	t	11
208	4	RESOURCE_CALENDAR00003	\N	t	24
209	4	RESOURCE_CALENDAR00004	\N	t	14
210	4	RESOURCE_CALENDAR00005	\N	t	2
6666	1	RESOURCE_CALENDAR00006	\N	t	2
\.


--
-- Data for Name: calendar_availability; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY calendar_availability (id, version, code, start_date, end_date, base_calendar_id, position_in_calendar) FROM stdin;
1717	4	RESOURCE_CALENDAR00001-00005	2011-03-01	\N	206	0
1718	3	RESOURCE_CALENDAR00002-00005	2011-03-01	2011-06-30	207	0
1719	4	RESOURCE_CALENDAR00003-00005	2011-03-01	\N	208	0
1720	4	RESOURCE_CALENDAR00004-00005	2011-03-01	\N	209	0
1721	4	RESOURCE_CALENDAR00005-00002	2011-03-01	\N	210	0
6868	1	RESOURCE_CALENDAR00006-00002	2011-05-02	\N	6666	0
\.


--
-- Data for Name: calendar_data; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY calendar_data (id, version, code, parent, expiring_date, base_calendar_id, position_in_calendar) FROM stdin;
303	2	CALENDAR00001-00001	\N	\N	202	0
305	1	CALENDAR00005-00004	202	\N	204	0
306	2	CALENDAR00006-00002	202	\N	205	0
307	4	RESOURCE_CALENDAR00001-00004	204	\N	206	0
308	3	RESOURCE_CALENDAR00002-00004	205	\N	207	0
309	4	RESOURCE_CALENDAR00003-00004	205	\N	208	0
310	4	RESOURCE_CALENDAR00004-00004	204	\N	209	0
311	4	RESOURCE_CALENDAR00005-00001	202	\N	210	0
6767	1	RESOURCE_CALENDAR00006-00001	202	\N	6666	0
\.


--
-- Data for Name: calendar_exception; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY calendar_exception (id, version, code, date, standard_effort, calendar_exception_id, base_calendar_id, allowed_extra_effort) FROM stdin;
1313	1	CALENDAR00005-00001	2011-04-22	0	711	204	0
1314	1	CALENDAR00005-00002	2011-12-30	14400	712	204	\N
1315	1	CALENDAR00005-00003	2011-05-17	0	711	204	0
1316	2	CALENDAR00006-00001	2011-04-12	0	711	205	\N
1317	1	CALENDAR00006-00003	2011-12-30	0	712	205	\N
1318	1	CALENDAR00006-00004	2011-10-10	0	711	205	0
1320	2	RESOURCE_CALENDAR00001-00018	2011-06-11	0	707	206	0
1330	2	RESOURCE_CALENDAR00001-00017	2011-06-12	0	707	206	0
1324	2	RESOURCE_CALENDAR00001-00014	2011-06-07	0	707	206	0
1321	2	RESOURCE_CALENDAR00001-00010	2011-06-10	0	707	206	0
1329	2	RESOURCE_CALENDAR00001-00022	2011-06-08	0	707	206	0
1327	2	RESOURCE_CALENDAR00001-00021	2011-06-06	0	707	206	0
1326	2	RESOURCE_CALENDAR00001-00020	2011-06-04	0	707	206	0
1325	2	RESOURCE_CALENDAR00001-00019	2011-06-01	0	707	206	0
1323	2	RESOURCE_CALENDAR00001-00013	2011-06-02	0	707	206	0
1319	2	RESOURCE_CALENDAR00001-00009	2011-06-03	0	707	206	0
1322	2	RESOURCE_CALENDAR00001-00012	2011-06-05	0	707	206	0
1328	2	RESOURCE_CALENDAR00001-00016	2011-06-09	0	707	206	0
1333	2	RESOURCE_CALENDAR00003-00009	2011-04-04	0	707	208	0
1339	2	RESOURCE_CALENDAR00003-00017	2011-04-01	0	707	208	0
1338	2	RESOURCE_CALENDAR00003-00016	2011-04-03	0	707	208	0
1340	2	RESOURCE_CALENDAR00003-00018	2011-04-06	0	707	208	0
1336	2	RESOURCE_CALENDAR00003-00013	2011-04-07	0	707	208	0
1337	2	RESOURCE_CALENDAR00003-00014	2011-04-05	0	707	208	0
1332	2	RESOURCE_CALENDAR00003-00020	2011-04-08	0	707	208	0
1334	2	RESOURCE_CALENDAR00003-00010	2011-04-02	0	707	208	0
1331	2	RESOURCE_CALENDAR00003-00019	2011-04-09	0	707	208	0
1335	2	RESOURCE_CALENDAR00003-00012	2011-04-10	0	707	208	0
\.


--
-- Data for Name: calendar_exception_type; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY calendar_exception_type (id, version, code, code_autogenerated, name, color, standard_effort, allowed_extra_effort) FROM stdin;
707	11	CALENDAR_EXCEPTION_TYPE00001	t	HOLIDAY	red	0	0
708	9	CALENDAR_EXCEPTION_TYPE00002	t	SICK_LEAVE	red	0	0
709	7	CALENDAR_EXCEPTION_TYPE00003	t	LEAVE	red	0	0
710	5	CALENDAR_EXCEPTION_TYPE00004	t	STRIKE	red	0	0
711	3	CALENDAR_EXCEPTION_TYPE00005	t	BANK_HOLIDAY	red	0	0
712	1	CALENDAR_EXCEPTION_TYPE00006	t	WORKABLE_BANK_HOLIDAY	orange	0	\N
\.


--
-- Data for Name: capacity_per_day; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY capacity_per_day (base_calendar_id, standard_effort, day_id, allowed_extra_effort) FROM stdin;
303	28800	0	\N
303	28800	1	\N
303	28800	2	\N
303	28800	3	\N
303	28800	4	\N
303	0	5	0
303	0	6	0
\.


--
-- Data for Name: configuration; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY configuration (id, version, configuration_id, company_code, generate_code_for_cost_category, generate_code_for_calendar_exception_type, generate_code_for_work_report_type, generate_code_for_criterion, generate_code_for_label, generate_code_for_work_report, generate_code_for_resources, generate_code_for_types_of_work_hours, generate_code_for_material_categories, generate_code_for_unit_types, generate_code_for_base_calendars, expand_company_planning_view_charts, expand_order_planning_view_charts, expand_resource_load_view_charts, monte_carlo_method_tab_visible, progress_type, company_logo_url, scenarios_visible, changed_default_admin_password, changed_default_user_password, changed_default_wsreader_password, changed_default_wswriter_password) FROM stdin;
404	1	202	COMPANY_CODE	t	t	t	t	t	t	t	t	t	t	t	f	t	t	f	0		f	f	f	f	f
\.


--
-- Data for Name: consolidated_value; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY consolidated_value (id, consolidated_value_type, version, date, value, task_end_date, consolidation_id, advance_measurement_id) FROM stdin;
4646	non_calculated	1	2011-03-04	16.00	2011-03-29	2627	4267
4647	non_calculated	1	2011-03-11	33.00	2011-03-29	2627	4266
4648	non_calculated	1	2011-03-25	50.00	2011-03-29	2627	4265
7576	non_calculated	2	2011-05-02	20.00	2011-05-03	6262	7491
7878	non_calculated	1	2011-05-02	20.00	2011-05-06	6263	7689
\.


--
-- Data for Name: consolidation; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY consolidation (id, consolidation_type, version, dir_advance_assignment_id, ind_advance_assignment_id) FROM stdin;
2627	non_calculated	1	2526	\N
6263	non_calculated	0	6162	\N
6262	non_calculated	1	6161	\N
\.


--
-- Data for Name: cost_category; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY cost_category (id, version, code, name, code_autogenerated, last_hour_cost_sequence_code, enabled) FROM stdin;
\.


--
-- Data for Name: criterion; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY criterion (id, version, code, name, predefined_criterion_internal_name, active, id_criterion_type, parent) FROM stdin;
610	1	CRITERION00008-00001	Programador	\N	t	163847	\N
611	1	CRITERION00008-00002	Analista	\N	t	163847	\N
612	1	CRITERION00008-00003	Gestor de proyecto	\N	t	163847	\N
613	1	CRITERION00010-00002	Galicia	\N	t	163848	\N
614	1	CRITERION00010-00001	Comunidad Valenciana	\N	t	163848	\N
6363	1	CRITERION00003-00001	Plumber	\N	t	163842	\N
606	25	CRITERION00001-00001	medicalLeave	medicalLeave	t	163840	\N
607	23	CRITERION00001-00002	paternityLeave	paternityLeave	t	163840	\N
608	6	CRITERION00006-00001	hiredResourceWorkingRelationship	hiredResourceWorkingRelationship	t	163845	\N
609	4	CRITERION00006-00002	firedResourceWorkingRelationship	firedResourceWorkingRelationship	t	163845	\N
\.


--
-- Data for Name: criterion_requirement; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY criterion_requirement (id, criterion_requirement_type, version, hours_group_id, order_element_id, order_element_template_id, criterion_id, parent, valid) FROM stdin;
2813	direct	8	\N	1945	\N	612	\N	\N
2815	direct	8	\N	1946	\N	611	\N	\N
2825	indirect	6	2445	\N	\N	610	2818	t
2930	indirect	6	2446	\N	\N	614	2817	t
2931	indirect	6	2446	\N	\N	610	2818	t
2992	indirect	4	2447	\N	\N	610	2988	t
2993	indirect	4	2447	\N	\N	613	2989	t
2997	indirect	4	2448	\N	\N	610	2988	t
2996	indirect	4	2448	\N	\N	613	2989	t
6479	direct	4	\N	5565	\N	6363	\N	\N
6480	indirect	4	\N	5566	\N	6363	6479	t
3001	indirect	4	2449	\N	\N	610	2988	t
3000	indirect	4	2449	\N	\N	613	2989	t
6482	indirect	4	\N	5567	\N	6363	6479	t
6481	indirect	5	6064	\N	\N	6363	6479	t
6483	indirect	5	6065	\N	\N	6363	6479	t
2816	indirect	7	2443	\N	\N	611	2815	t
2818	direct	8	\N	1947	\N	610	\N	\N
2817	direct	8	\N	1947	\N	614	\N	\N
2820	indirect	8	\N	1948	\N	614	2817	t
2819	indirect	8	\N	1948	\N	610	2818	t
2823	indirect	8	\N	1949	\N	614	2817	t
2824	indirect	8	\N	1949	\N	610	2818	t
2827	indirect	8	\N	1950	\N	614	2817	t
2929	indirect	8	\N	1950	\N	610	2818	t
2988	direct	7	\N	1951	\N	610	\N	\N
2989	direct	7	\N	1951	\N	613	\N	\N
2822	indirect	6	2444	\N	\N	610	2818	t
2821	indirect	6	2444	\N	\N	614	2817	t
2826	indirect	6	2445	\N	\N	614	2817	t
2990	indirect	7	\N	1952	\N	613	2989	t
2991	indirect	7	\N	1952	\N	610	2988	t
2995	indirect	7	\N	1953	\N	610	2988	t
2994	indirect	7	\N	1953	\N	613	2989	t
2999	indirect	7	\N	1954	\N	613	2989	t
2998	indirect	7	\N	1954	\N	610	2988	t
2814	indirect	8	2442	\N	\N	612	2813	t
\.


--
-- Data for Name: criterion_satisfaction; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY criterion_satisfaction (id, version, code, start_date, finish_date, is_deleted, criterion, resource) FROM stdin;
1818	1	CRITERION_SATISFACTION00001	2011-03-01	\N	f	612	1617
1819	1	CRITERION_SATISFACTION00003	2011-03-01	\N	f	610	1619
1820	1	CRITERION_SATISFACTION00002	2011-03-01	\N	f	614	1619
1821	1	CRITERION_SATISFACTION00004	2011-03-01	\N	f	610	1621
1822	1	CRITERION_SATISFACTION00005	2011-03-01	\N	f	614	1621
1823	2	CRITERION_SATISFACTION00006	2011-03-01	\N	f	610	1623
1824	1	CRITERION_SATISFACTION00007	2011-03-01	\N	f	613	1623
1825	2	CRITERION_SATISFACTION00008	2011-03-01	\N	f	611	1625
6969	1	CRITERION_SATISFACTION00009	2011-05-02	\N	f	6363	6566
\.


--
-- Data for Name: criterion_type; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY criterion_type (id, version, code, name, predefined_type_internal_name, description, allow_simultaneous_criterions_per_resource, allow_hierarchy, last_criterion_sequence_code, enabled, code_autogenerated, resource) FROM stdin;
163840	26	CRITERION00001	LEAVE	LEAVE	Leave	f	f	2	t	t	0
163841	20	CRITERION00002	MACHINE_LOCATION_GROUP	MACHINE_LOCATION_GROUP	Location where there are machines	t	f	0	t	t	1
163843	14	CRITERION00004	TRAINING	TRAINING	Training courses and labor training	t	t	0	t	t	0
163844	11	CRITERION00005	JOB	JOB	Job	t	t	0	t	t	0
163845	8	CRITERION00006	WORK_RELATIONSHIP	WORK_RELATIONSHIP	Relationship of the resource with the enterprise 	f	f	2	t	t	0
163846	1	CRITERION00007	LOCATION_GROUP	LOCATION_GROUP	Location where the workers work	t	f	0	t	t	0
163847	1	CRITERION00008	Formación	\N	\N	t	f	3	t	t	0
163848	1	CRITERION00010	Lugar	\N	\N	f	f	2	t	t	0
163842	18	CRITERION00003	CATEGORY	CATEGORY	Professional category	t	t	1	t	t	0
\.


--
-- Data for Name: databasechangelog; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY databasechangelog (id, author, filename, dateexecuted, orderexecuted, exectype, md5sum, description, comments, tag, liquibase) FROM stdin;
initial-database-creation-1	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:16.186855+02	1	EXECUTED	3:87284be6dfb6ea083b10c1619407f7c1	Create Table		\N	2.0-rc7
initial-database-creation-2	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:16.425049+02	2	EXECUTED	3:2aefb17353f2d68f83d7ea332888b2d2	Create Table		\N	2.0-rc7
initial-database-creation-3	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:16.616809+02	3	EXECUTED	3:ce3ce8e0fc46ab2c47bec537a027020d	Create Table		\N	2.0-rc7
initial-database-creation-4	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:16.770025+02	4	EXECUTED	3:8ae2d70ea70faf93eae21de1a4791bf9	Create Table		\N	2.0-rc7
initial-database-creation-5	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:16.814458+02	5	EXECUTED	3:d4cbb5410783507d1303188c725dcc5d	Create Table		\N	2.0-rc7
initial-database-creation-6	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:16.940405+02	6	EXECUTED	3:4b1af7d520bb2c2a8988082ccbec49a1	Create Table		\N	2.0-rc7
initial-database-creation-7	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:17.194665+02	7	EXECUTED	3:178842eb14f060ccbf7dea76bf5af6bd	Create Table		\N	2.0-rc7
initial-database-creation-8	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:17.452643+02	8	EXECUTED	3:d4cc67e5a8c6c78b799bde5d242e2195	Create Table		\N	2.0-rc7
initial-database-creation-9	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:17.66783+02	9	EXECUTED	3:1471c2ce00d6fa11e62790063f4a8ce7	Create Table		\N	2.0-rc7
initial-database-creation-10	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:17.832832+02	10	EXECUTED	3:99da8d60f89ce090a0d7b78347609260	Create Table		\N	2.0-rc7
initial-database-creation-11	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:18.076114+02	11	EXECUTED	3:c4c671163b8fc0264bf99968acb44219	Create Table		\N	2.0-rc7
initial-database-creation-12	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:18.234686+02	12	EXECUTED	3:452c93639576a7872bae3bb973c082c9	Create Table		\N	2.0-rc7
initial-database-creation-13	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:18.376002+02	13	EXECUTED	3:2c243134662b3064f3ef7a54f643a63f	Create Table		\N	2.0-rc7
initial-database-creation-14	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:18.558739+02	14	EXECUTED	3:4f2cf6d40106c9669531b1e014e6bb4b	Create Table		\N	2.0-rc7
initial-database-creation-15	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:18.726473+02	15	EXECUTED	3:b252f07529385182dd76b7227b8b2df6	Create Table		\N	2.0-rc7
initial-database-creation-16	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:18.917447+02	16	EXECUTED	3:f9f0db95d3e41539dfa997f85b1f8e3f	Create Table		\N	2.0-rc7
initial-database-creation-17	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:19.119103+02	17	EXECUTED	3:34d174383669623cdb993c0095264a13	Create Table		\N	2.0-rc7
initial-database-creation-18	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:19.246237+02	18	EXECUTED	3:709d0d38037adc072d8712b6f4315838	Create Table		\N	2.0-rc7
initial-database-creation-19	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:19.411706+02	19	EXECUTED	3:69ca6bbf77a8533d06f4f88419ccdb05	Create Table		\N	2.0-rc7
initial-database-creation-20	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:19.588159+02	20	EXECUTED	3:2889d42f2a2a85c7eb3a809d77848a51	Create Table		\N	2.0-rc7
initial-database-creation-21	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:19.671225+02	21	EXECUTED	3:0611c8311723e4c28991c7740053d0d2	Create Table		\N	2.0-rc7
initial-database-creation-22	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:19.745145+02	22	EXECUTED	3:81a435f38886f060afe9ca818e913261	Create Table		\N	2.0-rc7
initial-database-creation-23	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:19.819983+02	23	EXECUTED	3:74f3adbe81d2a601f546ba200b09a3f7	Create Table		\N	2.0-rc7
initial-database-creation-24	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:19.891429+02	24	EXECUTED	3:018e6915527540f7fd80bdee4256e45e	Create Table		\N	2.0-rc7
initial-database-creation-25	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:19.991686+02	25	EXECUTED	3:776ceb220f93fa1ddc4de0e867796fe7	Create Table		\N	2.0-rc7
initial-database-creation-26	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:20.092093+02	26	EXECUTED	3:371a9aaff8a124b46a18ce3907d008d9	Create Table		\N	2.0-rc7
initial-database-creation-27	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:20.128261+02	27	EXECUTED	3:187671bca568e9241de664c949efe281	Create Table		\N	2.0-rc7
initial-database-creation-28	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:20.221687+02	28	EXECUTED	3:a8d920d19a5d47faf98b794f5c1f603f	Create Table		\N	2.0-rc7
initial-database-creation-29	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:20.366453+02	29	EXECUTED	3:92e44bddb74e3234b8dd878af11e845d	Create Table		\N	2.0-rc7
initial-database-creation-30	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:20.481031+02	30	EXECUTED	3:251d3f91f6327e40c56f0b03b891ced9	Create Table		\N	2.0-rc7
initial-database-creation-31	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:20.567288+02	31	EXECUTED	3:062933122f426b4c076f3ce7cdc137e1	Create Table		\N	2.0-rc7
initial-database-creation-32	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:20.595953+02	32	EXECUTED	3:32efbeaafe8a8119e0e5e64aced1058c	Create Table		\N	2.0-rc7
initial-database-creation-33	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:20.69871+02	33	EXECUTED	3:54dca2b96d16125bf30f18cda2c66fce	Create Table		\N	2.0-rc7
initial-database-creation-34	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:20.83405+02	34	EXECUTED	3:f61b483914059aa8d009b92973c2b741	Create Table		\N	2.0-rc7
initial-database-creation-35	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:20.935287+02	35	EXECUTED	3:061afed029091fd857051adfb4f3e16f	Create Table		\N	2.0-rc7
initial-database-creation-36	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:21.080773+02	36	EXECUTED	3:e48ab025e1a1d524e012edc32e2898c4	Create Table		\N	2.0-rc7
initial-database-creation-37	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:21.232566+02	37	EXECUTED	3:5730c05f83fa3e9f3e44af12bc6c35df	Create Table		\N	2.0-rc7
initial-database-creation-38	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:21.324673+02	38	EXECUTED	3:0463559767dcef01c508a8b5112f3deb	Create Table		\N	2.0-rc7
initial-database-creation-39	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:21.412727+02	39	EXECUTED	3:46b77528455345f785fc03a410645a49	Create Table		\N	2.0-rc7
initial-database-creation-40	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:21.508042+02	40	EXECUTED	3:dcd26b48d4d1b5ab3daf0e9832fe8992	Create Table		\N	2.0-rc7
initial-database-creation-41	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:21.53295+02	41	EXECUTED	3:4eaf1c4d6e0a11e1a80b8f0ec3dfb26f	Create Table		\N	2.0-rc7
initial-database-creation-42	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:21.663234+02	42	EXECUTED	3:ab99562e3d474bcf433bfcffff244e3a	Create Table		\N	2.0-rc7
initial-database-creation-43	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:21.695532+02	43	EXECUTED	3:40caa86c50a07b2be7634de7e67c9d0e	Create Table		\N	2.0-rc7
initial-database-creation-44	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:21.858236+02	44	EXECUTED	3:a69f6df9bb8e7d01ccfa2d207f11d2e3	Create Table		\N	2.0-rc7
initial-database-creation-45	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:21.958814+02	45	EXECUTED	3:eb496ba0d027b1187fb186640698e06f	Create Table		\N	2.0-rc7
initial-database-creation-46	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:22.093695+02	46	EXECUTED	3:c8d022d6b44493268cbf59046da51418	Create Table		\N	2.0-rc7
initial-database-creation-47	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:22.20189+02	47	EXECUTED	3:01a97c41dce3b7b81a63fb0a1f569899	Create Table		\N	2.0-rc7
initial-database-creation-48	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:22.308628+02	48	EXECUTED	3:1cad873594a66abddd12c12c84604e61	Create Table		\N	2.0-rc7
initial-database-creation-49	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:22.500226+02	49	EXECUTED	3:3c455645cb91a9aac51a133b1e12b182	Create Table		\N	2.0-rc7
initial-database-creation-50	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:22.645142+02	50	EXECUTED	3:5834995f8c74c44f779144302ca58aa8	Create Table		\N	2.0-rc7
initial-database-creation-51	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:22.825479+02	51	EXECUTED	3:91af15971dac5d7c2dce84f531b9dcba	Create Table		\N	2.0-rc7
initial-database-creation-52	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:22.852761+02	52	EXECUTED	3:9d97a58ae14e3b0df488a616f68d8608	Create Table		\N	2.0-rc7
initial-database-creation-53	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:23.004691+02	53	EXECUTED	3:3433718f7930939efac3cc1168af30e8	Create Table		\N	2.0-rc7
initial-database-creation-54	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:23.031806+02	54	EXECUTED	3:e3bcd846c10389b459e2cef110b48d03	Create Table		\N	2.0-rc7
initial-database-creation-55	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:23.061102+02	55	EXECUTED	3:a20bdf2e0492d12ab88800a2032bd2ef	Create Table		\N	2.0-rc7
initial-database-creation-56	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:23.141314+02	56	EXECUTED	3:d5c07b2ca1483b597a4958f0eb5e5a3b	Create Table		\N	2.0-rc7
initial-database-creation-57	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:23.232251+02	57	EXECUTED	3:b1d878c752a4a7414957d394ea125b7b	Create Table		\N	2.0-rc7
initial-database-creation-58	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:23.332432+02	58	EXECUTED	3:1a96fe994ab633f35d387545646dfb12	Create Table		\N	2.0-rc7
initial-database-creation-59	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:23.425538+02	59	EXECUTED	3:89ede9ab53c28bb85db8417ae9bc7fbc	Create Table		\N	2.0-rc7
initial-database-creation-60	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:23.584097+02	60	EXECUTED	3:844ad1ebc9bd9ebe3d891863297dc01e	Create Table		\N	2.0-rc7
initial-database-creation-61	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:23.68409+02	61	EXECUTED	3:032ef8f40d527af24513bb73a05ad30b	Create Table		\N	2.0-rc7
initial-database-creation-62	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:23.778177+02	62	EXECUTED	3:b372d24dcdf07a22993aa92210a29fa9	Create Table		\N	2.0-rc7
initial-database-creation-63	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:23.860313+02	63	EXECUTED	3:cb593df4f833185dfff6c8dfba97b379	Create Table		\N	2.0-rc7
initial-database-creation-64	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:23.888821+02	64	EXECUTED	3:4810d42263de2a4d69b4885b51d02926	Create Table		\N	2.0-rc7
initial-database-creation-65	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:23.970084+02	65	EXECUTED	3:62ed94d67820284c9b43f4a362cf45de	Create Table		\N	2.0-rc7
initial-database-creation-66	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:24.123159+02	66	EXECUTED	3:88c5e07b28f3b3206fe94e52687251f4	Create Table		\N	2.0-rc7
initial-database-creation-67	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:24.147839+02	67	EXECUTED	3:20434c4cf0634db9a1515d2e11416022	Create Table		\N	2.0-rc7
initial-database-creation-68	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:24.241232+02	68	EXECUTED	3:117358a8c04147322328a2b1cac33a75	Create Table		\N	2.0-rc7
initial-database-creation-69	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:24.331859+02	69	EXECUTED	3:22bac185422beb26fe40885095dcbb34	Create Table		\N	2.0-rc7
initial-database-creation-70	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:24.428098+02	70	EXECUTED	3:713a91ce3c891f67655bb35a2a13b864	Create Table		\N	2.0-rc7
initial-database-creation-71	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:24.532879+02	71	EXECUTED	3:0477d3268030fa94537c7feade9cb5bb	Create Table		\N	2.0-rc7
initial-database-creation-72	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:24.564498+02	72	EXECUTED	3:22fb8ba522b8dbc6e7e61fe9c674a1c6	Create Table		\N	2.0-rc7
initial-database-creation-73	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:24.71561+02	73	EXECUTED	3:9115f453c85a6c3b00ba0002e2e82c27	Create Table		\N	2.0-rc7
initial-database-creation-74	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:24.759527+02	74	EXECUTED	3:59abfaf50b92353b3392d523afb80969	Create Table		\N	2.0-rc7
initial-database-creation-75	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:24.872649+02	75	EXECUTED	3:eb08efbe1a928c05efe5a6d77895372d	Create Table		\N	2.0-rc7
initial-database-creation-76	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:24.925989+02	76	EXECUTED	3:097d7c0a3f4d17415c0e3c66eddf18bb	Create Table		\N	2.0-rc7
initial-database-creation-77	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:25.002981+02	77	EXECUTED	3:92738794f2d218b8f7f58971f3581ea9	Create Table		\N	2.0-rc7
initial-database-creation-78	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:25.101174+02	78	EXECUTED	3:4bce4c614eb82972bd2063a5234e2491	Create Table		\N	2.0-rc7
initial-database-creation-79	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:25.171622+02	79	EXECUTED	3:c0f68a9478bc3c047c5d5d7f2a284234	Create Table		\N	2.0-rc7
initial-database-creation-80	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:25.218011+02	80	EXECUTED	3:39c0a2239e6cde5985736f3be2f27626	Create Table		\N	2.0-rc7
initial-database-creation-81	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:25.296483+02	81	EXECUTED	3:162e5fdd2937f61c06272ce790429fa0	Create Table		\N	2.0-rc7
initial-database-creation-82	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:25.496784+02	82	EXECUTED	3:c005b68c44b0fc74c5d88694275a90cf	Create Table		\N	2.0-rc7
initial-database-creation-83	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:25.602325+02	83	EXECUTED	3:2b80090725b78875ae45c21375bf33bf	Create Table		\N	2.0-rc7
initial-database-creation-84	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:25.803704+02	84	EXECUTED	3:18484f614e0b39eb5cde9b22057b26cc	Create Table		\N	2.0-rc7
initial-database-creation-85	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:25.990469+02	85	EXECUTED	3:517c243c1a5aa8ca0c383da9291e4c9f	Create Table		\N	2.0-rc7
initial-database-creation-86	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:26.068268+02	86	EXECUTED	3:d29574cf2d006c44a8bd571ea259baca	Create Table		\N	2.0-rc7
initial-database-creation-87	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:26.143966+02	87	EXECUTED	3:7b0481f4efa29a9019638150d929a940	Create Table		\N	2.0-rc7
initial-database-creation-88	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:26.234697+02	88	EXECUTED	3:6a9a4185f7faf33d4b87d49b54de2333	Create Table		\N	2.0-rc7
initial-database-creation-89	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:26.269984+02	89	EXECUTED	3:efd40214f5cf8a38097f7a1b34e8a68e	Create Table		\N	2.0-rc7
initial-database-creation-90	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:26.349993+02	90	EXECUTED	3:10330857abbcf0c9290af11ab1b7c6fe	Create Table		\N	2.0-rc7
initial-database-creation-91	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:26.3906+02	91	EXECUTED	3:5b7e90c4778ef1c74a6c43e84b06e1d4	Create Table		\N	2.0-rc7
initial-database-creation-92	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:26.537247+02	92	EXECUTED	3:e02e26cb45df4971db19aac13828902c	Create Table		\N	2.0-rc7
initial-database-creation-93	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:26.679814+02	93	EXECUTED	3:4a5be81b3613a7fd188d4d17e57f3361	Create Table		\N	2.0-rc7
initial-database-creation-94	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:26.716288+02	94	EXECUTED	3:8cc56adb7cfb603625d0a39177931a40	Create Table		\N	2.0-rc7
initial-database-creation-95	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:26.87383+02	95	EXECUTED	3:38ade818ab692296716542a1a3537266	Create Table		\N	2.0-rc7
initial-database-creation-96	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:26.951306+02	96	EXECUTED	3:6a534d1bb1f41bcda8e1b4bcfa9b3743	Create Table		\N	2.0-rc7
initial-database-creation-97	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:27.066886+02	97	EXECUTED	3:d6ab9141ebc2b626870df9b3fdf9f71b	Create Table		\N	2.0-rc7
initial-database-creation-98	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:27.172992+02	98	EXECUTED	3:ee51513cc42a9622f4bccb90e9ed5a20	Create Table		\N	2.0-rc7
initial-database-creation-99	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:27.295973+02	99	EXECUTED	3:9ba9fcfef5ef6a98fde2a5d25c6fcff4	Create Table		\N	2.0-rc7
initial-database-creation-100	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:27.442746+02	100	EXECUTED	3:153c8c988ca92c96f458627cda56c3cc	Create Table		\N	2.0-rc7
initial-database-creation-101	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:27.595982+02	101	EXECUTED	3:9d3ca496f7e511946e922943183e5932	Create Table		\N	2.0-rc7
initial-database-creation-102	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:27.622988+02	102	EXECUTED	3:d6dde8ef9b633103e1faf2ccd8235eca	Create Table		\N	2.0-rc7
initial-database-creation-103	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:27.641093+02	103	EXECUTED	3:095302ae71ae5b3388f4f63505571fc7	Create Table		\N	2.0-rc7
initial-database-creation-104	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:27.742438+02	104	EXECUTED	3:2be3c0a86a52f173260a6a79155b60cc	Add Primary Key		\N	2.0-rc7
initial-database-creation-105	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:27.817797+02	105	EXECUTED	3:82c230b9db293d053bccccd467b1ab9d	Add Primary Key		\N	2.0-rc7
initial-database-creation-106	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:27.892456+02	106	EXECUTED	3:4c853cafe73f4c89f67bb0002669aef9	Add Primary Key		\N	2.0-rc7
initial-database-creation-107	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:27.96819+02	107	EXECUTED	3:6d80c191c12998505130d53cf263c75a	Add Primary Key		\N	2.0-rc7
initial-database-creation-108	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:28.051259+02	108	EXECUTED	3:3977bb6dc04fd58db716246745b90ae1	Add Primary Key		\N	2.0-rc7
initial-database-creation-109	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:28.126245+02	109	EXECUTED	3:342a26af869022073adea79de410b7fd	Add Primary Key		\N	2.0-rc7
initial-database-creation-110	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:28.201199+02	110	EXECUTED	3:5bb3e8ba37633a8962e3e3ba898640a0	Add Primary Key		\N	2.0-rc7
initial-database-creation-111	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:28.276467+02	111	EXECUTED	3:d8ceff8fc74714e8a2f9f32f209ebce2	Add Primary Key		\N	2.0-rc7
initial-database-creation-112	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:28.343188+02	112	EXECUTED	3:6de340a52a1104fdff59a4dcce101bf7	Add Primary Key		\N	2.0-rc7
initial-database-creation-113	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:28.409982+02	113	EXECUTED	3:60251fdbce5c98e388ec031b31bfd4a9	Add Primary Key		\N	2.0-rc7
initial-database-creation-114	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:28.484971+02	114	EXECUTED	3:b626caf2e59e63cb5bc2c448cd3bdcee	Add Primary Key		\N	2.0-rc7
initial-database-creation-115	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:28.560202+02	115	EXECUTED	3:6a1578d583d5a81b902bc403403fee5c	Add Primary Key		\N	2.0-rc7
initial-database-creation-116	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:28.635089+02	116	EXECUTED	3:753b6ac45bff766fd2b928a78fca140e	Add Primary Key		\N	2.0-rc7
initial-database-creation-117	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:28.710178+02	117	EXECUTED	3:96f91a1db7919278ef2d842b2bf9c862	Add Primary Key		\N	2.0-rc7
initial-database-creation-118	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:28.785331+02	118	EXECUTED	3:0d00c02ce9487bfc2130eb8f02c351ca	Add Primary Key		\N	2.0-rc7
initial-database-creation-119	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:28.893771+02	119	EXECUTED	3:25dfec85b614a70c20871d4ae926c94f	Add Unique Constraint		\N	2.0-rc7
initial-database-creation-120	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:28.968926+02	120	EXECUTED	3:a7e74e1eb13868c98f003be79f493c56	Add Unique Constraint		\N	2.0-rc7
initial-database-creation-121	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:29.04378+02	121	EXECUTED	3:7f0b4f8943f92f6cddc6cd1c4a6278cc	Add Unique Constraint		\N	2.0-rc7
initial-database-creation-122	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:29.110537+02	122	EXECUTED	3:8b3d9cfba701fb0c874f769f84f70516	Add Unique Constraint		\N	2.0-rc7
initial-database-creation-123	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:29.185499+02	123	EXECUTED	3:0981e3f7645750b97850fe1402142b0e	Add Unique Constraint		\N	2.0-rc7
initial-database-creation-124	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:29.260984+02	124	EXECUTED	3:ffe99b4e79ec3f0641be13e3bacf379f	Add Unique Constraint		\N	2.0-rc7
initial-database-creation-125	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:29.335677+02	125	EXECUTED	3:22aa1d1bc3b6a0f3fcd195e696857ba9	Add Unique Constraint		\N	2.0-rc7
initial-database-creation-126	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:29.410851+02	126	EXECUTED	3:07bb676976f50996b441e8c5cb69cfa2	Add Unique Constraint		\N	2.0-rc7
initial-database-creation-127	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:29.486013+02	127	EXECUTED	3:f384b319e3e6ac2c53e6f2c9a86d3dc0	Add Unique Constraint		\N	2.0-rc7
initial-database-creation-128	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:29.561061+02	128	EXECUTED	3:56e6439776ec45ea1c0c46be8f4790d6	Add Unique Constraint		\N	2.0-rc7
initial-database-creation-129	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:29.636131+02	129	EXECUTED	3:19e9b0d9faaed12478e5be2cb73571a1	Add Unique Constraint		\N	2.0-rc7
initial-database-creation-130	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:29.719549+02	130	EXECUTED	3:581b66f431f221130c109e7b5b3d79a1	Add Unique Constraint		\N	2.0-rc7
initial-database-creation-131	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:29.794373+02	131	EXECUTED	3:01284292a4f935475258277902264ea0	Add Unique Constraint		\N	2.0-rc7
initial-database-creation-132	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:29.869678+02	132	EXECUTED	3:6a21869f3ed25150b2a6eba6f6fa34a1	Add Unique Constraint		\N	2.0-rc7
initial-database-creation-133	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:29.944625+02	133	EXECUTED	3:883f0f92a13463c399b89d50a3edc8d8	Add Unique Constraint		\N	2.0-rc7
initial-database-creation-134	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:30.011909+02	134	EXECUTED	3:28433d4766db563d308c29fa88e6efb6	Add Unique Constraint		\N	2.0-rc7
initial-database-creation-135	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:30.094802+02	135	EXECUTED	3:93afd0268fdf710e41e215ede32bd0c7	Add Unique Constraint		\N	2.0-rc7
initial-database-creation-136	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:30.169929+02	136	EXECUTED	3:09b6669e29fddc80e8c71e376356e75f	Add Unique Constraint		\N	2.0-rc7
initial-database-creation-137	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:30.253133+02	137	EXECUTED	3:d0fb22f1498540b1d4a13ea905aa8bf9	Add Unique Constraint		\N	2.0-rc7
initial-database-creation-138	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:30.336725+02	138	EXECUTED	3:82729e55fe4c9e2ccd9c2a9182f38ba7	Add Unique Constraint		\N	2.0-rc7
initial-database-creation-139	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:30.420175+02	139	EXECUTED	3:667ac9a3119d5ef2050a8d7641b6fe6b	Add Unique Constraint		\N	2.0-rc7
initial-database-creation-140	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:30.494954+02	140	EXECUTED	3:01190ca80a2bd28599dc668c7184e41a	Add Unique Constraint		\N	2.0-rc7
initial-database-creation-141	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:30.578706+02	141	EXECUTED	3:3a8cc0400cb042e6038be04e9d926a05	Add Unique Constraint		\N	2.0-rc7
initial-database-creation-142	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:30.662149+02	142	EXECUTED	3:5a53439f8e5077092c3f5ce0b9b64c21	Add Unique Constraint		\N	2.0-rc7
initial-database-creation-143	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:30.728845+02	143	EXECUTED	3:96e2c867553b562a55d7fb2ea533ca71	Add Unique Constraint		\N	2.0-rc7
initial-database-creation-144	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:30.795405+02	144	EXECUTED	3:45c7dade3103b4abae6541d367af4646	Add Unique Constraint		\N	2.0-rc7
initial-database-creation-145	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:30.870483+02	145	EXECUTED	3:46fc2fe38a4124551b6f80beec0723ea	Add Unique Constraint		\N	2.0-rc7
initial-database-creation-146	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:30.945531+02	146	EXECUTED	3:703ecd41878d365d67ad634e081834ba	Add Unique Constraint		\N	2.0-rc7
initial-database-creation-147	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:31.020681+02	147	EXECUTED	3:d7b7260d265b86e5876c927d303c2307	Add Unique Constraint		\N	2.0-rc7
initial-database-creation-148	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:31.095545+02	148	EXECUTED	3:fd0cdc07177675faff1de4ce2d419aea	Add Unique Constraint		\N	2.0-rc7
initial-database-creation-149	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:31.194121+02	149	EXECUTED	3:7ca5452c5eda521966ff722b5e75447d	Add Unique Constraint		\N	2.0-rc7
initial-database-creation-150	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:31.262437+02	150	EXECUTED	3:0ecdada661fa702ab592847649bbd97a	Add Unique Constraint		\N	2.0-rc7
initial-database-creation-151	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:31.346035+02	151	EXECUTED	3:4b9d4c90bd12aab922901999d57da26c	Add Unique Constraint		\N	2.0-rc7
initial-database-creation-152	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:31.422548+02	152	EXECUTED	3:8f15ab0d59b79e0cf7d957de68f3deef	Add Unique Constraint		\N	2.0-rc7
initial-database-creation-153	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:31.492828+02	153	EXECUTED	3:774367d719df7294f6d6440f5ac517d4	Add Unique Constraint		\N	2.0-rc7
initial-database-creation-154	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:31.579609+02	154	EXECUTED	3:d2d48913de9694152030b963fc9143bf	Add Unique Constraint		\N	2.0-rc7
initial-database-creation-155	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:31.92133+02	155	EXECUTED	3:19bcbd19bad4ea32d85d004d1795b1a6	Add Unique Constraint		\N	2.0-rc7
initial-database-creation-156	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:32.00471+02	156	EXECUTED	3:31bb2a3ea7637c2f906524752befe266	Add Unique Constraint		\N	2.0-rc7
initial-database-creation-157	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:32.080137+02	157	EXECUTED	3:2894f29c57031879dba2f226cdae9927	Add Unique Constraint		\N	2.0-rc7
initial-database-creation-158	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:32.154629+02	158	EXECUTED	3:18c342a5d0a532e4fa4791dcce9880ba	Add Unique Constraint		\N	2.0-rc7
initial-database-creation-159	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:32.238323+02	159	EXECUTED	3:a47fff57bc9745af3813b6d938579e9c	Add Unique Constraint		\N	2.0-rc7
initial-database-creation-160	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:32.313062+02	160	EXECUTED	3:1da2f7a4ca6be20552fda03ab7a66577	Add Unique Constraint		\N	2.0-rc7
initial-database-creation-161	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:32.388181+02	161	EXECUTED	3:c4a50b93cede59c04d8d70a6d308149b	Add Unique Constraint		\N	2.0-rc7
initial-database-creation-162	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:32.522113+02	162	EXECUTED	3:6ca5838d878d4003b19f8204043bffc8	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-163	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:32.547059+02	163	EXECUTED	3:771fd4bf9b4fa2ec19b0d8dbfb11c5ca	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-164	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:32.572361+02	164	EXECUTED	3:5b22401b49d47e3139789a3286cf2904	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-165	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:32.594067+02	165	EXECUTED	3:4fbe63eff31009289ac04f757e6381a8	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-166	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:32.610572+02	166	EXECUTED	3:d103e205521dca0e85d3542d2e8d1c27	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-167	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:32.638121+02	167	EXECUTED	3:e9068f3a7306357ac93a04c0c549c655	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-168	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:32.664483+02	168	EXECUTED	3:0de5961990bb9ac7db825eccbec1bcf7	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-169	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:32.689655+02	169	EXECUTED	3:c9f8185b37520cd3b10ee27caaeef011	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-170	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:32.714798+02	170	EXECUTED	3:3d42148470c09493db120a7393297ef7	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-171	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:32.740999+02	171	EXECUTED	3:5ab06af79b8048602fb6a791c07ef202	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-172	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:32.775627+02	172	EXECUTED	3:d6f1ee934641f7b100d01506d66679a3	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-173	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:32.808458+02	173	EXECUTED	3:337ce4245e14e3537574714100c402a8	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-174	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:32.841245+02	174	EXECUTED	3:6134a4c78a5f101f0fc0d856846143f9	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-175	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:32.86721+02	175	EXECUTED	3:3838f97e2e79e8bd4d1b2128c69733ca	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-176	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:32.897214+02	176	EXECUTED	3:ae64144f1a2f16352edede6476839d91	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-177	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:32.925485+02	177	EXECUTED	3:1caa957da919b2ea7a93deda99e51a60	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-178	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:32.958531+02	178	EXECUTED	3:a7a73a6e4112ee22395c29105156bc91	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-179	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:32.984269+02	179	EXECUTED	3:e040013fdc4b4ce36d3f69c1d6674335	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-180	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:33.01725+02	180	EXECUTED	3:d97eda36924db94274be5ab3f84243d5	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-181	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:33.050627+02	181	EXECUTED	3:d2a946e9c8e210dcc9b027f5f87bc12a	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-182	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:33.075777+02	182	EXECUTED	3:5a0c046d5e7c620600de389e84768032	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-183	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:33.100745+02	183	EXECUTED	3:751ca516edf6d1913f3c5053fd10a54c	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-184	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:33.125997+02	184	EXECUTED	3:4ca4aafaa69fe368939654984f25c467	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-185	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:33.151167+02	185	EXECUTED	3:519db3d2355645a8c8e7d9dc138aa6e8	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-186	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:33.176046+02	186	EXECUTED	3:33648622935198fa5d0af99e01a79392	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-187	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:33.201123+02	187	EXECUTED	3:cd14eca26e076455aa89ac4f60f1b7f8	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-188	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:33.226578+02	188	EXECUTED	3:22774445af4e2629a540c215357c4dab	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-189	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:33.248026+02	189	EXECUTED	3:5fcea32b59170b73531afed44865e74a	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-190	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:33.276894+02	190	EXECUTED	3:d3f51ea26b08aa936c492ce372201a61	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-191	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:33.301762+02	191	EXECUTED	3:a65bbb0340fa7e6c01cbfd26dcb077d3	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-192	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:33.326945+02	192	EXECUTED	3:f1a98d11af89c6883a7b157c58276235	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-193	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:33.352047+02	193	EXECUTED	3:a686a180578010b9efeb99aa42d29b4c	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-194	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:33.377122+02	194	EXECUTED	3:9bdcc8590786650e93a8858633047535	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-195	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:33.402264+02	195	EXECUTED	3:d7021acb0e045255f8728e52ab9ef8d6	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-196	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:33.427772+02	196	EXECUTED	3:f7a3a4af5f66f90f2f626703887adf63	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-197	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:33.494459+02	197	EXECUTED	3:77d92b99cf2a7f78f82536064f9d8709	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-198	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:33.519561+02	198	EXECUTED	3:b44200cbbcc9cfe835a1a744a7fcdd5d	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-199	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:33.544317+02	199	EXECUTED	3:997d230b1bd7f21f2b6d4d475a81f55d	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-200	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:33.569985+02	200	EXECUTED	3:1d4a4f92d2e6e53b828d8a479a8d7339	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-201	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:33.591467+02	201	EXECUTED	3:8c331c6cec5acb11958fe8dcef715dc2	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-202	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:33.609114+02	202	EXECUTED	3:5d2a6f1c4bd8872ef397210c2b8a9803	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-203	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:33.62519+02	203	EXECUTED	3:fd3e049c58fddb6eb920e7df5176c2b7	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-204	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:33.642725+02	204	EXECUTED	3:9c39ece402136d78cf9fb4c12a06448b	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-205	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:33.672223+02	205	EXECUTED	3:c3ec865ee19510a322120043fd616672	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-206	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:33.704029+02	206	EXECUTED	3:e10c28e3a28ce071668047d2e5a42768	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-207	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:33.726185+02	207	EXECUTED	3:875d68b89a6455170d9c0789a36e7fef	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-208	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:33.742629+02	208	EXECUTED	3:aac51bb1deb77ce8e327b39634177cb2	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-209	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:33.767956+02	209	EXECUTED	3:04a1423fcd96ad1a08fe0ac56ba97b7c	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-210	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:33.784798+02	210	EXECUTED	3:8f780a2ddbe61d2d2cb6833bfcbbb02b	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-211	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:33.801513+02	211	EXECUTED	3:8b5bc7629c2c332de636dd41e73e88dc	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-212	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:33.822666+02	212	EXECUTED	3:ceeee0ec2d062de8eede0aa0c8ebffb9	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-213	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:33.847178+02	213	EXECUTED	3:2010f9d69985a58d4fa5e21ab91ce8d4	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-214	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:33.880586+02	214	EXECUTED	3:caa591120174d2313064b5b0b3cb0e0a	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-215	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:33.905644+02	215	EXECUTED	3:8c176d0dcdfd293b62cba0339f88758c	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-216	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:33.935232+02	216	EXECUTED	3:a8477e72853850f291e6d92eb93c1a1c	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-217	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:33.965635+02	217	EXECUTED	3:f204c84329622937e3b5b83fb5de11f0	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-218	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:33.994141+02	218	EXECUTED	3:72cc4963e0140bb49315b9abaf100100	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-219	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:34.01055+02	219	EXECUTED	3:0f3f19e068b47fc2747342a071da40a4	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-220	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:34.032392+02	220	EXECUTED	3:dc478c27d333866f942b85cf945c9c0a	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-221	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:34.056533+02	221	EXECUTED	3:7a1dad22d92f48a1230c6d032055ae5d	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-222	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:34.090572+02	222	EXECUTED	3:cf98b03148caf81a1309cb5aa3fe8d0d	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-223	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:34.111359+02	223	EXECUTED	3:720d630dda1340f512cda4b803ed58d8	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-224	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:34.136477+02	224	EXECUTED	3:e034974f9b0f18abffb02b0cf09599b1	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-225	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:34.153259+02	225	EXECUTED	3:9e68f93aa41b4053d54f5b6381b9b3d1	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-226	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:34.169962+02	226	EXECUTED	3:8e793bf47d077581dce41e5aa22719ec	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-227	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:34.186625+02	227	EXECUTED	3:54cf40128196150b8c4869fe05b42584	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-228	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:34.204073+02	228	EXECUTED	3:9319e57d85aaf1dca2a5a48479539182	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-229	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:34.232947+02	229	EXECUTED	3:74453f75fb11f5591e78b57e3a695fd4	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-230	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:34.26336+02	230	EXECUTED	3:1e616234cee687d9d49da89ef367d95c	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-231	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:34.29243+02	231	EXECUTED	3:38ca408d0a37c533ad2a8065da793e96	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-232	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:34.325729+02	232	EXECUTED	3:066843828bc319a546bb83f843411786	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-233	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:34.350531+02	233	EXECUTED	3:5af5ccaee031f9a37287c1d6530eddb1	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-234	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:34.381652+02	234	EXECUTED	3:7b876dd4a3f4ab6234817c6582c9354f	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-235	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:34.397485+02	235	EXECUTED	3:e86441717b14aba611f0ab3dd81e2248	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-236	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:34.414368+02	236	EXECUTED	3:b81a74f217e43872eb1890daee23375f	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-237	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:34.435165+02	237	EXECUTED	3:982749b8bc3a1f6e5cc93a386f4cbd7f	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-238	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:34.468214+02	238	EXECUTED	3:9c473d165bc7cbcbcb746d1bbe0e7356	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-239	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:34.493295+02	239	EXECUTED	3:07e634a56cf2d8b7974b14e502e0a451	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-240	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:34.518519+02	240	EXECUTED	3:6982068a9d4b5e020b62a78c08370e8d	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-241	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:34.54432+02	241	EXECUTED	3:bdabb7155f2e0261df6ca32f70253f80	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-242	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:34.576956+02	242	EXECUTED	3:6fdbc6b0c99aca28da5fa00e47ed8210	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-243	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:34.590303+02	243	EXECUTED	3:46dcaefe6fa5ad73ac005c7a84233d26	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-244	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:34.619073+02	244	EXECUTED	3:afb33e984040d98515f608de8862a589	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-245	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:34.644614+02	245	EXECUTED	3:5c4c810265ede002db1f4a76d3d63138	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-246	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:34.678011+02	246	EXECUTED	3:778c297135c84377bf8d4240dc48c0a0	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-247	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:34.702815+02	247	EXECUTED	3:47dfc937e60f5b8a577ea6669b985147	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-248	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:34.728009+02	248	EXECUTED	3:b33ae064331e47e159a5854a462168ca	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-249	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:34.752901+02	249	EXECUTED	3:5de74051f06b7904db00c5a27eddb2cf	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-250	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:34.774772+02	250	EXECUTED	3:6b57cbd2461cfef12fcfd6dd45c8fddd	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-251	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:34.800182+02	251	EXECUTED	3:a3ad74745c7365c602e61050a79f76b0	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-252	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:34.876338+02	252	EXECUTED	3:38187e6c448d3c9b32973eaa0fd656a0	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-253	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:34.928528+02	253	EXECUTED	3:4ae03a949ae43a71729474d8e5f53150	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-254	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:34.962135+02	254	EXECUTED	3:f2914f15fdd4e6edc6a0f2c0f0dc80f3	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-255	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:34.987327+02	255	EXECUTED	3:56c3cfd26107f4ce977833eb08c7e5ae	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-256	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:35.012114+02	256	EXECUTED	3:1eb5c70b6a2fdfb02b73ee27043ad43c	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-257	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:35.037635+02	257	EXECUTED	3:07be1c2d2175f835a6aba9773f667dd8	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-258	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:35.0682+02	258	EXECUTED	3:08984ba465853a2a563e365f7aa1ab26	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-259	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:35.084462+02	259	EXECUTED	3:3ac327d8478fe9edce42046913957e7b	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-260	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:35.101289+02	260	EXECUTED	3:4403ec16e108e294edaef52caf1a8c7c	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-261	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:35.118961+02	261	EXECUTED	3:252bdacabeb2826d8793fa7e0d7632f1	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-262	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:35.146509+02	262	EXECUTED	3:49cf13edda1de865cda1e26c8a47b6c3	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-263	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:35.171443+02	263	EXECUTED	3:081269141bd1a2c3b6067eed14a98dbd	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-264	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:35.197206+02	264	EXECUTED	3:585520c715d028c82db537081fdaa6db	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-265	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:35.230257+02	265	EXECUTED	3:da6dce425fe510812ff888e23d1d2ef6	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-266	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:35.2554+02	266	EXECUTED	3:c8d801ef6ad80b14971820ae8693107d	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-267	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:35.280836+02	267	EXECUTED	3:798d622e2d833ea81745773ede98d0e5	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-268	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:35.305589+02	268	EXECUTED	3:5e4879e532269fea183650f2a9bbc1f6	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-269	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:35.330758+02	269	EXECUTED	3:e3a5ff727a9a2b7d8f940ecc574420cd	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-270	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:35.358932+02	270	EXECUTED	3:da45adc3bd7cfc38349fb882bfd1e61b	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-271	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:35.38105+02	271	EXECUTED	3:397f66e74d24ddb474acb59aee87fec4	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-272	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:35.406907+02	272	EXECUTED	3:5bf1bdf33676cf54e819163003abf621	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-273	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:35.43976+02	273	EXECUTED	3:69121faa7785a9b350b00fcb9f50374e	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-274	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:35.461882+02	274	EXECUTED	3:170677e6cea583462e1c1eae76f497c4	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-275	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:35.480165+02	275	EXECUTED	3:38ff29923dee1ffdb36c61ef41e10fa3	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-276	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:35.49582+02	276	EXECUTED	3:c1b8ef9c9f5768d55a22f6bc3c6e7d8b	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-277	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:35.512668+02	277	EXECUTED	3:5c8b73daea6620f93dacff75e9da0ecd	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-278	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:35.548761+02	278	EXECUTED	3:84ab0451c76fc6a1e0327e5553eb4001	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-279	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:35.574124+02	279	EXECUTED	3:09eb0f505dd4bcae3ac228b5a16e86d4	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-280	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:35.599063+02	280	EXECUTED	3:c7a35b004084951019dfbba0c5260617	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-281	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:35.624206+02	281	EXECUTED	3:2c02e02f5998c45c04372f606349976c	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-282	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:35.64937+02	282	EXECUTED	3:fa9865a96de94e288de10ffa4e1ce2a9	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-283	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:35.674566+02	283	EXECUTED	3:6e5b049c1456230e0e14b10dea5e92c6	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-284	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:35.699563+02	284	EXECUTED	3:c35081a6ee50dc8ab705314d3a16d2cc	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-285	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:35.725121+02	285	EXECUTED	3:5cb90b324fce12b8b9de95c7a6182a81	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-286	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:35.749879+02	286	EXECUTED	3:6889e09671c3f9c636c8c3a2336a9944	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-287	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:35.771895+02	287	EXECUTED	3:363e2d30bf43e3e1926507da337146cd	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-288	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:35.796682+02	288	EXECUTED	3:b529de2d46e696eaaadd2f92ed83336f	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-289	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:35.814994+02	289	EXECUTED	3:d77fbf7e3a87d863b5263c5958b62e3f	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-290	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:35.831894+02	290	EXECUTED	3:9f3174e9b185e772a9d9450c19e3cf72	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-291	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:35.848411+02	291	EXECUTED	3:4901470de7e46df0f0a83549dc445836	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-292	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:35.86636+02	292	EXECUTED	3:6b0827965e0984983abe21e149577aac	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-293	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:35.882028+02	293	EXECUTED	3:14e268e07ed0b10cdc0760092b4accda	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-294	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:35.898757+02	294	EXECUTED	3:ceb38419fb5ecfea3d5af5afbbd8ed1b	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-295	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:35.91583+02	295	EXECUTED	3:13985768185e234221d2046eaec46060	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-296	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:35.932532+02	296	EXECUTED	3:961586fd7e50969fe28046a9d7d0951c	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-297	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:35.948982+02	297	EXECUTED	3:d1e35a7d03ed902b0ace9dd9779379a1	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-298	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:35.965697+02	298	EXECUTED	3:92f56dbb820fb826c9e18c84f2690e06	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-299	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:35.987166+02	299	EXECUTED	3:1baf3e542a91bea351a98817ec49b614	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-300	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:36.01932+02	300	EXECUTED	3:0c284839f49f6bfd54ee353e45e61e00	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-301	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:36.044543+02	301	EXECUTED	3:81b4f87dda1aa9bc5b948054ad4b3c41	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-302	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:36.06994+02	302	EXECUTED	3:bc91d51b3d71869842e183b950ee4a3d	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-303	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:36.095191+02	303	EXECUTED	3:8517bddba816a73625f3c985eee952ae	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-304	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:36.119965+02	304	EXECUTED	3:a6169a3bfa622c13ab0c4e8c035fa82e	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-305	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:36.145764+02	305	EXECUTED	3:35751059fd18a1576e00a40643746a9c	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-306	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:36.179356+02	306	EXECUTED	3:82583a548f6b4a542193236c0f3730d1	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-307	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:36.212229+02	307	EXECUTED	3:aec0c9b10b5c2aaedf092fdccc7324c7	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-308	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:36.237603+02	308	EXECUTED	3:aa4c8dac41b35a7d4566718d67275b88	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-309	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:36.267841+02	309	EXECUTED	3:4a666381e39c0feacc2bf1a9097f24bc	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-310	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:36.284366+02	310	EXECUTED	3:d7f5f54774e60c4d70d2369946878280	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-311	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:36.301201+02	311	EXECUTED	3:0b17054b26e4a79fe7c786416d2ab29f	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-312	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:36.319337+02	312	EXECUTED	3:8ad4d076ac44a570b2273f851de1e961	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-313	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:36.346961+02	313	EXECUTED	3:3db2f5919bbdff69c85a35f646ef7dbe	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-314	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:36.380002+02	314	EXECUTED	3:ed0ad939f78c788414fc097c03a7b162	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-315	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:36.405112+02	315	EXECUTED	3:a76df5b34827aa316543a45fa373bcdc	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-316	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:36.432651+02	316	EXECUTED	3:50265034b760cabcd843dd6a65f97b2b	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-317	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:36.452364+02	317	EXECUTED	3:ec3dbc035055d606078eb1b05d0e74d2	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-318	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:36.472007+02	318	EXECUTED	3:01322e22f99bf7f04e2ff4f5ce6df09a	Add Foreign Key Constraint		\N	2.0-rc7
initial-database-creation-319	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:36.493943+02	319	EXECUTED	3:f60256feedbef0be164052c5f2df1581	Create Table		\N	2.0-rc7
initial-database-creation-320	mrego	src/main/resources/db.changelog-database.xml	2011-04-30 17:44:36.51257+02	320	EXECUTED	3:81e6324ad1a420cfff85922519dd3052	Insert Row		\N	2.0-rc7
resize-precision-in-planning_data	dpino	src/main/resources/db.changelog-initial.xml	2011-04-30 17:44:36.708707+02	321	EXECUTED	3:61373c398e47cd9179bc4bd826e9aef2	Modify data type (x2)	Resize precision for 'progress_by_duration' and 'progress_by_num_hours' fields	\N	2.0-rc7
add-company-logo-url-configuration-setting	ltilve	src/main/resources/db.changelog-initial.xml	2011-04-30 17:44:36.808951+02	322	EXECUTED	3:75b2b7f08bf87acdf9b2a12cacd47286	Add Column, Update Data	Add new column with configuration setting	\N	2.0-rc7
add scheduling mode	ogonzalez	src/main/resources/db.changelog-initial.xml	2011-04-30 17:44:36.837239+02	323	EXECUTED	3:5b6868755182ff5eb80506985af14867	Add Column, Update Data	column for org.navalplanner.business.orders.entities.Order.schedulingMode	\N	2.0-rc7
rename start_constraint_type in task and task milestone	ogonzalez	src/main/resources/db.changelog-initial.xml	2011-04-30 17:44:36.903422+02	324	EXECUTED	3:de401390eb9a0384356e0bb7bd2a12ab	Rename Column (x2)	Caused by renaming org.navalplanner.business.planner.entities.TaskPositionConstraint.startConstraintType	\N	2.0-rc7
add-scenarios-enabled-configuration-setting	ltilve	src/main/resources/db.changelog-initial.xml	2011-04-30 17:44:36.929384+02	325	EXECUTED	3:0380a3452299382a1cf03dea0ff64eae	Add Column, Update Data	Add new column with scenarios visibility flag	\N	2.0-rc7
change-types-start-finish-date-criterion-satisfaction	ogonzalez	src/main/resources/db.changelog-initial.xml	2011-04-30 17:44:37.152345+02	326	EXECUTED	3:5430918dc2871878441d77c6dc3b0eed	Modify data type (x2)	Change types of start and finish date to date for criterion satisfaction table	\N	2.0-rc7
use-capacity-instead-of-effort_duration-and-not_over_assignable	ogonzalez	src/main/resources/db.changelog-1.0.xml	2011-04-30 17:44:37.188072+02	327	EXECUTED	3:5a699c17dea00898019528a50308cc89	Add Column, Rename Column, Update Data, Drop Column	Convert from duration + notAssignable (not over assignable) to capacity property	\N	2.0-rc7
use-capacity-for-exceptions	ogonzalez	src/main/resources/db.changelog-1.0.xml	2011-04-30 17:44:37.212526+02	328	EXECUTED	3:51ece468ddd11a6b7e55e6f1c89a91cb	Add Column, Rename Column, Custom SQL	Convert from duration to capacity property for calendar exceptions	\N	2.0-rc7
use-capacity-for-capacity-per-day-for-calendar-data	ogonzalez	src/main/resources/db.changelog-1.0.xml	2011-04-30 17:44:37.229817+02	329	EXECUTED	3:f7fb1d58644b8adfa2fb89b8cc812960	Rename Table, Add Column, Rename Column	Convert from duration to capacity in effort per day for CalendarData	\N	2.0-rc7
by_default_weekends_are_not_overassignable	ogonzalez	src/main/resources/db.changelog-1.0.xml	2011-04-30 17:44:37.269882+02	330	EXECUTED	3:dbebff33f8250d39bfe90bd960cad761	Custom SQL	By default weekends are not over assignable	\N	2.0-rc7
replace-column-limited_resource-with-resource_type	jaragunde	src/main/resources/db.changelog-1.0.xml	2011-04-30 17:44:37.297028+02	331	EXECUTED	3:6ad32b60962f35aefd3f23dfc12cf9a0	Add Column, Update Data (x2), Add Not-Null Constraint, Drop Column	Replace column limited_resource with resource_type in resource table	\N	2.0-rc7
add-new-column-changed_default_admin_password	smontes	src/main/resources/db.changelog-1.0.xml	2011-04-30 17:44:37.325666+02	332	EXECUTED	3:a81d15dda00b5418560ee9d47338e50b	Add Column, Add Default Value, Add Not-Null Constraint	Add new column changed_default_admin_password with default value FALSE to configuration table	\N	2.0-rc7
add-new-column-changed_default_user_password	smontes	src/main/resources/db.changelog-1.0.xml	2011-04-30 17:44:37.355483+02	333	EXECUTED	3:f23e635cae0bf0da3207769e60426b9b	Add Column, Add Default Value, Add Not-Null Constraint	Add new column changed_default_user_password with default value FALSE to configuration table	\N	2.0-rc7
add-new-column-changed_default_wsreader_password	smontes	src/main/resources/db.changelog-1.0.xml	2011-04-30 17:44:37.392895+02	334	EXECUTED	3:66d0f8871e382b3b114285331a26fbf2	Add Column, Add Default Value, Add Not-Null Constraint	Add new column changed_default_wsreader_password with default value FALSE to configuration table	\N	2.0-rc7
add-new-column-changed_default_wswriter_password	smontes	src/main/resources/db.changelog-1.0.xml	2011-04-30 17:44:37.421533+02	335	EXECUTED	3:0b1de92b4c81169e1c283436246330f3	Add Column, Add Default Value, Add Not-Null Constraint	Add new column changed_default_wswriter_password with default value FALSE to configuration table	\N	2.0-rc7
add-intended_resources_per_day-column-to-resource-allocation	ogonzalez	src/main/resources/db.changelog-1.0.xml	2011-04-30 17:44:37.437844+02	336	EXECUTED	3:9b56ffce2f52cded2ced6cf9a46cadc3	Add Column, Custom SQL	add intended_resources_per_day column to resource-allocation	\N	2.0-rc7
change-original-total-assignment-to-use-effort-duration	ogonzalez	src/main/resources/db.changelog-1.0.xml	2011-04-30 17:44:37.482816+02	337	EXECUTED	3:705a6aa43fa49745dd51f15a304f0135	Add Column, Add Default Value, Custom SQL, Drop Column	rename original_total_assignment to intended_total_assignment and now it's interpreted as an EffortDuration	\N	2.0-rc7
add-intended_non_consolidated_effort	ogonzalez	src/main/resources/db.changelog-1.0.xml	2011-04-30 17:44:37.505006+02	338	EXECUTED	3:7316016ad9c6c205338120f7584fc9f1	Add Column, Add Default Value, Custom SQL		\N	2.0-rc7
\.


--
-- Data for Name: databasechangeloglock; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY databasechangeloglock (id, locked, lockgranted, lockedby) FROM stdin;
1	f	\N	\N
\.


--
-- Data for Name: day_assignment; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY day_assignment (id, day_assignment_type, version, duration, consolidated, day, resource_id, specific_container_id, generic_container_id, derived_container_id) FROM stdin;
7405	generic_day	2	21600	t	2011-05-02	6566	\N	7272	\N
7416	generic_day	1	21600	f	2011-05-03	6566	\N	7272	\N
7415	generic_day	1	7200	f	2011-05-04	6566	\N	7272	\N
4488	specific_day	1	14400	f	2011-06-16	1617	3438	\N	\N
4489	specific_day	1	0	f	2011-06-05	1617	3438	\N	\N
4490	specific_day	1	0	f	2011-04-16	1617	3438	\N	\N
4491	specific_day	1	14400	f	2011-05-10	1617	3438	\N	\N
4492	specific_day	1	14400	f	2011-03-30	1617	3438	\N	\N
4493	specific_day	1	0	f	2011-06-07	1617	3438	\N	\N
4494	specific_day	1	0	f	2011-06-10	1617	3438	\N	\N
4495	specific_day	1	14400	f	2011-04-01	1617	3438	\N	\N
4496	specific_day	1	14400	f	2011-03-04	1617	3438	\N	\N
4497	specific_day	1	0	f	2011-06-01	1617	3438	\N	\N
4498	specific_day	1	14400	f	2011-05-05	1617	3438	\N	\N
4499	specific_day	1	14400	f	2011-04-19	1617	3438	\N	\N
4500	specific_day	1	0	f	2011-05-14	1617	3438	\N	\N
4501	specific_day	1	14400	f	2011-03-09	1617	3438	\N	\N
4502	specific_day	1	14400	f	2011-05-06	1617	3438	\N	\N
4503	specific_day	1	0	f	2011-03-20	1617	3438	\N	\N
4504	specific_day	1	0	f	2011-06-26	1617	3438	\N	\N
4505	specific_day	1	14400	f	2011-06-22	1617	3438	\N	\N
4506	specific_day	1	0	f	2011-05-01	1617	3438	\N	\N
4507	specific_day	1	14400	f	2011-03-03	1617	3438	\N	\N
4508	specific_day	1	14400	f	2011-05-27	1617	3438	\N	\N
4509	specific_day	1	14400	f	2011-04-18	1617	3438	\N	\N
4510	specific_day	1	14400	f	2011-04-04	1617	3438	\N	\N
4511	specific_day	1	0	f	2011-06-11	1617	3438	\N	\N
4512	specific_day	1	0	f	2011-06-08	1617	3438	\N	\N
4513	specific_day	1	14400	f	2011-06-24	1617	3438	\N	\N
4514	specific_day	1	0	f	2011-04-09	1617	3438	\N	\N
4515	specific_day	1	14400	f	2011-06-17	1617	3438	\N	\N
4516	specific_day	1	14400	f	2011-05-31	1617	3438	\N	\N
4517	specific_day	1	14400	f	2011-05-24	1617	3438	\N	\N
4518	specific_day	1	14400	f	2011-03-28	1617	3438	\N	\N
4567	specific_day	1	14400	f	2011-04-26	1617	3438	\N	\N
4568	specific_day	1	0	f	2011-03-26	1617	3438	\N	\N
4569	specific_day	1	0	f	2011-04-17	1617	3438	\N	\N
4570	specific_day	1	0	f	2011-06-19	1617	3438	\N	\N
4571	specific_day	1	0	f	2011-04-10	1617	3438	\N	\N
4572	specific_day	1	0	f	2011-05-15	1617	3438	\N	\N
4573	specific_day	1	14400	f	2011-04-29	1617	3438	\N	\N
4574	specific_day	1	0	f	2011-03-05	1617	3438	\N	\N
4575	specific_day	1	0	f	2011-04-02	1617	3438	\N	\N
4576	specific_day	1	0	f	2011-06-18	1617	3438	\N	\N
4577	specific_day	1	0	f	2011-05-08	1617	3438	\N	\N
4578	specific_day	1	14400	f	2011-03-14	1617	3438	\N	\N
4579	specific_day	1	14400	f	2011-04-08	1617	3438	\N	\N
4580	specific_day	1	14400	f	2011-04-20	1617	3438	\N	\N
4581	specific_day	1	14400	f	2011-05-25	1617	3438	\N	\N
5164	generic_day	0	28800	f	2011-06-08	1623	\N	3237	\N
5165	generic_day	0	28800	f	2011-06-13	1623	\N	3237	\N
5166	generic_day	0	28800	f	2011-06-07	1623	\N	3237	\N
5167	generic_day	0	28800	f	2011-06-21	1623	\N	3237	\N
5168	generic_day	0	28800	f	2011-06-22	1623	\N	3237	\N
5169	generic_day	0	28800	f	2011-06-16	1623	\N	3237	\N
5170	generic_day	0	28800	f	2011-06-20	1623	\N	3237	\N
5171	generic_day	0	28800	f	2011-06-15	1623	\N	3237	\N
5172	generic_day	0	14400	f	2011-06-23	1623	\N	3237	\N
5173	generic_day	0	28800	f	2011-06-10	1623	\N	3237	\N
5174	generic_day	0	28800	f	2011-06-17	1623	\N	3237	\N
5175	generic_day	0	28800	f	2011-06-14	1623	\N	3237	\N
5176	generic_day	0	28800	f	2011-06-09	1623	\N	3237	\N
5177	generic_day	0	28800	f	2011-06-07	1623	\N	3238	\N
5178	generic_day	0	28800	f	2011-06-13	1623	\N	3238	\N
5179	generic_day	0	28800	f	2011-06-08	1623	\N	3238	\N
5180	generic_day	0	28800	f	2011-06-10	1623	\N	3238	\N
5181	generic_day	0	28800	f	2011-06-09	1623	\N	3238	\N
5182	generic_day	0	28800	f	2011-06-16	1623	\N	3239	\N
5183	generic_day	0	28800	f	2011-06-09	1623	\N	3239	\N
5184	generic_day	0	28800	f	2011-06-08	1623	\N	3239	\N
5185	generic_day	0	28800	f	2011-06-15	1623	\N	3239	\N
5186	generic_day	0	28800	f	2011-06-17	1623	\N	3239	\N
5187	generic_day	0	28800	f	2011-06-13	1623	\N	3239	\N
5188	generic_day	0	28800	f	2011-06-14	1623	\N	3239	\N
5189	generic_day	0	28800	f	2011-06-07	1623	\N	3239	\N
5190	generic_day	0	28800	f	2011-06-10	1623	\N	3239	\N
5191	generic_day	0	28800	f	2011-06-20	1623	\N	3239	\N
7781	generic_day	0	14400	f	2011-05-05	6566	\N	7273	\N
7782	generic_day	0	14400	f	2011-05-04	6566	\N	7273	\N
5192	generic_day	0	28800	f	2011-04-01	1625	\N	3234	\N
5193	generic_day	0	28800	f	2011-04-04	1625	\N	3234	\N
5194	generic_day	0	35018	t	2011-03-21	1625	\N	3234	\N
5195	generic_day	0	28800	t	2011-03-03	1625	\N	3234	\N
5196	generic_day	0	30150	t	2011-03-08	1625	\N	3234	\N
5197	generic_day	0	28800	t	2011-03-04	1625	\N	3234	\N
5198	generic_day	0	35018	t	2011-03-25	1625	\N	3234	\N
5199	generic_day	0	28800	f	2011-03-28	1625	\N	3234	\N
5200	generic_day	0	30150	t	2011-03-10	1625	\N	3234	\N
5201	generic_day	0	28800	t	2011-03-02	1625	\N	3234	\N
5202	generic_day	0	30150	t	2011-03-09	1625	\N	3234	\N
5203	generic_day	0	28800	f	2011-03-30	1625	\N	3234	\N
5204	generic_day	0	35018	t	2011-03-17	1625	\N	3234	\N
5205	generic_day	0	28800	f	2011-04-07	1625	\N	3234	\N
5206	generic_day	0	35018	t	2011-03-18	1625	\N	3234	\N
5207	generic_day	0	35018	t	2011-03-23	1625	\N	3234	\N
5208	generic_day	0	35018	t	2011-03-22	1625	\N	3234	\N
5209	generic_day	0	28800	t	2011-03-01	1625	\N	3234	\N
5210	generic_day	0	35018	t	2011-03-24	1625	\N	3234	\N
5211	generic_day	0	28800	f	2011-03-31	1625	\N	3234	\N
5212	generic_day	0	30150	t	2011-03-11	1625	\N	3234	\N
5213	generic_day	0	35018	t	2011-03-16	1625	\N	3234	\N
5214	generic_day	0	30150	t	2011-03-07	1625	\N	3234	\N
5215	generic_day	0	28800	f	2011-04-08	1625	\N	3234	\N
5216	generic_day	0	35019	t	2011-03-14	1625	\N	3234	\N
5217	generic_day	0	28800	f	2011-04-05	1625	\N	3234	\N
5218	generic_day	0	28800	f	2011-04-06	1625	\N	3234	\N
5219	generic_day	0	28800	f	2011-03-29	1625	\N	3234	\N
5220	generic_day	0	35019	t	2011-03-15	1625	\N	3234	\N
5221	generic_day	0	14400	f	2011-07-08	1617	\N	3240	\N
5222	generic_day	0	14400	f	2011-07-05	1617	\N	3240	\N
5223	generic_day	0	14400	f	2011-06-29	1617	\N	3240	\N
5224	generic_day	0	14400	f	2011-07-07	1617	\N	3240	\N
5225	generic_day	0	14400	f	2011-06-30	1617	\N	3240	\N
5226	generic_day	0	14400	f	2011-07-18	1617	\N	3240	\N
5227	generic_day	0	14400	f	2011-07-21	1617	\N	3240	\N
5228	generic_day	0	14400	f	2011-07-20	1617	\N	3240	\N
5229	generic_day	0	14400	f	2011-06-27	1617	\N	3240	\N
5230	generic_day	0	14400	f	2011-07-15	1617	\N	3240	\N
5231	generic_day	0	14400	f	2011-07-04	1617	\N	3240	\N
5232	generic_day	0	14400	f	2011-06-28	1617	\N	3240	\N
5233	generic_day	0	14400	f	2011-06-24	1617	\N	3240	\N
5234	generic_day	0	14400	f	2011-07-06	1617	\N	3240	\N
5235	generic_day	0	14400	f	2011-07-13	1617	\N	3240	\N
5236	generic_day	0	14400	f	2011-07-19	1617	\N	3240	\N
5237	generic_day	0	14400	f	2011-07-01	1617	\N	3240	\N
5238	generic_day	0	14400	f	2011-07-14	1617	\N	3240	\N
5239	generic_day	0	14400	f	2011-07-11	1617	\N	3240	\N
5240	generic_day	0	14400	f	2011-07-12	1617	\N	3240	\N
5241	specific_day	0	12000	f	2011-06-23	1619	3439	\N	\N
5242	specific_day	0	26400	f	2011-06-28	1619	3439	\N	\N
5243	specific_day	0	26400	f	2011-06-29	1619	3439	\N	\N
5244	specific_day	0	26400	f	2011-06-27	1619	3439	\N	\N
5245	specific_day	0	26400	f	2011-06-24	1619	3439	\N	\N
5246	specific_day	0	26400	f	2011-06-30	1619	3439	\N	\N
5247	generic_day	0	14400	f	2011-06-24	1625	\N	3241	\N
5248	generic_day	0	14400	f	2011-07-21	1625	\N	3241	\N
5249	generic_day	0	14400	f	2011-07-12	1625	\N	3241	\N
5250	generic_day	0	14400	f	2011-07-14	1625	\N	3241	\N
5251	generic_day	0	14400	f	2011-07-04	1625	\N	3241	\N
5252	generic_day	0	14400	f	2011-06-29	1625	\N	3241	\N
5253	generic_day	0	14400	f	2011-07-08	1625	\N	3241	\N
5254	generic_day	0	14400	f	2011-07-06	1625	\N	3241	\N
5255	generic_day	0	14400	f	2011-07-18	1625	\N	3241	\N
5256	generic_day	0	14400	f	2011-07-11	1625	\N	3241	\N
5257	generic_day	0	14400	f	2011-07-07	1625	\N	3241	\N
5258	generic_day	0	14400	f	2011-07-05	1625	\N	3241	\N
5259	generic_day	0	14400	f	2011-06-30	1625	\N	3241	\N
5260	generic_day	0	14400	f	2011-07-01	1625	\N	3241	\N
5261	generic_day	0	14400	f	2011-06-27	1625	\N	3241	\N
5262	generic_day	0	14400	f	2011-07-13	1625	\N	3241	\N
5263	generic_day	0	14400	f	2011-06-28	1625	\N	3241	\N
5264	generic_day	0	14400	f	2011-07-15	1625	\N	3241	\N
5265	generic_day	0	14400	f	2011-07-20	1625	\N	3241	\N
5266	generic_day	0	14400	f	2011-07-19	1625	\N	3241	\N
5267	generic_day	0	28800	f	2011-04-15	1619	\N	3235	\N
5268	generic_day	0	28800	f	2011-04-20	1619	\N	3235	\N
5269	generic_day	0	28800	f	2011-04-22	1619	\N	3235	\N
5270	generic_day	0	28800	f	2011-04-13	1619	\N	3235	\N
5271	generic_day	0	28800	f	2011-04-12	1619	\N	3235	\N
5272	generic_day	0	28800	f	2011-04-14	1619	\N	3235	\N
5273	generic_day	0	28800	f	2011-04-18	1619	\N	3235	\N
5274	generic_day	0	28800	f	2011-04-19	1619	\N	3235	\N
5275	generic_day	0	28800	f	2011-04-21	1619	\N	3235	\N
5276	generic_day	0	28800	f	2011-04-11	1619	\N	3235	\N
5277	generic_day	0	21600	f	2011-04-28	1621	\N	3236	\N
5278	generic_day	0	7200	f	2011-05-06	1619	\N	3236	\N
5279	generic_day	0	21600	f	2011-05-03	1621	\N	3236	\N
5280	generic_day	0	7200	f	2011-04-29	1619	\N	3236	\N
5281	generic_day	0	21600	f	2011-04-26	1621	\N	3236	\N
5282	generic_day	0	7200	f	2011-05-02	1619	\N	3236	\N
5283	generic_day	0	21600	f	2011-04-29	1621	\N	3236	\N
5284	generic_day	0	7200	f	2011-04-26	1619	\N	3236	\N
5285	generic_day	0	21600	f	2011-05-04	1621	\N	3236	\N
5286	generic_day	0	7200	f	2011-05-03	1619	\N	3236	\N
5287	generic_day	0	21600	f	2011-04-27	1621	\N	3236	\N
5288	generic_day	0	7200	f	2011-05-04	1619	\N	3236	\N
5289	generic_day	0	21600	f	2011-05-05	1621	\N	3236	\N
5290	generic_day	0	21600	f	2011-05-02	1621	\N	3236	\N
5291	generic_day	0	7200	f	2011-04-28	1619	\N	3236	\N
5292	generic_day	0	28800	f	2011-04-25	1621	\N	3236	\N
5293	generic_day	0	7200	f	2011-05-05	1619	\N	3236	\N
5294	generic_day	0	7200	f	2011-04-27	1619	\N	3236	\N
5295	generic_day	0	21600	f	2011-05-06	1621	\N	3236	\N
5296	specific_day	0	21600	f	2011-05-26	1619	3437	\N	\N
5297	specific_day	0	21600	f	2011-05-25	1619	3437	\N	\N
5298	specific_day	0	21600	f	2011-05-20	1619	3437	\N	\N
5299	specific_day	0	21600	f	2011-05-13	1619	3437	\N	\N
5300	specific_day	0	21600	f	2011-05-30	1619	3437	\N	\N
5301	specific_day	0	21600	f	2011-05-16	1619	3437	\N	\N
5302	specific_day	0	21600	f	2011-05-18	1619	3437	\N	\N
5303	specific_day	0	21600	f	2011-05-11	1619	3437	\N	\N
5304	specific_day	0	21600	f	2011-05-12	1619	3437	\N	\N
5305	specific_day	0	21600	f	2011-05-27	1619	3437	\N	\N
5306	specific_day	0	21600	f	2011-06-06	1619	3437	\N	\N
5307	specific_day	0	21600	f	2011-05-10	1619	3437	\N	\N
5308	specific_day	0	21600	f	2011-06-01	1619	3437	\N	\N
5309	specific_day	0	21600	f	2011-05-23	1619	3437	\N	\N
4463	specific_day	1	14400	f	2011-04-14	1617	3438	\N	\N
4464	specific_day	1	14400	f	2011-06-14	1617	3438	\N	\N
4465	specific_day	1	14400	f	2011-04-25	1617	3438	\N	\N
4466	specific_day	1	14400	f	2011-03-15	1617	3438	\N	\N
4467	specific_day	1	14400	f	2011-04-12	1617	3438	\N	\N
4468	specific_day	1	0	f	2011-03-06	1617	3438	\N	\N
4469	specific_day	1	14400	f	2011-04-06	1617	3438	\N	\N
4470	specific_day	1	0	f	2011-05-21	1617	3438	\N	\N
4471	specific_day	1	14400	f	2011-04-07	1617	3438	\N	\N
4472	specific_day	1	0	f	2011-05-28	1617	3438	\N	\N
4473	specific_day	1	14400	f	2011-03-01	1617	3438	\N	\N
4474	specific_day	1	14400	f	2011-03-21	1617	3438	\N	\N
4475	specific_day	1	14400	f	2011-05-18	1617	3438	\N	\N
4476	specific_day	1	0	f	2011-06-25	1617	3438	\N	\N
4477	specific_day	1	14400	f	2011-03-23	1617	3438	\N	\N
4478	specific_day	1	14400	f	2011-05-09	1617	3438	\N	\N
4479	specific_day	1	14400	f	2011-06-15	1617	3438	\N	\N
4480	specific_day	1	14400	f	2011-04-11	1617	3438	\N	\N
4481	specific_day	1	0	f	2011-04-23	1617	3438	\N	\N
4482	specific_day	1	14400	f	2011-05-26	1617	3438	\N	\N
4483	specific_day	1	0	f	2011-06-04	1617	3438	\N	\N
4484	specific_day	1	14400	f	2011-05-02	1617	3438	\N	\N
4485	specific_day	1	14400	f	2011-06-23	1617	3438	\N	\N
4486	specific_day	1	0	f	2011-05-17	1617	3438	\N	\N
4487	specific_day	1	14400	f	2011-03-11	1617	3438	\N	\N
5310	specific_day	0	21600	f	2011-05-19	1619	3437	\N	\N
5311	specific_day	0	21600	f	2011-05-24	1619	3437	\N	\N
5312	specific_day	0	21600	f	2011-05-17	1619	3437	\N	\N
5313	specific_day	0	21600	f	2011-06-02	1619	3437	\N	\N
5314	specific_day	0	21600	f	2011-05-31	1619	3437	\N	\N
5315	specific_day	0	21600	f	2011-05-09	1619	3437	\N	\N
5316	specific_day	0	21600	f	2011-06-03	1619	3437	\N	\N
4519	specific_day	1	14400	f	2011-04-28	1617	3438	\N	\N
4520	specific_day	1	0	f	2011-03-12	1617	3438	\N	\N
4521	specific_day	1	0	f	2011-06-03	1617	3438	\N	\N
4522	specific_day	1	14400	f	2011-03-22	1617	3438	\N	\N
4523	specific_day	1	14400	f	2011-05-19	1617	3438	\N	\N
4524	specific_day	1	14400	f	2011-04-15	1617	3438	\N	\N
4525	specific_day	1	14400	f	2011-03-10	1617	3438	\N	\N
4526	specific_day	1	14400	f	2011-05-03	1617	3438	\N	\N
4527	specific_day	1	0	f	2011-06-09	1617	3438	\N	\N
4528	specific_day	1	14400	f	2011-05-12	1617	3438	\N	\N
4529	specific_day	1	14400	f	2011-05-30	1617	3438	\N	\N
4530	specific_day	1	14400	f	2011-03-24	1617	3438	\N	\N
4531	specific_day	1	14400	f	2011-06-13	1617	3438	\N	\N
4532	specific_day	1	14400	f	2011-04-05	1617	3438	\N	\N
4533	specific_day	1	14400	f	2011-06-20	1617	3438	\N	\N
4534	specific_day	1	14400	f	2011-06-27	1617	3438	\N	\N
4535	specific_day	1	14400	f	2011-05-20	1617	3438	\N	\N
4536	specific_day	1	0	f	2011-06-06	1617	3438	\N	\N
4537	specific_day	1	14400	f	2011-04-27	1617	3438	\N	\N
4538	specific_day	1	0	f	2011-04-22	1617	3438	\N	\N
4539	specific_day	1	0	f	2011-03-19	1617	3438	\N	\N
4540	specific_day	1	0	f	2011-04-24	1617	3438	\N	\N
4541	specific_day	1	0	f	2011-05-29	1617	3438	\N	\N
4542	specific_day	1	14400	f	2011-05-13	1617	3438	\N	\N
4543	specific_day	1	14400	f	2011-03-02	1617	3438	\N	\N
4544	specific_day	1	0	f	2011-05-22	1617	3438	\N	\N
4545	specific_day	1	0	f	2011-04-30	1617	3438	\N	\N
4546	specific_day	1	14400	f	2011-03-17	1617	3438	\N	\N
4547	specific_day	1	0	f	2011-06-02	1617	3438	\N	\N
4548	specific_day	1	14400	f	2011-03-08	1617	3438	\N	\N
4549	specific_day	1	0	f	2011-06-12	1617	3438	\N	\N
4550	specific_day	1	14400	f	2011-05-04	1617	3438	\N	\N
4551	specific_day	1	14400	f	2011-03-07	1617	3438	\N	\N
4552	specific_day	1	14400	f	2011-05-23	1617	3438	\N	\N
4553	specific_day	1	14400	f	2011-04-13	1617	3438	\N	\N
4554	specific_day	1	0	f	2011-04-03	1617	3438	\N	\N
4555	specific_day	1	14400	f	2011-03-16	1617	3438	\N	\N
4556	specific_day	1	0	f	2011-03-13	1617	3438	\N	\N
4557	specific_day	1	14400	f	2011-06-21	1617	3438	\N	\N
4558	specific_day	1	14400	f	2011-03-25	1617	3438	\N	\N
4559	specific_day	1	14400	f	2011-03-18	1617	3438	\N	\N
4560	specific_day	1	0	f	2011-05-07	1617	3438	\N	\N
4561	specific_day	1	0	f	2011-03-27	1617	3438	\N	\N
4562	specific_day	1	14400	f	2011-04-21	1617	3438	\N	\N
4563	specific_day	1	14400	f	2011-05-16	1617	3438	\N	\N
4564	specific_day	1	14400	f	2011-03-31	1617	3438	\N	\N
4565	specific_day	1	14400	f	2011-03-29	1617	3438	\N	\N
4566	specific_day	1	14400	f	2011-05-11	1617	3438	\N	\N
5317	specific_day	0	7200	f	2011-05-26	1621	3436	\N	\N
5318	specific_day	0	7200	f	2011-05-19	1621	3436	\N	\N
5319	specific_day	0	7200	f	2011-05-09	1621	3436	\N	\N
5320	specific_day	0	7200	f	2011-05-11	1621	3436	\N	\N
5321	specific_day	0	7200	f	2011-05-24	1621	3436	\N	\N
5322	specific_day	0	7200	f	2011-05-13	1621	3436	\N	\N
5323	specific_day	0	7200	f	2011-05-10	1621	3436	\N	\N
5324	specific_day	0	7200	f	2011-05-25	1621	3436	\N	\N
5325	specific_day	0	7200	f	2011-06-01	1621	3436	\N	\N
5326	specific_day	0	7200	f	2011-05-20	1621	3436	\N	\N
5327	specific_day	0	7200	f	2011-05-17	1621	3436	\N	\N
5328	specific_day	0	7200	f	2011-05-30	1621	3436	\N	\N
5329	specific_day	0	7200	f	2011-05-16	1621	3436	\N	\N
5330	specific_day	0	7200	f	2011-05-23	1621	3436	\N	\N
5331	specific_day	0	7200	f	2011-06-06	1621	3436	\N	\N
5332	specific_day	0	7200	f	2011-05-27	1621	3436	\N	\N
5333	specific_day	0	7200	f	2011-05-31	1621	3436	\N	\N
5334	specific_day	0	7200	f	2011-05-18	1621	3436	\N	\N
5335	specific_day	0	7200	f	2011-06-03	1621	3436	\N	\N
5336	specific_day	0	7200	f	2011-05-12	1621	3436	\N	\N
5337	specific_day	0	7200	f	2011-06-02	1621	3436	\N	\N
\.


--
-- Data for Name: dependency; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY dependency (id, version, origin, destination, queue_dependency, type) FROM stdin;
983043	6	2635	2636	\N	0
983044	6	2631	2635	\N	0
983042	6	2627	2631	\N	0
983045	6	2628	2629	\N	0
983046	6	2629	2630	\N	0
2293760	4	6262	6263	\N	0
\.


--
-- Data for Name: derived_allocation; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY derived_allocation (id, version, resource_allocation_id, configurationunit) FROM stdin;
\.


--
-- Data for Name: derived_day_assignments_container; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY derived_day_assignments_container (id, version, derived_allocation_id, scenario) FROM stdin;
\.


--
-- Data for Name: description_values; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY description_values (description_value_id, fieldname, value) FROM stdin;
\.


--
-- Data for Name: description_values_in_line; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY description_values_in_line (description_value_id, field_name, value) FROM stdin;
\.


--
-- Data for Name: direct_advance_assignment; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY direct_advance_assignment (advance_assignment_id, direct_order_element_id, max_value) FROM stdin;
2525	1945	100.00
2526	1946	6.00
2527	1948	100.00
2528	1949	100.00
2529	1950	100.00
2532	1952	100.00
2533	1953	100.00
2534	1954	100.00
2537	1955	100.00
2601	1962	100.00
6161	5566	100.00
6162	5567	100.00
\.


--
-- Data for Name: entity_sequence; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY entity_sequence (id, version, entity_name, prefix, last_value, number_of_digits, active) FROM stdin;
112	14	11	CALENDAR_EXCEPTION_TYPE	6	5	t
101	22	0	ORDER	3	5	t
105	21	4	WORKER	6	5	t
106	22	5	UNIT_TYPE	8	5	t
109	12	8	MATERIAL_CATEGORY	1	5	t
114	12	13	RESOURCE_CALENDAR	6	5	t
115	14	14	CRITERION_SATISFACTION	9	5	t
102	28	1	CRITERION	10	5	t
107	18	6	CALENDAR	6	5	t
103	18	2	LABEL	1	5	t
104	16	3	MACHINE	0	5	t
108	12	7	WORK_HOURS_TYPE	0	5	t
110	10	9	WORK_REPORT	0	5	t
111	9	10	WORKREPORTTYPE	0	5	t
113	7	12	COST_CATEGORY	0	5	t
116	4	15	RESOURCE_COST_CATEGORY_ASSIGNMENT	0	5	t
\.


--
-- Data for Name: external_company; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY external_company (id, version, name, nif, client, subcontractor, interacts_with_applications, app_uri, our_company_login, our_company_password, company_user) FROM stdin;
\.


--
-- Data for Name: generic_day_assignments_container; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY generic_day_assignments_container (id, version, resource_allocation_id, scenario, start_date, duration_start_in_first_day, end_date, duration_in_last_day) FROM stdin;
3237	4	3141	1010	2011-06-07	0	2011-06-23	14400
3238	4	3142	1010	2011-06-07	0	2011-06-14	0
3239	4	3143	1010	2011-06-07	0	2011-06-21	0
3234	5	3135	1010	2011-03-01	0	2011-04-09	0
3240	3	3145	1010	2011-06-23	14400	2011-07-22	0
3241	3	3146	1010	2011-06-23	14400	2011-07-22	0
3235	5	3136	1010	2011-04-09	0	2011-04-23	0
3236	5	3137	1010	2011-04-23	0	2011-05-07	0
7272	3	7171	1010	2011-05-02	0	2011-05-04	9600
7273	3	7172	1010	2011-05-04	0	2011-05-06	0
\.


--
-- Data for Name: generic_resource_allocation; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY generic_resource_allocation (resource_allocation_id, resource_type) FROM stdin;
3141	0
3142	0
3143	0
3135	0
3145	0
3146	0
3136	0
3137	0
7171	0
7172	0
\.


--
-- Data for Name: heading_field; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY heading_field (heading_id, fieldname, length, positionnumber) FROM stdin;
\.


--
-- Data for Name: hibernate_unique_key; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY hibernate_unique_key (next_hi) FROM stdin;
79
\.


--
-- Data for Name: hour_cost; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY hour_cost (id, version, code, price_cost, init_date, end_date, type_of_work_hours_id, cost_category_id) FROM stdin;
\.


--
-- Data for Name: hours_group; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY hours_group (id, version, code, resource_type, working_hours, percentage, fixed_percentage, parent_order_line, order_line_template) FROM stdin;
6064	9	ORDER00003-00002-00001	WORKER	10	1.00	f	5566	\N
6065	9	ORDER00003-00003-00001	WORKER	10	1.00	f	5567	\N
2443	11	ORDER00001-00002-00001	WORKER	160	1.00	f	1946	\N
2444	11	ORDER00001-00006-00001	WORKER	80	1.00	f	1948	\N
2445	11	ORDER00001-00007-00001	WORKER	80	1.00	f	1949	\N
2446	11	ORDER00001-00008-00001	WORKER	160	1.00	f	1950	\N
2447	11	ORDER00001-00009-00001	WORKER	100	1.00	f	1952	\N
2448	11	ORDER00001-00010-00001	WORKER	40	1.00	f	1953	\N
2449	11	ORDER00001-00011-00001	WORKER	80	1.00	f	1954	\N
2450	11	ORDER00001-00005-00001	WORKER	160	1.00	f	1955	\N
2442	11	ORDER00001-00001-00001	WORKER	350	1.00	f	1945	\N
2453	4	ORDER00002-00001-00001	WORKER	100	1.00	f	1962	\N
\.


--
-- Data for Name: indirect_advance_assignment; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY indirect_advance_assignment (advance_assignment_id, indirect_order_element_id) FROM stdin;
6165	5558
6166	5558
6163	5565
6164	5565
2530	1947
2531	1947
2535	1951
2536	1951
2538	1922
2539	1922
2600	1922
2603	1959
2602	1959
\.


--
-- Data for Name: label; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY label (id, version, code, name, label_type_id) FROM stdin;
1424	1	LABEL00001-00001	Baja	1515
1425	1	LABEL00001-00002	Muy urgente	1515
1426	1	LABEL00001-00003	Urgente	1515
1427	1	LABEL00001-00004	Promedio	1515
\.


--
-- Data for Name: label_type; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY label_type (id, version, code, name, code_autogenerated, last_label_sequence_code) FROM stdin;
1515	1	LABEL00001	Prioridad	t	4
\.


--
-- Data for Name: limiting_resource_queue; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY limiting_resource_queue (id, version, resource_id) FROM stdin;
\.


--
-- Data for Name: limiting_resource_queue_dependency; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY limiting_resource_queue_dependency (id, type, origin_queue_element_id, destiny_queue_element_id) FROM stdin;
\.


--
-- Data for Name: limiting_resource_queue_element; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY limiting_resource_queue_element (id, version, resource_allocation_id, limiting_resource_queue_id, earlier_start_date_because_of_gantt, earliest_end_date_because_of_gantt, creation_timestamp, start_date, start_hour, end_date, end_hour) FROM stdin;
\.


--
-- Data for Name: line_field; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY line_field (heading_id, fieldname, length, positionnumber) FROM stdin;
\.


--
-- Data for Name: machine; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY machine (machine_id, name, description) FROM stdin;
\.


--
-- Data for Name: machine_configuration_unit_required_criterions; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY machine_configuration_unit_required_criterions (id, criterion_id) FROM stdin;
\.


--
-- Data for Name: machine_worker_assignment; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY machine_worker_assignment (id, version, start_date, finish_date, configuration_id, worker_id) FROM stdin;
\.


--
-- Data for Name: machine_workers_configuration_unit; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY machine_workers_configuration_unit (id, version, name, alpha, machine) FROM stdin;
\.


--
-- Data for Name: material; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY material (id, version, code, description, default_unit_price, unit_type, disabled, category_id) FROM stdin;
\.


--
-- Data for Name: material_assigment; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY material_assigment (id, version, units, unit_price, material_id, estimated_availability, status, order_element_id) FROM stdin;
\.


--
-- Data for Name: material_assigment_template; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY material_assigment_template (id, version, units, unit_price, material_id, order_element_template_id) FROM stdin;
\.


--
-- Data for Name: material_category; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY material_category (id, version, code, name, code_autogenerated, last_material_sequence_code, parent_id) FROM stdin;
909	1	MATERIAL_CATEGORY00001	Imported materials without category	t	0	\N
\.


--
-- Data for Name: order_authorization; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY order_authorization (id, order_authorization_subclass, version, authorization_type, order_id, user_id, profile_id) FROM stdin;
2323	user	4	WRITE_AUTHORIZATION	1922	1213	\N
2324	user	4	WRITE_AUTHORIZATION	1959	1213	\N
5959	user	4	WRITE_AUTHORIZATION	5558	1213	\N
\.


--
-- Data for Name: order_element; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY order_element (id, version, name, description, code, init_date, deadline, last_advance_meausurement_for_spreading, dirty_last_advance_measurement_for_spreading, parent, template, external_code, sum_charged_hours_id, position_in_container) FROM stdin;
1945	11	Coordinación	\N	ORDER00001-00001	\N	\N	0.25	f	1922	\N	\N	2046	0
1922	12	Proyecto 1 - Programa de Contabilidad	\N	ORDER00001	2011-03-01 00:00:00+01	2011-08-01 00:00:00+02	0.14	t	\N	\N	\N	2023	\N
1946	11	Análisis	\N	ORDER00001-00002	\N	\N	0.50	f	1922	\N	\N	2047	1
1947	11	Módulo de sistema de usuarios	\N	ORDER00001-00003	\N	\N	0.00	f	1922	\N	\N	2048	2
1948	11	CU1 - Alta usuarios	\N	ORDER00001-00006	\N	\N	0.00	f	1947	\N	\N	2049	0
1949	11	CU2 - Registro de usuarios	\N	ORDER00001-00007	\N	\N	0.00	f	1947	\N	\N	2050	1
1950	11	CU3- Gestión de roles de usuario	\N	ORDER00001-00008	\N	\N	0.00	f	1947	\N	\N	2051	2
1951	11	Módulo Facturas	\N	ORDER00001-00004	\N	\N	0.00	f	1922	\N	\N	2052	3
1952	11	CU4 - Alta de facturas	\N	ORDER00001-00009	\N	\N	0.00	f	1951	\N	\N	2053	0
1953	11	CU5 - Listado de facturas	\N	ORDER00001-00010	\N	\N	0.00	f	1951	\N	\N	2054	1
1954	11	CU6 - Búsqueda de facturas	\N	ORDER00001-00011	\N	\N	0.00	f	1951	\N	\N	2055	2
1955	11	Módulo Pruebas	\N	ORDER00001-00005	\N	\N	0.00	f	1922	\N	\N	2056	4
5565	9	Fix bidet	\N	ORDER00003-00001	\N	\N	0.20	f	5558	\N	\N	5666	0
5558	10	Housework	\N	ORDER00003	2011-05-02 11:05:47.873+02	\N	0.20	f	\N	\N	\N	5659	\N
1959	5	Order 1	\N	ORDER00002	2011-04-30 22:22:34.105+02	\N	0.00	f	\N	\N	\N	2844	\N
1962	4	order element 1	\N	ORDER00002-00001	\N	\N	0.00	f	1959	\N	\N	2847	0
5566	9	Repair handles	\N	ORDER00003-00002	\N	\N	0.20	f	5565	\N	\N	5667	0
5567	9	Unblock pipes	\N	ORDER00003-00003	\N	\N	0.20	f	5565	\N	\N	5668	1
\.


--
-- Data for Name: order_element_label; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY order_element_label (order_element_id, label_id) FROM stdin;
\.


--
-- Data for Name: order_element_template; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY order_element_template (id, version, name, description, code, start_as_days_from_beginning, deadline_as_days_from_beginning, scheduling_state_type, parent, position_in_container) FROM stdin;
\.


--
-- Data for Name: order_element_template_label; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY order_element_template_label (order_element_template_id, label_id) FROM stdin;
\.


--
-- Data for Name: order_element_template_quality_form; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY order_element_template_quality_form (order_element_template_id, quality_form_id) FROM stdin;
\.


--
-- Data for Name: order_line; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY order_line (order_element_id, last_hours_group_sequence_code) FROM stdin;
1945	1
1946	1
1948	1
1949	1
1950	1
1952	1
1953	1
1954	1
1955	1
1962	1
5566	1
5567	1
\.


--
-- Data for Name: order_line_group; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY order_line_group (order_element_id) FROM stdin;
1922
1947
1951
1959
5558
5565
\.


--
-- Data for Name: order_line_group_template; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY order_line_group_template (group_template_id) FROM stdin;
\.


--
-- Data for Name: order_line_template; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY order_line_template (order_line_template_id, last_hours_group_sequence_code) FROM stdin;
\.


--
-- Data for Name: order_table; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY order_table (order_element_id, responsible, dependencies_constraints_have_priority, code_autogenerated, last_order_element_sequence_code, work_budget, materials_budget, total_hours, customer_reference, external_code, state, customer, base_calendar_id, scheduling_mode) FROM stdin;
1922	\N	\N	t	11	0.00	0.00	1210	\N	\N	0	\N	202	0
1959	\N	\N	t	1	0.00	0.00	100	\N	\N	0	\N	202	0
5558	\N	\N	t	3	0.00	0.00	20	\N	\N	0	\N	202	0
\.


--
-- Data for Name: order_template; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY order_template (order_template_id, base_calendar_id) FROM stdin;
\.


--
-- Data for Name: order_version; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY order_version (id, version, modification_by_owner_timestamp, ownerscenario) FROM stdin;
2225	12	2011-04-30 22:22:15.912+02	1010
2229	5	2011-04-30 22:31:35.037+02	1010
5861	10	2011-05-02 11:52:54.071+02	1010
\.


--
-- Data for Name: planning_data; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY planning_data (planning_data_id, progress_by_duration, progress_by_num_hours) FROM stdin;
2637	0.139423	0.142776
6265	0.200000	0.200000
\.


--
-- Data for Name: profile_roles; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY profile_roles (profile_id, elt) FROM stdin;
\.


--
-- Data for Name: profile_table; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY profile_table (id, version, profile_name) FROM stdin;
\.


--
-- Data for Name: quality_form; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY quality_form (id, version, name, description, quality_form_type, report_advance, advance_type_id) FROM stdin;
\.


--
-- Data for Name: quality_form_items; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY quality_form_items (quality_form_id, name, percentage, "position", idx) FROM stdin;
\.


--
-- Data for Name: resource; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY resource (id, version, code, code_autogenerated, base_calendar_id, resource_type) FROM stdin;
1617	4	WORKER00001	t	206	NON_LIMITING_RESOURCE
1619	3	WORKER00002	t	207	NON_LIMITING_RESOURCE
1621	4	WORKER00003	t	208	NON_LIMITING_RESOURCE
1623	4	WORKER00004	t	209	NON_LIMITING_RESOURCE
1625	4	WORKER00005	t	210	NON_LIMITING_RESOURCE
6566	1	WORKER00006	t	6666	NON_LIMITING_RESOURCE
\.


--
-- Data for Name: resource_allocation; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY resource_allocation (id, version, resources_per_day, intended_total_hours, task, assignment_function, intended_resources_per_day, intended_total_assignment, intended_non_consolidated_effort) FROM stdin;
7171	3	0.75	\N	6262	\N	0.75	36000	28800
7172	3	0.60	\N	6263	\N	0.75	36000	28800
3140	5	0.50	\N	2626	\N	0.50	1080000	1080000
3141	4	1.00	\N	2632	\N	1.00	360000	360000
3142	4	1.00	\N	2633	\N	1.00	144000	144000
3143	4	1.00	\N	2634	\N	1.00	288000	288000
3135	5	1.08	\N	2627	\N	1.00	576000	288000
3145	3	0.50	\N	2636	\N	1.00	288000	288000
3144	3	0.91	\N	2636	\N	\N	144000	144000
3146	3	0.50	\N	2636	\N	1.00	288000	288000
3136	5	1.00	\N	2628	\N	1.00	288000	288000
3137	5	1.00	\N	2629	\N	1.00	288000	288000
3139	5	0.75	\N	2630	\N	0.75	453600	453600
3138	5	0.25	\N	2630	\N	0.25	151200	151200
\.


--
-- Data for Name: resource_calendar; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY resource_calendar (base_calendar_id, capacity) FROM stdin;
206	1
207	1
208	1
209	1
210	1
6666	1
\.


--
-- Data for Name: resources_cost_category_assignment; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY resources_cost_category_assignment (id, version, code, init_date, end_date, cost_category_id, resource_id) FROM stdin;
\.


--
-- Data for Name: roles_table; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY roles_table (user_id, elt) FROM stdin;
1213	ROLE_READ_ALL_ORDERS
1213	ROLE_CREATE_ORDER
1213	ROLE_EDIT_ALL_ORDERS
1213	ROLE_ADMINISTRATION
1214	ROLE_WS_READER
1215	ROLE_WS_READER
1215	ROLE_WS_WRITER
\.


--
-- Data for Name: scenario; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY scenario (id, version, name, description, last_not_owned_reassignations_time_stamp, predecessor) FROM stdin;
1010	0	master	\N	\N	\N
\.


--
-- Data for Name: scenario_orders; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY scenario_orders (order_id, order_version_id, scenario_id) FROM stdin;
1922	2225	1010
1959	2229	1010
5558	5861	1010
\.


--
-- Data for Name: scheduling_data_for_version; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY scheduling_data_for_version (id, version, scheduling_state_type, order_element_id) FROM stdin;
2124	12	3	1922
2148	11	0	1946
2149	11	3	1947
2150	11	0	1948
2151	11	0	1949
2152	11	0	1950
2153	11	3	1951
2154	11	0	1952
2155	11	0	1953
2156	11	0	1954
2157	11	0	1955
2147	11	0	1945
2161	6	3	1959
2164	5	0	1962
5760	10	3	5558
5767	9	3	5565
5768	9	0	5566
5769	9	0	5567
\.


--
-- Data for Name: scheduling_states_by_order_version; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY scheduling_states_by_order_version (order_element_id, scheduling_state_for_version_id, order_version_id) FROM stdin;
1922	2124	2225
1945	2147	2225
1946	2148	2225
1947	2149	2225
1948	2150	2225
1949	2151	2225
1950	2152	2225
1951	2153	2225
1952	2154	2225
1953	2155	2225
1954	2156	2225
1955	2157	2225
1959	2161	2229
1962	2164	2229
5558	5760	5861
5565	5767	5861
5566	5768	5861
5567	5769	5861
\.


--
-- Data for Name: sigmoid_function; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY sigmoid_function (assignment_function_id) FROM stdin;
\.


--
-- Data for Name: specific_day_assignments_container; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY specific_day_assignments_container (id, version, resource_allocation_id, scenario, start_date, duration_start_in_first_day, end_date, duration_in_last_day) FROM stdin;
3438	5	3140	1010	2011-03-01	0	2011-06-28	0
3439	3	3144	1010	2011-06-23	14400	2011-07-22	0
3437	5	3139	1010	2011-05-07	0	2011-06-07	0
3436	5	3138	1010	2011-05-07	0	2011-06-07	0
\.


--
-- Data for Name: specific_resource_allocation; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY specific_resource_allocation (resource_allocation_id, resource) FROM stdin;
3140	1617
3144	1619
3139	1619
3138	1621
\.


--
-- Data for Name: stretches; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY stretches (assignment_function_id, date, length_percentage, amount_work_percentage, stretch_position) FROM stdin;
\.


--
-- Data for Name: stretches_function; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY stretches_function (assignment_function_id, type) FROM stdin;
\.


--
-- Data for Name: subcontracted_task_data; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY subcontracted_task_data (id, version, external_company, subcontratation_date, subcontract_communication_date, work_description, subcontract_price, subcontracted_code, node_without_children_exported, labels_exported, material_assignments_exported, hours_groups_exported, state) FROM stdin;
\.


--
-- Data for Name: sum_charged_hours; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY sum_charged_hours (id, version, direct_charged_hours, indirect_charged_hours) FROM stdin;
2023	12	0	0
2047	11	0	0
2048	11	0	0
2049	11	0	0
2050	11	0	0
2051	11	0	0
2052	11	0	0
2053	11	0	0
2054	11	0	0
2055	11	0	0
2056	11	0	0
2046	11	0	0
2844	5	0	0
2847	4	0	0
5659	10	0	0
5666	9	0	0
5667	9	0	0
5668	9	0	0
\.


--
-- Data for Name: task; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY task (task_element_id, calculated_value, constraint_type, constraint_date, workable_days, allocation_direction, subcontrated_task_data_id, priority) FROM stdin;
2626	1	0	\N	\N	0	\N	\N
2632	1	0	\N	\N	0	\N	\N
2633	1	0	\N	\N	0	\N	\N
2634	1	0	\N	\N	0	\N	\N
2627	1	0	\N	\N	0	\N	\N
2636	2	0	\N	21	0	\N	\N
2628	2	0	\N	10	0	\N	\N
2629	2	0	\N	10	0	\N	\N
2630	0	0	\N	21	0	\N	\N
2640	1	0	\N	\N	0	\N	\N
6262	1	0	\N	\N	0	\N	\N
6263	1	0	\N	\N	0	\N	\N
\.


--
-- Data for Name: task_element; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY task_element (id, version, name, notes, start_date, start_day_duration, end_date, end_day_duration, deadline, advance_percentage, sum_of_hours_allocated, parent, base_calendar_id, position_in_parent) FROM stdin;
6264	9	Fix bidet	\N	2011-05-02	0	2011-05-06	0	\N	0.2000	22	6265	\N	0
6262	9	Repair handles	\N	2011-05-02	0	2011-05-04	9600	\N	0.2000	14	6264	\N	0
6263	9	Unblock pipes	\N	2011-05-04	9600	2011-05-06	0	\N	0.2000	8	6264	\N	1
6265	9	Housework	\N	2011-05-02	0	2011-05-06	0	\N	0.2000	22	\N	\N	\N
2640	2	order element 1	\N	2011-04-30	0	2011-05-18	14400	\N	0.0000	0	2641	\N	0
2641	2	Order 1	\N	2011-04-30	0	2011-05-18	14400	\N	0.0000	0	\N	\N	\N
2626	11	Coordinación	\N	2011-03-01	0	2011-06-28	0	\N	0.2500	300	2637	\N	0
2635	11	Módulo Facturas	\N	2011-06-07	0	2011-06-23	14400	\N	0.0000	220	2637	\N	3
2632	11	CU4 - Alta de facturas	\N	2011-06-07	0	2011-06-23	14400	\N	0.0000	100	2635	\N	0
2633	11	CU5 - Listado de facturas	\N	2011-06-07	0	2011-06-14	0	\N	0.0000	40	2635	\N	1
2634	11	CU6 - Búsqueda de facturas	\N	2011-06-07	0	2011-06-21	0	\N	0.0000	80	2635	\N	2
2627	11	Análisis	\N	2011-03-01	0	2011-04-09	0	\N	0.5000	251	2637	\N	1
2636	11	Módulo Pruebas	\N	2011-06-23	14400	2011-07-22	14400	\N	0.0000	200	2637	\N	4
2631	11	Módulo de sistema de usuarios	\N	2011-04-09	0	2011-06-07	0	\N	0.0000	328	2637	\N	2
2628	11	CU1 - Alta usuarios	\N	2011-04-09	0	2011-04-23	0	\N	0.0000	80	2631	\N	0
2629	11	CU2 - Registro de usuarios	\N	2011-04-23	0	2011-05-07	0	\N	0.0000	80	2631	\N	1
2630	11	CU3- Gestión de roles de usuario	\N	2011-05-07	0	2011-06-07	0	\N	0.0000	168	2631	\N	2
2637	11	Proyecto 1 - Programa de Contabilidad	\N	2011-03-01	0	2011-07-22	0	2011-08-01	0.1384	1299	\N	\N	\N
\.


--
-- Data for Name: task_group; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY task_group (task_element_id) FROM stdin;
2631
2635
2637
2641
6264
6265
\.


--
-- Data for Name: task_milestone; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY task_milestone (task_element_id, constraint_type, constraint_date) FROM stdin;
\.


--
-- Data for Name: task_quality_form; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY task_quality_form (id, version, quality_form_id, order_element_id, report_advance) FROM stdin;
\.


--
-- Data for Name: task_quality_form_items; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY task_quality_form_items (task_quality_form_id, name, percentage, "position", passed, date, idx) FROM stdin;
\.


--
-- Data for Name: task_source; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY task_source (id, version, schedulingdata) FROM stdin;
6262	4	5768
6263	4	5769
6264	4	5767
6265	4	5760
2626	4	2147
2627	4	2148
2628	4	2150
2629	4	2151
2630	4	2152
2631	4	2149
2632	4	2154
2633	4	2155
2634	4	2156
2635	4	2153
2636	4	2157
2637	4	2124
2640	2	2164
2641	2	2161
\.


--
-- Data for Name: task_source_hours_groups; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY task_source_hours_groups (task_source_id, hours_group_id) FROM stdin;
2626	2442
2627	2443
2628	2444
2629	2445
2630	2446
2632	2447
2633	2448
2634	2449
2636	2450
2640	2453
6262	6064
6263	6065
\.


--
-- Data for Name: type_of_work_hours; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY type_of_work_hours (id, version, name, code, default_price, enabled, code_autogenerated) FROM stdin;
\.


--
-- Data for Name: unit_type; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY unit_type (id, version, code, measure, code_autogenerated) FROM stdin;
808	8	UNIT_TYPE00001	units	t
809	7	UNIT_TYPE00002	kg	t
810	6	UNIT_TYPE00003	km	t
811	5	UNIT_TYPE00004	l	t
812	4	UNIT_TYPE00005	m	t
813	3	UNIT_TYPE00006	m2	t
814	2	UNIT_TYPE00007	m3	t
815	1	UNIT_TYPE00008	tn	t
\.


--
-- Data for Name: user_profiles; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY user_profiles (user_id, profile_id) FROM stdin;
\.


--
-- Data for Name: user_table; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY user_table (id, version, login_name, password, email, disabled, lastconnectedscenario) FROM stdin;
1212	4	user	c35c71570b3f45bb21a588107e7cb946b3c50bf2cd9e885d3876de669a73df1133aabe8b69d24db37837c6f26f9e7bc35dc34ee04c8f9a51d53ed7d82859f80e	\N	f	\N
1213	3	admin	e02a1a8809e830cf7b7c875e43c16e684ed02a818c7ac25aeadd515432f908ea041447720c194d6b0ec19a1c3dd97f7b378efaab4dd8efd46de568adf3f44c9a	\N	f	\N
1214	2	wsreader	9134100ea9446b87a04cda86febe02900e53ca5af2f5b9422c5120bc3291079a7de3ea91ec72e944167e3fbcb97d35a2a904ee66bacf3727a67f7e5bf9fdaadc	\N	f	\N
1215	1	wswriter	a3d23705b1bb5ededfc890707b8e3331760206a6ceb213469fdf320dbe889170c2da17106005c5d057c51462621d7d77f33e005e6b9f1cddec6fa8c9b7a66eb8	\N	f	\N
\.


--
-- Data for Name: virtual_worker; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY virtual_worker (virtual_worker_id, observations) FROM stdin;
\.


--
-- Data for Name: work_report; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY work_report (id, version, code, date, code_autogenerated, last_work_report_line_sequence_code, ork_report_type_id, resource_id, order_element_id) FROM stdin;
\.


--
-- Data for Name: work_report_label_type_assigment; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY work_report_label_type_assigment (id, version, labels_shared_by_lines, position_number, label_type_id, label_id, work_report_type_id) FROM stdin;
\.


--
-- Data for Name: work_report_line; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY work_report_line (id, version, code, num_hours, date, clock_start, clock_finish, work_report_id, resource_id, order_element_id, type_work_hours_id) FROM stdin;
\.


--
-- Data for Name: work_report_type; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY work_report_type (id, version, name, code, date_is_shared_by_lines, resource_is_shared_in_lines, order_element_is_shared_in_lines, code_autogenerated, hours_management) FROM stdin;
\.


--
-- Data for Name: worker; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY worker (worker_id, first_name, surname, nif) FROM stdin;
1617	Raúl	González Álvarez	1A
1619	Ana	Pérez López	2B
1621	Felipe	Romero Gómez	3C
1623	Vicente	Martínez Pino	4C
1625	Pablo	Requejo Tilve	5G
6566	Mario	Mario	3A
\.


--
-- Data for Name: workreports_labels; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY workreports_labels (work_report_id, label_id) FROM stdin;
\.


--
-- Data for Name: workreportslines_labels; Type: TABLE DATA; Schema: public; Owner: naval
--

COPY workreportslines_labels (work_report_line_id, label_id) FROM stdin;
\.


--
-- Name: advance_assignment_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY advance_assignment
    ADD CONSTRAINT advance_assignment_pkey PRIMARY KEY (id);


--
-- Name: advance_assignment_template_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY advance_assignment_template
    ADD CONSTRAINT advance_assignment_template_pkey PRIMARY KEY (id);


--
-- Name: advance_measurement_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY advance_measurement
    ADD CONSTRAINT advance_measurement_pkey PRIMARY KEY (id);


--
-- Name: advance_type_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY advance_type
    ADD CONSTRAINT advance_type_pkey PRIMARY KEY (id);


--
-- Name: advance_type_unit_name_key; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY advance_type
    ADD CONSTRAINT advance_type_unit_name_key UNIQUE (unit_name);


--
-- Name: all_criterions_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY all_criterions
    ADD CONSTRAINT all_criterions_pkey PRIMARY KEY (generic_resource_allocation_id, criterion_id);


--
-- Name: assignment_function_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY assignment_function
    ADD CONSTRAINT assignment_function_pkey PRIMARY KEY (id);


--
-- Name: base_calendar_code_key; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY base_calendar
    ADD CONSTRAINT base_calendar_code_key UNIQUE (code);


--
-- Name: base_calendar_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY base_calendar
    ADD CONSTRAINT base_calendar_pkey PRIMARY KEY (id);


--
-- Name: calendar_availability_code_key; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY calendar_availability
    ADD CONSTRAINT calendar_availability_code_key UNIQUE (code);


--
-- Name: calendar_availability_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY calendar_availability
    ADD CONSTRAINT calendar_availability_pkey PRIMARY KEY (id);


--
-- Name: calendar_data_code_key; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY calendar_data
    ADD CONSTRAINT calendar_data_code_key UNIQUE (code);


--
-- Name: calendar_data_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY calendar_data
    ADD CONSTRAINT calendar_data_pkey PRIMARY KEY (id);


--
-- Name: calendar_exception_code_key; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY calendar_exception
    ADD CONSTRAINT calendar_exception_code_key UNIQUE (code);


--
-- Name: calendar_exception_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY calendar_exception
    ADD CONSTRAINT calendar_exception_pkey PRIMARY KEY (id);


--
-- Name: calendar_exception_type_code_key; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY calendar_exception_type
    ADD CONSTRAINT calendar_exception_type_code_key UNIQUE (code);


--
-- Name: calendar_exception_type_name_key; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY calendar_exception_type
    ADD CONSTRAINT calendar_exception_type_name_key UNIQUE (name);


--
-- Name: calendar_exception_type_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY calendar_exception_type
    ADD CONSTRAINT calendar_exception_type_pkey PRIMARY KEY (id);


--
-- Name: configuration_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY configuration
    ADD CONSTRAINT configuration_pkey PRIMARY KEY (id);


--
-- Name: consolidated_value_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY consolidated_value
    ADD CONSTRAINT consolidated_value_pkey PRIMARY KEY (id);


--
-- Name: consolidation_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY consolidation
    ADD CONSTRAINT consolidation_pkey PRIMARY KEY (id);


--
-- Name: cost_category_code_key; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY cost_category
    ADD CONSTRAINT cost_category_code_key UNIQUE (code);


--
-- Name: cost_category_name_key; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY cost_category
    ADD CONSTRAINT cost_category_name_key UNIQUE (name);


--
-- Name: cost_category_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY cost_category
    ADD CONSTRAINT cost_category_pkey PRIMARY KEY (id);


--
-- Name: criterion_code_key; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY criterion
    ADD CONSTRAINT criterion_code_key UNIQUE (code);


--
-- Name: criterion_name_key; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY criterion
    ADD CONSTRAINT criterion_name_key UNIQUE (id_criterion_type, name);


--
-- Name: criterion_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY criterion
    ADD CONSTRAINT criterion_pkey PRIMARY KEY (id);


--
-- Name: criterion_requirement_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY criterion_requirement
    ADD CONSTRAINT criterion_requirement_pkey PRIMARY KEY (id);


--
-- Name: criterion_satisfaction_code_key; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY criterion_satisfaction
    ADD CONSTRAINT criterion_satisfaction_code_key UNIQUE (code);


--
-- Name: criterion_satisfaction_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY criterion_satisfaction
    ADD CONSTRAINT criterion_satisfaction_pkey PRIMARY KEY (id);


--
-- Name: criterion_type_code_key; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY criterion_type
    ADD CONSTRAINT criterion_type_code_key UNIQUE (code);


--
-- Name: criterion_type_name_key; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY criterion_type
    ADD CONSTRAINT criterion_type_name_key UNIQUE (name);


--
-- Name: criterion_type_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY criterion_type
    ADD CONSTRAINT criterion_type_pkey PRIMARY KEY (id);


--
-- Name: day_assignment_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY day_assignment
    ADD CONSTRAINT day_assignment_pkey PRIMARY KEY (id);


--
-- Name: dependency_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY dependency
    ADD CONSTRAINT dependency_pkey PRIMARY KEY (id);


--
-- Name: derived_allocation_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY derived_allocation
    ADD CONSTRAINT derived_allocation_pkey PRIMARY KEY (id);


--
-- Name: derived_day_assignments_container_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY derived_day_assignments_container
    ADD CONSTRAINT derived_day_assignments_container_pkey PRIMARY KEY (id);


--
-- Name: direct_advance_assignment_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY direct_advance_assignment
    ADD CONSTRAINT direct_advance_assignment_pkey PRIMARY KEY (advance_assignment_id);


--
-- Name: effort_per_day_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY capacity_per_day
    ADD CONSTRAINT effort_per_day_pkey PRIMARY KEY (base_calendar_id, day_id);


--
-- Name: entity_sequence_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY entity_sequence
    ADD CONSTRAINT entity_sequence_pkey PRIMARY KEY (id);


--
-- Name: external_company_name_key; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY external_company
    ADD CONSTRAINT external_company_name_key UNIQUE (name);


--
-- Name: external_company_nif_key; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY external_company
    ADD CONSTRAINT external_company_nif_key UNIQUE (nif);


--
-- Name: external_company_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY external_company
    ADD CONSTRAINT external_company_pkey PRIMARY KEY (id);


--
-- Name: generic_day_assignments_container_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY generic_day_assignments_container
    ADD CONSTRAINT generic_day_assignments_container_pkey PRIMARY KEY (id);


--
-- Name: generic_resource_allocation_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY generic_resource_allocation
    ADD CONSTRAINT generic_resource_allocation_pkey PRIMARY KEY (resource_allocation_id);


--
-- Name: hour_cost_code_key; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY hour_cost
    ADD CONSTRAINT hour_cost_code_key UNIQUE (code);


--
-- Name: hour_cost_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY hour_cost
    ADD CONSTRAINT hour_cost_pkey PRIMARY KEY (id);


--
-- Name: hours_group_code_key; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY hours_group
    ADD CONSTRAINT hours_group_code_key UNIQUE (code);


--
-- Name: hours_group_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY hours_group
    ADD CONSTRAINT hours_group_pkey PRIMARY KEY (id);


--
-- Name: indirect_advance_assignment_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY indirect_advance_assignment
    ADD CONSTRAINT indirect_advance_assignment_pkey PRIMARY KEY (advance_assignment_id);


--
-- Name: label_code_key; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY label
    ADD CONSTRAINT label_code_key UNIQUE (code);


--
-- Name: label_name_key; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY label
    ADD CONSTRAINT label_name_key UNIQUE (label_type_id, name);


--
-- Name: label_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY label
    ADD CONSTRAINT label_pkey PRIMARY KEY (id);


--
-- Name: label_type_code_key; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY label_type
    ADD CONSTRAINT label_type_code_key UNIQUE (code);


--
-- Name: label_type_name_key; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY label_type
    ADD CONSTRAINT label_type_name_key UNIQUE (name);


--
-- Name: label_type_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY label_type
    ADD CONSTRAINT label_type_pkey PRIMARY KEY (id);


--
-- Name: limiting_resource_queue_dependency_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY limiting_resource_queue_dependency
    ADD CONSTRAINT limiting_resource_queue_dependency_pkey PRIMARY KEY (id);


--
-- Name: limiting_resource_queue_element_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY limiting_resource_queue_element
    ADD CONSTRAINT limiting_resource_queue_element_pkey PRIMARY KEY (id);


--
-- Name: limiting_resource_queue_element_resource_allocation_id_key; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY limiting_resource_queue_element
    ADD CONSTRAINT limiting_resource_queue_element_resource_allocation_id_key UNIQUE (resource_allocation_id);


--
-- Name: limiting_resource_queue_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY limiting_resource_queue
    ADD CONSTRAINT limiting_resource_queue_pkey PRIMARY KEY (id);


--
-- Name: limiting_resource_queue_resource_id_key; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY limiting_resource_queue
    ADD CONSTRAINT limiting_resource_queue_resource_id_key UNIQUE (resource_id);


--
-- Name: machine_configuration_unit_required_criterions_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY machine_configuration_unit_required_criterions
    ADD CONSTRAINT machine_configuration_unit_required_criterions_pkey PRIMARY KEY (id, criterion_id);


--
-- Name: machine_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY machine
    ADD CONSTRAINT machine_pkey PRIMARY KEY (machine_id);


--
-- Name: machine_worker_assignment_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY machine_worker_assignment
    ADD CONSTRAINT machine_worker_assignment_pkey PRIMARY KEY (id);


--
-- Name: machine_workers_configuration_unit_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY machine_workers_configuration_unit
    ADD CONSTRAINT machine_workers_configuration_unit_pkey PRIMARY KEY (id);


--
-- Name: material_assigment_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY material_assigment
    ADD CONSTRAINT material_assigment_pkey PRIMARY KEY (id);


--
-- Name: material_assigment_template_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY material_assigment_template
    ADD CONSTRAINT material_assigment_template_pkey PRIMARY KEY (id);


--
-- Name: material_category_code_key; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY material_category
    ADD CONSTRAINT material_category_code_key UNIQUE (code);


--
-- Name: material_category_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY material_category
    ADD CONSTRAINT material_category_pkey PRIMARY KEY (id);


--
-- Name: material_code_key; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY material
    ADD CONSTRAINT material_code_key UNIQUE (code);


--
-- Name: material_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY material
    ADD CONSTRAINT material_pkey PRIMARY KEY (id);


--
-- Name: order_authorization_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY order_authorization
    ADD CONSTRAINT order_authorization_pkey PRIMARY KEY (id);


--
-- Name: order_element_code_key; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY order_element
    ADD CONSTRAINT order_element_code_key UNIQUE (code);


--
-- Name: order_element_label_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY order_element_label
    ADD CONSTRAINT order_element_label_pkey PRIMARY KEY (order_element_id, label_id);


--
-- Name: order_element_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY order_element
    ADD CONSTRAINT order_element_pkey PRIMARY KEY (id);


--
-- Name: order_element_sum_charged_hours_id_key; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY order_element
    ADD CONSTRAINT order_element_sum_charged_hours_id_key UNIQUE (sum_charged_hours_id);


--
-- Name: order_element_template_label_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY order_element_template_label
    ADD CONSTRAINT order_element_template_label_pkey PRIMARY KEY (order_element_template_id, label_id);


--
-- Name: order_element_template_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY order_element_template
    ADD CONSTRAINT order_element_template_pkey PRIMARY KEY (id);


--
-- Name: order_element_template_quality_form_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY order_element_template_quality_form
    ADD CONSTRAINT order_element_template_quality_form_pkey PRIMARY KEY (order_element_template_id, quality_form_id);


--
-- Name: order_line_group_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY order_line_group
    ADD CONSTRAINT order_line_group_pkey PRIMARY KEY (order_element_id);


--
-- Name: order_line_group_template_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY order_line_group_template
    ADD CONSTRAINT order_line_group_template_pkey PRIMARY KEY (group_template_id);


--
-- Name: order_line_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY order_line
    ADD CONSTRAINT order_line_pkey PRIMARY KEY (order_element_id);


--
-- Name: order_line_template_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY order_line_template
    ADD CONSTRAINT order_line_template_pkey PRIMARY KEY (order_line_template_id);


--
-- Name: order_table_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY order_table
    ADD CONSTRAINT order_table_pkey PRIMARY KEY (order_element_id);


--
-- Name: order_template_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY order_template
    ADD CONSTRAINT order_template_pkey PRIMARY KEY (order_template_id);


--
-- Name: order_version_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY order_version
    ADD CONSTRAINT order_version_pkey PRIMARY KEY (id);


--
-- Name: pk_databasechangelog; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY databasechangelog
    ADD CONSTRAINT pk_databasechangelog PRIMARY KEY (id, author, filename);


--
-- Name: pk_databasechangeloglock; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY databasechangeloglock
    ADD CONSTRAINT pk_databasechangeloglock PRIMARY KEY (id);


--
-- Name: planning_data_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY planning_data
    ADD CONSTRAINT planning_data_pkey PRIMARY KEY (planning_data_id);


--
-- Name: profile_table_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY profile_table
    ADD CONSTRAINT profile_table_pkey PRIMARY KEY (id);


--
-- Name: profile_table_profile_name_key; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY profile_table
    ADD CONSTRAINT profile_table_profile_name_key UNIQUE (profile_name);


--
-- Name: quality_form_items_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY quality_form_items
    ADD CONSTRAINT quality_form_items_pkey PRIMARY KEY (quality_form_id, idx);


--
-- Name: quality_form_name_key; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY quality_form
    ADD CONSTRAINT quality_form_name_key UNIQUE (name);


--
-- Name: quality_form_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY quality_form
    ADD CONSTRAINT quality_form_pkey PRIMARY KEY (id);


--
-- Name: resource_allocation_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY resource_allocation
    ADD CONSTRAINT resource_allocation_pkey PRIMARY KEY (id);


--
-- Name: resource_base_calendar_id_key; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY resource
    ADD CONSTRAINT resource_base_calendar_id_key UNIQUE (base_calendar_id);


--
-- Name: resource_calendar_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY resource_calendar
    ADD CONSTRAINT resource_calendar_pkey PRIMARY KEY (base_calendar_id);


--
-- Name: resource_code_key; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY resource
    ADD CONSTRAINT resource_code_key UNIQUE (code);


--
-- Name: resource_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY resource
    ADD CONSTRAINT resource_pkey PRIMARY KEY (id);


--
-- Name: resources_cost_category_assignment_code_key; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY resources_cost_category_assignment
    ADD CONSTRAINT resources_cost_category_assignment_code_key UNIQUE (code);


--
-- Name: resources_cost_category_assignment_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY resources_cost_category_assignment
    ADD CONSTRAINT resources_cost_category_assignment_pkey PRIMARY KEY (id);


--
-- Name: scenario_orders_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY scenario_orders
    ADD CONSTRAINT scenario_orders_pkey PRIMARY KEY (scenario_id, order_id);


--
-- Name: scenario_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY scenario
    ADD CONSTRAINT scenario_pkey PRIMARY KEY (id);


--
-- Name: scheduling_data_for_version_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY scheduling_data_for_version
    ADD CONSTRAINT scheduling_data_for_version_pkey PRIMARY KEY (id);


--
-- Name: scheduling_states_by_order_version_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY scheduling_states_by_order_version
    ADD CONSTRAINT scheduling_states_by_order_version_pkey PRIMARY KEY (order_element_id, order_version_id);


--
-- Name: sigmoid_function_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY sigmoid_function
    ADD CONSTRAINT sigmoid_function_pkey PRIMARY KEY (assignment_function_id);


--
-- Name: specific_day_assignments_container_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY specific_day_assignments_container
    ADD CONSTRAINT specific_day_assignments_container_pkey PRIMARY KEY (id);


--
-- Name: specific_resource_allocation_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY specific_resource_allocation
    ADD CONSTRAINT specific_resource_allocation_pkey PRIMARY KEY (resource_allocation_id);


--
-- Name: stretches_function_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY stretches_function
    ADD CONSTRAINT stretches_function_pkey PRIMARY KEY (assignment_function_id);


--
-- Name: stretches_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY stretches
    ADD CONSTRAINT stretches_pkey PRIMARY KEY (assignment_function_id, stretch_position);


--
-- Name: subcontracted_task_data_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY subcontracted_task_data
    ADD CONSTRAINT subcontracted_task_data_pkey PRIMARY KEY (id);


--
-- Name: sum_charged_hours_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY sum_charged_hours
    ADD CONSTRAINT sum_charged_hours_pkey PRIMARY KEY (id);


--
-- Name: task_element_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY task_element
    ADD CONSTRAINT task_element_pkey PRIMARY KEY (id);


--
-- Name: task_group_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY task_group
    ADD CONSTRAINT task_group_pkey PRIMARY KEY (task_element_id);


--
-- Name: task_milestone_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY task_milestone
    ADD CONSTRAINT task_milestone_pkey PRIMARY KEY (task_element_id);


--
-- Name: task_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY task
    ADD CONSTRAINT task_pkey PRIMARY KEY (task_element_id);


--
-- Name: task_quality_form_items_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY task_quality_form_items
    ADD CONSTRAINT task_quality_form_items_pkey PRIMARY KEY (task_quality_form_id, idx);


--
-- Name: task_quality_form_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY task_quality_form
    ADD CONSTRAINT task_quality_form_pkey PRIMARY KEY (id);


--
-- Name: task_source_hours_groups_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY task_source_hours_groups
    ADD CONSTRAINT task_source_hours_groups_pkey PRIMARY KEY (task_source_id, hours_group_id);


--
-- Name: task_source_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY task_source
    ADD CONSTRAINT task_source_pkey PRIMARY KEY (id);


--
-- Name: task_source_schedulingdata_key; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY task_source
    ADD CONSTRAINT task_source_schedulingdata_key UNIQUE (schedulingdata);


--
-- Name: task_subcontrated_task_data_id_key; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY task
    ADD CONSTRAINT task_subcontrated_task_data_id_key UNIQUE (subcontrated_task_data_id);


--
-- Name: type_of_work_hours_code_key; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY type_of_work_hours
    ADD CONSTRAINT type_of_work_hours_code_key UNIQUE (code);


--
-- Name: type_of_work_hours_name_key; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY type_of_work_hours
    ADD CONSTRAINT type_of_work_hours_name_key UNIQUE (name);


--
-- Name: type_of_work_hours_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY type_of_work_hours
    ADD CONSTRAINT type_of_work_hours_pkey PRIMARY KEY (id);


--
-- Name: unit_type_code_key; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY unit_type
    ADD CONSTRAINT unit_type_code_key UNIQUE (code);


--
-- Name: unit_type_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY unit_type
    ADD CONSTRAINT unit_type_pkey PRIMARY KEY (id);


--
-- Name: user_profiles_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY user_profiles
    ADD CONSTRAINT user_profiles_pkey PRIMARY KEY (user_id, profile_id);


--
-- Name: user_table_login_name_key; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY user_table
    ADD CONSTRAINT user_table_login_name_key UNIQUE (login_name);


--
-- Name: user_table_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY user_table
    ADD CONSTRAINT user_table_pkey PRIMARY KEY (id);


--
-- Name: virtual_worker_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY virtual_worker
    ADD CONSTRAINT virtual_worker_pkey PRIMARY KEY (virtual_worker_id);


--
-- Name: work_report_code_key; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY work_report
    ADD CONSTRAINT work_report_code_key UNIQUE (code);


--
-- Name: work_report_label_type_assigment_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY work_report_label_type_assigment
    ADD CONSTRAINT work_report_label_type_assigment_pkey PRIMARY KEY (id);


--
-- Name: work_report_line_code_key; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY work_report_line
    ADD CONSTRAINT work_report_line_code_key UNIQUE (code);


--
-- Name: work_report_line_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY work_report_line
    ADD CONSTRAINT work_report_line_pkey PRIMARY KEY (id);


--
-- Name: work_report_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY work_report
    ADD CONSTRAINT work_report_pkey PRIMARY KEY (id);


--
-- Name: work_report_type_code_key; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY work_report_type
    ADD CONSTRAINT work_report_type_code_key UNIQUE (code);


--
-- Name: work_report_type_name_key; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY work_report_type
    ADD CONSTRAINT work_report_type_name_key UNIQUE (name);


--
-- Name: work_report_type_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY work_report_type
    ADD CONSTRAINT work_report_type_pkey PRIMARY KEY (id);


--
-- Name: worker_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY worker
    ADD CONSTRAINT worker_pkey PRIMARY KEY (worker_id);


--
-- Name: workreports_labels_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY workreports_labels
    ADD CONSTRAINT workreports_labels_pkey PRIMARY KEY (work_report_id, label_id);


--
-- Name: workreportslines_labels_pkey; Type: CONSTRAINT; Schema: public; Owner: naval; Tablespace: 
--

ALTER TABLE ONLY workreportslines_labels
    ADD CONSTRAINT workreportslines_labels_pkey PRIMARY KEY (work_report_line_id, label_id);


--
-- Name: fk101a54bf87fa6b5d; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY task_quality_form_items
    ADD CONSTRAINT fk101a54bf87fa6b5d FOREIGN KEY (task_quality_form_id) REFERENCES task_quality_form(id);


--
-- Name: fk11d365279578651e; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY material
    ADD CONSTRAINT fk11d365279578651e FOREIGN KEY (category_id) REFERENCES material_category(id);


--
-- Name: fk11d36527f11b2d0; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY material
    ADD CONSTRAINT fk11d36527f11b2d0 FOREIGN KEY (unit_type) REFERENCES unit_type(id);


--
-- Name: fk16e20ea114a5c61; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY criterion
    ADD CONSTRAINT fk16e20ea114a5c61 FOREIGN KEY (id_criterion_type) REFERENCES criterion_type(id);


--
-- Name: fk16e20ea13a156175; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY criterion
    ADD CONSTRAINT fk16e20ea13a156175 FOREIGN KEY (parent) REFERENCES criterion(id);


--
-- Name: fk172a16c02f2d3aec; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY direct_advance_assignment
    ADD CONSTRAINT fk172a16c02f2d3aec FOREIGN KEY (advance_assignment_id) REFERENCES advance_assignment(id);


--
-- Name: fk172a16c0a1127ce5; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY direct_advance_assignment
    ADD CONSTRAINT fk172a16c0a1127ce5 FOREIGN KEY (direct_order_element_id) REFERENCES order_element(id);


--
-- Name: fk1e6bf5475c390c4; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY description_values_in_line
    ADD CONSTRAINT fk1e6bf5475c390c4 FOREIGN KEY (description_value_id) REFERENCES work_report_line(id);


--
-- Name: fk1fc5f45575ed79ba; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY limiting_resource_queue_element
    ADD CONSTRAINT fk1fc5f45575ed79ba FOREIGN KEY (resource_allocation_id) REFERENCES resource_allocation(id);


--
-- Name: fk1fc5f455bd2209e8; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY limiting_resource_queue_element
    ADD CONSTRAINT fk1fc5f455bd2209e8 FOREIGN KEY (limiting_resource_queue_id) REFERENCES limiting_resource_queue(id);


--
-- Name: fk225ff96a8c4c676c; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY criterion_satisfaction
    ADD CONSTRAINT fk225ff96a8c4c676c FOREIGN KEY (criterion) REFERENCES criterion(id);


--
-- Name: fk225ff96aeae850b2; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY criterion_satisfaction
    ADD CONSTRAINT fk225ff96aeae850b2 FOREIGN KEY (resource) REFERENCES resource(id);


--
-- Name: fk27c2a21648d21790; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY resources_cost_category_assignment
    ADD CONSTRAINT fk27c2a21648d21790 FOREIGN KEY (resource_id) REFERENCES resource(id);


--
-- Name: fk27c2a216c29ad8eb; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY resources_cost_category_assignment
    ADD CONSTRAINT fk27c2a216c29ad8eb FOREIGN KEY (cost_category_id) REFERENCES cost_category(id);


--
-- Name: fk2908787d415884f6; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY heading_field
    ADD CONSTRAINT fk2908787d415884f6 FOREIGN KEY (heading_id) REFERENCES work_report_type(id);


--
-- Name: fk2d124245efda874f; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY order_line
    ADD CONSTRAINT fk2d124245efda874f FOREIGN KEY (order_element_id) REFERENCES order_element(id);


--
-- Name: fk2e7e6bcc5567ad13; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY roles_table
    ADD CONSTRAINT fk2e7e6bcc5567ad13 FOREIGN KEY (user_id) REFERENCES user_table(id);


--
-- Name: fk31314447937680b7; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY machine
    ADD CONSTRAINT fk31314447937680b7 FOREIGN KEY (machine_id) REFERENCES resource(id);


--
-- Name: fk3525435419b9dfde; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY material_assigment_template
    ADD CONSTRAINT fk3525435419b9dfde FOREIGN KEY (order_element_template_id) REFERENCES order_element_template(id);


--
-- Name: fk35254354b5c68337; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY material_assigment_template
    ADD CONSTRAINT fk35254354b5c68337 FOREIGN KEY (material_id) REFERENCES material(id);


--
-- Name: fk35588e2d3ae24ff8; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY consolidated_value
    ADD CONSTRAINT fk35588e2d3ae24ff8 FOREIGN KEY (consolidation_id) REFERENCES consolidation(id);


--
-- Name: fk35588e2db96bba28; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY consolidated_value
    ADD CONSTRAINT fk35588e2db96bba28 FOREIGN KEY (advance_measurement_id) REFERENCES advance_measurement(id);


--
-- Name: fk35bc4ed63804cfa; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY subcontracted_task_data
    ADD CONSTRAINT fk35bc4ed63804cfa FOREIGN KEY (external_company) REFERENCES external_company(id);


--
-- Name: fk3635854936bb8c; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY task
    ADD CONSTRAINT fk3635854936bb8c FOREIGN KEY (task_element_id) REFERENCES task_element(id);


--
-- Name: fk3635855b595a0; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY task
    ADD CONSTRAINT fk3635855b595a0 FOREIGN KEY (subcontrated_task_data_id) REFERENCES subcontracted_task_data(id);


--
-- Name: fk3b9a8148c29ad8eb; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY hour_cost
    ADD CONSTRAINT fk3b9a8148c29ad8eb FOREIGN KEY (cost_category_id) REFERENCES cost_category(id);


--
-- Name: fk3b9a8148d5b6184d; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY hour_cost
    ADD CONSTRAINT fk3b9a8148d5b6184d FOREIGN KEY (type_of_work_hours_id) REFERENCES type_of_work_hours(id);


--
-- Name: fk4339b2e41638aab; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY order_element_template
    ADD CONSTRAINT fk4339b2e41638aab FOREIGN KEY (parent) REFERENCES order_line_group_template(group_template_id);


--
-- Name: fk4356e07e8b37665c; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY task_quality_form
    ADD CONSTRAINT fk4356e07e8b37665c FOREIGN KEY (quality_form_id) REFERENCES quality_form(id);


--
-- Name: fk4356e07eefda874f; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY task_quality_form
    ADD CONSTRAINT fk4356e07eefda874f FOREIGN KEY (order_element_id) REFERENCES order_element(id);


--
-- Name: fk4949f0241a5e11f8; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY stretches_function
    ADD CONSTRAINT fk4949f0241a5e11f8 FOREIGN KEY (assignment_function_id) REFERENCES assignment_function(id);


--
-- Name: fk4d9497454936bb8c; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY task_group
    ADD CONSTRAINT fk4d9497454936bb8c FOREIGN KEY (task_element_id) REFERENCES task_element(id);


--
-- Name: fk557738bca44abee3; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY calendar_availability
    ADD CONSTRAINT fk557738bca44abee3 FOREIGN KEY (base_calendar_id) REFERENCES base_calendar(id);


--
-- Name: fk5948535228f2695; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY limiting_resource_queue_dependency
    ADD CONSTRAINT fk5948535228f2695 FOREIGN KEY (origin_queue_element_id) REFERENCES limiting_resource_queue_element(id);


--
-- Name: fk59485352e42f8d29; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY limiting_resource_queue_dependency
    ADD CONSTRAINT fk59485352e42f8d29 FOREIGN KEY (destiny_queue_element_id) REFERENCES limiting_resource_queue_element(id);


--
-- Name: fk616de2a319b9dfde; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY order_element_template_label
    ADD CONSTRAINT fk616de2a319b9dfde FOREIGN KEY (order_element_template_id) REFERENCES order_element_template(id);


--
-- Name: fk616de2a3c1c2746e; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY order_element_template_label
    ADD CONSTRAINT fk616de2a3c1c2746e FOREIGN KEY (label_id) REFERENCES label(id);


--
-- Name: fk61f7ef4707cd777; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY label
    ADD CONSTRAINT fk61f7ef4707cd777 FOREIGN KEY (label_type_id) REFERENCES label_type(id);


--
-- Name: fk6476ce4b9a4a7d90; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY order_template
    ADD CONSTRAINT fk6476ce4b9a4a7d90 FOREIGN KEY (order_template_id) REFERENCES order_line_group_template(group_template_id);


--
-- Name: fk6476ce4ba44abee3; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY order_template
    ADD CONSTRAINT fk6476ce4ba44abee3 FOREIGN KEY (base_calendar_id) REFERENCES base_calendar(id);


--
-- Name: fk64cbad3b218d7620; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY indirect_advance_assignment
    ADD CONSTRAINT fk64cbad3b218d7620 FOREIGN KEY (indirect_order_element_id) REFERENCES order_element(id);


--
-- Name: fk64cbad3b2f2d3aec; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY indirect_advance_assignment
    ADD CONSTRAINT fk64cbad3b2f2d3aec FOREIGN KEY (advance_assignment_id) REFERENCES advance_assignment(id);


--
-- Name: fk64cbad3b8202350f; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY indirect_advance_assignment
    ADD CONSTRAINT fk64cbad3b8202350f FOREIGN KEY (indirect_order_element_id) REFERENCES order_line_group(order_element_id);


--
-- Name: fk672eed98efda874f; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY scheduling_data_for_version
    ADD CONSTRAINT fk672eed98efda874f FOREIGN KEY (order_element_id) REFERENCES order_element(id);


--
-- Name: fk733374f6cc119699; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY configuration
    ADD CONSTRAINT fk733374f6cc119699 FOREIGN KEY (configuration_id) REFERENCES base_calendar(id);


--
-- Name: fk7358465a4cd98327; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY user_table
    ADD CONSTRAINT fk7358465a4cd98327 FOREIGN KEY (lastconnectedscenario) REFERENCES scenario(id);


--
-- Name: fk74fc040b7fa34e3f; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY calendar_data
    ADD CONSTRAINT fk74fc040b7fa34e3f FOREIGN KEY (parent) REFERENCES base_calendar(id);


--
-- Name: fk74fc040ba44abee3; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY calendar_data
    ADD CONSTRAINT fk74fc040ba44abee3 FOREIGN KEY (base_calendar_id) REFERENCES base_calendar(id);


--
-- Name: fk75a2f39d4ec080cf; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY order_table
    ADD CONSTRAINT fk75a2f39d4ec080cf FOREIGN KEY (customer) REFERENCES external_company(id);


--
-- Name: fk75a2f39d504f463e; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY order_table
    ADD CONSTRAINT fk75a2f39d504f463e FOREIGN KEY (order_element_id) REFERENCES order_line_group(order_element_id);


--
-- Name: fk75a2f39da44abee3; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY order_table
    ADD CONSTRAINT fk75a2f39da44abee3 FOREIGN KEY (base_calendar_id) REFERENCES base_calendar(id);


--
-- Name: fk7950e0153d72bc6f; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY task_source
    ADD CONSTRAINT fk7950e0153d72bc6f FOREIGN KEY (id) REFERENCES task_element(id);


--
-- Name: fk7950e0159a2c0abd; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY task_source
    ADD CONSTRAINT fk7950e0159a2c0abd FOREIGN KEY (schedulingdata) REFERENCES scheduling_data_for_version(id);


--
-- Name: fk7980035061f02c44; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY all_criterions
    ADD CONSTRAINT fk7980035061f02c44 FOREIGN KEY (criterion_id) REFERENCES criterion(id);


--
-- Name: fk79800350b1524a73; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY all_criterions
    ADD CONSTRAINT fk79800350b1524a73 FOREIGN KEY (generic_resource_allocation_id) REFERENCES generic_resource_allocation(resource_allocation_id);


--
-- Name: fk7d1ee2c5fec79eb0; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY description_values
    ADD CONSTRAINT fk7d1ee2c5fec79eb0 FOREIGN KEY (description_value_id) REFERENCES work_report(id);


--
-- Name: fk7e57469848d21790; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY limiting_resource_queue
    ADD CONSTRAINT fk7e57469848d21790 FOREIGN KEY (resource_id) REFERENCES resource(id);


--
-- Name: fk84c66516b53669f2; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY material_category
    ADD CONSTRAINT fk84c66516b53669f2 FOREIGN KEY (parent_id) REFERENCES material_category(id);


--
-- Name: fk84f61df123b85cf1; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY scheduling_states_by_order_version
    ADD CONSTRAINT fk84f61df123b85cf1 FOREIGN KEY (order_version_id) REFERENCES order_version(id);


--
-- Name: fk84f61df19bfe55d0; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY scheduling_states_by_order_version
    ADD CONSTRAINT fk84f61df19bfe55d0 FOREIGN KEY (scheduling_state_for_version_id) REFERENCES scheduling_data_for_version(id);


--
-- Name: fk84f61df1efda874f; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY scheduling_states_by_order_version
    ADD CONSTRAINT fk84f61df1efda874f FOREIGN KEY (order_element_id) REFERENCES order_element(id);


--
-- Name: fk88eecef415884f6; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY line_field
    ADD CONSTRAINT fk88eecef415884f6 FOREIGN KEY (heading_id) REFERENCES work_report_type(id);


--
-- Name: fk91bbca7423b85cf1; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY scenario_orders
    ADD CONSTRAINT fk91bbca7423b85cf1 FOREIGN KEY (order_version_id) REFERENCES order_version(id);


--
-- Name: fk91bbca7487287288; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY scenario_orders
    ADD CONSTRAINT fk91bbca7487287288 FOREIGN KEY (order_id) REFERENCES order_table(order_element_id);


--
-- Name: fk91bbca74c0fb9d8e; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY scenario_orders
    ADD CONSTRAINT fk91bbca74c0fb9d8e FOREIGN KEY (scenario_id) REFERENCES scenario(id);


--
-- Name: fk92271f0b1e635c19; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY order_element
    ADD CONSTRAINT fk92271f0b1e635c19 FOREIGN KEY (parent) REFERENCES order_line_group(order_element_id);


--
-- Name: fk92271f0b7ec17fa6; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY order_element
    ADD CONSTRAINT fk92271f0b7ec17fa6 FOREIGN KEY (sum_charged_hours_id) REFERENCES sum_charged_hours(id);


--
-- Name: fk92271f0bd97bcc8c; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY order_element
    ADD CONSTRAINT fk92271f0bd97bcc8c FOREIGN KEY (template) REFERENCES order_element_template(id);


--
-- Name: fk95548d7861f02c44; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY machine_configuration_unit_required_criterions
    ADD CONSTRAINT fk95548d7861f02c44 FOREIGN KEY (criterion_id) REFERENCES criterion(id);


--
-- Name: fk95548d7875999a91; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY machine_configuration_unit_required_criterions
    ADD CONSTRAINT fk95548d7875999a91 FOREIGN KEY (id) REFERENCES machine_workers_configuration_unit(id);


--
-- Name: fk9619184fa44abee3; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY resource_calendar
    ADD CONSTRAINT fk9619184fa44abee3 FOREIGN KEY (base_calendar_id) REFERENCES base_calendar(id);


--
-- Name: fk9c819f74ddc82952; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY order_line_group_template
    ADD CONSTRAINT fk9c819f74ddc82952 FOREIGN KEY (group_template_id) REFERENCES order_element_template(id);


--
-- Name: fka01fe4ee8c80ccb7; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY task_source_hours_groups
    ADD CONSTRAINT fka01fe4ee8c80ccb7 FOREIGN KEY (task_source_id) REFERENCES task_source(id);


--
-- Name: fka01fe4eee036cfed; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY task_source_hours_groups
    ADD CONSTRAINT fka01fe4eee036cfed FOREIGN KEY (hours_group_id) REFERENCES hours_group(id);


--
-- Name: fka215508ea44abee3; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY calendar_exception
    ADD CONSTRAINT fka215508ea44abee3 FOREIGN KEY (base_calendar_id) REFERENCES base_calendar(id);


--
-- Name: fka215508eadad7e51; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY calendar_exception
    ADD CONSTRAINT fka215508eadad7e51 FOREIGN KEY (calendar_exception_id) REFERENCES calendar_exception_type(id);


--
-- Name: fka2c1583686b2de7a; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY machine_worker_assignment
    ADD CONSTRAINT fka2c1583686b2de7a FOREIGN KEY (configuration_id) REFERENCES machine_workers_configuration_unit(id);


--
-- Name: fka2c158369bebcf10; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY machine_worker_assignment
    ADD CONSTRAINT fka2c158369bebcf10 FOREIGN KEY (worker_id) REFERENCES worker(worker_id);


--
-- Name: fka391ce7a2380ca7; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY order_version
    ADD CONSTRAINT fka391ce7a2380ca7 FOREIGN KEY (ownerscenario) REFERENCES scenario(id);


--
-- Name: fkad6003c58b37665c; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY quality_form_items
    ADD CONSTRAINT fkad6003c58b37665c FOREIGN KEY (quality_form_id) REFERENCES quality_form(id);


--
-- Name: fkb3e9425b5c68337; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY material_assigment
    ADD CONSTRAINT fkb3e9425b5c68337 FOREIGN KEY (material_id) REFERENCES material(id);


--
-- Name: fkb3e9425efda874f; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY material_assigment
    ADD CONSTRAINT fkb3e9425efda874f FOREIGN KEY (order_element_id) REFERENCES order_element(id);


--
-- Name: fkb83176c31b8e7cf2; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY derived_day_assignments_container
    ADD CONSTRAINT fkb83176c31b8e7cf2 FOREIGN KEY (derived_allocation_id) REFERENCES derived_allocation(id);


--
-- Name: fkb83176c3421c7cf4; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY derived_day_assignments_container
    ADD CONSTRAINT fkb83176c3421c7cf4 FOREIGN KEY (scenario) REFERENCES scenario(id);


--
-- Name: fkb92b59485567ad13; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY order_authorization
    ADD CONSTRAINT fkb92b59485567ad13 FOREIGN KEY (user_id) REFERENCES user_table(id);


--
-- Name: fkb92b594887287288; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY order_authorization
    ADD CONSTRAINT fkb92b594887287288 FOREIGN KEY (order_id) REFERENCES order_table(order_element_id);


--
-- Name: fkb92b5948edc4db41; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY order_authorization
    ADD CONSTRAINT fkb92b5948edc4db41 FOREIGN KEY (profile_id) REFERENCES profile_table(id);


--
-- Name: fkbb262920131853a1; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY work_report_label_type_assigment
    ADD CONSTRAINT fkbb262920131853a1 FOREIGN KEY (work_report_type_id) REFERENCES work_report_type(id);


--
-- Name: fkbb262920707cd777; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY work_report_label_type_assigment
    ADD CONSTRAINT fkbb262920707cd777 FOREIGN KEY (label_type_id) REFERENCES label_type(id);


--
-- Name: fkbb262920c1c2746e; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY work_report_label_type_assigment
    ADD CONSTRAINT fkbb262920c1c2746e FOREIGN KEY (label_id) REFERENCES label(id);


--
-- Name: fkbb493f5019256004; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY day_assignment
    ADD CONSTRAINT fkbb493f5019256004 FOREIGN KEY (generic_container_id) REFERENCES generic_day_assignments_container(id);


--
-- Name: fkbb493f5048d21790; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY day_assignment
    ADD CONSTRAINT fkbb493f5048d21790 FOREIGN KEY (resource_id) REFERENCES resource(id);


--
-- Name: fkbb493f50510e7a78; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY day_assignment
    ADD CONSTRAINT fkbb493f50510e7a78 FOREIGN KEY (derived_container_id) REFERENCES derived_day_assignments_container(id);


--
-- Name: fkbb493f50756348a8; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY day_assignment
    ADD CONSTRAINT fkbb493f50756348a8 FOREIGN KEY (specific_container_id) REFERENCES specific_day_assignments_container(id);


--
-- Name: fkbb58534c6ccf87c5; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY planning_data
    ADD CONSTRAINT fkbb58534c6ccf87c5 FOREIGN KEY (planning_data_id) REFERENCES task_group(task_element_id);


--
-- Name: fkc01655fd421c7cf4; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY generic_day_assignments_container
    ADD CONSTRAINT fkc01655fd421c7cf4 FOREIGN KEY (scenario) REFERENCES scenario(id);


--
-- Name: fkc01655fdee970b; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY generic_day_assignments_container
    ADD CONSTRAINT fkc01655fdee970b FOREIGN KEY (resource_allocation_id) REFERENCES generic_resource_allocation(resource_allocation_id);


--
-- Name: fkc405554bfd5e49bc; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY capacity_per_day
    ADD CONSTRAINT fkc405554bfd5e49bc FOREIGN KEY (base_calendar_id) REFERENCES calendar_data(id);


--
-- Name: fkc631a642a44abee3; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY task_element
    ADD CONSTRAINT fkc631a642a44abee3 FOREIGN KEY (base_calendar_id) REFERENCES base_calendar(id);


--
-- Name: fkc631a642a5f3c581; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY task_element
    ADD CONSTRAINT fkc631a642a5f3c581 FOREIGN KEY (parent) REFERENCES task_group(task_element_id);


--
-- Name: fkc74605de5567ad13; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY user_profiles
    ADD CONSTRAINT fkc74605de5567ad13 FOREIGN KEY (user_id) REFERENCES user_table(id);


--
-- Name: fkc74605deedc4db41; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY user_profiles
    ADD CONSTRAINT fkc74605deedc4db41 FOREIGN KEY (profile_id) REFERENCES profile_table(id);


--
-- Name: fkc9400e2c430ea1de; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY consolidation
    ADD CONSTRAINT fkc9400e2c430ea1de FOREIGN KEY (ind_advance_assignment_id) REFERENCES indirect_advance_assignment(advance_assignment_id);


--
-- Name: fkc9400e2c9f1d6611; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY consolidation
    ADD CONSTRAINT fkc9400e2c9f1d6611 FOREIGN KEY (dir_advance_assignment_id) REFERENCES direct_advance_assignment(advance_assignment_id);


--
-- Name: fkc9400e2cff2b2ba3; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY consolidation
    ADD CONSTRAINT fkc9400e2cff2b2ba3 FOREIGN KEY (id) REFERENCES task(task_element_id);


--
-- Name: fkc9c3fe691a5e11f8; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY sigmoid_function
    ADD CONSTRAINT fkc9c3fe691a5e11f8 FOREIGN KEY (assignment_function_id) REFERENCES assignment_function(id);


--
-- Name: fkcb8fc1cd5078e161; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY workreportslines_labels
    ADD CONSTRAINT fkcb8fc1cd5078e161 FOREIGN KEY (work_report_line_id) REFERENCES work_report_line(id);


--
-- Name: fkcb8fc1cdc1c2746e; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY workreportslines_labels
    ADD CONSTRAINT fkcb8fc1cdc1c2746e FOREIGN KEY (label_id) REFERENCES label(id);


--
-- Name: fkcee46998421c7cf4; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY specific_day_assignments_container
    ADD CONSTRAINT fkcee46998421c7cf4 FOREIGN KEY (scenario) REFERENCES scenario(id);


--
-- Name: fkcee469987518838c; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY specific_day_assignments_container
    ADD CONSTRAINT fkcee469987518838c FOREIGN KEY (resource_allocation_id) REFERENCES specific_resource_allocation(resource_allocation_id);


--
-- Name: fkd04de7364936bb8c; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY task_milestone
    ADD CONSTRAINT fkd04de7364936bb8c FOREIGN KEY (task_element_id) REFERENCES task_element(id);


--
-- Name: fkd162537e40901220; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY worker
    ADD CONSTRAINT fkd162537e40901220 FOREIGN KEY (worker_id) REFERENCES resource(id);


--
-- Name: fkd1c57390fd99606d; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY scenario
    ADD CONSTRAINT fkd1c57390fd99606d FOREIGN KEY (predecessor) REFERENCES scenario(id);


--
-- Name: fkd4192eaab216ed4c; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY advance_assignment
    ADD CONSTRAINT fkd4192eaab216ed4c FOREIGN KEY (advance_type_id) REFERENCES advance_type(id);


--
-- Name: fkd47281efffeb5538; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY machine_workers_configuration_unit
    ADD CONSTRAINT fkd47281efffeb5538 FOREIGN KEY (machine) REFERENCES machine(machine_id);


--
-- Name: fkd557d8a7edc4db41; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY profile_roles
    ADD CONSTRAINT fkd557d8a7edc4db41 FOREIGN KEY (profile_id) REFERENCES profile_table(id);


--
-- Name: fkd8e14c09b36a6d51; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY external_company
    ADD CONSTRAINT fkd8e14c09b36a6d51 FOREIGN KEY (company_user) REFERENCES user_table(id);


--
-- Name: fkd9b7594f1ed629ea; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY hours_group
    ADD CONSTRAINT fkd9b7594f1ed629ea FOREIGN KEY (parent_order_line) REFERENCES order_line(order_element_id);


--
-- Name: fkd9b7594f8bdc6ac6; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY hours_group
    ADD CONSTRAINT fkd9b7594f8bdc6ac6 FOREIGN KEY (order_line_template) REFERENCES order_line_template(order_line_template_id);


--
-- Name: fkd9bfae6f19b9dfde; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY advance_assignment_template
    ADD CONSTRAINT fkd9bfae6f19b9dfde FOREIGN KEY (order_element_template_id) REFERENCES order_element_template(id);


--
-- Name: fkd9bfae6fb216ed4c; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY advance_assignment_template
    ADD CONSTRAINT fkd9bfae6fb216ed4c FOREIGN KEY (advance_type_id) REFERENCES advance_type(id);


--
-- Name: fkdaba2f7f2f2d3aec; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY advance_measurement
    ADD CONSTRAINT fkdaba2f7f2f2d3aec FOREIGN KEY (advance_assignment_id) REFERENCES advance_assignment(id);


--
-- Name: fkdaba2f7fa9e53843; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY advance_measurement
    ADD CONSTRAINT fkdaba2f7fa9e53843 FOREIGN KEY (advance_assignment_id) REFERENCES direct_advance_assignment(advance_assignment_id);


--
-- Name: fkdce41405efda874f; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY order_line_group
    ADD CONSTRAINT fkdce41405efda874f FOREIGN KEY (order_element_id) REFERENCES order_element(id);


--
-- Name: fke2af47f148d21790; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY work_report_line
    ADD CONSTRAINT fke2af47f148d21790 FOREIGN KEY (resource_id) REFERENCES resource(id);


--
-- Name: fke2af47f1e7e1020b; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY work_report_line
    ADD CONSTRAINT fke2af47f1e7e1020b FOREIGN KEY (type_work_hours_id) REFERENCES type_of_work_hours(id);


--
-- Name: fke2af47f1efda874f; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY work_report_line
    ADD CONSTRAINT fke2af47f1efda874f FOREIGN KEY (order_element_id) REFERENCES order_element(id);


--
-- Name: fke2af47f1f1a3177c; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY work_report_line
    ADD CONSTRAINT fke2af47f1f1a3177c FOREIGN KEY (work_report_id) REFERENCES work_report(id);


--
-- Name: fke4c379349fb7fc18; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY order_line_template
    ADD CONSTRAINT fke4c379349fb7fc18 FOREIGN KEY (order_line_template_id) REFERENCES order_element_template(id);


--
-- Name: fke8344cc0c1c2746e; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY order_element_label
    ADD CONSTRAINT fke8344cc0c1c2746e FOREIGN KEY (label_id) REFERENCES label(id);


--
-- Name: fke8344cc0efda874f; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY order_element_label
    ADD CONSTRAINT fke8344cc0efda874f FOREIGN KEY (order_element_id) REFERENCES order_element(id);


--
-- Name: fke8a96db115671e92; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY resource_allocation
    ADD CONSTRAINT fke8a96db115671e92 FOREIGN KEY (assignment_function) REFERENCES assignment_function(id);


--
-- Name: fke8a96db1ff61540d; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY resource_allocation
    ADD CONSTRAINT fke8a96db1ff61540d FOREIGN KEY (task) REFERENCES task(task_element_id);


--
-- Name: fkebabc40edc874c20; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY resource
    ADD CONSTRAINT fkebabc40edc874c20 FOREIGN KEY (base_calendar_id) REFERENCES resource_calendar(base_calendar_id);


--
-- Name: fkee053f32f2ed6dc; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY virtual_worker
    ADD CONSTRAINT fkee053f32f2ed6dc FOREIGN KEY (virtual_worker_id) REFERENCES worker(worker_id);


--
-- Name: fkee374673ae0677b8; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY stretches
    ADD CONSTRAINT fkee374673ae0677b8 FOREIGN KEY (assignment_function_id) REFERENCES stretches_function(assignment_function_id);


--
-- Name: fkef395fa519b9dfde; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY criterion_requirement
    ADD CONSTRAINT fkef395fa519b9dfde FOREIGN KEY (order_element_template_id) REFERENCES order_element_template(id);


--
-- Name: fkef395fa561f02c44; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY criterion_requirement
    ADD CONSTRAINT fkef395fa561f02c44 FOREIGN KEY (criterion_id) REFERENCES criterion(id);


--
-- Name: fkef395fa5e036cfed; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY criterion_requirement
    ADD CONSTRAINT fkef395fa5e036cfed FOREIGN KEY (hours_group_id) REFERENCES hours_group(id);


--
-- Name: fkef395fa5efda874f; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY criterion_requirement
    ADD CONSTRAINT fkef395fa5efda874f FOREIGN KEY (order_element_id) REFERENCES order_element(id);


--
-- Name: fkef395fa5f41d57f2; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY criterion_requirement
    ADD CONSTRAINT fkef395fa5f41d57f2 FOREIGN KEY (parent) REFERENCES criterion_requirement(id);


--
-- Name: fkf0260c4275ed79ba; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY derived_allocation
    ADD CONSTRAINT fkf0260c4275ed79ba FOREIGN KEY (resource_allocation_id) REFERENCES resource_allocation(id);


--
-- Name: fkf0260c4287b470f0; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY derived_allocation
    ADD CONSTRAINT fkf0260c4287b470f0 FOREIGN KEY (configurationunit) REFERENCES machine_workers_configuration_unit(id);


--
-- Name: fkf0e8572475ed79ba; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY specific_resource_allocation
    ADD CONSTRAINT fkf0e8572475ed79ba FOREIGN KEY (resource_allocation_id) REFERENCES resource_allocation(id);


--
-- Name: fkf0e85724eae850b2; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY specific_resource_allocation
    ADD CONSTRAINT fkf0e85724eae850b2 FOREIGN KEY (resource) REFERENCES resource(id);


--
-- Name: fkf635cc04b216ed4c; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY quality_form
    ADD CONSTRAINT fkf635cc04b216ed4c FOREIGN KEY (advance_type_id) REFERENCES advance_type(id);


--
-- Name: fkf788b34975ed79ba; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY generic_resource_allocation
    ADD CONSTRAINT fkf788b34975ed79ba FOREIGN KEY (resource_allocation_id) REFERENCES resource_allocation(id);


--
-- Name: fkf796fbd0c1c2746e; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY workreports_labels
    ADD CONSTRAINT fkf796fbd0c1c2746e FOREIGN KEY (label_id) REFERENCES label(id);


--
-- Name: fkf796fbd0f1a3177c; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY workreports_labels
    ADD CONSTRAINT fkf796fbd0f1a3177c FOREIGN KEY (work_report_id) REFERENCES work_report(id);


--
-- Name: fkfd7aa62248d21790; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY work_report
    ADD CONSTRAINT fkfd7aa62248d21790 FOREIGN KEY (resource_id) REFERENCES resource(id);


--
-- Name: fkfd7aa62278e4e2ea; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY work_report
    ADD CONSTRAINT fkfd7aa62278e4e2ea FOREIGN KEY (ork_report_type_id) REFERENCES work_report_type(id);


--
-- Name: fkfd7aa622efda874f; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY work_report
    ADD CONSTRAINT fkfd7aa622efda874f FOREIGN KEY (order_element_id) REFERENCES order_element(id);


--
-- Name: fkfe6ed34b1545e7a; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY dependency
    ADD CONSTRAINT fkfe6ed34b1545e7a FOREIGN KEY (origin) REFERENCES task_element(id);


--
-- Name: fkfe6ed34b9e788f90; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY dependency
    ADD CONSTRAINT fkfe6ed34b9e788f90 FOREIGN KEY (queue_dependency) REFERENCES limiting_resource_queue_dependency(id);


--
-- Name: fkfe6ed34be838f362; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY dependency
    ADD CONSTRAINT fkfe6ed34be838f362 FOREIGN KEY (destination) REFERENCES task_element(id);


--
-- Name: fkfe6fb57519b9dfde; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY order_element_template_quality_form
    ADD CONSTRAINT fkfe6fb57519b9dfde FOREIGN KEY (order_element_template_id) REFERENCES order_element_template(id);


--
-- Name: fkfe6fb5758b37665c; Type: FK CONSTRAINT; Schema: public; Owner: naval
--

ALTER TABLE ONLY order_element_template_quality_form
    ADD CONSTRAINT fkfe6fb5758b37665c FOREIGN KEY (quality_form_id) REFERENCES quality_form(id);


--
-- Name: public; Type: ACL; Schema: -; Owner: postgres
--

REVOKE ALL ON SCHEMA public FROM PUBLIC;
REVOKE ALL ON SCHEMA public FROM postgres;
GRANT ALL ON SCHEMA public TO postgres;
GRANT ALL ON SCHEMA public TO PUBLIC;


--
-- PostgreSQL database dump complete
--