summaryrefslogtreecommitdiff
path: root/odoo/addons/base/base.sql
diff options
context:
space:
mode:
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,