Redux Auth Table SQL


/ Published in: SQL
Save to your folder(s)



Copy this code and paste it in your HTML
  1. -- phpMyAdmin SQL Dump
  2. -- version 2.11.9.4
  3. -- http://www.phpmyadmin.net
  4. --
  5. -- Host: localhost
  6. -- Generation Time: Jan 02, 2009 at 12:09 PM
  7. -- Server version: 5.0.67
  8. -- PHP Version: 5.2.6
  9.  
  10. SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
  11.  
  12. --
  13. -- Database: `redux`
  14. --
  15.  
  16. -- --------------------------------------------------------
  17.  
  18. --
  19. -- Table structure for table `groups`
  20. --
  21.  
  22. CREATE TABLE IF NOT EXISTS `groups` (
  23. `id` tinyint(3) UNSIGNED NOT NULL AUTO_INCREMENT,
  24. `name` VARCHAR(20) NOT NULL,
  25. `description` VARCHAR(100) NOT NULL,
  26. PRIMARY KEY (`id`)
  27. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
  28.  
  29. -- --------------------------------------------------------
  30.  
  31. --
  32. -- Table structure for table `meta`
  33. --
  34.  
  35. CREATE TABLE IF NOT EXISTS `meta` (
  36. `id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT,
  37. `user_id` mediumint(8) UNSIGNED NOT NULL,
  38. `first_name` VARCHAR(50) NOT NULL,
  39. `last_name` VARCHAR(50) NOT NULL,
  40. PRIMARY KEY (`id`)
  41. ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
  42.  
  43. -- --------------------------------------------------------
  44.  
  45. --
  46. -- Table structure for table `users`
  47. --
  48.  
  49. CREATE TABLE IF NOT EXISTS `users` (
  50. `id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT,
  51. `group_id` mediumint(8) UNSIGNED NOT NULL,
  52. `ip_address` CHAR(16) NOT NULL,
  53. `username` VARCHAR(15) NOT NULL,
  54. `password` VARCHAR(40) NOT NULL,
  55. `email` VARCHAR(40) NOT NULL,
  56. `activation_code` VARCHAR(40) NOT NULL DEFAULT '0',
  57. `forgotten_password_code` VARCHAR(40) NOT NULL DEFAULT '0',
  58. PRIMARY KEY (`id`)
  59. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.