plugins/sys/share/db/sql_php/check_multi_accounts.sql_php.php
<?php
return [
'fields' => [
'user_id' => [
'name' => 'user_id',
'type' => 'int',
'length' => 10,
'decimals' => null,
'unsigned' => true,
'nullable' => false,
'default' => null,
'charset' => null,
'collate' => null,
'auto_inc' => false,
'primary' => true,
'unique' => false,
'values' => null,
],
'matching_users' => [
'name' => 'matching_users',
'type' => 'longtext',
'length' => null,
'decimals' => null,
'unsigned' => null,
'nullable' => false,
'default' => null,
'charset' => null,
'collate' => null,
'auto_inc' => false,
'primary' => false,
'unique' => false,
'values' => null,
],
'matching_ips' => [
'name' => 'matching_ips',
'type' => 'longtext',
'length' => null,
'decimals' => null,
'unsigned' => null,
'nullable' => false,
'default' => null,
'charset' => null,
'collate' => null,
'auto_inc' => false,
'primary' => false,
'unique' => false,
'values' => null,
],
'num_m_users' => [
'name' => 'num_m_users',
'type' => 'int',
'length' => 10,
'decimals' => null,
'unsigned' => true,
'nullable' => false,
'default' => '0',
'charset' => null,
'collate' => null,
'auto_inc' => false,
'primary' => false,
'unique' => false,
'values' => null,
],
'num_m_ips' => [
'name' => 'num_m_ips',
'type' => 'int',
'length' => 10,
'decimals' => null,
'unsigned' => true,
'nullable' => false,
'default' => '0',
'charset' => null,
'collate' => null,
'auto_inc' => false,
'primary' => false,
'unique' => false,
'values' => null,
],
'last_update' => [
'name' => 'last_update',
'type' => 'int',
'length' => 10,
'decimals' => null,
'unsigned' => true,
'nullable' => false,
'default' => '0',
'charset' => null,
'collate' => null,
'auto_inc' => false,
'primary' => false,
'unique' => false,
'values' => null,
],
'cookie_match' => [
'name' => 'cookie_match',
'type' => 'enum',
'length' => null,
'decimals' => null,
'unsigned' => null,
'nullable' => false,
'default' => '0',
'charset' => null,
'collate' => null,
'auto_inc' => false,
'primary' => false,
'unique' => false,
'values' => [
0 => '0',
1 => '1',
],
],
'ip_match' => [
'name' => 'ip_match',
'type' => 'enum',
'length' => null,
'decimals' => null,
'unsigned' => null,
'nullable' => false,
'default' => null,
'charset' => null,
'collate' => null,
'auto_inc' => false,
'primary' => false,
'unique' => false,
'values' => [
0 => '0',
1 => '1',
],
],
],
'indexes' => [
'PRIMARY' => [
'name' => 'PRIMARY',
'type' => 'primary',
'columns' => [
'user_id' => 'user_id',
],
],
'ip_match' => [
'name' => 'ip_match',
'type' => 'index',
'columns' => [
'ip_match' => 'ip_match',
],
],
'cookie_match' => [
'name' => 'cookie_match',
'type' => 'index',
'columns' => [
'cookie_match' => 'cookie_match',
],
],
],
'foreign_keys' => [
],
'options' => [
],
];