-- 已有 location 表时增量添加字段(与 Models/Location 一致) ALTER TABLE location ADD COLUMN IF NOT EXISTS row_no INTEGER NULL; ALTER TABLE location ADD COLUMN IF NOT EXISTS column_no INTEGER NULL; ALTER TABLE location ADD COLUMN IF NOT EXISTS layer_no INTEGER NULL; ALTER TABLE location ADD COLUMN IF NOT EXISTS height NUMERIC(18, 6) NULL; ALTER TABLE location ADD COLUMN IF NOT EXISTS location_status SMALLINT NOT NULL DEFAULT 1; ALTER TABLE location ADD COLUMN IF NOT EXISTS is_outer BOOLEAN NOT NULL DEFAULT FALSE; ALTER TABLE location ADD COLUMN IF NOT EXISTS container_code VARCHAR(64) NULL; DO $$ BEGIN IF NOT EXISTS ( SELECT 1 FROM pg_constraint WHERE conname = 'ck_location_status' ) THEN ALTER TABLE location ADD CONSTRAINT ck_location_status CHECK (location_status IN (1, 2, 3, 4, 5)); END IF; END $$; CREATE INDEX IF NOT EXISTS ix_location_container_code ON location (container_code) WHERE is_deleted = FALSE AND container_code IS NOT NULL;