Port von Artikel aus Joomla - autom oder man.

CREATE TABLE IF NOT EXISTS vjl1p_content (
    id int(10) unsigned NOT NULL auto_increment,
    asset_id int(10) unsigned NOT NULL default '0' COMMENT 'FK to the #__assets table.',
    title varchar(255) NOT NULL default '',
    alias varchar(255) NOT NULL default '',
    title_alias varchar(255) NOT NULL default '',
    introtext mediumtext NOT NULL,
    fulltext mediumtext NOT NULL,
    state tinyint(3) NOT NULL default '0',
    sectionid int(10) unsigned NOT NULL default '0',
    mask int(10) unsigned NOT NULL default '0',
    catid int(10) unsigned NOT NULL default '0',
    created datetime NOT NULL default '0000-00-00 00:00:00',
    created_by int(10) unsigned NOT NULL default '0',
    created_by_alias varchar(255) NOT NULL default '',
    modified datetime NOT NULL default '0000-00-00 00:00:00',
    modified_by int(10) unsigned NOT NULL default '0',
    checked_out int(10) unsigned NOT NULL default '0',
    checked_out_time datetime NOT NULL default '0000-00-00 00:00:00',
    publish_up datetime NOT NULL default '0000-00-00 00:00:00',
    publish_down datetime NOT NULL default '0000-00-00 00:00:00',
    images text NOT NULL,
    urls text NOT NULL,
    attribs varchar(5120) NOT NULL,
    version int(10) unsigned NOT NULL default '1',
    parentid int(10) unsigned NOT NULL default '0',
    ordering int(11) NOT NULL default '0',
    metakey text NOT NULL,
    metadesc text NOT NULL,
    access int(10) unsigned NOT NULL default '0',
    hits int(10) unsigned NOT NULL default '0',
    metadata text NOT NULL,
    featured tinyint(3) unsigned NOT NULL default '0' COMMENT 'Set if article is featured.',
    language char(7) NOT NULL COMMENT 'The language code for the article.',
    xreference varchar(50) NOT NULL COMMENT 'A reference to enable linkages to external data sets.',
    PRIMARY KEY (id),
    KEY idx_access (access),
    KEY idx_checkout (checked_out),
    KEY idx_state (state),
    KEY idx_catid (catid),
    KEY idx_createdby (created_by),
    KEY idx_featured_catid (featured,catid),
    KEY idx_language (language),
    KEY idx_xreference (xreference)
    ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=58 ;