Hilfe mysql Fehler

Erstellt am 1. April 2005 · 46 Antworten · letzte Antwort am 13. Juni 2006 · Seite 1 von 3

Michaela-Ww · 1. April 2005 11:46

Hallo Leute,

haben unsere Vereins-HP unter Typo laufen.
versuche seit Tagen die Mininews zum laufen zu bekommen und bekomme immer einen mysql Fehler.
Nun habe ich mal einen Database integrity check gemacht der sagt folgenden:

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/u0014363084/public_html/typo3/t3lib/class.t3lib_db.php on line 723
Relations:
 [ MENU ] Record Statistics Total Page Tree Database Relations Full search Find filename 
Files with no references at all (delete them!):
Files referenced from more than one record:
Missing files:
Select fields:
Group fields:
There are 1 records pointing to this missing or deleted record; [pages][44]
There are 1 records pointing to this missing or deleted record; [pages][34]
There are 1 records pointing to this missing or deleted record; [pages][47]
There are 2 records pointing to this missing or deleted record; [be_groups][1]

und das:

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/u0014363084/public_html/typo3/t3lib/class.t3lib_db.php on line 723

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/u0014363084/public_html/typo3/t3lib/class.t3lib_db.php on line 736

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/u0014363084/public_html/typo3/t3lib/class.t3lib_db.php on line 736

Was bedeutet das?
Wer kann mir helfen

Im Total Page Tree (in der DB Überprüfung)
werden auch lauter Seiten angezeigt die gelöscht wurden...
Kann ich die irgendwie löschen?

Gruß
Michaela

colli · 1. April 2005 16:17

Cache gelöscht?

Michaela-Ww · 1. April 2005 22:59

Hallo Colli,

colli schrieb
Cache gelöscht?

Ja cache ist gelöscht!
Aber die Meldungen bleiben

masti83 · 1. April 2005 23:16

schau doch mal direkt in die db (z.b. mit php myadmin) und überprüfe ob die Tabellen für dir Extension korrekt angelegt wurden. (alternativ kannst du auch im extensions manager die mininews anklicken, wenn dann eine sql anweisung zu sehen ist fehlen Felder oder Tabellen in der DB).

"gelöschte Seiten" sind in typo nicht wirklich gelöscht sondern es wird nur ein wert in datensatz eingefügt der diesen als gelöscht markiert. Um es wirklich zu löschen gibts ne Extension oder man macht das direkt über sql (würde ich nicht empfehlen falls man keine ahnung von hat)

MFG
Daniel

colli · 2. April 2005 13:12

Dann hat es wahrscheinlich etwas mit dem Import von .sql file von Typo3 im Install Tool zu tun.

Im Install Tool einfach mal auf import klicken. Dann müsste es weg sein.

Michaela-Ww · 3. April 2005 19:56

Hallo,

colli schrieb
Dann hat es wahrscheinlich etwas mit dem Import von .sql file von Typo3 im Install Tool zu tun.

Im Install Tool einfach mal auf import klicken. Dann müsste es weg sein.

Ich weis nicht wo?

Ich habe die Extension wieder entfernt und neu geladen.
Wenn ich versuche eine News anzulegen bekomme ich folgende Fehlermeldung:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/u0014363084/public_html/typo3/t3lib/class.t3lib_db.php on line 711

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/u0014363084/public_html/typo3/t3lib/class.t3lib_db.php on line 711

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/u0014363084/public_html/typo3/t3lib/class.t3lib_db.php on line 711

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/u0014363084/public_html/typo3/t3lib/class.t3lib_db.php on line 711

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/u0014363084/public_html/typo3/t3lib/class.t3lib_db.php on line 711

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/u0014363084/public_html/typo3/t3lib/class.t3lib_db.php on line 711

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/u0014363084/public_html/typo3/t3lib/class.t3lib_db.php on line 711

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/u0014363084/public_html/typo3/t3lib/class.t3lib_db.php on line 711

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/u0014363084/public_html/typo3/t3lib/class.t3lib_db.php on line 711

Warning: Cannot modify header information - headers already sent by (output started at /home/u0014363084/public_html/typo3/t3lib/class.t3lib_db.php:711) in /home/u0014363084/public_html/typo3/template.php on line 601

Damit kann ich aber nichts anfangen.
Ich bin echt noch ein Newbie - sorry.

Könnt ihr mir trotzdem helfen?

LG
Michaela

Michaela-Ww · 3. April 2005 20:03

Hallo,

wenn ich im Extension Manager mir die Mininews genauer ansehe finde ich folgende Fehlermeldungen in roter Schrift:

Database status: Table error!
Probably one or more required fields/tables are missing in the database!

und

Errors: Some tables or fields are of wrong type!

Habe aber nicht die geringste Ahnung was ich damit machen soll ... 😢

LG
Michaela

colli · 4. April 2005 16:54

Mit den Extensions hat das wenig zu tun.

Im install Verzeichnis auf "Database Analyser" steht unten "Dump static data". Da auf IMPORT klicken. Der Fehler in den News ist wahrscheinlich vererbt, da mit der Konfiguration etwas nicht stimmt.

Michaela-Ww · 5. April 2005 09:29

Hallo colli,

colli schrieb
Mit den Extensions hat das wenig zu tun.

Im install Verzeichnis auf "Database Analyser" steht unten "Dump static data". Da auf IMPORT klicken. Der Fehler in den News ist wahrscheinlich vererbt, da mit der Konfiguration etwas nicht stimmt.

Habe ich eben gemacht.
Es bleibt alles beim alten.
Wenn ich eine news anlegen will bekomme ich folgende Fehlermeldung:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/u0014363084/public_html/typo3/t3lib/class.t3lib_db.php on line 711

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/u0014363084/public_html/typo3/t3lib/class.t3lib_db.php on line 711

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/u0014363084/public_html/typo3/t3lib/class.t3lib_db.php on line 711

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/u0014363084/public_html/typo3/t3lib/class.t3lib_db.php on line 711

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/u0014363084/public_html/typo3/t3lib/class.t3lib_db.php on line 711

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/u0014363084/public_html/typo3/t3lib/class.t3lib_db.php on line 711

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/u0014363084/public_html/typo3/t3lib/class.t3lib_db.php on line 711

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/u0014363084/public_html/typo3/t3lib/class.t3lib_db.php on line 711

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/u0014363084/public_html/typo3/t3lib/class.t3lib_db.php on line 711

Warning: Cannot modify header information - headers already sent by (output started at /home/u0014363084/public_html/typo3/t3lib/class.t3lib_db.php:711) in /home/u0014363084/public_html/typo3/template.php on line 601

mit am Ende der Aufforderung "Continue". Wenn ich das drücke komme ich zurück zu der aufforderung was ich "neu" machen will 😢

Ich weis echt nichtmehr weiter...

LG
Michaela

colli · 5. April 2005 13:13

Seltsam.
Hast du wirklich alle Caches usw. gelöscht?

Ich habe den Fehler:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/u0014363084/public_html/typo3/t3lib/class.t3lib_db.php on line 711

schon so häufig gehabt und bei mir hat es immer an dem sql File im installer Tool gelegen. Import und/oder reset user preferences klaptten immer.

Michaela-Ww · 5. April 2005 15:52

Hallo Colli,

colli schrieb
Seltsam.
Hast du wirklich alle Caches usw. gelöscht?

Hmmm... ich glaube schon.
In der linken Seite von Typo werden ja 2 verschienene caches zum löschen angeboten.
Die habe ich beide benutzt.

Habs grade nochmal versucht. Caches gelöscht, news angelegt und wieder das gleiche wie schon oben beschrieben.
Über dem Continue button steht noch in einem winzigen Feld:

2: SQL error: 'Table 'db0014361.tx_mininews_news' doesn't exist' (tx_mininews_news:NEW425298c35b150)

Vielleicht noch was was vielleicht weiter hilft.
Wenn ich DB Überprüfung anklicke und dann auf Record static bekomme ich über der Anzeige folgende Fehlermeldungen:

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/u0014363084/public_html/typo3/t3lib/class.t3lib_db.php on line 723

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/u0014363084/public_html/typo3/t3lib/class.t3lib_db.php on line 736

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/u0014363084/public_html/typo3/t3lib/class.t3lib_db.php on line 736

Ich verstehe nur nicht was mir Typo damit sagen will

LG
Michaela

Michaela-Ww · 5. April 2005 16:00

Hallo Colli,

hab grade nochmal was nachgeschaut.
Im Log sagt mit Typo folgendes:

15:55  admin  DB  Sys!  Einfügen  Attempt to insert a record on page 'Table 'db0014361.tx_mininews_news' doesn't exist' (tx_mininews_news:NEW425298c35b150) from table '' without permissions. Or non-existing page. (12)

Sagt dir das was?

Ich habe einen sys ordner angelegt der news heißt. Dort sollen die News eingetragen werden und ich möchte sie dann auf allen Seiten als Teaser und auf der News-Seite als Volltext anzeigen.
Der sys-ordner liegt "unter" der Seite News...

LG
Michaela

Dander · 6. April 2005 09:08

tach,

ein paar der benötigten datenbanktabellen sind defekt oder fehlen.

Du musst ins installtool, aud den Database analyser gehen und COMPARE
und IMPORT klicken wenn das nicht funktioniert dann kopierst du dir die
SQL befehle die dir das installtool nach COMPARE anzeigt und fügst sie in den
PHPMYADMIN ein

Michaela-Ww · 6. April 2005 10:40

Hallo Dander

Dander schrieb
tach,

ein paar der benötigten datenbanktabellen sind defekt oder fehlen.

Du musst ins installtool, aud den Database analyser gehen und COMPARE
und IMPORT klicken wenn das nicht funktioniert dann kopierst du dir die
SQL befehle die dir das installtool nach COMPARE anzeigt und fügst sie in den
PHPMYADMIN ein

Also im Install Tool war ich schon.
Habe auch schon compare und Import ausgeführt.
Es funktioniert trotzdem nicht.
Mit SQL und PHPMYADMIN kenne ich mich nicht aus.

Ich verzweifele noch... 😢 komme einfach nichtmehr weiter.

Hmmm... jetzt habe ich nochmal im Installtool diverse Funktionen ausgeführt - und nun ist meine Seite weg!!!
In Typo bekomme ich die Contentelemente sauber angezeigt - aber wenn ich das Frontend aufrufe ist jede Seite leer... nur die Menüs sind noch da 🙁
Nu geht garnichtsmehr.

Das Template ist noch da.
Wenn ich mir die Startseite mit der Funktione Liste ansehe wird oben folgende Fehlermeldung angezeigt:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/u0014363084/public_html/typo3/t3lib/class.t3lib_db.php on line 736

Warning: Cannot modify header information - headers already sent by (output started at /home/u0014363084/public_html/typo3/t3lib/class.t3lib_db.php:736) in /home/u0014363084/public_html/typo3/template.php on line 601

Gruß
Michaela

Dander · 6. April 2005 10:48

was zeigt er dir denn bei COMPARE an???

Michaela-Ww · 6. April 2005 10:57

Hallo Dander,

Dander schrieb
was zeigt er dir denn bei COMPARE an???

Update database tables and fields: 
Table and field definitions should be updated 
There seems to be a number of differencies between the database and the selected SQL-file. Please select which statements you want to execute in order to update your database:


 
Changing fields
 ALTER TABLE tx_veguestbook_entries CHANGE uid uid int(11) unsigned NOT NULL auto_increment; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL auto_increment 

Add tables
 CREATE TABLE tx_mininews_news (
uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
pid int(11) unsigned DEFAULT '0' NOT NULL,
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
crdate int(11) unsigned DEFAULT '0' NOT NULL,
cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
starttime int(11) unsigned DEFAULT '0' NOT NULL,
endtime int(11) unsigned DEFAULT '0' NOT NULL,
fe_group int(11) DEFAULT '0' NOT NULL,
datetime int(11) DEFAULT '0' NOT NULL,
title tinytext NOT NULL,
teaser text NOT NULL,
full_text text NOT NULL,
front_page tinyint(3) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
) TYPE=MyISAM; 

Drop tables (really!)
 DROP TABLE zzz_deleted_tt_board; 
 Records in table: 2 
 DROP TABLE zzz_deleted_tt_news; 
 Records in table: 3 
 DROP TABLE zzz_deleted_tt_news_cat; 
  
 DROP TABLE zzz_deleted_tt_news_related_mm; 
  



 

--------------------------------------------------------------------------------
OS detected: UNIX
UNIX/CGI detected: NO
PATH_thisScript: /home/u0014363084/public_html/typo3/install/index.php

Backend admin in new window.
Frontend website in new window.

bzw unter typo3conf/database.sql (1.1 M) Compare

Update database tables and fields: 
Table and field definitions should be updated 
There seems to be a number of differencies between the database and the selected SQL-file. Please select which statements you want to execute in order to update your database:


 
Changing fields
 ALTER TABLE be_groups CHANGE uid uid int(11) unsigned NOT NULL auto_increment; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL auto_increment 
 ALTER TABLE be_groups CHANGE pid pid int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE be_groups CHANGE tstamp tstamp int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE be_groups CHANGE title title varchar(20) NOT NULL default ''; 
 Current value: varchar(20) DEFAULT '' NOT NULL 
 ALTER TABLE be_groups CHANGE db_mountpoints db_mountpoints varchar(40) NOT NULL default ''; 
 Current value: varchar(40) DEFAULT '' NOT NULL 
 ALTER TABLE be_groups CHANGE crdate crdate int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE be_groups CHANGE cruser_id cruser_id int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE be_groups CHANGE file_mountpoints file_mountpoints varchar(40) NOT NULL default ''; 
 Current value: varchar(40) DEFAULT '' NOT NULL 
 ALTER TABLE be_groups CHANGE hidden hidden tinyint(3) unsigned NOT NULL default '0'; 
 Current value: tinyint(3) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE be_groups CHANGE inc_access_lists inc_access_lists tinyint(3) unsigned NOT NULL default '0'; 
 Current value: tinyint(3) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE be_groups CHANGE lockToDomain lockToDomain varchar(50) NOT NULL default ''; 
 Current value: varchar(50) DEFAULT '' NOT NULL 
 ALTER TABLE be_groups CHANGE deleted deleted tinyint(3) unsigned NOT NULL default '0'; 
 Current value: tinyint(3) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE be_groups CHANGE hide_in_lists hide_in_lists tinyint(4) NOT NULL default '0'; 
 Current value: tinyint(4) DEFAULT '0' NOT NULL 
 ALTER TABLE be_groups DROP PRIMARY KEY; 
 ALTER TABLE be_groups ADD PRIMARY KEY (uid); 
 ALTER TABLE be_sessions CHANGE ses_id ses_id varchar(32) NOT NULL default ''; 
 Current value: varchar(32) DEFAULT '' NOT NULL 
 ALTER TABLE be_sessions CHANGE ses_name ses_name varchar(32) NOT NULL default ''; 
 Current value: varchar(32) DEFAULT '' NOT NULL 
 ALTER TABLE be_sessions CHANGE ses_userid ses_userid int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE be_sessions CHANGE ses_tstamp ses_tstamp int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE be_sessions CHANGE ses_iplock ses_iplock varchar(15) NOT NULL default ''; 
 Current value: varchar(15) DEFAULT '' NOT NULL 
 ALTER TABLE be_sessions CHANGE ses_hashlock ses_hashlock int(11) NOT NULL default '0'; 
 Current value: int(11) DEFAULT '0' NOT NULL 
 ALTER TABLE be_sessions DROP PRIMARY KEY; 
 ALTER TABLE be_sessions ADD PRIMARY KEY (ses_id,ses_name); 
 ALTER TABLE be_users CHANGE uid uid int(11) unsigned NOT NULL auto_increment; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL auto_increment 
 ALTER TABLE be_users CHANGE pid pid int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE be_users CHANGE tstamp tstamp int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE be_users CHANGE username username varchar(20) NOT NULL default ''; 
 Current value: varchar(20) DEFAULT '' NOT NULL 
 ALTER TABLE be_users CHANGE password password varchar(40) NOT NULL default ''; 
 Current value: varchar(40) DEFAULT '' NOT NULL 
 ALTER TABLE be_users CHANGE admin admin tinyint(4) unsigned NOT NULL default '0'; 
 Current value: tinyint(4) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE be_users CHANGE disable disable tinyint(4) unsigned NOT NULL default '0'; 
 Current value: tinyint(4) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE be_users CHANGE starttime starttime int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE be_users CHANGE endtime endtime int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE be_users CHANGE lang lang char(2) NOT NULL default ''; 
 Current value: char(2) DEFAULT '' NOT NULL 
 ALTER TABLE be_users CHANGE email email varchar(80) NOT NULL default ''; 
 Current value: varchar(80) DEFAULT '' NOT NULL 
 ALTER TABLE be_users CHANGE db_mountpoints db_mountpoints varchar(40) NOT NULL default ''; 
 Current value: varchar(40) DEFAULT '' NOT NULL 
 ALTER TABLE be_users CHANGE options options tinyint(4) unsigned NOT NULL default '0'; 
 Current value: tinyint(4) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE be_users CHANGE crdate crdate int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE be_users CHANGE cruser_id cruser_id int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE be_users CHANGE realName realName varchar(80) NOT NULL default ''; 
 Current value: varchar(80) DEFAULT '' NOT NULL 
 ALTER TABLE be_users CHANGE file_mountpoints file_mountpoints varchar(40) NOT NULL default ''; 
 Current value: varchar(40) DEFAULT '' NOT NULL 
 ALTER TABLE be_users CHANGE fileoper_perms fileoper_perms tinyint(4) NOT NULL default '0'; 
 Current value: tinyint(4) DEFAULT '0' NOT NULL 
 ALTER TABLE be_users CHANGE lockToDomain lockToDomain varchar(50) NOT NULL default ''; 
 Current value: varchar(50) DEFAULT '' NOT NULL 
 ALTER TABLE be_users CHANGE deleted deleted tinyint(3) unsigned NOT NULL default '0'; 
 Current value: tinyint(3) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE be_users CHANGE lastlogin lastlogin int(10) unsigned NOT NULL default '0'; 
 Current value: int(10) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE be_users CHANGE createdByAction createdByAction int(11) NOT NULL default '0'; 
 Current value: int(11) DEFAULT '0' NOT NULL 
 ALTER TABLE be_users CHANGE disableIPlock disableIPlock tinyint(3) unsigned NOT NULL default '0'; 
 Current value: tinyint(3) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE be_users DROP PRIMARY KEY; 
 ALTER TABLE be_users ADD PRIMARY KEY (uid); 
 ALTER TABLE cache_hash CHANGE hash hash varchar(32) NOT NULL default ''; 
 Current value: varchar(32) DEFAULT '' NOT NULL 
 ALTER TABLE cache_hash CHANGE tstamp tstamp int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE cache_hash CHANGE ident ident varchar(20) NOT NULL default ''; 
 Current value: varchar(20) DEFAULT '' NOT NULL 
 ALTER TABLE cache_hash DROP PRIMARY KEY; 
 ALTER TABLE cache_hash ADD PRIMARY KEY (hash); 
 ALTER TABLE cache_imagesizes CHANGE md5hash md5hash varchar(32) NOT NULL default ''; 
 Current value: varchar(32) DEFAULT '' NOT NULL 
 ALTER TABLE cache_imagesizes CHANGE md5filename md5filename varchar(32) NOT NULL default ''; 
 Current value: varchar(32) DEFAULT '' NOT NULL 
 ALTER TABLE cache_imagesizes CHANGE tstamp tstamp int(11) NOT NULL default '0'; 
 Current value: int(11) DEFAULT '0' NOT NULL 
 ALTER TABLE cache_imagesizes CHANGE imagewidth imagewidth mediumint(11) unsigned NOT NULL default '0'; 
 Current value: mediumint(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE cache_imagesizes CHANGE imageheight imageheight mediumint(11) unsigned NOT NULL default '0'; 
 Current value: mediumint(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE cache_imagesizes DROP PRIMARY KEY; 
 ALTER TABLE cache_imagesizes ADD PRIMARY KEY (md5filename); 
 ALTER TABLE cache_md5params CHANGE md5hash md5hash varchar(20) NOT NULL default ''; 
 Current value: varchar(20) DEFAULT '' NOT NULL 
 ALTER TABLE cache_md5params CHANGE tstamp tstamp int(11) NOT NULL default '0'; 
 Current value: int(11) DEFAULT '0' NOT NULL 
 ALTER TABLE cache_md5params CHANGE type type tinyint(3) NOT NULL default '0'; 
 Current value: tinyint(3) DEFAULT '0' NOT NULL 
 ALTER TABLE cache_md5params DROP PRIMARY KEY; 
 ALTER TABLE cache_md5params ADD PRIMARY KEY (md5hash); 
 ALTER TABLE cache_pages CHANGE id id int(11) unsigned NOT NULL auto_increment; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL auto_increment 
 ALTER TABLE cache_pages CHANGE hash hash varchar(32) NOT NULL default ''; 
 Current value: varchar(32) DEFAULT '' NOT NULL 
 ALTER TABLE cache_pages CHANGE page_id page_id int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE cache_pages CHANGE reg1 reg1 int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE cache_pages CHANGE tstamp tstamp int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE cache_pages CHANGE expires expires int(10) unsigned NOT NULL default '0'; 
 Current value: int(10) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE cache_pages DROP PRIMARY KEY; 
 ALTER TABLE cache_pages ADD PRIMARY KEY (id); 
 ALTER TABLE cache_pagesection CHANGE page_id page_id int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE cache_pagesection CHANGE tstamp tstamp int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE cache_pagesection CHANGE mpvar_hash mpvar_hash int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE cache_pagesection DROP PRIMARY KEY; 
 ALTER TABLE cache_pagesection ADD PRIMARY KEY (page_id,mpvar_hash); 
 ALTER TABLE cache_typo3temp_log CHANGE md5hash md5hash varchar(32) NOT NULL default ''; 
 Current value: varchar(32) DEFAULT '' NOT NULL 
 ALTER TABLE cache_typo3temp_log CHANGE tstamp tstamp int(11) NOT NULL default '0'; 
 Current value: int(11) DEFAULT '0' NOT NULL 
 ALTER TABLE cache_typo3temp_log DROP PRIMARY KEY; 
 ALTER TABLE cache_typo3temp_log ADD PRIMARY KEY (md5hash); 
 ALTER TABLE fe_groups CHANGE uid uid int(11) unsigned NOT NULL auto_increment; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL auto_increment 
 ALTER TABLE fe_groups CHANGE pid pid int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE fe_groups CHANGE tstamp tstamp int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE fe_groups CHANGE title title varchar(20) NOT NULL default ''; 
 Current value: varchar(20) DEFAULT '' NOT NULL 
 ALTER TABLE fe_groups CHANGE hidden hidden tinyint(3) unsigned NOT NULL default '0'; 
 Current value: tinyint(3) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE fe_groups CHANGE lockToDomain lockToDomain varchar(50) NOT NULL default ''; 
 Current value: varchar(50) DEFAULT '' NOT NULL 
 ALTER TABLE fe_groups CHANGE deleted deleted tinyint(3) unsigned NOT NULL default '0'; 
 Current value: tinyint(3) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE fe_groups DROP PRIMARY KEY; 
 ALTER TABLE fe_groups ADD PRIMARY KEY (uid); 
 ALTER TABLE fe_session_data CHANGE hash hash varchar(32) NOT NULL default ''; 
 Current value: varchar(32) DEFAULT '' NOT NULL 
 ALTER TABLE fe_session_data CHANGE tstamp tstamp int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE fe_session_data DROP PRIMARY KEY; 
 ALTER TABLE fe_session_data ADD PRIMARY KEY (hash); 
 ALTER TABLE fe_sessions CHANGE ses_id ses_id varchar(32) NOT NULL default ''; 
 Current value: varchar(32) DEFAULT '' NOT NULL 
 ALTER TABLE fe_sessions CHANGE ses_name ses_name varchar(32) NOT NULL default ''; 
 Current value: varchar(32) DEFAULT '' NOT NULL 
 ALTER TABLE fe_sessions CHANGE ses_userid ses_userid int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE fe_sessions CHANGE ses_tstamp ses_tstamp int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE fe_sessions CHANGE ses_iplock ses_iplock varchar(15) NOT NULL default ''; 
 Current value: varchar(15) DEFAULT '' NOT NULL 
 ALTER TABLE fe_sessions CHANGE ses_hashlock ses_hashlock int(11) NOT NULL default '0'; 
 Current value: int(11) DEFAULT '0' NOT NULL 
 ALTER TABLE fe_sessions DROP PRIMARY KEY; 
 ALTER TABLE fe_sessions ADD PRIMARY KEY (ses_id,ses_name); 
 ALTER TABLE fe_users CHANGE uid uid int(11) unsigned NOT NULL auto_increment; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL auto_increment 
 ALTER TABLE fe_users CHANGE pid pid int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE fe_users CHANGE tstamp tstamp int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE fe_users CHANGE username username varchar(50) NOT NULL default ''; 
 Current value: varchar(50) DEFAULT '' NOT NULL 
 ALTER TABLE fe_users CHANGE password password varchar(40) NOT NULL default ''; 
 Current value: varchar(40) DEFAULT '' NOT NULL 
 ALTER TABLE fe_users CHANGE disable disable tinyint(4) unsigned NOT NULL default '0'; 
 Current value: tinyint(4) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE fe_users CHANGE starttime starttime int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE fe_users CHANGE endtime endtime int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE fe_users CHANGE name name varchar(80) NOT NULL default ''; 
 Current value: varchar(80) DEFAULT '' NOT NULL 
 ALTER TABLE fe_users CHANGE telephone telephone varchar(20) NOT NULL default ''; 
 Current value: varchar(20) DEFAULT '' NOT NULL 
 ALTER TABLE fe_users CHANGE fax fax varchar(20) NOT NULL default ''; 
 Current value: varchar(20) DEFAULT '' NOT NULL 
 ALTER TABLE fe_users CHANGE email email varchar(80) NOT NULL default ''; 
 Current value: varchar(80) DEFAULT '' NOT NULL 
 ALTER TABLE fe_users CHANGE crdate crdate int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE fe_users CHANGE cruser_id cruser_id int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE fe_users CHANGE lockToDomain lockToDomain varchar(50) NOT NULL default ''; 
 Current value: varchar(50) DEFAULT '' NOT NULL 
 ALTER TABLE fe_users CHANGE deleted deleted tinyint(3) unsigned NOT NULL default '0'; 
 Current value: tinyint(3) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE fe_users CHANGE title title varchar(40) NOT NULL default ''; 
 Current value: varchar(40) DEFAULT '' NOT NULL 
 ALTER TABLE fe_users CHANGE zip zip varchar(10) NOT NULL default ''; 
 Current value: varchar(10) DEFAULT '' NOT NULL 
 ALTER TABLE fe_users CHANGE city city varchar(50) NOT NULL default ''; 
 Current value: varchar(50) DEFAULT '' NOT NULL 
 ALTER TABLE fe_users CHANGE country country varchar(40) NOT NULL default ''; 
 Current value: varchar(40) DEFAULT '' NOT NULL 
 ALTER TABLE fe_users CHANGE www www varchar(80) NOT NULL default ''; 
 Current value: varchar(80) DEFAULT '' NOT NULL 
 ALTER TABLE fe_users CHANGE company company varchar(80) NOT NULL default ''; 
 Current value: varchar(80) DEFAULT '' NOT NULL 
 ALTER TABLE fe_users CHANGE module_sys_dmail_category module_sys_dmail_category int(10) unsigned NOT NULL default '0'; 
 Current value: int(10) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE fe_users CHANGE module_sys_dmail_html module_sys_dmail_html tinyint(3) unsigned NOT NULL default '0'; 
 Current value: tinyint(3) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE fe_users CHANGE fe_cruser_id fe_cruser_id int(10) unsigned NOT NULL default '0'; 
 Current value: int(10) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE fe_users CHANGE lastlogin lastlogin int(10) unsigned NOT NULL default '0'; 
 Current value: int(10) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE fe_users CHANGE is_online is_online int(10) unsigned NOT NULL default '0'; 
 Current value: int(10) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE fe_users DROP PRIMARY KEY; 
 ALTER TABLE fe_users ADD PRIMARY KEY (uid); 
 ALTER TABLE pages CHANGE uid uid int(11) NOT NULL auto_increment; 
 Current value: int(11) DEFAULT '0' NOT NULL auto_increment 
 ALTER TABLE pages CHANGE pid pid int(11) NOT NULL default '0'; 
 Current value: int(11) DEFAULT '0' NOT NULL 
 ALTER TABLE pages CHANGE tstamp tstamp int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE pages CHANGE sorting sorting int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE pages CHANGE deleted deleted tinyint(4) unsigned NOT NULL default '0'; 
 Current value: tinyint(4) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE pages CHANGE perms_userid perms_userid int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE pages CHANGE perms_groupid perms_groupid int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE pages CHANGE perms_user perms_user tinyint(4) unsigned NOT NULL default '0'; 
 Current value: tinyint(4) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE pages CHANGE perms_group perms_group tinyint(4) unsigned NOT NULL default '0'; 
 Current value: tinyint(4) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE pages CHANGE perms_everybody perms_everybody tinyint(4) unsigned NOT NULL default '0'; 
 Current value: tinyint(4) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE pages CHANGE crdate crdate int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE pages CHANGE cruser_id cruser_id int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE pages CHANGE doktype doktype tinyint(3) unsigned NOT NULL default '0'; 
 Current value: tinyint(3) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE pages CHANGE storage_pid storage_pid int(11) NOT NULL default '0'; 
 Current value: int(11) DEFAULT '0' NOT NULL 
 ALTER TABLE pages CHANGE is_siteroot is_siteroot tinyint(4) NOT NULL default '0'; 
 Current value: tinyint(4) DEFAULT '0' NOT NULL 
 ALTER TABLE pages CHANGE php_tree_stop php_tree_stop tinyint(4) NOT NULL default '0'; 
 Current value: tinyint(4) DEFAULT '0' NOT NULL 
 ALTER TABLE pages CHANGE tx_impexp_origuid tx_impexp_origuid int(11) NOT NULL default '0'; 
 Current value: int(11) DEFAULT '0' NOT NULL 
 ALTER TABLE pages CHANGE hidden hidden tinyint(4) unsigned NOT NULL default '0'; 
 Current value: tinyint(4) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE pages CHANGE starttime starttime int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE pages CHANGE endtime endtime int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE pages CHANGE urltype urltype tinyint(4) unsigned NOT NULL default '0'; 
 Current value: tinyint(4) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE pages CHANGE shortcut shortcut int(10) unsigned NOT NULL default '0'; 
 Current value: int(10) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE pages CHANGE shortcut_mode shortcut_mode int(10) unsigned NOT NULL default '0'; 
 Current value: int(10) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE pages CHANGE no_cache no_cache int(10) unsigned NOT NULL default '0'; 
 Current value: int(10) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE pages CHANGE fe_group fe_group int(11) NOT NULL default '0'; 
 Current value: int(11) DEFAULT '0' NOT NULL 
 ALTER TABLE pages CHANGE layout layout tinyint(3) unsigned NOT NULL default '0'; 
 Current value: tinyint(3) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE pages CHANGE target target varchar(20) NOT NULL default ''; 
 Current value: varchar(20) DEFAULT '' NOT NULL 
 ALTER TABLE pages CHANGE lastUpdated lastUpdated int(10) unsigned NOT NULL default '0'; 
 Current value: int(10) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE pages CHANGE cache_timeout cache_timeout int(10) unsigned NOT NULL default '0'; 
 Current value: int(10) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE pages CHANGE newUntil newUntil int(10) unsigned NOT NULL default '0'; 
 Current value: int(10) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE pages CHANGE no_search no_search tinyint(3) unsigned NOT NULL default '0'; 
 Current value: tinyint(3) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE pages CHANGE SYS_LASTCHANGED SYS_LASTCHANGED int(10) unsigned NOT NULL default '0'; 
 Current value: int(10) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE pages CHANGE module module varchar(10) NOT NULL default ''; 
 Current value: varchar(10) DEFAULT '' NOT NULL 
 ALTER TABLE pages CHANGE extendToSubpages extendToSubpages tinyint(3) unsigned NOT NULL default '0'; 
 Current value: tinyint(3) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE pages CHANGE author_email author_email varchar(80) NOT NULL default ''; 
 Current value: varchar(80) DEFAULT '' NOT NULL 
 ALTER TABLE pages CHANGE content_from_pid content_from_pid int(10) unsigned NOT NULL default '0'; 
 Current value: int(10) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE pages CHANGE mount_pid mount_pid int(10) unsigned NOT NULL default '0'; 
 Current value: int(10) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE pages CHANGE alias alias varchar(20) NOT NULL default ''; 
 Current value: varchar(20) DEFAULT '' NOT NULL 
 ALTER TABLE pages CHANGE t3ver_oid t3ver_oid int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE pages CHANGE t3ver_id t3ver_id int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE pages CHANGE t3ver_label t3ver_label varchar(30) NOT NULL default ''; 
 Current value: varchar(30) DEFAULT '' NOT NULL 
 ALTER TABLE pages CHANGE editlock editlock tinyint(4) unsigned NOT NULL default '0'; 
 Current value: tinyint(4) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE pages CHANGE nav_hide nav_hide tinyint(4) NOT NULL default '0'; 
 Current value: tinyint(4) DEFAULT '0' NOT NULL 
 ALTER TABLE pages CHANGE mount_pid_ol mount_pid_ol tinyint(4) NOT NULL default '0'; 
 Current value: tinyint(4) DEFAULT '0' NOT NULL 
 ALTER TABLE pages CHANGE l18n_cfg l18n_cfg tinyint(4) NOT NULL default '0'; 
 Current value: tinyint(4) DEFAULT '0' NOT NULL 
 ALTER TABLE pages DROP PRIMARY KEY; 
 ALTER TABLE pages ADD PRIMARY KEY (uid); 
 ALTER TABLE pages_language_overlay CHANGE uid uid int(11) NOT NULL auto_increment; 
 Current value: int(11) DEFAULT '0' NOT NULL auto_increment 
 ALTER TABLE pages_language_overlay CHANGE pid pid int(11) NOT NULL default '0'; 
 Current value: int(11) DEFAULT '0' NOT NULL 
 ALTER TABLE pages_language_overlay CHANGE tstamp tstamp int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE pages_language_overlay CHANGE crdate crdate int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE pages_language_overlay CHANGE cruser_id cruser_id int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE pages_language_overlay CHANGE sys_language_uid sys_language_uid int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE pages_language_overlay CHANGE hidden hidden tinyint(4) unsigned NOT NULL default '0'; 
 Current value: tinyint(4) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE pages_language_overlay CHANGE starttime starttime int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE pages_language_overlay CHANGE endtime endtime int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE pages_language_overlay CHANGE author_email author_email varchar(80) NOT NULL default ''; 
 Current value: varchar(80) DEFAULT '' NOT NULL 
 ALTER TABLE pages_language_overlay CHANGE tx_impexp_origuid tx_impexp_origuid int(11) NOT NULL default '0'; 
 Current value: int(11) DEFAULT '0' NOT NULL 
 ALTER TABLE pages_language_overlay CHANGE t3ver_oid t3ver_oid int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE pages_language_overlay CHANGE t3ver_id t3ver_id int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE pages_language_overlay CHANGE t3ver_label t3ver_label varchar(30) NOT NULL default ''; 
 Current value: varchar(30) DEFAULT '' NOT NULL 
 ALTER TABLE pages_language_overlay DROP PRIMARY KEY; 
 ALTER TABLE pages_language_overlay ADD PRIMARY KEY (uid); 
 ALTER TABLE static_template CHANGE uid uid int(11) unsigned NOT NULL auto_increment; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL auto_increment 
 ALTER TABLE static_template CHANGE pid pid int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE static_template CHANGE tstamp tstamp int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE static_template CHANGE crdate crdate int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE static_template DROP PRIMARY KEY; 
 ALTER TABLE static_template ADD PRIMARY KEY (uid); 
 ALTER TABLE static_tsconfig_help CHANGE uid uid int(11) NOT NULL auto_increment; 
 Current value: int(11) DEFAULT '0' NOT NULL auto_increment 
 ALTER TABLE static_tsconfig_help CHANGE guide guide int(11) NOT NULL default '0'; 
 Current value: int(11) DEFAULT '0' NOT NULL 
 ALTER TABLE static_tsconfig_help CHANGE md5hash md5hash varchar(32) NOT NULL default ''; 
 Current value: varchar(32) DEFAULT '' NOT NULL 
 ALTER TABLE static_tsconfig_help DROP PRIMARY KEY; 
 ALTER TABLE static_tsconfig_help ADD PRIMARY KEY (uid); 
 ALTER TABLE sys_be_shortcuts CHANGE uid uid int(11) unsigned NOT NULL auto_increment; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL auto_increment 
 ALTER TABLE sys_be_shortcuts CHANGE userid userid int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE sys_be_shortcuts CHANGE sorting sorting int(11) NOT NULL default '0'; 
 Current value: int(11) DEFAULT '0' NOT NULL 
 ALTER TABLE sys_be_shortcuts CHANGE sc_group sc_group tinyint(4) NOT NULL default '0'; 
 Current value: tinyint(4) DEFAULT '0' NOT NULL 
 ALTER TABLE sys_be_shortcuts DROP PRIMARY KEY; 
 ALTER TABLE sys_be_shortcuts ADD PRIMARY KEY (uid); 
 ALTER TABLE sys_domain CHANGE uid uid int(11) unsigned NOT NULL auto_increment; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL auto_increment 
 ALTER TABLE sys_domain CHANGE pid pid int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE sys_domain CHANGE tstamp tstamp int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE sys_domain CHANGE hidden hidden tinyint(4) unsigned NOT NULL default '0'; 
 Current value: tinyint(4) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE sys_domain CHANGE domainName domainName varchar(80) NOT NULL default ''; 
 Current value: varchar(80) DEFAULT '' NOT NULL 
 ALTER TABLE sys_domain CHANGE redirectTo redirectTo varchar(120) NOT NULL default ''; 
 Current value: varchar(120) DEFAULT '' NOT NULL 
 ALTER TABLE sys_domain CHANGE sorting sorting int(10) unsigned NOT NULL default '0'; 
 Current value: int(10) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE sys_domain CHANGE prepend_params prepend_params int(10) NOT NULL default '0'; 
 Current value: int(10) DEFAULT '0' NOT NULL 
 ALTER TABLE sys_domain DROP PRIMARY KEY; 
 ALTER TABLE sys_domain ADD PRIMARY KEY (uid); 
 ALTER TABLE sys_filemounts CHANGE uid uid int(11) unsigned NOT NULL auto_increment; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL auto_increment 
 ALTER TABLE sys_filemounts CHANGE pid pid int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE sys_filemounts CHANGE tstamp tstamp int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE sys_filemounts CHANGE title title varchar(30) NOT NULL default ''; 
 Current value: varchar(30) DEFAULT '' NOT NULL 
 ALTER TABLE sys_filemounts CHANGE path path varchar(120) NOT NULL default ''; 
 Current value: varchar(120) DEFAULT '' NOT NULL 
 ALTER TABLE sys_filemounts CHANGE base base tinyint(4) unsigned NOT NULL default '0'; 
 Current value: tinyint(4) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE sys_filemounts CHANGE hidden hidden tinyint(3) unsigned NOT NULL default '0'; 
 Current value: tinyint(3) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE sys_filemounts CHANGE deleted deleted tinyint(3) unsigned NOT NULL default '0'; 
 Current value: tinyint(3) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE sys_filemounts DROP PRIMARY KEY; 
 ALTER TABLE sys_filemounts ADD PRIMARY KEY (uid); 
 ALTER TABLE sys_history CHANGE uid uid int(11) unsigned NOT NULL auto_increment; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL auto_increment 
 ALTER TABLE sys_history CHANGE sys_log_uid sys_log_uid int(11) NOT NULL default '0'; 
 Current value: int(11) DEFAULT '0' NOT NULL 
 ALTER TABLE sys_history CHANGE recuid recuid int(11) NOT NULL default '0'; 
 Current value: int(11) DEFAULT '0' NOT NULL 
 ALTER TABLE sys_history CHANGE tablename tablename varchar(40) NOT NULL default ''; 
 Current value: varchar(40) DEFAULT '' NOT NULL 
 ALTER TABLE sys_history CHANGE tstamp tstamp int(11) NOT NULL default '0'; 
 Current value: int(11) DEFAULT '0' NOT NULL 
 ALTER TABLE sys_history CHANGE snapshot snapshot tinyint(4) NOT NULL default '0'; 
 Current value: tinyint(4) DEFAULT '0' NOT NULL 
 ALTER TABLE sys_history DROP PRIMARY KEY; 
 ALTER TABLE sys_history ADD PRIMARY KEY (uid); 
 ALTER TABLE sys_language CHANGE uid uid int(11) unsigned NOT NULL auto_increment; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL auto_increment 
 ALTER TABLE sys_language CHANGE pid pid int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE sys_language CHANGE tstamp tstamp int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE sys_language CHANGE hidden hidden tinyint(4) unsigned NOT NULL default '0'; 
 Current value: tinyint(4) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE sys_language CHANGE title title varchar(80) NOT NULL default ''; 
 Current value: varchar(80) DEFAULT '' NOT NULL 
 ALTER TABLE sys_language CHANGE flag flag varchar(20) NOT NULL default ''; 
 Current value: varchar(20) DEFAULT '' NOT NULL 
 ALTER TABLE sys_language CHANGE static_lang_isocode static_lang_isocode int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE sys_language DROP PRIMARY KEY; 
 ALTER TABLE sys_language ADD PRIMARY KEY (uid); 
 ALTER TABLE sys_lockedrecords CHANGE uid uid int(11) unsigned NOT NULL auto_increment; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL auto_increment 
 ALTER TABLE sys_lockedrecords CHANGE userid userid int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE sys_lockedrecords CHANGE tstamp tstamp int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE sys_lockedrecords CHANGE record_table record_table varchar(40) NOT NULL default ''; 
 Current value: varchar(40) DEFAULT '' NOT NULL 
 ALTER TABLE sys_lockedrecords CHANGE record_uid record_uid int(11) NOT NULL default '0'; 
 Current value: int(11) DEFAULT '0' NOT NULL 
 ALTER TABLE sys_lockedrecords CHANGE record_pid record_pid int(11) NOT NULL default '0'; 
 Current value: int(11) DEFAULT '0' NOT NULL 
 ALTER TABLE sys_lockedrecords CHANGE username username varchar(20) NOT NULL default ''; 
 Current value: varchar(20) DEFAULT '' NOT NULL 
 ALTER TABLE sys_lockedrecords DROP PRIMARY KEY; 
 ALTER TABLE sys_lockedrecords ADD PRIMARY KEY (uid); 
 ALTER TABLE sys_log CHANGE uid uid int(11) unsigned NOT NULL auto_increment; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL auto_increment 
 ALTER TABLE sys_log CHANGE userid userid int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE sys_log CHANGE action action tinyint(4) unsigned NOT NULL default '0'; 
 Current value: tinyint(4) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE sys_log CHANGE recuid recuid int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE sys_log CHANGE tablename tablename varchar(40) NOT NULL default ''; 
 Current value: varchar(40) DEFAULT '' NOT NULL 
 ALTER TABLE sys_log CHANGE recpid recpid int(11) NOT NULL default '0'; 
 Current value: int(11) DEFAULT '0' NOT NULL 
 ALTER TABLE sys_log CHANGE error error tinyint(4) unsigned NOT NULL default '0'; 
 Current value: tinyint(4) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE sys_log CHANGE tstamp tstamp int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE sys_log CHANGE type type tinyint(3) unsigned NOT NULL default '0'; 
 Current value: tinyint(3) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE sys_log CHANGE details_nr details_nr tinyint(3) unsigned NOT NULL default '0'; 
 Current value: tinyint(3) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE sys_log CHANGE IP IP varchar(39) NOT NULL default ''; 
 Current value: varchar(39) DEFAULT '' NOT NULL 
 ALTER TABLE sys_log CHANGE event_pid event_pid int(11) NOT NULL default '-1'; 
 Current value: int(11) DEFAULT '-1' NOT NULL 
 ALTER TABLE sys_log CHANGE NEWid NEWid varchar(20) NOT NULL default ''; 
 Current value: varchar(20) DEFAULT '' NOT NULL 
 ALTER TABLE sys_log DROP PRIMARY KEY; 
 ALTER TABLE sys_log ADD PRIMARY KEY (uid); 
 ALTER TABLE sys_note CHANGE uid uid int(11) unsigned NOT NULL auto_increment; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL auto_increment 
 ALTER TABLE sys_note CHANGE pid pid int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE sys_note CHANGE deleted deleted tinyint(3) unsigned NOT NULL default '0'; 
 Current value: tinyint(3) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE sys_note CHANGE tstamp tstamp int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE sys_note CHANGE crdate crdate int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE sys_note CHANGE cruser cruser int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE sys_note CHANGE author author varchar(80) NOT NULL default ''; 
 Current value: varchar(80) DEFAULT '' NOT NULL 
 ALTER TABLE sys_note CHANGE email email varchar(80) NOT NULL default ''; 
 Current value: varchar(80) DEFAULT '' NOT NULL 
 ALTER TABLE sys_note CHANGE personal personal tinyint(3) unsigned NOT NULL default '0'; 
 Current value: tinyint(3) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE sys_note CHANGE category category tinyint(3) unsigned NOT NULL default '0'; 
 Current value: tinyint(3) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE sys_note DROP PRIMARY KEY; 
 ALTER TABLE sys_note ADD PRIMARY KEY (uid); 
 ALTER TABLE sys_notepad CHANGE uid uid int(11) unsigned NOT NULL auto_increment; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL auto_increment 
 ALTER TABLE sys_notepad CHANGE pid pid int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE sys_notepad CHANGE tstamp tstamp int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE sys_notepad CHANGE cruser_id cruser_id int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE sys_notepad CHANGE crdate crdate int(11) NOT NULL default '0'; 
 Current value: int(11) DEFAULT '0' NOT NULL 
 ALTER TABLE sys_notepad DROP PRIMARY KEY; 
 ALTER TABLE sys_notepad ADD PRIMARY KEY (uid); 
 ALTER TABLE sys_template CHANGE uid uid int(11) NOT NULL auto_increment; 
 Current value: int(11) DEFAULT '0' NOT NULL auto_increment 
 ALTER TABLE sys_template CHANGE pid pid int(11) NOT NULL default '0'; 
 Current value: int(11) DEFAULT '0' NOT NULL 
 ALTER TABLE sys_template CHANGE tstamp tstamp int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE sys_template CHANGE sorting sorting int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE sys_template CHANGE crdate crdate int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE sys_template CHANGE cruser_id cruser_id int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE sys_template CHANGE hidden hidden tinyint(4) unsigned NOT NULL default '0'; 
 Current value: tinyint(4) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE sys_template CHANGE starttime starttime int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE sys_template CHANGE endtime endtime int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE sys_template CHANGE root root tinyint(4) unsigned NOT NULL default '0'; 
 Current value: tinyint(4) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE sys_template CHANGE clear clear tinyint(4) unsigned NOT NULL default '0'; 
 Current value: tinyint(4) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE sys_template CHANGE nextLevel nextLevel varchar(5) NOT NULL default ''; 
 Current value: varchar(5) DEFAULT '' NOT NULL 
 ALTER TABLE sys_template CHANGE deleted deleted tinyint(3) unsigned NOT NULL default '0'; 
 Current value: tinyint(3) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE sys_template CHANGE includeStaticAfterBasedOn includeStaticAfterBasedOn tinyint(4) unsigned NOT NULL default '0'; 
 Current value: tinyint(4) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE sys_template CHANGE static_file_mode static_file_mode tinyint(4) unsigned NOT NULL default '0'; 
 Current value: tinyint(4) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE sys_template CHANGE tx_impexp_origuid tx_impexp_origuid int(11) NOT NULL default '0'; 
 Current value: int(11) DEFAULT '0' NOT NULL 
 ALTER TABLE sys_template CHANGE t3ver_oid t3ver_oid int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE sys_template CHANGE t3ver_id t3ver_id int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE sys_template CHANGE t3ver_label t3ver_label varchar(30) NOT NULL default ''; 
 Current value: varchar(30) DEFAULT '' NOT NULL 
 ALTER TABLE sys_template DROP PRIMARY KEY; 
 ALTER TABLE sys_template ADD PRIMARY KEY (uid); 
 ALTER TABLE tt_content CHANGE uid uid int(11) NOT NULL auto_increment; 
 Current value: int(11) DEFAULT '0' NOT NULL auto_increment 
 ALTER TABLE tt_content CHANGE pid pid int(11) NOT NULL default '0'; 
 Current value: int(11) DEFAULT '0' NOT NULL 
 ALTER TABLE tt_content CHANGE tstamp tstamp int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE tt_content CHANGE hidden hidden tinyint(4) unsigned NOT NULL default '0'; 
 Current value: tinyint(4) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE tt_content CHANGE sorting sorting int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE tt_content CHANGE CType CType varchar(30) NOT NULL default ''; 
 Current value: varchar(30) DEFAULT '' NOT NULL 
 ALTER TABLE tt_content CHANGE header_position header_position varchar(6) NOT NULL default ''; 
 Current value: varchar(6) DEFAULT '' NOT NULL 
 ALTER TABLE tt_content CHANGE imagewidth imagewidth mediumint(11) unsigned NOT NULL default '0'; 
 Current value: mediumint(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE tt_content CHANGE imageorient imageorient tinyint(4) unsigned NOT NULL default '0'; 
 Current value: tinyint(4) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE tt_content CHANGE imagecols imagecols tinyint(4) unsigned NOT NULL default '0'; 
 Current value: tinyint(4) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE tt_content CHANGE imageborder imageborder tinyint(4) unsigned NOT NULL default '0'; 
 Current value: tinyint(4) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE tt_content CHANGE layout layout tinyint(3) unsigned NOT NULL default '0'; 
 Current value: tinyint(3) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE tt_content CHANGE deleted deleted tinyint(4) unsigned NOT NULL default '0'; 
 Current value: tinyint(4) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE tt_content CHANGE cols cols tinyint(3) unsigned NOT NULL default '0'; 
 Current value: tinyint(3) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE tt_content CHANGE starttime starttime int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE tt_content CHANGE endtime endtime int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE tt_content CHANGE colPos colPos tinyint(3) unsigned NOT NULL default '0'; 
 Current value: tinyint(3) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE tt_content CHANGE spaceBefore spaceBefore tinyint(4) unsigned NOT NULL default '0'; 
 Current value: tinyint(4) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE tt_content CHANGE spaceAfter spaceAfter tinyint(4) unsigned NOT NULL default '0'; 
 Current value: tinyint(4) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE tt_content CHANGE fe_group fe_group int(11) NOT NULL default '0'; 
 Current value: int(11) DEFAULT '0' NOT NULL 
 ALTER TABLE tt_content CHANGE imagecaption_position imagecaption_position varchar(6) NOT NULL default ''; 
 Current value: varchar(6) DEFAULT '' NOT NULL 
 ALTER TABLE tt_content CHANGE image_zoom image_zoom tinyint(3) unsigned NOT NULL default '0'; 
 Current value: tinyint(3) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE tt_content CHANGE image_noRows image_noRows tinyint(3) unsigned NOT NULL default '0'; 
 Current value: tinyint(3) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE tt_content CHANGE image_effects image_effects tinyint(3) unsigned NOT NULL default '0'; 
 Current value: tinyint(3) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE tt_content CHANGE image_compression image_compression tinyint(3) unsigned NOT NULL default '0'; 
 Current value: tinyint(3) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE tt_content CHANGE header_layout header_layout varchar(30) NOT NULL default '0'; 
 Current value: varchar(30) DEFAULT '0' NOT NULL 
 ALTER TABLE tt_content CHANGE text_align text_align varchar(6) NOT NULL default ''; 
 Current value: varchar(6) DEFAULT '' NOT NULL 
 ALTER TABLE tt_content CHANGE text_face text_face tinyint(3) unsigned NOT NULL default '0'; 
 Current value: tinyint(3) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE tt_content CHANGE text_size text_size tinyint(3) unsigned NOT NULL default '0'; 
 Current value: tinyint(3) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE tt_content CHANGE text_color text_color tinyint(3) unsigned NOT NULL default '0'; 
 Current value: tinyint(3) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE tt_content CHANGE text_properties text_properties tinyint(3) unsigned NOT NULL default '0'; 
 Current value: tinyint(3) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE tt_content CHANGE menu_type menu_type varchar(30) NOT NULL default '0'; 
 Current value: varchar(30) DEFAULT '0' NOT NULL 
 ALTER TABLE tt_content CHANGE list_type list_type varchar(36) NOT NULL default '0'; 
 Current value: varchar(36) DEFAULT '0' NOT NULL 
 ALTER TABLE tt_content CHANGE table_border table_border tinyint(3) unsigned NOT NULL default '0'; 
 Current value: tinyint(3) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE tt_content CHANGE table_cellspacing table_cellspacing tinyint(3) unsigned NOT NULL default '0'; 
 Current value: tinyint(3) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE tt_content CHANGE table_cellpadding table_cellpadding tinyint(3) unsigned NOT NULL default '0'; 
 Current value: tinyint(3) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE tt_content CHANGE table_bgColor table_bgColor tinyint(3) unsigned NOT NULL default '0'; 
 Current value: tinyint(3) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE tt_content CHANGE select_key select_key varchar(80) NOT NULL default ''; 
 Current value: varchar(80) DEFAULT '' NOT NULL 
 ALTER TABLE tt_content CHANGE sectionIndex sectionIndex tinyint(3) unsigned NOT NULL default '0'; 
 Current value: tinyint(3) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE tt_content CHANGE linkToTop linkToTop tinyint(3) unsigned NOT NULL default '0'; 
 Current value: tinyint(3) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE tt_content CHANGE filelink_size filelink_size tinyint(3) unsigned NOT NULL default '0'; 
 Current value: tinyint(3) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE tt_content CHANGE section_frame section_frame tinyint(3) unsigned NOT NULL default '0'; 
 Current value: tinyint(3) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE tt_content CHANGE date date int(10) unsigned NOT NULL default '0'; 
 Current value: int(10) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE tt_content CHANGE splash_layout splash_layout varchar(30) NOT NULL default '0'; 
 Current value: varchar(30) DEFAULT '0' NOT NULL 
 ALTER TABLE tt_content CHANGE image_frames image_frames tinyint(3) unsigned NOT NULL default '0'; 
 Current value: tinyint(3) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE tt_content CHANGE recursive recursive tinyint(3) unsigned NOT NULL default '0'; 
 Current value: tinyint(3) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE tt_content CHANGE imageheight imageheight mediumint(8) unsigned NOT NULL default '0'; 
 Current value: mediumint(8) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE tt_content CHANGE module_sys_dmail_category module_sys_dmail_category int(10) unsigned NOT NULL default '0'; 
 Current value: int(10) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE tt_content CHANGE rte_enabled rte_enabled tinyint(4) NOT NULL default '0'; 
 Current value: tinyint(4) DEFAULT '0' NOT NULL 
 ALTER TABLE tt_content CHANGE sys_language_uid sys_language_uid int(11) NOT NULL default '0'; 
 Current value: int(11) DEFAULT '0' NOT NULL 
 ALTER TABLE tt_content CHANGE tx_impexp_origuid tx_impexp_origuid int(11) NOT NULL default '0'; 
 Current value: int(11) DEFAULT '0' NOT NULL 
 ALTER TABLE tt_content CHANGE t3ver_oid t3ver_oid int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE tt_content CHANGE t3ver_id t3ver_id int(11) unsigned NOT NULL default '0'; 
 Current value: int(11) unsigned DEFAULT '0' NOT NULL 
 ALTER TABLE tt_content CHANGE t3ver_label t3ver_label varchar(30) NOT NULL default ''; 
 Current value: varchar(30) DEFAULT '' NOT NULL 
 ALTER TABLE tt_content CHANGE l18n_parent l18n_parent int(11) NOT NULL default '0'; 
 Current value: int(11) DEFAULT '0' NOT NULL 
 ALTER TABLE tt_content DROP PRIMARY KEY; 
 ALTER TABLE tt_content ADD PRIMARY KEY (uid); 

Remove unused fields (rename with prefix)
 (EXT) ALTER TABLE tt_content CHANGE tx_mininews_frontpage_list zzz_deleted_tx_mininews_frontpage_list int(11) unsigned DEFAULT '0' NOT NULL; 

Removing tables (rename with prefix)
 ALTER TABLE tt_guest RENAME zzz_deleted_tt_guest; 
 Records in table: 3 
 (EXT) ALTER TABLE tx_veguestbook_entries RENAME zzz_deleted_tx_veguestbook_entries; 
 Records in table: 13 

Drop tables (really!)
 DROP TABLE zzz_deleted_tt_board; 
 Records in table: 2 
 DROP TABLE zzz_deleted_tt_news; 
 Records in table: 3 
 DROP TABLE zzz_deleted_tt_news_cat; 
  
 DROP TABLE zzz_deleted_tt_news_related_mm; 
  



 

--------------------------------------------------------------------------------
OS detected: UNIX
UNIX/CGI detected: NO
PATH_thisScript: /home/u0014363084/public_html/typo3/install/index.php

Ist es das was du meinst?

Dander · 6. April 2005 11:00

uih doch so wenig 🙂

jett geh mal in den phpmyadmin click auf den menüpunkt sql
und kopier das hier in die textarea und klick auf import

ALTER TABLE tx_veguestbook_entries CHANGE uid uid int(11) unsigned NOT NULL auto_increment; 
Current value: int(11) unsigned DEFAULT '0' NOT NULL auto_increment 

CREATE TABLE tx_mininews_news ( 
uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment, 
pid int(11) unsigned DEFAULT '0' NOT NULL, 
tstamp int(11) unsigned DEFAULT '0' NOT NULL, 
crdate int(11) unsigned DEFAULT '0' NOT NULL, 
cruser_id int(11) unsigned DEFAULT '0' NOT NULL, 
deleted tinyint(4) unsigned DEFAULT '0' NOT NULL, 
hidden tinyint(4) unsigned DEFAULT '0' NOT NULL, 
starttime int(11) unsigned DEFAULT '0' NOT NULL, 
endtime int(11) unsigned DEFAULT '0' NOT NULL, 
fe_group int(11) DEFAULT '0' NOT NULL, 
datetime int(11) DEFAULT '0' NOT NULL, 
title tinytext NOT NULL, 
teaser text NOT NULL, 
full_text text NOT NULL, 
front_page tinyint(3) unsigned DEFAULT '0' NOT NULL, 
PRIMARY KEY (uid), 
KEY parent (pid) 
) TYPE=MyISAM; 

DROP TABLE zzz_deleted_tt_board; 
Records in table: 2 
DROP TABLE zzz_deleted_tt_news; 
Records in table: 3 
DROP TABLE zzz_deleted_tt_news_cat; 
  
DROP TABLE zzz_deleted_tt_news_related_mm;

Michaela-Ww · 6. April 2005 11:03

Hallo,

Dander schrieb
uih doch so wenig 🙂

jett geh mal in den phpmyadmin click auf den menüpunkt sql
und kopier das hier in die textarea und klick auf import

ich habe dort keinen Knopf Import.
nur

SQL-Befehl hier wieder anzeigen

oder Datei :

 (Maximale Dateigröße: 8.192KB)
 Kompression:  Autom. Erkennung     keine     GZip-komprimiert     BZip-komprimiert

und OK

soll ich OK drücken?

Dander · 6. April 2005 11:06

ja ok drücken

Michaela-Ww · 6. April 2005 11:08

Dander schrieb
ja ok drücken

hab ich gemacht...
jetzt sagt er mir das:

Datenbank db0014361 auf localhost 
Fehler

SQL-Befehl :  

Current value : int( 11 ) unsigned DEFAULT '0' NOT NULL AUTO_INCREMENT CREATE TABLE tx_mininews_news(

uid int( 11 ) unsigned DEFAULT '0' NOT NULL AUTO_INCREMENT ,
pid int( 11 ) unsigned DEFAULT '0' NOT NULL ,
tstamp int( 11 ) unsigned DEFAULT '0' NOT NULL ,
crdate int( 11 ) unsigned DEFAULT '0' NOT NULL ,
cruser_id int( 11 ) unsigned DEFAULT '0' NOT NULL ,
deleted tinyint( 4 ) unsigned DEFAULT '0' NOT NULL ,
hidden tinyint( 4 ) unsigned DEFAULT '0' NOT NULL ,
starttime int( 11 ) unsigned DEFAULT '0' NOT NULL ,
endtime int( 11 ) unsigned DEFAULT '0' NOT NULL ,
fe_group int( 11 ) DEFAULT '0' NOT NULL ,
datetime int( 11 ) DEFAULT '0' NOT NULL ,
title tinytext NOT NULL ,
teaser text NOT NULL ,
full_text text NOT NULL ,
front_page tinyint( 3 ) unsigned DEFAULT '0' NOT NULL ,
PRIMARY KEY ( uid ) ,
KEY parent( pid ) 
) TYPE = MYISAM 

MySQL meldet: 


#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Current value: int(11) unsigned DEFAULT '0' NOT NULL auto_increment 

CREATE T' at line 1 

[Dokumentation] · [Zurück]

Was mache ich jetzt?