Vergleich install/resources/sqlite_db_tables.php - 1.6.4 - 1.6.11

  Keine Änderungen   Hinzugefügt   Modifiziert   Entfernt
Zeile 6Zeile 6
 * Website: http://mybb.com
* License: http://mybb.com/about/license
*

 * Website: http://mybb.com
* License: http://mybb.com/about/license
*

 * $Id: sqlite_db_tables.php 5297 2010-12-28 22:01:14Z Tomm $

 * $Id$

 */

$tables[] = "CREATE TABLE mybb_adminlog (

 */

$tables[] = "CREATE TABLE mybb_adminlog (

Zeile 47Zeile 47
	visibility int(1) NOT NULL default '0',
fields TEXT NOT NULL,
conditions TEXT NOT NULL,

	visibility int(1) NOT NULL default '0',
fields TEXT NOT NULL,
conditions TEXT NOT NULL,

 
	custom_profile_fields TEXT NOT NULL,

	sortby varchar(20) NOT NULL default '',
sortorder varchar(4) NOT NULL default '',
perpage int(4) NOT NULL default '0',

	sortby varchar(20) NOT NULL default '',
sortorder varchar(4) NOT NULL default '',
perpage int(4) NOT NULL default '0',

Zeile 383Zeile 384
  canviewips int(1) NOT NULL default '0',
canopenclosethreads int(1) NOT NULL default '0',
canmanagethreads int(1) NOT NULL default '0',

  canviewips int(1) NOT NULL default '0',
canopenclosethreads int(1) NOT NULL default '0',
canmanagethreads int(1) NOT NULL default '0',

  canmovetononmodforum int(1) NOT NULL default '0'


  canmovetononmodforum int(1) NOT NULL default '0',
canusecustomtools int(1) NOT NULL default '0'

);";

$tables[] = "CREATE TABLE mybb_modtools (

);";

$tables[] = "CREATE TABLE mybb_modtools (

Zeile 413Zeile 415
  options TEXT NOT NULL,
votes TEXT NOT NULL,
numoptions smallint NOT NULL default '0',

  options TEXT NOT NULL,
votes TEXT NOT NULL,
numoptions smallint NOT NULL default '0',

  numvotes smallint NOT NULL default '0',

  numvotes text NOT NULL,

  timeout bigint(30) NOT NULL default '0',
closed int(1) NOT NULL default '0',
multiple int(1) NOT NULL default '0',

  timeout bigint(30) NOT NULL default '0',
closed int(1) NOT NULL default '0',
multiple int(1) NOT NULL default '0',

Zeile 481Zeile 483
  maxlength smallint NOT NULL default '0',
required int(1) NOT NULL default '0',
editable int(1) NOT NULL default '0',

  maxlength smallint NOT NULL default '0',
required int(1) NOT NULL default '0',
editable int(1) NOT NULL default '0',

  hidden int(1) NOT NULL default '0'


  hidden int(1) NOT NULL default '0',
postnum bigint(30) NOT NULL default '0'

);";



);";



Zeile 776Zeile 779
  pmquota int(3) NOT NULL default '0',
maxpmrecipients int(4) NOT NULL default '5',
cansendemail int(1) NOT NULL default '0',

  pmquota int(3) NOT NULL default '0',
maxpmrecipients int(4) NOT NULL default '5',
cansendemail int(1) NOT NULL default '0',

 
  cansendemailoverride int(1) NOT NULL default '0',

  maxemails int(3) NOT NULL default '5',
canviewmemberlist int(1) NOT NULL default '0',
canviewcalendar int(1) NOT NULL default '0',

  maxemails int(3) NOT NULL default '5',
canviewmemberlist int(1) NOT NULL default '0',
canviewcalendar int(1) NOT NULL default '0',

Zeile 805Zeile 809
  canwarnusers int(1) NOT NULL default '0',
canreceivewarnings int(1) NOT NULL default '0',
maxwarningsday int NOT NULL default '3',

  canwarnusers int(1) NOT NULL default '0',
canreceivewarnings int(1) NOT NULL default '0',
maxwarningsday int NOT NULL default '3',

  canmodcp int(1) NOT NULL default '0'






  canmodcp int(1) NOT NULL default '0',
showinbirthdaylist int(1) NOT NULL default '0',
canoverridepm int(1) NOT NULL default '0',
canusesig int(1) NOT NULL default '0',
canusesigxposts bigint(30) NOT NULL default '0',
signofollow int(1) NOT NULL default '0'

);";



);";



Zeile 888Zeile 897
  coppauser int(1) NOT NULL default '0',
classicpostbit int(1) NOT NULL default '0',
loginattempts tinyint(2) NOT NULL default '1',

  coppauser int(1) NOT NULL default '0',
classicpostbit int(1) NOT NULL default '0',
loginattempts tinyint(2) NOT NULL default '1',

  failedlogin bigint(30) NOT NULL default '0',

 
  usernotes TEXT NOT NULL
);";


  usernotes TEXT NOT NULL
);";