modules/relativity/relativity.mysql

CREATE TABLE relativity (
  nid int(10) unsigned NOT NULL default '0',
  parent_nid int(10) unsigned NOT NULL default '0',
  KEY nid (nid),
  KEY parent_nid (nid)
) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */;

CREATE TABLE relativity_query (
  nid int(10) unsigned NOT NULL default '0',
  target_nid int(10) unsigned,
  follow_parents int(10) unsigned,
  follow_children int(10) unsigned,
  recursion_depth int(10) unsigned,
  unique_types int(10) unsigned,
  max_results int(10) unsigned,
  options longtext,
  search_algorithm varchar(20) default 'dfs',
  search_types longtext,
  end_pts longtext,
  avoid_pts longtext,
  KEY nid (nid)
) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */;

1	CREATE TABLE relativity (
2	nid int(10) unsigned NOT NULL default '0',
3	parent_nid int(10) unsigned NOT NULL default '0',
4	KEY nid (nid),
5	KEY parent_nid (nid)
6	) TYPE=MyISAM /!40100 DEFAULT CHARACTER SET utf8 /;
7
8	CREATE TABLE relativity_query (
9	nid int(10) unsigned NOT NULL default '0',
10	target_nid int(10) unsigned,
11	follow_parents int(10) unsigned,
12	follow_children int(10) unsigned,
13	recursion_depth int(10) unsigned,
14	unique_types int(10) unsigned,
15	max_results int(10) unsigned,
16	options longtext,
17	search_algorithm varchar(20) default 'dfs',
18	search_types longtext,
19	end_pts longtext,
20	avoid_pts longtext,
21	KEY nid (nid)
22	) TYPE=MyISAM /!40100 DEFAULT CHARACTER SET utf8 /;
23