PHP Classes

File: SQL File

Recommend this page to a friend!
  Packages of Matthew Asham   Binkterm PHP   database/migrations/v1.11.0.75_ai_bot_activities.sql   Download  
File: database/migrations/v1.11.0.75_ai_bot_activities.sql
Role: Auxiliary data
Content type: text/plain
Description: Auxiliary data
Class: Binkterm PHP
Bulletin board system based on the Web
Author: By
Last change:
Date: 5 days ago
Size: 424 bytes
 

Contents

Class file image Download 
CREATE TABLE ai_bot_activities (
    id            SERIAL PRIMARY KEY,
    bot_id        INTEGER NOT NULL REFERENCES ai_bots(id) ON DELETE CASCADE,
    activity_type VARCHAR(50) NOT NULL,
    is_enabled    BOOLEAN NOT NULL DEFAULT TRUE,
    config_json   JSONB,
    created_at    TIMESTAMP NOT NULL DEFAULT NOW(),
    UNIQUE(bot_id, activity_type)
);

CREATE INDEX idx_ai_bot_activities_bot_id ON ai_bot_activities(bot_id);