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.
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.
Eevee [Sun, 8 Mar 2009 00:26:57 +0000 (16:26 -0800)]
Added SQLAlchemy to setup.py and fixed a typo in .gitignore.
Eevee [Sat, 7 Mar 2009 04:54:32 +0000 (20:54 -0800)]
Added Pokémon cries.
Eevee [Sat, 7 Mar 2009 04:21:43 +0000 (20:21 -0800)]
Added Diamond/Pearl Pokemon sprites.
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.
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
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.
Eevee [Fri, 6 Mar 2009 05:37:25 +0000 (21:37 -0800)]
Added footprint images.
Eevee [Thu, 5 Mar 2009 03:36:09 +0000 (19:36 -0800)]
Added body shape icons. Oops.
Eevee [Thu, 5 Mar 2009 03:29:43 +0000 (19:29 -0800)]
Added Pokemon body shapes.
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.
Eevee [Wed, 4 Mar 2009 01:59:18 +0000 (17:59 -0800)]
Round 1 of version icons!
Eevee [Wed, 4 Mar 2009 01:58:27 +0000 (17:58 -0800)]
Few more relations, for egg groups and evo chains.
Eevee [Wed, 4 Mar 2009 01:58:10 +0000 (17:58 -0800)]
Added region names to the generations table.
Eevee [Mon, 2 Mar 2009 09:06:31 +0000 (01:06 -0800)]
Added a generation_id column to the pokemon table.
Eevee [Mon, 2 Mar 2009 09:05:26 +0000 (01:05 -0800)]
Added sprite frames, used on Pokemon page headers.
Eevee [Mon, 2 Mar 2009 03:49:23 +0000 (19:49 -0800)]
Added contest and type ingame sprites.
Eevee [Mon, 2 Mar 2009 03:40:02 +0000 (19:40 -0800)]
Added more table relations, for spline-pokedex Pokemon page.
Eevee [Sat, 28 Feb 2009 08:00:39 +0000 (00:00 -0800)]
Added Sugimori art. Moves images into data/ folder.
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.
Eevee [Tue, 24 Feb 2009 07:31:35 +0000 (23:31 -0800)]
Added a whole bunch of foreign keys.
Eevee [Tue, 24 Feb 2009 02:21:15 +0000 (18:21 -0800)]
Added Trozei sprites.
Eevee [Mon, 23 Feb 2009 07:46:25 +0000 (23:46 -0800)]
Reverted unnecessary changes to setup.py.
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.
Eevee [Mon, 23 Feb 2009 07:43:33 +0000 (23:43 -0800)]
Added Platinum front sprites.
Eevee [Sun, 15 Feb 2009 03:19:19 +0000 (19:19 -0800)]
Made a data/csv directory for CSV sources.
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.