All pastes #632342 Raw Edit

Miscellany

public php v1 · immutable
#632342 ·published 2007-07-24 20:09 UTC
rendered paste body
<?phpfunction forward_install() {  switch ($GLOBALS['db_type']) {    case 'mysqli':    case 'mysql':      db_query("CREATE TABLE {cluster_type} (        ct_id int(10) unsigned NOT NULL default 0,        shortname varchar(48) NOT NULL default '',        module varchar(48) NOT NULL default 'node_cluster',        title varchar(128) NOT NULL default '',        description varchar(255) NOT NULL default '',        KEY (ct_id)      ) /*!40100 DEFAULT CHARACTER SET utf8 */;");      db_query("CREATE TABLE {cluster_node_type} (        cnt_id int(10) unsigned NOT NULL default 0,        ct_id int(10) unsigned NOT NULL default 0,        node_type varchar(48) NOT NULL default '',        shortname varchar(48) NOT NULL default '',        title varchar(128) NOT NULL default '',        description varchar(255) NOT NULL default '',        min_allowed int(10) unsigned NOT NULL default 0,        max_allowed int(10) unsigned NOT NULL default 0,        weight int(10) NOT NULL default 0,        count_fields int(1) unsigned NOT NULL default 0,        KEY (ct_id)      ) /*!40100 DEFAULT CHARACTER SET utf8 */;");      db_query("CREATE TABLE {cluster} (        c_id int(10) unsigned NOT NULL default 0,        ct_id int(10) unsigned NOT NULL default 0,        KEY (ct_id)      ) /*!40100 DEFAULT CHARACTER SET utf8 */;");      db_query("CREATE TABLE {cluster_node} (        nid int(10) unsigned NOT NULL default 0,        c_id int(10) unsigned NOT NULL default 0,        cnt_id int(10) unsigned NOT NULL default 0,        KEY (nid, ct_id)      ) /*!40100 DEFAULT CHARACTER SET utf8 */;");      break;    default:      break;  } // End case}function forward_uninstall() {  db_query('DROP TABLE {cluster_type}');  db_query('DROP TABLE {cluster_type_node}');  db_query('DROP TABLE {cluster}');  db_query('DROP TABLE {cluster_node}');}