search

mfreiholz / persistent_login

Provides a "Keep me logged in" aka "Remember Me" functionality for Roundcube.
79 stars 50 forks source link

sqlite support #48

Open 532910 opened 5 years ago

532910 commented 5 years ago

Please add sql/sqlite.sql.

This one works for me, but I'm not sure if it's completely correct:

CREATE TABLE `auth_tokens` (
    `token` varchar(128) NOT NULL,
    `expires` datetime NOT NULL,
    `user_id` int(10)  NOT NULL,
    `user_name` varchar(128) NOT NULL,
    `user_pass` varchar(128) NOT NULL,
    `host` varchar(255) NOT NULL
);
CREATE INDEX token ON auth_tokens(token);
twekkel commented 2 years ago

Mostly okay and it will work. For some improvements please have a look at at https://github.com/mfreiholz/persistent_login/pull/60