Newer
Older
mailpiler / util / db-upgrade-0.20-vs-0.21.sql
@SJ SJ on 28 Aug 2012 385 bytes improved the expert search
alter table `sph_index` add column `folder` int default 0;

create table if not exists `folder` (
   `id` int not null auto_increment,
   `parent_id` int default 0,
   `name` char(64) not null unique,
   primary key (`id`)
) Engine=InnoDB;

create table if not exists `notes` (
   `id` bigint unsigned not null,
   `note` text default null,
   key `notes_idx` (`id`)
) ENGINE=InnoDB;