(A website based on these tables was initiated on 30 Sep 2002.)

1. The modem Buses (ISA, PCI, RS-232 etc):

   CREATE TABLE buses (
    BID int(10) unsigned NOT NULL auto_increment PRIMARY KEY,
    NID int(10) unsigned NOT NULL default '0' REFERENCES names, /* Modem */
    BTD int(3) unsigned NOT NULL default '0' REFERENCES busTypes,
    UNIQUE KEY NID (NID,BTD)
   ) TYPE=MyISAM COMMENT='A Look-up table for Buses for devices';

   (26 May 02 added)
   (19 Nov 02 updated - key NID made compound & unique to prevent duplicates; this effectively makes NID the Primary key, but I cannot face re-writing all the scripts at this moment (better to get this sort of thing right at the beginning).)
   
2. Types of Bus Interface (ISA, PCI, RS-232 etc):

   CREATE TABLE busTypes (
    BTD tinyint(3) unsigned NOT NULL auto_increment PRIMARY KEY,
    Name tinytext NOT NULL
   ) TYPE=MyISAM COMMENT='See Buses';

   (26 May 02 updated - BID changed to BTD as have run out of auto-increment TLDs)
3. the modem Chip Families (this table is used to link all the Chip Names together):

   CREATE TABLE chipFamilies (
    UID int(10) unsigned NOT NULL auto_increment PRIMARY KEY,
    NID int(10) unsigned NOT NULL default '0' REFERENCES names, /* Mfc */
    NAD int(10) unsigned default NULL REFERENCES names, /* Family Type */
    NBD int(10) unsigned default NULL REFERENCES names, /* Family */
    NCD int(10) unsigned default NULL REFERENCES names, /* Chipset */
    Num tinyint(3) unsigned default NULL, /* Number of chips */
    KEY NID (NID),
    KEY NAD (NAD),
    KEY NBD (NBD),
    KEY NCD (NCD)
   ) TYPE=MyISAM COMMENT='A Look-up table to relate mfc to Chipsets and Family Types';

   (16 Feb 02 added)
   (28 Feb 02 updated - NED [chip] spun off into chipFLU & Num converted to tinyint from tinytext)
   (30 May 02 updated - NDD moved & name changed to NID, Key adjusted)
   (05 Oct 02 updated - compound Key changed to single keys for better performance [not much bigger])
   
4. a lookup table to associate each chip with its chipset:

   CREATE TABLE chipLU (
    CID int(10) unsigned NOT NULL auto_increment PRIMARY KEY,
    UID int(10) unsigned NOT NULL default '0' REFERENCES chipFamilies,
    NID int(10) unsigned NOT NULL default '0' REFERENCES names, /* Chip */
    UNIQUE KEY UID (UID,NID),
    KEY NID (NID)
   ) TYPE=MyISAM COMMENT='A Look-up table for Chips and Chipset Families';

   (28 Feb 02 added)
   (05 Sep 02 updated: UID/NID Key made UNIQUE so that only one combination allowed)
   (04 Oct 02 updated: Key for NID added to improve performance of chips.php)
   (26 Oct 02 updated - name changed from chipFLU & PRIMARY from VID as trying to regularize for define’s)
   
5. Types of Chip Package:

   CREATE TABLE chipPackTypes (
    QTD tinyint(3) unsigned NOT NULL auto_increment PRIMARY KEY,
    Name tinytext NOT NULL
   ) TYPE=MyISAM COMMENT='See Chips';

   (09 Feb 02 added)
   (28 May 02 updated - OID changed to QTD as have run out of auto-increment TLDs)
   
6. the Chips which make up the chipsets:

   CREATE TABLE chips (
    NID int(10) unsigned NOT NULL default '0' PRIMARY KEY REFERENCES names,
    JTD tinyint(3) unsigned default NULL REFERENCES chipTypes,
    QTD tinyint(3) unsigned default NULL REFERENCES chipPackTypes,
    KEY JTD (JTD)
   ) TYPE=MyISAM COMMENT='Unique extra info for each Chip - see Names';

   (09 Feb 02 updated - fields removed + ref changed to NID + added QTD)
   (15 Feb 02 updated - added key for NID)
   (02 Oct 02 updated - NID Key made Unique)
   (25 Oct 02 updated - JID dropped & NID made Primary Key)
7. the modem Chipsets (strictly chipset family) - this table is used in displaying the chipsets:

   CREATE TABLE chipsets (
    NID int(10) unsigned NOT NULL default '0' PRIMARY KEY REFERENCES names,
    Info tinytext NOT NULL,
    Notes text,
    AtCountry tinytext,
    AtVersion tinytext,
    Conflict text,
    Uninstall tinytext,
    Updated timestamp(14) NOT NULL
   ) TYPE=MyISAM COMMENT='Display reference table - see Names';

   (24 Jan 02 updated - Name removed + MID changed to NID + cosmetic field name changes)
   (06 Aug 02 updated - Updated added, Conflict changed to text + AtWinPrefix, Ati6, Info removed [no point in having 2 lots of text description])
   (25 Oct 02 updated - CID dropped & NID made Primary Key)
   (15 Dec 02 updated - Description changed to Info - throughout Info is now a short description in tinytext & Notes is a longer description in text)
   
8. Types of Chip function (DSP, DAA etc):

   CREATE TABLE chipTypes (
    JTD tinyint(3) unsigned NOT NULL auto_increment PRIMARY KEY,
    Name tinytext NOT NULL
   ) TYPE=MyISAM COMMENT='See Chips';

   (28 May 02 updated - FID changed to JTD as have run out of auto-increment TLDs)
9. Computers (to link computers/laptops/MBs with their modems):

   CREATE TABLE computers (
    XID int(10) unsigned NOT NULL auto_increment PRIMARY KEY,
    NID int(10) unsigned NOT NULL default '0' REFERENCES names, /* Computer */
    NSD int(10) unsigned NOT NULL default '0' REFERENCES names, /* Supplier */
    NMD int(10) unsigned NOT NULL default '0' REFERENCES names, /* Modem */
    UNIQUE KEY NID (NID,NSD,NMD),
    KEY NSD (NSD),
    KEY NMD (NMD)
   ) TYPE=MyISAM COMMENT='A Look-up table for Computers to modems to suppliers';

   (16 Jan 02 added)
   (21 Sep 02 updated - NCD changed to NID + NSD added)
   (04 Nov 02 updated - NID changed to NID,NSD,NMD & made UNIQUE to prevent duplicates)
   
10. Credits (for people that help + info):

    CREATE TABLE credits (
     AID int(10) unsigned NOT NULL auto_increment PRIMARY KEY,
     NID int(10) unsigned NOT NULL default '0' REFERENCES names,
     HID int(10) unsigned NOT NULL default '0' NULL REFERENCES emails,
     Updated timestamp(14) default NULL,
     Notes text NOT NULL,
     KEY NID (NID)
    ) TYPE=MyISAM COMMENT='Look-up table for emails';

    (16 Jan 02 updated - AID added [makes changes simple] + MID changed to NID + Updated changed from date to timestamp)
    (03 Nov 02 updated - HID changed to NOT NULL; no credits without an email address, although can be witheld from display)
    (15 Dec 02 updated - Info changed to Notes)
    
11. examples of driver version drawn from ATI command results:

    CREATE TABLE dvInfos (
     FID int(10) unsigned NOT NULL auto_increment PRIMARY KEY,
     NID int(10) unsigned NOT NULL default '0' REFERENCES names,
     Updated date default NULL,
     Version tinytext NOT NULL,
     Notes text,
     KEY NID (NID)
    ) TYPE=MyISAM COMMENT='A Look-up table for all Driver Information';

    (04 Jun 02 updated - FID added, Intro changed to Updated, Notes to Info, Version made NOT NULL)
    (06 Aug 02 updated - CID references Names - a chipset family)
    (10 Aug 02 updated - CID changed to NID) (15 Dec 02 updated - Info changed to Notes)
    
12. Emails:

    CREATE TABLE emails (
     HID int(10) unsigned NOT NULL auto_increment PRIMARY KEY,
     Name tinytext NOT NULL,
     Before tinytext NOT NULL,
     After tinytext NOT NULL,
     Noshow tinyint(3) unsigned default NULL
    ) TYPE=MyISAM COMMENT='Reference store of all email addresses';

    (16 Jan 02 added)
13. The modem Features (ISA, PCI, RS-232 etc):

    CREATE TABLE features (
     EID int(10) unsigned NOT NULL auto_increment PRIMARY KEY,
     NID int(10) unsigned NOT NULL default '0' REFERENCES names, /* Modem */
     ETD int(3) unsigned NOT NULL default '0' REFERENCES featureTypes,
     UNIQUE KEY NID (NID,ETD)
    ) TYPE=MyISAM COMMENT='A Look-up table for Features of devices';

    (27 May 02 added, featuredlu removed)
    (19 Nov 02 updated - key NID made compound & unique to prevent duplicates)
    
14. Types of Modem features (Data, Fax, Voice etc):

    CREATE TABLE featureTypes (
     ETD tinyint(3) unsigned NOT NULL auto_increment PRIMARY KEY,
     Name tinytext NOT NULL
    ) TYPE=MyISAM COMMENT='See Features';

    (27 May 02 updated - EID changed to ETD as have run out of auto-increment TLDs)
15. Hardware ID lookup (to find the HW IDs for modems & chipsets):

    CREATE TABLE hwIDLU (
     YID int(10) unsigned NOT NULL auto_increment PRIMARY KEY,
     NID int(10) unsigned NOT NULL default '0' REFERENCES names,
     WID int(10) unsigned NOT NULL default '0' REFERENCES hwids,
     WTD tinyint(3) unsigned NOT NULL default '0' REFERENCES hwIDTypes,
     UNIQUE KEY NID (NID,WID,WTD)
    ) TYPE=MyISAM COMMENT='A Look-up table for HW IDs for devices';

    (09 Aug 02 added)
16. Hardware ID info (this is what is used by .INF driver files to confirm the device):

    CREATE TABLE hwids (
     WID int(10) unsigned NOT NULL auto_increment PRIMARY KEY,
     HWID tinytext NOT NULL,
     UNIQUE KEY HWID (HWID(255))
    ) TYPE=MyISAM COMMENT='Reference store of all HW IDs';

    (02 Mar 02 added)
    (09 Aug 02 updated - there is lots of duplication of these IDs amongst drivers, so the IDs themselves appear here)
    
17. Types of Hardware ID (PCI SubVendor ID etc):

    CREATE TABLE hwIDTypes (
     WTD tinyint(3) unsigned NOT NULL auto_increment PRIMARY KEY,
     Name tinytext NOT NULL
    ) TYPE=MyISAM COMMENT='See hwIDLU';

    (02 Mar 02 added) (28 May 02 updated - XID changed to WTD as have run out of auto-increment TLDs)
18. Links Look-up - this is how the links for a name are found:

    CREATE TABLE linkLU (
     KID int(10) unsigned NOT NULL auto_increment PRIMARY KEY,
     NID int(10) unsigned NOT NULL default '0' REFERENCES names,
     LID int(10) unsigned NOT NULL default '0' REFERENCES links,
     LTD tinyint(3) unsigned NOT NULL default '0' REFERENCES linkTypes,
     Updated date default NULL,
     OTD tinyint(3) unsigned default NULL REFERENCES osTypes,
     PTD tinyint(3) unsigned default NULL REFERENCES protocolTypes,
     Notes text,
     KB smallint(5) unsigned default NULL,
     Version tinytext,
     KEY NID(NID,LID,LTD)
    ) TYPE=MyISAM COMMENT='A Look-up table for Links, OSs and Protocols for devices';

    (27 May 02 updated - linkDLU removed & OTD, PTD added here)
    (02 Jul 02 updated - Updated removed from links & added here)
    (05 Sep 02 updated - KB added to show size of download files)
    (26 Oct 02 updated - name changed from linkNLU as trying to regularize for define’s)
    (28 Jun 03 updated - Version added
    
19. Web-Links to other websites (this is going to be very generic):

    CREATE TABLE links (
     LID int(10) unsigned NOT NULL auto_increment PRIMARY KEY,
     Link tinytext NOT NULL,
     Title tinytext,
     UNIQUE KEY link (Link(255))
    ) TYPE=MyISAM COMMENT='Reference store of all Link addresses';

    (02 Jul 02 updated - Updated transferred to linkNLU as some webpages have many links on them [doh])
    (05 Sep 02 updated - Unique key link added)
    (16 Oct 02 updated - Title added)
    
20. Types of Links:

    CREATE TABLE linkTypes (
     LTD tinyint(3) unsigned NOT NULL auto_increment PRIMARY KEY,
     Name tinytext NOT NULL
    ) TYPE=MyISAM COMMENT='See LinkNLU';

    (28 May 02 updated - TID changed to LTD as have run out of auto-increment TLDs)
21. Logo lookup table:

    CREATE TABLE logoLU (
     DID int(10) unsigned NOT NULL auto_increment PRIMARY KEY,
     NID int(10) unsigned NOT NULL default '0' REFERENCES names,
     GID int(10) unsigned NOT NULL default '0' REFERENCES logos,
     LID int(10) unsigned default NULL REFERENCES links,
     UNIQUE KEY NID (NID,GID,LID)
    ) TYPE=MyISAM COMMENT='A Lookup table for Names, Logos & Links';

    (28 Sep 02 added)
    (26 Oct 02 updated - name changed from logoNLU & PRIMARY from GUD as trying to regularize for define’s)
    
22. Logos:

    CREATE TABLE logos (
     GID int(10) unsigned NOT NULL auto_increment PRIMARY KEY,
     Name tinytext NOT NULL,
     Wd tinyint(3) unsigned default NULL,
     Ht tinyint(3) unsigned default NULL,
     Alt tinytext,
     UNIQUE KEY Name (Name(20),Wd,Ht)
    ) TYPE=MyISAM COMMENT='Reference store of all Logo filenames, etc.';

    (05 Jun 02 updated - Wd & Ht (width/height) added, Name made NOT NULL)
    (28 Sep 02 updated - NID & LID moved to logoNLU as became clear there was going to be lots of duplicate logos, especially Microsoft)
    (16 Oct 02 updated - Title moved from here to Links as it belongs with the link, although included in the html with the Logo
    (29 Jun 03 updated - Key Name added & WD, Ht changed from tinyint to smallint as this will store both logos & pictures
    
23. mfcs - the list of Manufacturers:

    CREATE TABLE mfcs (
     MID int(10) unsigned NOT NULL auto_increment PRIMARY KEY,
     Name varchar(10) NOT NULL default '',
     UsesID text default NULL,
     Notes text,
     Updated timestamp(14) NOT NULL,
     KEY Name (Name)
    ) TYPE=MyISAM COMMENT='The core Table of Manufacturers';

    (20 Sep 02 updated - removed dead as this is within names)
    (30 Oct 02 updated - UsesID changed from yes/no to text - it now contains the info on how to access the ID & the presence/absence of this acts as the Boolean)
    (08 Nov 02 updated - removed Visits to names)
    
24. modems:

    CREATE TABLE modems (
     NID int(10) unsigned NOT NULL default '0' PRIMARY KEY REFERENCES names, /* Modem */
     NMD int(10) unsigned NOT NULL default '0' REFERENCES names, /* Mfc */
     NCD int(10) unsigned default NULL REFERENCES names, /* Chipset Mfc */
     CAD int(10) unsigned default NULL REFERENCES names, /* Chip Family Type */
     CBD int(10) unsigned default NULL REFERENCES names, /* Chipset Family */
     CCD int(10) unsigned default NULL REFERENCES names, /* Chipset */
     Notes text,
     Updated timestamp(14) NOT NULL,
     KEY NMD (NMD),
     KEY NCD (NCD,CAD,CBD,CCD)
    ) TYPE=MyISAM COMMENT='Display reference table';

    (18 Jan 02 updated - Name removed & MID changed to NID)
    (30 May 02 updated - large-scale changes across 7 days)
    (05 Sep 02 updated - key for NSD added)
    (25 Oct 02 updated - DID dropped, NID made Primary Key, NSD [supplier] changed to NMD [mfc])
25. the Name of the manufacturer, etc:

    CREATE TABLE names (
     NID int(10) unsigned NOT NULL auto_increment PRIMARY KEY,
     Name tinytext NOT NULL,
     NTD tinyint(3) unsigned NOT NULL default '0' REFERENCES nameTypes,
     MID int(10) unsigned NOT NULL default '0' REFERENCES mfcs,
     dead tinyint(3) unsigned default NULL,
     KEY MID (MID),
     KEY Name (Name(40))
    ) TYPE=MyISAM COMMENT='The Central table of Names';

    (08 Nov 02 updated - Hits added from mfcs)
    
26. Types of Manufacturer, etc.:

    CREATE TABLE nameTypes (
     NTD tinyint(3) unsigned NOT NULL auto_increment PRIMARY KEY,
     Name tinytext NOT NULL
    ) TYPE=MyISAM COMMENT='See Names';

    (28 May 02 updated - YID changed to NTD as have run out of auto-increment TLDs)
27. The modem OS Platforms (Windows 95, Linux etc):

    CREATE TABLE oss (
     OID int(10) unsigned NOT NULL auto_increment PRIMARY KEY,
     NID int(10) unsigned NOT NULL default '0' REFERENCES names, /* Modem */
     OTD int(3) unsigned NOT NULL default '0' REFERENCES osTypes,
     UNIQUE KEY NID (NID,OTD)
    ) TYPE=MyISAM COMMENT='A Look-up table of OSs for Devices';

    (02 Jun 02 added)
    (19 Nov 02 updated - key NID made compound & unique to prevent duplicates)
    
28. Types of Platforms (OSs - Windows 95, Linux etc):

    CREATE TABLE osTypes (
     OTD tinyint(3) unsigned NOT NULL auto_increment PRIMARY KEY,
     Name tinytext NOT NULL
    ) TYPE=MyISAM COMMENT='See OSs and LinkNLU';

    (27 May 02 updated - OID changed to OTD as have run out of auto-increment TLDs)
29. A ‘See Also’ table:

    CREATE TABLE others (
     QID int(10) unsigned NOT NULL auto_increment PRIMARY KEY,
     NID int(10) unsigned NOT NULL default '0' REFERENCES names, /* Modem */
     See int(10) unsigned NOT NULL default '0' REFERENCES names, /* Modem */
     UNIQUE KEY NID (NID,See)
    ) TYPE=MyISAM COMMENT='A Look-up table to connect Devices to other devices';

    (13 Jun 02 added)
    (03 Nov 02 added - NID Key changed to Unique with See to avoid duplicates)
    
30. Picture lookup table:

    CREATE TABLE piclu (
     JID int(10) unsigned NOT NULL auto_increment PRIMARY KEY,
     NID int(10) unsigned NOT NULL default '0',
     GID int(10) unsigned NOT NULL default '0',
     LID int(10) unsigned default NULL,
     UNIQUE KEY NID (NID,GID,LID)
    ) TYPE=MyISAM COMMENT='A Lookup table for Names, Pictures & Links';

    (29 Jun 03 added)
    
31. The modem Protocols (V.90, X.75, G.Lite etc):

    CREATE TABLE protocols (
     PID int(10) unsigned NOT NULL auto_increment PRIMARY KEY,
     NID int(10) unsigned NOT NULL default '0' REFERENCES names, /* Modem */
     PTD int(3) unsigned NOT NULL default '0' REFERENCES protocolTypes,
     UNIQUE KEY NID (NID,PTD)
    ) TYPE=MyISAM COMMENT='A Look-up table for Protocols for devices';

    (02 Jun 02 added)
    (19 Nov 02 updated - key NID made compound & unique to prevent duplicates)
    
32. Types of Protocols (V.90, X.75, G.Lite etc):

    CREATE TABLE protocolTypes (
     PTD tinyint(3) unsigned NOT NULL auto_increment PRIMARY KEY,
     Name tinytext NOT NULL
    ) TYPE=MyISAM COMMENT='See Protocols and LinkNLU';

    (27 May 02 updated - PID changed to PTD as have run out of auto-increment TLDs)
33. Page-visit statistics:

    CREATE TABLE statistics (
     NID int(10) unsigned NOT NULL default '0' REFERENCES names, /* Device */
     Day date NOT NULL,
     Visit int(10) unsigned NOT NULL,
     UNIQUE KEY NID (NID,Day,Visit)
    ) TYPE=MyISAM COMMENT='Page visits by day';

    (08 Nov 02 added - contains all hits for all pages)
    (01 Jun 03 updated - Key extended to include Visit; reduced Top 10 page calculation from 27 to 1.3 secs.)
    
34. Page-visit statistics:

    CREATE TABLE stats (
     ZID int(10) unsigned NOT NULL auto_increment PRIMARY KEY,
     Page tinytext NOT NULL,
     Year smallint(5) unsigned NOT NULL,
     Month tinyint(3) unsigned NOT NULL,
     Day tinyint(3) unsigned NOT NULL,
     Domain tinyint(3) unsigned NOT NULL,
     Visit int(10) unsigned NOT NULL,
     KEY Page (Page(25),Year,Month,Day)
    ) TYPE=MyISAM;

    (08 Mar 02 added)
    (18 Mar 02 updated - Domain addded ready for modem-help.co.uk [=1] addition)
35. The modem Telecom interfaces (POTS, Euro-ISDN etc):

    CREATE TABLE telecoms (
     IID int(10) unsigned NOT NULL auto_increment PRIMARY KEY,
     NID int(10) unsigned NOT NULL default '0' REFERENCES names, /* Modem */
     ITD int(3) unsigned NOT NULL default '0' REFERENCES telecomTypes,
     UNIQUE KEY NID (NID,ITD)
    ) TYPE=MyISAM COMMENT='A Look-up table for Telecoms for devices';

    (27 May 02 added, telecomdlu removed)
    (19 Nov 02 updated - key NID made compound & unique to prevent duplicates)
    
36. Types of Telecom Interface (POTS, Euro-ISDN etc):

    CREATE TABLE telecomTypes (
     ITD tinyint(3) unsigned NOT NULL auto_increment PRIMARY KEY,
     Name tinytext NOT NULL
    ) TYPE=MyISAM COMMENT='See Telecoms';

    (27 May 02 updated - IID changed to ITD as have run out of auto-increment TLDs)