Confused by the Help re extra mysql fields
Posted: Mon Oct 02, 2017 10:09 am
Hi guys 
Sorry this has me confused in the help it states:
If you have added custom profile fields to any (or all) of the login objects then you must also create these fields in the database.
Custom profile fields must be named extra1, extra2, extra3 etc!
The following SQL query generates a table with 5 extra custom profile fields:
Custom profile fields must be named extra1, extra2, extra3 etc! What does that mean please?
Cheers
BB
Sorry this has me confused in the help it states:
If you have added custom profile fields to any (or all) of the login objects then you must also create these fields in the database.
Custom profile fields must be named extra1, extra2, extra3 etc!
The following SQL query generates a table with 5 extra custom profile fields:
Code: Select all
CREATE TABLE `USERS` (
`id` int(10) NOT NULL auto_increment,
`username` varchar(50) NOT NULL,
`fullname` varchar(75) NOT NULL,
`password` varchar(50) NOT NULL,
`email` varchar(75) NOT NULL,
`active` tinyint(1) NOT NULL,
`code` varchar(75),
`extra1` varchar(100),
`extra2` varchar(100),
`extra3` varchar(100),
`extra4` varchar(100),
`extra5` varchar(100),
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1;
Cheers
BB
at some stage I will get to go through the tools code and not ask you dumb questions 