jyseo/db.sql

-- jyseo.seo_industry definition

CREATE TABLE jyseo.seo_industry
(

    `id` Int32,

    `keyword` String,

    `class1` String,

    `class2` String,

    `letter` String,

    `state` Int32
)
    ENGINE = MergeTree
    ORDER BY keyword
SETTINGS index_granularity = 8192;

-- jyseo.seo_industry_class definition

CREATE TABLE jyseo.seo_industry_class
(

    `id` Int32,

    `name` String
)
    ENGINE = MergeTree
    ORDER BY name
SETTINGS index_granularity = 8192;

-- jyseo.seo_resource definition

CREATE TABLE jyseo.seo_resource
(

    `id` Int32,

    `keyword` String,

    `letter` String,

    `state` Int32
)
    ENGINE = MergeTree
    ORDER BY keyword
SETTINGS index_granularity = 8192;

-- jyseo.seo_siteKeywords_splicing definition

CREATE TABLE jyseo.seo_siteKeywords_splicing
(

    `site_code` Int32,

    `area` String,

    `city` String,

    `city_special` String,

    `alias` String
)
    ENGINE = MergeTree
    ORDER BY site_code
SETTINGS index_granularity = 8192;

-- ===========================================
-- jyseo.new_areaClass definition
CREATE TABLE jyseo.new_areaClass
(

    `bid_id` String,

    `area` String,

    `city` String,

    `district` String,

    `toptype` String,

    `subtype` String,

    `publish_time` Int64
)
    ENGINE = MergeTree
    PARTITION BY area
    PRIMARY KEY (toptype,
                 subtype,
                 area,
                 city,
                 district)
    ORDER BY (toptype,
              subtype,
              area,
              city,
              district,
              publish_time,
              bid_id)
    SETTINGS index_granularity = 8192;

-- jyseo.new_bidList definition

CREATE TABLE jyseo.new_bidList
(

    `bid_id` String,

    `title` String,

    `area` String,

    `city` String,

    `district` String,

    `toptype` String,

    `subtype` String,

    `industry` String,

    `bidamount` Float64,

    `budget` Float64,

    `site` String,

    `isValidFile` Bool,

    `publish_time` Int64
)
    ENGINE = MergeTree
    PARTITION BY toptype
    PRIMARY KEY (toptype,
                 bid_id)
    ORDER BY (toptype,
              bid_id,
              publish_time)
    SETTINGS index_granularity = 8192;

-- jyseo.new_classKeywords definition

CREATE TABLE jyseo.new_classKeywords
(

    `bid_id` String,

    `keyword` String,

    `area` String,

    `city` String,

    `district` String,

    `toptype` String,

    `class1` String,

    `class2` String,

    `desc` String,

    `publish_time` Int64
)
    ENGINE = MergeTree
    ORDER BY (keyword,
 publish_time)
SETTINGS index_granularity = 8192;

-- jyseo.new_fullKeywords definition

CREATE TABLE jyseo.new_fullKeywords
(

    `bid_id` String,

    `keyword` String,

    `desc` String,

    `publish_time` Int64
)
    ENGINE = MergeTree
    ORDER BY (keyword,
 publish_time)
SETTINGS index_granularity = 8192;

-- jyseo.new_pinyinKeywords definition

CREATE TABLE jyseo.new_pinyinKeywords
(

    `bid_id` String,

    `keyword` String,

    `industry` String,

    `publish_time` Int64
)
    ENGINE = MergeTree
    ORDER BY (keyword,
 industry,
 publish_time)
SETTINGS index_granularity = 8192;

-- jyseo.new_siteKeywords definition

CREATE TABLE jyseo.new_siteKeywords
(

    `bid_id` String,

    `keyword` String,

    `area` String,

    `city` String,

    `district` String,

    `desc` String,

    `publish_time` Int64
)
    ENGINE = MergeTree
    ORDER BY (keyword,
 publish_time)
SETTINGS index_granularity = 8192;