Vergleich install/resources/pgsql_db_tables.php - 1.8.4 - 1.8.39

  Keine Änderungen   Hinzugefügt   Modifiziert   Entfernt
Zeile 33Zeile 33
  defaultviews text NOT NULL,
  loginattempts smallint NOT NULL default '0',
  loginlockoutexpiry int NOT NULL default '0',

 
  defaultviews text NOT NULL,
  loginattempts smallint NOT NULL default '0',
  loginlockoutexpiry int NOT NULL default '0',

  2fasecret varchar(16) NOT NULL default '',

  authsecret varchar(16) NOT NULL default '',

  recovery_codes varchar(177) NOT NULL default '',
  UNIQUE (uid)
);";

  recovery_codes varchar(177) NOT NULL default '',
  UNIQUE (uid)
);";

Zeile 46Zeile 46
	dateline int NOT NULL default '0',
	lastactive int NOT NULL default '0',
	data text NOT NULL default '',

 
	dateline int NOT NULL default '0',
	lastactive int NOT NULL default '0',
	data text NOT NULL default '',

	useragent varchar(100) NOT NULL default '',

	useragent varchar(200) NOT NULL default '',

	authenticated smallint NOT NULL default '0'
);";


	authenticated smallint NOT NULL default '0'
);";


Zeile 85Zeile 85
  pid int NOT NULL default '0',
  posthash varchar(50) NOT NULL default '',
  uid int NOT NULL default '0',

 
  pid int NOT NULL default '0',
  posthash varchar(50) NOT NULL default '',
  uid int NOT NULL default '0',

  filename varchar(120) NOT NULL default '',

  filename varchar(255) NOT NULL default '',

  filetype varchar(120) NOT NULL default '',
  filesize int NOT NULL default '0',

 
  filetype varchar(120) NOT NULL default '',
  filesize int NOT NULL default '0',

  attachname varchar(120) NOT NULL default '',

  attachname varchar(255) NOT NULL default '',

  downloads int NOT NULL default '0',
  dateuploaded int NOT NULL default '0',
  visible smallint NOT NULL default '0',

  downloads int NOT NULL default '0',
  dateuploaded int NOT NULL default '0',
  visible smallint NOT NULL default '0',

Zeile 103Zeile 103
  extension varchar(10) NOT NULL default '',
  maxsize int NOT NULL default '0',
  icon varchar(100) NOT NULL default '',

 
  extension varchar(10) NOT NULL default '',
  maxsize int NOT NULL default '0',
  icon varchar(100) NOT NULL default '',

 
  enabled smallint NOT NULL default '1',
  forcedownload smallint NOT NULL default '0',
  groups text NOT NULL default '-1',
  forums text NOT NULL default '-1',
  avatarfile smallint NOT NULL default '0',

  PRIMARY KEY (atid)
);";


  PRIMARY KEY (atid)
);";


Zeile 120Zeile 125
$tables[] = "CREATE TABLE mybb_badwords (
  bid serial,
  badword varchar(100) NOT NULL default '',

 
$tables[] = "CREATE TABLE mybb_badwords (
  bid serial,
  badword varchar(100) NOT NULL default '',

 
  regex smallint NOT NULL default '0',

  replacement varchar(100) NOT NULL default '',
  PRIMARY KEY (bid)
);";

  replacement varchar(100) NOT NULL default '',
  PRIMARY KEY (bid)
);";

Zeile 148Zeile 154

$tables[] = "CREATE TABLE mybb_buddyrequests (
 id serial,

 

$tables[] = "CREATE TABLE mybb_buddyrequests (
 id serial,

 uid int NOT NULL,
 touid int NOT NULL,
 date int NOT NULL,

 uid int NOT NULL default '0',
 touid int NOT NULL default '0',
 date int NOT NULL default '0',

 PRIMARY KEY (id)

 
 PRIMARY KEY (id)

);";


);";


$tables[] = "CREATE TABLE mybb_calendars (
  cid serial,
  name varchar(100) NOT NULL default '',

$tables[] = "CREATE TABLE mybb_calendars (
  cid serial,
  name varchar(100) NOT NULL default '',

Zeile 239Zeile 245
  candeleteposts smallint NOT NULL default '0',
  candeletethreads smallint NOT NULL default '0',
  caneditattachments smallint NOT NULL default '0',

 
  candeleteposts smallint NOT NULL default '0',
  candeletethreads smallint NOT NULL default '0',
  caneditattachments smallint NOT NULL default '0',

 
  canviewdeletionnotice smallint NOT NULL default '0',

  modposts smallint NOT NULL default '0',
  modthreads smallint NOT NULL default '0',
  mod_edit_posts smallint NOT NULL default '0',

  modposts smallint NOT NULL default '0',
  modthreads smallint NOT NULL default '0',
  mod_edit_posts smallint NOT NULL default '0',

Zeile 255Zeile 262
  description text NOT NULL default '',
  linkto varchar(180) NOT NULL default '',
  type char(1) NOT NULL default '',

 
  description text NOT NULL default '',
  linkto varchar(180) NOT NULL default '',
  type char(1) NOT NULL default '',

  pid smallint NOT NULL default '0',

  pid smallint NOT NULL default '0',

  parentlist text NOT NULL default '',
  disporder smallint NOT NULL default '0',
  active smallint NOT NULL default '0',

  parentlist text NOT NULL default '',
  disporder smallint NOT NULL default '0',
  active smallint NOT NULL default '0',

Zeile 292Zeile 299
  defaultsortby varchar(10) NOT NULL default '',
  defaultsortorder varchar(4) NOT NULL default '',
  PRIMARY KEY (fid)

 
  defaultsortby varchar(10) NOT NULL default '',
  defaultsortorder varchar(4) NOT NULL default '',
  PRIMARY KEY (fid)

);";


);";


$tables[] = "CREATE TABLE mybb_forumsread (
  fid int NOT NULL default '0',
  uid int NOT NULL default '0',

 
$tables[] = "CREATE TABLE mybb_forumsread (
  fid int NOT NULL default '0',
  uid int NOT NULL default '0',

  dateline int NOT NULL default '0'


  dateline int NOT NULL default '0',
  UNIQUE (fid, uid)

);";

$tables[] = "CREATE TABLE mybb_forumsubscriptions (

);";

$tables[] = "CREATE TABLE mybb_forumsubscriptions (

Zeile 320Zeile 328
$tables[] = "CREATE TABLE mybb_helpdocs (
  hid serial,
  sid smallint NOT NULL default '0',

 
$tables[] = "CREATE TABLE mybb_helpdocs (
  hid serial,
  sid smallint NOT NULL default '0',

  name varchar(120) NOT NULL default '',

  name varchar(120) NOT NULL default '',

  description text NOT NULL default '',
  document text NOT NULL default '',
  usetranslation smallint NOT NULL default '0',

  description text NOT NULL default '',
  document text NOT NULL default '',
  usetranslation smallint NOT NULL default '0',

Zeile 344Zeile 352
  name varchar(120) NOT NULL default '',
  path varchar(220) NOT NULL default '',
  PRIMARY KEY (iid)

 
  name varchar(120) NOT NULL default '',
  path varchar(220) NOT NULL default '',
  PRIMARY KEY (iid)

);";


);";


$tables[] = "CREATE TABLE mybb_joinrequests (
  rid serial,
  uid int NOT NULL default '0',

$tables[] = "CREATE TABLE mybb_joinrequests (
  rid serial,
  uid int NOT NULL default '0',

Zeile 357Zeile 365
);";

$tables[] = "CREATE TABLE mybb_massemails (

 
);";

$tables[] = "CREATE TABLE mybb_massemails (

	mid serial,

	mid serial,

	uid int NOT NULL default '0',
	subject varchar(200) NOT NULL default '',
	message text NOT NULL,

	uid int NOT NULL default '0',
	subject varchar(200) NOT NULL default '',
	message text NOT NULL,

Zeile 500Zeile 508
  uid int NOT NULL default '0',
  voteoption smallint NOT NULL default '0',
  dateline int NOT NULL default '0',

 
  uid int NOT NULL default '0',
  voteoption smallint NOT NULL default '0',
  dateline int NOT NULL default '0',

 
  ipaddress bytea NOT NULL default '',

  PRIMARY KEY (vid)
);";


  PRIMARY KEY (vid)
);";


Zeile 511Zeile 520
  subject varchar(120) NOT NULL default '',
  icon smallint NOT NULL default '0',
  uid int NOT NULL default '0',

 
  subject varchar(120) NOT NULL default '',
  icon smallint NOT NULL default '0',
  uid int NOT NULL default '0',

  username varchar(80) NOT NULL default '',

  username varchar(120) NOT NULL default '',

  dateline int NOT NULL default '0',
  message text NOT NULL default '',
  ipaddress  bytea NOT NULL default '',

  dateline int NOT NULL default '0',
  message text NOT NULL default '',
  ipaddress  bytea NOT NULL default '',

Zeile 633Zeile 642
  id3 int NOT NULL default '0',
  uid int NOT NULL default '0',
  reportstatus smallint NOT NULL default '0',

 
  id3 int NOT NULL default '0',
  uid int NOT NULL default '0',
  reportstatus smallint NOT NULL default '0',

 
  reasonid smallint NOT NULL default '0',

  reason varchar(250) NOT NULL default '',
  type varchar(50) NOT NULL default '',
  reports int NOT NULL default '0',
  reporters text NOT NULL default '',
  dateline int NOT NULL default '0',
  lastreport int NOT NULL default '0',

 
  reason varchar(250) NOT NULL default '',
  type varchar(50) NOT NULL default '',
  reports int NOT NULL default '0',
  reporters text NOT NULL default '',
  dateline int NOT NULL default '0',
  lastreport int NOT NULL default '0',

 
  PRIMARY KEY (rid)
);";

$tables[] = "CREATE TABLE mybb_reportreasons (
  rid serial,
  title varchar(250) NOT NULL default '',
  appliesto varchar(250) NOT NULL default '',
  extra smallint NOT NULL default '0',
  disporder smallint NOT NULL default '0',

  PRIMARY KEY (rid)
);";

$tables[] = "CREATE TABLE mybb_reputation (
  rid serial,

 
  PRIMARY KEY (rid)
);";

$tables[] = "CREATE TABLE mybb_reputation (
  rid serial,

  uid int NOT NULL default '0',

  uid int NOT NULL default '0',

  adduid int NOT NULL default '0',
  pid int NOT NULL default '0',
  reputation smallint NOT NULL default '0',

  adduid int NOT NULL default '0',
  pid int NOT NULL default '0',
  reputation smallint NOT NULL default '0',

Zeile 663Zeile 682
  resulttype varchar(10) NOT NULL default '',
  querycache text NOT NULL default '',
  keywords text NOT NULL default '',

 
  resulttype varchar(10) NOT NULL default '',
  querycache text NOT NULL default '',
  keywords text NOT NULL default '',

  UNIQUE (sid)

  UNIQUE (sid)

);";

$tables[] = "CREATE TABLE mybb_sessions (

);";

$tables[] = "CREATE TABLE mybb_sessions (

Zeile 672Zeile 691
  ip bytea NOT NULL default '',
  time int NOT NULL default '0',
  location varchar(150) NOT NULL default '',

 
  ip bytea NOT NULL default '',
  time int NOT NULL default '0',
  location varchar(150) NOT NULL default '',

  useragent varchar(100) NOT NULL default '',

  useragent varchar(200) NOT NULL default '',

  anonymous smallint NOT NULL default '0',
  nopermission smallint NOT NULL default '0',
  location1 int NOT NULL default '0',

  anonymous smallint NOT NULL default '0',
  nopermission smallint NOT NULL default '0',
  location1 int NOT NULL default '0',

Zeile 740Zeile 759
	numthreads numeric(10,0) NOT NULL default '0',
	numposts numeric(10,0) NOT NULL default '0',
	UNIQUE (dateline)

 
	numthreads numeric(10,0) NOT NULL default '0',
	numposts numeric(10,0) NOT NULL default '0',
	UNIQUE (dateline)

);";


);";


$tables[] = "CREATE TABLE mybb_tasks (
	tid serial,
	title varchar(120) NOT NULL default '',

$tables[] = "CREATE TABLE mybb_tasks (
	tid serial,
	title varchar(120) NOT NULL default '',

Zeile 766Zeile 785
	dateline int NOT NULL default '0',
	data text NOT NULL,
	PRIMARY KEY(lid)

 
	dateline int NOT NULL default '0',
	data text NOT NULL,
	PRIMARY KEY(lid)

);";

);";


$tables[] = "CREATE TABLE mybb_templategroups (
  gid serial,


$tables[] = "CREATE TABLE mybb_templategroups (
  gid serial,

Zeile 791Zeile 810
  sid serial,
  title varchar(120) NOT NULL default '',
  PRIMARY KEY (sid)

 
  sid serial,
  title varchar(120) NOT NULL default '',
  PRIMARY KEY (sid)

);";


);";


$tables[] = "CREATE TABLE mybb_themes (
  tid serial,
  name varchar(100) NOT NULL default '',

$tables[] = "CREATE TABLE mybb_themes (
  tid serial,
  name varchar(100) NOT NULL default '',

Zeile 845Zeile 864
  icon smallint NOT NULL default '0',
  poll int NOT NULL default '0',
  uid int NOT NULL default '0',

 
  icon smallint NOT NULL default '0',
  poll int NOT NULL default '0',
  uid int NOT NULL default '0',

  username varchar(80) NOT NULL default '',

  username varchar(120) NOT NULL default '',

  dateline int NOT NULL default '0',
  firstpost int NOT NULL default '0',
  lastpost int NOT NULL default '0',

  dateline int NOT NULL default '0',
  firstpost int NOT NULL default '0',
  lastpost int NOT NULL default '0',

Zeile 869Zeile 888
$tables[] = "CREATE TABLE mybb_threadsread (
  tid int NOT NULL default '0',
  uid int NOT NULL default '0',

 
$tables[] = "CREATE TABLE mybb_threadsread (
  tid int NOT NULL default '0',
  uid int NOT NULL default '0',

  dateline int NOT NULL default '0'


  dateline int NOT NULL default '0',
  UNIQUE (tid, uid)

);";

$tables[] = "CREATE TABLE mybb_threadsubscriptions (

);";

$tables[] = "CREATE TABLE mybb_threadsubscriptions (

Zeile 878Zeile 898
  tid int NOT NULL default '0',
  notification smallint NOT NULL default '0',
  dateline int NOT NULL default '0',

 
  tid int NOT NULL default '0',
  notification smallint NOT NULL default '0',
  dateline int NOT NULL default '0',

  subscriptionkey varchar(32) NOT NULL default '',

 
  PRIMARY KEY (sid)
);";


  PRIMARY KEY (sid)
);";


Zeile 889Zeile 908
  fid3 text NOT NULL default '',
  PRIMARY KEY (ufid)
);";

 
  fid3 text NOT NULL default '',
  PRIMARY KEY (ufid)
);";

$query = $db->write_query("SELECT column_name
						  FROM information_schema.constraint_column_usage
						  WHERE table_name = '".$config['tableprefix']."userfields'
						  AND constraint_name = '".$config['tableprefix']."userfields_pkey'
						  LIMIT 1");
$main_field = $db->fetch_field($query, 'column_name');
if(!empty($main_field))
{
	$tables[] = "DROP SEQUENCE mybb_userfields_ufid_seq;";
}

 
$tables[] = "CREATE SEQUENCE mybb_userfields_ufid_seq;";

$tables[] = "CREATE TABLE mybb_usergroups (

$tables[] = "CREATE SEQUENCE mybb_userfields_ufid_seq;";

$tables[] = "CREATE TABLE mybb_usergroups (

Zeile 930Zeile 939
  candeleteposts smallint NOT NULL default '0',
  candeletethreads smallint NOT NULL default '0',
  caneditattachments smallint NOT NULL default '0',

 
  candeleteposts smallint NOT NULL default '0',
  candeletethreads smallint NOT NULL default '0',
  caneditattachments smallint NOT NULL default '0',

 
  canviewdeletionnotice smallint NOT NULL default '0',

  canpostpolls smallint NOT NULL default '0',
  canvotepolls smallint NOT NULL default '0',
  canundovotes smallint NOT NULL default '0',

  canpostpolls smallint NOT NULL default '0',
  canvotepolls smallint NOT NULL default '0',
  canundovotes smallint NOT NULL default '0',

Zeile 959Zeile 969
  canratemembers smallint NOT NULL default '0',
  canchangename smallint NOT NULL default '0',
  canbereported smallint NOT NULL default '0',

 
  canratemembers smallint NOT NULL default '0',
  canchangename smallint NOT NULL default '0',
  canbereported smallint NOT NULL default '0',

 
  canbeinvisible smallint NOT NULL default '1',

  canchangewebsite smallint NOT NULL default '1',
  showforumteam smallint NOT NULL default '0',
  usereputationsystem smallint NOT NULL default '0',

  canchangewebsite smallint NOT NULL default '1',
  showforumteam smallint NOT NULL default '0',
  usereputationsystem smallint NOT NULL default '0',

Zeile 1015Zeile 1026
  lastvisit int NOT NULL default '0',
  lastpost int NOT NULL default '0',
  website varchar(200) NOT NULL default '',

 
  lastvisit int NOT NULL default '0',
  lastpost int NOT NULL default '0',
  website varchar(200) NOT NULL default '',

  icq varchar(10) NOT NULL default '',
  aim varchar(50) NOT NULL default '',
  yahoo varchar(50) NOT NULL default '',

 
  skype varchar(75) NOT NULL default '',
  google varchar(75) NOT NULL default '',
  birthday varchar(15) NOT NULL default '',

  skype varchar(75) NOT NULL default '',
  google varchar(75) NOT NULL default '',
  birthday varchar(15) NOT NULL default '',

Zeile 1076Zeile 1084
  suspendsigtime int NOT NULL default '0',
  coppauser smallint NOT NULL default '0',
  classicpostbit smallint NOT NULL default '0',

 
  suspendsigtime int NOT NULL default '0',
  coppauser smallint NOT NULL default '0',
  classicpostbit smallint NOT NULL default '0',

  loginattempts smallint NOT NULL default '1',


  loginattempts smallint NOT NULL default '0',
  loginlockoutexpiry int NOT NULL default '0',

  usernotes text NOT NULL default '',
  sourceeditor smallint NOT NULL default '0',
  PRIMARY KEY (uid)

  usernotes text NOT NULL default '',
  sourceeditor smallint NOT NULL default '0',
  PRIMARY KEY (uid)