Vergleich install/resources/sqlite_db_tables.php - 1.4.1 - 1.4.9

  Keine Änderungen   Hinzugefügt   Modifiziert   Entfernt
Zeile 6Zeile 6
 * Website: http://www.mybboard.net
* License: http://www.mybboard.net/about/license
*

 * Website: http://www.mybboard.net
* License: http://www.mybboard.net/about/license
*

 * $Id: sqlite_db_tables.php 3982 2008-07-04 21:25:56Z Tikitiki $

 * $Id: sqlite_db_tables.php 4289 2008-12-06 21:22:41Z Tikitiki $

 */

$tables[] = "CREATE TABLE mybb_adminlog (

 */

$tables[] = "CREATE TABLE mybb_adminlog (

Zeile 15Zeile 15
  dateline bigint(30) NOT NULL default '0',
module varchar(50) NOT NULL default '',
action varchar(50) NOT NULL default '',

  dateline bigint(30) NOT NULL default '0',
module varchar(50) NOT NULL default '',
action varchar(50) NOT NULL default '',

  data TEXT NOT NULL );";


  data TEXT NOT NULL 
);";


$tables[] = "CREATE TABLE mybb_adminoptions (
uid int(10) NOT NULL default '0',
cpstyle varchar(50) NOT NULL default '',


$tables[] = "CREATE TABLE mybb_adminoptions (
uid int(10) NOT NULL default '0',
cpstyle varchar(50) NOT NULL default '',

 
  codepress int(1) NOT NULL default '1',

  notes TEXT NOT NULL,
permissions TEXT NOT NULL,

  notes TEXT NOT NULL,
permissions TEXT NOT NULL,

  defaultviews TEXT NOT NULL );";


  defaultviews TEXT NOT NULL 
);";


$tables[] = "CREATE TABLE mybb_adminsessions (
sid varchar(32) NOT NULL default '',


$tables[] = "CREATE TABLE mybb_adminsessions (
sid varchar(32) NOT NULL default '',

Zeile 31Zeile 34
	ip varchar(40) NOT NULL default '',
dateline bigint(30) NOT NULL default '0',
lastactive bigint(30) NOT NULL default '0',

	ip varchar(40) NOT NULL default '',
dateline bigint(30) NOT NULL default '0',
lastactive bigint(30) NOT NULL default '0',

	data TEXT NOT NULL );";


	data TEXT NOT NULL
);";


$tables[] = "CREATE TABLE mybb_adminviews (
vid INTEGER PRIMARY KEY,


$tables[] = "CREATE TABLE mybb_adminviews (
vid INTEGER PRIMARY KEY,

Zeile 55Zeile 59
  message TEXT NOT NULL,
startdate bigint(30) NOT NULL default '0',
enddate bigint(30) NOT NULL default '0',

  message TEXT NOT NULL,
startdate bigint(30) NOT NULL default '0',
enddate bigint(30) NOT NULL default '0',

  allowhtml int(1) NOT NULL default '0',
allowmycode int(1) NOT NULL default '0',

  allowhtml int(1) NOT NULL default '0',
allowmycode int(1) NOT NULL default '0',

  allowsmilies int(1) NOT NULL default '0'
);";


  allowsmilies int(1) NOT NULL default '0'
);";


Zeile 106Zeile 110
  type int(1) NOT NULL default '0',
lastuse bigint(30) NOT NULL default '0',
dateline bigint(30) NOT NULL default '0'

  type int(1) NOT NULL default '0',
lastuse bigint(30) NOT NULL default '0',
dateline bigint(30) NOT NULL default '0'

);";


);";


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

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

Zeile 133Zeile 137
  allowmycode int(1) NOT NULL default '0',
allowimgcode int(1) NOT NULL default '0',
allowsmilies int(1) NOT NULL default '0'

  allowmycode int(1) NOT NULL default '0',
allowimgcode int(1) NOT NULL default '0',
allowsmilies int(1) NOT NULL default '0'

);";

);";


$tables[] = "CREATE TABLE mybb_calendarpermissions (
cid int NOT NULL default '0',


$tables[] = "CREATE TABLE mybb_calendarpermissions (
cid int NOT NULL default '0',

Zeile 151Zeile 155
);";

$tables[] = "CREATE TABLE mybb_datacache (

);";

$tables[] = "CREATE TABLE mybb_datacache (

  title varchar(50) NOT NULL default '',
cache mediumTEXT NOT NULL );";


  title varchar(50) NOT NULL default '' PRIMARY KEY,
cache mediumTEXT NOT NULL
);";


$tables[] = "CREATE TABLE mybb_events (
eid INTEGER PRIMARY KEY,
cid int NOT NULL default '0',


$tables[] = "CREATE TABLE mybb_events (
eid INTEGER PRIMARY KEY,
cid int NOT NULL default '0',

  uid int NOT NULL default '0',
name varchar(120) NOT NULL default '',

  uid int NOT NULL default '0',
name varchar(120) NOT NULL default '',

  description TEXT NOT NULL,
visible int(1) NOT NULL default '0',
private int(1) NOT NULL default '0',
dateline int(10) NOT NULL default '0',
starttime int(10) NOT NULL default '0',
endtime int(10) NOT NULL default '0',

  description TEXT NOT NULL,
visible int(1) NOT NULL default '0',
private int(1) NOT NULL default '0',
dateline int(10) NOT NULL default '0',
starttime int(10) NOT NULL default '0',
endtime int(10) NOT NULL default '0',

  timezone int(3) NOT NULL default '0',

  timezone varchar(4) NOT NULL default '0',

  ignoretimezone int(1) NOT NULL default '0',
usingtime int(1) NOT NULL default '0',
repeats TEXT NOT NULL );";

$tables[] = "CREATE TABLE mybb_forumpermissions (
pid INTEGER PRIMARY KEY,

  ignoretimezone int(1) NOT NULL default '0',
usingtime int(1) NOT NULL default '0',
repeats TEXT NOT NULL );";

$tables[] = "CREATE TABLE mybb_forumpermissions (
pid INTEGER PRIMARY KEY,

  fid int NOT NULL default '0',

  fid int NOT NULL default '0',

  gid int NOT NULL default '0',
canview int(1) NOT NULL default '0',
canviewthreads int(1) NOT NULL default '0',

  gid int NOT NULL default '0',
canview int(1) NOT NULL default '0',
canviewthreads int(1) NOT NULL default '0',

Zeile 235Zeile 240
);";

$tables[] = "CREATE TABLE mybb_forumsread (

);";

$tables[] = "CREATE TABLE mybb_forumsread (

  fid int NOT NULL default '0',
uid int NOT NULL default '0',
dateline int(10) NOT NULL default '0'
);";


  fid int NOT NULL default '0',
uid int NOT NULL default '0',
dateline int(10) NOT NULL default '0'
);";


$tables[] = "CREATE TABLE mybb_forumsubscriptions (
fsid INTEGER PRIMARY KEY,
fid smallint NOT NULL default '0',

$tables[] = "CREATE TABLE mybb_forumsubscriptions (
fsid INTEGER PRIMARY KEY,
fid smallint NOT NULL default '0',

Zeile 418Zeile 423
  dateline bigint(30) NOT NULL default '0',
message TEXT NOT NULL,
ipaddress varchar(30) NOT NULL default '',

  dateline bigint(30) NOT NULL default '0',
message TEXT NOT NULL,
ipaddress varchar(30) NOT NULL default '',

  longipaddress int(10) NOT NULL default '0',

  longipaddress int(11) NOT NULL default '0',

  includesig int(1) NOT NULL default '0',
smilieoff int(1) NOT NULL default '0',
edituid int NOT NULL default '0',

  includesig int(1) NOT NULL default '0',
smilieoff int(1) NOT NULL default '0',
edituid int NOT NULL default '0',

Zeile 531Zeile 536
  anonymous int(1) NOT NULL default '0',
nopermission int(1) NOT NULL default '0',
location1 int(10) NOT NULL default '0',

  anonymous int(1) NOT NULL default '0',
nopermission int(1) NOT NULL default '0',
location1 int(10) NOT NULL default '0',

  location2 int(10) NOT NULL default '0',
loginattempts tinyint(2) NOT NULL default '1',
failedlogin bigint(30) NOT NULL default '0'
);";


  location2 int(10) NOT NULL default '0'
);";




$tables[] = "CREATE TABLE mybb_settinggroups (
gid INTEGER PRIMARY KEY,
name varchar(100) NOT NULL default '',

$tables[] = "CREATE TABLE mybb_settinggroups (
gid INTEGER PRIMARY KEY,
name varchar(100) NOT NULL default '',

Zeile 545Zeile 548
  isdefault int(1) NOT NULL default '0'
);";


  isdefault int(1) NOT NULL default '0'
);";






$tables[] = "CREATE TABLE mybb_settings (

$tables[] = "CREATE TABLE mybb_settings (

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

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

  description TEXT NOT NULL,
optionscode TEXT NOT NULL,
value TEXT NOT NULL,

  description TEXT NOT NULL,
optionscode TEXT NOT NULL,
value TEXT NOT NULL,

Zeile 600Zeile 603
	enabled int(1) NOT NULL default '1',
logging int(1) NOT NULL default '0',
locked bigint(30) NOT NULL default '0'

	enabled int(1) NOT NULL default '1',
logging int(1) NOT NULL default '0',
locked bigint(30) NOT NULL default '0'

);";


);";


$tables[] = "CREATE TABLE mybb_tasklog (
lid INTEGER PRIMARY KEY,
tid int NOT NULL default '0',
dateline bigint(30) NOT NULL default '0',
data TEXT NOT NULL );";

$tables[] = "CREATE TABLE mybb_tasklog (
lid INTEGER PRIMARY KEY,
tid int NOT NULL default '0',
dateline bigint(30) NOT NULL default '0',
data TEXT NOT NULL );";





$tables[] = "CREATE TABLE mybb_templategroups (
gid INTEGER PRIMARY KEY,
prefix varchar(50) NOT NULL default '',
title varchar(100) NOT NULL default ''

$tables[] = "CREATE TABLE mybb_templategroups (
gid INTEGER PRIMARY KEY,
prefix varchar(50) NOT NULL default '',
title varchar(100) NOT NULL default ''

);";


);";


$tables[] = "CREATE TABLE mybb_templates (
tid INTEGER PRIMARY KEY,
title varchar(120) NOT NULL default '',

$tables[] = "CREATE TABLE mybb_templates (
tid INTEGER PRIMARY KEY,
title varchar(120) NOT NULL default '',

Zeile 651Zeile 654

$tables[] = "CREATE TABLE mybb_threadratings (
rid INTEGER PRIMARY KEY,


$tables[] = "CREATE TABLE mybb_threadratings (
rid INTEGER PRIMARY KEY,

  tid int NOT NULL default '0',

  tid int NOT NULL default '0',

  uid int NOT NULL default '0',
rating smallint NOT NULL default '0',
ipaddress varchar(30) NOT NULL default ''

  uid int NOT NULL default '0',
rating smallint NOT NULL default '0',
ipaddress varchar(30) NOT NULL default ''

Zeile 685Zeile 688
  unapprovedposts int(10) NOT NULL default '0',
attachmentcount int(10) NOT NULL default '0',
deletetime int(10) NOT NULL default '0'

  unapprovedposts int(10) NOT NULL default '0',
attachmentcount int(10) NOT NULL default '0',
deletetime int(10) NOT NULL default '0'

);";


);";


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

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

);";


);";


$tables[] = "CREATE TABLE mybb_threadsubscriptions (
sid INTEGER PRIMARY KEY,
uid int NOT NULL default '0',

$tables[] = "CREATE TABLE mybb_threadsubscriptions (
sid INTEGER PRIMARY KEY,
uid int NOT NULL default '0',

Zeile 706Zeile 709
  ufid int NOT NULL default '0',
fid1 TEXT NOT NULL,
fid2 TEXT NOT NULL,

  ufid int NOT NULL default '0',
fid1 TEXT NOT NULL,
fid2 TEXT NOT NULL,

  fid3 TEXT NOT NULL );";


  fid3 TEXT NOT NULL
);";


$tables[] = "CREATE TABLE mybb_usergroups (
gid INTEGER PRIMARY KEY,


$tables[] = "CREATE TABLE mybb_usergroups (
gid INTEGER PRIMARY KEY,

Zeile 833Zeile 837
  reputation bigint(30) NOT NULL default '0',
regip varchar(50) NOT NULL default '',
lastip varchar(50) NOT NULL default '',

  reputation bigint(30) NOT NULL default '0',
regip varchar(50) NOT NULL default '',
lastip varchar(50) NOT NULL default '',

  longregip int(10) NOT NULL default '0',
longlastip int(10) NOT NULL default '0',

  longregip int(11) NOT NULL default '0',
longlastip int(11) NOT NULL default '0',

  language varchar(50) NOT NULL default '',
timeonline bigint(30) NOT NULL default '0',
showcodebuttons int(1) NOT NULL default '1',

  language varchar(50) NOT NULL default '',
timeonline bigint(30) NOT NULL default '0',
showcodebuttons int(1) NOT NULL default '1',

Zeile 846Zeile 850
  suspendposting int(1) NOT NULL default '0',
suspensiontime bigint(30) NOT NULL default '0',
coppauser int(1) NOT NULL default '0',

  suspendposting int(1) NOT NULL default '0',
suspensiontime bigint(30) NOT NULL default '0',
coppauser int(1) NOT NULL default '0',

  classicpostbit 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'
);";



$tables[] = "CREATE TABLE mybb_usertitles (
utid INTEGER PRIMARY KEY,


$tables[] = "CREATE TABLE mybb_usertitles (
utid INTEGER PRIMARY KEY,

Zeile 861Zeile 867
$tables[] = "CREATE TABLE mybb_warninglevels (
lid INTEGER PRIMARY KEY,
percentage int(2) NOT NULL default '0',

$tables[] = "CREATE TABLE mybb_warninglevels (
lid INTEGER PRIMARY KEY,
percentage int(2) NOT NULL default '0',

	action TEXT NOT NULL );";


	action TEXT NOT NULL
);";


$tables[] = "CREATE TABLE mybb_warningtypes (
tid INTEGER PRIMARY KEY,


$tables[] = "CREATE TABLE mybb_warningtypes (
tid INTEGER PRIMARY KEY,