1
I've created simple module, which uses MySQL bases.
During module installation some sql tables should be created, if not exists.
module's xoops_version.php (sql part)
$modversion['sqlfile']['mysql'] = "sql/mysql.sql";
mysql.sql code:
CREATE TABLE IF NOT EXISTS Actions ( actions_id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, actions_desc TEXT NOT NULL, PRIMARY KEY(actions_id) );
Error during installation: SQL script error (IF NOT EXISTS).
If remove, the module can not be installed if tables already exist.
How can i create tables, if they don't exist only?
