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

#
# Tabellenstruktur für Tabelle `inproceeding`
#

CREATE TABLE inproceeding (
  InProceedingId int(11) NOT NULL auto_increment,
  Title varchar(255) NOT NULL default '',
  Pages varchar(15) default NULL,
  Url varchar(255) default NULL,
  ProceedingId int(11) default NULL,
  PRIMARY KEY  (InProceedingId),
  KEY ProceedingId (ProceedingId)
) TYPE=MyISAM;

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

#
# Tabellenstruktur für Tabelle `person`
#

CREATE TABLE person (
  PersonId int(11) NOT NULL auto_increment,
  Name varchar(255) NOT NULL default '',
  PRIMARY KEY  (PersonId)
) TYPE=MyISAM;

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

#
# Tabellenstruktur für Tabelle `proceeding`
#

CREATE TABLE proceeding (
  ProceedingId int(11) NOT NULL auto_increment,
  Title varchar(255) NOT NULL default '',
  EditorId int(11) default NULL,
  PublisherId int(11) default NULL,
  SeriesId int(11) default NULL,
  Year varchar(15) NOT NULL default '',
  ISBN varchar(15) default NULL,
  Url varchar(255) default NULL,
  PRIMARY KEY  (ProceedingId),
  KEY EditorId (EditorId),
  KEY PublisherId (PublisherId),
  KEY SeriesId (SeriesId)
) TYPE=MyISAM;

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

#
# Tabellenstruktur für Tabelle `publisher`
#

CREATE TABLE publisher (
  PublisherId int(11) NOT NULL auto_increment,
  Name varchar(255) NOT NULL default '',
  PRIMARY KEY  (PublisherId)
) TYPE=MyISAM;

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

#
# Tabellenstruktur für Tabelle `relationpersoninproceeding`
#

CREATE TABLE relationpersoninproceeding (
  PersonId int(11) NOT NULL default '0',
  InProceedingId int(11) NOT NULL default '0',
  PRIMARY KEY  (PersonId,InProceedingId),
  KEY InProceedingId (InProceedingId)
) TYPE=MyISAM;

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

#
# Tabellenstruktur für Tabelle `series`
#

CREATE TABLE series (
  SeriesId int(11) NOT NULL auto_increment,
  Title varchar(255) NOT NULL default '',
  Url varchar(255) default NULL,
  PRIMARY KEY  (SeriesId)
) TYPE=MyISAM;
CREATE TABLE Person (
  PersonId int(11) default NULL,
  Name text
) TYPE=MyISAM;

CREATE TABLE Publisher (
  PublisherId int(11) default NULL,
  Name text
) TYPE=MyISAM;

CREATE TABLE Series (
  SeriesId int(11) default NULL,
  Title text,
  Url text
) TYPE=MyISAM;

CREATE TABLE Proceeding (
  ProceedingId int(11) default NULL,
  Title text,
  EditorId int(11) default NULL,
  PublisherId int(11) default NULL,
  SeriesId int(11) default NULL,
  Year text,
  ISBN text,
  Url text
) TYPE=MyISAM;

CREATE TABLE InProceeding (
  InProceedingId int(11) default NULL,
  Title text,
  Pages text,
  Url text,
  ProceedingId int(11)
) TYPE=MyISAM;

CREATE TABLE RelationPersonInProceeding (
  PersonId int(11) default NULL,
  InProceedingId int(11) default NULL
) TYPE=MyISAM;