· 4 years ago · Dec 21, 2020, 09:18 AM
1
2create table `keys` (`id` int unsigned not null auto_increment primary key, `name` varchar(191) null, `slug` varchar(191) null, `secret_key` varchar(191) null, `description` text null, `status` tinyint not null default '1', `created_at` timestamp null, `updated_at` timestamp null) default character set utf8mb4 collate utf8mb4_unicode_ci
3
4create table `mapping_store_users` (`id` int unsigned not null auto_increment primary key, `full_name` varchar(191) null, `phone_number` varchar(50) null, `store_id` int unsigned not null, `status_verification` int DEFAULT 0, `created_at` timestamp null, `updated_at` timestamp null) default character set utf8mb4 collate utf8mb4_unicode_ci
5alter table `mapping_store_users` add constraint `mapping_store_users_user_id_foreign` foreign key (`user_id`) references `users` (`id`)
6alter table `mapping_store_users` add constraint `mapping_store_users_role_id_foreign` foreign key (`role_id`) references `roles` (`id`)
7alter table `mapping_store_users` add constraint `mapping_store_users_store_id_foreign` foreign key (`store_id`) references `stores` (`id`)
8ALTER TABLE mapping_store_users
9ADD COLUMN email varchar(191) NULL AFTER phone_number,
10ADD COLUMN `role` varchar(50) NULL AFTER email;
11
12create table `store_temporaries` (`id` int unsigned not null auto_increment primary key, `store_name` varchar(191) not null, `store_code` varchar(191) null, `master_store_id` int not null, `store_category_id` int unsigned not null, `email` varchar(191) null, `phone_number` varchar(191) null, `image` varchar(191) null, `longitude` varchar(191) null, `latitude` varchar(191) null, `address` varchar(191) null, `postal_code` varchar(191) null, `year_established` varchar(191) null, `account_number` varchar(191) null, `account_name` varchar(191) null, `province_id` int null, `city_id` int null, `district_id` int null, `village_id` int null, `status` varchar(191) not null, `no_siup` varchar(191) null, `file_siup` varchar(191) null, `no_npwp` varchar(191) null, `file_npwp` varchar(191) null, `no_situ` varchar(191) null, `file_situ` varchar(191) null, `no_pbb` varchar(191) null, `file_pbb` varchar(191) null, `no_skdu` varchar(191) null, `file_skdu` varchar(191) null, `no_rek_listrik` varchar(191) null, `file_rek_listrik` varchar(191) null, `no_ktp` varchar(191) null, `file_ktp` varchar(191) null, `verified_at` datetime null, `verified_by` int null, `created_at` timestamp null, `updated_at` timestamp null) default character set utf8mb4 collate utf8mb4_unicode_ci
13alter table `store_temporaries` add constraint `store_temporaries_store_category_id_foreign` foreign key (`store_category_id`) references `store_categories` (`id`)
14
15create table `user_temporaries` (`id` int unsigned not null auto_increment primary key, `name` varchar(191) null, `phone_number` varchar(50) null, `email` varchar(191) null, `register_date` timestamp null) default character set utf8mb4 collate utf8mb4_unicode_ci
16ALTER TABLE store_temporaries ADD COLUMN proof_of_business varchar(255) null AFTER status
17ALTER TABLE store_temporaries
18 MODIFY COLUMN province_id BIGINT,
19 MODIFY COLUMN city_id BIGINT,
20 MODIFY COLUMN district_id BIGINT,
21 MODIFY COLUMN village_id BIGINT;
22ALTER TABLE stores ADD COLUMN proof_of_business varchar(255) null AFTER status
23
24ALTER TABLE store_temporaries
25ADD COLUMN website varchar(50) NULL AFTER address,
26ADD COLUMN description LONGTEXT NULL AFTER website;
27
28ALTER TABLE order_temporaries ADD COLUMN user_creator varchar(50) NULL AFTER created_by;
29
30create table `order_temporaries` (`id` int unsigned not null auto_increment primary key, `code` varchar(191) null, `brand_id` int not null default '0', `agent_id` int not null default '0', `salesman_id` int not null default '0', `store_id` int not null default '0', `store_address_id` int not null default '0', `store_address` text null, `created_by` int not null default '0', `status` varchar(191) null, `total_amount` decimal(15, 2) not null default '0', `so_ref_number` varchar(191) null, `so_ref_date` date null, `notes` longtext null, `internal_comment` text null, `g_lat` varchar(191) null, `g_lng` varchar(191) null, `order_type` varchar(191) null, `verified_by_agent` int not null default '0', `created_at` timestamp null, `updated_at` timestamp null) default character set utf8mb4 collate utf8mb4_unicode_ci
31ALTER TABLE order_temporaries ADD COLUMN reference_order_number VARCHAR(191) NULL AFTER code;
32
33create table `order_detail_temporaries` (`id` int unsigned not null auto_increment primary key, `order_temporaries_id` int unsigned not null, `product_master_id` int not null default '0', `product_agent_id` int not null default '0', `qty` int not null default '0', `unit` varchar(191) null, `unit_type` varchar(191) null, `last_sent_qty` int not null default '0', `residual_qty` int not null default '0', `temp_residual_qty` int not null default '0', `price_at_time` decimal(15, 2) not null default '0', `subtotal_price` decimal(15, 2) not null default '0', `status` varchar(191) null, `created_at` timestamp null, `updated_at` timestamp null) default character set utf8mb4 collate utf8mb4_unicode_ci
34alter table `order_detail_temporaries` add constraint `order_detail_temporaries_order_temporaries_id_foreign` foreign key (`order_temporaries_id`) references `order_temporaries` (`id`) on delete no action
35
36
37CREATE TABLE assign_stores (
38 id INT PRIMARY KEY AUTO_INCREMENT,
39 third_party_agent_id INT NOT NULL,
40 agent_id INT NOT NULL,
41 store_id INT NOT NULL,
42 status VARCHAR(50) NOT NULL,
43 assignment_date TIMESTAMP NOT NULL,
44 created_at TIMESTAMP NOT NULL,
45 updated_at TIMESTAMP NULL
46)
47
48ALTER TABLE assign_stores ADD COLUMN approved_by INT NULL AFTER assignment_date;
49ALTER TABLE assign_stores ADD COLUMN order_temp_id INT NULL AFTER store_id;
50ALTER TABLE assign_stores ADD COLUMN brand_id INT NULL AFTER store_id;
51ALTER TABLE assign_stores ADD COLUMN reject_reason text NULL AFTER status;
52
53
54ALTER TABLE brand_store_agent ADD COLUMN created_at timestamp NULL;
55ALTER TABLE brand_store_agent ADD COLUMN updated_at timestamp NULL;
56
57ALTER TABLE mapping_store ADD COLUMN use_apps TINYINT DEFAULT 0 AFTER store_id;
58
59