maintenance/oracle/archives/patch-trackbacks.sql

   1 CREATE SEQUENCE trackbacks_id_seq;
   2 CREATE TABLE trackbacks (
   3         tb_id           NUMBER PRIMARY KEY,
   4         tb_page         NUMBER(8) REFERENCES page(page_id) ON DELETE CASCADE,
   5         tb_title        VARCHAR(255) NOT NULL,
   6         tb_url          VARCHAR(255) NOT NULL,
   7         tb_ex           CLOB,
   8         tb_name         VARCHAR(255)
   9 );
  10 CREATE INDEX tb_name_page_idx ON trackbacks(tb_page);