- Code: Select all
-- Database: `phplist`
--
-- --------------------------------------------------------
--
-- Tabel structuur voor tabel `phplist_mail2list_allowsend`
--
CREATE TABLE phplist_mail2list_allowsend (
id int(11) NOT NULL auto_increment,
email varchar(255) NOT NULL,
name varchar(255) NOT NULL,
sent int(50) NOT NULL default '0',
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
--
-- Tabel structuur voor tabel phplist_mail2list_list
--
CREATE TABLE phplist_mail2list_list (
listid int(10) NOT NULL,
toemail varchar(255) NOT NULL,
template int(10) NOT NULL,
footer text NOT NULL,
PRIMARY KEY (listid)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Tabel structuur voor tabel phplist_mail2list_popaccounts
--
CREATE TABLE phplist_mail2list_popaccounts (
listid int(10) NOT NULL,
host varchar(255) NOT NULL,
port varchar(255) NOT NULL,
login varchar(50) NOT NULL,
pass varchar(50) NOT NULL,
mail_status varchar(10) NOT NULL default '0/0',
queue varchar(3) NOT NULL default 'yes',
del_message varchar(3) NOT NULL default 'yes',
PRIMARY KEY (listid)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
In this version the quotes are gone.
I use MySQL v5.x, maybe that is the problem.