這裡也分享一張沒有上傳到圖片站上的圖片（這張圖用的模型是 Flux.1 Dev. 對於商用並沒有那麼自由）。它叫做 Greeky. 在 Morton, Lisa. 2012. Trick or Treat : A History of Halloween. London: Reaktion Books 中提到 Halloween 的起源：
“Samhain was also an important day for administration, akin to the US Tax Day in modern times. A yearly gathering was held at Tara, the ancient seat of kings, where three days’ worth of feasting and sporting alternated with debt repayment and trials (those who were found guilty of particularly severe crimes were executed then as well).” Deepl 翻譯: Samhain 也是一個重要的行政日，類似於現代美國的納稅日。一年一度的聚會在古代國王的所在地塔拉 (Tara) 舉行，三天的宴會和體育活動與還債和審判交替進行（那些被判犯有特別嚴重罪行的人也會在這一天被處決）。
Self-Enslavement as Resistance to the State? Siamese Early Modern Laws on Slavery Eugénie Mérie au （University of Paris 1 Panthéon-Sorbonne） I examine slavery laws, as reproduced in the 1805 Three Seals Code, as well as accounts of Europeans, to compare the legal conditions of enslaved people and serfs in early modern Siam. I argue that the Siamese kingdom of Ayutthaya (1350–1767) was a slave society where contractual self-enslavement was a widespread means for serfs to escape required corvée and military service to the state. I also suggest that differentiating indigenous contractual slaves (temporary, collateral, and permanent), who were protected to various degrees by the law, from enslaved foreign war captives, who were potentially outside of any legal framework, invites us to rethink freedom and slavery as a continuum rather than a dichotomy.
DELIMITER $$
CREATE PROCEDURE FindCSourceRecords()
BEGIN
DECLARE done INT DEFAULT FALSE;
DECLARE tableName VARCHAR(255);
DECLARE cur CURSOR FOR
SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME = 'c_source'
AND TABLE_SCHEMA = 'cbdb_data'; -- Replace with your database name
DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;
OPEN cur;
read_loop: LOOP
FETCH cur INTO tableName;
IF done THEN
LEAVE read_loop;
END IF;
-- Corrected dynamic SQL to properly execute and check for existence
SET @s = CONCAT('SELECT EXISTS (SELECT 1 FROM ', tableName, ' WHERE c_source = 38299) INTO @exists;');
PREPARE stmt FROM @s;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;
-- Check if the query found a row and then do something with the result
IF @exists THEN
-- This is a placeholder action; you might want to SELECT the table name or insert it into a log
SELECT CONCAT('Found in table: ', tableName) AS Result;
END IF;
END LOOP;
CLOSE cur;
END$$
DELIMITER ;
Call query procedure
CALL FindCSourceRecords();
Remove query procedure
DROP PROCEDURE IF EXISTS FindCSourceRecords;
The procedure to update
DELIMITER $$
CREATE PROCEDURE UpdateCSourceRecords()
BEGIN
DECLARE done INT DEFAULT FALSE;
DECLARE tableName VARCHAR(255);
DECLARE cur CURSOR FOR
SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME = 'c_source'
AND TABLE_SCHEMA = 'cbdb_data'; -- Replace with your actual database name
DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;
OPEN cur;
read_loop: LOOP
FETCH cur INTO tableName;
IF done THEN
LEAVE read_loop;
END IF;
-- Dynamic SQL for updating c_source values
SET @s = CONCAT('UPDATE ', tableName, ' SET c_source = 9334 WHERE c_source = 38299;');
PREPARE stmt FROM @s;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;
END LOOP;
CLOSE cur;
END$$
DELIMITER ;
