CREATE TABLE twig_folders (
   id int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
   owner varchar(20) NOT NULL,
   server varchar(255) NOT NULL,
   port int(11) DEFAULT '0' NOT NULL,
   groupname varchar(255) NOT NULL,
   username varchar(20),
   password varchar(20),
   servertype varchar(10),
   PRIMARY KEY (id),
   KEY id (id),
   UNIQUE id_2 (id),
   KEY owner (owner),
   KEY owner_2 (owner),
   KEY groupname (groupname)
);

CREATE TABLE twig_news_prefs (
   id int(11) DEFAULT '0' NOT NULL auto_increment,
   owner varchar(20) NOT NULL,
   replyto text NOT NULL,
   pagesize int(11) DEFAULT '0' NOT NULL,
   newwindow int(11) DEFAULT '1' NOT NULL,
   PRIMARY KEY (id),
   KEY id (id, owner),
   UNIQUE id_2 (id)
);