close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues


SecurityAssist 'users.sql' file

Thread began 10/01/2009 2:01 pm by neil186288 | Last modified 10/02/2009 8:12 am by jenkolaka19379118 | 1970 views | 7 replies |


SecurityAssist 'users.sql' file

Dear Jason, Ray or Anna,

Please could you help us out a little bit when you get a moment?

When you purchase Security Assist, there are some tutorials to work through which use the blue_sky_music.sql database as the practice database.

In the tutorial videos it refers to a 'users' table which is required to proceed with the tutorial. The blue_sky_music.sql doesn't have a 'users' table, and the solution pack available from WITHIN the SecurityAssist support files page doesn't contain a 'users.sql' file to help create the table.

Maybe this is intentional to encourage us to investigate creating tables in mySql ourselves, but it might be useful to have the SQL included in the pack that is available from WITHIN the SecurityAssist support files area - or better still, to have the table already available in the blue_sky_music.sql so that the tutorial videos may be followed through without having to sort this out.

I have been adapting the users.sql available in the User Registration Solution Pack which is a seperate download (for me, anyway) on my mywebassist/downloadcenter page.

It just took quite a while to find it. I think this would be helpful.


Sign in to reply to this post

Jason ByrnesWebAssist

You can use the Visitors table that is included in the Blue Sky music SQL file.

Sign in to reply to this post

Neil Beadle


We have a number of different Solution Recipes for our products that use the Blue Sky Music database. However, some of these Solution Recipes were created quite a long time ago, and the database may have changed slightly. In most cases, a simple question such as "where is the users table?" here on the forums, would guide you in the appropriate direction. You should probably avoid directing posts to specific WebAssist employees since there are a number of Community Experts here that could be helpful and get you a response faster.

Also, keep in mind that the User Registration Solution Pack, is not included with the purchase of SecurityAssist or the Extension Library, so the Solution Recipes for SecurityAssist may not lineup perfectly with the database the Solution Pack uses. Although, the process should be the same, and you should still be able to succeed.

We are working hard to improve documentation and streamline Solution Recipes to be more helpful. However, we have a lot of them and they can take some time to update, so you may still see some minor inconsistencies in the near future.

Sign in to reply to this post


Thanks for that.

Many thanks Neil,

I appreciate your reply, informative, helpful, and explaining the situation without making me feel like an idiot. The problem I have been having - and why I have been getting so wound up in regard to:

Originally Said By: Neil Beadle
  In most cases, a simple question such as "where is the users table?" here on the forums, would guide you in the appropriate direction.  

can be demonstrated - I think - at this thread: showthread.php?t=4994 , where such an enquiry leads to a maze of misinformation - and not the straight-forward informative reply that you suggest. I admit to my part in that.

I think you are absolutely right, and in any thread, a reply like yours will be entirely welcome and appreciated by me. It just doesn't seem to pan out that way with some of the other threads.

Anyway, thanks for that. Now I have to go off and contemplate the depressing prospect of climbing off my high-horse and showing a little humilty following some disaterously over-reactionary posts I've made, and (still only slightly at this early stage) regret.


Neil H

Sign in to reply to this post

Office Guy-172461

Well I'm just a little tired of you playing judge and jury over the competence of the people trying to help, so I'm going to spend my time elsewhere until you get yourself straightened out. It's impossible to carry on a helpful thread with someone when someone else keeps butting in and derailing it.

Sorry we don't live up to your standards.

Sign in to reply to this post


To Neil,

I had a bit of confusion with this too, but I cannot ever criticize the web assist team because they are the most helpful compared to other sites that I have downloaded extensions from. Most of the other companies don't even have a help forum, or help of any kind, I won't give names.

Anyway I worked out that the solution recipie uses two different sites.

The first section of the solution recepie "security assist wizard tutoral" uses the users table that is unfortunately not available for download. This section of the tutorial describes the process of allowing users to register themselves on the site.

The second section of the solution recipie "access levels" uses a visitor table and has it's pages created by data assist. This is for if you want to control user registration and assign password and user names for user. When creating the pages this way you would need to assign SHAI ENCRYPTION during the data assist wizard and afterwards use security assist wizard to create the login and logout pages.

But back to the main issue you can recreate the user table like this

log into mysql adminstrator>
create a new table>

the table field look roughly like this

userID Not Null INTEGER Auto Increment PRIMARY KEY
firstname Not Null VARCHAR(60)
lastname Not Null VARCHAR(60)
username Not Null VARCHAR(60)
password Not Null VARCHAR(40)
userLevel Not Null INTEGER

userLevel will be a foriegn key, so you would also need to create the userLevel table

userLevelID Not Null INTEGER Auto Increament PRIMARY KEY
description Not Null VARCHAR(100)

the user level entries should be-

1. Visitors
2. Power Users
3. Administrators

This is how access values are recognised when you apply access levels.

Hope this helps

Sign in to reply to this post


Many thanks for that jenkolaka,

I'll save this post for a little later. I'm not sure people understand just how technically incapable I am. I haven't got to grips with foreign keys and the like yet, but have ordered a couple of books to hopefully get me going!

(I honestly didn't expect to have to know this stuff).

I'll have another bash at it when I learn a bit more from the books, and feel able to ask questions here in the hope of understanding the answers.

Your post looks like it will be perfect for when that time (hopefully) comes. I have copied and pasted it into a text file, and put it in my Security Assist folder for later. I appreciate the time and attention you put into it.

Office Guy,

Helpful threads are all I'm after. I'm sorry you see a search for clarity as butting in and derailment. I can't help that; perhaps when you're less tired, you will be able to appreciate that. As I've said before, I do appreciate the help you've given and your input to the threads. Incidentally, in the thread I assume you are referring to, my input resulted in confirmation that a certain file - referred to in a tutorial - did not in fact exist, and successfully elicited advice on an alternative solution, whereas your input comprised insisting that the non-existent file did in fact exist. So I'm confused as to your definition of derailment. Perhaps you should review it. You should perhaps also say 'I' rather than 'we' regarding standards.

Neil H

Sign in to reply to this post


Your welcome Neil,

If you need any more help, just post. I am a beginner too so it may be easier to explain things more in-depth simply because I know the exact problem you are having.

Good Luck

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question





Ease of use


security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...