Script para criação da tabela de controle

Discussion in 'Remote Session' started by Visual Net, Feb 14, 2017.

  1. Visual Net

    Visual Net Delivering more than expected Staff Member

    Script para criação da tabela de controle do Remote Session


    CREATE TABLE tbVNR_OnLine
    (
    `ID` int(11) NOT NULL AUTO_INCREMENT,
    `Data` varchar(8) COLLATE latin1_general_ci NOT NULL,
    `Hora` varchar(8) COLLATE latin1_general_ci NOT NULL,
    `Computador` varchar(60) COLLATE latin1_general_ci NOT NULL,
    `Status` varchar(1) COLLATE latin1_general_ci NOT NULL,
    `Usuario` varchar(60) COLLATE latin1_general_ci NOT NULL,
    `IP` varchar(30) COLLATE latin1_general_ci NOT NULL,
    `Porta` int(11) NOT NULL,
    `DataPing` varchar(8) COLLATE latin1_general_ci DEFAULT NULL,
    `HoraPing` varchar(8) COLLATE latin1_general_ci DEFAULT NULL,
    UNIQUE KEY `ID` (`ID`)
    ) ENGINE=MyISAM AUTO_INCREMENT=67 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
     

Share This Page