spec/dummy/db/structure.sql in landable-1.13.2 vs spec/dummy/db/structure.sql in landable-1.14.0

@@ -159,11 +159,12 @@
 CREATE TABLE access_tokens (
     access_token_id uuid DEFAULT public.uuid_generate_v4() NOT NULL,
     author_id uuid NOT NULL,
     expires_at timestamp without time zone NOT NULL,
     created_at timestamp without time zone,
-    updated_at timestamp without time zone
+    updated_at timestamp without time zone,
+    permissions public.hstore
 );
 
 
 --
 -- Name: TABLE access_tokens; Type: COMMENT; Schema: dummy_landable; Owner: -
@@ -205,14 +206,14 @@
 --
 
 CREATE TABLE audits (
     id integer NOT NULL,
     auditable_id uuid,
-    auditable_type character varying(255),
+    auditable_type character varying,
     notes text,
     approver text,
-    flags character varying(255)[] DEFAULT '{}'::character varying[],
+    flags character varying[] DEFAULT '{}'::character varying[],
     created_at timestamp without time zone,
     updated_at timestamp without time zone
 );
 
 
@@ -371,12 +372,12 @@
     head_content text,
     status_code smallint DEFAULT 200 NOT NULL,
     abstract text,
     hero_asset_id uuid,
     deleted_at timestamp without time zone,
-    audit_flags character varying(255)[] DEFAULT '{}'::character varying[],
-    page_name character varying(255),
+    audit_flags character varying[] DEFAULT '{}'::character varying[],
+    page_name character varying,
     CONSTRAINT only_valid_paths CHECK ((path ~ '^/[a-zA-Z0-9/_.~-]*$'::text))
 );
 
 
 --
@@ -402,11 +403,12 @@
     name text,
     slug text,
     body text,
     description text,
     created_at timestamp without time zone,
-    updated_at timestamp without time zone
+    updated_at timestamp without time zone,
+    category_id uuid
 );
 
 
 --
 -- Name: templates; Type: TABLE; Schema: dummy_landable; Owner: -; Tablespace: 
@@ -425,11 +427,12 @@
     file text,
     editable boolean DEFAULT true,
     deleted_at timestamp without time zone,
     published_revision_id uuid,
     is_publishable boolean DEFAULT true,
-    audit_flags character varying(255)[] DEFAULT '{}'::character varying[]
+    audit_flags character varying[] DEFAULT '{}'::character varying[],
+    category_id uuid
 );
 
 
 --
 -- Name: TABLE templates; Type: COMMENT; Schema: dummy_landable; Owner: -
@@ -1803,11 +1806,11 @@
 --
 -- Name: schema_migrations; Type: TABLE; Schema: public; Owner: -; Tablespace: 
 --
 
 CREATE TABLE schema_migrations (
-    version character varying(255) NOT NULL
+    version character varying NOT NULL
 );
 
 
 SET search_path = dummy_landable, pg_catalog;
 
@@ -3457,10 +3460,26 @@
 ALTER TABLE ONLY templates
     ADD CONSTRAINT template_revision_id_fk FOREIGN KEY (published_revision_id) REFERENCES template_revisions(template_revision_id);
 
 
 --
+-- Name: template_revisions_category_id_fkey; Type: FK CONSTRAINT; Schema: dummy_landable; Owner: -
+--
+
+ALTER TABLE ONLY template_revisions
+    ADD CONSTRAINT template_revisions_category_id_fkey FOREIGN KEY (category_id) REFERENCES categories(category_id);
+
+
+--
+-- Name: templates_category_id_fkey; Type: FK CONSTRAINT; Schema: dummy_landable; Owner: -
+--
+
+ALTER TABLE ONLY templates
+    ADD CONSTRAINT templates_category_id_fkey FOREIGN KEY (category_id) REFERENCES categories(category_id);
+
+
+--
 -- Name: theme_id_fk; Type: FK CONSTRAINT; Schema: dummy_landable; Owner: -
 --
 
 ALTER TABLE ONLY theme_assets
     ADD CONSTRAINT theme_id_fk FOREIGN KEY (theme_id) REFERENCES themes(theme_id);
@@ -3894,11 +3913,11 @@
 
 --
 -- PostgreSQL database dump complete
 --
 
-SET search_path TO "$user", public;
+SET search_path TO "$user",public;
 
 INSERT INTO schema_migrations (version) VALUES ('20130510221424');
 
 INSERT INTO schema_migrations (version) VALUES ('20130909182713');
 
@@ -3960,5 +3979,8 @@
 
 INSERT INTO schema_migrations (version) VALUES ('20141211200012');
 
 INSERT INTO schema_migrations (version) VALUES ('20141217171816');
 
+INSERT INTO schema_migrations (version) VALUES ('20150610999999');
+
+INSERT INTO schema_migrations (version) VALUES ('20150728195345');