Step 2: set up the database

Create a database and the "heusers" table

We need to create and set up a database where activation data will be stored.

1) Start phpmyadmin on your server and create a new database. Choose the name you want or the one given by your hosting provider.

data 1

2) Select your new database and click SQL SQL. Copy and paste the following SQL query:

CREATE TABLE IF NOT EXISTS `heusers` (
`userkey` varchar(80) collate latin1_general_ci NOT NULL,
`name` text collate latin1_general_ci NOT NULL,
`compname` text collate latin1_general_ci,
`certificate` text collate latin1_general_ci NOT NULL,
`email` text collate latin1_general_ci,
`datetime` datetime default NULL,
`lastsystemid` varchar(12) collate latin1_general_ci default NULL,
`lastip` text collate latin1_general_ci,
`blocked` tinyint(1) NOT NULL default '0',
`numact` int(11) NOT NULL default '3',
`comments` text collate latin1_general_ci,
PRIMARY KEY (`userkey`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

And validate.

sql OK

Now you should have a table named "heusers":

heusers table

img Step 3: configure the mandatory settings