Return to base.sql CVS log

Up to [Coherent Logic Development] / pandia

Annotation of pandia/base.sql, revision 1.2

1.1       snw         1: USE pandia;
                      2: 
1.2     ! snw         3: DROP TABLE IF EXISTS url_domains;
        !             4: CREATE TABLE url_domains
        !             5:        (url_domain VARCHAR(255) NOT NULL,
        !             6:        PRIMARY KEY(url_domain))
        !             7:        ENGINE=InnoDB DEFAULT CHARSET=utf8;       
        !             8: 
1.1       snw         9: DROP TABLE IF EXISTS crawl_queue;
                     10: CREATE TABLE crawl_queue
                     11:        (url VARCHAR(255) NOT NULL,
1.2     ! snw        12:        parent_url VARCHAR(255),
        !            13:        url_domain VARCHAR(255) NOT NULL,
        !            14:        scheme VARCHAR(40) NOT NULL DEFAULT "http",
        !            15:        analyzed TINYINT NOT NULL DEFAULT 0,
1.1       snw        16:        create_ts TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
                     17:        PRIMARY KEY(url))
                     18:        ENGINE=InnoDB DEFAULT CHARSET=utf8;
                     19: 
                     20: DROP TABLE IF EXISTS blacklist;
                     21: CREATE TABLE blacklist
                     22:        (url_domain VARCHAR(255) NOT NULL,
                     23:        PRIMARY KEY(url_domain))
                     24:        ENGINE=InnoDB DEFAULT CHARSET=utf8;
                     25: 
1.2     ! snw        26: DROP TABLE IF EXISTS keywords;
        !            27: CREATE TABLE keywords
        !            28:        (id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
        !            29:        word VARCHAR(255) NOT NULL,
        !            30:        url VARCHAR(255) NOT NULL,
        !            31:        url_domain VARCHAR(255) NOT NULL,
        !            32:        word_count SMALLINT UNSIGNED NOT NULL,
        !            33:        PRIMARY KEY(id))
        !            34:        ENGINE=InnoDB DEFAULT CHARSET=utf8;
        !            35: 
        !            36: DROP TABLE IF EXISTS url_fulltext;
        !            37: CREATE TABLE url_fulltext
        !            38:        (url VARCHAR(255) NOT NULL,
        !            39:        body MEDIUMTEXT NOT NULL,
        !            40:        PRIMARY KEY(url))
        !            41:        ENGINE=InnoDB DEFAULT CHARSET=utf8;
        !            42:        
        !            43: CREATE INDEX idx_keyword_search_word ON keywords(word);
        !            44: CREATE INDEX idx_keyword_search_url ON keywords(url);
        !            45: CREATE INDEX idx_keyword_search_domain ON keywords(url_domain);