Project

General

Profile

Actions

Bug #51090

closed

SQL parser does not analyse NOT NULL in extension SQL files

Added by Tobias Klepp over 11 years ago. Updated about 7 years ago.

Status:
Closed
Priority:
Should have
Category:
Install Tool
Target version:
Start date:
2013-08-15
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
6.1
PHP Version:
5.3
Tags:
Complexity:
Is Regression:
No
Sprint Focus:

Description

If I start the database analyzer in the install tool, the SQL parser didn't analyse the NULL attribute of the tables.

In ext_tables.sql there are the following example definition:

#
# Table structure for table 'tx_extkey_tablename'
#
CREATE TABLE tx_extkey_tablename (
  uid int(11) NOT NULL auto_increment,
  pid int(11) DEFAULT '0' NOT NULL,
  tstamp int(11) DEFAULT '0' NOT NULL,
  crdate int(11) DEFAULT '0' NOT NULL,
  cruser_id int(11) DEFAULT '0' NOT NULL,
  deleted tinyint(4) DEFAULT '0' NOT NULL,
  hidden tinyint(4) DEFAULT '0' NOT NULL,
  title varchar(150) DEFAULT '' NOT NULL,
  example tinyint(4) DEFAULT '0' NOT NULL,

  PRIMARY KEY (uid),
  KEY parent (pid)
);

In the database the structure looks like this:

#
# Table structure for table 'tx_extkey_tablename'
#
CREATE TABLE tx_extkey_tablename (
  uid int(11) NOT NULL auto_increment,
  pid int(11) DEFAULT '0' NOT NULL,
  tstamp int(11) DEFAULT '0' NOT NULL,
  crdate int(11) DEFAULT '0' NOT NULL,
  cruser_id int(11) DEFAULT '0' NOT NULL,
  deleted tinyint(4) DEFAULT '0' NOT NULL,
  hidden tinyint(4) DEFAULT '0' NOT NULL,
  title varchar(150) DEFAULT '' NOT NULL,
  example tinyint(4) DEFAULT '0',

  PRIMARY KEY (uid),
  KEY parent (pid)
);

The database analyzer say, that everything is ok. Nothing to do. But that's not true.


Related issues 1 (0 open1 closed)

Related to TYPO3 Core - Bug #64616: Compare Database does not remove 'NOT NULL'Closed2015-01-29

Actions
Actions

Also available in: Atom PDF