create_sessions.sql 257 B

1234567
  1. CREATE TABLE `sessions` (
  2. `session_pkey` INT NOT NULL AUTO_INCREMENT,
  3. `session_id` VARCHAR(32) NOT NULL,
  4. `user_id` INT NULL DEFAULT 0,
  5. `session_expiry` INT NULL,
  6. PRIMARY KEY (`session_pkey`),
  7. UNIQUE INDEX `session_id_UNIQUE` (`session_id` ASC));