codi SQL que crea la base de dades

CREATE DATABASE `apamdb`;

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

# Estructura de la taula node

CREATE TABLE `node` (
`id_node` int(11) unsigned NOT NULL auto_increment,
`url` BLOB NOT NULL,
`data` timestamp(14) NOT NULL default '20040106083000',
`vida` int(5) unsigned NOT NULL default '500',
`nhash` varchar(255) default NULL,
PRIMARY KEY (`id_node`)
) TYPE=MyISAM COMMENT='Aquesta taula guarda la informacio basica de cada node.' AUTO_INCREMENT=1 ;

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

# Estructura de la taula `recurs`

CREATE TABLE `recurs` (
`id_recurs` int(11) unsigned NOT NULL auto_increment,
`html` text NOT NULL ,
`src` blob NULL ,
`width` smallint (4) unsigned NULL default '0',
`height` smallint (4) unsigned NULL default '0',
`text` text NULL,
`m1` char (24) NULL default 'null',
`m2` char (24) NULL default 'null',
`m3` char (24) NULL default 'null',
PRIMARY KEY `id_recurs` (`id_recurs`)
) TYPE=MyISAM COMMENT='Taula que registra els recursos (imatges, textos,...) que son la base dels enllacos' AUTO_INCREMENT=1 ;

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

# Estructura de la taula nodenode

CREATE TABLE `nodenode` (
`id_nodenode` int(11) unsigned NOT NULL auto_increment,
`id_nodeWilliam` int(11) unsigned NOT NULL REFERENCES node(id_node),
`id_nodeTellapple` int(11) unsigned NOT NULL REFERENCES node(id_node),
PRIMARY KEY (`id_nodenode`)
) TYPE=MyISAM COMMENT='Aquesta taula connecta els nodes de la taula node que s enllacen entre si' ;

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

# Estructura de la taula noderecurs

CREATE TABLE `noderecurs` (
`id_noderecurs` int(11) unsigned NOT NULL auto_increment,
`id_node` int(11) unsigned NOT NULL REFERENCES node (id_node),
`id_recurs` int(11) unsigned NOT NULL REFERENCES recurs (id_recurs),
PRIMARY KEY (`id_noderecurs`)
) TYPE=MyISAM COMMENT='taula que relaciona taules Node i Recurs connectant recursos amb la pagina a la que enllacen' AUTO_INCREMENT=1 ;

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

# Estructura de la taula apamprefs

CREATE TABLE `apamprefs` (
`id_prefs` int(11) unsigned NOT NULL auto_increment,
`nomprefs`char(32) NULL,
`vida_L` int(5) unsigned NOT NULL DEFAULT 0,
`vida_nV` int(5) unsigned NOT NULL,
`vida_nNV` int(5) unsigned NOT NULL,
PRIMARY KEY (`id_prefs`)
) TYPE=MyISAM COMMENT='taula de preferencies de apam' AUTO_INCREMENT=1 ;