 
 CREATE TABLE association (
     id character varying(64) NOT NULL,
-    home character varying(64),
-    lid character varying(64) NOT NULL,
-    objecttype character varying(128),
-    status character varying(128) NOT NULL,
-    versionname character varying(16),
-    comment_ character varying(256),
-    associationtype character varying(128) NOT NULL,
+    lid character varying(64) NOT NULL,
+    objecttype char(2),
+    status char(1) NOT NULL,
+    versionname character varying(16),
+    associationtype char(2) NOT NULL,
     sourceobject character varying(64) NOT NULL,
     targetobject character varying(64) NOT NULL,
-    CONSTRAINT association_objecttype_check CHECK (((objecttype)::text = 'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:Association'::text))
+    CONSTRAINT association_objecttype_check CHECK (((objecttype)::text = 'AS'::text))
 );
 
 
 ALTER TABLE public.association OWNER TO omar;
 
---
--- TOC entry 1568 (class 1259 OID 78407)
--- Dependencies: 1869 6
--- Name: auditableevent; Type: TABLE; Schema: public; Owner: omar; Tablespace: 
---
-
-CREATE TABLE auditableevent (
-    id character varying(256) NOT NULL,
-    home character varying(256),
-    lid character varying(256) NOT NULL,
-    objecttype character varying(256),
-    status character varying(256) NOT NULL,
-    versionname character varying(16),
-    comment_ character varying(256),
-    requestid character varying(256) NOT NULL,
-    eventtype character varying(256) NOT NULL,
-    timestamp_ character varying(30) NOT NULL,
-    user_ character varying(256) NOT NULL,
-    CONSTRAINT auditableevent_objecttype_check CHECK (((objecttype)::text = 'urn:oasis:names:tc:ebxml-regrep:ObjectType:RegistryObject:AuditableEvent'::text))
-);
-
-
-ALTER TABLE public.auditableevent OWNER TO omar;
 
 --
 -- TOC entry 1569 (class 1259 OID 78414)

ALTER TABLE ONLY name_
    ADD CONSTRAINT name__pkey PRIMARY KEY (parent);


--
-- TOC entry 1955 (class 2606 OID 78650)
-- Dependencies: 1590 1590
-- Name: notification_pkey; Type: CONSTRAINT; Schema: public; Owner: omar; Tablespace: 
--

ALTER TABLE ONLY notification
    ADD CONSTRAINT notification_pkey PRIMARY KEY (id);


--
-- TOC entry 1957 (class 2606 OID 78652)
-- Dependencies: 1591 1591 1591
-- Name: notificationobject_pkey; Type: CONSTRAINT; Schema: public; Owner: omar; Tablespace: 
--

ALTER TABLE ONLY notificationobject
    ADD CONSTRAINT notificationobject_pkey PRIMARY KEY (notificationid, registryobjectid);


--
-- TOC entry 1928 (class 2606 OID 78655)
-- Dependencies: 1578 1578
-- Name: objectref_pkey; Type: CONSTRAINT; Schema: public; Owner: omar; Tablespace: 
--

ALTER TABLE ONLY objectref
    ADD CONSTRAINT objectref_pkey PRIMARY KEY (id);


--
-- TOC entry 1930 (class 2606 OID 78658)
-- Dependencies: 1579 1579
-- Name: organization_pkey; Type: CONSTRAINT; Schema: public; Owner: omar; Tablespace: 
--

ALTER TABLE ONLY organization
    ADD CONSTRAINT organization_pkey PRIMARY KEY (id);


--
-- TOC entry 1934 (class 2606 OID 78660)
-- Dependencies: 1580 1580
-- Name: person_pkey; Type: CONSTRAINT; Schema: public; Owner: omar; Tablespace: 
--

ALTER TABLE ONLY person
    ADD CONSTRAINT person_pkey PRIMARY KEY (id);


--
-- TOC entry 1936 (class 2606 OID 78662)
-- Dependencies: 1581 1581
-- Name: registry_pkey; Type: CONSTRAINT; Schema: public; Owner: omar; Tablespace: 
--

ALTER TABLE ONLY registry
    ADD CONSTRAINT registry_pkey PRIMARY KEY (id);


--
-- TOC entry 1963 (class 2606 OID 78664)
-- Dependencies: 1594 1594 1594
-- Name: registryobject_pkey; Type: CONSTRAINT; Schema: public; Owner: omar; Tablespace: 
--

--ALTER TABLE ONLY registryobject
--    ADD CONSTRAINT registryobject_pkey PRIMARY KEY (id, objecttype);


--
-- TOC entry 1938 (class 2606 OID 78666)
-- Dependencies: 1582 1582


CREATE INDEX ro_eid_idx ON externalidentifier USING btree (registryobject);

--
-- TOC entry 1896 (class 1259 OID 78781)
-- Dependencies: 1567
