[DiscordArchive] Will run the importer then?
[DiscordArchive] Will run the importer then?
Original source
-- DB update 2017_10_14_00 -> 2017_10_14_01
DROP PROCEDURE IF EXISTS `updateDb`;
DELIMITER //
CREATE PROCEDURE updateDb ()
proc:BEGIN DECLARE OK VARCHAR(100) DEFAULT 'FALSE';
SELECT COUNT(*) INTO @COLEXISTS
FROM information_schema.COLUMNS
WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'version_db_world' AND COLUMN_NAME = '2017_10_14_00';
IF @COLEXISTS = 0 THEN LEAVE proc; END IF;
START TRANSACTION;
ALTER TABLE version_db_world CHANGE COLUMN 2017_10_14_00 2017_10_14_01 bit;
SELECT sql_rev INTO OK FROM version_db_world WHERE sql_rev = '1504704582101308200'; IF OK <> 'FALSE' THEN LEAVE proc; END IF;
--
-- START UPDATING QUERIES
--
--
-- END UPDATING QUERIES
--
COMMIT;
END;
//
DELIMITER ;
CALL updateDb();
DROP PROCEDURE IF EXISTS `updateDb`;
rektbyfaith
10-15-2017, 09:27 AM #11Archived author: STARRHELD • Posted: 2017-10-15T09:27:45.269000+00:00
Original source
-- DB update 2017_10_14_00 -> 2017_10_14_01
DROP PROCEDURE IF EXISTS `updateDb`;
DELIMITER //
CREATE PROCEDURE updateDb ()
proc:BEGIN DECLARE OK VARCHAR(100) DEFAULT 'FALSE';
SELECT COUNT(*) INTO @COLEXISTS
FROM information_schema.COLUMNS
WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'version_db_world' AND COLUMN_NAME = '2017_10_14_00';
IF @COLEXISTS = 0 THEN LEAVE proc; END IF;
START TRANSACTION;
ALTER TABLE version_db_world CHANGE COLUMN 2017_10_14_00 2017_10_14_01 bit;
SELECT sql_rev INTO OK FROM version_db_world WHERE sql_rev = '1504704582101308200'; IF OK <> 'FALSE' THEN LEAVE proc; END IF;
--
-- START UPDATING QUERIES
--
--
-- END UPDATING QUERIES
--
COMMIT;
END;
//
DELIMITER ;
CALL updateDb();
DROP PROCEDURE IF EXISTS `updateDb`;
Original source
There are no quiries inside none of them from October the 14th
rektbyfaith
10-15-2017, 09:28 AM #12Archived author: STARRHELD • Posted: 2017-10-15T09:28:38.286000+00:00
Original source
There are no quiries inside none of them from October the 14th
Original source
So no wonder we are missing stuff
rektbyfaith
10-15-2017, 09:28 AM #13Archived author: STARRHELD • Posted: 2017-10-15T09:28:52.764000+00:00
Original source
So no wonder we are missing stuff
Original source
mmm i think that talamorts didn't run the script at this point xD
rektbyfaith
10-15-2017, 09:30 AM #14Archived author: Yehonal • Posted: 2017-10-15T09:30:36.715000+00:00
Original source
mmm i think that talamorts didn't run the script at this point xD
Original source
it's totally wrong
rektbyfaith
10-15-2017, 09:30 AM #15Archived author: Yehonal • Posted: 2017-10-15T09:30:39.411000+00:00
Original source
it's totally wrong
Original source
i didn't notice it
rektbyfaith
10-15-2017, 09:34 AM #16Archived author: Yehonal • Posted: 2017-10-15T09:34:03.305000+00:00
Original source
i didn't notice it
Original source
rektbyfaith
10-15-2017, 09:34 AM #17Archived author: STARRHELD • Posted: 2017-10-15T09:34:27.233000+00:00
Original source
Original source
<@171701405172760577> take a look
rektbyfaith
10-15-2017, 09:50 AM #18Archived author: Yehonal • Posted: 2017-10-15T09:50:12.241000+00:00
Original source
<@171701405172760577> take a look
Original source
Minute.
rektbyfaith
10-15-2017, 09:55 AM #19Archived author: STARRHELD • Posted: 2017-10-15T09:55:14.951000+00:00
Original source
Minute.
Original source
wait
rektbyfaith
10-15-2017, 09:55 AM #20Archived author: Yehonal • Posted: 2017-10-15T09:55:18.746000+00:00
Original source
wait
1 Guest(s)
1 Guest(s)