Return to base.sql CVS log

Up to [Coherent Logic Development] / pandia

Annotation of pandia/base.sql, revision 1.4

1.2       snw         1: DROP TABLE IF EXISTS url_domains;
                      2: CREATE TABLE url_domains
                      3:        (url_domain VARCHAR(255) NOT NULL,
                      4:        PRIMARY KEY(url_domain))
                      5:        ENGINE=InnoDB DEFAULT CHARSET=utf8;       
                      6: 
1.1       snw         7: DROP TABLE IF EXISTS crawl_queue;
                      8: CREATE TABLE crawl_queue
                      9:        (url VARCHAR(255) NOT NULL,
1.2       snw        10:        parent_url VARCHAR(255),
                     11:        url_domain VARCHAR(255) NOT NULL,
                     12:        scheme VARCHAR(40) NOT NULL DEFAULT "http",
                     13:        analyzed TINYINT NOT NULL DEFAULT 0,
1.1       snw        14:        create_ts TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
                     15:        PRIMARY KEY(url))
                     16:        ENGINE=InnoDB DEFAULT CHARSET=utf8;
                     17: 
                     18: DROP TABLE IF EXISTS blacklist;
                     19: CREATE TABLE blacklist
                     20:        (url_domain VARCHAR(255) NOT NULL,
                     21:        PRIMARY KEY(url_domain))
                     22:        ENGINE=InnoDB DEFAULT CHARSET=utf8;
                     23: 
1.2       snw        24: 
                     25: DROP TABLE IF EXISTS url_fulltext;
                     26: CREATE TABLE url_fulltext
                     27:        (url VARCHAR(255) NOT NULL,
1.4     ! snw        28:        url_domain VARCHAR(255) NOT NULL,
1.2       snw        29:        body MEDIUMTEXT NOT NULL,
1.4     ! snw        30:        body_html MEDIUMTEXT NOT NULL,
1.3       snw        31:        page_title TEXT,
1.2       snw        32:        PRIMARY KEY(url))
                     33:        ENGINE=InnoDB DEFAULT CHARSET=utf8;