Configure MySql Database:
mysql> create database springtest; mysql> use springtest;
CREATE TABLE users ( username VARCHAR(45) NOT NULL , password VARCHAR(9999) NOT NULL , email varchar(120) NOT NULL, enabled TINYINT NOT NULL DEFAULT 1 , PRIMARY KEY (username));
CREATE TABLE user_roles ( user_role_id int(11) NOT NULL AUTO_INCREMENT, username varchar(45) NOT NULL, role varchar(45) NOT NULL, PRIMARY KEY (user_role_id), UNIQUE KEY uni_username_role (role,username), KEY fk_username_idx (username), CONSTRAINT fk_username FOREIGN KEY (username) REFERENCES users (username));
CREATE TABLE offers (
id int(11) NOT NULL AUTO_INCREMENT,
name varchar(100) NOT NULL,
email varchar(60) NOT NULL,
text text NOT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
INSERT INTO offers VALUES (1,'Bob','[email protected]','I will write Java for you'),(2,'Mike','[email protected]','Web design, very cheap'),(3,'Sue','[email protected]','PHP coding');