databases/Metier/schema/backoffice.session.sql
2016-07-01 13:58:43 +02:00

8 lines
469 B
SQL

CREATE TABLE `session` (
`id` char(32) CHARACTER SET utf8 NOT NULL DEFAULT '',
`modified` int(11) DEFAULT NULL COMMENT 'Timestamp de modification',
`lifetime` int(11) DEFAULT NULL COMMENT 'Durée de vie de la session',
`data` text CHARACTER SET utf8 COMMENT 'data pour la session',
PRIMARY KEY (`id`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci PAGE_CHECKSUM=0 TRANSACTIONAL=0 COMMENT='Clés de session pour authentification backoffice';