Login   Register  
PHP Classes
elePHPant
Icontem

File: chat.sql

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Igor Herson Aquino de Franša  >  HelpDesk Chat  >  chat.sql  >  Download  
File: chat.sql
Role: Auxiliary data
Content type: text/plain
Description: database file
Class: HelpDesk Chat
Manage chat dialog sessions
Author: By
Last change:
Date: 5 years ago
Size: 594 bytes
 

Contents

Class file image Download
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Banco de Dados: `chat`
--

-- --------------------------------------------------------

--
-- Estrutura da tabela `log`
--

CREATE TABLE IF NOT EXISTS `log` (
  `logid` int(11) NOT NULL auto_increment,
  `email` varchar(200) NOT NULL,
  `sessao` int(11) NOT NULL default '0',
  `ip` varchar(50) NOT NULL,
  `time` datetime NOT NULL,
  `msg` text NOT NULL,
  `status` tinyint(1) NOT NULL,
  `admin` tinyint(1) NOT NULL,
  PRIMARY KEY  (`logid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=127 ;

--
-- Extraindo dados da tabela `log`
--