[Phpwebsite-developers] SQL error on boost

[Verdon V. <ve...@gm...>]

Hi,

I'm encountering a strange thing while trying to write an install.sql 
file for a module I am working on. I'm hoping fresh eyes might help.

Thanks for any advice. Regards,
verdon


If I run the sql statement below, in phpmyadmin, it works fine. If I 
try to boost instead, I get this generic error

DB Error: syntax error
CREATE TABLE mod_cstconference_applications ( id int NOT NULL default 
'0', regnum int NOT NULL default '0', regstudent tinyint NOT NULL 
default '0', regprov varchar(20) default '', regonline tinyint NOT NULL 
default '0', applicants text, firstname varchar(60) default '', 
lastname varchar(60) default '', organization varchar(255) default '', 
address1 varchar(255) default '', address2 varchar(255) default '', 
city varchar(120) default '', province varchar(60) default '', postal 
varchar(20) default '', phone varchar(60) default '', email 
varchar(120) default '', total ) [nativecode=1064 ** You have an error 
in your SQL syntax. Check the manual that corresponds to your MySQL 
server version for the right syntax to use near ')' at line 1]

This is the sql...

CREATE TABLE mod_cstconference_applications (
   id            int NOT NULL default '0',
   regnum        int NOT NULL default '0',
   regstudent    tinyint NOT NULL default '0',
   regprov       varchar(20) default '',
   regonline     tinyint NOT NULL default '0',
   applicants    text,
   firstname     varchar(60) default '',
   lastname      varchar(60) default '',
   organization  varchar(255) default '',
   address1      varchar(255) default '',
   address2      varchar(255) default '',
   city          varchar(120) default '',
   province      varchar(60) default '',
   postal        varchar(20) default '',
   phone         varchar(60) default '',
   email         varchar(120) default '',
   total         text,
   PRIMARY KEY   (id)
) TYPE=MyISAM;