[TYPO3-core] RFC: Remove "default 0" from auto_increment lines in SQL files

Karsten Dambekalns karsten at typo3.org
Mon Jan 16 12:32:18 CET 2006


Hi.

On Saturday 14 January 2006 14:44, Michael Stucki wrote:
> I already have the patch ready, just wanted to find out if "NOT NULL" is
> the same like "". The patch is attached.

Ok. If you move the replcaement before the auto_inc check, you can remove the 
(NOT) NULL from the preg expression... :)'

> The patch also changes "UNIQUE KEY" to "UNIQUE" because it seems the first
> was wrong, but it appeared in an extension I've seen (Sebastians "be_acl"
> extension). I think it's ok if we fix this automatically.

Not wrong if used in a field definition, there one can use UNIQUE [KEY].
If you add a unique index to the table outside of the field definition, you 
can only use UNIQUE [INDEX]. Great, eh?

I'd have to check whether the core "understands" both UNIQUE and UNIQUE KEY, 
depending on that it might make sense to replace that.

Karsten
-- 
Karsten Dambekalns
TYPO3 Association - Active Member
http://association.typo3.org/
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 307 bytes
Desc: not available
Url : http://lists.netfielders.de/pipermail/typo3-team-core/attachments/20060116/3e0f5ca7/attachment.pgp 


More information about the TYPO3-team-core mailing list