mecanism available
  referencial integrity, some sort of typed linked list
  function and procedure, simplify the code
  trigger, awesome callback event
  current_user, use dbms user system, already mmo from begining

thing to test
  ascii art
  user function like fleet un schemaverse
  view are supposely readonly


hint:
SQLcity,    city building and economic game
SQLspace    space travel game
SQLtrade    trade goods
SQLrailroad transport goods
SQLwar      like the tower defense/advance war concept
SQLmonster  fight between monster, pokemon like thing
SQLrpg      why not

idea:
  streets
    a simple street tree, from the first, hook many who will be recursively hooked
    building are hooked to street and provide commodity (residential, commercial, industrial)
            is pathfinding possible in sql?
    people need one house, one job, one service
            residential provide one house
            commercial provide 10 services and 1 job
            industrial provide 10 jobs
            some building may grow bigger if upgrated
            street hold 10 building
    mods
        crime and police
        fire and firefighter
        illness and hospital
        riot and education
  blafurtagen
    city with factory and population
    road that link city
    you are an army you can travel from city to city unless their is another army
    you can leave some unit in a city or in a road
    you can exploit city you are occupying