Run #9

{
  "ok": false,
  "failed": [
    "hallucinated_tables:memory_entity_kind"
  ],
  "hallucinated": [
    "memory_entity_kind"
  ],
  "context_errors": []
}

{
  "specs": "Add column entity_score numeric(6,2) NOT NULL DEFAULT 0 with btree index DESC for ranking. Use ALTER TABLE.",
  "tables": [
    "memory_entities"
  ]
}

Tu es DBA senior Postgres. Genere migration SQL idempotente.

TABLE agencecom.memory_entities :
  id uuid NOT NULL DEFAULT gen_random_uuid()
  kind USER-DEFINED NOT NULL
  name text NOT NULL
  slug text
  description text
  props jsonb NOT NULL DEFAULT '{}'::jsonb
  tags ARRAY DEFAULT '{}'::text[]
  active boolean NOT NULL DEFAULT true
  source_file_id uuid
  created_at timestamp with time zone NOT NULL DEFAULT now()
  updated_at timestamp with time zone NOT NULL DEFAULT now()

SPECS:
[missing:specs]

REGLES: schema prefix agencecom., IF NOT EXISTS, DO blocks idempotence, DROP IF EXISTS sur policies avant recreate, jamais DROP TABLE sans IF EXISTS et review DG.

REPONDS UNIQUEMENT bloc sql.

```sql
-- Migration idempotente pour agencecom.memory_entities
-- Création du type enum s'il n'existe pas (ajuster les valeurs selon le besoin métier)
DO $$
BEGIN
    IF NOT EXISTS (
        SELECT 1 FROM pg_type t
        JOIN pg_namespace n ON n.oid = t.typnamespace
        WHERE t.typname = 'memory_entity_kind' AND n.nspname = 'agencecom'
    ) THEN
        CREATE TYPE agencecom.memory_entity_kind AS ENUM ('default');
    END IF;
END $$;

-- Création de la table principale (idempotente grâce à IF NOT EXISTS)
CREATE TABLE IF NOT EXISTS agencecom.memory_entities (
    id              uuid NOT NULL DEFAULT gen_random_uuid(),
    kind            agencecom.memory_entity_kind NOT NULL,
    name            text NOT NULL,
    slug            text,
    description     text,
    props           jsonb NOT NULL DEFAULT '{}'::jsonb,
    tags            text[] DEFAULT '{}'::text[],
    active          boolean NOT NULL DEFAULT true,
    source_file_id  uuid,
    created_at      timestamptz NOT NULL DEFAULT now(),
    updated_at      timestamptz NOT NULL DEFAULT now(),
    CONSTRAINT memory_entities_pkey PRIMARY KEY (id)
);

-- Politiques (exemple d'idempotence : DROP IF EXISTS avant CREATE)
-- DROP POLICY IF EXISTS "example_policy" ON agencecom.memory_entities;
-- CREATE POLICY "example_policy" ON agencecom.memory_entities
--     FOR SELECT
--     USING (active = true);
```