You cannot select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

10 lines
485 B
SQL

CREATE TABLE /*_*/isekai_user_daily_sign_log (
`user_id` INT UNSIGNED NOT NULL,
`year` INT UNSIGNED NOT NULL,
`month` INT UNSIGNED NOT NULL,
`sign_log` LONGTEXT NOT NULL
) /*$wgDBTableOptions*/;
ALTER TABLE /*_*/isekai_user_daily_sign_log ADD PRIMARY KEY (`user_id`, `year`, `month`);
ALTER TABLE /*_*/isekai_user_daily_sign_log ADD INDEX(`user_id`);
ALTER TABLE /*_*/isekai_user_daily_sign_log ADD INDEX(`year`);
ALTER TABLE /*_*/isekai_user_daily_sign_log ADD INDEX(`month`);