sobersabre

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 */;");