create new database with table

[Manhao Chen]

i'm trying to write a script that creates a new database, and creates tables/store procedures..etc.... for the newly created database, but it seems to only create the database, and not the tables..

CREATE DATABASE this_is_the_database_name;

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `tbl_dynamic_page_trash`
-- ----------------------------
DROP TABLE IF EXISTS `tbl_dynamic_page_trash`;
CREATE TABLE `tbl_dynamic_page_trash` (
`PK_dynamic_page_trash` int(10) NOT NULL AUTO_INCREMENT,
`file_name` varchar(50) NOT NULL,
`dynamic_page_type` varchar(8) NOT NULL,
`FK_sites` int(10) NOT NULL,
PRIMARY KEY (`PK_dynamic_page_trash`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;