--
-- File generated with SQLiteStudio v3.4.4 on Tue May 23 18:50:07 2023
--
-- Text encoding used: System
--
PRAGMA foreign_keys = off;
BEGIN TRANSACTION;

-- Table: RPGAbilityDurationDefinition
CREATE TABLE IF NOT EXISTS RPGAbilityDurationDefinition (AbilityID TEXT COLLATE NOCASE PRIMARY KEY REFERENCES Registry (RegistryID) ON UPDATE CASCADE, Duration REAL, Units TEXT COLLATE NOCASE REFERENCES PotionUnitTypes (UnitID) ON UPDATE CASCADE DEFAULT Seconds, UpgradeAbilityTag TEXT COLLATE NOCASE, UpgradeDuration REAL, UpgradeUnits TEXT COLLATE NOCASE) WITHOUT ROWID;
INSERT OR REPLACE INTO RPGAbilityDurationDefinition (AbilityID, Duration, Units, UpgradeAbilityTag, UpgradeDuration, UpgradeUnits) VALUES ('AMFillPotion', 15.0, 'Seconds', NULL, NULL, NULL);
INSERT OR REPLACE INTO RPGAbilityDurationDefinition (AbilityID, Duration, Units, UpgradeAbilityTag, UpgradeDuration, UpgradeUnits) VALUES ('AutoDamagePotion', 30.0, 'Seconds', NULL, NULL, NULL);
INSERT OR REPLACE INTO RPGAbilityDurationDefinition (AbilityID, Duration, Units, UpgradeAbilityTag, UpgradeDuration, UpgradeUnits) VALUES ('Edurus', 20.0, 'Seconds', NULL, NULL, NULL);
INSERT OR REPLACE INTO RPGAbilityDurationDefinition (AbilityID, Duration, Units, UpgradeAbilityTag, UpgradeDuration, UpgradeUnits) VALUES ('FelixFelicis', 48.0, 'Minutes', NULL, NULL, NULL);
INSERT OR REPLACE INTO RPGAbilityDurationDefinition (AbilityID, Duration, Units, UpgradeAbilityTag, UpgradeDuration, UpgradeUnits) VALUES ('InvisibilityAbility', 6.0, 'Hours', NULL, NULL, NULL);
INSERT OR REPLACE INTO RPGAbilityDurationDefinition (AbilityID, Duration, Units, UpgradeAbilityTag, UpgradeDuration, UpgradeUnits) VALUES ('InvisibilityPotion', 4.0, 'Seconds', 'Talent_Sanc_Invisibility', 10.0, 'Seconds');
INSERT OR REPLACE INTO RPGAbilityDurationDefinition (AbilityID, Duration, Units, UpgradeAbilityTag, UpgradeDuration, UpgradeUnits) VALUES ('Maxima', 20.0, 'Seconds', NULL, NULL, NULL);
INSERT OR REPLACE INTO RPGAbilityDurationDefinition (AbilityID, Duration, Units, UpgradeAbilityTag, UpgradeDuration, UpgradeUnits) VALUES ('PolyJuice_Complete', 100.0, 'Minutes', NULL, NULL, NULL);
INSERT OR REPLACE INTO RPGAbilityDurationDefinition (AbilityID, Duration, Units, UpgradeAbilityTag, UpgradeDuration, UpgradeUnits) VALUES ('Social_HouseLeader', 1.0, 'Days', NULL, NULL, NULL);
INSERT OR REPLACE INTO RPGAbilityDurationDefinition (AbilityID, Duration, Units, UpgradeAbilityTag, UpgradeDuration, UpgradeUnits) VALUES ('Social_Infamous', 1.0, 'Days', NULL, NULL, NULL);
INSERT OR REPLACE INTO RPGAbilityDurationDefinition (AbilityID, Duration, Units, UpgradeAbilityTag, UpgradeDuration, UpgradeUnits) VALUES ('Social_Notoriety', 1.0, 'Days', NULL, NULL, NULL);
INSERT OR REPLACE INTO RPGAbilityDurationDefinition (AbilityID, Duration, Units, UpgradeAbilityTag, UpgradeDuration, UpgradeUnits) VALUES ('WellFed', 4.0, 'Hours', NULL, NULL, NULL);
INSERT OR REPLACE INTO RPGAbilityDurationDefinition (AbilityID, Duration, Units, UpgradeAbilityTag, UpgradeDuration, UpgradeUnits) VALUES ('WellRested', 16.0, 'Hours', NULL, NULL, NULL);
INSERT OR REPLACE INTO RPGAbilityDurationDefinition (AbilityID, Duration, Units, UpgradeAbilityTag, UpgradeDuration, UpgradeUnits) VALUES ('WoundCleaning', 0.0, 'Seconds', NULL, NULL, NULL);

COMMIT TRANSACTION;
PRAGMA foreign_keys = on;
