From b5011db653355251c30da30525072ede27fa1769 Mon Sep 17 00:00:00 2001 From: River Tarnell Date: Tue, 2 Aug 2005 13:49:01 +0000 Subject: [PATCH] trackbacks table for oracle --- maintenance/oracle/archives/patch-trackbacks.sql | 10 ++++++++++ 1 file changed, 10 insertions(+) create mode 100644 maintenance/oracle/archives/patch-trackbacks.sql diff --git a/maintenance/oracle/archives/patch-trackbacks.sql b/maintenance/oracle/archives/patch-trackbacks.sql new file mode 100644 index 0000000000..15d4eef1ca --- /dev/null +++ b/maintenance/oracle/archives/patch-trackbacks.sql @@ -0,0 +1,10 @@ +CREATE SEQUENCE trackbacks_id_seq; +CREATE TABLE trackbacks ( + tb_id NUMBER PRIMARY KEY, + tb_page NUMBER(8) REFERENCES page(page_id) ON DELETE CASCADE, + tb_title VARCHAR(255) NOT NULL, + tb_url VARCHAR(255) NOT NULL, + tb_ex CLOB, + tb_name VARCHAR(255) +); +CREATE INDEX tb_name_page_idx ON trackbacks(tb_page); -- 2.20.1