search

BerlusGmbH / Berlussimo

Hausverwaltung Software
GNU Affero General Public License v3.0
18 stars 23 forks source link

Add missing table KAUTION_DATEN to the db schema creation #51

Closed powervault76 closed 5 years ago

powervault76 commented 6 years ago

The table KAUTION_DATEN is referenced in legacy/classes/class_kautionen.php but this table is not created by the db schema creation instructions in install/DB-Version-0.4.0/

mueller-berlus commented 5 years ago

You are correct. Thanks for the hint. I have created a laravel migration for all legacy tables including KAUTION_DATEN. Unfortunately it might be a while until this change hits the develop tree. So for the time being here is the definition I am going to use:

CREATE TABLE IF NOT EXISTSKAUTION_DATEN( DATint(7) NOT NULL AUTO_INCREMENT, MV_IDint(7) NOT NULL, FELDvarchar(50) NOT NULL, WERTvarchar(100) NOT NULL, AKTUELLenum('0','1') NOT NULL, PRIMARY KEY (DAT) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

As you can see I switched the engine and the collation. I will close this for now, as a fix is on its way. Although slowly. Feel free to reopen this issue, if necessary.