Vergleich install/resources/pgsql_db_tables.php - 1.8.11 - 1.8.21

  Keine Änderungen   Hinzugefügt   Modifiziert   Entfernt
Zeile 124Zeile 124
$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 505Zeile 506
  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 1031Zeile 1033
  lastpost int NOT NULL default '0',
website varchar(200) NOT NULL default '',
icq varchar(10) NOT NULL default '',

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

  yahoo varchar(50) NOT NULL default '',
skype varchar(75) NOT NULL default '',
google varchar(75) NOT NULL default '',

Zeile 1091Zeile 1092
  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)