Posted by Noxwizard Sat 24th Mar 2007 05:17 - Syntax is SQL - 113 views
Download | New Post | Modify | Hide line numbers
  1. CREATE TABLE phpbb_users (
  2.    user_id mediumint(8) NOT NULL,
  3.    user_active tinyint(1) DEFAULT '1',
  4.    username varchar(25) NOT NULL,
  5.    user_password varchar(32) NOT NULL,
  6.    user_session_time int(11) DEFAULT '0' NOT NULL,
  7.    user_session_page smallint(5) DEFAULT '0' NOT NULL,
  8.    user_lastvisit int(11) DEFAULT '0' NOT NULL,
  9.    user_regdate int(11) DEFAULT '0' NOT NULL,
  10.    user_level tinyint(4) DEFAULT '0',
  11.    user_posts mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
  12.    user_timezone decimal(5,2) DEFAULT '0' NOT NULL,
  13.    user_style tinyint(4),
  14.    user_lang varchar(255),
  15.    user_dateformat varchar(14) DEFAULT 'd M Y H:i' NOT NULL,
  16.    user_new_privmsg smallint(5) UNSIGNED DEFAULT '0' NOT NULL,
  17.    user_unread_privmsg smallint(5) UNSIGNED DEFAULT '0' NOT NULL,
  18.    user_last_privmsg int(11) DEFAULT '0' NOT NULL,
  19.    user_login_tries smallint(5) UNSIGNED DEFAULT '0' NOT NULL,
  20.    user_last_login_try int(11) DEFAULT '0' NOT NULL,
  21.    user_emailtime int(11),
  22.    user_viewemail tinyint(1),
  23.    user_attachsig tinyint(1),
  24.    user_allowhtml tinyint(1) DEFAULT '1',
  25.    user_allowbbcode tinyint(1) DEFAULT '1',
  26.    user_allowsmile tinyint(1) DEFAULT '1',
  27.    user_allowavatar tinyint(1) DEFAULT '1' NOT NULL,
  28.    user_allow_pm tinyint(1) DEFAULT '1' NOT NULL,
  29.    user_allow_viewonline tinyint(1) DEFAULT '1' NOT NULL,
  30.    user_notify tinyint(1) DEFAULT '1' NOT NULL,
  31.    user_notify_pm tinyint(1) DEFAULT '0' NOT NULL,
  32.    user_popup_pm tinyint(1) DEFAULT '0' NOT NULL,
  33.    user_rank int(11) DEFAULT '0',
  34.    user_avatar varchar(100),
  35.    user_avatar_type tinyint(4) DEFAULT '0' NOT NULL,
  36.    user_email varchar(255),
  37.    user_icq varchar(15),
  38.    user_website varchar(100),
  39.    user_from varchar(100),
  40.    user_sig text,
  41.    user_sig_bbcode_uid char(10),
  42.    user_aim varchar(255),
  43.    user_yim varchar(255),
  44.    user_msnm varchar(255),
  45.    user_occ varchar(100),
  46.    user_interests varchar(255),
  47.    user_actkey varchar(32),
  48.    user_newpasswd varchar(32),
  49.    PRIMARY KEY (user_id),
  50.    KEY user_session_time (user_session_time)
  51. );

PermaLink to this entry https://pastebin.co.uk/12167
Posted by Noxwizard Sat 24th Mar 2007 05:17 - Syntax is SQL - 113 views
Download | New Post | Modify | Hide line numbers

 

Comments: 0