> there is a very little mistake in the script - here the version which fits for me:
> ....
> db_do("DROP TABLE IF EXISTS `acks`;");
> db_do("CREATE TABLE `acks` (
> `computer` varchar(255) NOT NULL,
> `domain` varchar(255) default NULL,
> `log` varchar(255) NOT NULL,
> `source` varchar(255) NOT NULL,
> `eventID` int(11) NOT NULL,
> `timePeriod` int(11) default NULL, <-- added a comma
> `comment` varchar(1024) default NULL
> ) ENGINE=InnoDB DEFAULT CHARSET=latin1;");
>
> Thanks for your efforts
> sct
Zip file now fixed (01/19/2008).
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Message from "sct":
> there is a very little mistake in the script - here the version which fits for me:
> ....
> db_do("DROP TABLE IF EXISTS `acks`;");
> db_do("CREATE TABLE `acks` (
> `computer` varchar(255) NOT NULL,
> `domain` varchar(255) default NULL,
> `log` varchar(255) NOT NULL,
> `source` varchar(255) NOT NULL,
> `eventID` int(11) NOT NULL,
> `timePeriod` int(11) default NULL, <-- added a comma
> `comment` varchar(1024) default NULL
> ) ENGINE=InnoDB DEFAULT CHARSET=latin1;");
>
> Thanks for your efforts
> sct
Zip file now fixed (01/19/2008).