Login   Register  
PHP Classes
elePHPant
Icontem

File: user.sql

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Olavo Alexandrino  >  ADODB XML  >  user.sql  >  Download  
File: user.sql
Role: Auxiliary data
Content type: text/plain
Description: Script SQL
Class: ADODB XML
Import and export data in databases to XML files
Author: By
Last change:
Date: 2004-07-23 07:10
Size: 935 bytes
 

Contents

Class file image Download
# phpMyAdmin SQL Dump
# version 2.5.7
# http://www.phpmyadmin.net
#
# Servidor: localhost
# Tempo de Generação: Jul 22, 2004 at 04:17 
# Versão do Servidor: 3.23.58
# Versão do PHP: 4.3.2
# 
# Banco de Dados : `test`
# 

# --------------------------------------------------------

#
# Estrutura da tabela `user`
#

CREATE TABLE `user` (
  `userId` int(10) unsigned NOT NULL auto_increment,
  `userName` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`userId`),
  UNIQUE KEY `userId` (`userId`),
  KEY `userId_2` (`userId`)
) TYPE=MyISAM AUTO_INCREMENT=7 ;

#
# Extraindo dados da tabela `user`
#

INSERT INTO `user` VALUES (1, 'Olavo Alexandrino');
INSERT INTO `user` VALUES (2, 'Romário');
INSERT INTO `user` VALUES (3, 'Maradona');
INSERT INTO `user` VALUES (4, 'Ronaldinho Gaúcho');
INSERT INTO `user` VALUES (5, 'Édson Arantes do Nascimento (Pelé)');
INSERT INTO `user` VALUES (6, 'Rivaldo');