16 lines
619 B
SQL
16 lines
619 B
SQL
CREATE TABLE IF NOT EXISTS project_requests (
|
|
id INT UNSIGNED NOT NULL AUTO_INCREMENT,
|
|
name VARCHAR(120) NOT NULL,
|
|
email VARCHAR(190) NOT NULL,
|
|
company VARCHAR(160) NULL,
|
|
project_type VARCHAR(120) NOT NULL,
|
|
timeline VARCHAR(80) NOT NULL,
|
|
budget VARCHAR(80) NOT NULL,
|
|
details TEXT NOT NULL,
|
|
status VARCHAR(30) NOT NULL DEFAULT 'new',
|
|
created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
PRIMARY KEY (id),
|
|
KEY idx_project_requests_status (status),
|
|
KEY idx_project_requests_created_at (created_at)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|