     status smallint NOT NULL,
     is_verified boolean DEFAULT false NOT NULL,
     public_location boolean,
-    update_timestamp timestamp(0) without time zone
+    update_timestamp timestamp(0) without time zone,
+    subsite_id integer
 );
 
 



--
-- Name: agent_meta id; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE ONLY agent_meta ALTER COLUMN id SET DEFAULT nextval('agent_meta_id_seq'::regclass);


--
-- Name: agent_relation id; Type: DEFAULT; Schema: public; Owner: -
--




--
-- Name: subsite; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE subsite (
    id integer NOT NULL,
    name character varying(255) NOT NULL,
    create_timestamp timestamp(0) without time zone NOT NULL,
    status smallint NOT NULL,
    agent_id integer NOT NULL,
    url character varying(255) NOT NULL,
    namespace character varying(50) NOT NULL,
    alias_url character varying(255) DEFAULT NULL::character varying,
    verified_seals character varying(512) DEFAULT '[]'::character varying
);


--
-- Name: subsite_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE subsite_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: subsite_meta; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE subsite_meta (
    object_id integer NOT NULL,
    key character varying(255) NOT NULL,
    value text,
    id integer NOT NULL
);


--
-- Name: subsite_meta_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE subsite_meta_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: term; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE term (
    id integer NOT NULL,
    taxonomy character varying(64) NOT NULL,
    term character varying(255) NOT NULL,
    description text
);
