-- phpMyAdmin SQL Dump
-- version 2.11.9.6
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Nov 23, 2009 at 06:49 PM
-- Server version: 5.0.84
-- PHP Version: 5.2.11-pl1-gentoo

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `statutory`
--

-- --------------------------------------------------------

--
-- Table structure for table `CountryCodes`
--

CREATE TABLE IF NOT EXISTS `CountryCodes` (
  `Code` int(11) NOT NULL default '0',
  `Name` varchar(50) NOT NULL default '',
  `ISO_2` varchar(2) NOT NULL default '',
  `ISO_3` varchar(3) NOT NULL default '',
  `Postal` varchar(3) NOT NULL default '',
  `Continent` enum('EU','AF','AS','AU','NA','SA','') NOT NULL default '',
  `Fee` enum('low','high','unknown') NOT NULL default 'unknown',
  PRIMARY KEY  (`Code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=1;

-- --------------------------------------------------------

--
-- Table structure for table `files`
--

CREATE TABLE IF NOT EXISTS `files` (
  `id` int(11) NOT NULL auto_increment,
  `info_id` int(11) NOT NULL,
  `subject` varchar(64) NOT NULL,
  `filename` varchar(64) NOT NULL,
  `filetype` varchar(64) NOT NULL,
  `data` mediumblob NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `info`
--

CREATE TABLE IF NOT EXISTS `info` (
  `id` int(11) NOT NULL auto_increment,
  `subject` varchar(128) NOT NULL,
  `message` text NOT NULL,
  `access` enum('public','aegee','draft') NOT NULL default 'public',
  `dateadd` datetime NOT NULL,
  `datemodify` datetime NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

-- --------------------------------------------------------

--
-- Table structure for table `log`
--

CREATE TABLE IF NOT EXISTS `log` (
  `id` int(11) NOT NULL auto_increment,
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  `section` varchar(16) NOT NULL default '',
  `message` varchar(192) NOT NULL default '',
  `type` enum('info','warning','error') NOT NULL default 'info',
  `sess_name` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `querylog`
--

CREATE TABLE IF NOT EXISTS `querylog` (
  `id` int(11) NOT NULL auto_increment,
  `date` datetime NOT NULL,
  `sid` int(11) NOT NULL,
  `user` varchar(32) NOT NULL,
  `query` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `users`
--

CREATE TABLE IF NOT EXISTS `users` (
  `uid` int(11) NOT NULL auto_increment,
  `user` varchar(50) NOT NULL default '',
  `password` varchar(40) NOT NULL default '',
  `email` varchar(75) NOT NULL default '',
  `access` enum('no','view','edit','jc','localorg','chair','admin') NOT NULL default 'no',
  `privstatementagree` enum('yes','no') NOT NULL default 'no',
  PRIMARY KEY  (`uid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=9 ;
