File: exempleUserSQL

Recommend this page to a friend!
  Classes of António Lira Fernandes  >  PHP Database Table Viewer  >  exempleUserSQL  >  Download  
File: exempleUserSQL
Role: Auxiliary data
Content type: text/plain
Description: Auxiliary data
Class: PHP Database Table Viewer
Generate HTML table to show database query results
Author: By
Last change:
Date: 13 days ago
Size: 787 bytes
 

Contents

Class file image Download
CREATE TABLE `users` (
  `id` int(11) NOT NULL,
  `nome` varchar(60) NOT NULL DEFAULT '',
  `login` varchar(40) NOT NULL DEFAULT '',
  `pass` varchar(64) NOT NULL DEFAULT '',
  `email` varchar(200) DEFAULT NULL,
  `postar` enum('S','N') NOT NULL DEFAULT 'S',
  `ultimo_acesso` datetime DEFAULT NULL,
  `num_acessos` int(11) NOT NULL DEFAULT '0',
  `tipo` int(11) NOT NULL,
  `ativo` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `users` (`id`, `nome`, `login`, `pass`, `email`, `postar`, `ultimo_acesso`, `num_acessos`, `tipo`, `ativo`) VALUES
(2, 'Admin', 'admin', 'c99b5e8c22376084429e03dd3c588bc0', NULL, 'S', NULL, 0, 3, 1)

ALTER TABLE `users`
  ADD PRIMARY KEY (`id`);


ALTER TABLE `users`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=50;

For more information send a message to info at phpclasses dot org.