cafreak

SQL Query to create users table

Apr 30th, 2014
45
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.51 KB | None | 0 0
  1. CREATE TABLE IF NOT EXISTS `ssbb_users` (
  2.   `id` bigint NOT NULL AUTO_INCREMENT,
  3.   `username` nvarchar(30) NOT NULL,
  4.   `password` nvarchar(255) NOT NULL,
  5.   `saltkey` nvarchar(max) NOT NULL,
  6.   `ssaltkey` nvarchar(255) NOT NULL,
  7.   `loginkey` nvarchar(max) NOT NULL,
  8.   `groupid` bigint NOT NULL,
  9.   `usertitle` nvarchar(255) NOT NULL,
  10.   `ip` nvarchar(255) NOT NULL,
  11.   `lastip` nvarchar(255) NOT NULL,
  12.   `regdate` nvarchar(255) NOT NULL,
  13.   PRIMARY KEY (`id`),
  14.   FOREIGN KEY (`groupid`) REFERENCES ssbb_groups(`id`)
  15.   )
Advertisement
Add Comment
Please, Sign In to add comment