--- /dev/null
+#-*- coding: utf8 -*-
+from openerp.osv import osv, fields
+
+
+class BaseA(osv.Model):
+ """Classe parente A"""
+
+ _name = "testing.base.a"
+
+ _description = "BaseA"
+
+ _columns = {
+ "name": fields.char(string="name", size=8, required=True),
+ "a1": fields.char(string="A1", size=8, required=True),
+ "a2": fields.char(string="A2", size=8, required=True),
+ }
+
+
+class BaseB(osv.Model):
+ """Classe parente B"""
+
+ _name = "testing.base.b"
+
+ _description = "BaseB"
+
+ _columns = {
+ "name": fields.char(string="name", size=8, required=True),
+ "b1": fields.char(string="B1", size=8, required=True),
+ "b2": fields.char(string="B2", size=8, required=True),
+ }
+
+
+class BaseC(osv.Model):
+ """Classe parente C"""
+
+ _name = "testing.base.c"
+
+ _description = "BaseC"
+
+ _columns = {
+ "name": fields.char(string="name", size=8, required=True),
+ "c1": fields.char(string="C1", size=8, required=True),
+ "c2": fields.char(string="C2", size=8, required=True),
+ }
+
+
+class BaseD(osv.Model):
+ """Classe parente D"""
+
+ _name = "testing.base.d"
+
+ _description = "BaseD"
+
+ _columns = {
+ "name": fields.char(string="name", size=8, required=True),
+ "d1": fields.char(string="D1", size=8, required=True),
+ "d2": fields.char(string="D2", size=8, required=True),
+ }
+
+
+class ClassInheritance(osv.Model):
+ """Test d'héritage de classe"""
+
+ _name = "testing.base.c"
+
+ _description = "ClassInheritance"
+
+ _inherit = "testing.base.c"
+
+ _columns = {
+ "name": fields.char(string="name", size=8, required=True),
+ "c1": fields.char(string="C1", size=8, required=True),
+ "c3": fields.char(string="C3", size=8, required=True),
+ }
+
+
+class PrototypeInheritance(osv.Model):
+ """Test d'héritage de prototype"""
+
+ _name = "testing.inheritance.prototype"
+
+ _description = "PrototypeInheritance"
+
+ _inherit = "testing.base.d"
+
+ _columns = {
+ "name": fields.char(string="name", size=8, required=True),
+ "d1": fields.char(string="D1", size=8, required=True),
+ "d3": fields.char(string="D3", size=8, required=True),
+ }
+
+
+class DelegationInheritance1(osv.Model):
+ """Test d'héritage par délégation"""
+
+ _name = "testing.inheritance.delegation1"
+
+ _description = "DelegationInheritance1"
+
+ _inherits = {"testing.base.a": "custom_base_a_id"}
+
+ _columns = {
+ "name": fields.char(string="name", size=8, required=True),
+ "a1": fields.char(string="A1", size=8, required=True),
+ "a3": fields.char(string="A3", size=8, required=True),
+ }
+
+
+class DelegationInheritance2(osv.Model):
+ """Test d'héritage par délégation"""
+
+ _name = "testing.inheritance.delegation2"
+
+ _description = "DelegationInheritance2"
+
+ _inherits = {
+ "testing.base.a": "custom_base_a_id",
+ "testing.base.b": "custom_base_b_id",
+ }
+
+ _columns = {
+ "name": fields.char(string="name", size=8, required=True),
+ "a1": fields.char(string="A1", size=8, required=True),
+ "a3": fields.char(string="A3", size=8, required=True),
+ "b1": fields.char(string="B1", size=8, required=True),
+ "b3": fields.char(string="B3", size=8, required=True),
+ }
+
+
+class DelegationInheritance3(osv.Model):
+ """Test d'héritage par délégation"""
+
+ _name = "testing.inheritance.delegation3"
+
+ _description = "DelegationInheritance3"
+
+ _inherits = {"testing.base.a": "custom_base_a_id"}
+
+ _columns = {
+ "name": fields.char(string="name", size=8, required=True),
+ "custom_base_a_id": fields.many2one("testing.base.a", 'Base A', required=True, ondelete='CASCADE'),
+ "a1": fields.char(string="A1", size=8, required=True),
+ "a3": fields.char(string="A3", size=8, required=True),
+ }
+
+
+class DelegationInheritance4(osv.Model):
+ """Test d'héritage par délégation"""
+
+ _name = "testing.inheritance.delegation4"
+
+ _description = "DelegationInheritance4"
+
+ _inherits = {
+ "testing.base.a": "custom_base_a_id",
+ "testing.base.b": "custom_base_b_id",
+ }
+
+ _columns = {
+ "name": fields.char(string="name", size=8, required=True),
+ "custom_base_a_id": fields.many2one("testing.base.a", 'Base A', required=True, ondelete='CASCADE'),
+ "custom_base_b_id": fields.many2one("testing.base.b", 'Base B', required=True, ondelete='CASCADE'),
+ "a1": fields.char(string="A1", size=8, required=True),
+ "a3": fields.char(string="A3", size=8, required=True),
+ "b1": fields.char(string="B1", size=8, required=True),
+ "b3": fields.char(string="B3", size=8, required=True),
+ }
+
--- /dev/null
+--
+-- Name: testing_base_a; Type: TABLE; Schema: public; Owner: openerp; Tablespace:
+--
+
+CREATE TABLE testing_base_a (
+ id integer NOT NULL,
+ create_uid integer,
+ create_date timestamp without time zone,
+ write_date timestamp without time zone,
+ write_uid integer,
+ a1 character varying(8) NOT NULL,
+ a2 character varying(8) NOT NULL,
+ name character varying(8) NOT NULL
+);
+
+
+ALTER TABLE public.testing_base_a OWNER TO openerp;
+
+--
+-- Name: TABLE testing_base_a; Type: COMMENT; Schema: public; Owner: openerp
+--
+
+COMMENT ON TABLE testing_base_a IS 'BaseA';
+
+
+--
+-- Name: COLUMN testing_base_a.a1; Type: COMMENT; Schema: public; Owner: openerp
+--
+
+COMMENT ON COLUMN testing_base_a.a1 IS 'A1';
+
+
+--
+-- Name: COLUMN testing_base_a.a2; Type: COMMENT; Schema: public; Owner: openerp
+--
+
+COMMENT ON COLUMN testing_base_a.a2 IS 'A2';
+
+
+--
+-- Name: COLUMN testing_base_a.name; Type: COMMENT; Schema: public; Owner: openerp
+--
+
+COMMENT ON COLUMN testing_base_a.name IS 'name';
+
+
+--
+-- Name: testing_base_a_id_seq; Type: SEQUENCE; Schema: public; Owner: openerp
+--
+
+CREATE SEQUENCE testing_base_a_id_seq
+ START WITH 1
+ INCREMENT BY 1
+ NO MINVALUE
+ NO MAXVALUE
+ CACHE 1;
+
+
+ALTER TABLE public.testing_base_a_id_seq OWNER TO openerp;
+
+--
+-- Name: testing_base_a_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: openerp
+--
+
+ALTER SEQUENCE testing_base_a_id_seq OWNED BY testing_base_a.id;
+
+
+--
+-- Name: testing_base_b; Type: TABLE; Schema: public; Owner: openerp; Tablespace:
+--
+
+CREATE TABLE testing_base_b (
+ id integer NOT NULL,
+ create_uid integer,
+ create_date timestamp without time zone,
+ write_date timestamp without time zone,
+ write_uid integer,
+ name character varying(8) NOT NULL,
+ b2 character varying(8) NOT NULL,
+ b1 character varying(8) NOT NULL
+);
+
+
+ALTER TABLE public.testing_base_b OWNER TO openerp;
+
+--
+-- Name: TABLE testing_base_b; Type: COMMENT; Schema: public; Owner: openerp
+--
+
+COMMENT ON TABLE testing_base_b IS 'BaseB';
+
+
+--
+-- Name: COLUMN testing_base_b.name; Type: COMMENT; Schema: public; Owner: openerp
+--
+
+COMMENT ON COLUMN testing_base_b.name IS 'name';
+
+
+--
+-- Name: COLUMN testing_base_b.b2; Type: COMMENT; Schema: public; Owner: openerp
+--
+
+COMMENT ON COLUMN testing_base_b.b2 IS 'B2';
+
+
+--
+-- Name: COLUMN testing_base_b.b1; Type: COMMENT; Schema: public; Owner: openerp
+--
+
+COMMENT ON COLUMN testing_base_b.b1 IS 'B1';
+
+
+--
+-- Name: testing_base_b_id_seq; Type: SEQUENCE; Schema: public; Owner: openerp
+--
+
+CREATE SEQUENCE testing_base_b_id_seq
+ START WITH 1
+ INCREMENT BY 1
+ NO MINVALUE
+ NO MAXVALUE
+ CACHE 1;
+
+
+ALTER TABLE public.testing_base_b_id_seq OWNER TO openerp;
+
+--
+-- Name: testing_base_b_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: openerp
+--
+
+ALTER SEQUENCE testing_base_b_id_seq OWNED BY testing_base_b.id;
+
+
+--
+-- Name: testing_base_c; Type: TABLE; Schema: public; Owner: openerp; Tablespace:
+--
+
+CREATE TABLE testing_base_c (
+ id integer NOT NULL,
+ create_uid integer,
+ create_date timestamp without time zone,
+ write_date timestamp without time zone,
+ write_uid integer,
+ c3 character varying(8) NOT NULL,
+ c2 character varying(8) NOT NULL,
+ c1 character varying(8) NOT NULL,
+ name character varying(8) NOT NULL
+);
+
+
+ALTER TABLE public.testing_base_c OWNER TO openerp;
+
+--
+-- Name: TABLE testing_base_c; Type: COMMENT; Schema: public; Owner: openerp
+--
+
+COMMENT ON TABLE testing_base_c IS 'ClassInheritance';
+
+
+--
+-- Name: COLUMN testing_base_c.c3; Type: COMMENT; Schema: public; Owner: openerp
+--
+
+COMMENT ON COLUMN testing_base_c.c3 IS 'C3';
+
+
+--
+-- Name: COLUMN testing_base_c.c2; Type: COMMENT; Schema: public; Owner: openerp
+--
+
+COMMENT ON COLUMN testing_base_c.c2 IS 'C2';
+
+
+--
+-- Name: COLUMN testing_base_c.c1; Type: COMMENT; Schema: public; Owner: openerp
+--
+
+COMMENT ON COLUMN testing_base_c.c1 IS 'C1';
+
+
+--
+-- Name: COLUMN testing_base_c.name; Type: COMMENT; Schema: public; Owner: openerp
+--
+
+COMMENT ON COLUMN testing_base_c.name IS 'name';
+
+
+--
+-- Name: testing_base_c_id_seq; Type: SEQUENCE; Schema: public; Owner: openerp
+--
+
+CREATE SEQUENCE testing_base_c_id_seq
+ START WITH 1
+ INCREMENT BY 1
+ NO MINVALUE
+ NO MAXVALUE
+ CACHE 1;
+
+
+ALTER TABLE public.testing_base_c_id_seq OWNER TO openerp;
+
+--
+-- Name: testing_base_c_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: openerp
+--
+
+ALTER SEQUENCE testing_base_c_id_seq OWNED BY testing_base_c.id;
+
+
+--
+-- Name: testing_base_d; Type: TABLE; Schema: public; Owner: openerp; Tablespace:
+--
+
+CREATE TABLE testing_base_d (
+ id integer NOT NULL,
+ create_uid integer,
+ create_date timestamp without time zone,
+ write_date timestamp without time zone,
+ write_uid integer,
+ d2 character varying(8) NOT NULL,
+ name character varying(8) NOT NULL,
+ d1 character varying(8) NOT NULL
+);
+
+
+ALTER TABLE public.testing_base_d OWNER TO openerp;
+
+--
+-- Name: TABLE testing_base_d; Type: COMMENT; Schema: public; Owner: openerp
+--
+
+COMMENT ON TABLE testing_base_d IS 'BaseD';
+
+
+--
+-- Name: COLUMN testing_base_d.d2; Type: COMMENT; Schema: public; Owner: openerp
+--
+
+COMMENT ON COLUMN testing_base_d.d2 IS 'D2';
+
+
+--
+-- Name: COLUMN testing_base_d.name; Type: COMMENT; Schema: public; Owner: openerp
+--
+
+COMMENT ON COLUMN testing_base_d.name IS 'name';
+
+
+--
+-- Name: COLUMN testing_base_d.d1; Type: COMMENT; Schema: public; Owner: openerp
+--
+
+COMMENT ON COLUMN testing_base_d.d1 IS 'D1';
+
+
+--
+-- Name: testing_base_d_id_seq; Type: SEQUENCE; Schema: public; Owner: openerp
+--
+
+CREATE SEQUENCE testing_base_d_id_seq
+ START WITH 1
+ INCREMENT BY 1
+ NO MINVALUE
+ NO MAXVALUE
+ CACHE 1;
+
+
+ALTER TABLE public.testing_base_d_id_seq OWNER TO openerp;
+
+--
+-- Name: testing_base_d_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: openerp
+--
+
+ALTER SEQUENCE testing_base_d_id_seq OWNED BY testing_base_d.id;
+
+
+--
+-- Name: testing_inheritance_delegation1; Type: TABLE; Schema: public; Owner: openerp; Tablespace:
+--
+
+CREATE TABLE testing_inheritance_delegation1 (
+ id integer NOT NULL,
+ create_uid integer,
+ create_date timestamp without time zone,
+ write_date timestamp without time zone,
+ write_uid integer,
+ a1 character varying(8) NOT NULL,
+ a3 character varying(8) NOT NULL,
+ name character varying(8) NOT NULL,
+ custom_base_a_id integer NOT NULL
+);
+
+
+ALTER TABLE public.testing_inheritance_delegation1 OWNER TO openerp;
+
+--
+-- Name: TABLE testing_inheritance_delegation1; Type: COMMENT; Schema: public; Owner: openerp
+--
+
+COMMENT ON TABLE testing_inheritance_delegation1 IS 'DelegationInheritance1';
+
+
+--
+-- Name: COLUMN testing_inheritance_delegation1.a1; Type: COMMENT; Schema: public; Owner: openerp
+--
+
+COMMENT ON COLUMN testing_inheritance_delegation1.a1 IS 'A1';
+
+
+--
+-- Name: COLUMN testing_inheritance_delegation1.a3; Type: COMMENT; Schema: public; Owner: openerp
+--
+
+COMMENT ON COLUMN testing_inheritance_delegation1.a3 IS 'A3';
+
+
+--
+-- Name: COLUMN testing_inheritance_delegation1.name; Type: COMMENT; Schema: public; Owner: openerp
+--
+
+COMMENT ON COLUMN testing_inheritance_delegation1.name IS 'name';
+
+
+--
+-- Name: COLUMN testing_inheritance_delegation1.custom_base_a_id; Type: COMMENT; Schema: public; Owner: openerp
+--
+
+COMMENT ON COLUMN testing_inheritance_delegation1.custom_base_a_id IS 'Automatically created field to link to parent testing.base.a';
+
+
+--
+-- Name: testing_inheritance_delegation1_id_seq; Type: SEQUENCE; Schema: public; Owner: openerp
+--
+
+CREATE SEQUENCE testing_inheritance_delegation1_id_seq
+ START WITH 1
+ INCREMENT BY 1
+ NO MINVALUE
+ NO MAXVALUE
+ CACHE 1;
+
+
+ALTER TABLE public.testing_inheritance_delegation1_id_seq OWNER TO openerp;
+
+--
+-- Name: testing_inheritance_delegation1_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: openerp
+--
+
+ALTER SEQUENCE testing_inheritance_delegation1_id_seq OWNED BY testing_inheritance_delegation1.id;
+
+
+--
+-- Name: testing_inheritance_delegation2; Type: TABLE; Schema: public; Owner: openerp; Tablespace:
+--
+
+CREATE TABLE testing_inheritance_delegation2 (
+ id integer NOT NULL,
+ create_uid integer,
+ create_date timestamp without time zone,
+ write_date timestamp without time zone,
+ write_uid integer,
+ custom_base_a_id integer NOT NULL,
+ a1 character varying(8) NOT NULL,
+ a3 character varying(8) NOT NULL,
+ b1 character varying(8) NOT NULL,
+ b3 character varying(8) NOT NULL,
+ "custom_base_B_id" integer NOT NULL,
+ name character varying(8) NOT NULL
+);
+
+
+ALTER TABLE public.testing_inheritance_delegation2 OWNER TO openerp;
+
+--
+-- Name: TABLE testing_inheritance_delegation2; Type: COMMENT; Schema: public; Owner: openerp
+--
+
+COMMENT ON TABLE testing_inheritance_delegation2 IS 'DelegationInheritance2';
+
+
+--
+-- Name: COLUMN testing_inheritance_delegation2.custom_base_a_id; Type: COMMENT; Schema: public; Owner: openerp
+--
+
+COMMENT ON COLUMN testing_inheritance_delegation2.custom_base_a_id IS 'Automatically created field to link to parent testing.base.a';
+
+
+--
+-- Name: COLUMN testing_inheritance_delegation2.a1; Type: COMMENT; Schema: public; Owner: openerp
+--
+
+COMMENT ON COLUMN testing_inheritance_delegation2.a1 IS 'A1';
+
+
+--
+-- Name: COLUMN testing_inheritance_delegation2.a3; Type: COMMENT; Schema: public; Owner: openerp
+--
+
+COMMENT ON COLUMN testing_inheritance_delegation2.a3 IS 'A3';
+
+
+--
+-- Name: COLUMN testing_inheritance_delegation2.b1; Type: COMMENT; Schema: public; Owner: openerp
+--
+
+COMMENT ON COLUMN testing_inheritance_delegation2.b1 IS 'B1';
+
+
+--
+-- Name: COLUMN testing_inheritance_delegation2.b3; Type: COMMENT; Schema: public; Owner: openerp
+--
+
+COMMENT ON COLUMN testing_inheritance_delegation2.b3 IS 'B3';
+
+
+--
+-- Name: COLUMN testing_inheritance_delegation2."custom_base_B_id"; Type: COMMENT; Schema: public; Owner: openerp
+--
+
+COMMENT ON COLUMN testing_inheritance_delegation2."custom_base_B_id" IS 'Automatically created field to link to parent testing.base.b';
+
+
+--
+-- Name: COLUMN testing_inheritance_delegation2.name; Type: COMMENT; Schema: public; Owner: openerp
+--
+
+COMMENT ON COLUMN testing_inheritance_delegation2.name IS 'name';
+
+
+--
+-- Name: testing_inheritance_delegation2_id_seq; Type: SEQUENCE; Schema: public; Owner: openerp
+--
+
+CREATE SEQUENCE testing_inheritance_delegation2_id_seq
+ START WITH 1
+ INCREMENT BY 1
+ NO MINVALUE
+ NO MAXVALUE
+ CACHE 1;
+
+
+ALTER TABLE public.testing_inheritance_delegation2_id_seq OWNER TO openerp;
+
+--
+-- Name: testing_inheritance_delegation2_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: openerp
+--
+
+ALTER SEQUENCE testing_inheritance_delegation2_id_seq OWNED BY testing_inheritance_delegation2.id;
+
+
+--
+-- Name: testing_inheritance_delegation3; Type: TABLE; Schema: public; Owner: openerp; Tablespace:
+--
+
+CREATE TABLE testing_inheritance_delegation3 (
+ id integer NOT NULL,
+ create_uid integer,
+ create_date timestamp without time zone,
+ write_date timestamp without time zone,
+ write_uid integer,
+ a1 character varying(8) NOT NULL,
+ a3 character varying(8) NOT NULL,
+ name character varying(8) NOT NULL,
+ custom_base_a_id integer NOT NULL
+);
+
+
+ALTER TABLE public.testing_inheritance_delegation3 OWNER TO openerp;
+
+--
+-- Name: TABLE testing_inheritance_delegation3; Type: COMMENT; Schema: public; Owner: openerp
+--
+
+COMMENT ON TABLE testing_inheritance_delegation3 IS 'DelegationInheritance3';
+
+
+--
+-- Name: COLUMN testing_inheritance_delegation3.a1; Type: COMMENT; Schema: public; Owner: openerp
+--
+
+COMMENT ON COLUMN testing_inheritance_delegation3.a1 IS 'A1';
+
+
+--
+-- Name: COLUMN testing_inheritance_delegation3.a3; Type: COMMENT; Schema: public; Owner: openerp
+--
+
+COMMENT ON COLUMN testing_inheritance_delegation3.a3 IS 'A3';
+
+
+--
+-- Name: COLUMN testing_inheritance_delegation3.name; Type: COMMENT; Schema: public; Owner: openerp
+--
+
+COMMENT ON COLUMN testing_inheritance_delegation3.name IS 'name';
+
+
+--
+-- Name: COLUMN testing_inheritance_delegation3.custom_base_a_id; Type: COMMENT; Schema: public; Owner: openerp
+--
+
+COMMENT ON COLUMN testing_inheritance_delegation3.custom_base_a_id IS 'Base A';
+
+
+--
+-- Name: testing_inheritance_delegation3_id_seq; Type: SEQUENCE; Schema: public; Owner: openerp
+--
+
+CREATE SEQUENCE testing_inheritance_delegation3_id_seq
+ START WITH 1
+ INCREMENT BY 1
+ NO MINVALUE
+ NO MAXVALUE
+ CACHE 1;
+
+
+ALTER TABLE public.testing_inheritance_delegation3_id_seq OWNER TO openerp;
+
+--
+-- Name: testing_inheritance_delegation3_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: openerp
+--
+
+ALTER SEQUENCE testing_inheritance_delegation3_id_seq OWNED BY testing_inheritance_delegation3.id;
+
+
+--
+-- Name: testing_inheritance_delegation4; Type: TABLE; Schema: public; Owner: openerp; Tablespace:
+--
+
+CREATE TABLE testing_inheritance_delegation4 (
+ id integer NOT NULL,
+ create_uid integer,
+ create_date timestamp without time zone,
+ write_date timestamp without time zone,
+ write_uid integer,
+ a1 character varying(8) NOT NULL,
+ a3 character varying(8) NOT NULL,
+ name character varying(8) NOT NULL,
+ b3 character varying(8) NOT NULL,
+ custom_base_b_id integer NOT NULL,
+ custom_base_a_id integer NOT NULL,
+ b1 character varying(8) NOT NULL
+);
+
+
+ALTER TABLE public.testing_inheritance_delegation4 OWNER TO openerp;
+
+--
+-- Name: TABLE testing_inheritance_delegation4; Type: COMMENT; Schema: public; Owner: openerp
+--
+
+COMMENT ON TABLE testing_inheritance_delegation4 IS 'DelegationInheritance4';
+
+
+--
+-- Name: COLUMN testing_inheritance_delegation4.a1; Type: COMMENT; Schema: public; Owner: openerp
+--
+
+COMMENT ON COLUMN testing_inheritance_delegation4.a1 IS 'A1';
+
+
+--
+-- Name: COLUMN testing_inheritance_delegation4.a3; Type: COMMENT; Schema: public; Owner: openerp
+--
+
+COMMENT ON COLUMN testing_inheritance_delegation4.a3 IS 'A3';
+
+
+--
+-- Name: COLUMN testing_inheritance_delegation4.name; Type: COMMENT; Schema: public; Owner: openerp
+--
+
+COMMENT ON COLUMN testing_inheritance_delegation4.name IS 'name';
+
+
+--
+-- Name: COLUMN testing_inheritance_delegation4.b3; Type: COMMENT; Schema: public; Owner: openerp
+--
+
+COMMENT ON COLUMN testing_inheritance_delegation4.b3 IS 'B3';
+
+
+--
+-- Name: COLUMN testing_inheritance_delegation4.custom_base_b_id; Type: COMMENT; Schema: public; Owner: openerp
+--
+
+COMMENT ON COLUMN testing_inheritance_delegation4.custom_base_b_id IS 'Base B';
+
+
+--
+-- Name: COLUMN testing_inheritance_delegation4.custom_base_a_id; Type: COMMENT; Schema: public; Owner: openerp
+--
+
+COMMENT ON COLUMN testing_inheritance_delegation4.custom_base_a_id IS 'Base A';
+
+
+--
+-- Name: COLUMN testing_inheritance_delegation4.b1; Type: COMMENT; Schema: public; Owner: openerp
+--
+
+COMMENT ON COLUMN testing_inheritance_delegation4.b1 IS 'B1';
+
+
+--
+-- Name: testing_inheritance_delegation4_id_seq; Type: SEQUENCE; Schema: public; Owner: openerp
+--
+
+CREATE SEQUENCE testing_inheritance_delegation4_id_seq
+ START WITH 1
+ INCREMENT BY 1
+ NO MINVALUE
+ NO MAXVALUE
+ CACHE 1;
+
+
+ALTER TABLE public.testing_inheritance_delegation4_id_seq OWNER TO openerp;
+
+--
+-- Name: testing_inheritance_delegation4_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: openerp
+--
+
+ALTER SEQUENCE testing_inheritance_delegation4_id_seq OWNED BY testing_inheritance_delegation4.id;
+
+
+--
+-- Name: testing_inheritance_prototype; Type: TABLE; Schema: public; Owner: openerp; Tablespace:
+--
+
+CREATE TABLE testing_inheritance_prototype (
+ id integer NOT NULL,
+ create_uid integer,
+ create_date timestamp without time zone,
+ write_date timestamp without time zone,
+ write_uid integer,
+ d1 character varying(8) NOT NULL,
+ d2 character varying(8) NOT NULL,
+ name character varying(8) NOT NULL,
+ d3 character varying(8) NOT NULL
+);
+
+
+ALTER TABLE public.testing_inheritance_prototype OWNER TO openerp;
+
+--
+-- Name: TABLE testing_inheritance_prototype; Type: COMMENT; Schema: public; Owner: openerp
+--
+
+COMMENT ON TABLE testing_inheritance_prototype IS 'PrototypeInheritance';
+
+
+--
+-- Name: COLUMN testing_inheritance_prototype.d1; Type: COMMENT; Schema: public; Owner: openerp
+--
+
+COMMENT ON COLUMN testing_inheritance_prototype.d1 IS 'D1';
+
+
+--
+-- Name: COLUMN testing_inheritance_prototype.d2; Type: COMMENT; Schema: public; Owner: openerp
+--
+
+COMMENT ON COLUMN testing_inheritance_prototype.d2 IS 'D2';
+
+
+--
+-- Name: COLUMN testing_inheritance_prototype.name; Type: COMMENT; Schema: public; Owner: openerp
+--
+
+COMMENT ON COLUMN testing_inheritance_prototype.name IS 'name';
+
+
+--
+-- Name: COLUMN testing_inheritance_prototype.d3; Type: COMMENT; Schema: public; Owner: openerp
+--
+
+COMMENT ON COLUMN testing_inheritance_prototype.d3 IS 'D3';
+
+
+--
+-- Name: testing_inheritance_prototype_id_seq; Type: SEQUENCE; Schema: public; Owner: openerp
+--
+
+CREATE SEQUENCE testing_inheritance_prototype_id_seq
+ START WITH 1
+ INCREMENT BY 1
+ NO MINVALUE
+ NO MAXVALUE
+ CACHE 1;
+
+
+ALTER TABLE public.testing_inheritance_prototype_id_seq OWNER TO openerp;
+
+--
+-- Name: testing_inheritance_prototype_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: openerp
+--
+
+ALTER SEQUENCE testing_inheritance_prototype_id_seq OWNED BY testing_inheritance_prototype.id;
+
+
+
+
+
+
+
+
+--
+-- Name: id; Type: DEFAULT; Schema: public; Owner: openerp
+--
+
+ALTER TABLE ONLY testing_base_a ALTER COLUMN id SET DEFAULT nextval('testing_base_a_id_seq'::regclass);
+
+
+--
+-- Name: id; Type: DEFAULT; Schema: public; Owner: openerp
+--
+
+ALTER TABLE ONLY testing_base_b ALTER COLUMN id SET DEFAULT nextval('testing_base_b_id_seq'::regclass);
+
+
+--
+-- Name: id; Type: DEFAULT; Schema: public; Owner: openerp
+--
+
+ALTER TABLE ONLY testing_base_c ALTER COLUMN id SET DEFAULT nextval('testing_base_c_id_seq'::regclass);
+
+
+--
+-- Name: id; Type: DEFAULT; Schema: public; Owner: openerp
+--
+
+ALTER TABLE ONLY testing_base_d ALTER COLUMN id SET DEFAULT nextval('testing_base_d_id_seq'::regclass);
+
+
+--
+-- Name: id; Type: DEFAULT; Schema: public; Owner: openerp
+--
+
+ALTER TABLE ONLY testing_inheritance_delegation1 ALTER COLUMN id SET DEFAULT nextval('testing_inheritance_delegation1_id_seq'::regclass);
+
+
+--
+-- Name: id; Type: DEFAULT; Schema: public; Owner: openerp
+--
+
+ALTER TABLE ONLY testing_inheritance_delegation2 ALTER COLUMN id SET DEFAULT nextval('testing_inheritance_delegation2_id_seq'::regclass);
+
+
+--
+-- Name: id; Type: DEFAULT; Schema: public; Owner: openerp
+--
+
+ALTER TABLE ONLY testing_inheritance_delegation3 ALTER COLUMN id SET DEFAULT nextval('testing_inheritance_delegation3_id_seq'::regclass);
+
+
+--
+-- Name: id; Type: DEFAULT; Schema: public; Owner: openerp
+--
+
+ALTER TABLE ONLY testing_inheritance_delegation4 ALTER COLUMN id SET DEFAULT nextval('testing_inheritance_delegation4_id_seq'::regclass);
+
+
+--
+-- Name: id; Type: DEFAULT; Schema: public; Owner: openerp
+--
+
+ALTER TABLE ONLY testing_inheritance_prototype ALTER COLUMN id SET DEFAULT nextval('testing_inheritance_prototype_id_seq'::regclass);
+
+
+
+
+
+
+
+
+
+
+--
+-- Data for Name: testing_base_a; Type: TABLE DATA; Schema: public; Owner: openerp
+--
+
+COPY testing_base_a (id, create_uid, create_date, write_date, write_uid, a1, a2, name) FROM stdin;
+\.
+
+
+--
+-- Name: testing_base_a_id_seq; Type: SEQUENCE SET; Schema: public; Owner: openerp
+--
+
+SELECT pg_catalog.setval('testing_base_a_id_seq', 1, false);
+
+
+--
+-- Data for Name: testing_base_b; Type: TABLE DATA; Schema: public; Owner: openerp
+--
+
+COPY testing_base_b (id, create_uid, create_date, write_date, write_uid, name, b2, b1) FROM stdin;
+\.
+
+
+--
+-- Name: testing_base_b_id_seq; Type: SEQUENCE SET; Schema: public; Owner: openerp
+--
+
+SELECT pg_catalog.setval('testing_base_b_id_seq', 1, false);
+
+
+--
+-- Data for Name: testing_base_c; Type: TABLE DATA; Schema: public; Owner: openerp
+--
+
+COPY testing_base_c (id, create_uid, create_date, write_date, write_uid, c3, c2, c1, name) FROM stdin;
+\.
+
+
+--
+-- Name: testing_base_c_id_seq; Type: SEQUENCE SET; Schema: public; Owner: openerp
+--
+
+SELECT pg_catalog.setval('testing_base_c_id_seq', 1, false);
+
+
+--
+-- Data for Name: testing_base_d; Type: TABLE DATA; Schema: public; Owner: openerp
+--
+
+COPY testing_base_d (id, create_uid, create_date, write_date, write_uid, d2, name, d1) FROM stdin;
+\.
+
+
+--
+-- Name: testing_base_d_id_seq; Type: SEQUENCE SET; Schema: public; Owner: openerp
+--
+
+SELECT pg_catalog.setval('testing_base_d_id_seq', 1, false);
+
+
+--
+-- Data for Name: testing_inheritance_delegation1; Type: TABLE DATA; Schema: public; Owner: openerp
+--
+
+COPY testing_inheritance_delegation1 (id, create_uid, create_date, write_date, write_uid, a1, a3, name, custom_base_a_id) FROM stdin;
+\.
+
+
+--
+-- Name: testing_inheritance_delegation1_id_seq; Type: SEQUENCE SET; Schema: public; Owner: openerp
+--
+
+SELECT pg_catalog.setval('testing_inheritance_delegation1_id_seq', 1, false);
+
+
+--
+-- Data for Name: testing_inheritance_delegation2; Type: TABLE DATA; Schema: public; Owner: openerp
+--
+
+COPY testing_inheritance_delegation2 (id, create_uid, create_date, write_date, write_uid, custom_base_a_id, a1, a3, b1, b3, "custom_base_B_id", name) FROM stdin;
+\.
+
+
+--
+-- Name: testing_inheritance_delegation2_id_seq; Type: SEQUENCE SET; Schema: public; Owner: openerp
+--
+
+SELECT pg_catalog.setval('testing_inheritance_delegation2_id_seq', 1, false);
+
+
+--
+-- Data for Name: testing_inheritance_delegation3; Type: TABLE DATA; Schema: public; Owner: openerp
+--
+
+COPY testing_inheritance_delegation3 (id, create_uid, create_date, write_date, write_uid, a1, a3, name, custom_base_a_id) FROM stdin;
+\.
+
+
+--
+-- Name: testing_inheritance_delegation3_id_seq; Type: SEQUENCE SET; Schema: public; Owner: openerp
+--
+
+SELECT pg_catalog.setval('testing_inheritance_delegation3_id_seq', 1, false);
+
+
+--
+-- Data for Name: testing_inheritance_delegation4; Type: TABLE DATA; Schema: public; Owner: openerp
+--
+
+COPY testing_inheritance_delegation4 (id, create_uid, create_date, write_date, write_uid, a1, a3, name, b3, custom_base_b_id, custom_base_a_id, b1) FROM stdin;
+\.
+
+
+--
+-- Name: testing_inheritance_delegation4_id_seq; Type: SEQUENCE SET; Schema: public; Owner: openerp
+--
+
+SELECT pg_catalog.setval('testing_inheritance_delegation4_id_seq', 1, false);
+
+
+--
+-- Data for Name: testing_inheritance_prototype; Type: TABLE DATA; Schema: public; Owner: openerp
+--
+
+COPY testing_inheritance_prototype (id, create_uid, create_date, write_date, write_uid, d1, d2, name, d3) FROM stdin;
+\.
+
+
+--
+-- Name: testing_inheritance_prototype_id_seq; Type: SEQUENCE SET; Schema: public; Owner: openerp
+--
+
+SELECT pg_catalog.setval('testing_inheritance_prototype_id_seq', 1, false);
+
+
+
+
+
+
+
+
+
+
+--
+-- Name: testing_base_a_pkey; Type: CONSTRAINT; Schema: public; Owner: openerp; Tablespace:
+--
+
+ALTER TABLE ONLY testing_base_a
+ ADD CONSTRAINT testing_base_a_pkey PRIMARY KEY (id);
+
+
+--
+-- Name: testing_base_b_pkey; Type: CONSTRAINT; Schema: public; Owner: openerp; Tablespace:
+--
+
+ALTER TABLE ONLY testing_base_b
+ ADD CONSTRAINT testing_base_b_pkey PRIMARY KEY (id);
+
+
+--
+-- Name: testing_base_c_pkey; Type: CONSTRAINT; Schema: public; Owner: openerp; Tablespace:
+--
+
+ALTER TABLE ONLY testing_base_c
+ ADD CONSTRAINT testing_base_c_pkey PRIMARY KEY (id);
+
+
+--
+-- Name: testing_base_d_pkey; Type: CONSTRAINT; Schema: public; Owner: openerp; Tablespace:
+--
+
+ALTER TABLE ONLY testing_base_d
+ ADD CONSTRAINT testing_base_d_pkey PRIMARY KEY (id);
+
+
+--
+-- Name: testing_inheritance_delegation1_pkey; Type: CONSTRAINT; Schema: public; Owner: openerp; Tablespace:
+--
+
+ALTER TABLE ONLY testing_inheritance_delegation1
+ ADD CONSTRAINT testing_inheritance_delegation1_pkey PRIMARY KEY (id);
+
+
+--
+-- Name: testing_inheritance_delegation2_pkey; Type: CONSTRAINT; Schema: public; Owner: openerp; Tablespace:
+--
+
+ALTER TABLE ONLY testing_inheritance_delegation2
+ ADD CONSTRAINT testing_inheritance_delegation2_pkey PRIMARY KEY (id);
+
+
+--
+-- Name: testing_inheritance_delegation3_pkey; Type: CONSTRAINT; Schema: public; Owner: openerp; Tablespace:
+--
+
+ALTER TABLE ONLY testing_inheritance_delegation3
+ ADD CONSTRAINT testing_inheritance_delegation3_pkey PRIMARY KEY (id);
+
+
+--
+-- Name: testing_inheritance_delegation4_pkey; Type: CONSTRAINT; Schema: public; Owner: openerp; Tablespace:
+--
+
+ALTER TABLE ONLY testing_inheritance_delegation4
+ ADD CONSTRAINT testing_inheritance_delegation4_pkey PRIMARY KEY (id);
+
+
+--
+-- Name: testing_inheritance_prototype_pkey; Type: CONSTRAINT; Schema: public; Owner: openerp; Tablespace:
+--
+
+ALTER TABLE ONLY testing_inheritance_prototype
+ ADD CONSTRAINT testing_inheritance_prototype_pkey PRIMARY KEY (id);
+
+
+
+
+
+
+
+
+
+
+--
+-- Name: testing_base_a_create_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: openerp
+--
+
+ALTER TABLE ONLY testing_base_a
+ ADD CONSTRAINT testing_base_a_create_uid_fkey FOREIGN KEY (create_uid) REFERENCES res_users(id) ON DELETE SET NULL;
+
+
+--
+-- Name: testing_base_a_write_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: openerp
+--
+
+ALTER TABLE ONLY testing_base_a
+ ADD CONSTRAINT testing_base_a_write_uid_fkey FOREIGN KEY (write_uid) REFERENCES res_users(id) ON DELETE SET NULL;
+
+
+--
+-- Name: testing_base_b_create_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: openerp
+--
+
+ALTER TABLE ONLY testing_base_b
+ ADD CONSTRAINT testing_base_b_create_uid_fkey FOREIGN KEY (create_uid) REFERENCES res_users(id) ON DELETE SET NULL;
+
+
+--
+-- Name: testing_base_b_write_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: openerp
+--
+
+ALTER TABLE ONLY testing_base_b
+ ADD CONSTRAINT testing_base_b_write_uid_fkey FOREIGN KEY (write_uid) REFERENCES res_users(id) ON DELETE SET NULL;
+
+
+--
+-- Name: testing_base_c_create_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: openerp
+--
+
+ALTER TABLE ONLY testing_base_c
+ ADD CONSTRAINT testing_base_c_create_uid_fkey FOREIGN KEY (create_uid) REFERENCES res_users(id) ON DELETE SET NULL;
+
+
+--
+-- Name: testing_base_c_write_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: openerp
+--
+
+ALTER TABLE ONLY testing_base_c
+ ADD CONSTRAINT testing_base_c_write_uid_fkey FOREIGN KEY (write_uid) REFERENCES res_users(id) ON DELETE SET NULL;
+
+
+--
+-- Name: testing_base_d_create_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: openerp
+--
+
+ALTER TABLE ONLY testing_base_d
+ ADD CONSTRAINT testing_base_d_create_uid_fkey FOREIGN KEY (create_uid) REFERENCES res_users(id) ON DELETE SET NULL;
+
+
+--
+-- Name: testing_base_d_write_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: openerp
+--
+
+ALTER TABLE ONLY testing_base_d
+ ADD CONSTRAINT testing_base_d_write_uid_fkey FOREIGN KEY (write_uid) REFERENCES res_users(id) ON DELETE SET NULL;
+
+
+--
+-- Name: testing_inheritance_delegation1_create_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: openerp
+--
+
+ALTER TABLE ONLY testing_inheritance_delegation1
+ ADD CONSTRAINT testing_inheritance_delegation1_create_uid_fkey FOREIGN KEY (create_uid) REFERENCES res_users(id) ON DELETE SET NULL;
+
+
+--
+-- Name: testing_inheritance_delegation1_custom_base_a_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: openerp
+--
+
+ALTER TABLE ONLY testing_inheritance_delegation1
+ ADD CONSTRAINT testing_inheritance_delegation1_custom_base_a_id_fkey FOREIGN KEY (custom_base_a_id) REFERENCES testing_base_a(id) ON DELETE CASCADE;
+
+
+--
+-- Name: testing_inheritance_delegation1_write_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: openerp
+--
+
+ALTER TABLE ONLY testing_inheritance_delegation1
+ ADD CONSTRAINT testing_inheritance_delegation1_write_uid_fkey FOREIGN KEY (write_uid) REFERENCES res_users(id) ON DELETE SET NULL;
+
+
+--
+-- Name: testing_inheritance_delegation2_create_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: openerp
+--
+
+ALTER TABLE ONLY testing_inheritance_delegation2
+ ADD CONSTRAINT testing_inheritance_delegation2_create_uid_fkey FOREIGN KEY (create_uid) REFERENCES res_users(id) ON DELETE SET NULL;
+
+
+--
+-- Name: testing_inheritance_delegation2_custom_base_B_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: openerp
+--
+
+ALTER TABLE ONLY testing_inheritance_delegation2
+ ADD CONSTRAINT "testing_inheritance_delegation2_custom_base_B_id_fkey" FOREIGN KEY ("custom_base_B_id") REFERENCES testing_base_b(id) ON DELETE CASCADE;
+
+
+--
+-- Name: testing_inheritance_delegation2_custom_base_a_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: openerp
+--
+
+ALTER TABLE ONLY testing_inheritance_delegation2
+ ADD CONSTRAINT testing_inheritance_delegation2_custom_base_a_id_fkey FOREIGN KEY (custom_base_a_id) REFERENCES testing_base_a(id) ON DELETE CASCADE;
+
+
+--
+-- Name: testing_inheritance_delegation2_write_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: openerp
+--
+
+ALTER TABLE ONLY testing_inheritance_delegation2
+ ADD CONSTRAINT testing_inheritance_delegation2_write_uid_fkey FOREIGN KEY (write_uid) REFERENCES res_users(id) ON DELETE SET NULL;
+
+
+--
+-- Name: testing_inheritance_delegation3_create_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: openerp
+--
+
+ALTER TABLE ONLY testing_inheritance_delegation3
+ ADD CONSTRAINT testing_inheritance_delegation3_create_uid_fkey FOREIGN KEY (create_uid) REFERENCES res_users(id) ON DELETE SET NULL;
+
+
+--
+-- Name: testing_inheritance_delegation3_custom_base_a_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: openerp
+--
+
+ALTER TABLE ONLY testing_inheritance_delegation3
+ ADD CONSTRAINT testing_inheritance_delegation3_custom_base_a_id_fkey FOREIGN KEY (custom_base_a_id) REFERENCES testing_base_a(id) ON DELETE CASCADE;
+
+
+--
+-- Name: testing_inheritance_delegation3_write_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: openerp
+--
+
+ALTER TABLE ONLY testing_inheritance_delegation3
+ ADD CONSTRAINT testing_inheritance_delegation3_write_uid_fkey FOREIGN KEY (write_uid) REFERENCES res_users(id) ON DELETE SET NULL;
+
+
+--
+-- Name: testing_inheritance_delegation4_create_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: openerp
+--
+
+ALTER TABLE ONLY testing_inheritance_delegation4
+ ADD CONSTRAINT testing_inheritance_delegation4_create_uid_fkey FOREIGN KEY (create_uid) REFERENCES res_users(id) ON DELETE SET NULL;
+
+
+--
+-- Name: testing_inheritance_delegation4_custom_base_a_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: openerp
+--
+
+ALTER TABLE ONLY testing_inheritance_delegation4
+ ADD CONSTRAINT testing_inheritance_delegation4_custom_base_a_id_fkey FOREIGN KEY (custom_base_a_id) REFERENCES testing_base_a(id) ON DELETE CASCADE;
+
+
+--
+-- Name: testing_inheritance_delegation4_custom_base_b_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: openerp
+--
+
+ALTER TABLE ONLY testing_inheritance_delegation4
+ ADD CONSTRAINT testing_inheritance_delegation4_custom_base_b_id_fkey FOREIGN KEY (custom_base_b_id) REFERENCES testing_base_b(id) ON DELETE CASCADE;
+
+
+--
+-- Name: testing_inheritance_delegation4_write_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: openerp
+--
+
+ALTER TABLE ONLY testing_inheritance_delegation4
+ ADD CONSTRAINT testing_inheritance_delegation4_write_uid_fkey FOREIGN KEY (write_uid) REFERENCES res_users(id) ON DELETE SET NULL;
+
+
+--
+-- Name: testing_inheritance_prototype_create_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: openerp
+--
+
+ALTER TABLE ONLY testing_inheritance_prototype
+ ADD CONSTRAINT testing_inheritance_prototype_create_uid_fkey FOREIGN KEY (create_uid) REFERENCES res_users(id) ON DELETE SET NULL;
+
+
+--
+-- Name: testing_inheritance_prototype_write_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: openerp
+--
+
+ALTER TABLE ONLY testing_inheritance_prototype
+ ADD CONSTRAINT testing_inheritance_prototype_write_uid_fkey FOREIGN KEY (write_uid) REFERENCES res_users(id) ON DELETE SET NULL;
projects / OpenERP / testing.git / commitdiff