-- phpMyAdmin SQL Dump
-- version 2.8.2.1
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: May 24, 2008 at 06:11 PM
-- Server version: 5.0.51
-- PHP Version: 5.2.1
-- 
-- Database: `phpmyide`
-- 

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

-- 
-- Table structure for table `preferences`
-- 

CREATE TABLE `preferences` (
  `key` varchar(32) NOT NULL,
  `value` varchar(254) NOT NULL,
  PRIMARY KEY  (`key`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `preferences`
-- 

INSERT INTO `preferences` (`key`, `value`) VALUES ('print_headertitle', '1'),
('print_pagenumbers', '1'),
('print_headerdate', '1'),
('print_linenumbers', '1'),
('print_fontsize', '11'),
('print_fontname', 'courier');

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

-- 
-- Table structure for table `timemachine`
-- 

CREATE TABLE `timemachine` (
  `descriptor` varchar(254) NOT NULL,
  `uid` int(11) NOT NULL auto_increment,
  `timestamp` datetime NOT NULL,
  `createsql` text NOT NULL,
  PRIMARY KEY  (`descriptor`,`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


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

-- 
-- Table structure for table `triggers`
-- 

CREATE TABLE `triggers` (
  `dbname` varchar(128) NOT NULL,
  `tablename` varchar(64) NOT NULL,
  `timing` varchar(32) NOT NULL,
  `oneshot` char(1) NOT NULL default '0',
  `script` text NOT NULL,
  PRIMARY KEY  (`dbname`,`tablename`,`timing`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;