DROP TABLE IF EXISTS tourisme;

CREATE TABLE tourisme (
    ogc_fid integer NOT NULL,
    id character varying,
    id_sitra1 character varying,
    type character varying,
    type_detail character varying,
    nom character varying,
    adresse character varying,
    codepostal character varying,
    commune character varying,
    telephone character varying,
    fax character varying,
    telephonefax character varying,
    email character varying,
    siteweb character varying,
    facebook character varying,
    classement character varying,
    ouverture character varying,
    tarifsenclair character varying,
    tarifsmin character varying,
    tarifsmax character varying,
    producteur character varying,
    gid character varying,
    date_creation timestamp with time zone,
    last_update timestamp with time zone,
    last_update_fme timestamp with time zone,
    wkb_geometry geometry(Point,4326)
);


CREATE SEQUENCE tourisme_ogc_fid_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE tourisme_ogc_fid_seq OWNED BY tourisme.ogc_fid;


ALTER TABLE ONLY tourisme ALTER COLUMN ogc_fid SET DEFAULT nextval('tourisme_ogc_fid_seq'::regclass);








