TID: Mystic BBS 1.12 A49   
   MSGID: 1:129/215 08112d94   
   TZUTC: -0400   
    CA> I have a question about how you laid our your db containing msgs that i   
    CA> thought you might answer.   
    CA> In storing messages, specifically echomail, do you save each kludge   
    CA> as a seperate value or do you just simply save the header info and then   
    CA> the entire message text with kludge?   
      
   The message text and the kludges are stored separately.  JAM bases have a   
   message header/index with mostly integer-based data, and then a message text   
   buffer.  Part of that text storage is a sub-text buffer that stores custom   
   fields and it has a variable length which allows field expandability without   
   breaking the format.  The subtext is where the kludges are stored.   
      
   I believe Synchronet's format uses a similar approach too.   
      
   ... A SQL query walks into a bar and sees two tables. Asks: 'Can I join you?'   
      
   --- Mystic BBS v1.12 A49 2023/03/14 (Windows/64)   
    * Origin: Sector 7 * Mystic WHQ (1:129/215)   
   SEEN-BY: 1/123 15/0 90/1 105/81 106/201 114/705 120/616 123/10 120   
   SEEN-BY: 123/131 129/215 305 153/7715 154/10 30 40 50 700 218/700   
   SEEN-BY: 218/840 220/70 90 221/6 226/17 18 30 70 100 227/114 201 229/110   
   SEEN-BY: 229/111 112 113 206 275 307 310 317 400 424 426 428 452 470   
   SEEN-BY: 229/550 664 700 250/5 8 266/512 267/800 280/464 282/1038   
   SEEN-BY: 292/854 298/25 301/1 305/2 3 317/3 320/219 322/757 342/200   
   SEEN-BY: 396/45 460/58 633/280 712/848 770/1 2320/105 3634/12   
   PATH: 129/215 154/10 770/1 317/3 229/426