PHP Classes

File: ChatText.sql

Recommend this page to a friend!
  Classes of António Lira Fernandes   Chat Text   ChatText.sql   Download  
File: ChatText.sql
Role: Auxiliary data
Content type: text/plain
Description: Auxiliary data
Class: Chat Text
Exchange text messages between Web site users
Author: By
Last change:
Date: 1 year ago
Size: 1,422 bytes
 

Contents

Class file image Download
-- phpMyAdmin SQL Dump -- version 4.9.7 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Tempo de geração: 11-Abr-2022 às 11:38 -- Versão do servidor: 10.3.34-MariaDB-cll-lve -- versão do PHP: 7.4.28 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET AUTOCOMMIT = 0; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -------------------------------------------------------- -- -- Estrutura da tabela `chatText` -- CREATE TABLE `chatText` ( `id` int(11) NOT NULL, `idSender` int(11) NOT NULL, `idDestination` int(11) NOT NULL, `msg` varchar(250) NOT NULL, `dateTime` timestamp NOT NULL DEFAULT current_timestamp(), `noRead` int(11) NOT NULL DEFAULT 1 ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Índices para tabela `chatText` -- ALTER TABLE `chatText` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT de tabelas despejadas -- -- -- AUTO_INCREMENT de tabela `chatText` -- ALTER TABLE `chatText` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;