Commit graph

4 commits

Author SHA1 Message Date
Eric Lippmann
dd75a5edbc schema/mysql: Use UNIX_TIMESTAMP() instead of CURRENT_TIMESTMAP()
`CURRENT_TIMESTAMP()` an alias for `NOW()` returns the current date and
time in the format `YYYY-MM-DD hh:mm:ss` using the session time zone.
Since we are using numeric context, the value is stored in the format
`YYYYMMDDhhmmss`. But actually we want to set a (millisecond) UNIX
timestamp here, so we need to use `UNIX_TIMESTAMP()` instead.
2024-03-18 10:22:35 +01:00
Julian Brost
653f356123 Increase database schema version
The removal of the `NOT NULL` constraint on `customvar_flat`.`flat_value` makes
the schema upgrade a hard requirement for 1.1.1.
2023-08-07 13:09:01 +02:00
Julian Brost
7a2ab2dff1 Schema: merge 1.2.0.sql upgrades into 1.1.1.sql
Initially, we planed a 1.2.0 release instead of 1.1.1 so over time, both schema
upgrade files appeared. Merge them to clean up in preparation for the 1.1.1
release.

Changes were generated using these commands:

    { echo; cat schema/mysql/upgrades/1.2.0.sql } >> schema/mysql/upgrades/1.1.1.sql
    { echo; cat schema/pgsql/upgrades/1.2.0.sql } >> schema/pgsql/upgrades/1.1.1.sql
    git rm schema/mysql/upgrades/1.2.0.sql
    git rm schema/pgsql/upgrades/1.2.0.sql
2023-08-07 13:09:01 +02:00
Alexander A. Klimov
cde27fd608 schema: notification: enlarge name and name_ci 255 -> 767 2023-05-23 15:36:17 +02:00