<filename>db/db_sampledata.sql
#Creates Administrator account
INSERT INTO `user_signin`(`userid`, `account_type`, `email`, `password`, `created_on`) VALUES ('1', 'administrator', '<EMAIL>', <PASSWORD>', '0000-00-00 00:00:00');
INSERT INTO `user_fee`(`userid`, `fee_amount`, `created_on`) VALUES ('1', '0.00', '0000-00-00 00:00:00');
INSERT INTO `user_detail`(`userid`, `studentno`, `firstname`, `surname`, `gender`, `dateofbirth`, `phonenumber`, `degree`, `address1`, `address2`, `town`, `city`, `country`, `postcode`, `user_status`, `created_on`) VALUES ('1','1','Adminstrator','', 'male', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'active', '0000-00-00 00:00:00');
INSERT INTO `user_token`(`userid`, `token`, `created_on`) VALUES ('1', NULL, '0000-00-00 00:00:00');