53 lines
2.0 KiB
SQL
53 lines
2.0 KiB
SQL
-- Table structure for meet_requests
|
|
CREATE TABLE IF NOT EXISTS `meet_requests` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`topic` varchar(255) NOT NULL,
|
|
`meet_date` date NOT NULL,
|
|
`start_time` time NOT NULL,
|
|
`end_time` time NOT NULL,
|
|
`meet_link` varchar(255) NOT NULL,
|
|
`created_by` varchar(50) NOT NULL,
|
|
`created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
|
|
-- Table structure for system_settings
|
|
CREATE TABLE IF NOT EXISTS `system_settings` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`setting_name` varchar(100) NOT NULL,
|
|
`setting_value` text,
|
|
`updated_by` varchar(50) DEFAULT NULL,
|
|
`updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
|
|
PRIMARY KEY (`id`),
|
|
UNIQUE KEY `setting_name` (`setting_name`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
|
|
-- Insert default settings
|
|
INSERT IGNORE INTO `system_settings` (`setting_name`, `setting_value`) VALUES
|
|
('google_client_id', ''),
|
|
('google_client_secret', ''),
|
|
('google_api_key', '');
|
|
|
|
-- Table structure for system_logs
|
|
CREATE TABLE IF NOT EXISTS `system_logs` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`user_id` varchar(50) NOT NULL,
|
|
`user_name` varchar(255) NOT NULL,
|
|
`action` varchar(100) NOT NULL,
|
|
`detail` text,
|
|
`ip_address` varchar(50) DEFAULT NULL,
|
|
`created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
|
|
-- Table structure for system_users (Role-Based Access Control)
|
|
CREATE TABLE IF NOT EXISTS `system_users` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`cid` varchar(13) NOT NULL,
|
|
`role` enum('superadmin', 'admin') NOT NULL DEFAULT 'admin',
|
|
`created_by` varchar(13) DEFAULT NULL,
|
|
`created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
PRIMARY KEY (`id`),
|
|
UNIQUE KEY `cid` (`cid`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|