summaryrefslogtreecommitdiff
path: root/odoo/addons/base/base.sql
diff options
context:
space:
mode:
authorRaphael Collet <rco@openerp.com>2017-01-25 11:52:12 +0100
committerRaphael Collet <rco@openerp.com>2017-02-22 15:24:05 +0100
commitdaa1eb1fc488d45ba9d4e782053c08cfc1a53cfe (patch)
tree2ab197f907f1a56f958025a12972ea80af957d72 /odoo/addons/base/base.sql
parent2b46025dd553b01e852ae37a90f90c240851adc1 (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.sql71
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,