zzz-pokedex.git
15 years agoCSV import now respects NULLability of columns.
Eevee [Mon, 9 Mar 2009 01:34:48 +0000 (21:34 -0400)] 
CSV import now respects NULLability of columns.

Empty strings loaded into NULL columns are changed to NULL instead.

15 years agoFixed some MySQL import problems.
Eevee [Sun, 8 Mar 2009 02:54:01 +0000 (18:54 -0800)] 
Fixed some MySQL import problems.

Tables weren't being defined as UTF-8 if that wasn't the server default.

A lot of tables were trying to create erroneous auto_increment columns.

Foreign key checks were pretty much fucking everything up.

15 years agoAdded SQLAlchemy to setup.py and fixed a typo in .gitignore.
Eevee [Sun, 8 Mar 2009 00:26:57 +0000 (16:26 -0800)] 
Added SQLAlchemy to setup.py and fixed a typo in .gitignore.

15 years agoAdded Pokémon cries.
Eevee [Sat, 7 Mar 2009 04:54:32 +0000 (20:54 -0800)] 
Added Pokémon cries.

15 years agoAdded Diamond/Pearl Pokemon sprites.
Eevee [Sat, 7 Mar 2009 04:21:43 +0000 (20:21 -0800)] 
Added Diamond/Pearl Pokemon sprites.

15 years agoFixed some Platinum sprite naming.
Eevee [Sat, 7 Mar 2009 04:15:19 +0000 (20:15 -0800)] 
Fixed some Platinum sprite naming.

201-f.png had become female/201.png.

Deoxys forms were named after games, rather than stats.

15 years agoAdded habitat sprites. Renamed flavor to flavor_text.
Eevee [Sat, 7 Mar 2009 03:14:42 +0000 (19:14 -0800)] 
Added habitat sprites.  Renamed flavor to flavor_text.

pokemon_flavor_text.flavor -> pokemon_flavor_text.flavor_text

15 years agoMoved images/ to media/.
Eevee [Sat, 7 Mar 2009 01:15:24 +0000 (17:15 -0800)] 
Moved images/ to media/.

Since this directory will shortly contain cries, which are mp3s,
'images' didn't really seem fitting.

15 years agoAdded footprint images.
Eevee [Fri, 6 Mar 2009 05:37:25 +0000 (21:37 -0800)] 
Added footprint images.

15 years agoAdded body shape icons. Oops.
Eevee [Thu, 5 Mar 2009 03:36:09 +0000 (19:36 -0800)] 
Added body shape icons.  Oops.

15 years agoAdded Pokemon body shapes.
Eevee [Thu, 5 Mar 2009 03:29:43 +0000 (19:29 -0800)] 
Added Pokemon body shapes.

15 years agoAdded gender rate bars.
Eevee [Wed, 4 Mar 2009 02:19:48 +0000 (18:19 -0800)] 
Added gender rate bars.

Putting them in here because they strike me as generally useful.

15 years agoRound 1 of version icons!
Eevee [Wed, 4 Mar 2009 01:59:18 +0000 (17:59 -0800)] 
Round 1 of version icons!

15 years agoFew more relations, for egg groups and evo chains.
Eevee [Wed, 4 Mar 2009 01:58:27 +0000 (17:58 -0800)] 
Few more relations, for egg groups and evo chains.

15 years agoAdded region names to the generations table.
Eevee [Wed, 4 Mar 2009 01:58:10 +0000 (17:58 -0800)] 
Added region names to the generations table.

15 years agoAdded a generation_id column to the pokemon table.
Eevee [Mon, 2 Mar 2009 09:06:31 +0000 (01:06 -0800)] 
Added a generation_id column to the pokemon table.

15 years agoAdded sprite frames, used on Pokemon page headers.
Eevee [Mon, 2 Mar 2009 09:05:26 +0000 (01:05 -0800)] 
Added sprite frames, used on Pokemon page headers.

15 years agoAdded contest and type ingame sprites.
Eevee [Mon, 2 Mar 2009 03:49:23 +0000 (19:49 -0800)] 
Added contest and type ingame sprites.

15 years agoAdded more table relations, for spline-pokedex Pokemon page.
Eevee [Mon, 2 Mar 2009 03:40:02 +0000 (19:40 -0800)] 
Added more table relations, for spline-pokedex Pokemon page.

15 years agoAdded Sugimori art. Moves images into data/ folder.
Eevee [Sat, 28 Feb 2009 08:00:39 +0000 (00:00 -0800)] 
Added Sugimori art.  Moves images into data/ folder.

15 years agoFixed Pokemon female-sprite flags.
Eevee [Sat, 28 Feb 2009 02:42:12 +0000 (18:42 -0800)] 
Fixed Pokemon female-sprite flags.

Pokemon that have both a female front and back sprite in Gen IV didn't
import the flags at all.  Some goof on my part.

15 years agoAdded a whole bunch of foreign keys.
Eevee [Tue, 24 Feb 2009 07:31:35 +0000 (23:31 -0800)] 
Added a whole bunch of foreign keys.

15 years agoAdded Trozei sprites.
Eevee [Tue, 24 Feb 2009 02:21:15 +0000 (18:21 -0800)] 
Added Trozei sprites.

15 years agoReverted unnecessary changes to setup.py.
Eevee [Mon, 23 Feb 2009 07:46:25 +0000 (23:46 -0800)] 
Reverted unnecessary changes to setup.py.

15 years agoMoved CSV sources into pokedex/.
Eevee [Mon, 23 Feb 2009 07:44:40 +0000 (23:44 -0800)] 
Moved CSV sources into pokedex/.

This appears to be the only way to make data access in eggs actually
work, and is why the Platinum sprites are in pokedex/ too.

15 years agoAdded Platinum front sprites.
Eevee [Mon, 23 Feb 2009 07:43:33 +0000 (23:43 -0800)] 
Added Platinum front sprites.

15 years agoMade a data/csv directory for CSV sources.
Eevee [Sun, 15 Feb 2009 03:19:19 +0000 (19:19 -0800)] 
Made a data/csv directory for CSV sources.

15 years agoInitial commit, with much of the data imported.
Eevee [Thu, 5 Feb 2009 08:05:42 +0000 (00:05 -0800)] 
Initial commit, with much of the data imported.

Includes a wrapper script 'pokedex' that can, so far, read data from a
db and spit out CSVs or deploy CSVs to a db.