Log of /contributions/modules/links/links.mysql

---

Revision 1.5 - (view) (download) (annotate) - [select for diffs]
Sat Jan 21 03:29:46 2006 UTC (3 years, 10 months ago) by syscrusher
Branch: MAIN
CVS Tags: DRUPAL-4-7--1-1, DRUPAL-5--1-10, DRUPAL-5--1-11, DRUPAL-5--1-12, DRUPAL-5--1-12-BETA1, DRUPAL-5--1-13, DRUPAL-5--1-2, DRUPAL-5--1-3, DRUPAL-5--1-4, DRUPAL-5--1-5, DRUPAL-5--1-6, DRUPAL-5--1-7, DRUPAL-5--1-8, DRUPAL-5--1-9, DRUPAL-6--1-0, DRUPAL-6--1-0-BETA1, DRUPAL-6--1-0-BETA10, DRUPAL-6--1-0-BETA11, DRUPAL-6--1-0-BETA12, DRUPAL-6--1-0-BETA13, DRUPAL-6--1-0-BETA14, DRUPAL-6--1-0-BETA15, DRUPAL-6--1-0-BETA2, DRUPAL-6--1-0-BETA3, DRUPAL-6--1-0-BETA5, DRUPAL-6--1-0-BETA6, DRUPAL-6--1-0-BETA7, DRUPAL-6--1-0-BETA8, DRUPAL-6--1-0-BETA9, DRUPAL-6--1-1, DRUPAL-6--1-2, HEAD
Branch point for: DRUPAL-4-7, DRUPAL-5, DRUPAL-6--1, DRUPAL-6--2
Changes since 1.4: +1 -1 lines
Diff to previous 1.4

After the UTF8 update, one of the keys was too long in links_node.
Shortened a field to make it fit.

---

Revision 1.4 - (view) (download) (annotate) - [select for diffs]
Sat Jan 21 02:22:50 2006 UTC (3 years, 10 months ago) by syscrusher
Branch: MAIN
Changes since 1.3: +3 -3 lines
Diff to previous 1.3

Update for UTF8 character set in MySQL per http://drupal.org/node/22218#utf8_sql

---

Revision 1.3 - (view) (download) (annotate) - [select for diffs]
Mon Dec 12 14:53:31 2005 UTC (3 years, 11 months ago) by syscrusher
Branch: MAIN
Changes since 1.2: +0 -3 lines
Diff to previous 1.2

Removed DROP TABLE statements from SQL setups. These had been used during
early testing when retaining data was specifically not desired, but they
are not appropriate now that the schema is stable.

---

Revision 1.2 - (view) (download) (annotate) - [select for diffs]
Thu Jul 14 02:18:59 2005 UTC (4 years, 4 months ago) by syscrusher
Branch: MAIN
Changes since 1.1: +1 -1 lines
Diff to previous 1.1

Fixed problem with key being too long in MySQL table creation script.
This should fix bug 26414.

---

Revision 1.1 - (view) (download) (annotate) - [select for diffs]
Fri Jun 10 04:29:09 2005 UTC (4 years, 5 months ago) by syscrusher
Branch: MAIN

This is the initial public (non-sandbox) commit of the code for the new
"links" bundle. It is a multi-module set that offers the following features:

1. An API for managing URLs in a generic way, and for associating these
   links in a many-to-many relationship with nodes. Each link is
   "normalized" internally, to try to merge references to the same URL
   in the database. If the same URL is used multiple times, it appears
   only once but with many node references in the {links_node} table.
   This helps to make processes such as link monitoring and dead link
   detection more efficient. The API also allows each link-node
   association to (optionally) provide an unique node-local title that
   overrides the global title for that particular URL, but only when
   that node is being displayed. In other words, the same URL can appear
   to have multiple different titles.

2. A main links.module that governs the behavior of the bundle's global
   features, and which implements common functionality such as outlink
   tabulation of clicks. Click tabulation is by node and link, so that it
   is possible to find out not only how many times an outbound link has
   been followed, but also how many times it has been followed from each
   node that refers to it.

3. A links_related.module which allows the administrator to add a link
   field to any desired node types in the system. Currently, the node type
   setting is just a boolean flag, and if on, the node can have zero to
   infinity links. In the next version, however, this will become an
   integer where 0 means no links for the given node type, +N means "up to
   N links" for each node of that type, and -N means "exactly N links
   required (non-empty URL).

4. A links_weblink.module which defines a node type of 'weblink', which
   behaves very much like the node type of the same name by Ber Kessels,
   and which in fact is based on his module's code base but uses the
   new links API.

The SQL schema for monitoring is in this release, but the monitoring
module itself is not yet finished.

This code is EXPERIMENTAL and is under extremely active development. A
project will be created for issue reporting along with this new CVS
release.