Run #10

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

{
  "specs": "ALTER TABLE: ajouter colonne entity_score numeric(6,2) NOT NULL DEFAULT 0 AVEC index btree DESC pour ranking. PAS de CREATE 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 agencecom.MemoryEntityKind 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 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
-- Création du schéma si nécessaire
CREATE SCHEMA IF NOT EXISTS agencecom;

-- Création du type enum (placeholder, à adapter selon vos valeurs réelles)
DO $$
BEGIN
    CREATE TYPE agencecom.MemoryEntityKind AS ENUM ('PLACEHOLDER');
EXCEPTION
    WHEN duplicate_object THEN NULL;
END
$$;

-- Création de la table si elle n'existe pas
CREATE TABLE IF NOT EXISTS agencecom.memory_entities (
    id              uuid NOT NULL DEFAULT gen_random_uuid(),
    kind            agencecom.MemoryEntityKind 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      timestamp with time zone NOT NULL DEFAULT now(),
    updated_at      timestamp with time zone NOT NULL DEFAULT now(),
    PRIMARY KEY (id)
);

-- Assurance que la clé primaire existe même si la table existait déjà sans PK
DO $$
BEGIN
    IF EXISTS (
        SELECT 1
        FROM information_schema.tables
        WHERE table_schema = 'agencecom'
          AND table_name = 'memory_entities'
    ) AND NOT EXISTS (
        SELECT 1
        FROM pg_index i
        JOIN pg_class c ON i.indrelid = c.oid
        JOIN pg_namespace n ON c.relnamespace = n.oid
        WHERE n.nspname = 'agencecom'
          AND c.relname = 'memory_entities'
          AND i.indisprimary
    ) THEN
        ALTER TABLE agencecom.memory_entities ADD PRIMARY KEY (id);
    END IF;
END
$$;
```