Location: PHPKode > projects > Skrupel User Game Administration > doc/sql.txt
#
# Tabellenstruktur für Tabelle `skrupel_spiele`
#

CREATE TABLE skrupel_usedcommspiele (
  id int(11) NOT NULL auto_increment,
  spiel_name varchar(255) NOT NULL default '',
  siegbedingungen int(11) NOT NULL default '0',
  zielinfo_1 varchar(255) NOT NULL default '',
  zielinfo_2 varchar(255) NOT NULL default '',
  zielinfo_3 varchar(255) NOT NULL default '',
  zielinfo_4 varchar(255) NOT NULL default '',
  zielinfo_5 varchar(255) NOT NULL default '',
  user_1 varchar(255) NOT NULL default '',
  user_2 varchar(255) NOT NULL default '',
  user_3 varchar(255) NOT NULL default '',
  user_4 varchar(255) NOT NULL default '',
  user_5 varchar(255) NOT NULL default '',
  user_6 varchar(255) NOT NULL default '',
  user_7 varchar(255) NOT NULL default '',
  user_8 varchar(255) NOT NULL default '',
  user_9 varchar(255) NOT NULL default '',
  user_10 varchar(255) NOT NULL default '',
  rasse_1 varchar(255) NOT NULL default '',
  rasse_2 varchar(255) NOT NULL default '',
  rasse_3 varchar(255) NOT NULL default '',
  rasse_4 varchar(255) NOT NULL default '',
  rasse_5 varchar(255) NOT NULL default '',
  rasse_6 varchar(255) NOT NULL default '',
  rasse_7 varchar(255) NOT NULL default '',
  rasse_8 varchar(255) NOT NULL default '',
  rasse_9 varchar(255) NOT NULL default '',
  rasse_10 varchar(255) NOT NULL default '',
  spieler_admin int(11) NOT NULL default '',
  startposition int(11) NOT NULL default '',
  imperiumgroesse int(11) NOT NULL default '',
  geldmittel int(11) NOT NULL default '',
  mineralienhome int(11) NOT NULL default '',
  sternendichte int(11) NOT NULL default '',
  mineralien int(11) NOT NULL default '',
  spezien int(11) NOT NULL default '',
  max int(11) NOT NULL default '',
  wahr int(11) NOT NULL default '',
  lang int(11) NOT NULL default '',
  instabil int(11) NOT NULL default '',
  stabil int(11) NOT NULL default '',
  leminvorkommen int(11) NOT NULL default '',
  umfang int(11) NOT NULL default '',
  struktur varchar(255) NOT NULL default '',
  modul_0 int(11) NOT NULL default '',
  modul_2 int(11) NOT NULL default '',
  team1 int(11) NOT NULL default '0',
  team2 int(11) NOT NULL default '0',
  team3 int(11) NOT NULL default '0',
  team4 int(11) NOT NULL default '0',
  team5 int(11) NOT NULL default '0',
  team6 int(11) NOT NULL default '0',
  team7 int(11) NOT NULL default '0',
  team8 int(11) NOT NULL default '0',
  team9 int(11) NOT NULL default '0',
  team10 int(11) NOT NULL default '0',
  nebel int(11) NOT NULL default '',
  piraten_mitte int(11) NOT NULL default '0',
  piraten_aussen int(11) NOT NULL default '0',
  piraten_min int(11) NOT NULL default '0',
  piraten_max int(11) NOT NULL default '0',
  playable int(11) NOT NULL default '0',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

CREATE TABLE skrupel_usedcommchatrooms (
  id int(11) NOT NULL auto_increment,
  name int(11) NOT NULL default '',
  realname varchar(255) NOT NULL default '',
  descr varchar(255) NOT NULL default '',
  moderator varchar(255) NOT NULL default '',
  pos int(11) NOT NULL default '',
  created int(20) NOT NULL default '',
  PRIMARY KEY (id)
) TYPE=MyISAM;

INSERT INTO skrupel_usedcommchatrooms (name,realname,descr,moderator) VALUES ('0','Raumhafen','Sammelpunkt aller Chatter','0');

CREATE TABLE skrupel_usedcommchatmessages_0 (
  id int(10) NOT NULL auto_increment,
  message longtext NOT NULL default '',
  user varchar(250) NOT NULL default '',
  datum date NOT NULL DEFAULT '0000-00-00',
  ip varchar(15) NOT NULL default '',
  xforwarded text NOT NULL default '',
  hostname varchar(100) NOT NULL default '',
  PRIMARY KEY (id)
) TYPE=MyISAM;

CREATE TABLE skrupel_usedcommchatusers (
  id int(11) NOT NULL auto_increment,
  nick varchar(20) NOT NULL default '',
  pass varchar(30) NOT NULL default '',
  room varchar(50) NOT NULL default '',
  name varchar(50) NOT NULL default '',
  email varchar(50) NOT NULL default '',
  active tinyint(1) NOT NULL default '',
  away tinyint(1) NOT NULL default '',
  banned tinyint(1) NOT NULL default '',
  mode tinyint(1) NOT NULL default '',
  lastaction int(20) NOT NULL default '',
  hpurl varchar(100) NOT NULL default '',
  imgurl varchar(100) NOT NULL default '',
  col varchar(6) NOT NULL default '',
  text text NOT NULL default '',
  guestbook tinyint(1) NOT NULL DEFAULT '000000',
  totaltime int(20) NOT NULL default '',
  totalmsgs int(20) NOT NULL default '',
  creation date NOT NULL DEFAULT '0000-00-00',
  lastip varchar(15) NOT NULL default '',
  lasthost varchar(100) NOT NULL default '',
  ignorelist longtext NOT NULL default '',
  PRIMARY KEY (id)
) TYPE=MyISAM;

INSERT INTO skrupel_usedcommchatusers (nick,pass,room) VALUES ('admin','password','0');

CREATE TABLE skrupel_usedcommchatusers_gb (
  id int(11) NOT NULL auto_increment,
  owner varchar(20) NOT NULL default '',
  von varchar(20) NOT NULL default '',
  title varchar(255) NOT NULL default '',
  text text NOT NULL default '',
  PRIMARY KEY (id)
) TYPE=MyISAM;

CREATE TABLE skrupel_usedcommmsgs (
  id int(11) NOT NULL auto_increment,
  datum date NOT NULL DEFAULT '0000-00-00',
  uhrzeit time NOT NULL DEFAULT '00:00:00',
  sentby varchar(100) NOT NULL default '',
  sentto varchar(100) NOT NULL default '',
  message text NOT NULL default '',
  PRIMARY KEY (id)
) TYPE=MyISAM;

CREATE TABLE skrupel_usedcommcounter (
  ID int(10) unsigned NOT NULL auto_increment,
  IP varchar(200) NOT NULL default '',
  TIME int(100) NOT NULL default '0',
  PRIMARY KEY  (id)
) TYPE=MyISAM AUTO_INCREMENT=6 ;

CREATE TABLE skrupel_usedcommnews (
  ID int(11) NOT NULL auto_increment,
  html_text longtext,
  headline varchar(80) default NULL,
  online tinyint(4) NOT NULL default '0',
  datum datetime default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;


CREATE TABLE skrupel_usedcommmessages (
  ID int(11) NOT NULL auto_increment,
  html_text longtext,
  headline varchar(80) default NULL,
  online tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (ID)
) TYPE=MyISAM;

CREATE TABLE skrupel_usedcommletter (
  ID int(11) NOT NULL auto_increment,
  html_text longtext,
  headline varchar(80) default NULL,
  online tinyint(4) NOT NULL default '0',
  datum datetime default NULL,
  PRIMARY KEY  (ID)
) TYPE=MyISAM;

CREATE TABLE skrupel_usedcommgetletter (
  id int(10) unsigned NOT NULL auto_increment,
  name varchar(200) NOT NULL default '',
  email varchar(200) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM;
Return current item: Skrupel User Game Administration