changed:
-
# phpMyAdmin MySQL-Dump
# version 2.2.3
# http://phpwizard.net/phpMyAdmin/
# http://phpmyadmin.sourceforge.net/ (download page)
#
# Host: localhost
# Erstellungszeit: 11. Feb 2005 um 13:37
# Server Version: 3.23.51
# PHP Version: 4.1.2
# Datenbank : `pd`
# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `Abstraction`
#

CREATE TABLE Abstraction (
  Abstraction_ID smallint(6) NOT NULL auto_increment,
  Author_ID smallint(6) default NULL,
  Abstraction_Name varchar(255) default NULL,
  Abstraction_Description varchar(255) default NULL,
  URL_ID smallint(6) default NULL,
  Library_ID smallint(6) default NULL,
  Help_Patch_URL varchar(255) default NULL,
  PRIMARY KEY  (Abstraction_ID)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `Author`
#

CREATE TABLE Author (
  Author_ID smallint(6) NOT NULL auto_increment,
  Author varchar(255) default NULL,
  PRIMARY KEY  (Author_ID)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `External`
#

CREATE TABLE External (
  External_ID smallint(6) NOT NULL auto_increment,
  Author_ID smallint(6) default NULL,
  External_Name varchar(255) default NULL,
  External_Description varchar(255) default NULL,
  URL_ID smallint(6) default NULL,
  Library_ID smallint(6) default NULL,
  HelpPatch varchar(255) default NULL,
  Type char(3) default NULL,
  PRIMARY KEY  (External_ID)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `Library`
#

CREATE TABLE Library (
  Library_ID smallint(6) NOT NULL auto_increment,
  Author_ID smallint(6) default NULL,
  Library_Name varchar(255) default NULL,
  Library_Description varchar(255) default NULL,
  URL_ID smallint(6) default NULL,
  Platform varchar(255) default NULL,
  Version varchar(40) default NULL,
  PRIMARY KEY  (Library_ID)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `Patch`
#

CREATE TABLE Patch (
  Patch_ID smallint(6) NOT NULL auto_increment,
  Author_ID smallint(6) default NULL,
  Patch_Name varchar(255) default NULL,
  Patch_Description varchar(255) default NULL,
  URL_ID smallint(6) default NULL,
  Library_ID smallint(6) default NULL,
  PRIMARY KEY  (Patch_ID)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `URL`
#

CREATE TABLE URL (
  URL_ID smallint(6) NOT NULL auto_increment,
  Download varchar(255) default NULL,
  Documentation varchar(255) default NULL,
  PRIMARY KEY  (URL_ID)
) TYPE=MyISAM;