Ok i had a typo in the query. The only way for it to allow me to make the database that way is with
CREATE DATABASE steer3db CHARACTER SET utf8 COLLATE utf8_unicode_ci;
CREATE DATABASE box2db CHARACTER SET utf8 COLLATE utf8_unicode_ci;
BUT it still dont let me import the sql
[SQL] Query BOX_sp_2.16.1.db50 start
[ERR] 1418 - This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)
[ERR] -- Script was generated by Devart dbForge Studio for MySQL, Version 4.50.342.0
-- Script date 2011-11-11 오후 1:43:57
-- Server version: 5.1.41-3ubuntu12.10
-- Client version: 4.1
--
-- Disable foreign keys
--
/*!40014 SET
old_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
--
-- Set character set the client will use to send SQL statements to the server
--
SET NAMES 'utf8';
--
-- Definition for procedure P_CreateBox
--
DROP PROCEDURE IF EXISTS P_CreateBox;
CREATE PROCEDURE P_CreateBox(
IN in_receiverServiceSN INT,
IN in_receiverUserSN BIGINT,
IN in_receiverGUSID INT,
IN in_receiverCharacterSN INT,
IN in_receiverCharacterName VARCHAR(50),
IN in_senderUserSN BIGINT,
IN in_senderGUSID INT,
IN in_senderCharacterSN INT,
IN in_senderCharacterName VARCHAR(50),
IN in_createEndPointCode INT,
IN in_createDateTime DATETIME,
IN in_externalTransactionKey INT,
IN in_startActivationDateTime DATETIME,
IN in_endActivationDateTime DATETIME,
IN in_activateDurationAfterOpen INT,
IN in_visableFlagBeforeActivation INT,
IN in_boxEventSN INT,
IN in_boxTagInfo TEXT,
IN in_boxServiceItemInfo TEXT,
IN in_boxTransactionSN BIGINT UNSIGNED,
IN in_globalUniqueFunctionID INT UNSIGNED,
OUT out_returnCode INT,
OUT out_boxSN BIGINT
)
MAIN:
BEGIN
-- 변수 정의
DECLARE boxEventSN_ INT DEFAULT NULL;
DECLARE boxSN_ BIGINT DEFAULT 0;
DECLARE boxItemSN_ BIGINT DEFAULT 0;
DECLARE boxTransactionStateCode_ TINYINT UNSIGNED;
DECLARE isUpdateBoxTransactionResult_ TINYINT UNSIGNED DEFAULT 0;
DECLARE boxTagSN_ INT;
DECLARE boxTagSNString_ TEXT;
DECLARE boxTagValue_ TEXT;
DECLARE serviceItemSN_ INT;
DECLARE serviceItemSNString_ TEXT;
DECLARE externalItemKeyString_ TEXT;
DECLARE serviceItemTagSN_ INT;
DECLARE serviceItemTagSNString_ TEXT;
DECLARE serviceItemTagValue_ TEXT;
-- loop에 쓸 변수 선언
DECLARE splitIndex_ INT DEFAULT 1;
DECLARE loopCount_ INT DEFAULT 0;
DECLARE boxTagCount_ INT DEFAULT 0;
DECLARE innerLoopCount_ INT DEFAULT 0;
DECLARE boxServiceItemCount_ INT DEFAULT 0;
DECLARE boxServiceItemTagCount_ INT DEFAULT 0;
SET out_returnCode = 0x17000000;
-- Receiver에 대한 유효성 검사
IF in_receiverServiceSN IS NULL OR in_receiverUserSN IS NULL THEN
SET out_returnCode = out_returnCode + 1700;
LEAVE MAIN;
END IF;
START TRANSACTION;
-- boxTransactionSN 입력이 있는 경우 검사
IF in_boxTransactionSN IS NOT NULL AND in_globalUniqueFunctionID IS NOT NULL THEN
-- 입력된 boxTransactionSN을 이용하여 boxTransactionStateCode를 조회한다.
SELECT boxTransactionStateCode INTO boxTransactionStateCode_
FROM box_transaction
WHERE boxTransactionSN = in_boxTransactionSN LIMIT 1;
-- boxTransactionStateCode_가 NULL인 경우는 존재하지 않는 boxTransactionSN인 경우이므로 에러처리 한다.
IF boxTransactionStateCode_ IS NULL THEN
SET out_returnCode = out_returnCode + 1704;
ROLLBACK;
LEAVE MAIN;
END IF;
-- 1 : 박스 생성을 정상적으로 진행한다.
-- 2 : 이미 사용 된 boxTransactionSN 이므로 에러를 반환 한다.
-- 3 : release된 boxTransactionSN 이므로 에러를 반환 한다.
CASE boxTransactionStateCode_
WHEN 1 THEN
UPDATE box_transaction
SET boxTransactionStateCode = 2,
boxTransactionGlobalUniqueFunctionID = in_globalUniqueFunctionID
WHERE boxTransactionSN = in_boxTransactionSN LIMIT 1;
SET isUpdateBoxTransactionResult_ = 1;
WHEN 2 THEN
SET out_returnCode = out_returnCode + 1705;
ROLLBACK;
LEAVE MAIN;
WHEN 3 THEN
SET out_returnCode = out_returnCode + 1706;
ROLLBACK;
LEAVE MAIN;
END CASE;
END IF;
-- 박스 정보 기록
INSERT box (recei
[SQL] Finished with error
