Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE `tbl_access_users` (
- `userId_n` INT(10) UNSIGNED NOT NULL,
- `firstName_c` VARCHAR(128) NOT NULL DEFAULT '0',
- `lastName_c` VARCHAR(128) NULL DEFAULT NULL,
- `middleInitial_c` VARCHAR(32) NULL DEFAULT NULL,
- `areaId_n` INT(10) UNSIGNED NULL DEFAULT NULL,
- `profileId_n` INT(10) UNSIGNED NULL DEFAULT NULL,
- `role_c` VARCHAR(128) NULL DEFAULT NULL,
- `disabled_n` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
- PRIMARY KEY (`userId_n`),
- INDEX `role_c` (`role_c`),
- INDEX `areaId_n` (`areaId_n`),
- INDEX `disabled_n` (`disabled_n`)
- )
- COLLATE='utf8_general_ci'
- ENGINE=InnoDB
- ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement