CREATE TABLE access_total (
    filenum TEXT,    -- 歌詞番号
    acc_y INTEGER,   --
    acc_m INTEGER,   --
    acc_d INTEGER,   --
    acc_h INTEGER,   --
    acc_time BIGINT,   --
    user_ip TEXT   --
);
grant all on access_total to public;


-- その週の水曜日 <8
CREATE TABLE week_1_access (
    filenum text NOT NULL,
    accesscounter integer
);
grant all on week_1_access to public;

-- その週の水曜日 8<= w <15
CREATE TABLE week_2_access (
    filenum text NOT NULL,
    accesscounter integer
);
grant all on week_2_access to public;

-- その週の水曜日 15<= w <22
CREATE TABLE week_3_access (
    filenum text NOT NULL,
    accesscounter integer
);
grant all on week_3_access to public;

-- その週の水曜日 22<= w <29
CREATE TABLE week_4_access (
    filenum text NOT NULL,
    accesscounter integer
);
grant all on week_4_access to public;

-- その週の水曜日 29<= w
CREATE TABLE week_5_access (
    filenum text NOT NULL,
    accesscounter integer
);
grant all on week_5_access to public;