SQLite format 3 @ .c � � � �
� � S�u q ��W�e �w99� tablepersonal_access_tokenspersonal_access_tokensCREATE TABLE "personal_access_tokens" ("id" integer primary key autoincrement not null, "tokenable_type" varchar not null, "tokenable_id" integer not null, "name" varchar not null, "token" varchar not null, "abilities" text, "last_used_at" datetime, "expires_at" datetime, "created_at" datetime, "updated_at" datetime)v;#�indexfailed_jobs_uuid_uniquefailed_jobsCREATE UNIQUE INDEX "failed_jobs_uuid_unique" on "failed_jobs" ("uuid")�(##�tablefailed_jobsfailed_jobsCREATE TABLE "failed_jobs" ("id" integer primary key autoincrement not null, "uuid" varchar not null, "connection" text not null, "queue" text not null, "payload" text not null, "exception" text not null, "failed_at" datetime not null default CURRENT_TIMESTAMP)�`##�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"))5I# indexsqlite_autoindex_job_batches_1job_batchesS-sindexjobs_queue_indexjobsCREATE INDEX "jobs_queue_index" on "jobs" ("queue")��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)�$
##�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_locks� �}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 Z-indexusers_nin_uniqueusersCREATE UNIQUE INDEX "users_nin_unique" on "users" ("nin")��}tableusersusersCREATE TABLE "users" ("id" integer primary key autoincrement not null, "name" varchar not null, "phone" varchar not null, "device_name" varchar, "email" varchar, "last_name" varchar, "middle_name" varchar, "dob" varchar, "gender" varchar, "nin" varchar, "status" varchar check ("status" in ('active', 'inactive')) not null default 'active', "role" varchar check ("role" in ('admin', 'seller', 'buyer')) not null default 'buyer', "last_login" varchar, "password" varchar not null, "google_id" varchar, "email_verified_at" datetime, "phone_verified_at" datetime, "remember_token" varchar, "created_at" datetime, "updated_at" datetime)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
� ���H �� 0 e 2024_04_24_234434_create_subcategories_table- _ 2024_04_24_233759_create_categories_table* Y 2024_04_23_003123_create_wallets_table9 w 2024_04_22_191640_create_personal_access_tokens_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
� � !migrations
u Y u � �
� � S�u q ��W�e � �}9�indexpersonal_access_tokens_tokenable_type_tokenable_id_indexpersonal_access_tokensCREATE INDEX "personal_access_tokens_tokenable_type_tokenable_id_index" on "personal_access_tokens" ("tokenable_type", "tokenable_id")�w99� tablepersonal_access_tokenspersonal_access_tokensCREATE TABLE "personal_access_tokens" ("id" integer primary key autoincrement not null, "tokenable_type" varchar not null, "tokenable_id" integer not null, "name" varchar not null, "token" varchar not null, "abilities" text, "last_used_at" datetime, "expires_at" datetime, "created_at" datetime, "updated_at" datetime)v;#�indexfailed_jobs_uuid_uniquefailed_jobsCREATE UNIQUE INDEX "failed_jobs_uuid_unique" on "failed_jobs" ("uuid")�(##�tablefailed_jobsfailed_jobsCREATE TABLE "failed_jobs" ("id" integer primary key autoincrement not null, "uuid" varchar not null, "connection" text not null, "queue" text not null, "payload" text not null, "exception" text not null, "failed_at" datetime not null default CURRENT_TIMESTAMP) �##�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"))5I# indexsqlite_autoindex_job_batches_1job_batches Y-sindexjobs_queue_indexjobsCREATE INDEX "jobs_queue_index" on "jobs" ("queue")��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)�$
##�tablecache_lockscache_locksCREATE TABLE "cache_locks" ("key" varchar not null, "owner" varchar not null, "expiration" integer not null, primary key ("key")) 7I# indexsqlite_autoindex_cache_locks_1cache_locks� �}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 Z-indexusers_nin_uniqueusersCREATE UNIQUE INDEX "users_nin_unique" on "users" ("nin")��}tableusersusersCREATE TABLE "users" ("id" integer primary key autoincrement not null, "name" varchar not null, "phone" varchar not null, "device_name" varchar, "email" varchar, "last_name" varchar, "middle_name" varchar, "dob" varchar, "gender" varchar, "nin" varchar, "status" varchar check ("status" in ('active', 'inactive')) not null default 'active', "role" varchar check ("role" in ('admin', 'seller', 'buyer')) not null default 'buyer', "last_login" varchar, "password" varchar not null, "google_id" varchar, "email_verified_at" datetime, "phone_verified_at" datetime, "remember_token" varchar, "created_at" datetime, "updated_at" datetime)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)
� ��p
� � 3 ��-aR� �o''� tablesubcategoriessubcategories CREATE TABLE "subcategories" ("id" integer primary key autoincrement not null, "category_id" integer not null, "name" varchar not null, "slug" varchar not null, "icon_url" varchar, "icon_public_id" varchar, "created_at" datetime, "updated_at" datetime, foreign key("category_id") references "categories"("id") on delete cascade)� !!�ctablecategoriescategories CREATE TABLE "categories" ("id" integer primary key autoincrement not null, "name" varchar not null, "slug" varchar not null, "icon_url" varchar not null, "icon_public_id" varchar not null, "created_at" datetime, "updated_at" datetime)�I�itablewalletswalletsCREATE TABLE "wallets" ("id" integer primary key autoincrement not null, "user_id" varchar not null, "balance" varchar not null, "created_at" datetime, "updated_at" datetime)�%S9�Kindexpersonal_access_tokens_token_uniquepersonal_access_tokensCREATE UNIQUE INDEX "personal_access_tokens_token_unique" on "personal_access_tokens" ("token")�a}9�indexpersonal_access_tokens_tokenable_type_tokenable_id_indexpersonal_access_tokensCREATE INDEX "personal_access_tokens_tokenable_type_tokenable_id_index" on "personal_access_tokens" ("tokenable_type", "tokenable_id")�w99� tablepersonal_access_tokenspersonal_access_tokensCREATE TABLE "personal_access_tokens" ("id" integer primary key autoincrement not null, "tokenable_type" varchar not null, "tokenable_id" integer not null, "name" varchar not null, "token" varchar not null, "abilities" text, "last_used_at" datetime, "expires_at" datetime, "created_at" datetime, "updated_at" datetime)v;#�indexfailed_jobs_uuid_uniquefailed_jobsCREATE UNIQUE INDEX "failed_jobs_uuid_unique" on "failed_jobs" ("uuid")�(##�tablefailed_jobsfailed_jobsCREATE TABLE "failed_jobs" ("id" integer primary key autoincrement not null, "uuid" varchar not null, "connection" text not null, "queue" text 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"))S-sindexjobs_queue_indexjobsCREATE INDEX "jobs_queue_index" on "jobs" ("queue")��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)5I# indexsqlite_autoindex_cache_locks_1cache_locks