blob: 15d4eef1cade23eb6af5e96751a825ae937521b0 (
plain)
1
2
3
4
5
6
7
8
9
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);
|