database.sql

CREATE TABLE IF NOT EXISTS `relationships` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `player1` int(11) NOT NULL,
    `player2` int(11) NOT NULL,
    `status` int(11) NOT NULL DEFAULT '0',
    `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    UNIQUE KEY `unique_relationship` (`player1`,`player2`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE IF NOT EXISTS `relationship_photos` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `relationship_id` int(11) NOT NULL,
    `photo_url` varchar(255) NOT NULL,
    `uploaded_by` int(11) NOT NULL,
    `uploaded_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    KEY `relationship_id` (`relationship_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE IF NOT EXISTS `relationship_gifts` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `relationship_id` int(11) NOT NULL,
    `gift_name` varchar(255) NOT NULL,
    `gifted_by` int(11) NOT NULL,
    `gifted_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    KEY `relationship_id` (`relationship_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;