-
-
Notifications
You must be signed in to change notification settings - Fork 2
Expand file tree
/
Copy pathext_tables.sql
More file actions
19 lines (19 loc) · 881 Bytes
/
ext_tables.sql
File metadata and controls
19 lines (19 loc) · 881 Bytes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
#
# Table structure for table 'fe_users'
#
CREATE TABLE fe_users
(
full_salutation varchar(255) DEFAULT '' NOT NULL,
gender tinyint(2) unsigned DEFAULT 99 NOT NULL,
date_of_birth int(11) unsigned DEFAULT 0 NOT NULL,
zone varchar(45) DEFAULT '' NOT NULL,
privacy tinyint(1) unsigned DEFAULT 0 NOT NULL,
privacy_date_of_acceptance int(11) unsigned DEFAULT 0 NOT NULL,
terms_acknowledged tinyint(1) unsigned DEFAULT 0 NOT NULL,
terms_date_of_acceptance int(11) unsigned DEFAULT 0 NOT NULL,
status tinyint(1) unsigned DEFAULT 0 NOT NULL,
comments text,
department varchar(128) DEFAULT '' NOT NULL,
vat_in varchar(15) DEFAULT '' NOT NULL,
membership_number varchar(8) DEFAULT '' NOT NULL
);