| Server IP : 35.80.110.71 / Your IP : 216.73.216.221 Web Server : Apache/2.4.58 (Ubuntu) System : Linux ip-172-31-21-44 6.17.0-1019-aws #19~24.04.1-Ubuntu SMP Tue Jun 23 18:53:06 UTC 2026 x86_64 User : ubuntu ( 1000) PHP Version : 8.3.31 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : OFF Directory : /var/www/switchyard/current/database/ |
Upload File : |
SQLite format 3 @ ^ ] G ^ .v� � S���� BK 0< +
� ���T���T$
�
�
�
Y
! � � u @ � � / a2026_06_16_120004_create_lead_events_table) U2026_06_16_120003_create_leads_table0 c2026_06_16_120002_create_lead_sources_table3 i2026_06_16_120001_create_clickup_configs_table7 q2026_06_16_120000_create_clickup_connections_table8 u 2026_06_08_170013_create_data_subject_requests_table7 s 2026_06_08_170012_create_ip_blocklist_entries_table6 q 2026_06_08_170011_create_idempotency_records_table/ c 2026_06_08_170010_create_audit_events_table4
m 2026_06_08_170009_create_delivery_attempts_table- _ 2026_06_08_170008_create_deliveries_table3 k 2026_06_08_170007_create_submission_files_table.
a 2026_06_08_170006_create_submissions_table4 m 2026_06_08_170005_create_form_destinations_table( U 2026_06_08_170004_create_forms_table+ [ 2026_06_08_170003_create_api_keys_table8 u 2026_06_08_170002_create_workspace_memberships_table7 s 2026_06_08_170001_add_current_workspace_id_to_users- _ 2026_06_08_170000_create_workspaces_table' S 0001_01_01_000002_create_jobs_table( U 0001_01_01_000001_create_cache_table( U 0001_01_01_000000_create_users_table
� �� users!migrations
� � Y
�Y �
g ! �
� x
} �
F ���O� V!� � [ � �l�7tableusersusers CREATE TABLE "users" ("id" integer primary key autoincrement not null, "name" varchar not null, "email" varchar not null, "email_verified_at" datetime, "password" varchar not null, "remember_token" varchar, "created_at" datetime, "updated_at" datetime, "current_workspace_id" varchar, "two_factor_secret" varchar, "two_factor_recovery_codes" text, "two_factor_confirmed_at" datetime, foreign key("current_workspace_id") references "workspaces"("id") on delete set null)r9!�indexworkspaces_slug_uniqueworkspacesCREATE UNIQUE INDEX "workspaces_slug_unique" on "workspaces" ("slug")3G! indexsqlite_autoindex_workspaces_1workspaces�F!!�WtableworkspacesworkspacesCREATE TABLE "workspaces" ("id" varchar not null, "name" varchar not null, "slug" varchar not null, "created_at" datetime, "updated_at" datetime, primary key ("id"))v;#�indexfailed_jobs_uuid_uniquefailed_jobsCREATE UNIQUE INDEX "failed_jobs_uuid_unique" on "failed_jobs" ("uuid")�5e#�oindexfailed_jobs_connection_queue_failed_at_indexfailed_jobsCREATE INDEX "failed_jobs_connection_queue_failed_at_index" on "failed_jobs" ("connection", "queue", "failed_at")�.##�#tablefailed_jobsfailed_jobsCREATE TABLE "failed_jobs" ("id" integer primary key autoincrement not null, "uuid" varchar not null, "connection" varchar not null, "queue" varchar not null, "payload" text not null, "exception" text not null, "failed_at" datetime not null default CURRENT_TIMESTAMP)5I# indexsqlite_autoindex_job_batches_1job_batches�`##�tablejob_batchesjob_batchesCREATE TABLE "job_batches" ("id" varchar not null, "name" varchar not null, "total_jobs" integer not null, "pending_jobs" integer not null, "failed_jobs" integer not null, "failed_job_ids" text not null, "options" text, "cancelled_at" integer, "created_at" integer not null, "finished_at" integer, primary key ("id"))��etablejobsjobsCREATE TABLE "jobs" ("id" integer primary key autoincrement not null, "queue" varchar not null, "payload" text not null, "attempts" integer not null, "reserved_at" integer, "available_at" integer not null, "created_at" integer not null)E#�#indexcache_locks_expiration_indexcache_locksCREATE INDEX "cache_locks_expiration_index" on "cache_locks" ("expiration")�$##�tablecache_lockscache_locksCREATE TABLE "cache_locks" ("key" varchar not null, "owner" varchar not null, "expiration" integer not null, primary key ("key"))5I# indexsqlite_autoindex_cache_locks_1cache_locksg
9� indexcache_expiration_indexcacheCREATE INDEX "cache_expiration_index" on "cache" ("expiration")� �}tablecachecache CREATE TABLE "cache" ("key" varchar not null, "value" text not null, "expiration" integer not null, primary key ("key"))) = indexsqlite_autoindex_cache_1cache
|
E �#indexsessions_last_activity_indexsessions CREATE INDEX "sessions_last_activity_index" on "sessions" ("last_activity")j 9 � indexsessions_user_id_indexsessions
CREATE INDEX "sessions_user_id_index" on "sessions" ("user_id")�W �tablesessionssessionsCREATE TABLE "sessions" ("id" varchar not null, "user_id" integer, "ip_address" varchar, "user_agent" text, "payload" text not null, "last_activity" integer not null, primary key ("id"))/C indexsqlite_autoindex_sessions_1sessions �>77�tablepassword_reset_tokenspassword_reset_tokensCREATE TABLE "password_reset_tokens" ("email" varchar not null, "token" varchar not null, "created_at" datetime, primary key ("email"))I]7 indexsqlite_autoindex_password_reset_tokens_1password_reset_tokens S-sindexjobs_queue_indexjobsCREATE INDEX "jobs_queue_index" on "jobs" ("queue")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)�$!!�tablemigrationsmigrationsCREATE TABLE "migrations" ("id" integer primary key autoincrement not null, "migration" varchar not null, "batch" integer not null)
� Q
2 � T
�
<����g$x � R > �:+##�;tablesubmissionssubmissions,CREATE TABLE "submissions" ("id" varchar not null, "form_id" varchar not null, "workspace_id" varchar not null, "payload" text not null, "meta" text not null, "spam_score" integer not null default '0', "spam_signals" text, "state" varchar not null default 'pending', "payload_hash" varchar not null, "pii_purged_at" datetime, "created_at" datetime, "updated_at" datetime, foreign key("form_id") references "forms"("id") on delete cascade, foreign key("workspace_id") references "workspaces"("id") on delete cascade, primary key ("id"))a 1�indexusers_email_uniqueusersCREATE UNIQUE INDEX "users_email_unique" on "users" ("email")�)*[/�Uindexform_destinations_form_id_enabled_indexform_destinations+CREATE INDEX "form_destinations_form_id_enabled_index" on "form_destinations" ("form_id", "enabled")A)U/ indexsqlite_autoindex_form_destinations_1form_destinations*� (//�otableform_destinationsform_destinations)CREATE TABLE "form_destinations" ("id" varchar not null, "form_id" varchar not null, "kind" varchar not null, "config" text not null, "enabled" tinyint(1) not null default '1', "priority" integer not null default '0', "health" varchar, "last_attempted_at" datetime, "last_health_check_at" datetime, "previous_secret" varchar, "previous_secret_expires_at" datetime, "created_at" datetime, "updated_at" datetime, foreign key("form_id") references "forms"("id") on delete cascade, primary key ("id"))j';�indexforms_archived_at_indexforms(CREATE INDEX "forms_archived_at_index" on "forms" ("archived_at")�&I�=indexforms_workspace_id_slug_uniqueforms'CREATE UNIQUE INDEX "forms_workspace_id_slug_unique" on "forms" ("workspace_id", "slug"))%= indexsqlite_autoindex_forms_1forms&�
$�ytableformsforms%CREATE TABLE "forms" ("id" varchar not null, "workspace_id" varchar not null, "slug" varchar not null, "name" varchar not null, "schema" text not null, "spam_threshold" integer not null default '50', "success_redirect_url" varchar, "cors_origins" text not null, "accept_any_origin" tinyint(1) not null default '0', "accept_any_origin_set_at" datetime, "allowed_mime_types" text, "honeypot_field" varchar not null default '_subject_honeypot', "from_email" varchar, "archived_at" datetime, "created_at" datetime, "updated_at" datetime, foreign key("workspace_id") references "workspaces"("id") on delete cascade, primary key ("id"))v#= � indexapi_keys_key_hash_uniqueapi_keys$CREATE UNIQUE INDEX "api_keys_key_hash_unique" on "api_keys" ("key_hash")� "Y �Qindexapi_keys_workspace_id_revoked_at_indexapi_keys#CREATE INDEX "api_keys_workspace_id_revoked_at_index" on "api_keys" ("workspace_id", "revoked_at")/!C indexsqlite_autoindex_api_keys_1api_keys"�* �'tableapi_keysapi_keys!CREATE TABLE "api_keys" ("id" varchar not null, "workspace_id" varchar not null, "name" varchar, "prefix" varchar not null, "key_hash" varchar not null, "last_four" varchar not null, "scopes" text not null, "last_used_at" datetime, "revoked_at" datetime, "created_at" datetime, "updated_at" datetime, foreign key("workspace_id") references "workspaces"("id") on delete cascade, primary key ("id"))�Q o7� indexworkspace_memberships_workspace_id_user_id_uniqueworkspace_memberships CREATE UNIQUE INDEX "workspace_memberships_workspace_id_user_id_unique" on "workspace_memberships" ("workspace_id", "user_id")I ]7 indexsqlite_autoindex_workspace_memberships_1workspace_memberships �, 77�wtableworkspace_membershipsworkspace_membershipsCREATE TABLE "workspace_memberships" ("id" varchar not null, "workspace_id" varchar not null, "user_id" integer not null, "role" varchar not null default 'member', "created_at" datetime, "updated_at" datetime, foreign key("user_id") references "users"("id") on delete cascade, foreign key("workspace_id") references "workspaces"("id") on delete cascade, primary key ("id"))
� : }�c� � i � � ]�������: r �-<a%�aindexaudit_events_subject_type_subject_id_indexaudit_events>CREATE INDEX "audit_events_subject_type_subject_id_index" on "audit_events" ("subject_type", "subject_id")�^9%%�tableaudit_eventsaudit_events;CREATE TABLE "audit_events" ("id" varchar not null, "workspace_id" varchar not null, "actor_type" varchar not null, "actor_id" varchar, "actor_label" varchar, "subject_type" varchar not null, "subject_id" varchar not null, "action" varchar not null, "diff" text not null, "reason" text, "created_at" datetime not null default CURRENT_TIMESTAMP, foreign key("workspace_id") references "workspaces"("id") on delete cascade, primary key ("id"))�/-a#�gindexsubmissions_form_id_state_created_at_indexsubmissions.CREATE INDEX "submissions_form_id_state_created_at_index" on "submissions" ("form_id", "state", "created_at")5,I# indexsqlite_autoindex_submissions_1submissions- ; �-;a%�aindexaudit_events_workspace_id_created_at_indexaudit_events=CREATE INDEX "audit_events_workspace_id_created_at_index" on "audit_events" ("workspace_id", "created_at")7:K% indexsqlite_autoindex_audit_events_1audit_events<�S8s/�indexdelivery_attempts_delivery_id_attempt_number_uniquedelivery_attempts:CREATE UNIQUE INDEX "delivery_attempts_delivery_id_attempt_number_unique" on "delivery_attempts" ("delivery_id", "attempt_number")A7U/ indexsqlite_autoindex_delivery_attempts_1delivery_attempts9�M6//�Itabledelivery_attemptsdelivery_attempts8CREATE TABLE "delivery_attempts" ("id" varchar not null, "delivery_id" varchar not null, "attempt_number" integer not null, "request_summary" varchar not null, "response_status" integer, "response_body_snippet" text, "latency_ms" integer, "error_code" varchar, "created_at" datetime not null default CURRENT_TIMESTAMP, foreign key("delivery_id") references "deliveries"("id") on delete cascade, primary key ("id"))�5U!�Iindexdeliveries_submission_id_state_indexdeliveries7CREATE INDEX "deliveries_submission_id_state_index" on "deliveries" ("submission_id", "state")34G! indexsqlite_autoindex_deliveries_1deliveries6�>3!!�Gtabledeliveriesdeliveries5CREATE TABLE "deliveries" ("id" varchar not null, "submission_id" varchar not null, "destination_id" varchar not null, "state" varchar not null default 'pending', "attempts" integer not null default '0', "replay_sequence" integer not null default '0', "final_status_code" integer, "last_attempted_at" datetime, "created_at" datetime, "updated_at" datetime, foreign key("submission_id") references "submissions"("id") on delete cascade, foreign key("destination_id") references "form_destinations"("id") on delete cascade, primary key ("id"))�2O-�7indexsubmission_files_scan_state_indexsubmission_files4CREATE INDEX "submission_files_scan_state_index" on "submission_files" ("scan_state")?1S- indexsqlite_autoindex_submission_files_1submission_files3�
0--�Gtablesubmission_filessubmission_files2CREATE TABLE "submission_files" ("id" varchar not null, "submission_id" varchar not null, "field_name" varchar not null, "storage_path" varchar not null, "original_name" varchar not null, "mime" varchar not null, "size" integer not null, "scan_state" varchar not null default 'pending', "scanned_at" datetime, "expires_at" datetime, "created_at" datetime, "updated_at" datetime, foreign key("submission_id") references "submissions"("id") on delete cascade, primary key ("id"))�)/_#�]indexsubmissions_workspace_id_created_at_indexsubmissions1CREATE INDEX "submissions_workspace_id_created_at_index" on "submissions" ("workspace_id", "created_at")�.U#�Iindexsubmissions_form_id_created_at_indexsubmissions/CREATE INDEX "submissions_form_id_created_at_index" on "submissions" ("form_id", "created_at")
6 �
z
3 s�&����e�
�
� � � � E ? ? �
K++�Ktableclickup_configsclickup_configsNCREATE TABLE "clickup_configs" ("id" varchar not null, "workspace_id" varchar not null, "inbound_list_id" varchar, "status_mapping" text, "custom_field_mapping" text, "default_assignee_user_id" integer, "default_priority" integer, "service_taxonomy" text, "portfolio_examples" text, "auto_route_enabled" tinyint(1) not null default '1', "created_at" datetime, "updated_at" datetime, foreign key("workspace_id") references "workspaces"("id") on delete cascade, primary key ("id"))�BGi7�qindexdata_subject_requests_workspace_id_state_indexdata_subject_requestsJCREATE INDEX "data_subject_requests_workspace_id_state_index" on "data_subject_requests" ("workspace_id", "state")�QE77�Atabledata_subject_requestsdata_subject_requestsHCREATE TABLE "data_subject_requests" ("id" varchar not null, "workspace_id" varchar not null, "email_hash" varchar not null, "reason" text not null, "state" varchar not null default 'queued', "submissions_purged" integer not null default '0', "created_at" datetime, "updated_at" datetime, "completed_at" datetime, foreign key("workspace_id") references "workspaces"("id") on delete cascade, primary key ("id"))IF]7 indexsqlite_autoindex_data_subject_requests_1data_subject_requestsI�MDq5�indexip_blocklist_entries_workspace_id_expires_at_indexip_blocklist_entriesGCREATE INDEX "ip_blocklist_entries_workspace_id_expires_at_index" on "ip_blocklist_entries" ("workspace_id", "expires_at")�#CW5�Gindexip_blocklist_entries_ip_or_cidr_indexip_blocklist_entriesFCREATE INDEX "ip_blocklist_entries_ip_or_cidr_index" on "ip_blocklist_entries" ("ip_or_cidr")�_A55�atableip_blocklist_entriesip_blocklist_entriesDCREATE TABLE "ip_blocklist_entries" ("id" varchar not null, "workspace_id" varchar, "ip_or_cidr" varchar not null, "reason" varchar, "expires_at" datetime, "created_at" datetime, "updated_at" datetime, foreign key("workspace_id") references "workspaces"("id") on delete cascade, primary key ("id"))GB[5 indexsqlite_autoindex_ip_blocklist_entries_1ip_blocklist_entriesE� @U3�Cindexidempotency_records_expires_at_indexidempotency_recordsCCREATE INDEX "idempotency_records_expires_at_index" on "idempotency_records" ("expires_at")�=?c3�qindexidempotency_records_workspace_id_key_uniqueidempotency_recordsACREATE UNIQUE INDEX "idempotency_records_workspace_id_key_unique" on "idempotency_records" ("workspace_id", "key")E>Y3 indexsqlite_autoindex_idempotency_records_1idempotency_records@�9=33�tableidempotency_recordsidempotency_records?CREATE TABLE "idempotency_records" ("id" varchar not null, "workspace_id" varchar not null, "key" varchar not null, "body_hash" varchar not null, "response" text not null, "status_code" integer not null, "expires_at" datetime not null, "created_at" datetime not null default CURRENT_TIMESTAMP, foreign key("workspace_id") references "workspaces"("id") on delete cascade, primary key ("id")) � �.J[3�[indexclickup_connections_workspace_id_uniqueclickup_connectionsMCREATE UNIQUE INDEX "clickup_connections_workspace_id_unique" on "clickup_connections" ("workspace_id")EIY3 indexsqlite_autoindex_clickup_connections_1clickup_connectionsL�'H33�utableclickup_connectionsclickup_connectionsKCREATE TABLE "clickup_connections" ("id" varchar not null, "workspace_id" varchar not null, "team_id" varchar not null, "access_token" text not null, "refresh_token" text, "access_token_expires_at" datetime, "scopes" text, "webhook_subscription_id" varchar, "webhook_secret" text, "last_sync_error" text, "connected_at" datetime, "disconnected_at" datetime, "created_at" datetime, "updated_at" datetime, foreign key("workspace_id") references "workspaces"("id") on delete cascade, primary key ("id"))
[ O
� �C
cu0�S� �� Of �XU#�Iindexlead_events_lead_id_created_at_indexlead_events\CREATE INDEX "lead_events_lead_id_created_at_index" on "lead_events" ("lead_id", "created_at")�V##�ytablelead_eventslead_eventsZCREATE TABLE "lead_events" ("id" varchar not null, "workspace_id" varchar not null, "lead_id" varchar not null, "kind" varchar not null, "payload" text, "created_at" datetime not null default CURRENT_TIMESTAMP, foreign key("workspace_id") references "workspaces"("id") on delete cascade, foreign key("lead_id") references "leads"("id") on delete cascade, primary key ("id"))5WI# indexsqlite_autoindex_lead_events_1lead_events[�US�Eindexleads_workspace_id_created_at_indexleadsYCREATE INDEX "leads_workspace_id_created_at_index" on "leads" ("workspace_id", "created_at")�TK�5indexleads_workspace_id_status_indexleadsXCREATE INDEX "leads_workspace_id_status_index" on "leads" ("workspace_id", "status")�SS�Qindexleads_source_id_external_ref_uniqueleadsWCREATE UNIQUE INDEX "leads_source_id_external_ref_unique" on "leads" ("source_id", "external_ref")�8Q�OtableleadsleadsUCREATE TABLE "leads" ("id" varchar not null, "workspace_id" varchar not null, "source_id" varchar not null, "external_ref" varchar, "raw_payload" text not null, "parsed_contact" text, "parsed_job" text, "service_tag" varchar, "suggested_examples" text, "lead_score" integer not null default '0', "status" varchar not null default 'received', "clickup_task_id" varchar, "routed_at" datetime, "won_at" datetime, "lost_at" datetime, "dismissed_at" datetime, "created_at" datetime, "updated_at" datetime, foreign key("workspace_id") references "workspaces"("id") on delete cascade, foreign key("source_id") references "lead_sources"("id") on delete cascade, primary key ("id")))R= indexsqlite_autoindex_leads_1leadsV
� �$PW%�Yindexlead_sources_workspace_id_slug_uniquelead_sourcesTCREATE UNIQUE INDEX "lead_sources_workspace_id_slug_unique" on "lead_sources" ("workspace_id", "slug")7OK% indexsqlite_autoindex_lead_sources_1lead_sourcesR�+N%%�tablelead_sourceslead_sourcesQCREATE TABLE "lead_sources" ("id" varchar not null, "workspace_id" varchar not null, "slug" varchar not null, "name" varchar not null, "kind" varchar not null, "inbound_secret" text, "field_mapping" text, "enabled" tinyint(1) not null default '1', "created_at" datetime, "updated_at" datetime, foreign key("workspace_id") references "workspaces"("id") on delete cascade, primary key ("id"))� MS+�Kindexclickup_configs_workspace_id_uniqueclickup_configsPCREATE UNIQUE INDEX "clickup_configs_workspace_id_unique" on "clickup_configs" ("workspace_id")=LQ+ indexsqlite_autoindex_clickup_configs_1clickup_configsO � �YS#�Eindexlead_events_workspace_id_kind_indexlead_events]CREATE INDEX "lead_events_workspace_id_kind_index" on "lead_events" ("workspace_id", "kind")