/*
SQLyog Pro - MySQL GUI v5.0
Host - 5.0.16-nt : Database - repliwiki
*********************************************************************
Server version : 5.0.16-nt
*/


create database if not exists `repliwiki`;

USE `repliwiki`;

/*Table structure for table `articles` */

DROP TABLE IF EXISTS `articles`;

CREATE TABLE `articles` (
  `title` mediumtext NOT NULL,
  `author` varchar(45) NOT NULL default '',
  `domain` varchar(45) NOT NULL default '',
  `timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
  `text` longtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Table structure for table `trace` */

DROP TABLE IF EXISTS `trace`;

CREATE TABLE `trace` (
  `title` mediumtext NOT NULL,
  `author` varchar(45) NOT NULL default '',
  `domain` varchar(45) NOT NULL,
  `timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
  `text` longtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Table structure for table `updates` */

DROP TABLE IF EXISTS `updates`;

CREATE TABLE `updates` (
  `hash` varchar(45) NOT NULL default ''
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Table structure for table `users` */

DROP TABLE IF EXISTS `users`;

CREATE TABLE `users` (
  `username` varchar(45) NOT NULL,
  `password` varchar(45) NOT NULL,
  `domain` varchar(45) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;