MySQL code: /** this is the php code */ db_query( "CREATE TABLE {table0} ( f01 varchar(10) NOT NULL default '', f02 varchar(50) NOT NULL default '', f03 float NOT NULL default '0.0', f04 float NOT NULL default '0.0', f05 float NOT NULL default '0.0', f06 float NOT NULL default '0.0', f07 float NOT NULL default '0.0', f08 int(10) NOT NULL default '0.0', f09 varchar(10) NOT NULL, f10 varchar(8) NOT NULL, f11 int(10) NOT NULL default '0', UNIQUE KEY symbol (symbol) ) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */;"); PostgreSQL code: db_query( "CREATE TABLE table0 ( f01 varchar(10) NOT NULL default '', f02 varchar(50) NOT NULL default '', f03 float8 NOT NULL default '0.0', f04 float8 NOT NULL default '0.0', f05 float8 NOT NULL default '0.0', f06 float8 NOT NULL default '0.0', f07 float8 NOT NULL default '0.0', f08 integer NOT NULL default '0.0', f09 varchar(10) NOT NULL, f10 varchar(8) NOT NULL, f11 integer NOT NULL default '0', PRIMARY KEY (f01) ) /*!40100 DEFAULT CHARACTER SET utf8 */;");