#85 installing the database

[Anonymous]

When inserting the contents of popper.mysql into my
mysql database:

mysql>
mysql> #
mysql> # Table structure for table 'confirmations'
mysql> #
mysql>
mysql> CREATE TABLE confirmations (
-> id int(11) NOT NULL default '0',
-> user_id int(11) NOT NULL default '0',
-> check char(32) default NULL
-> );
ERROR 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 'default NULL
)' at line 4

check is now a reserved word, correct SQL should be:

#
# Table structure for table 'confirmations'
#

CREATE TABLE confirmations (
id int(11) NOT NULL default '0',
user_id int(11) NOT NULL default '0',
`check` char(32) default NULL
);

(or change the field name)

sk8boardkid@gmail.com