Return to createTable.sql CVS log

Up to [home] / python / delicious

script for grabbing delicious posts and putting it into a db

-- a single del.icio.us user's bookmarks

--drop table if exists delicious;

create table if not exists delicious (
    id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
    hash CHAR(32) NOT NULL,
    time DATETIME NOT NULL,
    href TEXT NOT NULL,
    description TEXT NOT NULL,
    extended TEXT NOT NULL,
    tag TEXT NOT NULL,
    UNIQUE INDEX (hash)
)