# This file is part of the Basilic system
# Copyright (C) 2004  Gilles Debunne (Gilles.Debunne@imag.fr)
# Version 1.5.13, packaged on November 9, 2005.
# 
# http://artis.imag.fr/Software/Basilic
# 
# Basilic  is  free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published
# by the Free Software Foundation; either version 2 of the License,
# or (at your option) any later version.
# 
# Basilic  is  distributed  in the hope that it will be useful, but
# WITHOUT  ANY  WARRANTY ; without  even  the  implied  warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
# General Public License for more details.
# 
# You should have received a copy of the GNU General Public License
# along with Basilic; if not, write to the Free Software Foundation
# Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
# phpMyAdmin MySQL-Dump
# version 2.4.0
# http://www.phpmyadmin.net/ (download page)
#
# Database : `basilic`
# --------------------------------------------------------

#
# Table structure for table `authors`
#

CREATE TABLE authors (
  id smallint(5) unsigned NOT NULL auto_increment,
  first varchar(30) NOT NULL default '',
  last varchar(30) NOT NULL default '',
  url varchar(100) default NULL,
  PRIMARY KEY  (id),
  KEY kfirst (first,last)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `docs`
#

CREATE TABLE docs (
  id smallint(6) unsigned NOT NULL auto_increment,
  type enum('PDF','PS','PPT','ABS','IMG','MOV','INFO') NOT NULL default 'PDF',
  source varchar(255) NOT NULL default '',
  size int(10) unsigned default NULL,
  sizeX smallint(5) unsigned default NULL,
  sizeY smallint(5) unsigned default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `publiauthors`
#

CREATE TABLE publiauthors (
  idAuthor smallint(5) unsigned NOT NULL default '0',
  idPubli smallint(5) unsigned NOT NULL default '0',
  rank smallint(5) unsigned NOT NULL default '0'
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `publidocs`
#

CREATE TABLE publidocs (
  idDoc smallint(6) unsigned NOT NULL default '0',
  idPubli smallint(5) unsigned NOT NULL default '0'
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `publis`
#

CREATE TABLE publis (
  id smallint(5) unsigned NOT NULL auto_increment,
  bibTex varchar(20) NOT NULL default '',
  entry enum('Article','InProceedings','InBook','Book','PhdThesis','MastersThesis','TechReport','Misc','Booklet','InCollection','Manual','Proceedings','Unpublished') NOT NULL default 'Article',
  address varchar(255) default NULL,
  booktitle varchar(255) default NULL,
  chapter varchar(30) default NULL,
  edition varchar(50) default NULL,
  editor varchar(255) default NULL,
  howpublished varchar(255) default NULL,
  institution varchar(255) default NULL,
  journal varchar(255) default NULL,
  keywords varchar(255) default NULL,
  month varchar(30) default NULL,
  note varchar(255) default NULL,
  number varchar(10) default NULL,
  optkey varchar(255) default NULL,
  organization varchar(255) default NULL,
  pages varchar(15) default NULL,
  publisher varchar(255) default NULL,
  school varchar(255) default NULL,
  series varchar(255) default NULL,
  title varchar(255) NOT NULL default '',
  type varchar(255) default NULL,
  volume varchar(20) default NULL,
  year year(4) NOT NULL default '0000',
  PRIMARY KEY  (id),
  UNIQUE KEY bibTex (bibTex)
) TYPE=MyISAM;