CREATE DATABASE ns_spider DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
CREATE DATABASE ns_task DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
CREATE DATABASE ns_data DEFAULT CHARSET utf8 COLLATE utf8_general_ci;

CREATE TABLE ns_spider.spiders
(
  name       VARCHAR(64)   NOT NULL
    PRIMARY KEY,
  groups     VARCHAR(64)   NULL,
  status     VARCHAR(16)   NULL,
  crontime   VARCHAR(100)  NULL,
  comments   VARCHAR(1024) NULL,
  rate       INT           NULL,
  updatetime DOUBLE(16, 4) NULL
);