Vergleich install/resources/pgsql_db_tables.php - 1.8.1 - 1.8.7

  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',

 
  authsecret varchar(16) NOT NULL default '',
recovery_codes varchar(177) NOT NULL default '',

  UNIQUE (uid)
);";


  UNIQUE (uid)
);";


Zeile 44Zeile 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'

);";

$tables[] = "CREATE TABLE mybb_adminviews (

);";

$tables[] = "CREATE TABLE mybb_adminviews (

Zeile 145Zeile 148

$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)
);";


Zeile 669Zeile 672
  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 875Zeile 878
  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 960Zeile 962
  showforumteam smallint NOT NULL default '0',
usereputationsystem smallint NOT NULL default '0',
cangivereputations smallint NOT NULL default '0',

  showforumteam smallint NOT NULL default '0',
usereputationsystem smallint NOT NULL default '0',
cangivereputations smallint NOT NULL default '0',

 
  candeletereputations smallint NOT NULL default '0',

  reputationpower int NOT NULL default '0',
maxreputationsday int NOT NULL default '0',
maxreputationsperuser int NOT NULL default '0',

  reputationpower int NOT NULL default '0',
maxreputationsday int NOT NULL default '0',
maxreputationsperuser int NOT NULL default '0',