Thanks for the reply, that tutorial looks a lot clearer!
I've managed to get the module working, but i'm still having the database and extension manager issues.
The SQL syntax looks ok to me (i just double checked it against the code in the link you gave me) and I am using the tl_ prefix. This is the exact code i'm using:
Code:
--
-- Table 'tl_cds'
--
CREATE TABLE 'tl_cds' (
'id' int(10) unsigned NOT NULL auto_increment,
'tstamp' int(10) unsigned NOT NULL default '0',
'title' varchar(64) NOT NULL default ' ',
'artist' varchar(64) NOT NULL default ' ',
'image' varchar(64) NOT NULL default ' ',
'comment' text NULL,
PRIMARY KEY ('id')
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
It's still asking me to drop the tables when I update the database, even though they are being used by the module.
How does contao check which tables are needed by the installed extensions? Does it compare the database with each module's 'database.sql'? Or does it use a different file to determine which modules are using which tables?
Bookmarks