create_roybot_example_table.sql

CREATE TABLE `ruler` (
	`Name` TEXT COLLATE NOCASE,
	`Number` TEXT,
	`Title` TEXT COLLATE NOCASE,
	`Portrait` TEXT,
	`House` TEXT COLLATE NOCASE,
	`Country` TEXT COLLATE NOCASE,
	`Era` TEXT COLLATE NOCASE,
	`DtBirth` TEXT,
	`DtDeath` TEXT,
	`DeathCircumstances` TEXT,
	`ReignStartDt` TEXT,
	`ReignEndDt` TEXT,
	`Description` TEXT,
	`FamousBattles` TEXT,
	`NotableEventsDuringLife` TEXT,
	`RulerType` TEXT,
	`RulerId` INTEGER
	)