[tryton-commits] [tryton] [default] Do not create fs_values and values for ir_mod...

[Cédric Krier]

details:   https://code.tryton.org/tryton/commit/85a366497028
branch:    default
user:      Cédric Krier <c...@b2ck.com>
date:      Fri Nov 28 10:19:03 2025 +0100
description:
        Do not create fs_values and values for ir_model_data in init SQL

        Since 49ca1e40161c those fields have been replaced by field_names.

        Closes #14400
diffstat:

 trytond/trytond/backend/postgresql/init.sql |   9 ++++-----
 trytond/trytond/backend/sqlite/init.sql     |  11 +++++------
 2 files changed, 9 insertions(+), 11 deletions(-)

diffs (53 lines):

diff -r 2b03ee0515a1 -r 85a366497028 trytond/trytond/backend/postgresql/init.sql
--- a/trytond/trytond/backend/postgresql/init.sql       Thu Nov 27 15:12:45 
2025 +0100
+++ b/trytond/trytond/backend/postgresql/init.sql       Fri Nov 28 10:19:03 
2025 +0100
@@ -42,19 +42,18 @@
 CREATE TABLE ir_model_data (
    id INTEGER GENERATED BY DEFAULT AS IDENTITY (START WITH 3) NOT NULL
         CONSTRAINT ir_model_id_positive CHECK(id >= 0),
-    db_id INTEGER,
     fs_id VARCHAR,
     model VARCHAR NOT NULL,
     module VARCHAR NOT NULL,
+    db_id INTEGER,
     noupdate BOOL,
-    fs_values TEXT,
-    "values" TEXT,
     PRIMARY KEY(id),
     FOREIGN KEY (model) REFERENCES ir_model(name) ON DELETE CASCADE
 );
 
-INSERT INTO ir_model_data (id, db_id, fs_id, model, module, noupdate, 
fs_values, "values") VALUES (1, 1, 'user_admin', 'res.user', 'res', False, 
'[["login","admin"],["name","Administrator"]]', 
'[["login","admin"],["name","Administrator"]]');
-INSERT INTO ir_model_data (id, db_id, fs_id, model, module, noupdate, 
fs_values, "values") VALUES (2, 1, 'group_admin', 'res.group', 'res', False, 
'[["name","Administrator"]]', '[["name","Administrator"]]');
+INSERT INTO ir_model_data (id, fs_id, model, module, db_id, noupdate) VALUES
+    (1,'user_admin', 'res.user', 'res',  1, False),
+    (2, 'group_admin', 'res.group', 'res', 1, False);
 
 CREATE TABLE ir_ui_view (
     id INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL
diff -r 2b03ee0515a1 -r 85a366497028 trytond/trytond/backend/sqlite/init.sql
--- a/trytond/trytond/backend/sqlite/init.sql   Thu Nov 27 15:12:45 2025 +0100
+++ b/trytond/trytond/backend/sqlite/init.sql   Fri Nov 28 10:19:03 2025 +0100
@@ -31,17 +31,16 @@
 
 CREATE TABLE ir_model_data (
    id INTEGER PRIMARY KEy AUTOINCREMENT,
-    db_id INTEGER,
     fs_id VARCHAR,
     model VARCHAR NOT NULL,
     module VARCHAR NOT NULL,
-    noupdate BOOLEAN,
-    fs_values TEXT,
-    "values" TEXT
+    db_id INTEGER,
+    noupdate BOOLEAN
 );
 
-INSERT INTO ir_model_data (id, db_id, fs_id, model, module, noupdate, 
fs_values, "values") VALUES (1, 1, 'user_admin', 'res.user', 'res', False, 
'[["login","admin"],["name","Administrator"]]', 
'[["login","admin"],["name","Administrator"]]');
-INSERT INTO ir_model_data (id, db_id, fs_id, model, module, noupdate, 
fs_values, "values") VALUES (2, 1, 'group_admin', 'res.group', 'res', False, 
'[["name","Administrator"]]', '[["name","Administrator"]]');
+INSERT INTO ir_model_data (id, fs_id, model, module, db_id, noupdate) VALUES
+    (1, 'user_admin', 'res.user', 'res', 1, False),
+    (2, 'group_admin', 'res.group', 'res', 1, False);
 
 CREATE TABLE ir_ui_view (
     id INTEGER PRIMARY KEY AUTOINCREMENT,