mysql create table error

[wadro21]

can someone tell me what is wrong with this?

Error
SQL query:

CREATE TABLE uploads(
 
upload_id int( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
file_name VARCHAR( 30 ) NOT NULL ,
file_size INT( 6 ) UNSIGNED NOT NULL ,
file_type VARCHAR( 30 ) NOT NULL ,
description VARCHAR( 100 ) DEFAULT NULL ,
date_entered TIMESTAMP,
PRIMARY KEY ( upload_id ) ,
KEY ( file_name ) ,
KEY ( date_entered ) 
) CREATE TABLE urls(
url_id SMALLINT( 4 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
url VARCHAR( 60 ) NOT NULL ,
title VARCHAR( 60 ) NOT NULL ,
description SMALLTEXT NOT NULL ,
PRIMARY KEY ( url_id ) 
) CREATE TABLE url_categories(
url_category_id SMALLINT( 3 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
category VARCHAR( 20 ) NOT NULL ,
PRIMARY KEY ( url_category_id ) 
) CREATE TABLE url_associations(
ua_id SMALLINT( 4 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
url_id SMALLINT( 4 ) UNSIGNED NOT NULL ,
url_category_id TINYINT( 3 ) UNSIGNED NOT NULL ,
date_submitted TIMESTAMP,
approvedCHAR( 1 ) DEFAULT 'N' NOT NULL ,
PRIMARY KEY ( ua_id ) 
) 
 

MySQL said:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE urls (
url_id SMALLINT(4) UNSIGNED NOT NULL AUTO_INCREMENT, url VA' at line 7

[pbmods]

Heya, Wadro.

There are two things wrong with the code you posted:

• You didn't use CODE tags. Bad!
• You're missing a semicolon after each table declaration.

[wadro21]

Thanks again!

i will try to remember to put my code in tages next time.