DROP DATABASE IF EXISTS `LARGE_VARCHAR_EXAMPLE`;

CREATE DATABASE IF NOT EXISTS `LARGE_VARCHAR_EXAMPLE` CHARACTER SET latin1 COLLATE latin1_bin;

use LARGE_VARCHAR_EXAMPLE;

DELIMITER $$

CREATE PROCEDURE LARGE_VARCHAR_EXAMPLE (
  OUT opBOARDID BIGINT,
  OUT opID BIGINT,
  OUT opUSERNAME VARCHAR(100),
  OUT opPWORD VARCHAR(100),
  OUT opEMAIL VARCHAR(60),
  OUT opUSER_ACTIVE VARCHAR(1),
  OUT opTITLE VARCHAR(50),
  OUT opREALNAME VARCHAR(40),
  OUT opDOB DATE,
  OUT opURL VARCHAR(100),
  OUT opAVATAR VARCHAR(100),
  OUT opLOCATION VARCHAR(30),
  OUT opSIGNATURE VARCHAR(2500),
  OUT opSHOW_SIG VARCHAR(1),
  OUT opLANG VARCHAR(25),
  OUT opSTYLE VARCHAR(25),
  OUT opNUM_POSTS INT,
  OUT opNUM_TOPICS INT,
  OUT opLAST_POST TIMESTAMP,
  OUT opDATE_REGISTERED TIMESTAMP,
  OUT opREGISTRATION_IP VARCHAR(15),
  OUT opLAST_VISIT TIMESTAMP,
  OUT opADMIN_NOTES VARCHAR(300),
  OUT opRANK VARCHAR(100),
  OUT opHIDE_ONLINE_STATUS VARCHAR(1)
)
COMMENT 'Test Procedure' 
BEGIN

SELECT opBOARDID, opID, opUSERNAME, opPWORD, opEMAIL, opUSER_ACTIVE,
    opTITLE, opREALNAME, opDOB, opURL, opAVATAR, opLOCATION, opSIGNATURE, opSHOW_SIG,
    opLANG, opSTYLE, opNUM_POSTS, opNUM_TOPICS, opLAST_POST, opDATE_REGISTERED,
    opREGISTRATION_IP, opLAST_VISIT, opADMIN_NOTES, opRANK, opHIDE_ONLINE_STATUS LIMIT 1;

END$$

DELIMITER ;

COMMIT;