| Server IP : 134.29.175.74 / Your IP : 216.73.216.160 Web Server : nginx/1.10.2 System : Windows NT CST-WEBSERVER 10.0 build 19045 (Windows 10) i586 User : Administrator ( 0) PHP Version : 7.1.0 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/nginx/html/JimMartinson/_Archive/_MMDT2146/Labs/Lab02/ |
Upload File : |
Define the column type, null, default, comment for the user and userdata TABLE columns user TABLE column name type null default comment/example userId int(10) no Primary key userUsername varchar(16) userPassword varchar(16) userFirstname userMiddlename userLastname userEmail userImage userInactive userdata TABLE column name type null default comment/example userId businessName userNickname userAddress1 userAddress2 userCity stateId userCountry userZipcode userSecurityQuestion userSecurityQuestionAnswer userphonenumber TABLE userphonenumberId userphonenumberPhoneNumber userId userphonenumberType userphonenumberInactive userphonenumbertype TABLE column name type null default comment/example userphonenumbertypeId int(10) userphonenumbertypeName varchar(4) no work, cell, home, ooga userphonenumbertypeDescription varchar(128) yes userphonenumbertypeInactive tinyint(1) no 0 user_group TABLE column name type null default comment/example userId groupId group TABLE column name type null default comment/example groupId groupName