*** Create Tables CF8

Hi
I am on Mac Pro Intel 10.5
I am trying to learn coldfusion 8 developer edition with flex3
All I want is to create db tables in coldfusion 8. I believe this is a derby db
I have copied a script from Ben Forta site

CREATE TABLE ACTORS (
ACTORID INT NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 21) CONSTRAINT ACTORS_PK PRIMARY KEY,
NAMEFIRST CHAR(50) NOT NULL,
NAMELAST CHAR(50) NOT NULL,
AGE SMALLINT NOT NULL,
NAMEFIRSTREAL CHAR(50) NOT NULL,
NAMELASTREAL CHAR(50) NOT NULL,
AGEREAL SMALLINT NOT NULL,
ISEGOMANIAC SMALLINT NOT NULL,
ISTOTALBABE SMALLINT NOT NULL,
GENDER CHAR(1) NOT NULL
);

Now the silly part part...
I have created the data base from with in CF
It runs fine from localhost in the CF root
I have created a cfm page with cfquery the ben forta code inside, no luck.
<cfquery datasource="database dsn">  
</cfquery>

I have gone iinto flex builder pro 3, query builder pasted it in and execute query no luck

Please how do I create tables in the coldfusion 8 environment.
A step by step would be most grateful as all tutorials seem to skip this part and assume we all know it. I do not and I am not ashamed to say as I want to learn
Please can anyone help. I also have dreamweaver cs3
Thanks in advance
TeeFX