Difference between revisions of "Mysysusers"

From SPGC Document Wiki
Jump to: navigation, search
(→‎mod_sec_accs)
Line 81: Line 81:
 
|varchar
 
|varchar
 
|50
 
|50
 +
|No
 +
|No
 +
|No
 +
|}
 +
 +
==myempusers==
 +
{| class="wikitable" \
 +
!colspan="7" | myempusers
 +
|-
 +
! style="text-align:left;" | Column Name
 +
! Data Type
 +
! Length
 +
! Is PrimaryKey
 +
! Is Not Null
 +
! Auto Increment
 +
|-
 +
|myusername
 +
|varchar
 +
|10
 +
|No
 +
|No
 +
|No
 +
|-
 +
|myuserfulln
 +
|varchar
 +
|50
 +
|No
 +
|No
 +
|No
 +
|-
 +
|myuserpass
 +
|varchar
 +
|10
 +
|No
 +
|No
 +
|No
 +
|-
 +
|myuserlevel
 +
|varchar
 +
|3
 +
|No
 +
|No
 +
|No
 +
|-
 +
|myuservalis
 +
|datetime
 +
|0
 +
|No
 +
|No
 +
|No
 +
|-
 +
|myuservalie
 +
|datetime
 +
|0
 +
|No
 +
|No
 +
|No
 +
|-
 +
|myusercostc
 +
|varchar
 +
|10
 +
|No
 +
|No
 +
|No
 +
|-
 +
|myusergroup
 +
|varchar
 +
|15
 +
|No
 +
|No
 +
|No
 +
|-
 +
|myuseracomp
 +
|varchar
 +
|60
 +
|No
 +
|No
 +
|No
 +
|-
 +
|myusertype
 +
|varchar
 +
|7
 
|No
 
|No
 
|No
 
|No
 
|No
 
|No
 
|}
 
|}

Revision as of 09:29, 5 August 2016

mod_sec_accs

mod_sec_accs
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
recid int 20 Yes Yes Yes
MSA_USER varchar 10 No No No
MSA_SYS varchar 2 No No No
MSA_MODULE varchar 4 No No No
MSA_SMODULE varchar 5 No No No
MSA_ENCDTE datetime 0 No No No
MSA_MRK varchar 1 No No No

myadmin

myadmin
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
adminuser varchar 10 No No No
adminpass varchar 50 No No No

myempusers

myempusers
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
myusername varchar 10 No No No
myuserfulln varchar 50 No No No
myuserpass varchar 10 No No No
myuserlevel varchar 3 No No No
myuservalis datetime 0 No No No
myuservalie datetime 0 No No No
myusercostc varchar 10 No No No
myusergroup varchar 15 No No No
myuseracomp varchar 60 No No No
myusertype varchar 7 No No No
Retrieved from "http://115.85.30.86:286/spgcwiki/index.php?title=Mysysusers&oldid=2555"