Changeset 48 for veekun/trunk/script/base.sql

Timestamp:

03/14/07 23:06:34 (3 years ago)

Author:

eevee

Message:

Split Pokemon abilities and breeding groups off into their own tables, and wrote a couple accessors to clean up the horrid hacks I was using before.
Also tweaked the dump script slightly and made a couple columns less.. wrong.

Files:

• veekun/trunk/script/base.sql (modified) (2 diffs)

veekun/trunk/script/base.sql

@@ -1 @@
--- MySQL dump 10.10
---
--- Host: localhost    Database: pokedex
--- ------------------------------------------------------
--- Server version       5.0.27-community-nt
-
 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
@@ -59 +53 @@
   threadct int(10) unsigned NOT NULL default '0',
   postct int(10) unsigned NOT NULL default '0',
-  flags set('locked','readonly','header') NOT NULL default '',
-  accessibility enum('normal','locked','archive','hidden') NOT NULL,
+  flags set('header') default NULL,
+  accessibility enum('normal','locked','archive','hidden') NOT NULL default 'normal',
   blurb varchar(255) NOT NULL default '',
   PRIMARY KEY  (id)