schema-pgsql.sql 457 B

123456789101112131415161718192021
  1. /**
  2. * Database schema required by \yii\caching\DbCache.
  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.7
  10. */
  11. drop table if exists "cache";
  12. create table "cache"
  13. (
  14. "id" varchar(128) not null,
  15. "expire" integer,
  16. "data" bytea,
  17. primary key ("id")
  18. );