SQL
Codesign resources contain various editable/unobscured files such as client/server functions etc.
Last updated
Was this helpful?
Codesign resources contain various editable/unobscured files such as client/server functions etc.
Watch this video if you are unsure how to insert an SQL Query into your database. HeidiSQL / PHPMyAdmin.
Last updated
Was this helpful?
Was this helpful?
CREATE TABLE `cd_vipshop` (
`identifier` VARCHAR(50) NOT NULL COLLATE 'utf8mb4_general_ci',
`balance` DECIMAL(20,2) UNSIGNED NOT NULL DEFAULT '0.00',
PRIMARY KEY (`identifier`) USING BTREE
)
COLLATE='utf8mb4_general_ci'
ENGINE=InnoDB
;
CREATE TABLE `cd_vipshop_logs` (
`transaction_id` VARCHAR(50) NOT NULL COLLATE 'utf8mb4_general_ci',
`identifier` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
`package` LONGTEXT NOT NULL COLLATE 'utf8mb4_general_ci',
`redeemed` TINYINT(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`transaction_id`) USING BTREE,
INDEX `idx_identifier` (`identifier`) USING BTREE,
INDEX `idx_redeemed` (`redeemed`) USING BTREE
)
COLLATE='utf8mb4_general_ci'
ENGINE=InnoDB
;
CREATE TABLE `cd_vipshop_vehiclestock` (
`model` VARCHAR(50) NOT NULL COLLATE 'utf8mb4_unicode_ci',
`stock` INT(10) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (`model`) USING BTREE
)
COLLATE='utf8mb4_unicode_ci'
ENGINE=InnoDB
;
