Return to base.sql CVS log

Up to [Coherent Logic Development] / pandia

Annotation of pandia/base.sql, revision 1.1

1.1     ! snw         1: USE pandia;
        !             2: 
        !             3: DROP TABLE IF EXISTS crawl_queue;
        !             4: CREATE TABLE crawl_queue
        !             5:        (url VARCHAR(255) NOT NULL,
        !             6:        create_ts TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
        !             7:        PRIMARY KEY(url))
        !             8:        ENGINE=InnoDB DEFAULT CHARSET=utf8;
        !             9: 
        !            10: DROP TABLE IF EXISTS blacklist;
        !            11: CREATE TABLE blacklist
        !            12:        (url_domain VARCHAR(255) NOT NULL,
        !            13:        PRIMARY KEY(url_domain))
        !            14:        ENGINE=InnoDB DEFAULT CHARSET=utf8;
        !            15: