Share Pastebin
Guest
Public paste!

Djalma Arajo

By: a guest | Aug 30th, 2009 | Syntax: SQL | Size: 0.48 KB | Hits: 143 | Expires: Never
Copy text to clipboard
  1. --
  2. -- Estrutura da tabela `user`
  3. --
  4.  
  5. CREATE TABLE IF NOT EXISTS `user` (
  6.   `id` int(11) NOT NULL AUTO_INCREMENT,
  7.   `name` varchar(100) NOT NULL,
  8.   `email` varchar(100) NOT NULL,
  9.   `password` varchar(60) NOT NULL,
  10.   `status` int(11) NOT NULL DEFAULT '1',
  11.   `privileges` int(11) NOT NULL,
  12.   `created_at` datetime NOT NULL,
  13.   `updated_at` datetime NOT NULL,
  14.   PRIMARY KEY (`id`)
  15. ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
  16.  
  17. --
  18. -- Extraindo dados da tabela `user`
  19. --