sudo apt-get update sudo apt-get install apache2 software-properties-common mysql-server sudo add-apt-repository ppa:ondrej/php sudo apt-get install -y php pip install Flask Flask-SQLAlchemy Flask-Login python-barcode openpyxl Flask-Mail Flask-Migrate sudo mysql_secure_installation

CREATE DATABASE rht_tms;

USE rht_tms;

CREATE TABLE students (

cli_ID INT AUTO_INCREMENT PRIMARY KEY, student_ID VARCHAR(255) NOT NULL UNIQUE, student_NAME VARCHAR(255) NOT NULL, student_SNAME VARCHAR(255) NOT NULL, student_GSM VARCHAR(255), student_EMAIL VARCHAR(255) NOT NULL UNIQUE, student_DEP VARCHAR(255) NOT NULL

);

CREATE TABLE event (

event_ID char(10) PRIMARY KEY, event_name VARCHAR(255) NOT NULL, event_date DATE NOT NULL );

CREATE TABLE tickets (

ticket_ID BIGINT PRIMARY KEY, event_ID char(10) NOT NULL, FOREIGN KEY (event_ID) REFERENCES event(event_ID)

);

CREATE TABLE user (

id int(11) NOT NULL AUTO_INCREMENT, username varchar(255) NOT NULL, email varchar(255) NOT NULL, password varchar(255) NOT NULL, role varchar(255) NOT NULL, PRIMARY KEY (id), UNIQUE KEY username (username), UNIQUE KEY email (email)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO user (username, email, password, role) VALUES ('admin', '[email protected]', 'hashed_passwd', 'super_user' );