Database Setup

Database Info ecottc_test

cron3
FieldTypePrimary
job_idint(11)Y
job_namevarchar(255)
create_datetimestamp()
cron_file3
FieldTypePrimary
cf_idint(11)Y
job_idint(11)
file_idint(11)
job_statusvarchar(20)
notevarchar(255)
log_pathvarchar(255)
update_datetimestamp()
file3
FieldTypePrimary
file_idint(11)Y
file_namevarchar(255)
file_pathvarchar(255)
file_md5varchar(255)
file_typevarchar(255)
notetext()
is_activetinyint(1)
update_datetimestamp()
groups2
FieldTypePrimary
idmediumint(8)Y
namevarchar(20)
descriptionvarchar(100)
login_attempts0
FieldTypePrimary
idint(11)Y
ip_addressvarchar(15)
loginvarchar(100)
timeint(11)
substance4016
FieldTypePrimary
substance_idint(11)Y
casbigint(20)
substance_property22
FieldTypePrimary
property_idint(11)Y
property_namevarchar(255)
property_unitvarchar(255)
is_requiredtinyint(1)
is_searchabletinyint(1)
sort_ordersmallint(5)
default_valuetext()
property_formatvarchar(255)
notevarchar(255)
substance_property_double26971
FieldTypePrimary
value_idint(11)Y
substance_idint(11)
property_idint(11)
valuedouble()
substance_property_int0
FieldTypePrimary
value_idint(11)Y
substance_idint(11)
property_idint(11)
valueint(11)
substance_property_text32
FieldTypePrimary
value_idint(11)Y
substance_idint(11)
property_idint(11)
valuetext()
substance_property_varchar61351
FieldTypePrimary
value_idint(11)Y
substance_idint(11)
property_idint(11)
valuevarchar(255)
taxonomy1751
FieldTypePrimary
taxonomy_idint(11)Y
latin_namevarchar(255)
taxonomy_property9
FieldTypePrimary
property_idint(11)Y
property_namevarchar(255)
property_unitvarchar(255)
is_requiredtinyint(1)
is_searchabletinyint(1)
sort_ordersmallint(5)
default_valuetext()
property_formatvarchar(255)
notevarchar(255)
taxonomy_property_double0
FieldTypePrimary
value_idint(11)Y
taxonomy_idint(11)
property_idint(11)
valuedouble()
taxonomy_property_int0
FieldTypePrimary
value_idint(11)Y
taxonomy_idint(11)
property_idint(11)
valueint(11)
taxonomy_property_text0
FieldTypePrimary
value_idint(11)Y
taxonomy_idint(11)
property_idint(11)
valuetext()
taxonomy_property_varchar15759
FieldTypePrimary
value_idint(11)Y
taxonomy_idint(11)
property_idint(11)
valuevarchar(255)
test91217
FieldTypePrimary
test_idint(11)Y
substance_idint(11)
taxonomy_idint(11)
test_property15
FieldTypePrimary
property_idint(11)Y
property_namevarchar(255)
property_unitvarchar(255)
is_requiredtinyint(1)
is_searchabletinyint(1)
sort_ordersmallint(5)
default_valuetext()
property_formatvarchar(255)
notevarchar(255)
test_property_double440919
FieldTypePrimary
value_idint(11)Y
test_idint(11)
property_idint(11)
valuedouble()
test_property_int0
FieldTypePrimary
value_idint(11)Y
test_idint(11)
property_idint(11)
valueint(11)
test_property_text2571
FieldTypePrimary
value_idint(11)Y
test_idint(11)
property_idint(11)
valuetext()
test_property_varchar924765
FieldTypePrimary
value_idint(11)Y
test_idint(11)
property_idint(11)
valuevarchar(255)
users1
FieldTypePrimary
idint(11)Y
ip_addressvarchar(45)
usernamevarchar(100)
passwordvarchar(255)
saltvarchar(255)
emailvarchar(100)
activation_codevarchar(40)
forgotten_password_codevarchar(40)
forgotten_password_timeint(11)
remember_codevarchar(40)
created_onint(11)
last_loginint(11)
activetinyint(1)
first_namevarchar(50)
last_namevarchar(50)
companyvarchar(100)
phonevarchar(20)
users_groups2
FieldTypePrimary
idint(11)Y
user_idint(11)
group_idmediumint(8)
Import Data