PHP Classes

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: 3 years 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;