victorch6/schoolapp

SchoolApp

Login : Admin Pass: Admin1

-- Database: school

-- structure of table for table students

CREATE TABLE students ( firstname text NOT NULL, lastname text NOT NULL, pesel text NOT NULL, email text NOT NULL, faculty text NOT NULL, yearofstudy int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

ALTER TABLE students ADD UNIQUE KEY pesel (pesel(11));

-- Sample Data students

INSERT INTO students (firstname, lastname, pesel, email, faculty, yearofstudy) VALUES ('Ala', 'Makota', '96040414550', '[email protected]', 'Law', 2), ('Tomek', 'Kowalski', '92120212344', '[email protected]', 'Psychology', 3), ('Karol', 'Szklanka', '94010112345', '[email protected]', 'Logistics', 1);