-- PostgreSQL database dump
--
+SET statement_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = off;
SET check_function_bodies = false;
--
CREATE SEQUENCE fleet_id_seq
+ START WITH 1
INCREMENT BY 1
NO MAXVALUE
NO MINVALUE
--
CREATE SEQUENCE fleet_user_id_seq
+ START WITH 1
INCREMENT BY 1
NO MAXVALUE
NO MINVALUE
--
CREATE SEQUENCE fleet_vessel_id_seq
+ START WITH 1
INCREMENT BY 1
NO MAXVALUE
NO MINVALUE
CREATE TABLE job (
id character(8) NOT NULL,
user_id integer,
- queue_time timestamp without time zone DEFAULT now() NOT NULL,
+ queue_time timestamp without time zone DEFAULT timezone('GMT'::text, now()) NOT NULL,
start_time timestamp without time zone,
finish_time timestamp without time zone,
command text NOT NULL,
--
CREATE SEQUENCE mi_mmsi_i_seq
+ START WITH 1
INCREMENT BY 1
NO MAXVALUE
NO MINVALUE
--
CREATE SEQUENCE mi_source_id_seq
+ START WITH 1
INCREMENT BY 1
NO MAXVALUE
NO MINVALUE
--
CREATE SEQUENCE news_id_seq
+ START WITH 1
INCREMENT BY 1
NO MAXVALUE
NO MINVALUE
father_id integer,
creation_datetime timestamp without time zone DEFAULT now() NOT NULL,
phone character varying(20) DEFAULT ''::character varying NOT NULL,
- access_datetime timestamp without time zone
+ access_datetime timestamp without time zone,
+ flag_allowhidden boolean DEFAULT false NOT NULL
);
--
CREATE SEQUENCE user_id_seq
+ START WITH 1
INCREMENT BY 1
NO MAXVALUE
NO MINVALUE
--
CREATE SEQUENCE user_message_id_seq
+ START WITH 1
INCREMENT BY 1
NO MAXVALUE
NO MINVALUE
);
+SET default_with_oids = true;
+
+--
+-- Name: vessel_extra_data; Type: TABLE; Schema: public; Owner: -; Tablespace:
+--
+
+CREATE TABLE vessel_extra_data (
+ mmsi integer NOT NULL,
+ vessel_extra_field_id integer NOT NULL,
+ datetime timestamp without time zone DEFAULT now() NOT NULL,
+ value text NOT NULL
+);
+
+
+SET default_with_oids = false;
+
+--
+-- Name: vessel_extra_field; Type: TABLE; Schema: public; Owner: -; Tablespace:
+--
+
+CREATE TABLE vessel_extra_field (
+ id integer NOT NULL,
+ name character varying(64) NOT NULL
+);
+
+
+--
+-- Name: vessel_extra_field_id_seq; Type: SEQUENCE; Schema: public; Owner: -
+--
+
+CREATE SEQUENCE vessel_extra_field_id_seq
+ START WITH 1
+ INCREMENT BY 1
+ NO MAXVALUE
+ NO MINVALUE
+ CACHE 1;
+
+
+--
+-- Name: vessel_extra_field_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
+--
+
+ALTER SEQUENCE vessel_extra_field_id_seq OWNED BY vessel_extra_field.id;
+
+
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: -
--
-ALTER TABLE fleet ALTER COLUMN id SET DEFAULT nextval('fleet_id_seq'::regclass);
+ALTER TABLE ONLY fleet ALTER COLUMN id SET DEFAULT nextval('fleet_id_seq'::regclass);
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: -
--
-ALTER TABLE fleet_user ALTER COLUMN id SET DEFAULT nextval('fleet_user_id_seq'::regclass);
+ALTER TABLE ONLY fleet_user ALTER COLUMN id SET DEFAULT nextval('fleet_user_id_seq'::regclass);
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: -
--
-ALTER TABLE fleet_vessel ALTER COLUMN id SET DEFAULT nextval('fleet_vessel_id_seq'::regclass);
+ALTER TABLE ONLY fleet_vessel ALTER COLUMN id SET DEFAULT nextval('fleet_vessel_id_seq'::regclass);
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: -
--
-ALTER TABLE mi_source ALTER COLUMN id SET DEFAULT nextval('mi_source_id_seq'::regclass);
+ALTER TABLE ONLY mi_source ALTER COLUMN id SET DEFAULT nextval('mi_source_id_seq'::regclass);
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: -
--
-ALTER TABLE news ALTER COLUMN id SET DEFAULT nextval('news_id_seq'::regclass);
+ALTER TABLE ONLY news ALTER COLUMN id SET DEFAULT nextval('news_id_seq'::regclass);
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: -
--
-ALTER TABLE "user" ALTER COLUMN id SET DEFAULT nextval('user_id_seq'::regclass);
+ALTER TABLE ONLY "user" ALTER COLUMN id SET DEFAULT nextval('user_id_seq'::regclass);
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: -
--
-ALTER TABLE user_message ALTER COLUMN id SET DEFAULT nextval('user_message_id_seq'::regclass);
+ALTER TABLE ONLY user_message ALTER COLUMN id SET DEFAULT nextval('user_message_id_seq'::regclass);
+
+
+--
+-- Name: id; Type: DEFAULT; Schema: public; Owner: -
+--
+
+ALTER TABLE ONLY vessel_extra_field ALTER COLUMN id SET DEFAULT nextval('vessel_extra_field_id_seq'::regclass);
--
ADD CONSTRAINT user_pkey PRIMARY KEY (id);
+--
+-- Name: vessel_extra_field_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+--
+
+ALTER TABLE ONLY vessel_extra_field
+ ADD CONSTRAINT vessel_extra_field_pkey PRIMARY KEY (id);
+
+
--
-- Name: vessel_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
--
ADD CONSTRAINT user_message_user_message_category_id_fkey FOREIGN KEY (user_message_category_id) REFERENCES user_message_category(id) ON UPDATE CASCADE ON DELETE CASCADE;
+--
+-- Name: vessel_extra_data_mmsi_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
+--
+
+ALTER TABLE ONLY vessel_extra_data
+ ADD CONSTRAINT vessel_extra_data_mmsi_fkey FOREIGN KEY (mmsi) REFERENCES vessel(mmsi) ON UPDATE CASCADE ON DELETE CASCADE;
+
+
+--
+-- Name: vessel_extra_data_vessel_extra_field_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
+--
+
+ALTER TABLE ONLY vessel_extra_data
+ ADD CONSTRAINT vessel_extra_data_vessel_extra_field_id_fkey FOREIGN KEY (vessel_extra_field_id) REFERENCES vessel_extra_field(id) ON UPDATE CASCADE ON DELETE CASCADE;
+
+
--
-- PostgreSQL database dump complete
--