PHP Classes

File: teo.sql

Recommend this page to a friend!
  Classes of Alfredo Rodriguez  >  Teo  >  teo.sql  >  Download  
File: teo.sql
Role: Auxiliary data
Content type: text/plain
Description: Auxiliary data
Class: Teo
MVC Framework with configurable routes and filters
Author: By
Last change:
Date: 2 months ago
Size: 897 bytes
 

Contents

Class file image Download
# Create Testuser
CREATE USER 'teo'@'localhost' IDENTIFIED BY 'teo';
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON *.* TO 'teo'@'localhost';
# Create DB
CREATE DATABASE IF NOT EXISTS `teo` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
USE `teo`;
# Create Table
CREATE TABLE IF NOT EXISTS `users` (
  `user_id` int(11) NOT NULL,
  `created_on` timestamp NULL DEFAULT NULL,
  `modified_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `username` varchar(50) DEFAULT NULL,
  `salt` varchar(20) DEFAULT NULL,
  `password` varchar(50) DEFAULT NULL,
  `email` varchar(150) DEFAULT NULL,
  `firstname` varchar(50) DEFAULT NULL,
  `lastname` varchar(50) DEFAULT NULL,
  `dob` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
ALTER TABLE `users`
  ADD PRIMARY KEY (`user_id`);
ALTER TABLE `users`
  MODIFY `user_id` int(11) NOT NULL AUTO_INCREMENT;
# Add Data
For more information send a message to info at phpclasses dot org.