local DBTableStruct = {
    -- ### SERVER Related Tables ##################################################
    -- Server Profiles
    sv_profiles = {     {ServerID="char(20):primary"},
                        {IP="char(15)"},
                        {CreatedDate="int(10):unsigned"},
                        {CreatedTime="mediumint(8):unsigned"},
                        {LastSeenDate="int(10):unsigned"},
                        {LastSeenTime="mediumint(8):unsigned"},
                        {Owner="char(18):null"},
                        {Hostname="varchar(64):null"},
                        {HostnamePre="varchar(64):null"},
                        {HostnamePost="varchar(64):null"},
                        {ServerPassword="varchar(64):null"},
                        {DBType="varchar(16)"},
                        {DBName="varchar(64):null"},
                        {DBHost="varchar(128):null"},
                        {DBUsername="varchar(64):null"},
                        {DBPassword="varchar(128):null"},
                        {Notes="varchar(255):null"} };
    -- Server Logs
    sv_log = {          {Date="int(10):unsigned:index"},
                        {Time="mediumint(8):unsigned"},
                        {ServerID="char(20):index"},
                        {Data="varchar(255)"} };
    -- Server Data
    sv_data = {         {ServerID="char(20):index"},
                        {ObjType="varchar(64)"},
                        {Name="varchar(64)"},
                        {Data="text:null"} };
    -- Server Bans
    sv_bans = {         {ServerID="char(20):index"},
                        {SteamID="steamid:index"},
                        {IP="char(15)"},
                        {CreatedBy="steamid"},
                        {CreatedDate="int(10):unsigned"},
                        {CreatedTime="mediumint(8):unsigned"},
                        {ExpireDate="int(10):unsigned"},
                        {ExpireTime="mediumint(8):unsigned"},
                        {Reason="varchar(255)"} };
    -- Server Adverts
    sv_adverts = {      {Name="varchar(32)"},
                        {ServerID="char(20):index"},
                        {Type="varchar(16):null"},
                        {Time="mediumint(8)"},
                        {Data="text"} };
    -- Server Group Profiles
    sv_group_profiles = {   {GroupID="char(20):primary"},
                            {TServerID="char(20)"},
                            {Parent="chat(20):null:index"},
                            {Name="varchar(64):null"},
                            {Desc="varchar(255):null"} };
    -- Server Group Members
    sv_group_members = {    {GroupID="char(20):index"},
                            {Member="char(20):index"} };
    -- ### PLAYER Related Tables ###################################################
    -- Player Profiles
    ply_profiles = {    {SteamID="steamid:primary"},
                        {LastSeenDate="int(10):unsigned"},
                        {LastSeenTime="mediumint(8):unsigned"},
                        {LastSeenWhere="char(20)"},
                        {Nick="varchar(64)"},
                        {Password="varchar(128):null"},
                        {AddedDate="int(10):unsigned"},
                        {AddedTime="mediumint(8):unsigned"},
                        {AddedBy="steamid:null"},
                        {Email="varchar(255):null"},
                        {Notes="varchar(255):null"} };
    -- Player Known Aliases
    ply_alias = {       {SteamID="steamid:index"},
                        {FirstSeenDate="int(10):unsigned"},
                        {FirstSeenTime="mediumint(8):unsigned"},
                        {FirstSeenWhere="char(20)"},
                        {LastSeenDate="int(10):unsigned"},
                        {LastSeenTime="mediumint(8):unsigned"},
                        {LastSeenWhere="char(20)"},
                        {Nick="varchar(64)"} };
    -- Player Data (global and per server)
    ply_data = {        {SteamID="steamid:index"},
                        {ServerID="char(20):index"},
                        {ObjType="varchar(64)"},
                        {Name="varchar(64)"},
                        {Data="text:null"} };
    -- Player Files
    ply_files = {       {SteamID="steamid:index"},
                        {Name="varchar(64)"},
                        {Path="varchar(255)"},
                        {Version="smallint:unsigned"},
                        {Data="mediumtext"} };
    -- Player Server Times
    ply_servertime = {  {SteamID="steamid:index"},
                        {ServerID="char(20):index"},
                        {LastSeenDate="int(10):unsigned"},
                        {LastSeenTime="mediumint(8):unsigned"},
                        {TotalMinutes="int(10):unsigned"} };
    -- Player Group Profiles
    ply_group_profiles = {  {GroupID="char(20):primary"},
                            {Parent="char(20):null:index"},
                            {CreatedDate="int(10):unsigned"},
                            {CreatedTime="mediumint(8):unsigned"},
                            {CreatedBy="steamid:null"},
                            {Name="varchar(64):null"},
                            {Desc="varchar(255):null"} };
    -- Player Group Members
    ply_group_members = {   {GroupID="char(20):primary"},
                            {Member="steamid:index"},
                            {Level="tinyint:unsigned"},
                            {CreatedDate="int(10):unsigned"},
                            {CreatedTime="mediumint(8):unsigned"},
                            {CreatedBy="steamid:null"} };
    -- Player Group Data
    ply_group_data = {  {GroupID="char(20):index"},
                        {ObjType="varchar(64)"},
                        {Name="varchar(64)"},
                        {Data="text:null"} };
    -- Player Group Trust Relationships
    ply_group_to_group = {  {GroupID="char(20):index"},
                            {Trustee="char(20)"} };
    -- Player Group Server Relationship
    ply_group_to_server = { {GroupID="char(20):index"},
                            {ServerID="char(20)"} };
}

-- Create DB/DataStore
local PlayerDS = datastore.New()
PlayerDS:SetEngine("mysql", unpack(nss.mysqldb))

-- Define/Create Table
local UserProfiles = PlayerDS:DefineTable("ply_profiles", unpack(DBTableStruct["ply_profiles"]))
if !UserProfiles:Exists() then UserProfiles:Create() end

local playersprofile = UserProfiles:GetWhereAll(SteamID=ply:SteamID())
PrintTable(playersprofile)