Login   Register  
PHP Classes
elePHPant
Icontem

File: table.sql

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Victor Mendonša  >  New MySQL  >  table.sql  >  Download  
File: table.sql
Role: Auxiliary data
Content type: text/plain
Description: MySQL Example table
Class: New MySQL
Retrieve, update and delete MySQL table records
Author: By
Last change:
Date: 3 years ago
Size: 1,394 bytes
 

Contents

Class file image Download
/*
Navicat MySQL Data Transfer

Source Server         : localhost
Source Server Version : 50051
Source Host           : localhost:3306
Source Database       : creative

Target Server Type    : MYSQL
Target Server Version : 50051
File Encoding         : 65001

Date: 2011-01-21 05:18:21
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `cliente`
-- ----------------------------
DROP TABLE IF EXISTS `cliente`;
CREATE TABLE `cliente` (
  `id` int(3) NOT NULL auto_increment,
  `login` varchar(16) NOT NULL,
  `senha` varchar(16) default NULL,
  `nome_completo` varchar(120) default NULL,
  `email` varchar(160) default NULL,
  `site` varchar(255) default NULL,
  `skype` varchar(24) default NULL,
  `sexo` char(2) default NULL,
  `data_nascimento` date default NULL,
  `data_cadastro` date default NULL,
  `data_ultlogin` varchar(10) default NULL,
  `status` char(2) default NULL,
  `tipo` char(2) default NULL,
  PRIMARY KEY  (`id`,`login`),
  KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of cliente
-- ----------------------------
INSERT INTO `cliente` VALUES ('9', 'mend3', '811745304116', 'Victor Mendonca', 'victor.mend3@hotmail.com', 'http://www.victormendonca.com.br', 'v.mend3', 'M', '1990-10-05', '2011-01-14', '1294974104', '1', '5');