Correct pgsql creation sql

This is the correct pgsql creation sql:

CREATE TABLE janode (
vid INT NOT NULL DEFAULT 0,
nid INT NOT NULL DEFAULT 0,
http_link VARCHAR(255) NOT NULL DEFAULT '',
http_anchor VARCHAR(255) DEFAULT '',
http_recip VARCHAR(255) DEFAULT '',
http_click INT DEFAULT 0,
last_checked TIMESTAMP DEFAULT '2000-01-01 00:00:00',
status INT NOT NULL DEFAULT 0,
PRIMARY KEY (vid, nid)
);
CREATE INDEX idx_janode_last_checked ON janode (last_checked);
CREATE INDEX idx_janode_status ON janode (status);