Alex Satrapa wrote:
> I'm currently exploring the Zelerate AllCommerce system
> http://allcommerce.sourceforge.net
Ick... this product is *so* the poster child of the MySQL generation:
#
# Table structure for table 'addresses'
#
CREATE TABLE addresses (
objid varchar(20) DEFAULT '' NOT NULL,
objclass varchar(20) DEFAULT '' NOT NULL,
objtype varchar(20) DEFAULT '' NOT NULL,
...
PRIMARY KEY objid
);
No foreign keys! Look at all those "DEFAULT '' NOT NULL" columns! What
are they thinking?
As penance for suggesting this product, I will clean up the SQL and at
least post my experiences with installing and using this product on
PostgreSQL.