Difference between revisions of "Qoutabase"

From SPGC Document Wiki
Jump to: navigation, search
(→‎admin_users_groups)
Line 222: Line 222:
 
|-
 
|-
 
|id
 
|id
−
|mediumint
+
|int
−
|8
+
|11
 
|Yes
 
|Yes
 
|Yes
 
|Yes
 
|Yes
 
|Yes
 
|-
 
|-
−
|name
+
|user_id
−
|varchar
+
|int
−
|20
+
|11
 
|No
 
|No
 
|Yes
 
|Yes
 
|No
 
|No
 
|-
 
|-
−
|description
+
|group_id
−
|varchar
+
|mediumint
−
|100
+
|8
 
|No
 
|No
 
|Yes
 
|Yes
 
|No
 
|No
 
|}
 
|}

Revision as of 09:02, 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
Retrieved from "http://115.85.30.86:286/spgcwiki/index.php?title=Qoutabase&oldid=2620"