PHP Classes

File: SQL File

Recommend this page to a friend!
  Classes of Ramesh Narayan Jangid (Sharma)   PHP Microservices Framework   cache.sql   Download  
File: cache.sql
Role: Auxiliary data
Content type: text/plain
Description: Auxiliary data
Class: PHP Microservices Framework
Setup microservices apps with configuration arrays
Author: By
Last change: Update of cache.sql
Date: 12 days ago
Size: 1,226 bytes
 

Contents

Class file image Download 
DROP TABLE IF EXISTS `client`;

CREATE TABLE `client` (
  `key` VARCHAR(255) NOT NULL,
  `value` TEXT DEFAULT NULL,
  `ts` int DEFAULT 0,
  KEY (`key`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `user`;

CREATE TABLE `user` (
  `key` VARCHAR(255) NOT NULL,
  `value` TEXT DEFAULT NULL,
  `ts` int DEFAULT 0,
  KEY (`key`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `group`;

CREATE TABLE `group` (
  `key` INT NOT NULL,
  `value` TEXT DEFAULT NULL,
  `ts` int DEFAULT 0,
  KEY (`key`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `cidr`;

CREATE TABLE `cidr` (
  `key` INT NOT NULL,
  `value` TEXT DEFAULT NULL,
  `ts` int DEFAULT 0,
  KEY (`key`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `usertoken`;

CREATE TABLE `usertoken` (
  `key` INT NOT NULL,
  `value` TEXT DEFAULT NULL,
  `ts` int DEFAULT 0,
  KEY (`key`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `token`;

CREATE TABLE `token` (
  `key` varchar(255) NOT NULL,
  `value` TEXT DEFAULT NULL,
  `ts` int DEFAULT 0,
  KEY (`key`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;