Adding automatically Database Table

[Poring King]

Hello i always encounter this kind of stupid problem when im creating a sql table automatically .

This is my automatic sql

/*
DROP TABLE IF EXISTS `WOE`;
CREATE TABLE `WOE` (
  `test` int(11) unsigned NOT NULL auto_increment,
  `test1` varchar(34) NOT NULL default '',
  `test2` INT(11) NOT NULL,
  `test3` DATETIME NULL,
  `test4` DATETIME NULL,
  `test5` TINYINT(1) NOT NULL,
  `test6` DATETIME NULL,
  PRIMARY KEY (`test`)
) ENGINE=MYISAM DEFAULT CHARSET=utf8;
*/

I tried to use this on my phpmyadmin and its work fine but when i try to put this on npc it would not create .. Any IDEA ? I learn from my mistake so please point it out my mistake ^_^ Thx

[AnnieRuru]

well yes its actually better to create table with phpmyadmin
why use OnInit and access query_sql everytime ? query_sql is a slow operation (a simple line is fine but if having multiple lines you'll start notice the lag)

anyway, I don't recommend using OnInit, but here's the answer

-	script	jsdfksfj	1_F_MARIA,{
OnInit:
	.@query$ = "CREATE TABLE IF NOT EXISTS `blah` ("
	         +   "`id` INT AUTO_INCREMENT PRIMARY KEY,"
	         +   "`points` INT,"
	         +   "`breaktimestamp` DATETIME,"
	         +   "KEY(`points`)"
	         + ") ENGINE = InnoDB;";
	query_sql .@query$;
}

by the way I didn't see your table is index properly
anything that has SELECT <something> FROM `table` WHERE `column` ... this `column` has to be index