SQLite format 3 @ ! ! ._ � �
� z
; o I
� �
Z� ����Z�T�
� �j�3tablecartscartsCREATE TABLE "carts" ("id" integer primary key autoincrement not null, "user_id" integer not null, "created_at" datetime, "updated_at" datetime, foreign key("user_id") references "users"("id") on delete cascade)� U!�Uindexcart_items_cart_id_product_id_uniquecart_itemsCREATE UNIQUE INDEX "cart_items_cart_id_product_id_unique" on "cart_items" ("cart_id", "product_id")�/!!�)tablecart_itemscart_itemsCREATE TABLE "cart_items" ("id" integer primary key autoincrement not null, "cart_id" integer not null, "product_id" integer not null, "quantity" integer not null default '1', "unit_price_cents" integer not null, "created_at" datetime, "updated_at" datetime, foreign key("cart_id") references "carts"("id") on delete cascade, foreign key("product_id") references "products"("id") on delete cascade)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 a1�indexusers_email_uniqueusersCREATE UNIQUE INDEX "users_email_unique" on "users" ("email")��tableusersusersCREATE 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)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
o ���S(���o , [2026_01_19_014647_create_payments_table* W2026_01_19_014647_create_orders_table/ a2026_01_19_014647_create_order_items_table, [2026_01_19_014646_create_products_table) U2026_01_19_014646_create_carts_table. _2026_01_19_014646_create_cart_items_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
[ [ �"
-3�!33Test Usertest@example.com2026-01-19 02:00:38$2y$12$MPndIQajvHc1tyoTWoHcZulAdbMSV61/.HTR.yTpSnfLtr05Sncg2uANcYBJgzh2026-01-19 02:00:392026-01-19 02:00:39
� � - test@example.com
� � Y
�
� z
; o I
� �
Z� ����Z�T�
�
�~�3tablecartscartsCREATE TABLE "carts" ("id" integer primary key autoincrement not null, "user_id" integer not null, "created_at" datetime, "updated_at" datetime, foreign key("user_id") references "users"("id") on delete cascade)� U!�Uindexcart_items_cart_id_product_id_uniquecart_itemsCREATE UNIQUE INDEX "cart_items_cart_id_product_id_unique" on "cart_items" ("cart_id", "product_id")�/!!�)tablecart_itemscart_itemsCREATE TABLE "cart_items" ("id" integer primary key autoincrement not null, "cart_id" integer not null, "product_id" integer not null, "quantity" integer not null default '1', "unit_price_cents" integer not null, "created_at" datetime, "updated_at" datetime, foreign key("cart_id") references "carts"("id") on delete cascade, foreign key("product_id") references "products"("id") on delete cascade)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 a1�indexusers_email_uniqueusersCREATE UNIQUE INDEX "users_email_unique" on "users" ("email")��tableusersusersCREATE 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)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)
& �f
; �
o ����& �u �=tablepaymentspayments CREATE TABLE "payments" ("id" integer primary key autoincrement not null, "order_id" integer not null, "provider" varchar not null default 'fpx', "status" varchar not null default 'initiated', "reference" varchar, "payload" text, "created_at" datetime, "updated_at" datetime, foreign key("order_id") references "orders"("id") on delete cascade)n 9�indexorders_order_no_uniqueorders CREATE UNIQUE INDEX "orders_order_no_unique" on "orders" ("order_no")�E�etableordersorders CREATE TABLE "orders" ("id" integer primary key autoincrement not null, "user_id" integer not null, "order_no" varchar not null, "subtotal_cents" integer not null default '0', "total_cents" integer not null default '0', "status" varchar not null default 'pending', "customer_name" varchar, "customer_phone" varchar, "created_at" datetime, "updated_at" datetime, foreign key("user_id") references "users"("id") on delete cascade)�N##�ctableorder_itemsorder_items CREATE TABLE "order_items" ("id" integer primary key autoincrement not null, "order_id" integer not null, "product_id" integer not null, "quantity" integer not null, "unit_price_cents" integer not null, "line_total_cents" integer not null, "created_at" datetime, "updated_at" datetime, foreign key("order_id") references "orders"("id") on delete cascade, foreign key("product_id") references "products"("id") on delete cascade)j5 �indexproducts_slug_uniqueproducts CREATE UNIQUE INDEX "products_slug_unique" on "products" ("slug")�l �+tableproductsproductsCREATE TABLE "products" ("id" integer primary key autoincrement not null, "slug" varchar not null, "name" varchar not null, "short_description" text, "description" text, "video_url" varchar, "hero_image" varchar, "price_cents" integer not null, "is_active" tinyint(1) not null default '1', "created_at" datetime, "updated_at" datetime)�j�3tablecartscartsCREATE TABLE "carts" ("id" integer primary key autoincrement not null, "user_id" integer not null, "created_at" datetime, "updated_at" datetime, foreign key("user_id") references "users"("id") on delete cascade)� U!�Uindexcart_items_cart_id_product_id_uniquecart_itemsCREATE UNIQUE INDEX "cart_items_cart_id_product_id_unique" on "cart_items" ("cart_id", "product_id")�/!!�)tablecart_itemscart_itemsCREATE TABLE "cart_items" ("id" integer primary key autoincrement not null, "cart_id" integer not null, "product_id" integer not null, "quantity" integer not null default '1', "unit_price_cents" integer not null, "created_at" datetime, "updated_at" datetime, foreign key("cart_id") references "carts"("id") on delete cascade, foreign key("product_id") references "products"("id") on delete cascade)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"))