#--source include/have_innodb.inc

drop table if exists `document`;
create table `document` (
  `docid` int(10) unsigned not null auto_increment,
  `chainkey` varchar(32) default null,
  `form` varchar(128) not null default '',
  `creator` varchar(128) not null default '',
  `creation_date` bigint(20) default null,
  `workflow_state` varchar(128) default null,
  `last_modified_by` varchar(128) default null,
  `last_modified_date` bigint(20) default null,
  `timer_date` bigint(20) default null,
  `timer_processed` bigint(20) default null,
  `timer_step` varchar(128) default null,
  `published` int(1) default null,
  `latest` int(1) default null,
  `verion_number` int(2) default null,
  `version_number` int(2) default null,
  primary key  (`docid`),
  key `dockey_index` (`chainkey`),
  key `timer_date_index` (`timer_date`),
  key `timer_processed_index` (`timer_processed`),
  key `idx_document_chainkey_version_number` (`chainkey`,`version_number`)
) engine=innodb default charset=utf8;

lock tables `document` write;
insert into `document` values (1,'a14f8f52419f9411db617edf24e2c0e7','test_view','joe',573516000000,'pending','joe',921189600000,null,null,null,1,1,null,1),(2,'b14f8f52419f9411db617edf24e2c0e7','test_view','joe',573516000000,'exitpoint','joe',889048800000,null,null,null,null,0,null,1),(3,'c14f8f52419f9411db617edf24e2c0e7','test_view','joe',573516000000,'approved','joe',889048800000,null,null,null,null,1,null,1),(4,'d14f8f52419f9411db617edf24e2c0e7','test_view','admin',573516000000,'exitpoint','admin',889048800000,null,null,null,1,1,null,1),(5,'e14f8f52419f9411db617edf24e2c0e7','test_view','christine',649976400000,'pendingmanager','christine',655250400000,null,null,null,null,1,null,1),(6,'f14f8f52419f9411db617edf24e2c0e7','test_view','christine',825717600000,'rejected','joe',857253600000,null,null,null,null,1,null,1),(7,'g14f8f52419f9411db617edf24e2c0e7','test_view','paolo',573516000000,'approved','joe',573516000000,null,null,null,null,1,null,1),(8,'h14f8f52419f9411db617edf24e2c0e7','test_view','paolo',912636000000,'rejected','joe',915141600000,null,null,null,null,1,null,1),(9,'b14f8f52419f9411db617edf24e2c0e7','test_view','paolo',946677600000,'exitpoint','joe',946677600000,null,null,null,1,1,null,2);
unlock tables;

create temporary table if not exists af_vft (rnum int auto_increment primary key, docid bigint) engine = memory;

select count(d_docid) from (select distinct d.docid as d_docid
from document d where ((d.docid != 1 or d.docid is null ))) ids  order by d_docid desc;

insert into af_vft (docid) select d_docid from (select distinct d.docid as d_docid
from document d where ((d.docid != 1 or d.docid is null ))) ids  order by d_docid desc;

select count(d_docid) from (select distinct d.docid as d_docid
from document d where ((d.docid != 1 or d.docid is null ))) ids  order by d_docid desc;

select count(d_docid) from (select distinct d.docid as d_docid
from document d where ((d.docid != 1 or d.docid is null ))) ids  order by d_docid desc;