#
# mSQL Dump  (requires mSQL 2.0 Beta 5 or newer)
#
# Host: localhost    Database: epics
#--------------------------------------------------------


#
# Table structure for table 'maintenance'
#
CREATE TABLE maintenance (
  task CHAR(20),
  email1 CHAR(40),
  email2 CHAR(40),
  long_task TEXT(1024),
  last_maintenance INT,
  next_maintenance INT,
  period INT,
  period_type INT
) \g

CREATE UNIQUE  INDEX idx1 ON maintenance (
	task
) \g

CREATE   INDEX idx2 ON maintenance (
	next_maintenance
) \g


#
# Dumping data for table 'maintenance'
#