aboutsummaryrefslogtreecommitdiffstats
path: root/mayor-orig/mayor-base/update/rev001986-1-mayor_login.sql
blob: 75268f720bca243c68724a39a17c3d9e1d2c0c1d (plain)
1
2
3
4
DROP TABLE IF EXISTS `cache`;
CREATE TABLE `cache` (`sessionID` char(40), `policy` varchar(10), `kulcs` varchar(32) NOT NULL, `ertek` varchar(100), dt DATETIME)
ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_hungarian_ci;
ALTER TABLE `cache` add primary key PK (sessionID,policy,kulcs);