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

[Michael Stucki]

Hi Karsten,

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

OK, will do.

> > 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?

For some reason TYPO3 always wants to change the table if the SQL file 
contains "UNIQUE KEY". See mentioned be_acl extension for example.

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

It seems that only the first works, that's why I suggested this change by the 
way... :-)

- michael
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
Url : http://lists.netfielders.de/pipermail/typo3-team-core/attachments/20060116/5f99e5c3/attachment.pgp