[sepl]

habe ausversehen die tabelle tt_content in phpmyadmin gelöscht - kann mir bitte einer seine sql (struktur) schicken?
tausend dank im voraus!

[pcollins]

Hallo,

CREATE TABLE `tt_content` (
  `uid` int(11) NOT NULL auto_increment,
  `pid` int(11) NOT NULL default '0',
  `t3ver_oid` int(11) NOT NULL default '0',
  `t3ver_id` int(11) NOT NULL default '0',
  `t3ver_wsid` int(11) NOT NULL default '0',
  `t3ver_label` varchar(30) NOT NULL default '',
  `t3ver_state` tinyint(4) NOT NULL default '0',
  `t3ver_stage` tinyint(4) NOT NULL default '0',
  `t3ver_count` int(11) NOT NULL default '0',
  `t3ver_tstamp` int(11) NOT NULL default '0',
  `t3_origuid` int(11) NOT NULL default '0',
  `tstamp` int(11) unsigned NOT NULL default '0',
  `hidden` tinyint(4) unsigned NOT NULL default '0',
  `sorting` int(11) unsigned NOT NULL default '0',
  `CType` varchar(30) NOT NULL default '',
  `header` tinytext NOT NULL,
  `header_position` varchar(6) NOT NULL default '',
  `bodytext` mediumtext NOT NULL,
  `image` blob NOT NULL,
  `imagewidth` mediumint(11) unsigned NOT NULL default '0',
  `imageorient` tinyint(4) unsigned NOT NULL default '0',
  `imagecaption` text NOT NULL,
  `imagecols` tinyint(4) unsigned NOT NULL default '0',
  `imageborder` tinyint(4) unsigned NOT NULL default '0',
  `media` blob NOT NULL,
  `layout` tinyint(3) unsigned NOT NULL default '0',
  `deleted` tinyint(4) unsigned NOT NULL default '0',
  `cols` tinyint(3) unsigned NOT NULL default '0',
  `records` blob NOT NULL,
  `pages` tinyblob NOT NULL,
  `starttime` int(11) unsigned NOT NULL default '0',
  `endtime` int(11) unsigned NOT NULL default '0',
  `colPos` tinyint(3) unsigned NOT NULL default '0',
  `subheader` tinytext NOT NULL,
  `spaceBefore` tinyint(4) unsigned NOT NULL default '0',
  `spaceAfter` tinyint(4) unsigned NOT NULL default '0',
  `fe_group` varchar(100) NOT NULL default '0',
  `header_link` tinytext NOT NULL,
  `imagecaption_position` varchar(6) NOT NULL default '',
  `image_link` tinytext NOT NULL,
  `image_zoom` tinyint(3) unsigned NOT NULL default '0',
  `image_noRows` tinyint(3) unsigned NOT NULL default '0',
  `image_effects` tinyint(3) unsigned NOT NULL default '0',
  `image_compression` tinyint(3) unsigned NOT NULL default '0',
  `altText` text NOT NULL,
  `titleText` text NOT NULL,
  `longdescURL` text NOT NULL,
  `header_layout` varchar(30) NOT NULL default '0',
  `text_align` varchar(6) NOT NULL default '',
  `text_face` tinyint(3) unsigned NOT NULL default '0',
  `text_size` tinyint(3) unsigned NOT NULL default '0',
  `text_color` tinyint(3) unsigned NOT NULL default '0',
  `text_properties` tinyint(3) unsigned NOT NULL default '0',
  `menu_type` varchar(30) NOT NULL default '0',
  `list_type` varchar(36) NOT NULL default '0',
  `table_border` tinyint(3) unsigned NOT NULL default '0',
  `table_cellspacing` tinyint(3) unsigned NOT NULL default '0',
  `table_cellpadding` tinyint(3) unsigned NOT NULL default '0',
  `table_bgColor` tinyint(3) unsigned NOT NULL default '0',
  `select_key` varchar(80) NOT NULL default '',
  `sectionIndex` tinyint(3) unsigned NOT NULL default '0',
  `linkToTop` tinyint(3) unsigned NOT NULL default '0',
  `filelink_size` tinyint(3) unsigned NOT NULL default '0',
  `section_frame` tinyint(3) unsigned NOT NULL default '0',
  `date` int(10) unsigned NOT NULL default '0',
  `splash_layout` varchar(30) NOT NULL default '0',
  `multimedia` tinyblob NOT NULL,
  `image_frames` tinyint(3) unsigned NOT NULL default '0',
  `recursive` tinyint(3) unsigned NOT NULL default '0',
  `imageheight` mediumint(8) unsigned NOT NULL default '0',
  `rte_enabled` tinyint(4) NOT NULL default '0',
  `sys_language_uid` int(11) NOT NULL default '0',
  `tx_impexp_origuid` int(11) NOT NULL default '0',
  `pi_flexform` mediumtext NOT NULL,
  `l18n_parent` int(11) NOT NULL default '0',
  `l18n_diffsource` mediumblob NOT NULL,
  PRIMARY KEY  (`uid`),
  KEY `t3ver_oid` (`t3ver_oid`,`t3ver_wsid`),
  KEY `parent` (`pid`,`sorting`)
) TYPE=MyISAM AUTO_INCREMENT=4 ;

Kannst du das aber nicht mit dem Installer und dort Punkt2 machen?

mfg