Advertisement
Guest User

Untitled

a guest
Feb 28th, 2020
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.58 KB | None | 0 0
  1. CREATE TABLE `tbl_access_users` (
  2. `userId_n` INT(10) UNSIGNED NOT NULL,
  3. `firstName_c` VARCHAR(128) NOT NULL DEFAULT '0',
  4. `lastName_c` VARCHAR(128) NULL DEFAULT NULL,
  5. `middleInitial_c` VARCHAR(32) NULL DEFAULT NULL,
  6. `areaId_n` INT(10) UNSIGNED NULL DEFAULT NULL,
  7. `profileId_n` INT(10) UNSIGNED NULL DEFAULT NULL,
  8. `role_c` VARCHAR(128) NULL DEFAULT NULL,
  9. `disabled_n` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
  10. PRIMARY KEY (`userId_n`),
  11. INDEX `role_c` (`role_c`),
  12. INDEX `areaId_n` (`areaId_n`),
  13. INDEX `disabled_n` (`disabled_n`)
  14. )
  15. COLLATE='utf8_general_ci'
  16. ENGINE=InnoDB
  17. ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement