Answer to Question #238092 in HTML/JavaScript Web Application for Owen

Question

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)

);

Answer 1

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)