Run #11

{
  "ok": false,
  "failed": [
    "hallucinated_tables:update_updated_at_column"
  ],
  "hallucinated": [
    "update_updated_at_column"
  ],
  "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 de la table principale
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()
);

-- Commentaires sur la table et les colonnes (idempotents)
COMMENT ON TABLE agencecom.memory_entities IS 'Entités mémoire';
COMMENT ON COLUMN agencecom.memory_entities.id IS 'Identifiant unique généré automatiquement';
COMMENT ON COLUMN agencecom.memory_entities.kind IS 'Type de l''entité mémoire';
COMMENT ON COLUMN agencecom.memory_entities.name IS 'Nom de l''entité';
COMMENT ON COLUMN agencecom.memory_entities.slug IS 'Slug optionnel';
COMMENT ON COLUMN agencecom.memory_entities.description IS 'Description optionnelle';
COMMENT ON COLUMN agencecom.memory_entities.props IS 'Propriétés au format JSONB';
COMMENT ON COLUMN agencecom.memory_entities.tags IS 'Tableau de tags';
COMMENT ON COLUMN agencecom.memory_entities.active IS 'Indicateur d''activité';
COMMENT ON COLUMN agencecom.memory_entities.source_file_id IS 'Référence vers le fichier source';
COMMENT ON COLUMN agencecom.memory_entities.created_at IS 'Date de création';
COMMENT ON COLUMN agencecom.memory_entities.updated_at IS 'Date de dernière modification';

-- Index de base
CREATE INDEX IF NOT EXISTS idx_memory_entities_kind ON agencecom.memory_entities (kind);
CREATE INDEX IF NOT EXISTS idx_memory_entities_active ON agencecom.memory_entities (active) WHERE active = true;
CREATE UNIQUE INDEX IF NOT EXISTS idx_memory_entities_slug_unique ON agencecom.memory_entities (slug) WHERE slug IS NOT NULL;
CREATE INDEX IF NOT EXISTS idx_memory_entities_tags ON agencecom.memory_entities USING GIN (tags);
CREATE INDEX IF NOT EXISTS idx_memory_entities_props ON agencecom.memory_entities USING GIN (props jsonb_path_ops);
CREATE INDEX IF NOT EXISTS idx_memory_entities_source_file ON agencecom.memory_entities (source_file_id);
CREATE INDEX IF NOT EXISTS idx_memory_entities_created_at ON agencecom.memory_entities (created_at);

-- Fonction de mise à jour automatique de updated_at
CREATE OR REPLACE FUNCTION agencecom.update_updated_at_column()
RETURNS TRIGGER AS $$
BEGIN
    NEW.updated_at = now();
    RETURN NEW;
END;
$$ LANGUAGE plpgsql;

-- Trigger pour la mise à jour automatique (création conditionnelle pour l'idempotence)
DO $$
BEGIN
    IF NOT EXISTS (
        SELECT 1
        FROM pg_trigger
        WHERE tgname = 'update_memory_entities_updated_at'
          AND tgrelid = 'agencecom.memory_entities'::regclass
    ) THEN
        CREATE TRIGGER update_memory_entities_updated_at
        BEFORE UPDATE ON agencecom.memory_entities
        FOR EACH ROW
        EXECUTE PROCEDURE agencecom.update_updated_at_column();
    END IF;
END
$$;

-- Si des politiques RLS existent, les supprimer avant de les recréer (précaution)
-- (Aucune politique définie ici car les spécifications manquent)
-- Exemple : DROP POLICY IF EXISTS ... ON agencecom.memory_entities;
```