View file wapforum2/tables.txt

# phpMyAdmin MySQL-Dump
# version 2.3.2
# http://www.phpmyadmin.net/ (download page)
#
# Prisijungimo adresas: localhost
# Atlikimo laikas:  2004 m. Gruodzio 26 d.  16:42
# Serverio versija: 4.00.00
# PHP versija: 4.2.3
# Duomenu baze : `delto_wapforum`
# --------------------------------------------------------

#
# Sukurta duomenu struktura lentelei `administrators`
#

CREATE TABLE administrators (
  id int(11) NOT NULL auto_increment,
  name varchar(99) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

#
# Sukurta duomenu kopija lentelei `administrators`
#

INSERT INTO administrators VALUES (1, 'agressor');
# --------------------------------------------------------

#
# Sukurta duomenu struktura lentelei `annonces`
#

CREATE TABLE annonces (
  numero int(11) default NULL,
  nom varchar(45) default NULL,
  auteur varchar(30) default NULL,
  email varchar(50) default NULL,
  contenu blob,
  rubrique varchar(20) default NULL,
  telephone varchar(10) default NULL,
  date int(11) default NULL
) TYPE=MyISAM;

#
# Sukurta duomenu kopija lentelei `annonces`
#

# --------------------------------------------------------

#
# Sukurta duomenu struktura lentelei `buddylist`
#

CREATE TABLE buddylist (
  id int(100) NOT NULL auto_increment,
  whos varchar(255) NOT NULL default '',
  buddy varchar(255) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

#
# Sukurta duomenu kopija lentelei `buddylist`
#

# --------------------------------------------------------

#
# Sukurta duomenu struktura lentelei `chat`
#

CREATE TABLE chat (
  id int(10) NOT NULL auto_increment,
  msg varchar(150) NOT NULL default '',
  sentby varchar(40) NOT NULL default '',
  time int(30) NOT NULL default '0',
  sent varchar(30) NOT NULL default '',
  room varchar(50) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

#
# Sukurta duomenu kopija lentelei `chat`
#


# --------------------------------------------------------

#
# Sukurta duomenu struktura lentelei `chatonline`
#

CREATE TABLE chatonline (
  id int(20) NOT NULL auto_increment,
  name varchar(32) NOT NULL default '',
  room varchar(50) NOT NULL default '',
  time varchar(30) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

#
# Sukurta duomenu kopija lentelei `chatonline`
#

# --------------------------------------------------------

#
# Sukurta duomenu struktura lentelei `counter`
#

CREATE TABLE counter (
  id int(5) NOT NULL default '0',
  visitors int(99) NOT NULL default '0'
) TYPE=MyISAM;

#
# Sukurta duomenu kopija lentelei `counter`
#

INSERT INTO counter VALUES (1, 310);
# --------------------------------------------------------

#
# Sukurta duomenu struktura lentelei `forums`
#

CREATE TABLE forums (
  id int(10) NOT NULL auto_increment,
  name varchar(99) NOT NULL default '',
  perms int(99) NOT NULL default '0',
  position int(99) NOT NULL default '0',
  adminonl varchar(10) NOT NULL default '',
  modonl varchar(10) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

#
# Sukurta duomenu kopija lentelei `forums`
#

# --------------------------------------------------------

#
# Sukurta duomenu struktura lentelei `log`
#

CREATE TABLE log (
  id int(10) NOT NULL auto_increment,
  date varchar(99) NOT NULL default '',
  text varchar(255) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

#
# Sukurta duomenu kopija lentelei `log`
#

# --------------------------------------------------------

#
# Sukurta duomenu struktura lentelei `moderators`
#

CREATE TABLE moderators (
  id int(11) NOT NULL auto_increment,
  name varchar(99) NOT NULL default '',
  forum varchar(99) NOT NULL default '0',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

#
# Sukurta duomenu kopija lentelei `moderators`
#

# --------------------------------------------------------

#
# Sukurta duomenu struktura lentelei `online`
#

CREATE TABLE online (
  laikas int(15) NOT NULL default '0',
  username varchar(40) NOT NULL default '',
  PRIMARY KEY  (laikas),
  UNIQUE KEY username (username)
) TYPE=MyISAM;

#
# Sukurta duomenu kopija lentelei `online`
#

# --------------------------------------------------------

#
# Sukurta duomenu struktura lentelei `online2`
#

CREATE TABLE online2 (
  timeuser int(12) NOT NULL default '0',
  userip varchar(40) NOT NULL default ''
) TYPE=MyISAM;

#
# Sukurta duomenu kopija lentelei `online2`
#

# --------------------------------------------------------

#
# Sukurta duomenu struktura lentelei `permissions`
#

CREATE TABLE permissions (
  id int(99) NOT NULL auto_increment,
  name varchar(99) NOT NULL default '',
  forum varchar(99) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

#
# Sukurta duomenu kopija lentelei `permissions`
#

# --------------------------------------------------------

#
# Sukurta duomenu struktura lentelei `posts`
#

CREATE TABLE posts (
  id int(99) NOT NULL auto_increment,
  forum int(99) NOT NULL default '0',
  postedby varchar(99) NOT NULL default '',
  name varchar(30) NOT NULL default '',
  text varchar(200) NOT NULL default '',
  thread char(1) NOT NULL default '',
  position bigint(99) NOT NULL default '0',
  perms int(99) NOT NULL default '0',
  pinned varchar(5) NOT NULL default '',
  closed varchar(5) NOT NULL default '',
  date varchar(255) NOT NULL default '',
  PRIMARY KEY  (id),
  KEY name (name),
  KEY text (text),
  FULLTEXT KEY text_2 (text)
) TYPE=MyISAM;

#
# Sukurta duomenu kopija lentelei `posts`
#

# --------------------------------------------------------

#
# Sukurta duomenu struktura lentelei `private`
#

CREATE TABLE private (
  id int(99) NOT NULL auto_increment,
  unread varchar(5) NOT NULL default '',
  sentby varchar(255) NOT NULL default '',
  sentto varchar(255) NOT NULL default '',
  text varchar(255) NOT NULL default '',
  date varchar(100) NOT NULL default '',
  timesent int(50) NOT NULL default '0',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

#
# Sukurta duomenu kopija lentelei `private`
#

# --------------------------------------------------------

#
# Sukurta duomenu struktura lentelei `rooms`
#

CREATE TABLE rooms (
  id int(30) NOT NULL auto_increment,
  name varchar(50) NOT NULL default '',
  private char(2) NOT NULL default '',
  pinned char(2) NOT NULL default '',
  roomstart varchar(30) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

#
# Sukurta duomenu kopija lentelei `rooms`
#

# --------------------------------------------------------

#
# Sukurta duomenu struktura lentelei `smilies`
#

CREATE TABLE smilies (
  id int(10) NOT NULL auto_increment,
  bbcode varchar(200) NOT NULL default '',
  changeto varchar(200) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

#
# Sukurta duomenu kopija lentelei `smilies`
#

# --------------------------------------------------------

#
# Sukurta duomenu struktura lentelei `users`
#

CREATE TABLE users (
  id int(10) NOT NULL auto_increment,
  name varchar(32) NOT NULL default '',
  pass varchar(54) NOT NULL default '',
  postno int(100) NOT NULL default '0',
  pluses int(99) NOT NULL default '0',
  status varchar(99) NOT NULL default '',
  owntext varchar(100) NOT NULL default '',
  email varchar(50) NOT NULL default '',
  banned char(2) NOT NULL default '',
  bannedby varchar(100) NOT NULL default '',
  banto int(40) NOT NULL default '0',
  tlphone varchar(99) NOT NULL default '',
  site varchar(50) NOT NULL default '',
  avatar varchar(100) NOT NULL default '',
  lastpost int(100) NOT NULL default '0',
  lastthread int(100) NOT NULL default '0',
  banreason varchar(255) NOT NULL default '',
  plusreason varchar(255) NOT NULL default '',
  pms int(255) NOT NULL default '0',
  age int(2) NOT NULL default '0',
  city varchar(40) NOT NULL default '',
  likes varchar(100) NOT NULL default '',
  chate char(2) NOT NULL default 'n',
  pradejo int(30) NOT NULL default '0',
  chtmsg int(50) NOT NULL default '0',
  chtroom varchar(50) NOT NULL default '',
  requesting varchar(100) NOT NULL default '',
  reqban longtext NOT NULL,
  PRIMARY KEY  (id),
  UNIQUE KEY name (name)
) TYPE=MyISAM;

#
# Sukurta duomenu kopija lentelei `users`
#

# --------------------------------------------------------

#
# Sukurta duomenu struktura lentelei `vartotoju`
#

CREATE TABLE vartotoju (
  laikas int(15) NOT NULL default '0',
  ip varchar(40) NOT NULL default '',
  file varchar(100) NOT NULL default '',
  PRIMARY KEY  (laikas),
  KEY ip (ip),
  KEY file (file)
) TYPE=MyISAM;

#
# Sukurta duomenu kopija lentelei `vartotoju`
#