Guest

Djalma Arajo

By: a guest on Aug 30th, 2009  |  syntax: SQL  |  size: 0.48 KB  |  hits: 145  |  expires: Never
download  |  raw  |  embed  |  report abuse
Copied
  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. --