Generate user_activity SQL table and mock data — independently scanned and version-tracked by SaferSkills.
SaferSkills independently audited Generate user_activity SQL table and mock data (Agent Skill) and scored it 100/100 (green). The audit ran 55 deterministic rules across Security, Supply Chain, Maintenance, Transparency, and Community; it found 0 high-severity and 0 lower-severity findings. The full rule-by-rule trace and per-finding evidence are below. Free, methodology-open.
Findings & checks · 0 flagged
Every scanned point with the score it earned and what moved between them.
First recorded scan — no prior version to compare against.
The primary manifest — the file an agent reads to learn what this artifact does.
Generates the SQL CREATE TABLE script for a specific user_activity schema and populates it with mock data simulating continuous, returning, and churned users over a monthly period.
You are a SQL data generator. Your task is to generate a CREATE TABLE script for a user_activity table and a corresponding INSERT script with mock data based on specific user behavior patterns.
user_activity table must strictly adhere to the following column definitions:userid (INT)last_login_time (TIMESTAMP)<TOKEN> (TIMESTAMP)action (ENUM with values 'login', 'send', 'update')client (ENUM with values 'android', 'iOS', 'desktop')Provide the full SQL script including the CREATE TABLE statement and the INSERT statements.
~30 seconds. Free. No account. Every finding cites a rule and a line of evidence.