RootZanli & NinjaCr3

: / home / o5t6x7pgljbm / public_html / admin / sqls /

Filename : doculocker_changes.sql

back

-- composer command: composer require league/flysystem-aws-s3-v3 "^3.0"
CREATE TABLE docu_lockers (
    locker_id INT AUTO_INCREMENT PRIMARY KEY,
    locker_uuid VARCHAR(250) UNIQUE,
    user_id INT,
    max_storage_mb DECIMAL(15, 3) DEFAULT 0,
    total_storage_mb DECIMAL(15, 3) DEFAULT 0,
    created_at DATETIME,
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    deleted_at DATETIME
);

CREATE TABLE uploaded_documents (
    document_id INT AUTO_INCREMENT PRIMARY KEY,
    document_uuid VARCHAR(250) UNIQUE,
    locker_id INT,
    user_id INT,
    storage_type ENUM('LOCAL','S3'),
    s3_file_handle VARCHAR(250),
    local_file_url VARCHAR(500),
    file_name VARCHAR(250),
    file_extension VARCHAR(50),
    file_type VARCHAR(250),
    file_source ENUM('UPLOADED'),
    file_source_details_json TEXT,
    created_at DATETIME,
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    deleted_at DATETIME
);