Custom Drupal Module not creating any tables
- by Anthony
Anything specific I need in the module file?
Install File
function module_install() {
//lets create the school database
$create_table_sql = "CREATE TABLE IF NOT EXISTS `table1` (
id int(11) NOT NULL,
principal_name varchar(300) NOT NULL,
school_name varchar(300) NOT NULL,
address1 varchar(300) NOT NULL,
address2 varchar(300) NOT NULL,
city varchar(300) NOT NULL,
computer_serial_no varchar(300) NOT NULL,
state varchar(200) NOT NULL,
uid int(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1";
db_query($create_table_sql);
//lets create the student database
$create_table_sql = "CREATE TABLE IF NOT EXISTS table2 (
id int(11) NOT NULL,
principal_name varchar(300) NOT NULL,
school_name varchar(300) NOT NULL,
address1 varchar(300) NOT NULL,
address2 varchar(300) NOT NULL,
city varchar(300) NOT NULL,
computer_serial_no varchar(300) NOT NULL,
state varchar(200) NOT NULL,
uid int(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1";
db_query($create_table_sql);
}
/**
* _UNINSTALL hook
*
* This function is run to uninstall the module.
*
*/
function module_uninstall() {
// Delete the DB
db_query("drop table table1");
db_query("drop table table2");
}
Info File Just in Case
; $Id$
name = My Module
description = This module deals with blah blah
package = Somepackage
core = 6.x
version = "6.x-1.0"
core = "6.x"
