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
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`); |