Leetflex Banned Accounts
[]
['Create table If Not Exists LogInfo (account_id int, ip_address int, login datetime, logout datetime)', 'Truncate table LogInfo', "insert into LogInfo (account_id, ip_address, login, logout) values ('1', '1', '2021-02-01 09:00:00', '2021-02-01 09:30:00')", "insert into LogInfo (account_id, ip_address, login, logout) values ('1', '2', '2021-02-01 08:00:00', '2021-02-01 11:30:00')", "insert into LogInfo (account_id, ip_address, login, logout) values ('2', '6', '2021-02-01 20:30:00', '2021-02-01 22:00:00')", "insert into LogInfo (account_id, ip_address, login, logout) values ('2', '7', '2021-02-02 20:30:00', '2021-02-02 22:00:00')", "insert into LogInfo (account_id, ip_address, login, logout) values ('3', '9', '2021-02-01 16:00:00', '2021-02-01 16:59:59')", "insert into LogInfo (account_id, ip_address, login, logout) values ('3', '13', '2021-02-01 17:00:00', '2021-02-01 17:59:59')", "insert into LogInfo (account_id, ip_address, login, logout) values ('4', '10', '2021-02-01 16:00:00', '2021-02-01 17:00:00')", "insert into LogInfo (account_id, ip_address, login, logout) values ('4', '11', '2021-02-01 17:00:00', '2021-02-01 17:59:59')"]
{"mysql": ["Create table If Not Exists LogInfo (account_id int, ip_address int, login datetime, logout datetime)"], "mssql": ["Create table LogInfo (account_id int, ip_address int, login datetime, logout datetime)"], "oraclesql": ["Create table LogInfo (account_id int, ip_address int, login date, logout date)", "ALTER SESSION SET nls_date_format='YYYY-MM-DD HH24:MI:SS'"], "database": true, "manual": true, "name": "leetflex_banned_accnts", "pythondata": ["LogInfo = pd.DataFrame([], columns=['account_id', 'ip_address', 'login', 'logout']).astype({'account_id':'Int64', 'ip_address':'Int64', 'login':'datetime64[ns]', 'logout':'datetime64[ns]'})"], "postgresql": ["Create table If Not Exists LogInfo (account_id int, ip_address int, login timestamp, logout timestamp)\n"], "database_schema": {"LogInfo": {"account_id": "INT", "ip_address": "INT", "login": "DATETIME", "logout": "DATETIME"}}}
{"mysql": ["MySQL", "<p><code>MySQL 8.0</code>.</p>"], "mssql": ["MS SQL Server", "<p><code>mssql server 2019</code>.</p>"], "oraclesql": ["Oracle", "<p><code>Oracle Sql 11.2</code>.</p>"], "pythondata": ["Pandas", "<p>Python 3.10 with Pandas 2.2.2 and NumPy 1.26.4</p>"], "postgresql": ["PostgreSQL", "<p>PostgreSQL 16</p>"]}
['Database']