[BUGFIX] Fix syntax errors in ext_tables.sql files

Fix syntax errors by removing commas in excess after the last column/ key definition, add commas missing after column/key definitions and removing default values for auto_increment columns. Change-Id: Ica2dd1689211e56f6d9b01f7992867262cac3b5d Resolves: #77706 Releases: master, 7.6 Reviewed-on: https://review.typo3.org/49675 Tested-by: Bamboo TYPO3com <info@typo3.com> Reviewed-by: Andreas Fernandez <typo3@scripting-base.de> Tested-by: Andreas Fernandez <typo3@scripting-base.de> Reviewed-by: Wouter Wolters <typo3@wouterwolters.nl> Tested-by: Wouter Wolters <typo3@wouterwolters.nl>

[BUGFIX] Fix syntax errors in ext_tables.sql files
Fix syntax errors by removing commas in excess after the last column/ key definition, add commas missing after column/key definitions and removing default values for auto_increment columns. Change-Id: Ica2dd1689211e56f6d9b01f7992867262cac3b5d Resolves: #77706 Releases: master, 7.6 Reviewed-on: https://review.typo3.org/49675 Tested-by: Bamboo TYPO3com <info@typo3.com> Reviewed-by: Andreas Fernandez <typo3@scripting-base.de> Tested-by: Andreas Fernandez <typo3@scripting-base.de> Reviewed-by: Wouter Wolters <typo3@wouterwolters.nl> Tested-by: Wouter Wolters <typo3@wouterwolters.nl>
5ebf8154 · Morton Jonuschat · Wouter Wolters · e794574f · 5ebf8154 · 5ebf8154
Commit 5ebf8154 authored 8 years ago by Morton Jonuschat Committed by Wouter Wolters 8 years ago
--- a/typo3/sysext/extbase/ext_tables.sql
+++ b/typo3/sysext/extbase/ext_tables.sql
@@ -2,12 +2,12 @@
 # Add field 'tx_extbase_type' to table 'fe_users'
 #
 CREATE TABLE fe_users (
-	tx_extbase_type varchar(255) DEFAULT '0' NOT NULL,
+	tx_extbase_type varchar(255) DEFAULT '0' NOT NULL
 );

 #
 # Add field 'tx_extbase_type' to table 'fe_groups'
 #
 CREATE TABLE fe_groups (
-	tx_extbase_type varchar(255) DEFAULT '0' NOT NULL,
+	tx_extbase_type varchar(255) DEFAULT '0' NOT NULL
 );
--- a/typo3/sysext/fluid_styled_content/ext_tables.sql
+++ b/typo3/sysext/fluid_styled_content/ext_tables.sql
@@ -5,5 +5,5 @@ CREATE TABLE tt_content (
 	bullets_type tinyint(3) unsigned DEFAULT '0' NOT NULL,
 	uploads_description tinyint(1) unsigned DEFAULT '0' NOT NULL,
 	uploads_type tinyint(3) unsigned DEFAULT '0' NOT NULL,
-	assets int(11) unsigned DEFAULT '0' NOT NULL,
+	assets int(11) unsigned DEFAULT '0' NOT NULL
 );
--- a/typo3/sysext/indexed_search_mysql/ext_tables.sql
+++ b/typo3/sysext/indexed_search_mysql/ext_tables.sql
@@ -10,7 +10,7 @@ CREATE TABLE index_fulltext (
  phash int(11) DEFAULT '0' NOT NULL,
  fulltextdata mediumtext,
  metaphonedata mediumtext,
-  PRIMARY KEY (phash)
-  FULLTEXT fulltextdata (fulltextdata)
+  PRIMARY KEY (phash),
+  FULLTEXT fulltextdata (fulltextdata),
  FULLTEXT metaphonedata (metaphonedata)
 ) ENGINE=MyISAM;
--- a/typo3/sysext/scheduler/ext_tables.sql
+++ b/typo3/sysext/scheduler/ext_tables.sql
@@ -21,7 +21,7 @@ CREATE TABLE tx_scheduler_task (
 # Table structure for table 'tx_scheduler_task_group'
 #
 CREATE TABLE tx_scheduler_task_group (
-	uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
+	uid int(11) unsigned 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,