modules/votingapi/votingapi.mysql

#
# Table structure for votingapi data
#

CREATE TABLE votingapi_vote (
  vote_id int(10) unsigned NOT NULL,
  content_type varchar(20) default NULL,
  content_id int(10) unsigned default NULL,
  value float(10) default NULL,
  value_type varchar(20) NOT NULL,
  tag varchar(128) default 'vote',
  uid int(10) unsigned default '0',
  timestamp int(11) default NULL,
  hostname varchar(128) default '0',
  PRIMARY KEY  (vote_id),
  KEY content_type (content_type),
  KEY content_id (content_id)
) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */;
 
CREATE TABLE votingapi_cache (
  vote_cache_id int(10) unsigned NOT NULL,
  content_type varchar(20) default NULL,
  content_id int(10) unsigned default NULL,
  value float(10) default NULL,
  value_type varchar(20) NOT NULL,
  tag varchar(128) default 'vote',
  function varchar(128) default 'count',
  PRIMARY KEY  (vote_cache_id),
  KEY content_type (content_type),
  KEY content_id (content_id)
) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */;

CREATE TABLE votingapi_action_set (
  vasid int(10) unsigned NOT NULL,
  parent int(10) unsigned NOT NULL,
  required int(8) NOT NULL default '0',
  mask varchar(8) default 'AND',
  name varchar(128) default NULL,
  enabled int default 1,
  source varchar(65) default NULL,
  content_type varchar(64) default NULL,
  weight int(10) NOT NULL default 0,
  PRIMARY KEY  (vasid)
) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */;

CREATE TABLE votingapi_action_condition (
  vacid int(10) unsigned NOT NULL,
  vasid int(10) unsigned NOT NULL,
  weight int(10) NOT NULL default 0,
  value varchar(255),
  handler varchar(255) NOT NULL,
  PRIMARY KEY  (vacid)
) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */;

CREATE TABLE votingapi_action (
  vasid int(10) unsigned NOT NULL,
  aid varchar(255) NOT NULL default '0'
) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */;
1	#
2	# Table structure for votingapi data
3	#
4
5	CREATE TABLE votingapi_vote (
6	vote_id int(10) unsigned NOT NULL,
7	content_type varchar(20) default NULL,
8	content_id int(10) unsigned default NULL,
9	value float(10) default NULL,
10	value_type varchar(20) NOT NULL,
11	tag varchar(128) default 'vote',
12	uid int(10) unsigned default '0',
13	timestamp int(11) default NULL,
14	hostname varchar(128) default '0',
15	PRIMARY KEY (vote_id),
16	KEY content_type (content_type),
17	KEY content_id (content_id)
18	) TYPE=MyISAM /!40100 DEFAULT CHARACTER SET utf8 /;
19
20	CREATE TABLE votingapi_cache (
21	vote_cache_id int(10) unsigned NOT NULL,
22	content_type varchar(20) default NULL,
23	content_id int(10) unsigned default NULL,
24	value float(10) default NULL,
25	value_type varchar(20) NOT NULL,
26	tag varchar(128) default 'vote',
27	function varchar(128) default 'count',
28	PRIMARY KEY (vote_cache_id),
29	KEY content_type (content_type),
30	KEY content_id (content_id)
31	) TYPE=MyISAM /!40100 DEFAULT CHARACTER SET utf8 /;
32
33	CREATE TABLE votingapi_action_set (
34	vasid int(10) unsigned NOT NULL,
35	parent int(10) unsigned NOT NULL,
36	required int(8) NOT NULL default '0',
37	mask varchar(8) default 'AND',
38	name varchar(128) default NULL,
39	enabled int default 1,
40	source varchar(65) default NULL,
41	content_type varchar(64) default NULL,
42	weight int(10) NOT NULL default 0,
43	PRIMARY KEY (vasid)
44	) TYPE=MyISAM /!40100 DEFAULT CHARACTER SET utf8 /;
45
46	CREATE TABLE votingapi_action_condition (
47	vacid int(10) unsigned NOT NULL,
48	vasid int(10) unsigned NOT NULL,
49	weight int(10) NOT NULL default 0,
50	value varchar(255),
51	handler varchar(255) NOT NULL,
52	PRIMARY KEY (vacid)
53	) TYPE=MyISAM /!40100 DEFAULT CHARACTER SET utf8 /;
54
55	CREATE TABLE votingapi_action (
56	vasid int(10) unsigned NOT NULL,
57	aid varchar(255) NOT NULL default '0'
58	) TYPE=MyISAM /!40100 DEFAULT CHARACTER SET utf8 /;