MyConnection Server Tutorials

Creating a MySQL table to receive the MyConnection Server parameters

Step 3:

You can now begin adding tables to your database.

Do do this you need to use the create table command. The exact syntax is:

create table tablename (columnname inputtype, columnname inputtype, etc etc)

The example below creates a table called test then adds various column names that will be used to add data to from MyConnection Server.

Below the screenshot are ready made table commands that can be copied and pasted to help create your own tables. They contain every parameter you can have in MyConnection Server so feel free to edit according to what data you want to collect.

You can find help on MySQL commands at http://dev.mysql.com/doc/refman/5.1/en/

Click here for a tutorial on setting up MyConnection Server to deliver data to your MySQL database.

CREATE TABLE tests (recordid int, testid int, time varchar(40), timeint bigint, detaillink varchar(128), sid varchar(255), ip varchar(64), dnsname varchar(64), cc varchar(2), isp varchar(64), PRIMARY KEY (recordid), UNIQUE KEY (testid));

CREATE TABLE accessct (recordid int, testid int, dspeed int, uspeed int, qos tinyint, rtt smallint, maxpause mediumint, maxroutespeed int, maxlinespeed int, concurrenttcp float, tcpforcedidle float, tcprxpooo mediumint, tcprxbooo mediumint, tcprxpow mediumint, tcprxbow mediumint, tcprxdop mediumint, tcprxdob mediumint, tcprxpdp mediumint, tcprxpdb mediumint, tcprxcrcerr mediumint, tcprxboff mediumint, tcprxts mediumint, tcpbyteslost mediumint, uqos tinyint, umaxpause mediumint, umaxlinespeed int, uconcurrenttcp float, utcpforcedidle float, ethrxftl mediumint, ethrxnoal mediumint, ethrxsf mediumint, ethrxcrcerr mediumint, ethrxovr mediumint, ethrxtrunc mediumint, dtesttype varchar(6), version varchar(128), runtime mediumint, freeq mediumint, PRIMARY KEY (recordid), UNIQUE KEY (testid));

CREATE TABLE mycapacity (recordid int, testid int, dcapacity int, ucapacity int, dpackets mediumint, upackets mediumint, packetsize smallint, qos tinyint, PRIMARY KEY (recordid), UNIQUE KEY (testid));

CREATE TABLE myiptv (recordid int, testid int, jitter1 float, loss1 float, order1 float, jitter2 float, loss2 float, order2 float, jitter3 float, loss3 float, order3 float, PRIMARY KEY (recordid), UNIQUE KEY (testid));

CREATE TABLE myroute (recordid int, testid int, ipto varchar(64), hops tinyint, endms smallint, maxms smallint, endloss smallint, maxloss smallint, ipfrom varchar(64), nameto varchar(128), PRIMARY KEY (recordid), UNIQUE KEY (testid));

CREATE TABLE myspeed (recordid int, testid int, dspeed int, uspeed int, qos tinyint, rtt smallint, maxpause mediumint, avgpause mediumint, bandwidth int, routespeed int, forcedidle tinyint, routeconc float, dtesttype varchar(6), utesttype varchar(6), PRIMARY KEY (recordid), UNIQUE KEY (testid));

CREATE TABLE myvideo (recordid int, testid int, ajitter float, vjitter float, aloss tinyint, vloss tinyint, adiscards tinyint, vdiscards tinyint, PRIMARY KEY (recordid), UNIQUE KEY (testid));

CREATE TABLE myvoip (recordid int, testid int, jitter float, djitter float, loss float, dloss float, uorder float, dorder float, discards float, mos float, PRIMARY KEY (recordid), UNIQUE KEY (testid));