| Field |
Type |
Null |
Default |
| signup_model_id |
int(11) |
Yes |
NULL |
| Comment: This must be the same as the filename (model_(signup_model_id).inc.php) |
| name |
varchar(255) |
Yes |
|
| Comment: Name of signup model |
| user_signup_initial_groupids |
varchar(255) |
Yes |
|
| Comment: What extranet group shall we place user into upon signup? |
| user_signup_initial_status |
enum('pending', 'active', 'suspended') |
Yes |
pending |
| Comment: What extranet status shall the user have upon signup? |
| username_minlength |
int(11) |
Yes |
5 |
| Comment: Minimum username Length |
| email_is_username |
enum('Yes', 'No') |
Yes |
No |
| Comment: Use Email as username? (you wont need to provide a Username Field) |
| register_confirmation_email |
enum('Yes', 'No') |
Yes |
Yes |
| Comment: Send an email after registration? |
| auto_create_password |
enum('Yes', 'No') |
Yes |
No |
| Comment: Auto generate password? |
| passwordless_signup |
enum('Yes', 'No') |
Yes |
No |
| Comment: Require password for signup? |
| password_minlength |
int(11) |
Yes |
5 |
| Comment: Minimum Password Length |
| password_mand_tough |
enum('Yes', 'No') |
Yes |
No |
| Comment: Require tough password (numbers+non alphas) |
| title_mand |
enum('Yes', 'No') |
Yes |
No |
| Comment: Require Mr/Mrs/etc |
| first_name_minlength |
int(11) |
Yes |
0 |
| Comment: Minimum First Name Length |
| last_name_minlength |
int(11) |
Yes |
0 |
| Comment: Minimum Last Name Length |
| email_minlength |
int(11) |
Yes |
5 |
| Comment: Minimum Email Length |
| email_req_unique |
enum('Yes', 'No') |
Yes |
Yes |
| Comment: Allow users with same email? |
| website_minlength |
int(11) |
Yes |
0 |
| Comment: Minimum URL Length |
| job_title_minlength |
int(11) |
Yes |
0 |
| Comment: Minimum Job Title Length |
| company_name_minlength |
int(11) |
Yes |
0 |
| Comment: Minimum Company Name Length |
| address1_minlength |
int(11) |
Yes |
0 |
| Comment: |
| address2_minlength |
int(11) |
Yes |
0 |
| Comment: |
| town_minlength |
int(11) |
Yes |
0 |
| Comment: |
| state_minlength |
int(11) |
Yes |
0 |
| Comment: |
| postcode_minlength |
int(11) |
Yes |
0 |
| Comment: |
| country_id_mand |
enum('Yes', 'No') |
Yes |
No |
| Comment: Require country? |
| address_val_applies_to |
enum('res', 'bus', 'both', 'none') |
Yes |
NULL |
| Comment: Apply validation to which type of address? |
| mobile_minlength |
int(11) |
Yes |
0 |
| Comment: |
| phone_minlength |
int(11) |
Yes |
0 |
| Comment: |
| fax_minlength |
int(11) |
Yes |
0 |
| Comment: |
| spare_varchar1_minlength |
int(11) |
Yes |
0 |
| Comment: |
| spare_varchar2_minlength |
int(11) |
Yes |
0 |
| Comment: |
| spare_varchar3_minlength |
int(11) |
Yes |
0 |
| Comment: |
| spare_varchar4_minlength |
int(11) |
Yes |
0 |
| Comment: |
| spare_varchar5_minlength |
int(11) |
Yes |
0 |
| Comment: |
| spare_text1_minlength |
int(11) |
Yes |
0 |
| Comment: |
| spare_blob1_mand_notnull |
enum('Yes', 'No') |
Yes |
No |
| Comment: |
| spare_date1_mand_notnull |
enum('Yes', 'No') |
Yes |
No |
| Comment: |
| spare_date2_mand_notnull |
enum('Yes', 'No') |
Yes |
No |
| Comment: |
| spare_datetime1_mand_notnull |
enum('Yes', 'No') |
Yes |
No |
| Comment: |
| spare_datetime2_mand_notnull |
enum('Yes', 'No') |
Yes |
No |
| Comment: |
| spare_time1_mand_notnull |
enum('Yes', 'No') |
Yes |
No |
| Comment: |
| spare_time2_mand_notnull |
enum('Yes', 'No') |
Yes |
No |
| Comment: |
| spare_enum1_mand_set |
enum('Yes', 'No') |
Yes |
No |
| Comment: |
| spare_enum2_mand_set |
enum('Yes', 'No') |
Yes |
No |
| Comment: |
| spare_int1_mand_nonzero |
enum('Yes', 'No') |
Yes |
No |
| Comment: |
| spare_int2_mand_nonzero |
enum('Yes', 'No') |
Yes |
No |
| Comment: |
| spare_float1_minlength |
enum('Yes', 'No') |
Yes |
No |
| Comment: |
| spare_float2_minlength |
enum('Yes', 'No') |
Yes |
No |
| Comment: |
| consent1_mand_yes |
enum('Yes', 'No') |
Yes |
No |
| Comment: Force Consent 1? |
| consent2_mand_yes |
enum('Yes', 'No') |
Yes |
No |
| Comment: Force Consent 2? |
| consent3_mand_yes |
enum('Yes', 'No') |
Yes |
No |
| Comment: Force Consent 3? |
| post_login_target_content_id |
int(20) |
Yes |
NULL |
| Comment: Direct user to this cID after |
| post_login_target_content_type |
varchar(20) |
Yes |
NULL |
| Comment: Direct user to this cType after (requires post_login_target_content_id to be set with correct ctype) |
