/usr/lib/python2.7/dist-packages/trytond/backend/postgresql/init.sql is in tryton-server 3.0.2-1.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 | CREATE SEQUENCE ir_configuration_id_seq;
CREATE TABLE ir_configuration (
id INTEGER DEFAULT NEXTVAL('ir_configuration_id_seq') NOT NULL,
language VARCHAR,
PRIMARY KEY(id)
);
CREATE SEQUENCE ir_model_id_seq;
CREATE TABLE ir_model (
id INTEGER DEFAULT NEXTVAL('ir_model_id_seq') NOT NULL,
model VARCHAR NOT NULL,
name VARCHAR,
info TEXT,
module VARCHAR,
PRIMARY KEY(id)
);
CREATE SEQUENCE ir_model_field_id_seq;
CREATE TABLE ir_model_field (
id INTEGER DEFAULT NEXTVAL('ir_model_field_id_seq') NOT NULL,
model INTEGER,
name VARCHAR NOT NULL,
relation VARCHAR,
field_description VARCHAR,
ttype VARCHAR,
help TEXT,
module VARCHAR,
PRIMARY KEY(id),
FOREIGN KEY (model) REFERENCES ir_model(id) ON DELETE CASCADE
);
CREATE SEQUENCE ir_ui_view_id_seq;
CREATE TABLE ir_ui_view (
id INTEGER DEFAULT NEXTVAL('ir_ui_view_id_seq') NOT NULL,
model VARCHAR NOT NULL,
"type" VARCHAR,
data TEXT NOT NULL,
field_childs VARCHAR,
priority INTEGER NOT NULL,
PRIMARY KEY(id)
);
CREATE SEQUENCE ir_ui_menu_id_seq;
CREATE TABLE ir_ui_menu (
id INTEGER DEFAULT NEXTVAL('ir_ui_menu_id_seq') NOT NULL,
parent INTEGER,
name VARCHAR NOT NULL,
icon VARCHAR,
PRIMARY KEY (id),
FOREIGN KEY (parent) REFERENCES ir_ui_menu (id) ON DELETE SET NULL
);
CREATE SEQUENCE ir_translation_id_seq;
CREATE TABLE ir_translation (
id INTEGER DEFAULT NEXTVAL('ir_translation_id_seq') NOT NULL,
lang VARCHAR,
src TEXT,
src_md5 VARCHAR(32) NOT NULL,
name VARCHAR NOT NULL,
res_id INTEGER,
value TEXT,
"type" VARCHAR,
module VARCHAR,
fuzzy BOOLEAN NOT NULL,
PRIMARY KEY(id)
);
CREATE SEQUENCE ir_lang_id_seq;
CREATE TABLE ir_lang (
id INTEGER DEFAULT NEXTVAL('ir_lang_id_seq') NOT NULL,
name VARCHAR NOT NULL,
code VARCHAR NOT NULL,
translatable BOOLEAN NOT NULL,
active BOOLEAN NOT NULL,
direction VARCHAR NOT NULL,
PRIMARY KEY(id)
);
CREATE SEQUENCE res_user_id_seq;
CREATE TABLE res_user (
id INTEGER DEFAULT NEXTVAL('res_user_id_seq') NOT NULL,
name VARCHAR NOT NULL,
active BOOLEAN NOT NULL,
login VARCHAR NOT NULL UNIQUE,
password VARCHAR,
PRIMARY KEY(id)
);
ALTER TABLE res_user ADD CONSTRAINT res_user_login_uniq UNIQUE (login);
INSERT INTO res_user (id, login, password, name, active) VALUES (0, 'root', NULL, 'Root', False);
CREATE SEQUENCE res_group_id_seq;
CREATE TABLE res_group (
id INTEGER DEFAULT NEXTVAL('res_group_id_seq') NOT NULL,
name VARCHAR NOT NULL,
PRIMARY KEY(id)
);
CREATE SEQUENCE "res_user-res_group_id_seq";
CREATE TABLE "res_user-res_group" (
id INTEGER DEFAULT NEXTVAL('res_user-res_group_id_seq') NOT NULL,
"user" INTEGER NOT NULL,
"group" INTEGER NOT NULL,
FOREIGN KEY ("user") REFERENCES res_user (id) ON DELETE CASCADE,
FOREIGN KEY ("group") REFERENCES res_group (id) ON DELETE CASCADE,
PRIMARY KEY(id)
);
CREATE SEQUENCE ir_module_module_id_seq;
CREATE TABLE ir_module_module (
id INTEGER DEFAULT NEXTVAL('ir_module_module_id_seq') NOT NULL,
create_uid INTEGER NOT NULL,
create_date TIMESTAMP WITHOUT TIME ZONE NOT NULL,
write_date TIMESTAMP WITHOUT TIME ZONE,
write_uid INTEGER,
name VARCHAR NOT NULL,
state VARCHAR,
PRIMARY KEY(id),
FOREIGN KEY (create_uid) REFERENCES res_user ON DELETE SET NULL,
FOREIGN KEY (write_uid) REFERENCES res_user ON DELETE SET NULL
);
ALTER TABLE ir_module_module ADD CONSTRAINT name_uniq UNIQUE (name);
CREATE SEQUENCE ir_module_module_dependency_id_seq;
CREATE TABLE ir_module_module_dependency (
id INTEGER DEFAULT NEXTVAL('ir_module_module_dependency_id_seq') NOT NULL,
create_uid INTEGER NOT NULL,
create_date TIMESTAMP WITHOUT TIME ZONE NOT NULL,
write_date TIMESTAMP WITHOUT TIME ZONE,
write_uid INTEGER,
name VARCHAR,
module INTEGER,
PRIMARY KEY(id),
FOREIGN KEY (create_uid) REFERENCES res_user ON DELETE SET NULL,
FOREIGN KEY (write_uid) REFERENCES res_user ON DELETE SET NULL,
FOREIGN KEY (module) REFERENCES ir_module_module ON DELETE CASCADE
);
|