schema-mysql.sql 476 B

123456789101112131415161718192021
  1. /**
  2. * Database schema required by \yii\web\DbSession.
  3. *
  4. * @author Qiang Xue <qiang.xue@gmail.com>
  5. * @author Misbahul D Munir <misbahuldmunir@gmail.com>
  6. * @link http://www.yiiframework.com/
  7. * @copyright 2008 Yii Software LLC
  8. * @license http://www.yiiframework.com/license/
  9. * @since 2.0.8
  10. */
  11. drop table if exists `session`;
  12. create table `session`
  13. (
  14. `id` varchar(256) not null,
  15. `expire` integer,
  16. `data` LONGBLOB,
  17. primary key (`id`)
  18. ) engine InnoDB;