25 lines
999 B
SQL
25 lines
999 B
SQL
CREATE DATABASE IF NOT EXISTS `one_stop_web_service` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
|
|
USE `one_stop_web_service`;
|
|
|
|
CREATE TABLE IF NOT EXISTS `websites` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`name` varchar(255) NOT NULL,
|
|
`url` text NOT NULL,
|
|
`status` enum('normal','cancelled','maintenance') NOT NULL DEFAULT 'normal',
|
|
`logo_url` text NULL,
|
|
`click_count` int(11) NOT NULL DEFAULT 0,
|
|
`display_order` int(11) NOT NULL DEFAULT 0,
|
|
`is_mock` tinyint(1) NOT NULL DEFAULT 0,
|
|
`created_at` timestamp NOT NULL DEFAULT current_timestamp(),
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
|
|
CREATE TABLE IF NOT EXISTS `activity_logs` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`action` varchar(255) NOT NULL,
|
|
`details` text NOT NULL,
|
|
`ip_address` varchar(45) NOT NULL,
|
|
`created_at` timestamp NOT NULL DEFAULT current_timestamp(),
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|