Question regarding creating tables command line

[eternalprophet]

Hello everyone.

I am in the process of creating a way to keep track of items gardened in the MMORPG Final Fantasy XI that I avidly play.

I want to make the system automated so that it will create the tables for you, and this is my first shot ever at doing that. Can anyone tell me if this is right please?

#Create the database.#
#The default database name is ffxiGardenTracker#

CREATE DATABASE ffxiGardenTracker;

#Command to use the database you just created#

Use ffxiGardenTracker;

#Create the table. ffxigtMain is the default name.#

CREATE TABLE ffxigtMain (id TINYINT UNSIGNED DEFAULT NULL AUTO_INCREMENT PRIMARY KEY,
charName varchar(20) NOT_NULL,
pot varchar(20),
seed varchar(25),
plant_date DATE,
plant_day VARCHAR(20),
plant_moon VARCHAR(25),
plant_moon_percent TINYINT UNSIGNED,
crystal1 VARCHAR(12),
crystal1_date DATE,
crystal1_day VARCHAR(20),
crystal1_moon VARCHAR(25),
crystal1_moon_percent TINYINT UNSIGNED,
crystal2 VARCHAR(12),
crystal2_date DATE,
crystal2_day VARCHAR(20),
crystal2_moon VARCHAR(25),
crystal2_moon_percent TINYINT UNSIGNED,
harvest_date DATE,
harvest_day VARCHAR(20),
harvest_moon VARCHAR(25),
harvest_moon_percent TINYINT UNSIGNED,
yield VARCHAR(30),
yield_quantity TINYINT UNSIGNED);

#Create the table that will contain the names of your characters#

CREATE TABLE charName (id TINYINT UNSIGNED DEFAULT NULL AUTO_INCREMENT PRIMARY KEY,
charName VARCHAR(25));

#END OF TABLE AND DB CREATION#

#BEGIN POPUlATION OF A FEW ROWS#
#PLEASE NOTE YOU CAN DELETE THESE THROUGH THE ADMIN PAGE#

INSERT INTO ffxigtMain Values (
,"Porcelain", "Tree Cuttings", 20041010, "Windsday",,, "Fire", 20041015, "Firesday", "NOT RECORDED", ,
"Fire", 20041015, "Firesday", , , 20041020, "Windsday", , , "Tree Sapling", 2);

INSERT INTO charName Values ( , "TestChar");

Above, I am wondering if my syntax is correct, and also when I am inserting the values, are the above insert statements correct for inserting nothing into the primary key field? Just start with ( , field2, field3, etc)

I would appreciate any help.

[eternalprophet]

Fixed, I had to use '' for the primary key field and I switched all my " to '.