modules/userreview/userreview.install

<?php

/* $Id$ */

function userreview_install() {
	drupal_set_message('Installing userreview');
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    	db_query("
      CREATE TABLE {userreview} (
        nid int(10) unsigned NOT NULL default '0',
        content_type varchar(20) default NULL,
        content_id int(10) unsigned default NULL,
        vote_id int(10) unsigned default NULL,
        vote_value float(10) default NULL,
        vote_tag varchar(128) default NULL,
        uid int(10) unsigned default NULL,
        review_text text default NULL,
        PRIMARY KEY  (nid),
        INDEX content_id (content_id),
        INDEX vote_id (vote_id),
        INDEX uid (uid)
      ) /*!40100 DEFAULT CHARACTER SET utf8 */;");
      break;
    case 'mysqli':
      db_query("
      CREATE TABLE {userreview} (
        nid int(10) unsigned NOT NULL default '0',
        content_type varchar(20) default NULL,
        content_id int(10) unsigned default NULL,
        vote_id int(10) unsigned default NULL,
        vote_value float(10) default NULL,
        vote_tag varchar(128) default NULL,
        uid int(10) unsigned default NULL,
        review_text text default NULL,
        PRIMARY KEY  (nid),
        INDEX content_id (content_id),
        INDEX vote_id (vote_id),
        INDEX uid (uid)
      ) /*!40100 DEFAULT CHARACTER SET utf8 */;");
      break;
  }
}
?>
1	<?php
2
3	/* $Id$ */
4
5	function userreview_install() {
6	drupal_set_message('Installing userreview');
7	switch ($GLOBALS['db_type']) {
8	case 'mysql':
9	db_query("
10	CREATE TABLE {userreview} (
11	nid int(10) unsigned NOT NULL default '0',
12	content_type varchar(20) default NULL,
13	content_id int(10) unsigned default NULL,
14	vote_id int(10) unsigned default NULL,
15	vote_value float(10) default NULL,
16	vote_tag varchar(128) default NULL,
17	uid int(10) unsigned default NULL,
18	review_text text default NULL,
19	PRIMARY KEY (nid),
20	INDEX content_id (content_id),
21	INDEX vote_id (vote_id),
22	INDEX uid (uid)
23	) /!40100 DEFAULT CHARACTER SET utf8 /;");
24	break;
25	case 'mysqli':
26	db_query("
27	CREATE TABLE {userreview} (
28	nid int(10) unsigned NOT NULL default '0',
29	content_type varchar(20) default NULL,
30	content_id int(10) unsigned default NULL,
31	vote_id int(10) unsigned default NULL,
32	vote_value float(10) default NULL,
33	vote_tag varchar(128) default NULL,
34	uid int(10) unsigned default NULL,
35	review_text text default NULL,
36	PRIMARY KEY (nid),
37	INDEX content_id (content_id),
38	INDEX vote_id (vote_id),
39	INDEX uid (uid)
40	) /!40100 DEFAULT CHARACTER SET utf8 /;");
41	break;
42	}
43	}
44	?>