diff options
| author | Raphael Collet <rco@openerp.com> | 2017-01-25 11:52:12 +0100 |
|---|---|---|
| committer | Raphael Collet <rco@openerp.com> | 2017-02-22 15:24:05 +0100 |
| commit | daa1eb1fc488d45ba9d4e782053c08cfc1a53cfe (patch) | |
| tree | 2ab197f907f1a56f958025a12972ea80af957d72 /odoo/addons/base/base.sql | |
| parent | 2b46025dd553b01e852ae37a90f90c240851adc1 (diff) | |
[IMP] base: remove ir_model_* tables from base.sql
Diffstat (limited to 'odoo/addons/base/base.sql')
| -rw-r--r-- | odoo/addons/base/base.sql | 71 |
1 files changed, 0 insertions, 71 deletions
diff --git a/odoo/addons/base/base.sql b/odoo/addons/base/base.sql index 31b7061cf78..9e3efde69a6 100644 --- a/odoo/addons/base/base.sql +++ b/odoo/addons/base/base.sql @@ -12,49 +12,6 @@ CREATE TABLE ir_act_url (primary key(id)) INHERITS (ir_actions); CREATE TABLE ir_act_server (primary key(id)) INHERITS (ir_actions); CREATE TABLE ir_act_client (primary key(id)) INHERITS (ir_actions); - -CREATE TABLE ir_model ( - id serial, - model varchar NOT NULL, - name varchar, - state varchar, - info text, - transient boolean, - primary key(id) -); - -CREATE TABLE ir_model_fields ( - id serial, - model varchar NOT NULL, - model_id integer references ir_model on delete cascade, - name varchar NOT NULL, - state varchar default 'base', - field_description varchar, - help varchar, - ttype varchar, - relation varchar, - relation_field varchar, - index boolean, - copy boolean, - related varchar, - readonly boolean default False, - required boolean default False, - selectable boolean default False, - translate boolean default False, - relation_table varchar, - column1 varchar, - column2 varchar, - store boolean, - primary key(id) -); - -CREATE TABLE res_lang ( - id serial, - name VARCHAR(64) NOT NULL UNIQUE, - code VARCHAR(16) NOT NULL UNIQUE, - primary key(id) -); - CREATE TABLE res_users ( id serial NOT NULL, active boolean default True, @@ -137,34 +94,6 @@ CREATE TABLE ir_model_data ( primary key(id) ); --- Records foreign keys and constraints installed by a module (so they can be --- removed when the module is uninstalled): --- - for a foreign key: type is 'f', --- - for a constraint: type is 'u' (this is the convention PostgreSQL uses). -CREATE TABLE ir_model_constraint ( - id serial NOT NULL, - date_init timestamp without time zone, - date_update timestamp without time zone, - module integer NOT NULL references ir_module_module on delete restrict, - model integer NOT NULL references ir_model on delete restrict, - type character varying(1) NOT NULL, - definition varchar, - name varchar NOT NULL, - primary key(id) -); - --- Records relation tables (i.e. implementing many2many) installed by a module --- (so they can be removed when the module is uninstalled). -CREATE TABLE ir_model_relation ( - id serial NOT NULL, - date_init timestamp without time zone, - date_update timestamp without time zone, - module integer NOT NULL references ir_module_module on delete restrict, - model integer NOT NULL references ir_model on delete restrict, - name varchar NOT NULL, - primary key(id) -); - CREATE TABLE res_currency ( id serial, name varchar NOT NULL, |
