/*
CREATE TABLE Lu_Gm_Raiting(
id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
name VARCHAR(128) NOT NULL,
description TEXT,
CONSTRAINT PK_Lu_Gm_Raiting1 PRIMARY KEY (id));
*/
INSERT INTO Lu_Gm_Raiting(
name,
description)
VALUES
("True","This event is an accurate description of the real event"),
("Check", "This event is not considered accurate.  You should check the master event"),
("False", "This event false.  You should check the master event.");


/*
CREATE TABLE Lu_Association_Category(
id INT UNSIGNED NOT NULL AUTO_INCREMENT,
name VARCHAR(128) NOT NULL,
description MEDIUMTEXT NOT NULL,
CONSTRAINT PK_Lu_Association_Category1 PRIMARY KEY (id),
UNIQUE UC_name (name),
INDEX IDX_ASSOCIATION_CATEGORY_CODE (id));
*/
INSERT INTO Lu_Association_Category(
name,
description)
VALUES
("Boss", ""),
("Companion", ""),
("Enemy", ""),
("Family - Child", ""),
("Family - Parent", ""),
("Family - Sibling", ""),
("Friend", ""),
("Lackey", ""),
("Lord", ""),
("Lover", ""),
("Master", ""),
("Servant", ""),
("Vassel", "")
;


/*
CREATE TABLE Lu_Association_Rating(
id INT UNSIGNED NOT NULL AUTO_INCREMENT,
name VARCHAR(128) NOT NULL,
description TEXT NOT NULL,
CONSTRAINT PK_Lu_Association_Rating1 PRIMARY KEY (id),
INDEX IDX_ASSOCIATION_RATING_CODE (id));
*/
INSERT INTO Lu_Association_Rating(
name,
description)
VALUES
("Weak", ""),
("Medium", ""),
("Strong", ""),
("N/A", "Not Applicable") /* Should be default */
;


/*
CREATE TABLE Lu_Rank(
id INT UNSIGNED NOT NULL AUTO_INCREMENT,
honorific VARCHAR(128) NOT NULL,
level SMALLINT UNSIGNED NOT NULL,
title VARCHAR(128) NOT NULL,
CONSTRAINT PK_Lu_Rank1 PRIMARY KEY (id),
INDEX IDX_RANK_KEY (id));
*/
INSERT INTO Lu_Rank(
title,
honorific,
level)
VALUES
("Emperor", "Imperial Majesty", 0),
("Protector of the Realm", "Imperial Grace", 1),
("Prince of the Realm", "Imperial Highness", 2),
("King", "Majesty", 2),
("Duke of the Realm", "Royal Highness", 3),
("Ambassador of the Emperor", "Imperial Lordship", 5),
("Ambassador to the Emperor", "Imperial Lordship", 6),
("Knight of Cantor", "Noble Grace", 7),
("Knight Protector", "Royal Highness", 3),
("Prince", "Royal Highness", 4),
("Grand Duke", "Royal Highness", 5),
("Ambassador of the Nation", "Highness", 7),
("Ambassador to the Nation", "Highness", 8),
("Grand Earl", "Highness", 8),
("Grand Count", "Highness", 9),
("Duke", "Highness", 10),
("Margave", "Noble Grace", 12),
("Marquis", "Noble Grace", 13),
("Earl", "Noble Grace", 14),
("Count", "Noble Grace", 15),
("Archbaron", "Noble Grace", 16),
("Viscount", "Lordship", 17),
("Baron", "Lordship", 18),
("Magistar", "Lordship", 19),
("Emissary", "Lordship", 20),
("Knight", "Worthy Sir", 21),
("Gentleman", "Master", 22),
("Garlot", "Imperial Holiness", 2),
("Peers of the Realm", "Imperial Grace", 3),
("Archbishop", "Imperial Grace", 5),
("Bishop", "Grace", 16),
("Decon", "Father", 19)
;

/*
CREATE TABLE Lu_Character_Type(
id TINYINT UNSIGNED NOT NULL AUTO_INCREMENT,
name VARCHAR(128) NOT NULL,
description TEXT,
CONSTRAINT PK_Lu_Character_Type1 PRIMARY KEY (id),
INDEX IDX_Character_Type_NAME (name));
*/
INSERT INTO Lu_Character_Type(
name,
description)
VALUES
("PC", "A character which is played by a player, generally in the table top"),
("NPC", "A character which is player by a player in the free forms only")
;

/*
CREATE TABLE Lu_Organisation_Type(
id INT UNSIGNED NOT NULL AUTO_INCREMENT,
type VARCHAR(128),
CONSTRAINT PK_Lu_Organisation_Type1 PRIMARY KEY (id),
UNIQUE UC_id (id));
*/
INSERT INTO Lu_Organisation_Type(type)
VALUES
("Clan"),
("House"),
("Family"),
("Nation"),
("Empire"),
("Society, Secret"),
("Church"),
("Business"),
("Society, Social"),
("Society, Other"),
("Spy Network"),
("Military"),
("Company")
;

/*
CREATE TABLE Lu_Allegiance_Type(
code CHAR(3) NOT NULL,
name VARCHAR(128) NOT NULL,
description MEDIUMTEXT,
CONSTRAINT PK_Lu_Allegiance_Type1 PRIMARY KEY (code),
UNIQUE UC_name (name));
*/
INSERT INTO Lu_Allegiance_Type(
code,
name,
description)
VALUES
("ALL", "Alliance", ""),
("FUD", "Feud", ""),
("DFB", "Defeated By", ""),
("DFD", "Defeated", ""),
("OFT", "Owes Fealty to", ""),
("CTL", "Controls", ""),
("NUT", "Neutral", ""),
("WAR", "War", ""),
("EFP", "Enforced Peace", ""),
("ICB", "is Contained by", ""),
("CNT", "Contains", "")
;


/*
CREATE TABLE Lu_Allegiance_Strength(
code CHAR(3) NOT NULL,
name VARCHAR(128) NOT NULL,
description MEDIUMTEXT,
CONSTRAINT PK_Lu_Allegiance_Strength1 PRIMARY KEY (code),
UNIQUE UC_name (name));
*/
INSERT INTO Lu_Allegiance_Strength(
code,
name,
description)
VALUES
("STR", "Strong", ""),
("MED", "Medium", ""),
("WEK", "Weak", "")
;

/*
CREATE TABLE Lu_Reliability(
id INT UNSIGNED NOT NULL AUTO_INCREMENT,
code VARCHAR(128) NOT NULL,
desctrption TEXT NOT NULL,
CONSTRAINT PK_Lu_Reliability1 PRIMARY KEY (id));
*/
INSERT INTO Lu_Reliability(
code,
description)
VALUES
("Dependable",""),
("Strong", ""),
("Medium", ""),
("Low", ""),
("Unreliable", "")
;


/*
CREATE TABLE Lu_Report_State(
code CHAR(3) NOT NULL,
description MEDIUMTEXT NOT NULL,
name VARCHAR(128) NOT NULL,
CONSTRAINT PK_Lu_Report_State1 PRIMARY KEY (code));
*/
INSERT INTO Lu_Report_State(
code,
name,
description)
VALUES
("new", "new report", "A newly created report, which hasn't yet been submitted"),
("sub", "submitted", "A report submitted to the GM for approval"),
("apv", "approved", "Approved by the GM"),
("upd", "updating", "A report which has been released from approved to allow a player to update the report")
;


/*
CREATE TABLE Lu_Event_Type(
id INT UNSIGNED NOT NULL AUTO_INCREMENT,
name VARCHAR(128) NOT NULL,
description TEXT NOT NULL,
CONSTRAINT PK_Lu_Event_Type1 PRIMARY KEY (id),
UNIQUE UC_name (name));
*/
INSERT INTO Lu_Event_Type(
name,
description)
VALUES
("Major, Long Term", "An event which will have major long term effect on plot."),
("Major, Short Term", "An event which will have major short term effect on plot."),
("Minor, Long Term", "An event which will have minor long term effects on a plot."),
("Minor, Short Term", "An event which will have minor short term effects on a plot."),
("Knowledge", "Something other than an event")
;

/*
CREATE TABLE Lu_Race(
id TINYINT UNSIGNED NOT NULL AUTO_INCREMENT,
name VARCHAR(128) NOT NULL,
description MEDIUMTEXT NOT NULL,
CONSTRAINT PK_Lu_Race1 PRIMARY KEY (id));
*/
INSERT INTO Lu_Race(
name,
description)
VALUES
("Tiranese", "People from Tiran"),
("Drakish", "People from Drakland")
;
;
