Adding UserLevel to Visitors table in blue sky music
Hello - this may be a very basic question but it is stopping me moving forward.
Security Assist 1.18
I am following the instructions in the pdf "User Level Authentication" and using MySQL Adminsitrator (Table Editor)
The PDF provides step by step instructions for modifying the Visitors Table and I have reached step 4. For the column name, enter userLevel. and step 5. Click once in the Datatype column, and enter Integer (MySQL)
But in the Visitors table that is downloaded in SA1.18 there is already a cell in column called userLevel and in the Datatype is the value INT(10). In Flags is the value UNSIGNED
Question - should I really be entering a new cell in this table with an identical value (userLevel)
All my database experience would indicate that you can not have two identical field names in a table.
Is this just a case of the PDF not being updated to reflect the fact that the field name has been added in this release or am I missing something really obvious?
Appreciate some advice on this.
Thanks - Don