Re: Re: The future of SMB (Synchronet Message Base)
  By: Ragnarok to Digital Man on Wed Apr 10 2019 01:18 pm

 > El 9/4/19 a las 02:03, Digital Man escribió:
 >
 >
 > > Well I'm mainly interested in input from folks who've designed database
 > > schemas. I want to try to do it right the first time (naturally).
 >
 >
 > First, i think that you need to avoid the Libraries->Directories->files
 > (two level limited) and migrate to Tree data (more like filesystem)
 >
 >
 > files table
 > ------------
 > id
 > name
 > description
 > directory_id
 > upload_by
 > upload_date
 > etc...
 >
 >
 > directories table
 > ---------------
 > id
 > name
 > descripcion
 > parent_directory_id
 > etc....

I think we're talking about 2 different things. I'm talking about the database
schema for a single message area.

                                            digital man

Synchronet/BBS Terminology Definition #50:
PET = Personal Electronic Transactor (Commodore computer)
Norco, CA WX: 67.3øF, 27.0% humidity, 1 mph NNW wind, 0.00 inches rain/24hrs
--- SBBSecho 3.07-Linux