| Subject: | Catalyst::Manual::Tutorial::05_Authentication: Typo in Auth DB generation SQL |
Under section
BASIC AUTHENTICATION -> Add Users and Roles to the Database
The sample SQL contains:
<snip>
CREATE TABLE user_role (
user_id INTEGER REFERENCES user(id) ON DELETE CASCADE ON UPDATE CASCADE,
role_id INTEGER REFERENCES role(id) ON DELETE CASCADE ON UPDATE CASCADE,
PRIMARY KEY (user_id, role_id)
);
<snip>
foreign key reference to user(id) is incorrect ('users' table misnamed),
it should be:
"user_id INTEGER REFERENCES users(id) ON DELETE CASCADE ON UPDATE CASCADE,"