(INTs, & TINYINTs changed to UNSIGNED as this doubles possible size; TINYINTs are now 0 to 255, INTs 0 to 4294967295, and BIGINTs (for visits) changed back to INTs.)

1. modems:

   CREATE TABLE modems (
     DID INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
     Name TINYTEXT,
     BID TINYINT UNSIGNED NOT NULL, /* Computer Interface */
     CID INT UNSIGNED NOT NULL, /* Chipset */
     MID INT UNSIGNED NOT NULL, /* Manufacturer */
     SID INT UNSIGNED NOT NULL, /* Supplier - is also a MID */
     IdInfo TINYTEXT, /* mfc-supplied ID */
     Babt TINYTEXT,
     Fcc TINYTEXT,
     Notes TEXT,
     Updated TIMESTAMP NOT NULL,
     KEY(BID),
     KEY(CID),
     KEY(MID),
     KEY(SID),
     KEY(IdInfo(20)),
     KEY(Fcc(20)),
     KEY(Babt(20))
     );

   (14 Jan - all tables continued now at 14 Jan)
2. Types of Protocols (V.90, X.75, G.Lite etc):

   CREATE TABLE protocolTypes (
     PID TINYINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
     Name TINYTEXT NOT NULL
     );

3. Types of Modem features (Data, Fax, Voice etc):

   CREATE TABLE featureTypes (
     EID TINYINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
     Name TINYTEXT NOT NULL
     );

4. Features Look-up - the same modem can have many features:

   CREATE TABLE featureDLU (
     DID INT UNSIGNED NOT NULL,
     EID TINYINT UNSIGNED NOT NULL, /* Types of modem feature */
     PRIMARY KEY(DID, EID)
     );

   (9 Oct added)
5. Types of Telecom Interface (POTS, Euro-ISDN etc):

   CREATE TABLE telecomTypes (
     IID TINYINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
     Name TINYTEXT NOT NULL
     );

   (27 Oct added)
6. Telecom Look-up - the same modem can have many telecom interfaces:

   CREATE TABLE telecomDLU (
     DID INT UNSIGNED NOT NULL,
     IID TINYINT UNSIGNED NOT NULL, /* Types of modem feature */
     PRIMARY KEY(DID, IID)
     );

   (27 Oct added)