[DL-Learner SVN] SF.net SVN: dl-learner:[1091] trunk/src/dbpedia-navigator/localhost.sql

[<sk...@us...>]

Revision: 1091
          http://dl-learner.svn.sourceforge.net/dl-learner/?rev=1091&view=rev
Author:   sknappe
Date:     2008-08-15 13:53:47 +0000 (Fri, 15 Aug 2008)

Log Message:
-----------
added database schema for the database that is afterwords filled with data by CalculatePageRank.java Script

Added Paths:
-----------
    trunk/src/dbpedia-navigator/localhost.sql

Added: trunk/src/dbpedia-navigator/localhost.sql
===================================================================
--- trunk/src/dbpedia-navigator/localhost.sql	                        (rev 0)
+++ trunk/src/dbpedia-navigator/localhost.sql	2008-08-15 13:53:47 UTC (rev 1091)
@@ -0,0 +1,50 @@
+-- phpMyAdmin SQL Dump
+-- version 2.9.1
+-- http://www.phpmyadmin.net
+-- 
+-- Host: localhost
+-- Erstellungszeit: 15. August 2008 um 15:51
+-- Server Version: 5.0.67
+-- PHP-Version: 5.2.5
+-- 
+-- Datenbank: `navigator_db`
+-- 
+CREATE DATABASE `navigator_db` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
+USE `navigator_db`;
+
+-- --------------------------------------------------------
+
+-- 
+-- Tabellenstruktur für Tabelle `categories`
+-- 
+
+CREATE TABLE `categories` (
+  `category` varchar(330) NOT NULL,
+  `label` varchar(330) NOT NULL,
+  PRIMARY KEY  (`category`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+-- 
+-- Daten für Tabelle `categories`
+-- 
+
+
+-- --------------------------------------------------------
+
+-- 
+-- Tabellenstruktur für Tabelle `rank`
+-- 
+
+CREATE TABLE `rank` (
+  `name` varchar(330) NOT NULL,
+  `number` int(8) NOT NULL default '0',
+  `label` varchar(330) default NULL,
+  `category` varchar(330) default NULL,
+  PRIMARY KEY  (`name`),
+  FULLTEXT KEY `Label` (`label`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+-- 
+-- Daten für Tabelle `rank`
+-- 
+


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.