CREATE TABLE users (

id INT AUTO_INCREMENT PRIMARY KEY,

username VARCHAR(50) NOT NULL,

password VARCHAR(255) NOT NULL,

role ENUM('admin', 'teacher') DEFAULT 'teacher'

);

CREATE TABLE projects (

id INT AUTO_INCREMENT PRIMARY KEY,

title VARCHAR(255) NOT NULL,

description TEXT,

status ENUM('pending', 'approved', 'rejected') DEFAULT 'pending',

user_id INT,

FOREIGN KEY (user_id) REFERENCES users(id)

);

]]>

from flask import Flask, request, jsonify

app = Flask(__name__)

@app.route('/project/submit', methods=['POST'])

def submit_project():

data = request.get_json()

# Insert into database logic here

return jsonify({"message": "Project submitted successfully"}), 201

if __name__ == '__main__':

app.run(debug=True)

實(shí)訓(xùn)實(shí)習(xí)管理系統(tǒng)

]]>