diff options
Diffstat (limited to 'maintenance/oracle/archives/patch-trackbacks.sql')
-rw-r--r-- | maintenance/oracle/archives/patch-trackbacks.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/maintenance/oracle/archives/patch-trackbacks.sql b/maintenance/oracle/archives/patch-trackbacks.sql new file mode 100644 index 00000000..15d4eef1 --- /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); |