'id', 'type' => 'bigint', 'length' => '20', 'unsigned' => true, 'extra' => 'auto_increment', 'sortable' => true, ), // Foreign reference to wp_acrossai_mcp_servers.id (no physical FK). array( 'name' => 'server_id', 'type' => 'bigint', 'length' => '20', 'unsigned' => true, 'searchable' => true, ), // Ability name (\WP_Ability::get_name()). 191 chars fits UNIQUE // composite key under InnoDB utf8mb4 767-byte key limit. array( 'name' => 'ability_slug', 'type' => 'varchar', 'length' => '191', 'default' => '', 'searchable' => true, ), // Set by BerlinDB `created` timestamping on INSERT. array( 'name' => 'created_at', 'type' => 'datetime', 'created' => true, 'date_query' => true, 'sortable' => true, ), // Set by BerlinDB `modified` timestamping on every UPDATE. // NB: the flag is `modified`, NOT `date_updated` — an unrecognized // name silently becomes a dynamic property and trips PHP 8.2 // "Creation of dynamic property" deprecations (B21). array( 'name' => 'updated_at', 'type' => 'datetime', 'modified' => true, ), ); /** * Array of index definitions. * * BerlinDB v3 requires the PRIMARY KEY to be declared as an explicit Index * entry — the `primary` column flag is query-layer only, not DDL. * * `server_ability` UNIQUE enforces the presence-based correctness * invariant at the DB level: at most one row per (server, ability) pair. * * @var array */ public $indexes = array( array( 'name' => 'primary', 'type' => 'primary', 'columns' => array( 'id' ), ), array( 'name' => 'server_ability', 'type' => 'unique', 'columns' => array( 'server_id', 'ability_slug' ), ), array( 'name' => 'server_id', 'type' => 'key', 'columns' => array( 'server_id' ), ), ); }