Re: Preferred administration/maintainence tools.

[cfm@maine.com]

******    message to minivend-users from cfm@maine.com     ******

> ******    message to minivend-users from mediamob <mediamob@dnaco.net>     ******
> 
> I am working on my catalog and need to make some design choices for my
> database mastering. My descriptions are very lengthy, so the import/export
> from Microsoft Excel and/or Access make them inappropriate (they truncate
> MEMO fields to 255 chars).
> 
> Is anyone else facing this situation? What are you using to build your
> products.asc file, or have you gone with straight SQL? I can use solutions
> on Win 9x or Linux, and prefer linux.

We use SQL exclusively and run 100% linux.  Below is our standard
products table.  We use both a short 255 char description and a longer
(up to 64kb) text field.  At least some DOS/Windows dbs support memo 
fields over 255.  dbf is what, Foxpro?

#DROP TABLE products;
CREATE TABLE products (
  code varchar(32) DEFAULT '0' NOT NULL PRIMARY KEY,
  annum varchar(13),
  description tinytext,
  flypage tinytext,
  headline tinytext,
  image tinytext,
  image_height int(11),
  image_width int(11),
  keywords varchar(255),
  lm timestamp(14) NOT NULL,
  meta varchar(64),
  price varchar(16),
  product varchar(64),
  product_sub varchar(32),
  shipping_charge varchar(16),
  status int(11) DEFAULT '-1' NOT NULL,
  text text,
  thumbnail tinytext,
  thumbnail_height int(11),
  thumbnail_width int(11),
);

> 
> Thanks,
> 
> Pat Santucci
> 
> -
> To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
> email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
> Archive of past messages: http://www.minivend.com/minivend/minivend-list
> 


-- 

Christopher F. Miller, Publisher                            cfm@maine.com
MaineStreet Communications, Inc        208 Portland Road, Gray, ME  04039
1.207.657.5078  (MTRF 3-5pm)                        http://www.maine.com/
-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list