modules/uc_node_access/uc_node_access.install

<?php
// $Id$

function uc_node_access_install() {
  switch ($GLOBALS['db_type']) {
    case 'mysqli':
    case 'mysql':
      db_query("CREATE TABLE {uc_node_access_products} (
        pfid mediumint(9) NOT NULL,
        model varchar(255) NULL,
        access_nid int(10) NOT NULL,
        access_limit varchar(32) NOT NULL,
        time_period varchar(255) NOT NULL,
        end_date varchar(255) NOT NULL,
        PRIMARY KEY pfid (pfid),
        KEY model (model)
      ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ");
      db_query("CREATE TABLE {uc_node_access_expirations} (
        uid mediumint(11) NOT NULL,
        access_nid int(10) NOT NULL,
        expiration int(11) NOT NULL,
        KEY uid (uid),
        KEY access_nid (access_nid)
      ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ");
      break;
  }
}

function uc_node_access_uninstall() {
  db_query("DROP TABLE IF EXISTS {uc_node_access_products}");
  db_query("DROP TABLE IF EXISTS {uc_node_access_expirations}");
}

1	<?php
2	// $Id$
3
4	function uc_node_access_install() {
5	switch ($GLOBALS['db_type']) {
6	case 'mysqli':
7	case 'mysql':
8	db_query("CREATE TABLE {uc_node_access_products} (
9	pfid mediumint(9) NOT NULL,
10	model varchar(255) NULL,
11	access_nid int(10) NOT NULL,
12	access_limit varchar(32) NOT NULL,
13	time_period varchar(255) NOT NULL,
14	end_date varchar(255) NOT NULL,
15	PRIMARY KEY pfid (pfid),
16	KEY model (model)
17	) /!40100 DEFAULT CHARACTER SET UTF8 / ");
18	db_query("CREATE TABLE {uc_node_access_expirations} (
19	uid mediumint(11) NOT NULL,
20	access_nid int(10) NOT NULL,
21	expiration int(11) NOT NULL,
22	KEY uid (uid),
23	KEY access_nid (access_nid)
24	) /!40100 DEFAULT CHARACTER SET UTF8 / ");
25	break;
26	}
27	}
28
29	function uc_node_access_uninstall() {
30	db_query("DROP TABLE IF EXISTS {uc_node_access_products}");
31	db_query("DROP TABLE IF EXISTS {uc_node_access_expirations}");
32	}
33