You are here

Home » API reference » Hosting 5 » hosting_site.install

function hosting_site_install in Hosting 5

Same name and namespace in other branches
  1. 6.2 site/hosting_site.install \hosting_site_install()

File

site/hosting_site.install, line 3

Code

function hosting_site_install() {
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      db_query("CREATE TABLE {hosting_site} (\n        vid int(10) unsigned NOT NULL default '0',\n        nid int(10) unsigned NOT NULL default '0',\n        client int(11) NOT NULL default '0',\n        db_server int(11) NOT NULL default '0',\n        platform int(11) NOT NULL default '0',\n        profile int(11) NOT NULL default '0',\n        language VARCHAR(10) NOT NULL default 'en',\n        last_cron int(10) default NULL,\n        verified int(10) NOT NULL default '0',\n        status tinyint NOT NULL default '0',\n        PRIMARY KEY  (vid)\n      ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ");
      db_query("CREATE TABLE {hosting_site_backups} (\n        bid int(10) unsigned NOT NULL,\n        site int(10) NOT NULL default '0',\n        web_server int(10) NOT NULL default '0',\n        description longtext,\n        filename longtext,\n        timestamp int(11) default NULL,\n        PRIMARY KEY  (bid)    \n        ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ");
      break;
  }
}