X-Git-Url: https://projects.mako.cc/source/selectricity-live/blobdiff_plain/776bdf980f85cf230b238a80e1019fc78d53f06e..d2fadf2d1f345fab0956a05599b50a483d939c9a:/db/create.sql diff --git a/db/create.sql b/db/create.sql index 7d5f405..c28dd36 100644 --- a/db/create.sql +++ b/db/create.sql @@ -101,6 +101,19 @@ create table rankings ( primary key (id) ); +# CREATE sessions TABLE +###################################### + +drop table if exists sessions; +create table sessions ( + id int(11) NOT NULL auto_increment, + sessid varchar(255), + data text, + updated_at datetime DEFAULT NULL, + primary key (id), + index session_index (sessid) +); + # CREATE users TABLE ##################################### #DROP TABLE IF EXISTS `users`;