chpark
0e549cad46
Original PHP source rsync'd from production server (slot-ss.com) on 2026-04-27. Excluded from import: - data/editor (74GB user uploads), data/file (8.5GB attachments) - data/member_image, vendor/, db100up/, caches/sessions/logs/tmp Includes: - 11,636 files, ~206MB source code (gnuboard5 v5.6.6, Eyoom builder, YoungCart 4) - 28 plugins (bacara, chatbot, cron, swiunApi, sns, sms5, ...) - Active theme: eb4_maga_005 (Eyoom magazine layout) - Local Docker dev stack (PHP 7.4 + Apache + Redis + MariaDB) under docker/ - PostgreSQL migration setup (pgloader configs) under db/ - Architecture/migration docs under docs/ Single non-source patch: src/config.php now reads G5_DOMAIN_OVERRIDE env var so the local Docker stack can serve at http://localhost:8088 without touching the production constant. Falls back to https://slot-ss.com when unset.
41 lines
1.7 KiB
Fish
41 lines
1.7 KiB
Fish
LOAD DATABASE
|
|
FROM mysql://root:rootpass@127.0.0.1:33306/inspection2
|
|
INTO postgresql:///slot
|
|
|
|
WITH include drop, create tables, create indexes, reset sequences,
|
|
workers = 4, concurrency = 1,
|
|
multiple readers per thread, rows per range = 50000,
|
|
preserve index names
|
|
|
|
SET MySQL PARAMETERS
|
|
net_read_timeout = '600',
|
|
net_write_timeout = '600'
|
|
|
|
SET PostgreSQL PARAMETERS
|
|
maintenance_work_mem to '512MB',
|
|
work_mem to '64MB'
|
|
|
|
CAST type tinyint to smallint drop typemod,
|
|
type smallint to smallint drop typemod,
|
|
type mediumint to integer drop typemod,
|
|
type integer to integer drop typemod,
|
|
type int to integer drop typemod,
|
|
type bigint to bigint drop typemod,
|
|
type tinyint when unsigned to smallint drop typemod,
|
|
type smallint when unsigned to integer drop typemod,
|
|
type mediumint when unsigned to integer drop typemod,
|
|
type int when unsigned to bigint drop typemod,
|
|
type bigint when unsigned to bigint drop typemod,
|
|
type float to real drop typemod,
|
|
type double to float8 drop typemod,
|
|
type year to integer drop typemod,
|
|
type set to text drop typemod,
|
|
type enum to text drop typemod,
|
|
type datetime to timestamptz drop default drop not null using zero-dates-to-null,
|
|
type timestamp to timestamptz drop default drop not null using zero-dates-to-null,
|
|
type date to date drop default drop not null using zero-dates-to-null
|
|
|
|
BEFORE LOAD DO
|
|
$$ CREATE EXTENSION IF NOT EXISTS pg_trgm; $$,
|
|
$$ CREATE EXTENSION IF NOT EXISTS unaccent; $$;
|