mirror of
https://github.com/photoprism/photoprism.git
synced 2026-07-18 09:05:25 +00:00
30 lines
1.4 KiB
Go
30 lines
1.4 KiB
Go
package migrate
|
|
|
|
// Generated code, do not edit.
|
|
|
|
var DialectPostgres = Migrations{
|
|
{
|
|
ID: "20241202-000001",
|
|
Dialect: "postgres",
|
|
Stage: "main",
|
|
Statements: []string{"UPDATE auth_users_details SET birth_year = -1 WHERE birth_year >= 0 AND birth_year < 1000 OR birth_year < -1 OR birth_year IS NULL;", "UPDATE auth_users_details SET birth_month = -1 WHERE birth_month = 0 OR birth_month < -1 OR birth_month > 12 OR birth_month IS NULL;", "UPDATE auth_users_details SET birth_day = -1 WHERE birth_day = 0 OR birth_day < -1 OR birth_day > 31 OR birth_day IS NULL;", "UPDATE auth_users_details SET user_country = 'zz' WHERE user_country = '' OR user_country IS NULL;"},
|
|
},
|
|
{
|
|
ID: "20250117-000001",
|
|
Dialect: "postgres",
|
|
Stage: "pre",
|
|
Statements: []string{"ALTER TABLE IF EXISTS photos RENAME COLUMN photo_description TO photo_caption;", "ALTER TABLE IF EXISTS photos RENAME COLUMN description_src TO caption_src;"},
|
|
},
|
|
{
|
|
ID: "20250416-000001",
|
|
Dialect: "postgres",
|
|
Stage: "main",
|
|
Statements: []string{"UPDATE photos SET time_zone = 'Local' WHERE time_zone = '' OR time_zone IS NULL;"},
|
|
},
|
|
{
|
|
ID: "20250819-000001",
|
|
Dialect: "postgres",
|
|
Stage: "post",
|
|
Statements: []string{"CREATE COLLATION IF NOT EXISTS caseinsensitive (provider = icu, locale = 'und', deterministic = false);"},
|
|
},
|
|
}
|