Info: The 'created_at' column already exists in the proposals table.
Current Proposals Table Structure:
| Field |
Type |
Null |
Key |
Default |
Extra |
| id | int(11) | NO | PRI | NULL | auto_increment |
| full_name | varchar(255) | NO | | NULL | |
| programme_of_study | varchar(255) | NO | | NULL | |
| level | varchar(50) | NO | | NULL | |
| contact | varchar(15) | NO | | NULL | |
| email | varchar(255) | NO | | NULL | |
| business_idea_title | varchar(255) | NO | | NULL | |
| brief_description | text | NO | | NULL | |
| target_market | text | NO | | NULL | |
| competitors | text | NO | | NULL | |
| market_trends | text | NO | | NULL | |
| initial_capital | varchar(50) | NO | | NULL | |
| required_resources | text | NO | | NULL | |
| skills_needed | text | YES | | NULL | |
| potential_partnerships | text | YES | | NULL | |
| social_impact | text | YES | | NULL | |
| technological_elements | text | YES | | NULL | |
| member1_name | varchar(255) | YES | | NULL | |
| member1_programme | varchar(255) | YES | | NULL | |
| member1_level | varchar(50) | YES | | NULL | |
| member1_email | varchar(255) | YES | | NULL | |
| member2_name | varchar(255) | YES | | NULL | |
| member2_programme | varchar(255) | YES | | NULL | |
| member2_level | varchar(50) | YES | | NULL | |
| member2_email | varchar(255) | YES | | NULL | |
| created_at | timestamp | YES | | current_timestamp() | |