Jay Brown
c10fa98d0a
Restore original migrations (001-120) to fix schema_migrations version mismatch * Restore original migrations (001-120) to fix schema_migrations version mismatch The previous migration collapse broke deployed databases because: - Dev database was at version 120 (the real remove_text_extraction migration) - Main had collapsed migrations (001-012) + stub files (119_stub, 120_stub) - The migrate tool couldn't find version 119/120 with matching content This commit restores the original 27 migrations (versions 001-120) from before the collapse, ensuring backward compatibility with existing databases.
38 lines
794 B
PL/PgSQL
38 lines
794 B
PL/PgSQL
CREATE EXTENSION IF NOT EXISTS "pgcrypto";
|
|
|
|
create or replace function uuid_generate_v7()
|
|
returns uuid
|
|
as $$
|
|
select encode(
|
|
set_bit(
|
|
set_bit(
|
|
overlay(uuid_send(gen_random_uuid())
|
|
placing substring(int8send(floor(extract(epoch from clock_timestamp()) * 1000)::bigint) from 3)
|
|
from 1 for 6
|
|
),
|
|
52, 1
|
|
),
|
|
53, 1
|
|
),
|
|
'hex')::uuid;
|
|
$$
|
|
language SQL
|
|
volatile;
|
|
|
|
CREATE FUNCTION isInVersion(
|
|
_version int,
|
|
_addedVersion int,
|
|
_removedVersion int
|
|
)
|
|
RETURNS boolean as $$
|
|
BEGIN
|
|
RETURN _version is null OR (
|
|
_version >= _addedVersion AND
|
|
(_removedVersion is null OR _version < _removedVersion)
|
|
);
|
|
END;
|
|
$$ LANGUAGE plpgsql;
|
|
|
|
CREATE DOMAIN unsignedsmallint AS SMALLINT
|
|
CHECK (VALUE >= 0);
|