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.
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
