You are here

function _nodewords_update_create_table in Nodewords: D6 Meta Tags 5

Create the table

2 calls to _nodewords_update_create_table()
nodewords_update_1 in ./nodewords.install
Update: nodewords.module < version 1.9 to nodewords.module version >= 1.9
nodewords_update_2 in ./nodewords.install
Update: nodewords.module <= version v.14 to nodewords.module version >= 1.15

File

./nodewords.install, line 56

Code

function _nodewords_update_create_table() {
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      $ret = update_sql("CREATE TABLE {nodewords} (\n        type varchar(16) NOT NULL,\n        id varchar(255) NOT NULL,\n        name varchar(32) NOT NULL,\n        content varchar(255) NULL,\n        PRIMARY KEY(type, id, name)\n        ) /*!40100 DEFAULT CHARACTER SET utf8 */");
      break;
    case 'pgsql':
      $ret = update_sql("CREATE TABLE {nodewords} (\n        type varchar(16) NOT NULL,\n        id varchar(255) NOT NULL,\n        name varchar(32) NOT NULL,\n        content varchar(255) NULL,\n        PRIMARY KEY(type, id, name)\n        )");
      break;
  }
  return $ret;
}