Table admin

From Zen Cart(tm) Wiki

Contents 1 Database Version 2 Description 3 Table Details 3.1 Primary Key 3.2 Indexed Fields 4 Columns 4.1 admin_id 4.2 admin_name 4.3 admin_email 4.4 admin_pass 4.5 admin_level 5 Default Entries

Database Version

1.3.0.2

Description

Stores all access data to the admin panel.

Table Details

Primary Key

admin_id

Indexed Fields

admin_name

Columns

admin_id

A unique, auto incremented value, to identify each admin record.

Type:	int(11)
Null:	No
Default:
Extra:	auto_increment

admin_name

The username of the administrator account.

Type:	varchar(32)
Null:	No
Default:

admin_email

The email address of the administrator account. Checked for validation before inserting it via the admin panel. Used to reset admin password when password is forgotten by admin.

Type:	varchar(96)
Null:	No
Default:

admin_pass

Administrator password encrypted with the password function zen_encrypt_password(). The validation with an encrypted and a plain text password are made with the function zen_validate_password().

Type:	varchar(40)
Null:	No
Default:

admin_level

Admin level of the administrator account. This is used to restrict access as admin when the admin demo is setup. Can be set to 1 (full rights) or 2-9 (restricted rights).

At the present time, only 1 or 0 are used. The other values are ignored.

Type:	tinyint(1)
Null:	No
Default:	1

Default Entries

Although no default entries are loaded with a stock install (with or without demo data), they are populated when you run the install script and fill in these values via the form.