data-services/common-data/meta_category.sql
Rafa de la Torre 4dece40beb Add schema of common-data metadata tables #136
pg_dump -U postgres --schema-only --table=meta_dataset cartodb_user_db > meta_dataset.sql
pg_dump -U postgres --schema-only --table=meta_category cartodb_user_db > meta_category.sql
2015-05-05 19:06:53 +02:00

14 lines
374 B
SQL

--
-- Name: meta_category; Type: TABLE; Schema: public
--
CREATE TABLE meta_category (
cartodb_id integer NOT NULL,
name text,
created_at timestamp with time zone DEFAULT now() NOT NULL,
updated_at timestamp with time zone DEFAULT now() NOT NULL,
the_geom geometry(Geometry,4326),
the_geom_webmercator geometry(Geometry,3857),
image_url text
);