NYCPHP Meetup

[jon baer]

Well the 60 tables are a collaboration of packages ... (oscommerce, phpbb,
calendar, ai, etc) so much of it is reasonable, one is bh_player, which is
approx ~100 players per leagues, 5 leagues @ the moment:

CREATE TABLE bh_player (
  id int(11) NOT NULL auto_increment,
  team int(11) default NULL,
  first varchar(50),
  last varchar(50),
  jersey int(2) NOT NULL default '0',
  number1 varchar(10) default NULL,
  number2 varchar(10) default NULL,
  email varchar(50),
  zipcode varchar(5) NOT NULL default '00000',
  position int(1) default NULL,
  captain tinyint(1) default '0',
  sponsor varchar(50) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

<?xml version="1.0">
<player>
<team/>
<first/>
<last/>
...
</player>


----- Original Message -----
From: "Mitch Pirtle" <mitchy at spacemonkeylabs.com>
To: "NYPHP Talk" <talk at lists.nyphp.org>
Sent: Friday, February 27, 2004 2:36 PM
Subject: Re: [nycphp-talk] XML vs. DB (best approach)


> If you'd like to have the data model reviewed I'd be happy to take a
> look for you.  That does sound like a lot of tables for not that much
> data.  I definitely agree with Dan about XML being used for the sharing
> of data, and a RDBMS for storage/retrieval.
>