Advertisement
Genral

Untitled

Apr 27th, 2024
28
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.85 KB | None | 0 0
  1. CREATE TABLE `accounts` (
  2. `id` int NOT NULL AUTO_INCREMENT,
  3. `Username` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  4. `Password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  5. `Mobile` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  6. `Email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  7. `LastCheck` datetime NOT NULL DEFAULT current_timestamp,
  8. `State` tinyint NOT NULL,
  9. `F_Name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  10. PRIMARY KEY (`id`, `Username`) USING BTREE,
  11. UNIQUE INDEX `Username`(`Username` ASC) USING BTREE,
  12. UNIQUE INDEX `Mobile`(`Mobile` ASC) USING BTREE
  13. ) 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