modules/votingapi/votingapi_actions.install

<?php

// $Id: votingapi.install,v 1.19 2006/06/10 04:38:00 eaton Exp $

function votingapi_actions_install() {
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      db_query("CREATE TABLE {votingapi_action_set} (
           name varchar(64) NOT NULL,
           source varchar(64) default NULL,
           description varchar(255) default NULL,
           parent_name varchar(64) default NULL,
           required int(8) NOT NULL default '0',
           condition_mask varchar(8) default 'AND',
           content_type varchar(20) default NULL,
           weight int(10) NOT NULL default 0,
           PRIMARY KEY  (name)
         ) /*!40100 DEFAULT CHARACTER SET utf8 */;");

      db_query("CREATE TABLE {votingapi_action_condition} (
          name varchar(64) NOT NULL,
          parent_name varchar(64) default NULL,
          description varchar(255) NOT NULL,
          weight int(10) NOT NULL default 0,
          data varchar(255),
          handler varchar(255) NOT NULL,
          PRIMARY KEY  (name)
        ) /*!40100 DEFAULT CHARACTER SET utf8 */;");

      db_query("CREATE TABLE {votingapi_action} (
          parent_name varchar(64) NOT NULL,
          aid varchar(255) NOT NULL
        ) /*!40100 DEFAULT CHARACTER SET utf8 */;");
      break;

    case 'pgsql':
      db_query("CREATE TABLE {votingapi_action_set} (
           name varchar(64) NOT NULL,
           source varchar(64) default NULL,
           description varchar(255) default NULL,
           parent_name varchar(64) default NULL,
           required int4 NOT NULL default '0',
           condition_mask varchar(8) default 'AND',
           content_type varchar(20) default NULL,
           weight int4 NOT NULL default 0,
           PRIMARY KEY  (name));");

      db_query("CREATE TABLE {votingapi_action_condition} (
          name varchar(64) NOT NULL,
          parent_name varchar(64) default NULL,
          description varchar(255) NOT NULL,
          weight int4 NOT NULL default 0,
          data varchar(255),
          handler varchar(255) NOT NULL,
          PRIMARY KEY  (name));");

      db_query("CREATE TABLE {votingapi_action} (
          parent_name varchar(64) NOT NULL,
          aid varchar(255) NOT NULL);");
      break;
  }
}
1	<?php
2
3	// $Id: votingapi.install,v 1.19 2006/06/10 04:38:00 eaton Exp $
4
5	function votingapi_actions_install() {
6	switch ($GLOBALS['db_type']) {
7	case 'mysql':
8	case 'mysqli':
9	db_query("CREATE TABLE {votingapi_action_set} (
10	name varchar(64) NOT NULL,
11	source varchar(64) default NULL,
12	description varchar(255) default NULL,
13	parent_name varchar(64) default NULL,
14	required int(8) NOT NULL default '0',
15	condition_mask varchar(8) default 'AND',
16	content_type varchar(20) default NULL,
17	weight int(10) NOT NULL default 0,
18	PRIMARY KEY (name)
19	) /!40100 DEFAULT CHARACTER SET utf8 /;");
20
21	db_query("CREATE TABLE {votingapi_action_condition} (
22	name varchar(64) NOT NULL,
23	parent_name varchar(64) default NULL,
24	description varchar(255) NOT NULL,
25	weight int(10) NOT NULL default 0,
26	data varchar(255),
27	handler varchar(255) NOT NULL,
28	PRIMARY KEY (name)
29	) /!40100 DEFAULT CHARACTER SET utf8 /;");
30
31	db_query("CREATE TABLE {votingapi_action} (
32	parent_name varchar(64) NOT NULL,
33	aid varchar(255) NOT NULL
34	) /!40100 DEFAULT CHARACTER SET utf8 /;");
35	break;
36
37	case 'pgsql':
38	db_query("CREATE TABLE {votingapi_action_set} (
39	name varchar(64) NOT NULL,
40	source varchar(64) default NULL,
41	description varchar(255) default NULL,
42	parent_name varchar(64) default NULL,
43	required int4 NOT NULL default '0',
44	condition_mask varchar(8) default 'AND',
45	content_type varchar(20) default NULL,
46	weight int4 NOT NULL default 0,
47	PRIMARY KEY (name));");
48
49	db_query("CREATE TABLE {votingapi_action_condition} (
50	name varchar(64) NOT NULL,
51	parent_name varchar(64) default NULL,
52	description varchar(255) NOT NULL,
53	weight int4 NOT NULL default 0,
54	data varchar(255),
55	handler varchar(255) NOT NULL,
56	PRIMARY KEY (name));");
57
58	db_query("CREATE TABLE {votingapi_action} (
59	parent_name varchar(64) NOT NULL,
60	aid varchar(255) NOT NULL);");
61	break;
62	}
63	}