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.sql141
1 files changed, 0 insertions, 141 deletions
diff --git a/odoo/addons/base/base.sql b/odoo/addons/base/base.sql
deleted file mode 100644
index 57d57a1389b..00000000000
--- a/odoo/addons/base/base.sql
+++ /dev/null
@@ -1,141 +0,0 @@
--------------------------------------------------------------------------
--- Pure SQL
--------------------------------------------------------------------------
-
-CREATE TABLE ir_actions (
- id serial,
- primary key(id)
-);
-CREATE TABLE ir_act_window (primary key(id)) INHERITS (ir_actions);
-CREATE TABLE ir_act_report_xml (primary key(id)) INHERITS (ir_actions);
-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 res_users (
- id serial NOT NULL,
- active boolean default True,
- login varchar(64) NOT NULL UNIQUE,
- password varchar(64) default null,
- -- No FK references below, will be added later by ORM
- -- (when the destination rows exist)
- company_id integer, -- references res_company,
- partner_id integer, -- references res_partner,
- primary key(id)
-);
-
-CREATE TABLE res_groups (
- id serial NOT NULL,
- name varchar NOT NULL,
- primary key(id)
-);
-
-CREATE TABLE ir_module_category (
- id serial NOT NULL,
- create_uid integer, -- references res_users on delete set null,
- create_date timestamp without time zone,
- write_date timestamp without time zone,
- write_uid integer, -- references res_users on delete set null,
- parent_id integer REFERENCES ir_module_category ON DELETE SET NULL,
- name character varying(128) NOT NULL,
- primary key(id)
-);
-
-CREATE TABLE ir_module_module (
- id serial NOT NULL,
- create_uid integer, -- references res_users on delete set null,
- create_date timestamp without time zone,
- write_date timestamp without time zone,
- write_uid integer, -- references res_users on delete set null,
- website character varying(256),
- summary character varying(256),
- name character varying(128) NOT NULL,
- author character varying,
- icon varchar,
- state character varying(16),
- latest_version character varying(64),
- shortdesc character varying(256),
- category_id integer REFERENCES ir_module_category ON DELETE SET NULL,
- description text,
- application boolean default False,
- demo boolean default False,
- web boolean DEFAULT FALSE,
- license character varying(32),
- sequence integer DEFAULT 100,
- auto_install boolean default False,
- primary key(id)
-);
-ALTER TABLE ir_module_module add constraint name_uniq unique (name);
-
-CREATE TABLE ir_module_module_dependency (
- id serial NOT NULL,
- create_uid integer, -- references res_users on delete set null,
- create_date timestamp without time zone,
- write_date timestamp without time zone,
- write_uid integer, -- references res_users on delete set null,
- name character varying(128),
- module_id integer REFERENCES ir_module_module ON DELETE cascade,
- primary key(id)
-);
-
-CREATE TABLE ir_model_data (
- id serial NOT NULL,
- create_uid integer,
- create_date timestamp without time zone,
- write_date timestamp without time zone,
- write_uid integer,
- noupdate boolean,
- name varchar NOT NULL,
- date_init timestamp without time zone,
- date_update timestamp without time zone,
- module varchar NOT NULL,
- model varchar NOT NULL,
- res_id integer,
- primary key(id)
-);
-
-CREATE TABLE res_currency (
- id serial,
- name varchar NOT NULL,
- symbol varchar NOT NULL,
- primary key(id)
-);
-
-CREATE TABLE res_company (
- id serial,
- name varchar NOT NULL,
- partner_id integer,
- currency_id integer,
- primary key(id)
-);
-
-CREATE TABLE res_partner (
- id serial,
- name varchar,
- company_id integer,
- primary key(id)
-);
-
-
----------------------------------
--- Default data
----------------------------------
-insert into res_currency (id, name, symbol) VALUES (1, 'EUR', '€');
-insert into ir_model_data (name, module, model, noupdate, res_id) VALUES ('EUR', 'base', 'res.currency', true, 1);
-select setval('res_currency_id_seq', 2);
-
-insert into res_company (id, name, partner_id, currency_id) VALUES (1, 'My Company', 1, 1);
-insert into ir_model_data (name, module, model, noupdate, res_id) VALUES ('main_company', 'base', 'res.company', true, 1);
-select setval('res_company_id_seq', 2);
-
-insert into res_partner (id, name, company_id) VALUES (1, 'My Company', 1);
-insert into ir_model_data (name, module, model, noupdate, res_id) VALUES ('main_partner', 'base', 'res.partner', true, 1);
-select setval('res_partner_id_seq', 2);
-
-insert into res_users (id, login, password, active, partner_id, company_id) VALUES (1, 'admin', 'admin', true, 1, 1);
-insert into ir_model_data (name, module, model, noupdate, res_id) VALUES ('user_root', 'base', 'res.users', true, 1);
-select setval('res_users_id_seq', 2);
-
-insert into res_groups (id, name) VALUES (1, 'Employee');
-insert into ir_model_data (name, module, model, noupdate, res_id) VALUES ('group_user', 'base', 'res.groups', true, 1);
-select setval('res_groups_id_seq', 2);