Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE `accounts` (
- `id` int NOT NULL AUTO_INCREMENT,
- `Username` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
- `Password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
- `Mobile` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
- `Email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
- `LastCheck` datetime NOT NULL DEFAULT current_timestamp,
- `State` tinyint NOT NULL,
- `F_Name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
- PRIMARY KEY (`id`, `Username`) USING BTREE,
- UNIQUE INDEX `Username`(`Username` ASC) USING BTREE,
- UNIQUE INDEX `Mobile`(`Mobile` ASC) USING BTREE
- ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement