Code:
DROP TABLE IF EXISTS YOURPREFIXHERE_admin;
CREATE TABLE YOURPREFIXHERE_admin (
admin_id int(11) NOT NULL auto_increment,
admin_name varchar(32) NOT NULL default '',
admin_email varchar(96) NOT NULL default '',
admin_pass varchar(40) NOT NULL default '',
admin_level tinyint(1) NOT NULL default '1',
PRIMARY KEY (admin_id),
KEY idx_admin_name_zen (admin_name)
) TYPE=MyISAM;
Code:
INSERT INTO YOURPREFIXHERE_admin VALUES (1, 'Admin', 'admin@localhost', '351683ea4e19efe34874b501fdbf9792:9b', 1);
NOTE: the prefix is case sensative
Also, if you see both a table called:
admin
zen_admin
And you are using the prefix on your database tables, as in all start with YOURPREFIXHERE_, then the admin table should not be there ...
Bookmarks