mySQL table help

[Anon]

Okay, I'm very unfamiliar with creating mySQL tables (stupid me started out using MSaccess on ASP and never learned the "correct way"). The table needs to have the following:

ID |autoincriment
MapReviewer |text field
MapName |text field
MapAuthor |text field
MapSize |text field
MapTerrain |textfield
MapPlayers |textfield
MapCompatibility |textfield
MapRating |number
MapDate |textfield
MapTime |textfield
MapImageLarge |textfield
MapImageSmall |textfield
MapFilename |textfield
MapPublicRates |number
MapPublicTotalRates |number (not null, default value = 10)
MapDescription |memo
MapReview |memo
MapViews |number (not null, default of 0)
MapDownloads |number (not null, default of 0)

Thanks!

[reagent]

start by RTFM
http://www.mysql.com/doc/C/R/CREATE_TABLE.html

I would advise against using auto_increment, although MySQL does support it. Instead, create a "sequences" table that houses all the sequences you will need.

good luck
p.

[stephanie]

Just an example, you have to adjust all fields properties:

<?

CREATE TABLE mytable (
ID int(9) NOT NULL auto_increment,
MapReviewer varchar(250) NOT NULL,
MapName varchar(250) NOT NULL,
MapAuthor varchar(250) NOT NULL,
MapSize varchar(250) NOT NULL,
MapTerrain varchar(250) NOT NULL,
MapPlayers varchar(250) NOT NULL,
MapCompatibility varchar(250) NOT NULL,
MapRating int(3) NOT NULL,
MapDate varchar(250) NOT NULL,
MapTime varchar(250) NOT NULL,
MapImageLarge varchar(250) NOT NULL,
MapImageSmall varchar(250) NOT NULL,
MapFilename varchar(250) NOT NULL,
MapPublicRates int(3) NOT NULL,
MapPublicTotalRates int(3) DEFAULT '10' NOT NULL,
//etc...
PRIMARY KEY (ID)
);

?>

[Anon]

Thanks!