/[drupal]/contributions/modules/links/links.mysql
ViewVC logotype

Contents of /contributions/modules/links/links.mysql

Parent Directory Parent Directory | Revision Log Revision Log | View Revision Graph Revision Graph

Revision 1.5 - (show annotations) (download)
Sat Jan 21 03:29:46 2006 UTC (3 years, 10 months ago) by syscrusher
Branch: MAIN
CVS Tags: DRUPAL-5--1-12-BETA1, DRUPAL-5--1-7, DRUPAL-5--1-9, DRUPAL-5--1-8, DRUPAL-5--1-5, DRUPAL-5--1-6, DRUPAL-5--1-3, DRUPAL-5--1-2, DRUPAL-6--1-0, DRUPAL-6--1-1, DRUPAL-6--1-2, DRUPAL-4-7--1-1, DRUPAL-5--1-4, DRUPAL-6--1-0-BETA15, DRUPAL-6--1-0-BETA14, DRUPAL-6--1-0-BETA13, DRUPAL-6--1-0-BETA12, DRUPAL-6--1-0-BETA11, DRUPAL-6--1-0-BETA10, DRUPAL-5--1-11, DRUPAL-5--1-10, DRUPAL-5--1-13, DRUPAL-5--1-12, DRUPAL-6--1-0-BETA9, DRUPAL-6--1-0-BETA8, DRUPAL-6--1-0-BETA3, DRUPAL-6--1-0-BETA2, DRUPAL-6--1-0-BETA1, DRUPAL-6--1-0-BETA7, DRUPAL-6--1-0-BETA6, DRUPAL-6--1-0-BETA5, HEAD
Branch point for: DRUPAL-4-7, DRUPAL-6--1, DRUPAL-6--2, DRUPAL-5
Changes since 1.4: +1 -1 lines 
After the UTF8 update, one of the keys was too long in links_node.
Shortened a field to make it fit.
1 -- lid, the link ID, is linked to the sequence links_lid
2 CREATE TABLE links (
3 lid INT(10) UNSIGNED NOT NULL DEFAULT '0',
4 url_md5 CHAR(32) NOT NULL,
5 url TEXT NOT NULL DEFAULT '',
6 link_title VARCHAR(255) NOT NULL DEFAULT '',
7 last_click_time INT(11) UNSIGNED NOT NULL DEFAULT '0',
8 PRIMARY KEY (lid),
9 UNIQUE INDEX url_ix (url_md5),
10 UNIQUE INDEX title_ix (link_title, lid),
11 UNIQUE INDEX stale_ix (last_click_time, lid)
12 ) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */;
13
14 -- lid is a foreign key to links
15 CREATE TABLE links_node (
16 lid INT(10) UNSIGNED NOT NULL DEFAULT '0',
17 nid INT(10) UNSIGNED NOT NULL DEFAULT '0',
18 link_title VARCHAR(255) NOT NULL DEFAULT '',
19 weight INT(4) NOT NULL DEFAULT '0',
20 clicks INT(10) UNSIGNED NOT NULL DEFAULT '0',
21 module VARCHAR(60) NOT NULL,
22 PRIMARY KEY (lid, nid, module),
23 UNIQUE INDEX node_link_ix1 (nid, module, link_title, lid),
24 UNIQUE INDEX node_link_ix2 (link_title, nid, module, lid),
25 UNIQUE INDEX node_link_ix3 (nid, module, lid, weight)
26 ) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */;
27
28 -- lid is a foreign key to links
29 -- The interval defaults to 1 week
30 CREATE TABLE links_monitor (
31 lid INT(10) UNSIGNED NOT NULL DEFAULT '0',
32 check_interval INT(10) UNSIGNED NOT NULL DEFAULT '0',
33 last_check INT(11) NOT NULL DEFAULT '0',
34 fail_count INT(11) NOT NULL DEFAULT '0',
35 alternate_monitor_url TEXT DEFAULT NULL,
36 redirect_propose_url TEXT DEFAULT NULL,
37 redirect_saved_url TEXT DEFAULT NULL,
38 change_threshold INT(11) NOT NULL DEFAULT '0' ,
39 change_flag INT(1) NOT NULL DEFAULT '0',
40 change_last_data TEXT DEFAULT NULL,
41 PRIMARY KEY (lid),
42 UNIQUE INDEX check_ix (last_check, check_interval, lid),
43 UNIQUE INDEX change_ix (change_flag, last_check, lid),
44 UNIQUE INDEX rotted_ix (fail_count, last_check, lid)
45 ) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */;
  ViewVC Help
Powered by ViewVC 1.1.2