I am converting a database from MS SQL Server to MySQL. I am trying to create my users table as follows:
CREATE TABLE TBL_users (
MemberID int NOT NULL AUTO_INCREMENT,
UserAccess int DEFAULT 3,
EmailType nvarchar(50) DEFAULT 'HTML',
RegDate datetime NOT NULL DEFAULT CURDATE(),
isStrongPassword bit (0) NOT NULL DEFAULT,
isHashedPassword bit (0) NOT NULL DEFAULT,
PRIMARY KEY (MemberID)
I keep getting an error message that says I have a syntax error between the 'RegDate' line and the 'isHashedPassword' line? I have substituted CURDATE() for NOW() and get the same error. Also, I have tried the 'timestamp' data type for 'RegDate' but I don't want the 'RegDate' field to change when I do an update on a record in the database.
I have also changed the order of 'DEFAULT' and 'NOT NULL' in those lines but nothing seems to work??