Codice:
# phpMyAdmin MySQL-Dump
# version 2.3.1-rc1
# http://www.phpmyadmin.net/ (download page)
#
# servidor: localhost
# Tiempo de generación: 18-03-2004 a las 21:58:28
# Versión del servidor: 4.00.15
# Versión de PHP: 4.3.4
# Base de datos : `nuke`
# --------------------------------------------------------
#
# Estructura de tabla para la tabla `nuke_authors`
#
CREATE TABLE nuke_authors (
aid varchar(25) NOT NULL default '',
name varchar(50) default NULL,
url varchar(255) NOT NULL default '',
email varchar(255) NOT NULL default '',
pwd varchar(40) default NULL,
counter int(11) NOT NULL default '0',
radminarticle tinyint(2) NOT NULL default '0',
radmintopic tinyint(2) NOT NULL default '0',
radminuser tinyint(2) NOT NULL default '0',
radminsurvey tinyint(2) NOT NULL default '0',
radminsection tinyint(2) NOT NULL default '0',
radminlink tinyint(2) NOT NULL default '0',
radminephem tinyint(2) NOT NULL default '0',
radminfaq tinyint(2) NOT NULL default '0',
radmindownload tinyint(2) NOT NULL default '0',
radminreviews tinyint(2) NOT NULL default '0',
radminnewsletter tinyint(2) NOT NULL default '0',
radminforum tinyint(2) NOT NULL default '0',
radmincontent tinyint(2) NOT NULL default '0',
radminency tinyint(2) NOT NULL default '0',
radminsuper tinyint(2) NOT NULL default '1',
admlanguage varchar(30) NOT NULL default '',
PRIMARY KEY (aid),
KEY aid (aid)
) TYPE=MyISAM;
#
# Volcar la base de datos para la tabla `nuke_authors`
#
# --------------------------------------------------------
#
# Estructura de tabla para la tabla `nuke_autonews`
#
CREATE TABLE nuke_autonews (
anid int(11) NOT NULL auto_increment,
catid int(11) NOT NULL default '0',
aid varchar(30) NOT NULL default '',
title varchar(80) NOT NULL default '',
time varchar(19) NOT NULL default '',
hometext text NOT NULL,
bodytext text NOT NULL,
topic int(3) NOT NULL default '1',
informant varchar(20) NOT NULL default '',
notes text NOT NULL,
ihome int(1) NOT NULL default '0',
alanguage varchar(30) NOT NULL default '',
acomm int(1) NOT NULL default '0',
associated text NOT NULL,
PRIMARY KEY (anid),
KEY anid (anid)
) TYPE=MyISAM;
#
# Volcar la base de datos para la tabla `nuke_autonews`
#
# --------------------------------------------------------
#
# Estructura de tabla para la tabla `nuke_banner`
#
CREATE TABLE nuke_banner (
bid int(11) NOT NULL auto_increment,
cid int(11) NOT NULL default '0',
imptotal int(11) NOT NULL default '0',
impmade int(11) NOT NULL default '0',
clicks int(11) NOT NULL default '0',
imageurl varchar(100) NOT NULL default '',
clickurl varchar(200) NOT NULL default '',
alttext varchar(255) NOT NULL default '',
date datetime default NULL,
dateend datetime default NULL,
type tinyint(1) NOT NULL default '0',
active tinyint(1) NOT NULL default '1',
PRIMARY KEY (bid),
KEY bid (bid),
KEY cid (cid)
) TYPE=MyISAM;
#
# Volcar la base de datos para la tabla `nuke_banner`
#
# --------------------------------------------------------
#
# Estructura de tabla para la tabla `nuke_bannerclient`
#
CREATE TABLE nuke_bannerclient (
cid int(11) NOT NULL auto_increment,
name varchar(60) NOT NULL default '',
contact varchar(60) NOT NULL default '',
email varchar(60) NOT NULL default '',
login varchar(10) NOT NULL default '',
passwd varchar(10) NOT NULL default '',
extrainfo text NOT NULL,
PRIMARY KEY (cid),
KEY cid (cid)
) TYPE=MyISAM;
#
# Volcar la base de datos para la tabla `nuke_bannerclient`
#
# --------------------------------------------------------
#
# Estructura de tabla para la tabla `nuke_bbauth_access`
#
CREATE TABLE nuke_bbauth_access (
group_id mediumint(8) NOT NULL default '0',
forum_id smallint(5) unsigned NOT NULL default '0',
auth_view tinyint(1) NOT NULL default '0',
auth_read tinyint(1) NOT NULL default '0',
auth_post tinyint(1) NOT NULL default '0',
auth_reply tinyint(1) NOT NULL default '0',
auth_edit tinyint(1) NOT NULL default '0',
auth_delete tinyint(1) NOT NULL default '0',
auth_sticky tinyint(1) NOT NULL default '0',
auth_announce tinyint(1) NOT NULL default '0',
auth_vote tinyint(1) NOT NULL default '0',
auth_pollcreate tinyint(1) NOT NULL default '0',
auth_attachments tinyint(1) NOT NULL default '0',
auth_mod tinyint(1) NOT NULL default '0',
KEY group_id (group_id),
KEY forum_id (forum_id)
) TYPE=MyISAM;
#
# Volcar la base de datos para la tabla `nuke_bbauth_access`
#
# --------------------------------------------------------
#
# Estructura de tabla para la tabla `nuke_bbbanlist`
#
CREATE TABLE nuke_bbbanlist (
ban_id mediumint(8) unsigned NOT NULL auto_increment,
ban_userid mediumint(8) NOT NULL default '0',
ban_ip varchar(8) NOT NULL default '',
ban_email varchar(255) default NULL,
ban_time int(11) default NULL,
ban_expire_time int(11) default NULL,
ban_by_userid mediumint(8) default NULL,
ban_priv_reason text,
ban_pub_reason_mode tinyint(1) default NULL,
ban_pub_reason text,
PRIMARY KEY (ban_id),
KEY ban_ip_user_id (ban_ip,ban_userid)
) TYPE=MyISAM;
#
# Volcar la base de datos para la tabla `nuke_bbbanlist`
#
# --------------------------------------------------------
#
# Estructura de tabla para la tabla `nuke_bbcategories`
#
CREATE TABLE nuke_bbcategories (
cat_id mediumint(8) unsigned NOT NULL auto_increment,
cat_title varchar(100) default NULL,
cat_order mediumint(8) unsigned NOT NULL default '0',
PRIMARY KEY (cat_id),
KEY cat_order (cat_order)
) TYPE=MyISAM;
#
# Volcar la base de datos para la tabla `nuke_bbcategories`
#
# --------------------------------------------------------
#
# Estructura de tabla para la tabla `nuke_bbconfig`
#
CREATE TABLE nuke_bbconfig (
config_name varchar(255) NOT NULL default '',
config_value varchar(255) NOT NULL default '',
PRIMARY KEY (config_name)
) TYPE=MyISAM;
#.................
questo l ho gia caricato