Difference between revisions of "Qoutabase"

From SPGC Document Wiki
Jump to: navigation, search
(→‎admin_login_attempts)
Line 67: Line 67:
 
|int
 
|int
 
|30
 
|30
 +
|No
 +
|No
 +
|No
 +
|}
 +
 +
==admin_users==
 +
{| class="wikitable" \
 +
!colspan="7" | admin_users
 +
|-
 +
! style="text-align:left;" | Column Name
 +
! Data Type
 +
! Length
 +
! Is PrimaryKey
 +
! Is Not Null
 +
! Auto Increment
 +
|-
 +
|message_id
 +
|int
 +
|11
 +
|Yes
 +
|Yes
 +
|Yes
 +
|-
 +
|user_id
 +
|int
 +
|10
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|del
 +
|tinyint
 +
|1
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|cache_key
 +
|varchar
 +
|128
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|created
 +
|datetime
 +
|0
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|idx
 +
|int
 +
|11
 +
|Yes
 +
|Yes
 +
|Yes
 +
|-
 +
|uid
 +
|int
 +
|11
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|subject
 +
|varchar
 +
|255
 +
|No
 +
|No
 +
|No
 +
|-
 +
|from
 +
|varchar
 +
|255
 +
|No
 +
|No
 +
|No
 +
|-
 +
|to
 +
|varchar
 +
|255
 +
|No
 +
|Yes
 +
|Yes
 +
|-
 +
|cc
 +
|varchar
 +
|255
 +
|No
 +
|No
 +
|No
 +
|-
 +
|date
 +
|datetime
 +
|0
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|size
 +
|int
 +
|11
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|headers
 +
|text
 +
|0
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|structure
 +
|text
 +
|0
 
|No
 
|No
 
|No
 
|No
 
|No
 
|No
 
|}
 
|}

Revision as of 08: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
message_id int 11 Yes Yes Yes
user_id int 10 No Yes No
del tinyint 1 No Yes No
cache_key varchar 128 No Yes No
created datetime 0 No Yes No
idx int 11 Yes Yes Yes
uid int 11 No Yes No
subject varchar 255 No No No
from varchar 255 No No No
to varchar 255 No Yes Yes
cc varchar 255 No No No
date datetime 0 No Yes No
size int 11 No Yes No
headers text 0 No Yes No
structure text 0 No No No
Retrieved from "http://115.85.30.86:286/spgcwiki/index.php?title=Qoutabase&oldid=2615"