[TYPO3-english] CREATE OR REPLACE VIEW on extension

[Ries van Twisk]

On Jul 20, 2010, at 10:29 AM, Bjoern Pedersen wrote:

> Am 20.07.2010 17:19, schrieb Sergio:
>> Hi:
>>
>> I've tried to add a new view to my own extension, but I can't get  
>> it to be
>> created when I install the extension. All my tables are created  
>> when I
>> install it except my view. The view syntax is correct inside  
>> ext_tables.sql
>> because I could create it successfully inside phpmyadmin extension.
>>
>> I've tried to add TCA array on ext_tables.php as I do with tables,  
>> but
>> without success.
>>
>> Do I have to do something special to create it?
>>
>> I didn't see any documentation about it out there :(
>>
>> Thanks in advance,
>> Sergio
> Hi,
>
> Probably the TYPO3 sql parser does not understand the VIEWs. The
> sql-file is not passed 'as is' to the database, but parsed and adopted
> (e.g.  all create table calls for existing tables are changed to alter
> table statements).
>
> The  db-experts may give more details here.


You may have more luck adding the view(s) in ext_tables_static+adt.sql,

Ries