   `series` varchar(250) DEFAULT NULL,
   `school` varchar(250) DEFAULT NULL,
   `title` varchar(250) DEFAULT NULL,
-  `type` int(11) DEFAULT NULL,
   `url` varchar(250) DEFAULT NULL,
   `volume` int(11) DEFAULT NULL,
   `year` int(4) DEFAULT NULL,

  `exp_list_exp_data` int(3) DEFAULT NULL,
  `exp_data` int(3) DEFAULT NULL,
  `notes` text,
  `published` int(3) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE `#__citations_assoc` (

  `scope` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`),
  FULLTEXT KEY `title` (`title`),
  FULLTEXT KEY `content` (`content`),
  FULLTEXT KEY `#__blog_entries_title_content_ftidx` (`title`,`content`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE `#__cart` (
