Tyler

Thanks for your reply. I'd been waiting for an email message, but it never came. I'll have to figure out how to subscribe to my posts. Anyway, I still couldn't get varbinary to show up in my dropdown list, so I took another stab at creating the tables 1x1. I figured out what the error was. In the book there's a new line arrow that shows when a line of text wraps to a new line. When I removed that the error went away. I was able to create all the tables by pasting them into the sql box and pass did get set to varbinary(32). So even tho it wasn't an option, it did get set properly. Thanks!

I'm having a bit of trouble creating the tables for the knowledge is power example site. I'm using phpMyAdmin 3.3.9.2 in MAMP 1.9.6 on a Mac. MySQL version 5.5.9 First I tried to copy/paste the code from my digital copy of the book, but I got errors. So I decided to work through adding the tables manually and I got stuck. I'm not an expert on database design. I was doing ok until I got to the users table where it asks for a pass with a type of varbinary(32). I don't seem to have varbinary as an option in my dropdown list. The only differences I can see between what the book says to create and what I've created is the dabase engine. My install of phpMyAdmin defaults to InnoDB instead of MyISAM and I didn't notice this until after I had started creating tables. Do I need to change to MyISAM to see varbinary, or has varbinary been deprecated in my version of phpmyadmin/mysql? If so, what should I use in it's place for the password? Also, you show some fields as "PRIMARY KEY" (which I understand), some as "UNIQUE", and others as "KEY" in the book. KEY isn't an option in my list of dropdowns (I have PRIMARY, UNIQUE, INDEX, and FULL TEXT). I assume you're meaning for these keys to be used as foreign keys. If so, do I use INDEX for them? Again, I'm not an expert on DB design, so thanks in advance for the help!