Code: Select all
$members_sql = "CREATE TABLE members (
ID INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
Name VARCHAR(100) NOT NULL,
Email VARCHAR(100) NOT NULL,
Telephone VARCHAR(100) NOT NULL,
Cell VARCHAR(100) NOT NULL,
Home VARCHAR(100) NOT NULL,
TIN VARCHAR(100) NOT NULL,
MSCode VARCHAR(100) NOT NULL,
Status VARCHAR(100) NOT NULL,
Job VARCHAR(100) NOT NULL,
Reg_Date TIMESTAMP,
GDPR VARCHAR(100) NOT NULL,
SMS VARCHAR(100) NOT NULL,
MAILTO VARCHAR(100) NOT NULL,
)";
Is this normal or am I missing something? The site is still in beta mode and no-one will notice it but out of curiosity. How do you normally alter tables?
P.S: This is not a support question. Just asking if this is the intended behaviour and how you guys go altering tables using PHP .