Difference between revisions of "Qoutabase"

From SPGC Document Wiki
Jump to: navigation, search
(→‎artmaster_logs_upld)
Line 273: Line 273:
 
! Auto Increment
 
! Auto Increment
 
|-
 
|-
−
|id
+
|recid
 
|int
 
|int
−
|11
+
|25
 
|Yes
 
|Yes
 
|Yes
 
|Yes
 
|Yes
 
|Yes
 
|-
 
|-
−
|ip_address
+
|ARTMU_USER
 
|varchar
 
|varchar
−
|15
+
|25
 +
|No
 
|No
 
|No
−
|Yes
 
 
|No
 
|No
 
|-
 
|-
−
|login
+
|ARTMU_FILE
 
|varchar
 
|varchar
 
|100
 
|100
 
|No
 
|No
−
|Yes
+
|No
 
|No
 
|No
 
|-
 
|-
−
|time
+
|ARTMU_DATE
−
|int
+
|datetime
−
|30
+
|0
 +
|No
 +
|No
 +
|No
 +
|-
 +
|ARTMU_OFILE
 +
|varchar
 +
|100
 +
|No
 +
|No
 +
|No
 +
|-
 +
|ARTMU_RMARK
 +
|varchar
 +
|25
 
|No
 
|No
 
|No
 
|No
 
|No
 
|No
 
|}
 
|}

Revision as of 09:22, 8 August 2016

admin_groups

admin_groups
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
id mediumint 8 Yes Yes Yes
name varchar 20 No Yes No
description varchar 100 No Yes No

admin_login_attempts

admin_login_attempts
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
id int 11 Yes Yes Yes
ip_address varchar 15 No Yes No
login varchar 100 No Yes No
time int 30 No No No

admin_users

admin_users
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
id int 11 Yes Yes Yes
ip_address varchar 15 No Yes No
username varchar 100 No No No
password varchar 255 No Yes No
salt varchar 255 No No No
activation_code varchar 40 No No No
forgotten_password_code varchar 40 No No No
forgotten_password_time int 11 No No No
remember_code varchar 40 No No No
created_on int 11 No Yes No
last_login int 11 No No No
active tinyint 1 No Yes No
first_name varchar 50 No No No
last_name varchar 50 No No No
themes varchar 15 No No No
menu varchar 100 No No No
hmenu varchar 100 No No No
location varchar 50 No No No

admin_users_groups

admin_users_groups
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
id int 11 Yes Yes Yes
user_id int 11 No Yes No
group_id mediumint 8 No Yes No

artmaster_filetemp

artmaster_filetemp
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
mcontent varchar 150 No No No

artmaster_logs_upld

artmaster_logs_upld
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
recid int 25 Yes Yes Yes
ARTMU_USER varchar 25 No No No
ARTMU_FILE varchar 100 No No No
ARTMU_DATE datetime 0 No No No
ARTMU_OFILE varchar 100 No No No
ARTMU_RMARK varchar 25 No No No
Retrieved from "http://115.85.30.86:286/spgcwiki/index.php?title=Qoutabase&oldid=2624"