modules/links/links.pgsql

BEGIN;

-- lid, the link ID, is linked to the sequence links_lid
CREATE TABLE links (
  lid INT4 NOT NULL DEFAULT '0',
  url_md5 varchar(32) NOT NULL DEFAULT '',
  url TEXT DEFAULT '' NOT NULL,
  link_title varchar(255) NOT NULL DEFAULT '',
  last_click_time INT4 NOT NULL DEFAULT '0',
  PRIMARY KEY (lid)
);

-- lid is a foreign key to links
CREATE TABLE links_monitor (
  lid INT4 NOT NULL DEFAULT '0',
  check_interval INT4 NOT NULL DEFAULT '0',
  last_check INT4 NOT NULL DEFAULT '0',
  fail_count INT4 NOT NULL DEFAULT '0',
  alternate_monitor_url text,
  redirect_propose_url text,
  redirect_saved_url text,
  change_threshold INT4 NOT NULL DEFAULT '0',
  change_flag INT4 NOT NULL DEFAULT '0',
  change_last_data text,
  PRIMARY KEY (lid)
  );

-- lid is a foreign key to links
-- The interval defaults to 1 week
CREATE TABLE links_node (
  lid INT4 NOT NULL DEFAULT '0',
  nid INT4 NOT NULL DEFAULT '0',
  link_title varchar(255) NOT NULL DEFAULT '',
  weight INT4 NOT NULL DEFAULT '0',
  clicks INT4 NOT NULL DEFAULT '0',
  module varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (lid,nid,module)
);

COMMIT;
1	BEGIN;
2
3	-- lid, the link ID, is linked to the sequence links_lid
4	CREATE TABLE links (
5	lid INT4 NOT NULL DEFAULT '0',
6	url_md5 varchar(32) NOT NULL DEFAULT '',
7	url TEXT DEFAULT '' NOT NULL,
8	link_title varchar(255) NOT NULL DEFAULT '',
9	last_click_time INT4 NOT NULL DEFAULT '0',
10	PRIMARY KEY (lid)
11	);
12
13	-- lid is a foreign key to links
14	CREATE TABLE links_monitor (
15	lid INT4 NOT NULL DEFAULT '0',
16	check_interval INT4 NOT NULL DEFAULT '0',
17	last_check INT4 NOT NULL DEFAULT '0',
18	fail_count INT4 NOT NULL DEFAULT '0',
19	alternate_monitor_url text,
20	redirect_propose_url text,
21	redirect_saved_url text,
22	change_threshold INT4 NOT NULL DEFAULT '0',
23	change_flag INT4 NOT NULL DEFAULT '0',
24	change_last_data text,
25	PRIMARY KEY (lid)
26	);
27
28	-- lid is a foreign key to links
29	-- The interval defaults to 1 week
30	CREATE TABLE links_node (
31	lid INT4 NOT NULL DEFAULT '0',
32	nid INT4 NOT NULL DEFAULT '0',
33	link_title varchar(255) NOT NULL DEFAULT '',
34	weight INT4 NOT NULL DEFAULT '0',
35	clicks INT4 NOT NULL DEFAULT '0',
36	module varchar(100) NOT NULL DEFAULT '',
37	PRIMARY KEY (lid,nid,module)
38	);
39
40	COMMIT;