initialize.py

# This work is licensed under the Creative Commons Attribution 4.0 International License.
# To view a copy of this license, visit http://creativecommons.org/licenses/by/4.0/ or send a letter to Creative Commons, PO Box 1866, Mountain View, CA 94042, USA.
# This license covers the contents of the MySQL database which created with this Python source code.
# This license does not cover the Python source code that is used to create the MySQL database.

import dbconn as db
import globalvars as g

def Data():
    db.cur.execute("use TGTHB;")
    
    if g.debug:
        print("Inserting data into table: command")
    
    #        COMMAND
    
    db.cur.execute("insert into command values ('att','attack','att <person> | Attack target with the currently held weapon.');")
    db.cur.execute("insert into command values ('attack','attack','attack <person> | Attack target with the currently held weapon.');")
    db.cur.execute("insert into command values ('buy','buy','Display a list of buyable items. Use buy <item> to exchange money for an item.');")
    db.cur.execute("insert into command values ('c','talk','c <person> about <topic> | Talk to a person about a topic.');")
    db.cur.execute("insert into command values ('call','call','call <person> | Call a person with a telephone if they are reachable with a telephone.');")
    db.cur.execute("insert into command values ('chat','talk','chat <person> about <topic> | Talk to a person about a topic.');")
    db.cur.execute("insert into command values ('d','drop','d <item> | Drop an item from your inventory into the current area.');")
    db.cur.execute("insert into command values ('down','down','Move down.');")
    db.cur.execute("insert into command values ('drop','drop','drop <item> | Drop an item from your inventory into the current area.');")
    db.cur.execute("insert into command values ('dw','down','Move down.');")
    db.cur.execute("insert into command values ('e','east','Move east.');")
    db.cur.execute("insert into command values ('east','east','Move east.');")
    db.cur.execute("insert into command values ('ex','examine','ex <item/location/person> | Take closer look at an item, location, or a person.');")
    db.cur.execute("insert into command values ('examine','examine','examine <item/location/person> | Take closer look at an item, location, or a person.');")
    db.cur.execute("insert into command values ('f','shoot','f <person> | Shoot the currently equipped ranged weapon at a person.');")
    db.cur.execute("insert into command values ('fire','shoot','fire <person> | Shoot the currently equipped ranged weapon at a person.');")
    db.cur.execute("insert into command values ('g','give','g <item> to <person> | Give a person an item from your inventory.');")
    db.cur.execute("insert into command values ('get','take','get <item> | Take an item from the current area to your inventory.');")
    db.cur.execute("insert into command values ('give','give','give <item> to <person> | Give a person an item from your inventory.');")
    db.cur.execute("insert into command values ('go','travel','go <location> | Travel to a special location not available with the usual directional commands. ');")
    db.cur.execute("insert into command values ('greet','greet','greet <person> | Greet a person.');")
    db.cur.execute("insert into command values ('gt','travel','gt <location> | Travel to a special location not available with the usual directional commands. ');")
    db.cur.execute("insert into command values ('h','greet','h <person> | Greet a person.');")
    db.cur.execute("insert into command values ('hello','greet','hello <person> | Greet a person.');")
    db.cur.execute("insert into command values ('help','help','Display a full command list. Use help <cmd> to display information about a specific command.');")
    db.cur.execute("insert into command values ('i','inventory','Show the player inventory.');")
    db.cur.execute("insert into command values ('inv','inventory','Show the player inventory.');")
    db.cur.execute("insert into command values ('inventory','inventory','Show the player inventory.');")
    db.cur.execute("insert into command values ('l','look','Gives a description of the area around the player.');")
    db.cur.execute("insert into command values ('load','load','Load the saved game.');")
    db.cur.execute("insert into command values ('look','look','Gives a description of the area around the player.');")
    db.cur.execute("insert into command values ('n','north','Move north.');")
    db.cur.execute("insert into command values ('ne','northeast','Move north-east.');")
    db.cur.execute("insert into command values ('neast','northeast','Move north-east.');")
    db.cur.execute("insert into command values ('north','north','Move north.');")
    db.cur.execute("insert into command values ('northe','northeast','Move north-east.');")
    db.cur.execute("insert into command values ('northeast','northeast','Move north-east.');")
    db.cur.execute("insert into command values ('northw','northwest','Move north-west.');")
    db.cur.execute("insert into command values ('northwest','northwest','Move north-west.');")
    db.cur.execute("insert into command values ('nw','northwest','Move north-west.');")
    db.cur.execute("insert into command values ('nwest','northwest','Move north-west.');")
    db.cur.execute("insert into command values ('open','use','open <item> | Open the item if it can be opened.');")
    db.cur.execute("insert into command values ('quit','quit','Quit the game.');")
    db.cur.execute("insert into command values ('read','use','read <item> | Read the item if it can be read.');")
    db.cur.execute("insert into command values ('rent','rent','rent <item/object> | Exchange money to temporarily gain access to an item or an object. You get your money back when you return an item, but not when returning an object.');")
    db.cur.execute("insert into command values ('restart','restart','Recreate database and restore data into the initial state. This deletes any saved changes restarting the game from the beginning.');")
    db.cur.execute("insert into command values ('s','south','Move south.');")
    db.cur.execute("insert into command values ('save','save','Save the game.');")
    db.cur.execute("insert into command values ('say','say','say <words> | Say something aloud, not directed to anyone.');")
    db.cur.execute("insert into command values ('se','southeast','Move south-east.');")
    db.cur.execute("insert into command values ('seast','southeast','Move south-east.');")
    db.cur.execute("insert into command values ('shoot','shoot','shoot <person> | Shoot the currently equipped ranged weapon at a person.');")
    db.cur.execute("insert into command values ('south','south','Move south.');")
    db.cur.execute("insert into command values ('southe','southeast','Move south-east.');")
    db.cur.execute("insert into command values ('southeast','southeast','Move south-east.');")
    db.cur.execute("insert into command values ('southw','southwest','Move south-west.');")
    db.cur.execute("insert into command values ('southwest','southwest','Move south-west.');")
    db.cur.execute("insert into command values ('speak','talk','speak <person> about <topic> | Talk to a person about a topic.');")
    db.cur.execute("insert into command values ('sw','southwest','Move south-west.');")
    db.cur.execute("insert into command values ('swest','southwest','Move south-west.');")
    db.cur.execute("insert into command values ('t','take','t <item> | Take an item from the current area to your inventory.');")
    db.cur.execute("insert into command values ('take','take','take <item> | Take an item from the current area to your inventory.');")
    db.cur.execute("insert into command values ('talk','talk','talk <person> <topic> | Talk to a person about a topic.');")
    db.cur.execute("insert into command values ('tips','tips','Display the developer tips.');")
    db.cur.execute("insert into command values ('travel','travel','travel <location> | Travel to a special location not available with the usual directional commands. ');")
    db.cur.execute("insert into command values ('tt','travel','tt <location> | Travel to a special location not available with the usual directional commands. ');")
    db.cur.execute("insert into command values ('u','use','u <item> on <item/object> | A general purpose command to perform an action with an item. Some items that are in your inventory can be used in combination with other items in the world.');")
    db.cur.execute("insert into command values ('up','up','Move up.');")
    db.cur.execute("insert into command values ('use','use','use <item> on <item/object> | A general purpose command to perform an action with an item such as opening, reading, and others. Some items that are in your inventory can be used in combination with other items in the world.');")
    db.cur.execute("insert into command values ('w','west','Move west.');")
    db.cur.execute("insert into command values ('west','west','Move west.');")
    db.cur.execute("insert into command values ('x','examine','x <item/location/person> | Take closer look at an item, location, or a person.');")

    if g.debug:
        print("Inserting data into table: text")
    
    #        TEXT
    
    db.cur.execute("insert into text values ('archbleh','This object isn''t particularly interesting.');")
    db.cur.execute("insert into text values ('archdagg','You inspect the dagger for a while and quickly notice a slit between the pommel and the handle. It almost seems like the dagger could be opened.');")
    db.cur.execute("insert into text values ('archfake','You inspect the sword all around with the help of your Archeological Tools and realize that it has been made using techniques and materials unknown to the Vikings. \"This sword was not made by the Vikings! It is a replica!\"');")
    db.cur.execute("insert into text values ('bookinca','Inca oral history mentions three caves as the origin of life: Tambo Tocco, Maras Tocco and Sutic Tocco. Out of Tambo Tocco stepped four brothers and sisters: Ayar Manco, Ayar Cachi, Ayar Auca, Ayar Uchu, Mama Ocllo, Mama Raua, Mama Huaca, and Mama Cora. They were to be the ancestors of all the clans of the Inca people. Ayar Manco carried a magic staff made of the finest gold that would indicate the ideal place for Incas to live. After long travels, they reached Cusco where the staff sank into the ground. The people already living in Cusco fought hard to keep their land, but Mama Huaca was a fighter without a rival. When the people of Cusco attacked, she threw her bolas at a soldier killing him instantly. The other inhabitants, terrified, ran away. Finally the Incas settled in Cusco. After that, Ayar Manco became known as Manco Cápac, the founder of the Inca. It is said he and his sisters built the first Inca homes in the valley with their own hands. When it was time forhim to pass away, Manco Cápac instead turned to stone and a shrine was built around him. His son, Sinchi Roca, became the second emperor of the Inca. Sinchi Roca sacrificed humans on the steps of the shrine to honour his father. He used a special sword for this: it was called Nina Khillaychuki (“Fire Sword”) due to its orange hue. When swung, it seemed as though the metal had just been heated in brazing coals.');")
    db.cur.execute("insert into text values ('death','You have died.');")
    db.cur.execute("insert into text values ('devtips','DEVELOPER TIPS\n--------------\nThe game has a robust text matching system. You are not required to type in the full names of objects. A small part, sometimes even a single letter, will be enough to find the correct item, person, or location. Don''t worry, the game will ask you to be more specific when multiple objects with similar names are found.\n\nGreeting and speaking to people is essential for learning more information about certain topics and progressing in the game. Some people can be talked to multiple times and can even tell you new information about the same topic if talked to again. Talking to people may open up new dialogue options with the same, or some other person. There are some hidden locations that are not accessible until you have learned about them or about something that is there. Examine objects, people, and locations to discover previously hidden items and additional information. Special actions can be performed by using some objects and some things can be used in combination with other objects. Be mindful of your spending, you have a limited amount of money.\n\nThis game has a lot of text. Sometimes more than one full screen of text is shown at once. If you notice a large paragraph be sure to check above it as not to miss any potentially important text. All player input is prefixed with the \">\" symbol and any text shown because of that command is below that line up until the bottom of the console where there is another ''>'' symbol signifying that the game is waiting for input.\n\nIf you are unsure how to proceed try the \"help\" command or use the \"tips\" command to show this text again. Don''t forget the \"save\" and \"load\" commands! Use \"restart\" to begin the game again from the start.\n\nYou can lose the game.\n');")
    db.cur.execute("insert into text values ('dictonor','--------------------\nOLD NORSE DICTIONARY\n--------------------\nThese words are most likely fictional but they were made by combining real Old Norse words. The interpunct is used to separate words from one another. Pronunciation guide inside slashes is tailored to make it easier for Finns to read and as such does not follow English pronunciation methods. Words without Norse characters inside brackets. The r is rolled heavily. The h in ð is almost silent like in “this” while the h in Þ is pronounced like in “thin”.\n\nPeople & Creatures\n------------------\nÆsir /aisirr/ (aesir)\n Race of gods in Asgard.\nEiríkr Þorvaldsson /eiriikrr thorrvaldsson/ (eirikr thorvaldsson)\n Erik Thordvaldsson, father of Leif Eriksson.\nEiríkr hinn Rauði /eiriikrr hinn raut(h)i/ (eirikr hinn rauthi)\n Erik the Red, father of Leif Eriksson.\nHveðrungr /hvet(h)rungr/ (hvethrungr)\n Loki, Norse god of fire and trickery.\nJǫtunn /jötunn/ (jötunn)\n Giants of Norse mythology, banished from Asgard.\nLeifr Eiríksson /leifrr eiriiksson/ (leifr eiriksson)\n Leif Eriksson, a famous viking.\nÓðinn /oot(h)inn/ (othinn)\n Odin, Allfather of the gods and the ruler of Asgard.\nÞórr /thoorr/ (thorr)\n Thor, son of Odin, Norse god of thunder.\nSeiðmenn /seit(h)menn/ (seithmenn)\n A male shaman.\nVǫlur /vöölurr/ (völur)\n A female shaman.\nLinnormr /linnorrmrr/\n Lindworm, a wingless bipedal lizard with a venomous bite.\n\nObjects\n-------\nBál·brandr /baal·brandr/ (baalbrandr)\n Fireblade, sword of Loki.\nFjǫr·steinn /fjöör·steinn/ (fjörsteinn)\n Lifestone, the gem in Loki''s sword.\nVarmr·svell /varmrr·svekl/\n Warm ice, Loki''s gem that is encrusted in ice.\nGuð·hjǫrr /gut(h)·hjöörr/ (guthhjörr)\n Godsword, Bálbrandr that lacks the Fjǫrsteinn.\n\nLocations\n---------\nÁsgarðr /aasgarrt(h)rr/ (asgarthr)\n The home of the gods.\nValhöll /valhökl/\n Hall of the slain, those who die in combat travel to Valhalla.\n\nOther Words\n-----------\nEngi·andlát·líf /engi·andlaat·liif/ (engiandlatlif)\n No death life, immortal.\nEngi·andlát·æv /engi·andlaat·eev/ (engiandlataev)\n No death life, immortality.\nSeiðr /seit(h)rr/ (seithr)\n Norse magic/shamanism.\nMóðir /moot(h)irr/ (mothir)\n Mother.\nFaðir /fat(h)irr/ (fathir)\n Father.\nYfir-maðr /yfir-mat(h)rr/ (yfir-mathr)\n Leader or chieftain.');")
    db.cur.execute("insert into text values ('dontgive','What good would that do?');")
    db.cur.execute("insert into text values ('endfjors','The museum wants you to write an article about your travel. It will be used as advertisement, and you will be receiving 10% of the entrance fee gains it entails.');")
    db.cur.execute("insert into text values ('endguthh','Great work! You will get a fantastic recommendation letter from Gorka, which in turn allows you to become a renowned archaeologist. Your adventures are only just getting started...');")
    db.cur.execute("insert into text values ('ending','A MORTAL.@I CAN FEEL IT.@I CAN SEE YOUR MIND.@A FRAIL MIND.@YOU.@HOW DARE YOU LAY YOUR HANDS UPON MY WEAPON.@YOU ARE NOT WORTHY.@YOU ARE NOT FIT TO EVEN LOOK UPON SUCH POWER THAT IS WOVEN INTO BÁLBRANDR.@YOU.@A MORTAL.@A >HUMAN.@NOT EVEN A JǪTUNN.@BUT A MERE| MORTAL| FRAGILE.@TEMPORARY.@SHELL OF EXISTENCE.@YOU.@YOU HAVE MY BÁLBRANDR.@YOU CANNOT EVEN USE IT.@YOU CANNOT EVEN COMPREHEND ITS TRUE POWER.@YOU.@I WILL.@END.@YOUR.1S:H:O:R:T.2I:N:S:I:G:N:I:F:I:C:A:N:T.3E-X-I-S-T-E-N-C-E4445');")
    db.cur.execute("insert into text values ('endkfjor','So, you have decided to follow Zlatin''s example by keeping the Fjǫrsteinn to yourself? What will you do with it? Will you keep it a secret? Will you become a public figure, a healer? A figure in the shadows, a person appearing throughout the pages of history for much longer than any human should? The path ahead of you is full of open doors for your life is neverending.');")
    db.cur.execute("insert into text values ('endkguth','Guðhjǫrr. A sword of myth. A sword of power. You feel your body renewing whenever you hold it. You feel fearless. Undefeatable. What will you do with such power? The choice is yours alone, for no man nor god can overcome your awesome power.');")
    db.cur.execute("insert into text values ('endneckl','The museum is grateful to you for acquiring this artifact, but you will not be reimbursed.');")
    db.cur.execute("insert into text values ('endrepli','You have returned an Inca replica of the legendary Guðhjǫrr. Gorka gives his thanks for adding another exhibit to his museum.');")
    db.cur.execute("insert into text values ('essentia','A person of significant importance has died. An important clue leading to the treasures has passed with the life of this person, the knowledge is forever lost.');")
    db.cur.execute("insert into text values ('exaeleus','You look around the rooms in the monastery but can''t seem to find a anything of particular importance anywhere. You return back to where you started and notice a Martenitsa made from red and white string on the floor. A mere few meters away from where you originally stood. \"Perhaps I should have started searching in this room first rather than going to through the entire monastery.\" you think to yourself.');")
    db.cur.execute("insert into text values ('exafores','You examine the forest floor and in a crevice between roots of a tree something gray catches your eyes. You crouch at the roots and discover light gray scales. A shed skin of some sort of a lizard. Even though the forest floor is not snowy the white skin is tucked away fairly deep in the crevice and is not spotted easily.');")
    db.cur.execute("insert into text values ('examount','You examine the snowy landscape and discover several sets of footprints leading to the north but they are not recent. This path is not often walked but somebody must live around here.');")
    db.cur.execute("insert into text values ('exanone','There is nothing particular in this area.');")
    db.cur.execute("insert into text values ('gordagg','A tightly rolled letter falls out!');")
    db.cur.execute("insert into text values ('grwelcom','A local fisherman notices you. He eyes you for a bit before deciding that you''re probably not a merchant. \"Here for the crater are ya?\" he says. \"Just head on straight through the town and into the wilderness. It''s not too far.\"');")
    db.cur.execute("insert into text values ('gtitle2','  Version 1.0 (2014-10-16)\n--------------------------------------------------------------------------------\n|             Tales of Gods and Treachery: The Hunt for Bálbrandr              |\n--------------------------------------------------------------------------------\n|             Alternative History Low Fantasy Interactive Fiction              |\n|                           Designed & Developed by                            |\n|                           T. K., L. S. & J. U. of                            |\n|                 of Metropolia University of Applied Sciences                 |\n--------------------------------------------------------------------------------\n For 32/64-bit Windows NT Platforms                                 | Python 3 |\n                                                                    ------------\n');")
    db.cur.execute("insert into text values ('immortal','You have chosen to join the two into one. Perhaps unaware of the consequences. Perhaps on purpose. For doing so your life will unchangeably be set upon a path of gods and treachery.\n\nIn a brilliant flash of light and an deafening hum the Fjǫrsteinn sets into the slot in the hilt of Guðhjǫrr the two becoming one.\n\nYou feel adrenaline rushing through your veins like never before and your heart feels like it''s exploding. The sword is burning your hand, but you feel no pain. It''s warmth like that of a furnace encompasses your entire being. The blade glows as if it were on fire. For a moment you fear the metal might melt but you fail to form another thought as your mind goes blank. Your eyes go blind. Your head is filled with a voice louder than anything you have ever heard in your life.');")
    db.cur.execute("insert into text values ('innuendo','The sword slides in effortlessly into the hole in the altar. The harder you push the further the side of the altar opens. Once the sword is inside the slit up to it''s hilt the side of altar is completely open revealing a sword inside. The replica sword is now firmly stuck inside the altar.');")
    db.cur.execute("insert into text values ('intro','You are a Spanish archeology student studying at Museo de las Bellas Artes. The museum has just received a new artifact, a Bulgarian Dagger, and the museum director Gorka Ibaiguren has asked you to take care of inspecting the dagger to determine its age, origin and anything else of particular interest.');")
    db.cur.execute("insert into text values ('killrob1','Right as you rush through the door to hide in your room a deafening bang fills the carriage and a bullet hits your back. The robber is not yet satisfied yet and decides put a couple more bullets in your back while you''re laying on the ground bleeding profusely from your mouth.');")
    db.cur.execute("insert into text values ('killrob2','The two other robbers react quickly and carefully deposit numerous bullets in the general area around your heart.');")
    db.cur.execute("insert into text values ('killrob3','The other robbers crash through the door, notice their friend dead on the floor, and fill you with lead remarkably quickly.');")
    db.cur.execute("insert into text values ('killskel','Right as you take the sword from the altar the skeleton leaps towards you with the rattle of bones echoing in the cave. It goes straight for your neck with it''s disturbing sharp teeth and tears your throat out. The amount of blood outside your body is rapidly becoming greater than the amount of blood inside your body.');")
    db.cur.execute("insert into text values ('killvolu','Vǫlur let''s out a bloodcurdling scream, thrusts her hands towards you and in a flash of light you can feel the blood start boiling in your veins. You fall to the floor from the searing hot pain and in your last seconds of consciousness you see flames from Vǫlur''s eyes licking her face without harming her. Your consciousness fades...');")
    db.cur.execute("insert into text values ('kolpleas','The ghost looks at you disappointingly.');")
    db.cur.execute("insert into text values ('letter','Dear friend,\nI apologise for not contacting you earlier; my travels have left me little time to indulge in such activities. That is why I am thinking of settling down in a monastery in Burgas and leading a quiet life, away from the stress of Sofia. I encountered the Fjǫrsteinn on my last adventure, and with it I will be able to live long enough to truly find myself. I hope this message finds you well and healthy. Hoping to have the pleasure of your visit soon,\nyour fellow chess enthusiast Zlatin Panayotov\n\nP.S. Have you read my book on Erik the Red? I would like it if you sent me your thoughts about it later.');")
    db.cur.execute("insert into text values ('nophone','There''s no answer.');")
    db.cur.execute("insert into text values ('peghhaha','The bullet passes through the ghost and it continues idly floating around being all spooky.');")
    db.cur.execute("insert into text values ('phonthin','\"Huh, nobody''s here.\" you think to yourself \"Is that a phone? I wonder if I could call Gorka.\"');")
    db.cur.execute("insert into text values ('robburst','A robber bursts into the carriage right behind you. He yells something incomprehensible while aiming his gun at your chest.');")
    db.cur.execute("insert into text values ('robescap','You just barely manage to escape from the robbers. But you hear them running towards you in the other carriage.');")
    db.cur.execute("insert into text values ('robhide','You slip into the room and quickly lock the door behind you. You thank your luck, who knows what would have happened if the door was locked. You wait in the small dark room for a few minutes just to be sure. The train stops for a moment and continues moving soon after. The robbers must have left but you decide to wait around for an hour just to be sure.');")
    db.cur.execute("insert into text values ('robresta','As you enter the carriage some people in masks are waving guns around demanding people''s valuables. One of them spots you and yells something in Hindi.');")
    db.cur.execute("insert into text values ('shiphere','This where the ship sunk according to the Lone Patron.');")
    db.cur.execute("insert into text values ('shipunde','The ship is underwater and I am not diving down there without proper gear.');")
    db.cur.execute("insert into text values ('skelboom','The impact of the bullet causes the skeleton to explode in a magnificent shower of bones.');")
    db.cur.execute("insert into text values ('sleepinn','You slept well. In the morning you descend down the stairs to the bar. The innkeeper is still behind the counter, you wonder if she sleeps at all. \"If you''re looking for Jens, the man you were asking about last night, you''ll probably find him at his house a bit east from here.\" the innkeeper says to you.');")
    db.cur.execute("insert into text values ('tifiboat','The Fisherman takes you along the river with his little boat.');")
    db.cur.execute("insert into text values ('usearch','These tools are certainly very useful but not on their own. You should consider using them on other items to inspect them with care.');")
    db.cur.execute("insert into text values ('usedagg','You screw open the handle of the dagger and a tightly rolled letter falls out!');")
    db.cur.execute("insert into text values ('uselett','The letter appears to be written in Old Norse.');")
    db.cur.execute("insert into text values ('usesuit','\"This should be useful for exploring that sunk viking ship.\"');")
    db.cur.execute("insert into text values ('vikbook','This paragraph from the book caught your eye.\n\nEiríkr hinn Rauði, known as Erik the Red in modern times, discovered a sword in the crater of a meteorite near Maniitsoq, Greenland, circa 1000. According to the folk story, the sword was Bálbrandr, Loki''s weapon that fell all the way to Earth during his fight with Thor. The god of thunder won and bound Loki, so the latter could not retrieve his sword. Bálbrandr consisted of two parts: a metal blade that made its beholder invincible and a gem that prolonged life. When the amulet was placed in the sword''s hilt, the owner became immortal. The sword and gem separated upon the weapon''s fall to Earth. The gem was never seen again, and the sword became known as Guðhjǫrr.\n Guðhjǫrr was passed onto Erik'' son, Leifr Eiríksson, the first European to set foot on continental North America. Leifr is believed to have died between the years 1019 and 1025- the conditions of his death are very unclear. During this time, the precious sword was lost and it disappeared from Norse mythology.');")
    db.cur.execute("insert into text values ('wolftrai','The wolves walk to the north and into the wilderness, leaving behind a trail in the snow.');")

    if g.debug:
        print("Inserting data into table: save")
    
    #        SAVE
    
    db.cur.execute("insert into save values ('money','10');")
    db.cur.execute("insert into save values ('turns','0');")
    db.cur.execute("insert into save values ('score','0');")
    db.cur.execute("insert into save values ('wearDiveSuit','0');")
    db.cur.execute("insert into save values ('rentDiveSuit','0');")
    db.cur.execute("insert into save values ('wolvesGuided','0');")
    db.cur.execute("insert into save values ('grFisherCrater','0');")
    db.cur.execute("insert into save values ('chapters','1');")
    db.cur.execute("insert into save values ('firstBulgaria','1');")
    db.cur.execute("insert into save values ('inTrainRobbed','0');")
    db.cur.execute("insert into save values ('spletterRead','0');")
    db.cur.execute("insert into save values ('inTrainRobDone','0');")
    db.cur.execute("insert into save values ('inTrainBack','0');")
    db.cur.execute("insert into save values ('zlaGreet','0');")
    db.cur.execute("insert into save values ('firstTanz','1');")
    db.cur.execute("insert into save values ('firstPeru','1');")
    db.cur.execute("insert into save values ('backToIndia','0');")
    db.cur.execute("insert into save values ('spletterDropped','0');")
    db.cur.execute("insert into save values ('grkolbOut','0');")
    db.cur.execute("insert into save values ('buMartFind','0');")
    db.cur.execute("insert into save values ('grforSkin','0');")
    db.cur.execute("insert into save values ('grShamanMeet','0');")
    db.cur.execute("insert into save values ('spgorCalled','0');")
    db.cur.execute("insert into save values ('pewayCalled','0');")
    db.cur.execute("insert into save values ('gameSaved','0');")
    
    if g.debug:
        print("Inserting data into table: location")
    
    #        LOCATION
       
    db.cur.execute("insert into location values ('buairpor','Burgas Airport','0','The second largest airport in Bulgaria is not as impressive as it sounds. The previously white building is now a speckled gray color. Inside are rows of blue plastic chairs and impatient travelers.');")
    db.cur.execute("insert into location values ('buburgas','Burgas','1','Burgas is an old Thracian city located between the Dead Sea and the Burgas Lake. It is economically important because of the port- it is the main fishing site in Bulgaria.');")
    db.cur.execute("insert into location values ('bueleusa','Eleusa Monastery','1','This monastery dates from the 6th century. While it is mainly in ruins, some parts have been restored. One of its towers still stands and it can be visited. Monica lives here.');")
    db.cur.execute("insert into location values ('bumoback','Monastery Backyard','1','The overgrown backyard of the Zlatna Livada monastery is filled with the joyful screams of some children playing with a ball.');")
    db.cur.execute("insert into location values ('bumonast','Zlatna livada Monastery','1','This is the oldest monastery in Europe out in the middle of nowhere. It seems abandoned, but a few children can be seen playing in the backyard.');")
    db.cur.execute("insert into location values ('bumuseum','Archeological Museum','1','This museum exhibits the history of Nessebar since Thracian times.');")
    db.cur.execute("insert into location values ('bunesse','Nessebar','1','This small historical town of only thirty square kilometers is renowned for its untouched atmosphere: indeed, you will not see many tourists here.');")
    db.cur.execute("insert into location values ('grbay','Melville Bay','0','The water is a pleasant deep blue but you shiver at the thought of swimming in it. The wide open bay area offers no protection from the biting wind. You notice a sailboat in the distance towards the north along with some houses on the shore. You wonder about the name of the village.');")
    db.cur.execute("insert into location values ('grcralak','Crater Lake','1','The lake is a nearly perfect circle with dark and murky water that makes it difficult to judge its depth. The strangely warm water does not freeze during the dead of winter. It is surrounded by a forest. The large clearing around the lake is void of snow, probably due to the heat radiating from the body of water.');")
    db.cur.execute("insert into location values ('gredgecr','Edge of the Crater','1','You see an eroded depression in front of you, overgrown with a forest. The crater is just barely deep enough that you can''t see the top of the trees from beyond the edge. A small river trickles down from the edge to a lake at the bottom.');")
    db.cur.execute("insert into location values ('grfore','East Crater Forest','1','Some parts of the forest are dense making it difficult to move but you can see some clearings here and there. The snow on the trees gives them a candy-like look but the ground has stayed almost entirely clear of snow, even in the clearings.');")
    db.cur.execute("insert into location values ('grforn','North Crater Forest','1','The forest really thickens up here and moving takes quite a bit of effort. The snow on the trees gives them a candy-like look but the ground has stayed almost entirely clear of snow, even in the clearings. At least the birds sing their pretty little songs in the trees.');")
    db.cur.execute("insert into location values ('grforne','North-East Crater Forest','1','The forest isn''t very dense around these parts but strangely the ground is still mostly clear of snow.');")
    db.cur.execute("insert into location values ('grfornw','North-West Crater Forest','1','The forest isn''t very dense here so you catch a glimpse of a family of foxes walking around to the south. The snow on the trees gives them a candy-like look but the ground has stayed almost entirely clear of snow, even in the clearings.');")
    db.cur.execute("insert into location values ('grfors','South Crater Forest','1','The ground lacks the plentiful snow cover the few trees that are in the area have. You spot a white creature speeding past from the corner of your eye.');")
    db.cur.execute("insert into location values ('grforse','South-East Crater Forest','1','The forest really thickens up here and moving takes quite a bit of effort. The snow on the trees gives them a candy-like look but the ground has stayed almost entirely clear of snow, even in the clearings. At least the birds sing their pretty little songs in the trees.');")
    db.cur.execute("insert into location values ('grforsw','South-West Crater Forest','1','The snow on the trees gives them a candy-like look but the ground has stayed almost entirely clear of snow, even in the clearings.');")
    db.cur.execute("insert into location values ('grforw','West Crater Forest','1','The forest really thickens up here and moving takes quite a bit of effort. The snow on the trees gives them a candy-like look but the ground has stayed almost entirely clear of snow, even in the clearings. At least the birds sing their pretty little songs in the trees.');")
    db.cur.execute("insert into location values ('grinn1','Jakobshavn Inn','1','The smoky air stings as you breath in but warmth from the large fireplace quickly wraps around you making up for the smell. The inn isn''t exactly packed but taking into account the amount of people you''ve seen so far, nearly a fourth of the town must be here. A hushed buzz of conversation surrounds you along with the jingling of glasses and scraping of wood. Several people glance at you as you enter but don''t pay much attention, they''re probably used to the occasional merchant passing through. You make your way through the maze of tables to the counter where the innkeeper is talking with a patron.');")
    db.cur.execute("insert into location values ('grinn2','Jakobshavn Inn','1','The room is certainly warmer than outside but the lack of people in the room allow the warmth of the fire to quickly escape through the cracks. Cold is radiating from smooth but dirty stone floor. You see a lone patron drinking in the corner on the other side of a sea of tables. A few empty mugs are huddled together on one of the tables');")
    db.cur.execute("insert into location values ('grinnroo','Room','0','The little room is cozy, with a small night table with two drawers and a clean bed. You suppose it''s enough for the occasional traveler but a simple window could have been nice. Perhaps the innkeeper thinks the painting of the Jakobshavn port on the wall is an adequate replacement?');")
    db.cur.execute("insert into location values ('grjakob','Jakobshavn','1','The town is settled near the shore as the snow covered ground begins to rise steeply behind the furthest buildings. There is a single tall spiky rock standing on a smooth hill overlooking the town. The brightly colored wooden houses stand out in the snow like snow-capped flowers. The loosely defined streets are distinctly empty apart from a couple of people going about their day.');")
    db.cur.execute("insert into location values ('grjensho','Jens'' Home','0','The living room of the private collector is fairly well furnished with artefacts ranging from expensive looking mats to ancient paintings. An unexpected sight in a rural town like Jakobshavn. There are several old weapons, jewelry items, and utensils spread about the room, some under dusty glass boxes. He even has a somewhat rotten plank hung on one wall. Being familiar with private collectors Jens doesn''t appear to break the mold.');")
    db.cur.execute("insert into location values ('grlair1','Outside Shaman''s Lair','0','The nondescript bump in the ground that looks like any other mound. There is a small hole on the side, but it is hardly visible, even when you are staring right at it. There is a good chance you would never find it unless you were specifically looking for it.');")
    db.cur.execute("insert into location values ('grlair2','Shaman''s Lair','1','The large, cave-like structure is well hidden from the outside world. The walls have strange symbols carved into them and the pillar-like structures suggest the cave is not of natural origin.');")
    db.cur.execute("insert into location values ('grmaster','Port Master''s Building','1','The port master supervises her port from the warmth of her tiny office most days. The room is much smaller than it looks from the outside due to the copious number of drawers covering the walls. There is an old leather and brass diving suit on display in one corner. The stacks of papers on her desk are just about to fall over making you wonder how it''s possible a tiny port like this would require so much management and paperwork.');")
    db.cur.execute("insert into location values ('grport','Port of Jakobshavn','0','The small and quiet little port is located on the coast of Disko Bay. The water is strikingly cyan in color. Several sheets of thick ice float in the still bay. You can see an island to the west. A loose group of wooden houses and shacks populate the general area around the three wharves. Some buildings'' smoke stacks puff light smoke in the air. You see a fisherman gutting cod outside his shack and another fixing a hole in his net. There is a row of hides drying in a long canopy with several bulging leather sacks piled up at one end. A cold breeze catches you off guard, you shiver and pull up your collar more.');")
    db.cur.execute("insert into location values ('grpost','Jakobshavn Post Office','1','The first thing you notice as you enter the building is the slightly musty smell of the room and the moist air which makes you wonder why they haven''t insulated the room well enough since they handle so much paper. It is staggering how much post a little town like Jakobshavn can receive judging by the size of the room. One of the walls is covered with boxes stacked from floor to the ceiling with various markings on the side, probably describing the contents. There is simply no way all the boxes contain mere letters as there is a shelf with dozens of small boxes on another wall, some of which have letters and other documents in them. You walk towards a large messy table in the center of the room and notice two leather bags on a chair behind the table, once of which is open and filled with letters confirming your suspicions. The post office worker at the table looks at you inquiringly.');")
    db.cur.execute("insert into location values ('grship','Underwater Viking Ship','0','The sunken ship is that of the viking Kolbiorn. Rumours say the ghosts of the crew are still aboard.');")
    db.cur.execute("insert into location values ('grstore','General Store','1','The amount of various tools hung on the walls give an appearance of a more hunting oriented store but surprisingly enough they sell food as well. You don''t particularly like the appearance of the vegetables on one stand but you suppose they can''t do much better than that with the climate here.');")
    db.cur.execute("insert into location values ('inairpor','Bagdogra Airport','0','The airport has only one landing strip and one building. The gray building is not exactly a masterpiece of architecture.');")
    db.cur.execute("insert into location values ('inbussta','Bagdogra Bus Station','1','Bagdogra is located in the northeast of India, near the Nepalese border. Bagdogra has an airport and a train station.');")
    db.cur.execute("insert into location values ('inpost','Bagdogra Post Office','1','The Post office is located next to the train station because most of the mail comes to Bagdogra by train or by plane.');")
    db.cur.execute("insert into location values ('intrains','Bagdogra Train Station','1','The train station is located just north of the airport. It is a small building with only a few benches for the waiting passengers to sit on.');")
    db.cur.execute("insert into location values ('intrrest','Restaurant Carriage','1','The restaurant car has a small bar where the passengers can get their drinks and modest where they can dine.');")
    db.cur.execute("insert into location values ('intrro2','Room 2','1','This small room only has a bed and a table.');")
    db.cur.execute("insert into location values ('intrro7','Room 7','0','This small room only has a bed and a table.');")
    db.cur.execute("insert into location values ('intrsle1','Sleeping Carriage','1','The sleeping car has five small rooms for passengers. A narrow hallway goes through the car.');")
    db.cur.execute("insert into location values ('intrsle2','Sleeping Carriage II','1','The sleeping car has five small rooms for passengers. A narrow hallway goes through the car.');")
    db.cur.execute("insert into location values ('INV','INVENTORY','0','A WORKAROUND FOR ITEM/INVENTORY TABLE SEPARATION. THIS IS NOT TO BE USED AS A REAL LOCATION.');")
    db.cur.execute("insert into location values ('nehikesh','Hiking Supplies','1','The humble store sells hiking, fishing and hunting supplies.');")
    db.cur.execute("insert into location values ('nejaratr','Jarayotar Train Station','1','The unpretentious train station is the heart of the town.');")
    db.cur.execute("insert into location values ('nejaray','Jarayotar','1','Jarayotar is a popular stop for hikers traveling to the Himalayan mountain range.');")
    db.cur.execute("insert into location values ('netoti','Road to Tibet','1','This rural mountain road will take you to Tibet. There seems to be a small shack working as a bus station.');")
    db.cur.execute("insert into location values ('peairpor','Jorgé Chavez International Airport','0','This modern airport is covered in glass panes that reflect the sky''s blue color.');")
    db.cur.execute("insert into location values ('pearchiv','Archives','1','You have entered a very vast room with several long book shelves filled with ancient books and thesauruses.');")
    db.cur.execute("insert into location values ('pecave','Hidden Cave','0','The cave is very dark and vast. In the middle is an imposing altar.');")
    db.cur.execute("insert into location values ('pecave2','Hidden Cave','0','Like the cook said. It is absolutely pitch black here.');")
    db.cur.execute("insert into location values ('pecusco','Cusco','1','The center of Inca civilization has been home to all Inca emperors and the Sapa Inka before them.');")
    db.cur.execute("insert into location values ('peport','Port of Pisco','0','The space between the cranes and cargo boats is filled with small, colorful fishing barques.');")
    db.cur.execute("insert into location values ('pepost','Pisco Post Office','1','The post is located in an old colonial building, ten minutes by foot from the port. Oddly enough there is a black, dusty, telephone on the wall.');")
    db.cur.execute("insert into location values ('pevillag','Ayacucho','0','This city seems quite arid when seen from the air. It is located in a crowded valley with only a few green spots on the outskirts.');")
    db.cur.execute("insert into location values ('spairpor','Bilbao Airport','1','The Bilbao Airport is, you find, rather small but quite beautiful. It is easily accessible by bus from the central Plaza Moyua. The crisp white roof is inclined and rounded, which gives you the impression of being inside a vast seashell. You walk slowly towards the gates, taking in the exquisite architecture. Since the airport is quite calm, you are able to pass through the security check without fuss. The indications are clear, and finding the right gate poses no problems: you are now awaiting boarding.');")
    db.cur.execute("insert into location values ('sparchiv','Museum Archives','1','This just might be your favourite room in the museum. Books, books and more books. You inhale the air and feel welcomed by the smell of old paper and leather covers. The familiar scent invokes memories of long nights spent doing research at the university library. The archives are separated into three long columns of shelves, organised by date: B.C., 1-1000A.C. and 1001A.C-present.');")
    db.cur.execute("insert into location values ('spbilbao','Bilbao','1','This medium-sized city is half an hour from Sopelana beach. The Guggenheim and Bellas Artes museums are two of the main tourist attractions. The easiest way to travel within the city is by foot. Bilbao gives off a friendly, relaxed atmosphere: the river and numerous parks create a stress-relieving surrounding for city-dwellers.');")
    db.cur.execute("insert into location values ('spdiroff','Director''s Office','1','Gorka Ibaiguren''s office depicts his two passions clearly and leaves no room for doubt about his love of surf and art. While his desk is always well organised and professional, the walls reflect another side of his personality. The vigorous middle-aged man has attached a turquoise and yellow surfboard on the wall, right next to a large poster of Sopelana beach. On the other side of his bureau resides an even more substantial world map, with small photographs of artefacts pinned upon the locations they are from.');")
    db.cur.execute("insert into location values ('spintoff','Intern Office','1','You have now entered your small office. To your right is your working station, a rather small wooden desk with piles of archeology and history books. The rest of the room''s decor is sparse: the picturesque book shelf on the left contains no more than 30 volumes and all your archeology equipment is contained within a small box on the floor, next to the shelf. In an attempt to make the office more cosy, you have pinned a movie poster to the wall, between the shelf and the table. It used to read “Rocky Balboa”, but since you are a funny fellow, it now says “Rocky Bilbao.”');")
    db.cur.execute("insert into location values ('spmuseum','Museo de las Bellas Artes','1','This large museum was established in 1914 and has since accumulated an impressive range of artifacts (from Imperial Japan to modern Europe).');")
    db.cur.execute("insert into location values ('spport','Port of Bilbao','1','Industrial port near Sopelana beach.');")
    db.cur.execute("insert into location values ('sproom3','Storage Room 3','1','You are at the end of a fairly dark, dimly lit oblong room. The walls are covered in fragile 5th century Eastern European religious icons. The air is slightly cool and humid- just enough so to maintain the wooden icons from deteriorating. As you look around, you notice stands with glass boxes at the other end of the long space. Upon closer inspection, you discover they enclose ancient artefacts: a horse-shaped bronze medallion, a necklace made of dried-up grapes dipped in gold, several vases and a slightly curved iron dagger with a carved wooden handle.');")
    db.cur.execute("insert into location values ('stresste','Warp!','0','All locations filled!');")
    db.cur.execute("insert into location values ('taairpor','Tanga Airport','0','The airport is located just outside of Tanga and consists of only a few little buildings.');")
    db.cur.execute("insert into location values ('taarusha','Arusha','1','Arusha is a tiny village by the Lake Natron.');")
    db.cur.execute("insert into location values ('tachiefh','Chief''s Hut','1','The rather imposing mud hut presides over the whole village. ');")
    db.cur.execute("insert into location values ('tanatr1','Lake Natron I','1','The large lake, located in northern Tanzania, is known for its calcified animals and breeding flamingos.');")
    db.cur.execute("insert into location values ('tanatr2','Lake Natron II','1','There are several calcified animal bodies around: crow, bat and flamingo all stand side by side, petrified.');")
    db.cur.execute("insert into location values ('tanatr3','Lake Natron III','1','The shore turns towards the lake, creating a delicate, smooth cape.');")
    db.cur.execute("insert into location values ('taoutair','Outside of Tanga Airport','1','There are some buildings and people walking by. In front of you is an advertisement in English for a local guide, Neema.');")
    db.cur.execute("insert into location values ('taport','Port of Tanga','0','The harbour is located on the east coast of Tanzania, near the border with Kenya. The port is the heart of the city as most of the business goes through it.');")
    db.cur.execute("insert into location values ('tapost','Tanga Post Office','1','This post office handles all the letters that come from the boats and planes before mailing them forward.');")
    db.cur.execute("insert into location values ('tatanga','Tanga','1','Tanga is a demure city located on the east coast of Tanzania.');")
    db.cur.execute("insert into location values ('tichen','Chentangzhen','1','This simple, quiet village on the border of Nepal and Tibet does not take kindly to strangers. The river Pum Qu flows through the village.');")
    db.cur.execute("insert into location values ('timonyar','Monastery Yard','0','The open yard at the center of the monastery gives access to personal rooms all around.');")
    db.cur.execute("insert into location values ('timoplat','Mountain Plateau','1','You are standing on mostly level ground on the side of the mountain. Snow has accumulated here due to the low land relief.');")
    db.cur.execute("insert into location values ('timount','Snow Capped Mountain','1','This is only one of the many mountains in Tibet.');")
    db.cur.execute("insert into location values ('tioutmon','Outside Monastery','0','The nondescript, unmarked Buddhist monastery stands proudly at the top of a mountain.');")
    db.cur.execute("insert into location values ('tipath1','Mountain Path','1','The steep and rocky path undulates on the side of the mountain.');")
    db.cur.execute("insert into location values ('tipath2','Path up a Mountain','1','The steep and rocky path undulates on the side of the mountain.');")
    db.cur.execute("insert into location values ('tipumqu1','Pum Qu I','0','The calm river flows north from Chentangzen.');")
    db.cur.execute("insert into location values ('tipumqu2','Pum Qu II','1','The calm river flows north from Chentangzen.');")
    db.cur.execute("insert into location values ('tipumqu3','Pum Qu III','1','The calm river flows north from Chentangzen.');")
    db.cur.execute("insert into location values ('tisakpor','Sakya Monastery Porch','1','The front porch of the largest Buddhist monastery in Tibet is, to say the least, ancient. Some rocks have fallen from the roof down unto the stairs, yet there is no doubt the robust porch will remain in place for centuries to come.');")
    db.cur.execute("insert into location values ('tisakya','Sakya Monastery','0','The Buddhist monastery on the top of the mountain accomodates nearly a hundred monks.');")
    db.cur.execute("insert into location values ('tishore','Shore of Pum Qu','1','The sandy shore of the river Pum Qu, next to the village of Chentangzhen, has no vegetation. There''s a small boat on the beach.');")
    db.cur.execute("insert into location values ('titone','Road to Nepal','1','This rugged mountain road leads to Nepal.');")
    db.cur.execute("insert into location values ('titserom','Tsering''s Room','1','The room is humble, just like its inhabitant. There is only one chair, a thin but comfortable-looking mattress on the floor and an elementary chest.');")
  
    if g.debug:
        print("Inserting data into table: itemtype")
    
    #        ITEMTYPE
    
    db.cur.execute("insert into itemtype values ('altar','Altar','0','0','0','0','A large stone altar with ancient symbols carved in its sides. There seems to be a deep and thin vertical slit hidden among the symbols.');")
    db.cur.execute("insert into itemtype values ('antlers','Reindeer Antlers','0','0','0','60','Some use antlers for decoration, others as tools or fertilizer.');")
    db.cur.execute("insert into itemtype values ('archtool','Archeological Tools','0','0','0','0','A set of various tools used to examine artifacts in detail.');")
    db.cur.execute("insert into itemtype values ('awl','Awl','15','0','0','10','A metal spike with a wooden handle used for piercing holes in leather or even wood.');")
    db.cur.execute("insert into itemtype values ('axe','Axe','40','20','0','20','A regular axe suitable for many things like chopping down trees or hacking carcasses into more manageable chunks.');")
    db.cur.execute("insert into itemtype values ('backpack','Leather Backpack','0','0','0','150','A simple backpack made from seal leather. It is waterproof and allows the player to carry up to eight items.');")
    db.cur.execute("insert into itemtype values ('balbrand','Bálbrandr','999999','999999','999999','999999','The mythical sword of Hveðrungr. It grants immortality to the one who possesses it. In the hands of Hveðrungr the blade is said to be engulfed in flames.');")
    db.cur.execute("insert into itemtype values ('bookbilb','What to do in Bilbao: The Best Pintxos in Town','0','0','0','25','A booklet about the Basque capital''s culinary delicacies. Found in the intern''s room, on the book shelf.');")
    db.cur.execute("insert into itemtype values ('bookinca','Forgotten Pyramids of the Incas','0','0','0','50','A book about the Inca culture.');")
    db.cur.execute("insert into itemtype values ('bookviki','The Travels of Eiríkr hinn Rauði','0','0','0','50','A book describing the Viking expansion to Greenland in 986 by Erik the Red.');")
    db.cur.execute("insert into itemtype values ('budagger','Bulgarian Dagger','20','5','0','200','This ornate dagger has recently been acquired by the Bellas Artes Museum. It has curved, unclear carvings on the hilt.');")
    db.cur.execute("insert into itemtype values ('bullets','Bullets','0','0','0','10','These bullets are quite common so they can be bought from most general stores.');")
    db.cur.execute("insert into itemtype values ('club','Club','10','10','0','20','A wooden stick that is a somewhat larger at one end. Popular with hunters who do not wish to damage the pelts of the animals they kill.');")
    db.cur.execute("insert into itemtype values ('dicbulg','Bulgarian Dictionary','0','0','0','40','A Bulgarian - English - Bulgarian.');")
    db.cur.execute("insert into itemtype values ('dichindi','Hindi Dictionary','0','0','0','40','A Hindi - English - Hindi dictionary.');")
    db.cur.execute("insert into itemtype values ('dicnepal','Nepali Dictionary','0','0','0','40','A Nepali - English - Nepali dictionary.');")
    db.cur.execute("insert into itemtype values ('dicnorse','Old Norse Dictionary','0','0','0','40','An Old Norse - English dictionary that allows you to communicate in Old Norse.');")
    db.cur.execute("insert into itemtype values ('dicswahi','Swahili Dictionary','0','0','0','40','A Swahili - English - Swahili dictionary.');")
    db.cur.execute("insert into itemtype values ('divesuit','Diving Suit','0','0','0','500','A bulky leather suit with a heavy brass helmet used to dive into the depths of oceans.');")
    db.cur.execute("insert into itemtype values ('fishbait','Fish Bait','0','0','0','5','Cheap bait used when fishing with a rod.');")
    db.cur.execute("insert into itemtype values ('fishnet','Fishing Net','0','0','0','20','A medium sized fishing net suitable for manual fishing.');")
    db.cur.execute("insert into itemtype values ('fishrod','Fishing Rod','0','0','0','30','Not much more than a long stick with piece of string. At least it has a reel, albeit it looks rusty.');")
    db.cur.execute("insert into itemtype values ('fispear','Fishing Spear','35','30','0','50','Once a popular tool used in fishing has lost its usefulness with more practical modern fishing nets.');")
    db.cur.execute("insert into itemtype values ('fjorstei','Fjǫrsteinn','0','999999','0','2000','The gem gives the wearer extraordinary health and protection from all disease.');")
    db.cur.execute("insert into itemtype values ('flalight','Flashlight','0','0','0','45','A compact dynamo light that can easily be carried around.');")
    db.cur.execute("insert into itemtype values ('guthjorr','Guðhjǫrr','100','999999','0','9999999','It it said that the person who possesses it is invincible while holding it. It is a part of Hveðrungr''s mythical sword Bálbrandr but lacks the Fjǫrsteinn.');")
    db.cur.execute("insert into itemtype values ('gutknife','Gutting Knife','20','5','0','25','A specialized tool for gutting fish although a regular knife will do the job just fine.');")
    db.cur.execute("insert into itemtype values ('hikeboot','Hiking Boots','0','0','0','30','Sturdy looking brown boots with a thick rubber sole.');")
    db.cur.execute("insert into itemtype values ('kolbswor','Kolbiorn''s Sword','50','20','0','1000','The missing sword of the ghost of the viking Kolbiorn Vílgeirson. He wants it returned.');")
    db.cur.execute("insert into itemtype values ('linskin','Skin of Linnormr','0','0','0','0','Shed skin of a white lizard.');")
    db.cur.execute("insert into itemtype values ('martenit','Martenitsa','0','0','0','5','A red-and-white bracelet on the ground near Eleusa Monastery. These are traditionally handed out to friends on the 1st of March, to mark the start of spring. You might consider giving it to Monica.');")
    db.cur.execute("insert into itemtype values ('mead','Mead','0','0','30','15','Refreshing beer recovers some health.');")
    db.cur.execute("insert into itemtype values ('meat','Dried Meat','0','0','20','10','Not particularly tasty but it stays edible for a long time and provides some nutrition.');")
    db.cur.execute("insert into itemtype values ('necklace','Shaman''s Necklace','0','0','0','200','A necklace made by a strange shaman living in Greenland.');")
    db.cur.execute("insert into itemtype values ('pet','Calcified Vervet Monkey','0','0','0','0','Remains of a vervet monkey which have calcified in the salty water of Lake Natron. It once was the companion of one Zlatin Panayotov.');")
    db.cur.execute("insert into itemtype values ('revolver','Revolver','50','0','0','75','A fairly standard looking revolver.');")
    db.cur.execute("insert into itemtype values ('romvase','Romanian Vase','0','0','0','30','An ancient artifact from Romania.');")
    db.cur.execute("insert into itemtype values ('rope','Rope','0','0','0','20','A 20 meter spool of rope for general use as well as hiking.');")
    db.cur.execute("insert into itemtype values ('satchel','Leather Satchel','0','0','0','75','The player''s bag where he is able to store up to three items. ');")
    db.cur.execute("insert into itemtype values ('snoshoe','Snow Shoes','0','0','0','40','Snow shoes allow walking in deep snow if you want to keep your socks dry.');")
    db.cur.execute("insert into itemtype values ('socks','Socks','0','0','0','10','Cheap white socks with “Hiking Socks” written in the tag.');")
    db.cur.execute("insert into itemtype values ('swknife','Switch Knife','25','5','0','30','A popular tool used by hikers around the world. It has a short slightly curved blade that is turned inside the handle.');")
    db.cur.execute("insert into itemtype values ('tendon','Reindeer Tendon','0','0','0','10','A popular alternative to strings made from plant fibers.');")
    db.cur.execute("insert into itemtype values ('ticket','Train Ticket','0','0','0','60','A ticket for the train that travels between India and Nepal.');")
    db.cur.execute("insert into itemtype values ('viksword','Sword of Erik the Red','30','15','0','45','Sword once used by Erik the Red. A priceless Viking artifact.');")
    db.cur.execute("insert into itemtype values ('whetston','Whetstone','0','0','0','55','An essential tool for anyone regularly handles bladed tools.');")
    db.cur.execute("insert into itemtype values ('wolfpelt','Wolf Pelt','0','0','0','60','A tanned gray wolf skin with the fur still attached.');")
    db.cur.execute("insert into itemtype values ('wood','Firewood','0','0','0','10','Half a stere of firewood.');")
    db.cur.execute("insert into itemtype values ('zlatlett','Zlatin''s Letter','0','0','0','0','A letter hidden inside the Bulgarian Dagger, written in Old Norse to throw off unwanted readers.');")

    if g.debug:
        print("Inserting data into table: item")
    
    #        ITEM
    
    db.cur.execute("insert into item values ('altar','altar','pecave');")
    db.cur.execute("insert into item values ('antlers','antlers','INV');")
    db.cur.execute("insert into item values ('archtool','archtool','spintoff');")
    db.cur.execute("insert into item values ('awl','awl','INV');")
    db.cur.execute("insert into item values ('axe','axe','INV');")
    db.cur.execute("insert into item values ('backpack','backpack',\\N);")
    db.cur.execute("insert into item values ('balbrand','balbrand',\\N);")
    db.cur.execute("insert into item values ('bookbilb','bookbilb','spintoff');")
    db.cur.execute("insert into item values ('bookinca','bookinca','spintoff');")
    db.cur.execute("insert into item values ('budagger','budagger','sproom3');")
    db.cur.execute("insert into item values ('bullets','bullets','INV');")
    db.cur.execute("insert into item values ('club','club','INV');")
    db.cur.execute("insert into item values ('club2','club','grforn');")
    db.cur.execute("insert into item values ('dicbulg','dicbulg','buairpor');")
    db.cur.execute("insert into item values ('dichindi','dichindi',\\N);")
    db.cur.execute("insert into item values ('dicnepal','dicnepal',\\N);")
    db.cur.execute("insert into item values ('dicnorse','dicnorse','spintoff');")
    db.cur.execute("insert into item values ('dicswahi','dicswahi',\\N);")
    db.cur.execute("insert into item values ('divesuit','divesuit','INV');")
    db.cur.execute("insert into item values ('fishbait','fishbait','INV');")
    db.cur.execute("insert into item values ('fishnet','fishnet','INV');")
    db.cur.execute("insert into item values ('fishnet2','fishnet','INV');")
    db.cur.execute("insert into item values ('fishrod','fishrod','INV');")
    db.cur.execute("insert into item values ('fispear','fispear','INV');")
    db.cur.execute("insert into item values ('fjorstei','fjorstei','INV');")
    db.cur.execute("insert into item values ('flalight','flalight','spintoff');")
    db.cur.execute("insert into item values ('gnife2','gutknife','INV');")
    db.cur.execute("insert into item values ('guthjorr','guthjorr',\\N);")
    db.cur.execute("insert into item values ('gutknife','gutknife','INV');")
    db.cur.execute("insert into item values ('hikeboot','hikeboot','INV');")
    db.cur.execute("insert into item values ('kolbswor','kolbswor','INV');")
    db.cur.execute("insert into item values ('linskin','linskin',\\N);")
    db.cur.execute("insert into item values ('martenit','martenit',\\N);")
    db.cur.execute("insert into item values ('mead','mead','INV');")
    db.cur.execute("insert into item values ('mead2','mead','INV');")
    db.cur.execute("insert into item values ('mead3','mead','INV');")
    db.cur.execute("insert into item values ('meat','meat','INV');")
    db.cur.execute("insert into item values ('necklace','necklace','INV');")
    db.cur.execute("insert into item values ('pet','pet','INV');")
    db.cur.execute("insert into item values ('revolver','revolver','INV');")
    db.cur.execute("insert into item values ('romvase','romvase','sproom3');")
    db.cur.execute("insert into item values ('rope','rope','INV');")
    db.cur.execute("insert into item values ('satchel','satchel',\\N);")
    db.cur.execute("insert into item values ('snoshoe','snoshoe','INV');")
    db.cur.execute("insert into item values ('socks','socks','INV');")
    db.cur.execute("insert into item values ('swknife','swknife','bumoback');")
    db.cur.execute("insert into item values ('swknife2','swknife','INV');")
    db.cur.execute("insert into item values ('tendon','tendon','INV');")
    db.cur.execute("insert into item values ('tick1','ticket','INV');")
    db.cur.execute("insert into item values ('tick10','ticket',\\N);")
    db.cur.execute("insert into item values ('tick2','ticket','INV');")
    db.cur.execute("insert into item values ('tick3','ticket','INV');")
    db.cur.execute("insert into item values ('tick4','ticket',\\N);")
    db.cur.execute("insert into item values ('tick5','ticket',\\N);")
    db.cur.execute("insert into item values ('tick6','ticket',\\N);")
    db.cur.execute("insert into item values ('tick7','ticket',\\N);")
    db.cur.execute("insert into item values ('tick8','ticket',\\N);")
    db.cur.execute("insert into item values ('tick9','ticket',\\N);")
    db.cur.execute("insert into item values ('vikbok1','bookviki','spintoff');")
    db.cur.execute("insert into item values ('vikbok2','bookviki','INV');")
    db.cur.execute("insert into item values ('viksword','viksword','pecave');")
    db.cur.execute("insert into item values ('whetston','whetston','INV');")
    db.cur.execute("insert into item values ('wolfpelt','wolfpelt','INV');")
    db.cur.execute("insert into item values ('wood','wood','INV');")
    db.cur.execute("insert into item values ('zlatlett','zlatlett',\\N);")
  
    if g.debug:
        print("Inserting data into table: people")
    
    #        PEOPLE
    
    db.cur.execute("insert into people values ('bugeorgi','buairpor','Georgi Borisov','100','10','5','100','The jolly driver can take you from Burgas to Nessebar and back. He is a young boxing enthusiast that never lacks things to say.');")
    db.cur.execute("insert into people values ('bukids','bumoback','Group of Children','100','10','5','5','These loud, joyful youths love running around the backyard.');")
    db.cur.execute("insert into people values ('bumonica','bueleusa','Monica','100','10','5','30','Monica is an elderly woman that looks after the Eleusa Monastery, even though she is not paid to do so. She is very observant of everything going on in her neighborhood - she might provide you with interesting information.');")
    db.cur.execute("insert into people values ('grdead','grship','Skeleton','100','0','0','0','The remains are frail from old age.');")
    db.cur.execute("insert into people values ('grfisher','grport','Fisherman','100','10','5','5','The fisherman lives in Jakobshavn.');")
    db.cur.execute("insert into people values ('grinnkee','grinn1','Innkeeper','100','10','5','240','The innkeep runs one of the few accomodations in southern Greenland.');")
    db.cur.execute("insert into people values ('grjens','grjensho','Jens','100','10','5','4000','This private collector of viking artifacts living in Jakobshavn.');")
    db.cur.execute("insert into people values ('grkolbio',\\N,'Ghost of Kolbiorn Vílgeirson','150','10','50','0','The viking chief drowned with his crew when his ship sank.');")
    db.cur.execute("insert into people values ('grlinnor',\\N,'White Linnormr','20','20','5','0','You have just come face to face with a white two-legged lizard with nasty looking teeth and a long tail. It is not much larger than a small dog but it is surprisingly quick on its feet.');")
    db.cur.execute("insert into people values ('grlone','grinn1','Lone Patron','100','10','5','4000','The lone patron is a regular at the Jakobshavn Inn.');")
    db.cur.execute("insert into people values ('grportma','grmaster','Port Master','100','10','5','70','The port master keeps track of anything and everything that goes on in her port.');")
    db.cur.execute("insert into people values ('grpostw','grpost','Post Office Worker','100','10','5','30','The young boy runs the day-to-day operations in Jakobshavn''s only post office.');")
    db.cur.execute("insert into people values ('grsailor','grport','Sailor','100','10','5','500','The experienced sailor will take you to the world''s end, for a price.');")
    db.cur.execute("insert into people values ('grstore','grstore','General Store Worker','100','10','5','4600','The worker can provide you with various items which may or may not be useful on your travels.');")
    db.cur.execute("insert into people values ('grvillag','grjakob','Villager','100','10','5','10','You wonder if he''s mute- whatever you say to him, he remains unresponsive.');")
    db.cur.execute("insert into people values ('grvolur','grlair2','Vǫlur','100','10','5','0','Her flowing blonde hair fair skin contrast with the pitch black symbols painted on her face. Her glazed blue eyes make you uneasy. This young woman would look ordinary if not for the environment and her garb. She is dressed in what appears to be various animal skins decorated with strange symbols. Apart from the necklace made from animal bones and wood the shaman doesn''t have any jewelry. She appears to think of wolves as her children.');")
    db.cur.execute("insert into people values ('grwolf','grfornw','Tribal Wolf','200','30','15','0','The wolf is fairly large with light gray fur. It would look ordinary if not for the light blue markings on it''s side. \"Child\" is written on it''s fur in Old Norse.');")
    db.cur.execute("insert into people values ('grwolf2','grfornw','Tribal Wolf','200','30','15','0','The wolf is fairly large with light gray fur. It would look ordinary if not for the light blue markings on it''s side. \"Child\" is written on it''s fur in Old Norse.');")
    db.cur.execute("insert into people values ('inbusdri','inbussta','Abhijishya','100','10','5','100','The Nepalese bus driver never stops smiling.');")
    db.cur.execute("insert into people values ('inrob1','intrrest','Robber','100','0','0','120','The masked men are wearing all black.');")
    db.cur.execute("insert into people values ('inrob2','intrrest','Robber','100','0','0','120','The masked men are wearing all black.');")
    db.cur.execute("insert into people values ('inrob3','intrrest','Robber','100','0','0','120','The masked men are wearing all black.');")
    db.cur.execute("insert into people values ('inshopke','nehikesh','Shopkeeper','100','10','5','50','The large shopkeeper sells hiking equipment and various other items.');")
    db.cur.execute("insert into people values ('intimast','intrains','Ticket Master','100','0','0','120','The senior that sells train tickets speaks broken English.');")
    db.cur.execute("insert into people values ('nesherpa','nejaray','Gajadhar','100','10','5','50','The Sherpa is idly rocking on a chair in front of a house.');")
    db.cur.execute("insert into people values ('neyeti',\\N,'Yeti','150','20','30','0','Trouble staring you in the eyes- the fearsome, furry, man-like mountain creature towers over you.');")
    db.cur.execute("insert into people values ('pecook','pevillag','Cook','100','10','5','200','The street cook is grilling food that makes your mouth water.');")
    db.cur.execute("insert into people values ('peghost','pecave','Inca Ghost','30','5','50','0','The spirit of a powerful Inca shaman floats in front of you. He tore his soul out of his body to gain immortality.');")
    db.cur.execute("insert into people values ('peskele','pecave','Inca Skeleton Warrior','120','10','10','0','This warrior of the Inca people pledged to protect his civilisation''s treasures with his life.');")
    db.cur.execute("insert into people values ('pewayna',\\N,'Wayna','100','10','5','300','This Inca expert lives in Cuzco.');")
    db.cur.execute("insert into people values ('player','sproom3','Andrea Álvarez','100','10','5','10','You are a young archaeology student currently interning at Museo de la Bellas Artes.');")
    db.cur.execute("insert into people values ('spgorka','spdiroff','Gorka Ibaiguren','100','10','5','320','Gorka has been the director of the Bellas Artes museum for several years now.');")
    db.cur.execute("insert into people values ('tachief','tachiefh','Mwanza Chief','100','10','5','20','The chief has special knowledge of the surrounding area.');")
    db.cur.execute("insert into people values ('taneema','taoutair','Neema','100','10','5','200','This woman is an experienced guide familiar with the terrain in Tanzania. You should not try to travel the savannah on your own.');")
    db.cur.execute("insert into people values ('tapopo',\\N,'Popobawa','40','15','10','0','A large one-eyed bat creature.');")
    db.cur.execute("insert into people values ('tarhino','tanatr3','Emela-ntouka','250','40','30','0','This strange rhinoceros-like creature has a long and thick tail and particularly nasty looking set of teeth.');")
    db.cur.execute("insert into people values ('tifisher','tichen','Fisherman','100','10','5','20','The fisherman will take you up Pum Qu after a little negotiating.');")
    db.cur.execute("insert into people values ('timonk1','tisakpor','Monk','100','10','5','0','The Buddhist monk lives in the Sakya Monastery and leads a peaceful life.');")
    db.cur.execute("insert into people values ('timonk2','tioutmon','Monk','100','10','5','0','This monk is secluded from life- he lives with only a few other compatriotes in a small-scale monastery.');")
    db.cur.execute("insert into people values ('tiyeti','timoplat','Yeti','150','20','30','5','Trouble staring you in the eyes- the fearsome, furry, man-like mountain creature towers over you.');")
    db.cur.execute("insert into people values ('tizlatin','titserom','Zlatin Panayotov','100','10','5','100','The 142 year old Bulgarian adventurer lives in a secluded monastery, where he is known as Tsering. He possesses the mythical gem from the sword of the Norse god of fire, which has allowed him to live far longer than a normal human being.');")

    if g.debug:
        print("Inserting data into table: dialogue")
    
    #        DIALOGUE
    
    db.cur.execute("insert into dialogue values ('georgi1','bugeorgi','Eleusa Monastery','You walk to the cab and the driver opens the window. He looks at you from the front seat. His wide smile reveals a row of dark, stained teeth. \"To Eleusa Monastery? Right away.\" He turns the key in the ignition and the car coughs loudly. \"Did you know \"Eleusa\" comes from Byzantine Greek and means \"the Tender?\" It''s probably not that interesting to you though, I''ll concentrate on driving again.\" Georgi faces the road and the car jumps forward.');")
    db.cur.execute("insert into dialogue values ('georgi2','bugeorgi',\\N,'\"Hello to you, too. We''ll be there in no time.\"');")
    db.cur.execute("insert into dialogue values ('georgree','bugeorgi','Greet','\"Good day! Need a ride? It''s 10 a ride, you won''t find better prices anywhere else!\"');")
    db.cur.execute("insert into dialogue values ('mongreet','bumonica','Greet','\"Oh, dear me, dear me. I seem to have lost my bracelet somewhere.\"');")
    db.cur.execute("insert into dialogue values ('monica2','bumonica',\\N,'\"Zlatin Panayotov? Yes, I have known him. He was already an old man when I was a child. I would see him by the monastery steps every evening on my way home from our family shop. He would always nod, smile and wave calmly. Sometimes my mother would let me go play chess with him in Eleusa. He was an avid player, and I learned many tactics from him. About twenty years ago he disappeared. I''ve heard rumours that he went to Tibet to become a monk, but I don''t believe them- he was so old he could not possibly have managed to go so far.\"');")
    db.cur.execute("insert into dialogue values ('monica3','bumonica','Zlatin Panayotov','The elderly lady seems to become even smaller as she tightens the shawl around her shoulders. \"I don''t know you- please leave me alone.\"');")
    db.cur.execute("insert into dialogue values ('moniretu','bumonica',\\N,'The old woman smiles crookedly and her small, watery eyes twinkle in the sunlight. \"Oh, that is so very nice of you, thank you sweety. My name is Monica. You look lost, my child, can I help you?\"');")
    db.cur.execute("insert into dialogue values ('grdedgre','grdead','Greet','All of a sudden, you hear a low voice resonating inside your brass helmet. You see the what appears to be a white humanoid light source fading into view a few meters in front of you. \"Who goes there?\"');")
    db.cur.execute("insert into dialogue values ('grfish','grfisher','Vikings','\"Vikings? I dunno ''bout ''em. There''s that collector fella who might be able to help you though. That drunkard''s at the inn all the time.\"');")
    db.cur.execute("insert into dialogue values ('grfishgr','grfisher','Greet','\"Travelers ''round these part are always either merchants or here fo'' the crater. Like I said, not too far from here. Go on.\"');")
    db.cur.execute("insert into dialogue values ('inngreet','grinnkee','Greet','\"Good day young man. Here for a drink? Perhaps a roof over your head?\"');")
    db.cur.execute("insert into dialogue values ('innlone','grinnkee',\\N,'\"He''s here almost every night. Sticks to himself most of the time. Although he went home already, you might catch him tomorrow.\"');")
    db.cur.execute("insert into dialogue values ('innroom1','grinnkee',\\N,'\"We have a few vacant rooms. It''ll cost you a 20 to rent one for the night.\"');")
    db.cur.execute("insert into dialogue values ('innroom2','grinnkee',\\N,'\"Back again are we? 20 a night, if you please.\"');")
    db.cur.execute("insert into dialogue values ('jengreet','grjens','Greet','\"Hello again.\"');")
    db.cur.execute("insert into dialogue values ('jensalt','grjens',\\N,'\"Too... expensive for you?\" Jens smirks, \"Well... should you come across a Viking artifact of equal value I might exchange the sword for that.\" he says. \"Speaking of which... There have been rumors of strange goings-on at the crater amongst the villagers but then again they always have some fitting myth or story about that crater for every situation. It''s probably nothing but I personally wouldn''t risk my hide going there this time of year. Wolves are about.\"');")
    db.cur.execute("insert into dialogue values ('jensgive','grjens',\\N,'\"Incredible! Where did you find this? Here! Take the sword!\"');")
    db.cur.execute("insert into dialogue values ('jensty','grjens',\\N,'\"Thanks.\"');")
    db.cur.execute("insert into dialogue values ('jensword','grjens','Kolbiorn''s Sword','\"Kolbiorn''s Sword? Hmmm... Yes, I do believe I have the sword of that particular viking. Where did you hear about it? Oh! Are you interested in buying it? I might part with for the modest sum of 1200. How''s that sound? (Y/N)\"');")
    db.cur.execute("insert into dialogue values ('kolexch','grkolbio',\\N,'\"The story of the Guðhjǫrr is tied to one Hrosskell Hergeirsson. Being the fearless warrior he was, he set course for Vinland in the footprints Leifr Eiríksson bringing the Guðhjǫrr with him. This, however, did not attenuate his thirst for prestige. He had to continue. Conquer new lands. New people. He travelled south at a fast pace, crossing the massive tundras with no difficulty. In fact, facing the snow and extreme cold of Vinland was no feat for the unrelenting Viking. But he pushed further south than any Vikingr before. The journey became more arduous as the temperatures rose, since we are not accustomed to such warm climates. Some of his men decided to settle down. Some died. Some ran. Not letting this stop him, Hrosskell continued expanding further with only a small group of remaining men. This is all I have gathered. I know not what has become of him.\" He turns his back and fades away before you can ask any more questions.');")
    db.cur.execute("insert into dialogue values ('kolgreet','grkolbio','Greet','\"You wake me from my slumber for pointless drivel?\"');")
    db.cur.execute("insert into dialogue values ('kolrule','grkolbio','Guthhjörr','\"You wish to know of Guðhjǫrr?\" Kolbiorn roars, \"Oh perhaps I shall tell you what wish to know. But not for free, oh no. I require something in return for this information you seek. My sword... My precious sword has been stolen from me! How dare he! How dare that FILTHY PEASANT TOUCH MY PRECIOUS SWORD WITH HIS FILTHY PEASANT HANDS!\" he blows up. \"YOU!\" Kolbiorn yells pointing at you \"I DEMAND YOU BRING ME MY SWORD!\"');")
    db.cur.execute("insert into dialogue values ('kolthank','grkolbio',\\N,'\"You have my gratitude.\" echoes in your head.');")
    db.cur.execute("insert into dialogue values ('lonemor1','grlone',\\N,'\"I might be able to tell you some more if you have another drink with me.\" he says.');")
    db.cur.execute("insert into dialogue values ('lonemor2','grlone',\\N,'\"I think I know a bit more about vikings that might interest you.\"');")
    db.cur.execute("insert into dialogue values ('lonep1','grlone',\\N,'\"Ah, mead, the sweet elixir of my life.\" He takes another large gulp. \"Guðhjǫrr you say? That is a mythical sword that supposedly gives its beholder invincibility. It is an important part of Viking mythology.\" He finishes his mead in one gulp. \"Oh, look at that, I''m already out of something to drink...\"');")
    db.cur.execute("insert into dialogue values ('lonep2','grlone',\\N,'\"Much better, thank you.\" He drinks half of the mug at once. \"You have come to the right place if you want to learn about Vikings.\" He sips. \"Did you know there are a few renowned, mythical places around here? The sunken ship, for example.\" Another sip. \"It is said to be haunted by the crew members that drowned with it nearly a thousand years ago.\" The Lone Patron stops talking and looks at his empty glass with great sorrow in his eyes.');")
    db.cur.execute("insert into dialogue values ('lonep3','grlone',\\N,'He takes yet another sip. \"There we go. As I was saying, the sunken ship is haunted- according to the legend, of course. The captain Kolbiorn and his men spend eternity in their death trap, forever recounting old Norse stories. Whether you choose to believe in that is up to you. Now, if you will excuse me, the bar counter is calling me.\"');")
    db.cur.execute("insert into dialogue values ('lonesea1','grlone',\\N,'\"Excellent! Thank you! Please have a seat friend!\"');")
    db.cur.execute("insert into dialogue values ('lonesea2','grlone',\\N,'\"Thank you! Please have a seat friend!\"');")
    db.cur.execute("insert into dialogue values ('lonesea3','grlone',\\N,'\"Please have a seat friend!\"');")
    db.cur.execute("insert into dialogue values ('longreet','grlone','Greet','\"Mead?\"');")
    db.cur.execute("insert into dialogue values ('grmawork','grportma',\\N,'\"Did the suit still work? I hope you enjoyed diving, here''s your money back.\"');")
    db.cur.execute("insert into dialogue values ('pmgreet','grportma','Greet','\"What can I do for you?\"');")
    db.cur.execute("insert into dialogue values ('pmsuit','grportma','Diving Suit','She points at an old, rugged diving suit. The helm has several bumps and you wonder whether or not it is still waterproof. \"That thing? It was my father''s. He used to dive a lot when I was younger. I haven''t personally used it in years but it should stil be waterproof. Are you interested in diving? Not many people are but I could rent you the suit for a 500 but please return it and don''t damage it. It has sentimental value to me.\"');")
    db.cur.execute("insert into dialogue values ('grpostgr','grpostw','Greet','\"Yes, yes, welcome, what is it?\"');")
    db.cur.execute("insert into dialogue values ('grpostw','grpostw',\\N,'He silently points to the corner of the room.');")
    db.cur.execute("insert into dialogue values ('grsail1','grsailor','Greet','\"Hello, nice to see you.\"');")
    db.cur.execute("insert into dialogue values ('grsail2','grsailor',\\N,'\"Yes, I can take you to the bay area- for the small price of 70.\"');")
    db.cur.execute("insert into dialogue values ('grsail3','grsailor',\\N,'\"Right away, sir...\"');")
    db.cur.execute("insert into dialogue values ('grsailvi','grsailor','Artifacts','\"Ah. You''ll want that collector person who practically lives at the inn. He knows about all that ol'' stuff, not me.\"');")
    db.cur.execute("insert into dialogue values ('grstore','grstore','Greet','\"Welcome, welcome! Feel free to look around! We have many interesting items, from beef jerky to sharpest axes!\"');")
    db.cur.execute("insert into dialogue values ('volgre','grvolur','Greet','She stares at you with a stoic face.');")
    db.cur.execute("insert into dialogue values ('volneck','grvolur','Necklace','\"I require the shed skin of a two-legged snake whose scales are as pale as untouched snow. For that only, I will exhange my necklace for.\"');")
    db.cur.execute("insert into dialogue values ('inbusdri','inbusdri','Greet','\"20 per ride please. Very cheap!\"');")
    db.cur.execute("insert into dialogue values ('inticket','intimast','Tickets','\"80 one ticket. No ticket. No train. Want buy ticket?\"');")
    db.cur.execute("insert into dialogue values ('intickgr','intimast','Greet','\"Much welcome! Nice day yes? Want train? I sell ticket!\"');")
    db.cur.execute("insert into dialogue values ('intiwelc','intimast',\\N,'\"Welcome train!\" the Ticket Master says.');")
    db.cur.execute("insert into dialogue values ('neyetigr','neyeti','Greet','\"UUUURRRrrrr\"');")
    db.cur.execute("insert into dialogue values ('deusexma','pecook','Hidden Temples','\"Hidden temples? Hidden temples... Yeah, there might be one around here. Maybe. Not very popular with the tourists. Not like they''d know ''bout it. Or that there would be any tourists here. Ever. You are literally the first person I''ve seen around all day. This here place is dead. Dead I say. And to top it off you''re not the ol'' man from across the street, but a real tourist. In flesh and blood. Right there in fron'' o'' me. How on Earth did you EVER manage to get lost in this here lil'' village in the middle of exactly nowhere? Ah. Yes. Temples. Right abou'' that-a-way just a ways away but not too far. I think. Be sure to bring a flashlight tho''. It''s craaazy dark in there. Like pitch black. No light. Nil. Was there once. Or twice. It makes no sense tho'' since it''s not like the cave openin'' is that small. You should have plenny o'' light down there but naaah. Of cooourse not. That''d be too easy now wouldn''t i''. Bu'' hey atleast you can''t really miss it. It''s kinda obvious the way that gaping black maw just seems to suck up light like it''s nobody''s business. Weird, you know--\" you quietly sneak away while the cook still rambles on...');")
    db.cur.execute("insert into dialogue values ('pecook1','pecook','Greet','The cook looks up from the anticuchos, a grilled meat skewer regional speciality. \"Good afternoon!\" he says looking shocked.');")
    db.cur.execute("insert into dialogue values ('pecook2','pecook',\\N,'\"The stories say the temple is north-west from here, in a large clearing in the middle of the forest. No one has ever found it though. There is a clearing but no evidence of any infrastructures...\"');")
    db.cur.execute("insert into dialogue values ('peghspo','peghost','Greet','\"OooOOOooo I''m a spooky ghooOOooOOoost!\"');")
    db.cur.execute("insert into dialogue values ('waycall1','pewayna',\\N,'A friendly voice answers the phone after just three rings. \"Hi! I expected your call, Gorka contacted me earlier today. If you leave Pisco now, you''ll be in Cusco in four hours- I''ll be waiting for you there.\"');")
    db.cur.execute("insert into dialogue values ('waygre2','pewayna',\\N,'\"Find what you were looking for?\" she asks warmly.');")
    db.cur.execute("insert into dialogue values ('waygreet','pewayna','Greet','A surprisingly young woman waves at you from a distance. \"Hi!\" she yells. You are at a speaking distance from her in no time. \"Let''s go sit down and have some coffee while we talk.\" You follow her to a picturesque coffee shop at the end of the street and sit down at a table so small your knees cannot fit underneath it. You opt to sit sideways with your right elbow on the table. Wayna follows your lead. \"So, what exactly brings you here?\"');")
    db.cur.execute("insert into dialogue values ('waymyth','pewayna',\\N,'Wayna grins. \"Why yes, I do know a little something about Vikings in South America. The legends talk of a hidden temple somewhere near the old city of Ayacucho. It is made of large stone blocks with dozens of little suns carved into each rock. The altar in the middle of the temple is also carved with Inca symbols that depict the myth of Nina Khillaychuki, Manco Cápac''s firesword. Strange, is it not, that the myth describes the temple with such detail, yet no one has been able to find it.\"');")
    db.cur.execute("insert into dialogue values ('self','player','Greet','I have better things to do than talk to myself at the moment.');")
    db.cur.execute("insert into dialogue values ('gorcall','spgorka',\\N,'\"In Peru? Goodness, how an Earth did you end up there? -- Vikings in South America? Interesting... You might want to do some research on the subject. I know a renowned historian who might help you out. Her name is Wayna. You should call her as soon as you can to set up a meeting in Cusco.\"');")
    db.cur.execute("insert into dialogue values ('gorcall1','spgorka',\\N,'\"Hi, good to hear from you. Did you find Mr. Panayotov?\"');")
    db.cur.execute("insert into dialogue values ('gorcall2','spgorka',\\N,'\"That''s alright, you will just have to follow the lead and travel to Tibet. I will send you some more money. Take care and call me if you need help. Until next time.\"');")
    db.cur.execute("insert into dialogue values ('gorgreet','spgorka','Greet','Gorka looks up at you from his papers and smiles. \"Hello, any progress with the dagger?\"');")
    db.cur.execute("insert into dialogue values ('gorgre2','spgorka',\\N,'\"Have you found Mr. Panayotov yet?\"');")
    db.cur.execute("insert into dialogue values ('gorhelp','spgorka','Bulgarian Dagger','\"Have you thoroughly inspected the dagger with your tools?\" (Y/N)');")
    db.cur.execute("insert into dialogue values ('gorhh2','spgorka',\\N,'\"Ugh, you know this. You need to be more careful with these artifacts!\" Gorka inspects the gap between the pommel and handle. \"Hold on. This isn''t damaged. The pommel has - is a screw.\" He screws open the handle.');")
    db.cur.execute("insert into dialogue values ('gorhh3','spgorka',\\N,'\"Then what is this?\" he says while holding the dagger in front of your face, pointing at the small gap between the pommel and handle. \"How come you didn''t meantion this? It looks like the pommel might fall off if you not handled prope- wait a second. It''s a screw.\" He screws the handle open.');")
    db.cur.execute("insert into dialogue values ('grnodag','spgorka',\\N,'\"Then would you mind fetching the dagger? I''d like to take a closer look at it.\"');")
    db.cur.execute("insert into dialogue values ('gornotme','spgorka',\\N,'\"You are supposed to inspect this artifact. Not me.\"');")
    db.cur.execute("insert into dialogue values ('gorsigh','spgorka',\\N,'\"Then would you please go to your office and inspect the artifact, please.\" he sighs.');")
    db.cur.execute("insert into dialogue values ('gorhhold','spgorka',\\N,'\"Okay, did you find anything of interest? Let me see the dagger.\" Gorka takes the dagger from you. \"A fairly typical artifact of it''s time. I believe we might have ano- but hold on. What is this?\" He points at the pommel. \"Did you damage the dagger?\" (Y/N)');")
    db.cur.execute("insert into dialogue values ('gorlet2','spgorka',\\N,'Gorka''s face lights up and he looks at you with an astonished expression. \"How exciting! You have to go find Mr. Panayotov and ask him to lend us the gem so we can inspect it. This is an invaluable opportunity to learn about Viking history and, who knows, maybe even the presence of supernatural beings! The museum will finance your travels. Here''s 4125 money!\"');")
    db.cur.execute("insert into dialogue values ('gorsupr','spgorka',\\N,'The director is surprised and raises his dark eyebrows. \"You found that inside the Bulgarian Dagger? Fascinating! Let me inspect it more closely.\"');")
    db.cur.execute("insert into dialogue values ('gorwoah','spgorka',\\N,'\"Have you read this? This is incredible:\"');")
    db.cur.execute("insert into dialogue values ('gorfjo','spgorka',\\N,'\"Incredible! Magnificent! This gem is indeed most beautiful! It will be a fine addition to our collection! Just look at it! Look how it glows! Everyone must know about this! I will arrange for a reporter to come over as soon as possible. Everyone must hear of your travels. It had to very exciting was it not? And more publicity for us! Think of the tourists! The locals! The museum will be talk of the town for weeks! Maybe even months! Oh you need a raise right this instant, but first if you''ll excuse me I need to make a few phone calls to paper, few colleagues... Did you happen to find anything else on your travels? (Y/N)\"');")
    db.cur.execute("insert into dialogue values ('gorrep','spgorka',\\N,'\"Oh my! What a fine Viking sword you have there. But did you not go on your adventure to find a gem of some sort? Did you not find Mr. Panayotov? It matters not. More artifacts, the better. I''ll give you the honors of inspecting the weapon and categorizing it, off you go. Lot''s of work to do! Unless you found more artifacts? In which case you would even more work! (Y/N)\"');")
    db.cur.execute("insert into dialogue values ('gorgut','spgorka',\\N,'\"What an incredible sword! It appears to be of Viking origin is it not? How is it so well preserved? It seems like it was forged yesterday. Where did you find this? Peru?! Viking artifacts in South America are very rare. Hmmm... Were there any more artifacts where you found this? Should we start excavating there? This could be expensive, but South American Viking artifacts... Such publicity... All the newspapers... My colleagues... Speaking of which, what of Mr. Panayotov and the gem? Did you find any other artifacts on your travels?\" (Y/N)');")
    db.cur.execute("insert into dialogue values ('gornec','spgorka',\\N,'\"Interesting. Such a well preserved necklace. You found it in Greenland? Impressive, you must have been traveling the world a lot to end up there. Did you find anything else on your travels?\" (Y/N)');")
    db.cur.execute("insert into dialogue values ('gormore','spgorka',\\N,'\"Ooh! How exciting! Show me!\"');")
    db.cur.execute("insert into dialogue values ('gordone','spgorka',\\N,'\"Did you find any other artifacts?\" (Y/N)');")
    db.cur.execute("insert into dialogue values ('chief1','tachief','Zlatin Panayotov','\"Zlatin? Zlatin! That idiot! He awoke the lake monster!\"');")
    db.cur.execute("insert into dialogue values ('chief2','tachief',\\N,'\"Emela-ntouka is dead? You are most brave! Thank you! Hrrmmhh... Did Zlatin send you? Should have known it. Why else would strangers be coming here. Of course it had to be that damned Bulgarian! I know what you want. Take his blasted pet. It''s ugly anyways.\"');")
    db.cur.execute("insert into dialogue values ('chiefgre','tachief','Greet','\"Who are you? What do you want?\"');")
    db.cur.execute("insert into dialogue values ('neema','taneema','Lake Natron','\"I can show you the way, I''m familiar with the surroundings.\"');")
    db.cur.execute("insert into dialogue values ('neema1','taneema',\\N,'\"Airport? Follow me.\"');")
    db.cur.execute("insert into dialogue values ('neemagre','taneema','Greet','\"Hello hello! I am a tourist guide! Are interested in traveling the wilds? I can help you! I know these lands very well indeed.\"');")
    db.cur.execute("insert into dialogue values ('tapopogr','tapopo','Greet','\"popo poPO BAAWAAAA!\"');")
    db.cur.execute("insert into dialogue values ('fisher1','tifisher','Boat','\"No use boat. Can''t fish. Net broken. Go away. I busy.\"');")
    db.cur.execute("insert into dialogue values ('tifithan','tifisher',\\N,'\"Good many thanks. Need help? I have boat.\"');")
    db.cur.execute("insert into dialogue values ('sakymogr','timonk1','Greet','The monk smiles warmly and nods.');")
    db.cur.execute("insert into dialogue values ('sakymonk','timonk1',\\N,'\"Zlatin? Panayotov? I do not recall hearing of a monk going by that name I''m afraid. Bulgarian you say? We certainly do not have many foreigners here and none of them are from Bulgaria. Sorry, the person must be in another monastery.\"');")
    db.cur.execute("insert into dialogue values ('monk1','timonk2','Greet','The monk walks towards you at a calm, steady pace. \"Help?\" He smiles warmly.');")
    db.cur.execute("insert into dialogue values ('monk2','timonk2','Zlatin Panayotov','The man nods. \"An old Bulgarian monk? Ah, I believe you are looking for Tsering. He''s in his room at the moment. Go on inside.\"');")
    db.cur.execute("insert into dialogue values ('tiyetigr','tiyeti','Greet','\"HHRRRRRRRR\"');")
    db.cur.execute("insert into dialogue values ('zlagem','tizlatin','Fjörsteinn','Zlatin''s hand moves with surprising swiftness as he takes the gem out of his pocket. \"The Fjǫrsteinn. The very same gem spoken of in the myths of the Vikings.\" He holds up the small emerald stone in front of your eyes. \"Quite beautiful, is it not?\" His eyes reflect the rock''s faint green light and, for a moment, you are reminded of your childhood neighbour''s green-eyed cat. \"I found this in Greenland nearly a century years ago. At the time, I was travelling the north, looking for Viking artefacts. One time in Norway I came across an interesting myth that described a powerful sword that belonged to Hveðrungr, nowadays more commonly known as Loki. Have you heard about this?\" (Y/N)');")
    db.cur.execute("insert into dialogue values ('zlagreet','tizlatin','Greet','The old man regards you with an enigmatic smile. ''I expected this to happen eventually.'' He waves you towards the only chair in the room. ''So, you are here for the gem, are you not?''');")
    db.cur.execute("insert into dialogue values ('zlamyth','tizlatin',\\N,'\"Good. Now, as you know, the gem was never found- not until I did, anyway. The sword, on the other hand, was found, but it disappeared from Norse mythology around 1020. Well, I happen to know the second part of the story. Guðhjǫrr reappeared as the weapon of a previously unknown viking called Hrosskell Hergeirsson nearly 150 years later. Some say Leifr made sure he was buried with the sword, and no one dared disgrace his grave - until Hrosskell came along. The fabled viking was ruthless and unscrupulous. Even though Vikings were viewed as bloodthirsty and barbaric, he stood out from his kind. The man knew no limits to his quest for glory and power. He had to own the sword, had to have the most beautiful wives, had to go where no man had ever been before.\" The old man stops to take a sip of water.\n\"Not many are aware of this turn of events. I could have sought the blade, but I did not. Immortality comes with a price. It would have turned me into a monstruosity over the years- a human figure void of humanity. I was content with the long, calm life the Fjǫrsteinn would provide me with, so I came here, to the solitude of these mountains. Now I have lived for 142 years and I feel ready to pass the gem on. Should I find a suitable person to pass it on.\"');")
    db.cur.execute("insert into dialogue values ('zlanmyth','tizlatin',\\N,'\"You haven''t? Fortunately, I still have a copy of the book, so you can read about it for yourself.\" He hands you a large brown leather-bound volume.');")
    db.cur.execute("insert into dialogue values ('zlapet','tizlatin',\\N,'Zlatin examines you attentively. \"You seem to be a wise youngster. I will give you the stone but I would like to ask you for something in return- consider this my dying wish, if you will. On one of my trips, to Tanzania this time, I lost a dear friend of mine. A small, fluffy vervet monkey. His name was Beast. I was traveling in the region around Lake Natron at the time. Oh how I wish to see him again...\"');")
    db.cur.execute("insert into dialogue values ('zlapet2','tizlatin',\\N,'The old man tears up as you give him the once so lively monkey. \"Thank you.\" Without another word, he hands you the gem.');")

    if g.debug:
        print("Inserting data into table: inventory")
    
    #        INVENTORY
    
    db.cur.execute("insert into inventory values ('inskinv','inshopke','fishnet','fishnet2','awl','fishbait','fispear','gutknife','rope','snoshoe','hikeboot','swknife');")
    db.cur.execute("insert into inventory values ('invbugeo','bugeorgi',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into inventory values ('invbukid','bukids',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into inventory values ('invbumon','bumonica',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into inventory values ('invgorka','spgorka',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into inventory values ('invgrfis','grfisher','gnife2',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into inventory values ('invgrinn','grinnkee','mead','mead2','mead3',\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into inventory values ('invgrjen','grjens','kolbswor',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into inventory values ('invgrkol','grkolbio',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into inventory values ('invgrlin','grlinnor',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into inventory values ('invgrlon','grlone',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into inventory values ('invgrpor','grportma','divesuit',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into inventory values ('invgrpos','grpostw',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into inventory values ('invgrsai','grsailor',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into inventory values ('invgrsto','grstore','axe','club','antlers','fishrod','swknife2','meat','tendon','wolfpelt','whetston',\\N);")
    db.cur.execute("insert into inventory values ('invgrvil','grvillag',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into inventory values ('invgrvol','grvolur','necklace',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into inventory values ('invgrwol','grwolf',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into inventory values ('invinbus','inbusdri',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into inventory values ('invneshe','nesherpa',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into inventory values ('invneyet','neyeti','wood',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into inventory values ('invpecoo','pecook',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into inventory values ('invpegho','peghost',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into inventory values ('invpeske','peskele',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into inventory values ('invpeway','pewayna',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into inventory values ('invtachi','tachief','pet',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into inventory values ('invtanee','taneema',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into inventory values ('invtapop','tapopo',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into inventory values ('invtarhi','tarhino',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into inventory values ('invtifis','tifisher',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into inventory values ('invtimo1','timonk1',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into inventory values ('invtimo2','timonk2',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into inventory values ('invtiyet','tiyeti','socks',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into inventory values ('invtizla','tizlatin','fjorstei','vikbok2',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into inventory values ('plinv','player','bullets','revolver',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into inventory values ('tickinv','intimast','tick1',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    
    if g.debug:
        print("Inserting data into table: world")
    
    #        WORLD
    
    db.cur.execute("insert into world values ('buairpor',\\N,\\N,'bumonast',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,'inairpor','peairpor','taairpor','spairpor',\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into world values ('buburgas',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into world values ('bueleusa',\\N,\\N,\\N,\\N,'bumuseum',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into world values ('bumonast',\\N,\\N,\\N,\\N,'bumoback',\\N,'buairpor',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into world values ('bumuseum','bueleusa',\\N,\\N,\\N,\\N,\\N,'bunesse',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into world values ('bumoback','bumonast',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into world values ('bunesse',\\N,\\N,'bumuseum',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into world values ('grbay',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,'grship',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into world values ('grcralak','grforn','grforne','grfore','grforse','grfors','grforsw','grforw','grfornw',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into world values ('gredgecr',\\N,\\N,'grforw',\\N,\\N,\\N,\\N,\\N,\\N,\\N,'grlair1','grjakob',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into world values ('grfore','grforne',\\N,\\N,\\N,'grforse','grfors','grcralak','grforn',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into world values ('grforn',\\N,\\N,'grforne','grfore','grcralak','grforw','grfornw',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into world values ('grforne',\\N,\\N,\\N,\\N,'grfore','grcralak','grforn',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into world values ('grfornw',\\N,\\N,'grforn','grcralak','grforw',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into world values ('grfors','grcralak','grfore','grforse',\\N,\\N,\\N,'grforsw','grforw',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into world values ('grforse','grfore',\\N,\\N,\\N,\\N,\\N,'grfors','grcralak',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into world values ('grforsw','grforw','grcralak','grfors',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into world values ('grforw','grfornw','grforn','grcralak','grfors','grforsw',\\N,'gredgecr',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into world values ('grinn1','grjakob',\\N,\\N,\\N,\\N,\\N,\\N,\\N,'grinnroo',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into world values ('grinnroo',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,'grinn1',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into world values ('grjakob','grstore',\\N,'grjensho',\\N,'grinn1',\\N,'grport',\\N,\\N,\\N,'gredgecr',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into world values ('grjensho',\\N,\\N,\\N,\\N,\\N,'grinn1','grjakob',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into world values ('grlair1',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,'grlair2','gredgecr',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into world values ('grlair2',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,'grlair1',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into world values ('grmaster','grport',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into world values ('grport','grpost',\\N,'grjakob',\\N,'grmaster',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,'spport','peport','taport',\\N,\\N);")
    db.cur.execute("insert into world values ('grpost',\\N,\\N,\\N,\\N,'grport',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into world values ('grship',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,'grbay',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into world values ('grstore',\\N,\\N,\\N,\\N,'grjakob',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into world values ('inairpor','intrains',\\N,'inpost',\\N,\\N,\\N,'inbussta',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,'buairpor','peairpor','taairpor','spairpor',\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into world values ('inbussta',\\N,\\N,'inairpor',\\N,\\N,\\N,\\N,\\N,\\N,\\N,'netoti',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into world values ('inpost',\\N,\\N,\\N,\\N,\\N,\\N,'inairpor',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into world values ('intrains',\\N,\\N,\\N,\\N,'inairpor',\\N,\\N,\\N,\\N,\\N,'intrro7',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into world values ('intrrest',\\N,\\N,\\N,\\N,'intrsle1',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into world values ('intrro2',\\N,\\N,'intrsle1',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into world values ('intrro7',\\N,\\N,'intrsle2',\\N,\\N,\\N,\\N,\\N,\\N,\\N,'intrains','nejaratr',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into world values ('intrsle1','intrrest',\\N,\\N,\\N,'intrsle2',\\N,'intrro2',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into world values ('intrsle2','intrsle1',\\N,\\N,\\N,\\N,\\N,'intrro7',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into world values ('nehikesh',\\N,\\N,\\N,\\N,\\N,\\N,'nejaray',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into world values ('nejaratr',\\N,\\N,'nejaray',\\N,\\N,\\N,\\N,\\N,\\N,\\N,'intrro7',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into world values ('nejaray','netoti',\\N,'nehikesh',\\N,\\N,\\N,'nejaratr',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into world values ('netoti','titone',\\N,\\N,\\N,'nejaray',\\N,\\N,\\N,\\N,\\N,'inbussta',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into world values ('peairpor','pecusco',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,'buairpor','taairpor','spairpor','inairpor',\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into world values ('pearchiv',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into world values ('pecave',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,'pevillag',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into world values ('pecusco','pevillag',\\N,\\N,\\N,'peairpor',\\N,'peport',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into world values ('peport','pepost',\\N,'pecusco',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,'grport','spport','taport',\\N,\\N);")
    db.cur.execute("insert into world values ('pepost',\\N,\\N,\\N,\\N,'peport',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into world values ('pevillag',\\N,\\N,\\N,\\N,'pecusco',\\N,\\N,\\N,\\N,\\N,'pecave','pecave2',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into world values ('spairpor',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,'spmuseum',\\N,\\N,\\N,\\N,'buairpor','inairpor','peairpor','taairpor',\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into world values ('sparchiv','spmuseum',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into world values ('spbilbao',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into world values ('spdiroff',\\N,\\N,'spintoff','spmuseum',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into world values ('spintoff',\\N,\\N,\\N,\\N,'spmuseum',\\N,'spdiroff',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into world values ('spmuseum','spintoff',\\N,\\N,'sproom3','sparchiv',\\N,\\N,'spdiroff',\\N,\\N,'spairpor','spport',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into world values ('spport',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,'spmuseum',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,'grport','peport','taport',\\N,\\N);")
    db.cur.execute("insert into world values ('sproom3',\\N,\\N,\\N,\\N,\\N,\\N,\\N,'spmuseum',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into world values ('taairpor','taoutair',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,'buairpor','inairpor','peairpor','spairpor',\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into world values ('taarusha',\\N,\\N,\\N,\\N,'tachiefh',\\N,'tanatr1',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into world values ('tachiefh','taarusha',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into world values ('tanatr1','tanatr2',\\N,'taarusha',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into world values ('tanatr2','tanatr3',\\N,\\N,\\N,'tanatr1',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into world values ('tanatr3',\\N,\\N,\\N,\\N,'tanatr2',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into world values ('taoutair','tapost',\\N,'taport',\\N,'taairpor',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into world values ('taport',\\N,\\N,\\N,\\N,\\N,\\N,'taoutair','tapost',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,'grport','peport','spport',\\N,\\N);")
    db.cur.execute("insert into world values ('tapost',\\N,\\N,\\N,'taport','taoutair',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into world values ('tatanga',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into world values ('tichen',\\N,\\N,'tishore',\\N,'titone',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into world values ('timonyar',\\N,\\N,'titserom',\\N,'tioutmon',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into world values ('timoplat',\\N,\\N,\\N,\\N,\\N,\\N,'timount',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into world values ('timount','tioutmon',\\N,'timoplat',\\N,'tipath1',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into world values ('tioutmon','timonyar',\\N,\\N,\\N,'timount',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into world values ('tipath1','timount',\\N,'tipumqu3',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into world values ('tipath2',\\N,\\N,'tisakpor',\\N,\\N,\\N,'tipumqu2',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into world values ('tipumqu1','tipumqu2',\\N,\\N,\\N,'tishore',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into world values ('tipumqu2','tipumqu3',\\N,'tipath2',\\N,'tipumqu1',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into world values ('tipumqu3',\\N,\\N,\\N,\\N,'tipumqu2',\\N,'tipath1',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into world values ('tisakpor','tisakya',\\N,\\N,\\N,\\N,\\N,'tipath2',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into world values ('tisakya',\\N,\\N,\\N,\\N,'tisakpor',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into world values ('tishore','tipumqu1',\\N,\\N,\\N,\\N,\\N,'tichen',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into world values ('titone','tichen',\\N,\\N,\\N,'netoti',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into world values ('titserom',\\N,\\N,\\N,\\N,\\N,\\N,'timonyar',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    db.cur.execute("insert into world values ('stresste','grforn','grforne','grfore','grforse','grfors','grforsw','grforw','grfornw','buairpor','inairpor','peairpor','spairpor','spmuseum','taoutair','tisakpor','timount','nejaratr','bumonast','grmaster','intrains','intrsle1','intrsle2','spdiroff','tapost','tipath2');")
    db.cur.execute("insert into world values ('pecave2',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,'pevillag',\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N);")
    
    if g.debug:
        print("Data insertion complete. Database functional.\n")
    
    print("Database created, please restart the game.")

def Database():
    
    print("Please wait. Creating database, this could take up to ten seconds.\n")
    
    if g.debug:
        print("Reinitializing database...")
    
    db.cur.execute("use TGTHB;")
    
    # Sigh, the order matters.
    db.cur.execute("drop table if exists world;")
    db.cur.execute("drop table if exists inventory;")
    db.cur.execute("drop table if exists dialogue;")
    db.cur.execute("drop table if exists people;")
    db.cur.execute("drop table if exists item;")
    db.cur.execute("drop table if exists itemtype;")
    db.cur.execute("drop table if exists location;")
    db.cur.execute("drop table if exists save;")
    db.cur.execute("drop table if exists text;")
    db.cur.execute("drop table if exists command;")
        
    if g.debug:
        print("Tables dropped.")
        print("Creating tables...")
    
    db.cur.execute("create table command (alias varchar(32) not null primary key,cmd varchar(32) not null,dsc varchar(4096) not null);")
    db.cur.execute("create table text (txtid varchar(8) not null primary key,txt varchar(4096) not null);")
    db.cur.execute("create table save (var varchar(128) not null primary key,val varchar(128) not null);")
    db.cur.execute("create table location (locid varchar(8) not null primary key,name varchar(64) not null,vis boolean not null,dsc varchar(4096));")
    db.cur.execute("create table itemtype (typeid varchar(8) not null primary key,name varchar(64) not null,att int not null,def int not null,hp int not null,val int not null,dsc varchar(4096));")
    db.cur.execute("create table item (itemid varchar(8) not null primary key,typeid varchar(8) not null,locid varchar(8),foreign key (locid) references location(locid));")
    db.cur.execute("create table people (charid varchar(8) not null primary key,locid varchar(8),name varchar(64) not null,hp int not null,att int not null,def int not null,val int not null,dsc varchar(4096),foreign key (locid) references location(locid));")
    db.cur.execute("create table dialogue (dlgid varchar(8) not null primary key,charid varchar(8) not null,topic varchar(32),txt varchar(4096) not null,foreign key (charid) references people(charid));")
    db.cur.execute("create table inventory (invid varchar(8) not null primary key,charid varchar(8),item1 varchar(8),item2 varchar(8),item3 varchar(8),item4 varchar(8),item5 varchar(8),item6 varchar(8),item7 varchar(8),item8 varchar(8),item9 varchar(8),item10 varchar(8),foreign key (charid) references people(charid),foreign key (item1) references item(itemid),foreign key (item2) references item(itemid),foreign key (item3) references item(itemid),foreign key (item4) references item(itemid),foreign key (item5) references item(itemid),foreign key (item6) references item(itemid),foreign key (item7) references item(itemid),foreign key (item8) references item(itemid),foreign key (item9) references item(itemid),foreign key (item10) references item(itemid));")
    db.cur.execute("create table world (fromid varchar(8) not null primary key,n varchar(8),ne varchar(8),e varchar(8),se varchar(8),s varchar(8),sw varchar(8),w varchar(8),nw varchar(8),up varchar(8),down varchar(8),spec1 varchar(8),spec2 varchar(8),spec3 varchar(8),spec4 varchar(8),spec5 varchar(8),air1 varchar(8),air2 varchar(8),air3 varchar(8),air4 varchar(8),air5 varchar(8),sea1 varchar(8),sea2 varchar(8),sea3 varchar(8),sea4 varchar(8),sea5 varchar(8),foreign key (fromid) references location(locid),foreign key (n) references location(locid),foreign key (ne) references location(locid),foreign key (e) references location(locid),foreign key (se) references location(locid),foreign key (s) references location(locid),foreign key (sw) references location(locid),foreign key (w) references location(locid),foreign key (nw) references location(locid),foreign key (up) references location(locid),foreign key (down) references location(locid),foreign key (spec1) references location(locid),foreign key (spec2) references location(locid),foreign key (spec3) references location(locid),foreign key (spec4) references location(locid),foreign key (spec5) references location(locid),foreign key (air1) references location(locid),foreign key (air2) references location(locid),foreign key (air3) references location(locid),foreign key (air4) references location(locid),foreign key (air5) references location(locid),foreign key (sea1) references location(locid),foreign key (sea2) references location(locid),foreign key (sea3) references location(locid),foreign key (sea4) references location(locid),foreign key (sea5) references location(locid));")
    
    if g.debug:
        print("Tables created.")
        print("Database initialized.")