Database
<div id="_mcePaste">CREATE TABLE `accounts` ( `AccountName` varchar(20), `Email` varchar(50), `Password` varchar(30), `First` varchar(30), `Last` varchar(30), `Phone` varchar(11), `OrgAccount` varchar(20), `OrgName` varchar(50), `Type` enum(user,coach,organization,
admin), `CreationTimestamp` timestamp, PRIMARY KEY (`AccountName`) );</div>
<div id="_mcePaste">CREATE TABLE `account_inventories` ( `AccountName` varchar(20), `IID` varchar(10), `Pin` varchar(6), `ProductCode` varchar(20), `NickName` varchar(20), PRIMARY KEY (`AccountName`, `IID`) );</div> |