WMSlite/WmsLite.Api/Database/migrations/002_location_add_grid_status.sql
zhougf fa1b286463 Add WmsLite monorepo with JWT auth, tenant context, and project READMEs.
Implement API security baseline (sys_user, JWT, audit fields, transactions,
unique constraints) and Web real login with 401 handling. Document setup
and development workflows in root, WmsLite.Api, and WmsLite.Web README files.

Co-authored-by: Cursor <cursoragent@cursor.com>
2026-05-24 14:17:47 +08:00

20 lines
998 B
SQL

-- 已有 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;