v0.53-v0.54.sql

来自「JA++的最新...很多ROSF都用这个 ] 是个不错的东西-3-」· SQL 代码 · 共 599 行 · 第 1/2 页

# Jathena++ v0.53-v0.54 upgrade sql-script

#
# Definition for the `MFJA_AddGuildStorage` procedure : 
#

CREATE PROCEDURE `MFJA_AddGuildStorage`(IN id INTEGER(11), IN nameid INTEGER(11), IN amount INTEGER(11), IN equip MEDIUMINT(8), IN identify SMALLINT(6), IN refine TINYINT(3), IN attribute TINYINT(4), IN card0 INTEGER(11), IN card1 INTEGER(11), IN card2 INTEGER(11), IN card3 INTEGER(11), IN broken VARCHAR(20), IN lockid INTEGER(11), IN exp_ INTEGER(11), IN endurance INTEGER(11), IN max_endurance INTEGER(11))
    NOT DETERMINISTIC
    SQL SECURITY DEFINER
    COMMENT ''
BEGIN
INSERT DELAYED INTO `guild_storage`(`guild_storage`.`guild_id`, `guild_storage`.`nameid`, `guild_storage`.`amount`,
				    `guild_storage`.`equip`, `guild_storage`.`identify`, `guild_storage`.`refine`,
				    `guild_storage`.`attribute`, `guild_storage`.`card0`, `guild_storage`.`card1`,
				    `guild_storage`.`card2`, `guild_storage`.`card3`, `guild_storage`.`broken`,
				    `guild_storage`.`lockid`, `guild_storage`.`exp`, `guild_storage`.`endurance`,
				    `guild_storage`.`max_endurance`)
VALUES (id, nameid, amount, equip, identify, refine, attribute, card0, card1, card2, card3, broken, lockid, exp_, endurance,
	max_endurance);
END;

#
# Definition for the `MFJA_AddStorage` procedure : 
#

CREATE PROCEDURE `MFJA_AddStorage`(IN id INTEGER(11), IN nameid INTEGER(11), IN amount INTEGER(11), IN equip MEDIUMINT(8), IN identify SMALLINT(6), IN refine TINYINT(3), IN attribute TINYINT(4), IN card0 INTEGER(11), IN card1 INTEGER(11), IN card2 INTEGER(11), IN card3 INTEGER(11), IN broken VARCHAR(20), IN lockid INTEGER(11), IN exp_ INTEGER(11), IN endurance INTEGER(11), IN max_endurance INTEGER(11))
    NOT DETERMINISTIC
    SQL SECURITY DEFINER
    COMMENT ''
BEGIN
INSERT DELAYED INTO `storage`(`storage`.`account_id`, `storage`.`nameid`, `storage`.`amount`, `storage`.`equip`,
			      `storage`.`identify`, `storage`.`refine`, `storage`.`attribute`, `storage`.`card0`,
			      `storage`.`card1`, `storage`.`card2`, `storage`.`card3`, `storage`.`broken`,
			      `storage`.`lockid`, `storage`.`exp`, `storage`.`endurance`, `storage`.`max_endurance`)
VALUES (id, nameid, amount, equip, identify, refine, attribute, card0, card1, card2, card3, broken, lockid, exp_,
	endurance, max_endurance);
END;

#
# Definition for the `MFJA_DeleteGuildStorage` procedure : 
#

CREATE PROCEDURE `MFJA_DeleteGuildStorage`(IN id INTEGER(11), IN nameid INTEGER(11), IN card0 INTEGER(11), IN card1 INTEGER(11), IN card2 INTEGER(11), IN card3 INTEGER(11), IN refine TINYINT(3), IN broken VARCHAR(20))
    NOT DETERMINISTIC
    SQL SECURITY DEFINER
    COMMENT ''
BEGIN
DELETE FROM `guild_storage` WHERE
`guild_storage`.`guild_id`=id and `guild_storage`.`nameid`=nameid and `guild_storage`.`card0`=card0 and
`guild_storage`.`card1`=card1 and `guild_storage`.`card2`=card2 and `guild_storage`.`card3`=card3 and
`guild_storage`.`refine`=refine and `guild_storage`.`broken`=broken;
END;

#
# Definition for the `MFJA_DeleteStorage` procedure : 
#

CREATE PROCEDURE `MFJA_DeleteStorage`(IN id INTEGER(11), IN nameid INTEGER(11), IN card0 INTEGER(11), IN card1 INTEGER(11), IN card2 INTEGER(11), IN card3 INTEGER(11), IN refine TINYINT(3), IN broken VARCHAR(20))
    NOT DETERMINISTIC
    SQL SECURITY DEFINER
    COMMENT ''
BEGIN
DELETE FROM `storage` WHERE
`storage`.`account_id`=id and `storage`.`nameid`=nameid and `storage`.`card0`=card0 and `storage`.`card1`=card1 and
`storage`.`card2`=card2 and `storage`.`card3`=card3 and `storage`.`refine`=refine and `storage`.`broken`=broken;
END;

#
# Definition for the `MFJA_delete_cart_inventory01` procedure : 
#

CREATE PROCEDURE `MFJA_delete_cart_inventory01`(IN id INTEGER(11))
    NOT DETERMINISTIC
    SQL SECURITY DEFINER
    COMMENT ''
BEGIN
DELETE FROM `cart_inventory` WHERE cart_inventory.`char_id`=id;
END;

#
# Definition for the `MFJA_delete_char01` procedure : 
#

CREATE PROCEDURE `MFJA_delete_char01`(IN id INTEGER(11))
    NOT DETERMINISTIC
    SQL SECURITY DEFINER
    COMMENT ''
BEGIN
DELETE FROM `char` WHERE `char`.`char_id`=id;
END;

#
# Definition for the `MFJA_delete_friend01` procedure : 
#

CREATE PROCEDURE `MFJA_delete_friend01`(IN id INTEGER(11), IN val INTEGER(11))
    NOT DETERMINISTIC
    SQL SECURITY DEFINER
    COMMENT ''
BEGIN
DELETE FROM `friend` WHERE `friend`.`char_id`=id AND `friend`.`id2`=val;
END;

#
# Definition for the `MFJA_delete_friend02` procedure : 
#

CREATE PROCEDURE `MFJA_delete_friend02`(IN id INTEGER(11))
    NOT DETERMINISTIC
    SQL SECURITY DEFINER
    COMMENT ''
BEGIN
DELETE FROM `friend` WHERE `friend`.`char_id`=id;
END;

#
# Definition for the `MFJA_delete_global_reg_value01` procedure : 
#

CREATE PROCEDURE `MFJA_delete_global_reg_value01`(IN id INTEGER(11))
    NOT DETERMINISTIC
    SQL SECURITY DEFINER
    COMMENT ''
BEGIN
DELETE FROM `global_reg_value` WHERE `global_reg_value`.`type`=3 AND `global_reg_value`.`char_id`=id;
END;

#
# Definition for the `MFJA_delete_global_reg_value02` procedure : 
#

CREATE PROCEDURE `MFJA_delete_global_reg_value02`(IN id INTEGER(11))
    NOT DETERMINISTIC
    SQL SECURITY DEFINER
    COMMENT ''
BEGIN
DELETE FROM `global_reg_value` WHERE `global_reg_value`.`type`=2 AND `global_reg_value`.`account_id`=id;
END;

#
# Definition for the `MFJA_delete_global_reg_value03` procedure : 
#

CREATE PROCEDURE `MFJA_delete_global_reg_value03`(IN id INTEGER(11))
    NOT DETERMINISTIC
    SQL SECURITY DEFINER
    COMMENT ''
BEGIN
DELETE FROM `global_reg_value` WHERE `global_reg_value`.`type`='1' AND `global_reg_value`.`account_id`=id;
END;

#
# Definition for the `MFJA_delete_guild01` procedure : 
#

CREATE PROCEDURE `MFJA_delete_guild01`(IN id INTEGER(11))
    NOT DETERMINISTIC
    SQL SECURITY DEFINER
    COMMENT ''
BEGIN
DELETE FROM `guild` WHERE `guild`.`guild_id`=id;
END;

#
# Definition for the `MFJA_delete_guild_alliance01` procedure : 
#

CREATE PROCEDURE `MFJA_delete_guild_alliance01`(IN id INTEGER(11))
    NOT DETERMINISTIC
    SQL SECURITY DEFINER
    COMMENT ''
BEGIN
DELETE FROM `guild_alliance` WHERE `guild_alliance`.`guild_id`=id;
END;

#
# Definition for the `MFJA_delete_guild_alliance02` procedure : 
#

CREATE PROCEDURE `MFJA_delete_guild_alliance02`(IN id INTEGER(11))
    NOT DETERMINISTIC
    SQL SECURITY DEFINER
    COMMENT ''
BEGIN
DELETE FROM `guild_alliance` WHERE `guild_alliance`.`guild_id`=id OR `guild_alliance`.`alliance_id`=id;
END;

#
# Definition for the `MFJA_delete_guild_expulsion01` procedure : 
#

CREATE PROCEDURE `MFJA_delete_guild_expulsion01`(IN id INTEGER(11))
    NOT DETERMINISTIC
    SQL SECURITY DEFINER
    COMMENT ''
BEGIN
DELETE FROM `guild_expulsion` WHERE `guild_expulsion`.`guild_id`=id;
END;

#
# Definition for the `MFJA_delete_guild_member01` procedure : 
#

CREATE PROCEDURE `MFJA_delete_guild_member01`(IN id INTEGER(11))
    NOT DETERMINISTIC
    SQL SECURITY DEFINER
    COMMENT ''
BEGIN
DELETE FROM `guild_member` WHERE `guild_member`.`guild_id`=id;
END;

#
# Definition for the `MFJA_delete_guild_position01` procedure : 
#

CREATE PROCEDURE `MFJA_delete_guild_position01`(IN id INTEGER(11))
    NOT DETERMINISTIC
    SQL SECURITY DEFINER
    COMMENT ''
BEGIN
DELETE FROM `guild_position` WHERE `guild_position`.`guild_id`=id;
END;

#
# Definition for the `MFJA_delete_guild_skill01` procedure : 
#

CREATE PROCEDURE `MFJA_delete_guild_skill01`(IN id INTEGER(11))
    NOT DETERMINISTIC
    SQL SECURITY DEFINER
    COMMENT ''
BEGIN
DELETE FROM `guild_skill` WHERE `guild_skill`.`guild_id`=id;
END;

#
# Definition for the `MFJA_delete_guild_storage01` procedure : 
#

CREATE PROCEDURE `MFJA_delete_guild_storage01`(IN id INTEGER(11))
    NOT DETERMINISTIC
    SQL SECURITY DEFINER
    COMMENT ''
BEGIN
DELETE FROM `guild_storage` WHERE guild_storage.`guild_id`=id;
END;

#
# Definition for the `MFJA_delete_homunculus01` procedure : 
#

CREATE PROCEDURE `MFJA_delete_homunculus01`(IN id INTEGER(11))
    NOT DETERMINISTIC
    SQL SECURITY DEFINER
    COMMENT ''
BEGIN
DELETE FROM `homunculus` WHERE `homunculus`.`homun_id`=id;
END;

#
# Definition for the `MFJA_delete_homunculus_skill01` procedure : 
#

CREATE PROCEDURE `MFJA_delete_homunculus_skill01`(IN id INTEGER(11))
    NOT DETERMINISTIC
    SQL SECURITY DEFINER
    COMMENT ''
BEGIN
DELETE FROM `homunculus_skill` WHERE `homunculus_skill`.`homun_id`=id;
END;

#
# Definition for the `MFJA_delete_inventory01` procedure : 
#

CREATE PROCEDURE `MFJA_delete_inventory01`(IN id INTEGER(11))
    NOT DETERMINISTIC
    SQL SECURITY DEFINER
    COMMENT ''
BEGIN
DELETE FROM `inventory` WHERE `inventory`.`char_id`=id;
END;

#
# Definition for the `MFJA_delete_login01` procedure : 
#

CREATE PROCEDURE `MFJA_delete_login01`()
    NOT DETERMINISTIC
    SQL SECURITY DEFINER
    COMMENT ''
BEGIN
DELETE FROM `login` WHERE `login`.`account_id`=id;
END;

#
# Definition for the `MFJA_delete_memo01` procedure : 
#

CREATE PROCEDURE `MFJA_delete_memo01`(IN id INTEGER(11))