Re: Simplifying db queries
From: cruiserweight <bayon86_at_yahoo.com>
Date: 2 Mar 2005 03:44:09 -0800
Message-ID: <1109763848.992331.251790_at_o13g2000cwo.googlegroups.com>
Date: 2 Mar 2005 03:44:09 -0800
Message-ID: <1109763848.992331.251790_at_o13g2000cwo.googlegroups.com>
Sorry. The MySQL (MyISAM) table structure looks like:
creator tinyint(2) docName tinytext year smallint(4) month tinyint(2) week tinyint(1) dateCreated datetime lastModified datetime
creator is a two digit user code for whomever created the record. docname is the name of the excel spreadsheet, which is what the main purpose of the db is. Is that enough? Received on Wed Mar 02 2005 - 12:44:09 CET