modules/weblink/weblink.mysql

-- $Id: weblinks.mysql,v 1.2 2005/02/02 22:40:26 syscrusher Exp $

-- WARNING! This is a preliminary version for a rewritten "weblinks"
-- module. DO NOT apply this against an existing Drupal installation,
-- or it will ERASE your weblinks table.

DROP TABLE IF EXISTS weblinks;

-- lid, the link ID, is linked to the sequence weblinks_lid
CREATE TABLE weblinks (
  lid INT(10) UNSIGNED NOT NULL DEFAULT '0',
  url_md5 CHAR(32) NOT NULL,
  url TEXT NOT NULL DEFAULT '',
  clicks INT(10) UNSIGNED NOT NULL DEFAULT '0',
  last_click_time INT(11) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY (lid),
  UNIQUE INDEX url_ix (url_md5),
  UNIQUE INDEX stale_ix (last_click_time, lid),
  INDEX short_url_ix (url(20))
);

DROP TABLE IF EXISTS weblinks_node;

-- lid is a foreign key to weblinks
CREATE TABLE weblinks_node (
  lid INT(10) UNSIGNED NOT NULL DEFAULT '0',
  nid INT(10) UNSIGNED NOT NULL DEFAULT '0',
  weight INT(4) NOT NULL DEFAULT '0',
  link_title VARCHAR(255) NOT NULL DEFAULT '',
  PRIMARY KEY (lid, nid),
  UNIQUE INDEX node_link_ix (nid, lid, weight)
);
1	-- $Id: weblinks.mysql,v 1.2 2005/02/02 22:40:26 syscrusher Exp $
2
3	-- WARNING! This is a preliminary version for a rewritten "weblinks"
4	-- module. DO NOT apply this against an existing Drupal installation,
5	-- or it will ERASE your weblinks table.
6
7	DROP TABLE IF EXISTS weblinks;
8
9	-- lid, the link ID, is linked to the sequence weblinks_lid
10	CREATE TABLE weblinks (
11	lid INT(10) UNSIGNED NOT NULL DEFAULT '0',
12	url_md5 CHAR(32) NOT NULL,
13	url TEXT NOT NULL DEFAULT '',
14	clicks INT(10) UNSIGNED NOT NULL DEFAULT '0',
15	last_click_time INT(11) UNSIGNED NOT NULL DEFAULT '0',
16	PRIMARY KEY (lid),
17	UNIQUE INDEX url_ix (url_md5),
18	UNIQUE INDEX stale_ix (last_click_time, lid),
19	INDEX short_url_ix (url(20))
20	);
21
22	DROP TABLE IF EXISTS weblinks_node;
23
24	-- lid is a foreign key to weblinks
25	CREATE TABLE weblinks_node (
26	lid INT(10) UNSIGNED NOT NULL DEFAULT '0',
27	nid INT(10) UNSIGNED NOT NULL DEFAULT '0',
28	weight INT(4) NOT NULL DEFAULT '0',
29	link_title VARCHAR(255) NOT NULL DEFAULT '',
30	PRIMARY KEY (lid, nid),
31	UNIQUE INDEX node_link_ix (nid, lid, weight)
32	);