Add a new table using the install file
This is how you should add a new table for your module in the install file using the hook_update_N in Drupal 6
database
Handy SQL print in table for drupal
Privileges to MySQL using Drupal
This is the privileges to MySQL database when using Drupal.
- SELECT
- INSERT
- UPDATE
- DELETE
- CREATE
- DROP
- INDEX
- ALTER
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER ON databasename.* TO 'username'@'localhost' IDENTIFIED BY 'password'; Source: http://drupal.org/getting-started/6/install/create-database
Settings in Drupal at Oderland
This is my settings in settings.php to my oderland.se account:
$db_url = 'mysqli://account_dbuser:password@localhost/account_dbname';
$db_prefix = ''; To run cron on Drupal multisite I use the built in user interface for Unix:
Settings in Drupal at Surftown
This is my settings in settings.php to my surftown.se account:
$db_url = 'mysql://user_account:XXXXXXXX@mydbXX.surftown.se/user_database';
$db_prefix = '';WARNING! Surftown are using safe_mod=on. If you want to use file upload you have to manipulate file.inc in core. See this hack Have not tested it myself yet.