diff options
Diffstat (limited to 'maintenance/oracle/archives')
-rw-r--r-- | maintenance/oracle/archives/patch-trackbacks.sql | 10 | ||||
-rw-r--r-- | maintenance/oracle/archives/patch-transcache.sql | 5 |
2 files changed, 0 insertions, 15 deletions
diff --git a/maintenance/oracle/archives/patch-trackbacks.sql b/maintenance/oracle/archives/patch-trackbacks.sql deleted file mode 100644 index 15d4eef1..00000000 --- a/maintenance/oracle/archives/patch-trackbacks.sql +++ /dev/null @@ -1,10 +0,0 @@ -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); diff --git a/maintenance/oracle/archives/patch-transcache.sql b/maintenance/oracle/archives/patch-transcache.sql deleted file mode 100644 index 62ad2c7d..00000000 --- a/maintenance/oracle/archives/patch-transcache.sql +++ /dev/null @@ -1,5 +0,0 @@ -CREATE TABLE transcache ( - tc_url VARCHAR2(255) NOT NULL UNIQUE, - tc_contents CLOB, - tc_time TIMESTAMP NOT NULL -); |