Skip to content
Snippets Groups Projects
Commit d4f994ff authored by Morton Jonuschat's avatar Morton Jonuschat Committed by Wouter Wolters
Browse files

[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/49674


Reviewed-by: default avatarAndreas Fernandez <typo3@scripting-base.de>
Tested-by: default avatarAndreas Fernandez <typo3@scripting-base.de>
Reviewed-by: default avatarWouter Wolters <typo3@wouterwolters.nl>
Tested-by: default avatarWouter Wolters <typo3@wouterwolters.nl>
parent 3da4973f
No related branches found
No related tags found
No related merge requests found
......@@ -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
);
......@@ -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
);
......@@ -2,5 +2,5 @@
# Table structure for table 'tt_content'
#
CREATE TABLE tt_content (
tx_form_predefinedform varchar(255) DEFAULT '' NOT NULL,
tx_form_predefinedform varchar(255) DEFAULT '' NOT NULL
);
......@@ -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;
......@@ -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,
......
0% Loading or .
You are about to add 0 people to the discussion. Proceed with caution.
Finish editing this message first!
Please register or to comment