CREATE DATABASE rgi_student;
CREATE TABLE student_reg (
STID INTEGER (4)
USERNAME VARCHAR(30)
PASSWORD HASH CHAR(25)
CONFIRM PASSWORD
FIRSTNAME VARCHAR(30)
SURNAME VARCHAR(30)
EMAIL TEXT
QUALIFICATION VARCHAR(15)
CELL NUMBER INTERGER(10)
GENDER VARCHAR(6)
NATIONALITY VARCHAR(25)
);
Comments
Leave a comment