Hi folks,


I'm following the steps on;
http://wiki.dovecot.org/HowTo/ImapProxy

to create the SQL table. But I can't make it.

mysql> CREATE TABLE proxy (
     -> user varchar(255) NOT NULL,
     -> host varchar(16) defaul NULL,
     -> destuser varchar(255) NOT NULL default '',
     -> PRIMARY KEY (user)
     -> ); 
ERROR 1064 (42000): 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 'defaul NULL,
destuser varchar(255) NOT NULL default '',
PRIMARY KEY (user)
)' at line 3

Again;

mysql> CREATE TABLE `proxy` (
     -> `user` varchar(255) NOT NULL,
     -> `host` varchar(16) defaul 'NULL',
     -> `destuser` varchar(255) NOT NULL default '',     
     -> PRIMARY KEY (`user`)
     -> );
ERROR 1064 (42000): 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 'defaul 'NULL',
`destuser` varchar(255) NOT NULL default '',
PRIMARY KEY (`user`)' at line 3

Please advise what will be correct steps? TIA


B.R.
satimis

`host` varchar(16) defaul 'NULL'

Originally Posted by chrishirst

`host` varchar(16) defaul 'NULL'

Noted with thanks


B.R.
satimis