SQL

Codesign resources contain various editable/unobscured files such as client/server functions etc.

SQL Guide

Watch this video if you are unsure how to insert an SQL Query into your database. HeidiSQL / PHPMyAdmin.

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
;