File manager - Edit - /home/linknsbh/proffy.online/database/releases/v1.1.0/v1.1.0.sql
Back
create table `sales_payments` ( `id` bigint unsigned not null auto_increment primary key, `sale_id` bigint unsigned not null, `payment_date` date not null, `payment_type` int null, `amount` double null, `created_at` timestamp null, `updated_at` timestamp null ) default character set utf8mb4 collate 'utf8mb4_unicode_ci'; alter table `sales_payments` add constraint `sales_payments_sale_id_foreign` foreign key (`sale_id`) references `sales` (`id`) on delete cascade on update cascade; alter table `sales_payments` add `reference` varchar(255) null after `sale_id`; alter table `sales_payments` add `received_amount` double null after `amount`; create table `adjustments` ( `id` bigint unsigned not null auto_increment primary key, `date` date not null, `reference_code` varchar(255) null, `warehouse_id` bigint unsigned not null, `total_products` int null, `created_at` timestamp null, `updated_at` timestamp null ) default character set utf8mb4 collate 'utf8mb4_unicode_ci'; alter table `adjustments` add constraint `adjustments_warehouse_id_foreign` foreign key (`warehouse_id`) references `warehouses` (`id`) on delete cascade on update cascade; create table `adjustment_items` ( `id` bigint unsigned not null auto_increment primary key, `adjustment_id` bigint unsigned not null, `product_id` bigint unsigned not null, `quantity` double null, `method_type` int not null, `created_at` timestamp null, `updated_at` timestamp null ) default character set utf8mb4 collate 'utf8mb4_unicode_ci'; alter table `adjustment_items` add constraint `adjustment_items_adjustment_id_foreign` foreign key (`adjustment_id`) references `adjustments` (`id`) on delete cascade on update cascade; alter table `adjustment_items` add constraint `adjustment_items_product_id_foreign` foreign key (`product_id`) references `products` (`id`) on delete cascade on update cascade;
| ver. 1.4 |
Github
|
.
| PHP 8.2.31 | Generation time: 0.64 |
proxy
|
phpinfo
|
Settings