Wi hdZddlmZdZdZdZdZdZdZd Z d jeeeeeee gZ d d Z y )aRLM Neo-Cortex -- Tenant Partitioning PostgreSQL Schema (Story 6.08). SQL definitions for rlm_tenants and rlm_memories tables with: - Row-Level Security (RLS) policies - Composite indexes for tenant-scoped queries - Content deduplication per tenant - Encryption key hash audit trail Run via Alembic migration or directly against PostgreSQL. VERIFICATION_STAMP Story: 6.08 Verified By: parallel-builder Verified At: 2026-02-26 Tests: 5/5 Coverage: 100% ) annotationsa_ CREATE TABLE IF NOT EXISTS rlm_tenants ( tenant_id UUID PRIMARY KEY, tier VARCHAR(20) NOT NULL DEFAULT 'starter' CHECK (tier IN ('starter', 'professional', 'enterprise', 'queen')), encryption_key_hash VARCHAR(64) NOT NULL, region VARCHAR(20) DEFAULT 'au-east', is_active BOOLEAN DEFAULT TRUE, created_at TIMESTAMPTZ NOT NULL DEFAULT NOW(), updated_at TIMESTAMPTZ NOT NULL DEFAULT NOW() ); CREATE INDEX IF NOT EXISTS ix_rlm_tenants_tier ON rlm_tenants (tier); CREATE INDEX IF NOT EXISTS ix_rlm_tenants_active ON rlm_tenants (is_active); a CREATE TABLE IF NOT EXISTS rlm_memories ( id SERIAL PRIMARY KEY, tenant_id UUID NOT NULL REFERENCES rlm_tenants(tenant_id) ON DELETE CASCADE, content TEXT NOT NULL, content_hash VARCHAR(64) NOT NULL, source VARCHAR(100) NOT NULL, domain VARCHAR(100) NOT NULL, memory_tier VARCHAR(20) NOT NULL DEFAULT 'working' CHECK (memory_tier IN ('discard', 'working', 'episodic', 'semantic')), surprise_score FLOAT DEFAULT 0.0, access_count INTEGER DEFAULT 0, vector_id VARCHAR(100), metadata JSONB, created_at TIMESTAMPTZ NOT NULL DEFAULT NOW(), last_accessed TIMESTAMPTZ NOT NULL DEFAULT NOW(), CONSTRAINT uq_rlm_memory_dedup UNIQUE (tenant_id, content_hash) ); CREATE INDEX IF NOT EXISTS ix_rlm_memories_tenant ON rlm_memories (tenant_id); CREATE INDEX IF NOT EXISTS ix_rlm_memories_hash ON rlm_memories (content_hash); CREATE INDEX IF NOT EXISTS ix_rlm_memories_tier ON rlm_memories (memory_tier); CREATE INDEX IF NOT EXISTS ix_rlm_memories_accessed ON rlm_memories (last_accessed); CREATE INDEX IF NOT EXISTS ix_rlm_memories_tenant_tier ON rlm_memories (tenant_id, memory_tier); z4 ALTER TABLE rlm_tenants ENABLE ROW LEVEL SECURITY; z5 ALTER TABLE rlm_memories ENABLE ROW LEVEL SECURITY; a DO $$ BEGIN IF NOT EXISTS ( SELECT 1 FROM pg_policies WHERE tablename = 'rlm_tenants' AND policyname = 'tenant_isolation_rlm_tenants' ) THEN CREATE POLICY tenant_isolation_rlm_tenants ON rlm_tenants FOR ALL USING (tenant_id::text = current_setting('app.tenant_id', true)) WITH CHECK (tenant_id::text = current_setting('app.tenant_id', true)); END IF; END $$; a DO $$ BEGIN IF NOT EXISTS ( SELECT 1 FROM pg_policies WHERE tablename = 'rlm_memories' AND policyname = 'tenant_isolation_rlm_memories' ) THEN CREATE POLICY tenant_isolation_rlm_memories ON rlm_memories FOR ALL USING (tenant_id::text = current_setting('app.tenant_id', true)) WITH CHECK (tenant_id::text = current_setting('app.tenant_id', true)); END IF; END $$; a CREATE TABLE IF NOT EXISTS rlm_shred_audit ( id SERIAL PRIMARY KEY, tenant_id UUID NOT NULL, shredded_at TIMESTAMPTZ NOT NULL DEFAULT NOW(), memories_shredded INTEGER DEFAULT 0, vectors_deleted INTEGER DEFAULT 0, redis_keys_deleted INTEGER DEFAULT 0, initiated_by VARCHAR(100) DEFAULT 'system', reason TEXT DEFAULT 'right_to_erasure' ); CREATE INDEX IF NOT EXISTS ix_rlm_shred_audit_tenant ON rlm_shred_audit (tenant_id);  cKddl}|j|d{} |jtd{|j d{y7;77 #|j d{7wxYww)zlExecute the full migration against PostgreSQL. Args: pg_dsn: PostgreSQL connection string. rN)dsn)asyncpgconnectexecuteFULL_MIGRATIONclose)pg_dsnrconns 5/mnt/e/genesis-system/core/rlm/partitioning_schema.py run_migrationrs` V, ,Dll>***jjl -*djjlsSA<AA<AAAA<AA<AA<A92A53A99A<N)r strreturnNone) __doc__ __future__rCREATE_TENANTS_TABLECREATE_MEMORIES_TABLEENABLE_RLS_TENANTSENABLE_RLS_MEMORIESCREATE_RLS_POLICY_TENANTSCREATE_RLS_POLICY_MEMORIESCREATE_SHRED_AUDIT_TABLEjoinr rrrsw"#  @"*( r