tabulka pro social tokeny

[pohadkar]

-- Struktura tabulky t_social_tokens

CREATE TABLE t_social_tokens (
c_uid int NOT NULL,
c_user_id int NOT NULL,
c_service varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL,
c_type varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL,
c_data varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
c_token varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL,
c_valid_until int NOT NULL DEFAULT '0',
c_long_token varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Klíče pro exportované tabulky

--
-- Klíče pro tabulku t_social_tokens

ALTER TABLE t_social_tokens
ADD PRIMARY KEY (c_uid),
ADD KEY c_uid (c_user_id) USING BTREE;

--
-- AUTO_INCREMENT pro tabulky

--
-- AUTO_INCREMENT pro tabulku t_social_tokens

ALTER TABLE t_social_tokens
MODIFY c_uid int NOT NULL AUTO_INCREMENT;
COMMIT;