CREATE TABLE  IF NOT EXISTS `jos_adsmanager_fields` (
  `fieldid` INT(11) NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(50) NOT NULL DEFAULT '',
  `title` VARCHAR(255) NOT NULL DEFAULT '',
  `display_title` tinyint(1) NOT NULL DEFAULT '0',
  `description` mediumtext NOT NULL,
  `type` VARCHAR(50) NOT NULL DEFAULT '',
  `maxlength` INT(11) DEFAULT NULL,
  `size` INT(11) DEFAULT NULL,
  `required` tinyint(4) DEFAULT '0',
  `ordering` INT(11) DEFAULT NULL,
  `cols` INT(11) DEFAULT NULL,
  `rows` INT(11) DEFAULT NULL,
  `link_text` VARCHAR( 255 ) NOT NULL DEFAULT '', 
  `link_image` VARCHAR( 255 ) NOT NULL DEFAULT '', 
  `columnid` INT(11) NOT NULL DEFAULT '-1',
  `columnorder` INT(11) NOT NULL DEFAULT '0',
  `pos` tinyint(4) NOT NULL DEFAULT '1',
  `posorder` tinyint(4) NOT NULL DEFAULT '1',
  `profile` tinyint(1) NOT NULL DEFAULT '0',
  `cb_field` INT(11) NOT NULL DEFAULT '-1',
  `cbfieldvalues` INT(11) NOT NULL DEFAULT '-1',
  `editable` tinyint(1) NOT NULL DEFAULT '1',
  `searchable` tinyint(1) NOT NULL DEFAULT '1',
  `sort` tinyint(1) NOT NULL DEFAULT '0',
  `sort_direction` VARCHAR(4) NOT NULL DEFAULT 'DESC',
  `catsid` TEXT NOT NULL, 
  `options` TEXT NOT NULL,
  `published` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY  (`fieldid`)
) DEFAULT CHARACTER SET utf8;