[TYPO3-dev] EXT: Database updates - CREATE OR REPLACE VIEW

[Tomas Norre Mikkelsen]

Hi,

When installing my extension, there is several CREATE TABLE statements, 
but i also got some CREATE OR REPLACE VIEW statements:

CREATE OR REPLACE VIEW offers AS SELECT * FROM 
tx_niaaldestinations_offers_1;
CREATE OR REPLACE VIEW offers_transport AS SELECT * FROM 
tx_niaaldestinations_offers_transports_1;

Any reasons why they aren't shown in Database updates in Extension 
Manager? Are they left out intentionally or is it a bug?

I Also got problems with my foreign keys, they are shown as updates, but 
newer removed cause they will not succeed.

ALTER TABLE tx_niaaldestinations_offers_1 ADD FOREIGN KEY 
(destinations_id) REFERENCES tx_niaaldestinations_destination(uid) ON 
DELETE CASCADE;

When copy/paste the exact line of SQL to eg. phpmyadmin, the SQL works 
fine.

Hints on that ??

-- 
Venlig Hilsen / Best Regards
Tomas Norre Mikkelsen
Tomasnorre at gmail.com

TYPO3 Developer @netimage.dk
TYPO3 Profile:
http://forge.typo3.org/users/4289


Follow me at twitter
Twitter.com/tomasnorre