***** tables for new prelude/prewikka databases **************************************************************************************** *************************** prelude database show tables; +-------------------------------+ | Tables_in_prelude | +-------------------------------+ | Prelude_Action | | Prelude_AdditionalData | | Prelude_Address | | Prelude_Alert | | Prelude_Alertident | | Prelude_Analyzer | | Prelude_AnalyzerTime | | Prelude_Assessment | | Prelude_Checksum | | Prelude_Classification | | Prelude_Confidence | | Prelude_CorrelationAlert | | Prelude_CreateTime | | Prelude_DetectTime | | Prelude_File | | Prelude_FileAccess | | Prelude_FileAccess_Permission | | Prelude_Heartbeat | | Prelude_Impact | | Prelude_Inode | | Prelude_Linkage | | Prelude_Node | | Prelude_OverflowAlert | | Prelude_Process | | Prelude_ProcessArg | | Prelude_ProcessEnv | | Prelude_Reference | | Prelude_Service | | Prelude_SnmpService | | Prelude_Source | | Prelude_Target | | Prelude_ToolAlert | | Prelude_User | | Prelude_UserId | | Prelude_WebService | | Prelude_WebServiceArg | | _format | +-------------------------------+ describe Prelude_Action; +----------------+---------------------------------------------------------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+---------------------------------------------------------------------+------+-----+---------+-------+ | _message_ident | bigint(20) unsigned | NO | PRI | | | | _index | tinyint(4) | NO | PRI | | | | description | varchar(255) | YES | | | | | category | enum('block-installed','notification-sent','taken-offline','other') | NO | | | | +----------------+---------------------------------------------------------------------+------+-----+---------+-------+ describe Prelude_AdditionalData; +----------------+--------------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+--------------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+ | _message_ident | bigint(20) unsigned | NO | PRI | | | | _parent_type | enum('A','H') | NO | PRI | | | | _index | tinyint(4) | NO | PRI | | | | type | enum('boolean','byte','character','date-time','integer','ntpstamp','portlist','real','string','byte-string','xml') | NO | | | | | meaning | varchar(255) | YES | | | | | data | blob | NO | | | | +----------------+--------------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+ describe Prelude_Address; +----------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+ | _message_ident | bigint(20) unsigned | NO | PRI | | | | _parent_type | enum('A','H','S','T') | NO | PRI | | | | _parent0_index | tinyint(4) | NO | PRI | | | | _index | tinyint(4) | NO | PRI | | | | ident | varchar(255) | YES | | | | | category | enum('unknown','atm','e-mail','lotus-notes','mac','sna','vm','ipv4-addr','ipv4-addr-hex','ipv4-net','ipv4-net-mask','ipv6-addr','ipv6-addr-hex','ipv6-net','ipv6-net-mask') | NO | | | | | vlan_name | varchar(255) | YES | | | | | vlan_num | int(10) unsigned | YES | | | | | address | varchar(255) | NO | | | | | netmask | varchar(255) | YES | | | | +----------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+ describe Prelude_Alert; +-----------+---------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------+---------------------+------+-----+---------+----------------+ | _ident | bigint(20) unsigned | NO | PRI | | auto_increment | | messageid | varchar(255) | YES | MUL | | | +-----------+---------------------+------+-----+---------+----------------+ describe Prelude_Alertident; +----------------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+---------------------+------+-----+---------+-------+ | _message_ident | bigint(20) unsigned | NO | PRI | | | | _index | tinyint(4) | NO | PRI | | | | _parent_type | enum('T','C') | NO | PRI | | | | alertident | varchar(255) | NO | | | | | analyzerid | varchar(255) | YES | | | | +----------------+---------------------+------+-----+---------+-------+ describe Prelude_Analyzer; +----------------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+---------------------+------+-----+---------+-------+ | _message_ident | bigint(20) unsigned | NO | PRI | | | | _parent_type | enum('A','H') | NO | PRI | | | | _index | tinyint(4) | NO | PRI | | | | analyzerid | varchar(255) | YES | | | | | name | varchar(255) | YES | | | | | manufacturer | varchar(255) | YES | | | | | model | varchar(255) | YES | | | | | version | varchar(255) | YES | | | | | class | varchar(255) | YES | | | | | ostype | varchar(255) | YES | | | | | osversion | varchar(255) | YES | | | | +----------------+---------------------+------+-----+---------+-------+ describe Prelude_AnalyzerTime; +----------------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+---------------------+------+-----+---------+-------+ | _message_ident | bigint(20) unsigned | NO | PRI | | | | _parent_type | enum('A','H') | NO | PRI | | | | time | datetime | NO | | | | | usec | int(10) unsigned | NO | | | | | gmtoff | int(11) | NO | | | | +----------------+---------------------+------+-----+---------+-------+ describe Prelude_Assessment; +----------------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+---------------------+------+-----+---------+-------+ | _message_ident | bigint(20) unsigned | NO | PRI | | | +----------------+---------------------+------+-----+---------+-------+ describe Prelude_Checksum; +----------------+-------------------------------------------------------------------------------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+-------------------------------------------------------------------------------------------+------+-----+---------+-------+ | _message_ident | bigint(20) unsigned | NO | PRI | | | | _parent0_index | tinyint(4) | NO | PRI | | | | _parent1_index | tinyint(4) | NO | PRI | | | | _index | tinyint(4) | NO | PRI | | | | algorithm | enum('md4','md5','sha1','sha2-256','sha2-384','sha2-512','crc-32','haval','tiger','gost') | NO | | | | | value | varchar(255) | NO | | | | | checksum_key | varchar(255) | YES | | | | +----------------+-------------------------------------------------------------------------------------------+------+-----+---------+-------+ describe Prelude_Classification; +----------------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+---------------------+------+-----+---------+-------+ | _message_ident | bigint(20) unsigned | NO | PRI | | | | ident | varchar(255) | YES | | | | | text | varchar(255) | NO | MUL | | | +----------------+---------------------+------+-----+---------+-------+ describe Prelude_Confidence; +----------------+---------------------------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+---------------------------------------+------+-----+---------+-------+ | _message_ident | bigint(20) unsigned | NO | PRI | | | | confidence | float | YES | | | | | rating | enum('low','medium','high','numeric') | NO | | | | +----------------+---------------------------------------+------+-----+---------+-------+ describe Prelude_CorrelationAlert; +----------------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+---------------------+------+-----+---------+-------+ | _message_ident | bigint(20) unsigned | NO | PRI | | | | name | varchar(255) | NO | | | | +----------------+---------------------+------+-----+---------+-------+ describe Prelude_CreateTime; +----------------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+---------------------+------+-----+---------+-------+ | _message_ident | bigint(20) unsigned | NO | PRI | | | | _parent_type | enum('A','H') | NO | PRI | | | | time | datetime | NO | | | | | usec | int(10) unsigned | NO | | | | | gmtoff | int(11) | NO | | | | +----------------+---------------------+------+-----+---------+-------+ describe Prelude_DetectTime; +----------------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+---------------------+------+-----+---------+-------+ | _message_ident | bigint(20) unsigned | NO | PRI | | | | time | datetime | NO | MUL | | | | usec | int(10) unsigned | NO | | | | | gmtoff | int(11) | NO | | | | +----------------+---------------------+------+-----+---------+-------+ describe Prelude_File; +--------------------+--------------------------------------------------------------------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------------+--------------------------------------------------------------------------------+------+-----+---------+-------+ | _message_ident | bigint(20) unsigned | NO | PRI | | | | _parent0_index | tinyint(4) | NO | PRI | | | | _index | tinyint(4) | NO | PRI | | | | ident | varchar(255) | YES | | | | | path | varchar(255) | NO | | | | | name | varchar(255) | NO | | | | | category | enum('current','original') | YES | | | | | create_time | datetime | YES | | | | | create_time_gmtoff | int(11) | YES | | | | | modify_time | datetime | YES | | | | | modify_time_gmtoff | int(11) | YES | | | | | access_time | datetime | YES | | | | | access_time_gmtoff | int(11) | YES | | | | | data_size | int(10) unsigned | YES | | | | | disk_size | int(10) unsigned | YES | | | | | fstype | enum('ufs','efs','nfs','afs','ntfs','fat16','fat32','pcfs','joliet','iso9660') | YES | | | | | file_type | varchar(255) | YES | | | | +--------------------+--------------------------------------------------------------------------------+------+-----+---------+-------+ describe Prelude_FileAccess; +----------------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+---------------------+------+-----+---------+-------+ | _message_ident | bigint(20) unsigned | NO | PRI | | | | _parent0_index | tinyint(4) | NO | PRI | | | | _parent1_index | tinyint(4) | NO | PRI | | | | _index | tinyint(4) | NO | PRI | | | +----------------+---------------------+------+-----+---------+-------+ describe Prelude_FileAccess_Permission; +----------------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+---------------------+------+-----+---------+-------+ | _message_ident | bigint(20) unsigned | NO | PRI | | | | _parent0_index | tinyint(4) | NO | PRI | | | | _parent1_index | tinyint(4) | NO | PRI | | | | _parent2_index | tinyint(4) | NO | PRI | | | | _index | tinyint(4) | NO | PRI | | | | permission | varchar(255) | NO | | | | +----------------+---------------------+------+-----+---------+-------+ describe Prelude_Heartbeat; +--------------------+---------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------------+---------------------+------+-----+---------+----------------+ | _ident | bigint(20) unsigned | NO | PRI | | auto_increment | | messageid | varchar(255) | YES | | | | | heartbeat_interval | int(11) | YES | | | | +--------------------+---------------------+------+-----+---------+----------------+ describe Prelude_Impact; +----------------+---------------------------------------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+---------------------------------------------------+------+-----+---------+-------+ | _message_ident | bigint(20) unsigned | NO | PRI | | | | description | varchar(255) | YES | | | | | severity | enum('info','low','medium','high') | YES | MUL | | | | completion | enum('failed','succeeded') | YES | MUL | | | | type | enum('admin','dos','file','recon','user','other') | NO | MUL | | | +----------------+---------------------------------------------------+------+-----+---------+-------+ describe Prelude_Inode; +--------------------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------------+---------------------+------+-----+---------+-------+ | _message_ident | bigint(20) unsigned | NO | PRI | | | | _parent0_index | tinyint(4) | NO | PRI | | | | _parent1_index | tinyint(4) | NO | PRI | | | | change_time | datetime | YES | | | | | change_time_gmtoff | int(11) | YES | | | | | number | int(10) unsigned | YES | | | | | major_device | int(10) unsigned | YES | | | | | minor_device | int(10) unsigned | YES | | | | | c_major_device | int(10) unsigned | YES | | | | | c_minor_device | int(10) unsigned | YES | | | | +--------------------+---------------------+------+-----+---------+-------+ describe Prelude_Linkage; +----------------+-------------------------------------------------------------------------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+-------------------------------------------------------------------------------------+------+-----+---------+-------+ | _message_ident | bigint(20) unsigned | NO | PRI | | | | _parent0_index | tinyint(4) | NO | PRI | | | | _parent1_index | tinyint(4) | NO | PRI | | | | _index | tinyint(4) | NO | PRI | | | | category | enum('hard-link','mount-point','reparse-point','shortcut','stream','symbolic-link') | NO | | | | | name | varchar(255) | NO | | | | | path | varchar(255) | NO | | | | +----------------+-------------------------------------------------------------------------------------+------+-----+---------+-------+ describe Prelude_Node; +----------------+----------------------------------------------------------------------------------------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+----------------------------------------------------------------------------------------------------+------+-----+---------+-------+ | _message_ident | bigint(20) unsigned | NO | PRI | | | | _parent_type | enum('A','H','S','T') | NO | PRI | | | | _parent0_index | tinyint(4) | NO | PRI | | | | ident | varchar(255) | YES | | | | | category | enum('unknown','ads','afs','coda','dfs','dns','hosts','kerberos','nds','nis','nisplus','nt','wfw') | YES | | | | | location | varchar(255) | YES | | | | | name | varchar(255) | YES | | | | +----------------+----------------------------------------------------------------------------------------------------+------+-----+---------+-------+ describe Prelude_OverflowAlert; +----------------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+---------------------+------+-----+---------+-------+ | _message_ident | bigint(20) unsigned | NO | PRI | | | | program | varchar(255) | NO | | | | | size | int(10) unsigned | YES | | | | | buffer | blob | YES | | | | +----------------+---------------------+------+-----+---------+-------+ describe Prelude_Process; +----------------+-----------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+-----------------------+------+-----+---------+-------+ | _message_ident | bigint(20) unsigned | NO | PRI | | | | _parent_type | enum('A','H','S','T') | NO | PRI | | | | _parent0_index | tinyint(4) | NO | PRI | | | | ident | varchar(255) | YES | | | | | name | varchar(255) | NO | | | | | pid | int(10) unsigned | YES | | | | | path | varchar(255) | YES | | | | +----------------+-----------------------+------+-----+---------+-------+ describe Prelude_ProcessArg; +----------------+-----------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+-----------------------+------+-----+---------+-------+ | _message_ident | bigint(20) unsigned | NO | PRI | | | | _parent_type | enum('A','H','S','T') | NO | PRI | A | | | _parent0_index | tinyint(4) | NO | PRI | | | | _index | tinyint(4) | NO | PRI | | | | arg | varchar(255) | NO | | | | +----------------+-----------------------+------+-----+---------+-------+ describe Prelude_ProcessEnv; +----------------+-----------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+-----------------------+------+-----+---------+-------+ | _message_ident | bigint(20) unsigned | NO | PRI | | | | _parent_type | enum('A','H','S','T') | NO | PRI | | | | _parent0_index | tinyint(4) | NO | PRI | | | | _index | tinyint(4) | NO | PRI | | | | env | varchar(255) | NO | | | | +----------------+-----------------------+------+-----+---------+-------+ describe Prelude_Reference; +----------------+-----------------------------------------------------------------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+-----------------------------------------------------------------------------+------+-----+---------+-------+ | _message_ident | bigint(20) unsigned | NO | PRI | | | | _index | tinyint(4) | NO | PRI | | | | origin | enum('unknown','vendor-specific','user-specific','bugtraqid','cve','osvdb') | NO | | | | | name | varchar(255) | NO | MUL | | | | url | varchar(255) | NO | | | | | meaning | varchar(255) | YES | | | | +----------------+-----------------------------------------------------------------------------+------+-----+---------+-------+ describe Prelude_Service; +----------------------+----------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------------+----------------------+------+-----+---------+-------+ | _message_ident | bigint(20) unsigned | NO | PRI | | | | _parent_type | enum('S','T') | NO | PRI | | | | _parent0_index | bigint(20) | NO | PRI | | | | ident | varchar(255) | YES | | | | | ip_version | tinyint(3) unsigned | YES | | | | | name | varchar(255) | YES | | | | | port | smallint(5) unsigned | YES | | | | | iana_protocol_number | tinyint(3) unsigned | YES | | | | | iana_protocol_name | varchar(255) | YES | | | | | portlist | varchar(255) | YES | | | | | protocol | varchar(255) | YES | | | | +----------------------+----------------------+------+-----+---------+-------+ describe Prelude_SnmpService; +-------------------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------------+---------------------+------+-----+---------+-------+ | _message_ident | bigint(20) unsigned | NO | PRI | | | | _parent_type | enum('S','T') | NO | PRI | | | | _parent0_index | tinyint(4) | NO | PRI | | | | snmp_oid | varchar(255) | YES | | | | | community | varchar(255) | YES | | | | | security_name | varchar(255) | YES | | | | | context_name | varchar(255) | YES | | | | | context_engine_id | varchar(255) | YES | | | | | command | varchar(255) | YES | | | | +-------------------+---------------------+------+-----+---------+-------+ describe Prelude_Source; +----------------+----------------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+----------------------------+------+-----+---------+-------+ | _message_ident | bigint(20) unsigned | NO | PRI | | | | _index | tinyint(4) | NO | PRI | | | | ident | varchar(255) | YES | | | | | spoofed | enum('unknown','yes','no') | NO | | | | | interface | varchar(255) | YES | | | | +----------------+----------------------------+------+-----+---------+-------+ describe Prelude_Target; +----------------+----------------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+----------------------------+------+-----+---------+-------+ | _message_ident | bigint(20) unsigned | NO | PRI | | | | _index | tinyint(4) | NO | PRI | | | | ident | varchar(255) | YES | | | | | decoy | enum('unknown','yes','no') | NO | | | | | interface | varchar(255) | YES | | | | +----------------+----------------------------+------+-----+---------+-------+ describe Prelude_ToolAlert; +----------------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+---------------------+------+-----+---------+-------+ | _message_ident | bigint(20) unsigned | NO | PRI | | | | name | varchar(255) | NO | | | | | command | varchar(255) | YES | | | | +----------------+---------------------+------+-----+---------+-------+ describe Prelude_User; +----------------+-------------------------------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+-------------------------------------------+------+-----+---------+-------+ | _message_ident | bigint(20) unsigned | NO | PRI | | | | _parent_type | enum('S','T') | NO | PRI | | | | _parent0_index | tinyint(4) | NO | PRI | | | | ident | varchar(255) | YES | | | | | category | enum('unknown','application','os-device') | NO | | | | +----------------+-------------------------------------------+------+-----+---------+-------+ describe Prelude_UserId; +----------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+ | _message_ident | bigint(20) unsigned | NO | PRI | | | | _parent_type | enum('S','T','F') | NO | PRI | | | | _parent0_index | tinyint(4) | NO | PRI | | | | _parent1_index | tinyint(4) | NO | PRI | | | | _parent2_index | tinyint(4) | NO | PRI | | | | _index | tinyint(4) | NO | PRI | | | | ident | varchar(255) | YES | | | | | type | enum('current-user','original-user','target-user','user-privs','current-group','group-privs','other-privs') | NO | | | | | name | varchar(255) | YES | | | | | tty | varchar(255) | YES | | | | | number | int(10) unsigned | YES | | | | +----------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+ describe Prelude_WebService; +----------------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+---------------------+------+-----+---------+-------+ | _message_ident | bigint(20) unsigned | NO | PRI | | | | _parent_type | enum('S','T') | NO | PRI | | | | _parent0_index | tinyint(4) | NO | PRI | | | | url | varchar(255) | NO | | | | | cgi | varchar(255) | YES | | | | | http_method | varchar(255) | YES | | | | +----------------+---------------------+------+-----+---------+-------+ describe Prelude_WebServiceArg; +----------------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+---------------------+------+-----+---------+-------+ | _message_ident | bigint(20) unsigned | NO | PRI | | | | _parent_type | enum('S','T') | NO | PRI | | | | _parent0_index | tinyint(4) | NO | PRI | | | | _index | tinyint(4) | NO | PRI | | | | arg | varchar(255) | NO | | | | +----------------+---------------------+------+-----+---------+-------+ describe _format; +---------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------+--------------+------+-----+---------+-------+ | name | varchar(255) | NO | | | | | version | varchar(255) | NO | | | | +---------+--------------+------+-----+---------+-------+ **************************************************************************************** *************************** prewikka database +-----------------------------+ | Tables_in_prewikka | +-----------------------------+ | Prewikka_Filter | | Prewikka_Filter_Criterion | | Prewikka_Permission | | Prewikka_Session | | Prewikka_User | | Prewikka_User_Configuration | | Prewikka_Version | +-----------------------------+ describe Prewikka_Filter; +---------+---------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------+---------------------+------+-----+---------+----------------+ | id | bigint(20) unsigned | | PRI | NULL | auto_increment | | login | varchar(32) | | MUL | | | | name | varchar(64) | | | | | | comment | varchar(255) | YES | | NULL | | | formula | varchar(255) | | | | | +---------+---------------------+------+-----+---------+----------------+ describe Prewikka_Filter_Criterion; +----------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+---------------------+------+-----+---------+-------+ | id | bigint(20) unsigned | | MUL | 0 | | | name | varchar(16) | | | | | | path | varchar(255) | | | | | | operator | varchar(8) | YES | | NULL | | | value | varchar(255) | YES | | NULL | | +----------+---------------------+------+-----+---------+-------+ describe Prewikka_Permission; +------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+-------------+------+-----+---------+-------+ | login | varchar(32) | | MUL | | | | permission | varchar(32) | | | | | +------------+-------------+------+-----+---------+-------+ describe Prewikka_Session; +-----------+--------------+------+-----+---------------------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+--------------+------+-----+---------------------+-------+ | sessionid | varchar(128) | | PRI | | | | login | varchar(32) | | MUL | | | | time | datetime | | | 0000-00-00 00:00:00 | | +-----------+--------------+------+-----+---------------------+-------+ describe Prewikka_User; +----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+-------------+------+-----+---------+-------+ | login | varchar(32) | | PRI | | | | password | varchar(32) | YES | | NULL | | | email | varchar(64) | YES | | NULL | | +----------+-------------+------+-----+---------+-------+ describe Prewikka_User_Configuration; +-------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------+--------------+------+-----+---------+-------+ | login | varchar(32) | | | | | | view | varchar(32) | | | | | | name | varchar(255) | | MUL | | | | value | varchar(255) | YES | | NULL | | +-------+--------------+------+-----+---------+-------+ describe Prewikka_Version; +---------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------+--------------+------+-----+---------+-------+ | version | varchar(255) | | | | | +---------+--------------+------+-----+---------+-------+