persistent_login icon indicating copy to clipboard operation
persistent_login copied to clipboard

sqlite support

Open 532910 opened this issue 5 years ago • 1 comments

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

532910 avatar Sep 20 '19 20:09 532910

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

twekkel avatar Nov 12 '21 15:11 twekkel