schema-mssql.sql 521 B

1234567891011121314151617181920212223
  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. if object_id('[cache]', 'U') is not null
  12. drop table [cache];
  13. drop table if exists [cache];
  14. create table [cache]
  15. (
  16. [id] varchar(128) not null,
  17. [expire] integer,
  18. [data] BLOB,
  19. primary key ([id])
  20. );