Server : Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips PHP/7.4.20 System : Linux st2.domain.com 3.10.0-1127.10.1.el7.x86_64 #1 SMP Wed Jun 3 14:28:03 UTC 2020 x86_64 User : apache ( 48) PHP Version : 7.4.20 Disable Function : NONE Directory : /proc/self/root/var/www/html/tien-dien/code/admin/store/ |
<?php
global $DB, $print;
$install_messages = array();
// Create tb_stores table if it doesn't exist
$check_table = $DB->query("SHOW TABLES LIKE 'tb_stores'");
if ($DB->get_num_rows() == 0) {
$sql = "CREATE TABLE `tb_stores` (
`store_id` int NOT NULL AUTO_INCREMENT,
`store_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`store_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`user_id` int DEFAULT NULL,
`status` tinyint DEFAULT '1',
`created_at` int DEFAULT NULL,
`updated_at` int DEFAULT NULL,
PRIMARY KEY (`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;";
$DB->query($sql);
$install_messages[] = "Đã tạo bảng tb_stores.";
}
// Check if store_id column exists in tb_product table
$check_column = $DB->query("SHOW COLUMNS FROM tb_product LIKE 'store_id'");
if ($DB->get_num_rows() == 0) {
// Add store_id column to tb_product table
$sql = "ALTER TABLE tb_product ADD COLUMN `store_id` int DEFAULT NULL AFTER `id`";
$DB->query($sql);
$install_messages[] = "Đã thêm cột store_id vào bảng tb_product.";
}
$install_complete = true;
?>