/usr/lib/python2.7/dist-packages/trytond/backend/sqlite/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 | CREATE TABLE ir_configuration (
id INTEGER PRIMARY KEY AUTOINCREMENT,
language VARCHAR
);
CREATE TABLE ir_model (
id INTEGER PRIMARY KEY AUTOINCREMENT,
model VARCHAR,
name VARCHAR,
info TEXT,
module VARCHAR
);
CREATE TABLE ir_model_field (
id INTEGER PRIMARY KEY AUTOINCREMENT,
model INTEGER,
name VARCHAR,
relation VARCHAR,
field_description VARCHAR,
ttype VARCHAR,
help TEXT,
module VARCHAR
);
CREATE TABLE ir_ui_view (
id INTEGER PRIMARY KEY AUTOINCREMENT,
model VARCHAR,
"type" VARCHAR,
data TEXT,
field_childs VARCHAR,
priority INTEGER
);
CREATE TABLE ir_ui_menu (
id INTEGER PRIMARY KEY AUTOINCREMENT,
parent INTEGER,
name VARCHAR,
icon VARCHAR
);
CREATE TABLE ir_translation (
id INTEGER PRIMARY KEY AUTOINCREMENT,
lang VARCHAR,
src TEXT,
src_md5 VARCHAR(32) NOT NULL,
name VARCHAR,
res_id INTEGER,
value TEXT,
"type" VARCHAR,
module VARCHAR,
fuzzy BOOLEAN
);
CREATE TABLE ir_lang (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name VARCHAR,
code VARCHAR,
translatable BOOLEAN,
active BOOLEAN,
direction VARCHAR
);
CREATE TABLE res_user (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name VARCHAR,
active BOOLEAN,
login VARCHAR,
password VARCHAR
);
INSERT INTO res_user (id, login, password, name, active) VALUES (0, 'root', NULL, 'Root', 0);
CREATE TABLE res_group (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name VARCHAR
);
CREATE TABLE "res_user-res_group" (
id INTEGER PRIMARY KEY AUTOINCREMENT,
"user" INTEGER,
"group" INTEGER
);
CREATE TABLE ir_module_module (
id INTEGER PRIMARY KEY AUTOINCREMENT,
create_uid INTEGER,
create_date TIMESTAMP,
write_date TIMESTAMP,
write_uid INTEGER,
name VARCHAR,
state VARCHAR
);
CREATE TABLE ir_module_module_dependency (
id INTEGER PRIMARY KEY AUTOINCREMENT,
create_uid INTEGER,
create_date TIMESTAMP,
write_date TIMESTAMP,
write_uid INTEGER,
name VARCHAR,
module INTEGER
);
|