PHP Classes

File: SQL File

Recommend this page to a friend!
  Classes of Oleg Lunegov   MicroPHP Framework   micro.sql   Download  
File: micro.sql
Role: Auxiliary data
Content type: text/plain
Description: Auxiliary data
Class: MicroPHP Framework
MVC framework for Web or command line applications
Author: By
Last change: Update of micro.sql
Date: 1 month ago
Size: 713 bytes
 

Contents

Class file image Download 
--
-- Table structure for table `blogs`
--

CREATE TABLE IF NOT EXISTS `blogs` (
  `id`      INT(11)      NOT NULL AUTO_INCREMENT,
  `name`    VARCHAR(127) NOT NULL DEFAULT '',
  `content` TEXT         NOT NULL,
  PRIMARY KEY (`id`)
)
  ENGINE = InnoDB
  DEFAULT CHARSET = utf8;

-- --------------------------------------------------------

--
-- Table structure for table `users`
--

CREATE TABLE IF NOT EXISTS `users` (
  `id`    INT(11)      NOT NULL AUTO_INCREMENT,
  `email` VARCHAR(55)  NOT NULL DEFAULT '',
  `login` VARCHAR(55)  NOT NULL DEFAULT '',
  `pass`  VARCHAR(32)  NOT NULL DEFAULT '',
  `fio`   VARCHAR(127) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
)
  ENGINE = InnoDB
  DEFAULT CHARSET = utf8;