One of the concepts you may run into if you read into Python and its fans in great depth (and here I mean Python of the programming type rather than the Monty type) is that of “Guido’s Time Machine”, the…
(! - Generated; * - Mandatory; ? - Optional; & foreign key)
! ID - An identification number. (int)
* Title - Title of the game (Text-128 Unicode) (Unique to Campaign)
* ShortTitle - Short Title of the game for URLs. Autodefaulted from title (Text-64 Ascii)
& Campaign - A link to the parent campaign. (int)
0 - no campaign
* Description - Text description of the game. (medium unicode text)
& Owner - id of user who created - or otherwise owns - this game.
? World - Name of the world the universe/world is being played in (text-128, Unicode)
! Date_created (datetime)
! date_modified (datetime)
10 construction - game hasn't started yet
20 active - Game is in play
30 paused - Game is temporarily stopped
40 ended - Game is over.
10 - Only the owner can see the game
20 - Only the GMs can see the game
30 - Only the players can see the game
40 - Only logged in users can see the game
50 - anyone can see the game.
That’s an extract from today’s document. Going though this for every table gives me a good idea of where I’ve mucked up the data relationships, or put in circuler dependancies and maps fairly easily into SQL. Also it provides…
In the first part of a brand new series, I’m going to document the entire process of getting a web-app working. I’ve been promising a new version of PFd4 for a while now. I have also been meaning to learn…