Difference between revisions of "Qoutabase"

From SPGC Document Wiki
Jump to: navigation, search
(→‎admin_users)
Line 83: Line 83:
 
! Auto Increment
 
! Auto Increment
 
|-
 
|-
−
|message_id
+
|id
 
|int
 
|int
 
|11
 
|11
Line 90: Line 90:
 
|Yes
 
|Yes
 
|-
 
|-
−
|user_id
+
|ip_address
−
|int
+
|varchar
−
|10
+
|15
 
|No
 
|No
 
|Yes
 
|Yes
 
|No
 
|No
 
|-
 
|-
−
|del
+
|username
−
|tinyint
+
|varchar
−
|1
+
|100
 +
|No
 
|No
 
|No
−
|Yes
 
 
|No
 
|No
 
|-
 
|-
−
|cache_key
+
|password
 
|varchar
 
|varchar
−
|128
+
|255
 
|No
 
|No
 
|Yes
 
|Yes
 
|No
 
|No
 
|-
 
|-
−
|created
+
|salt
−
|datetime
+
|varchar
−
|0
+
|255
 +
|No
 
|No
 
|No
−
|Yes
 
 
|No
 
|No
 
|-
 
|-
−
|idx
+
|activation_code
 +
|varchar
 +
|40
 +
|No
 +
|No
 +
|No
 +
|-
 +
|forgotten_password_code
 +
|varchar
 +
|40
 +
|No
 +
|No
 +
|No
 +
|-
 +
|forgotten_password_time
 
|int
 
|int
 
|11
 
|11
−
|Yes
+
|No
−
|Yes
+
|No
−
|Yes
+
|No
 +
|-
 +
|remember_code
 +
|varchar
 +
|40
 +
|No
 +
|No
 +
|No
 
|-
 
|-
−
|uid
+
|created_on
 
|int
 
|int
 
|11
 
|11
Line 132: Line 153:
 
|No
 
|No
 
|-
 
|-
−
|subject
+
|last_login
−
|varchar
+
|int
−
|255
+
|11
 
|No
 
|No
 
|No
 
|No
 
|No
 
|No
 
|-
 
|-
−
|from
+
|active
−
|varchar
+
|tinyint
−
|255
+
|1
−
|No
+
 
|No
 
|No
 +
|Yes
 
|No
 
|No
 
|-
 
|-
−
|to
+
|first_name
 
|varchar
 
|varchar
−
|255
+
|50
 
|No
 
|No
 
|Yes
 
|Yes
−
|Yes
+
|No
 
|-
 
|-
−
|cc
+
|last_name
 
|varchar
 
|varchar
−
|255
+
|50
−
|No
+
 
|No
 
|No
 +
|Yes
 
|No
 
|No
 
|-
 
|-
−
|date
+
|themes
−
|datetime
+
|varchar
−
|0
+
|15
 +
|No
 
|No
 
|No
−
|Yes
 
 
|No
 
|No
 
|-
 
|-
−
|size
+
|menu
−
|int
+
|varchar
−
|11
+
|100
 +
|No
 
|No
 
|No
−
|Yes
 
 
|No
 
|No
 
|-
 
|-
−
|headers
+
|hmenu
−
|text
+
|varchar
−
|0
+
|100
 
|No
 
|No
 
|Yes
 
|Yes
 
|No
 
|No
 
|-
 
|-
−
|structure
+
|location
−
|text
+
|varchar
−
|0
+
|50
 
|No
 
|No
 
|No
 
|No
 
|No
 
|No
 
|}
 
|}

Revision as of 08:54, 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 Yes No
last_name varchar 50 No Yes No
themes varchar 15 No No No
menu varchar 100 No No No
hmenu varchar 100 No Yes No
location varchar 50 No No No
Retrieved from "http://115.85.30.86:286/spgcwiki/index.php?title=Qoutabase&oldid=2616"