schema #2

-- MySQL dump 8.22
--
-- Host: localhost    Database: builds
---------------------------------------------------------
-- Server version	3.23.54-max-nt

--
-- Table structure for table 'authtable'
--
CREATE DATABASE builds;

use builds;

CREATE TABLE authtable (
  server varchar(30) default NULL,
  machine varchar(128) default NULL
) TYPE=MyISAM;

--
-- Table structure for table 'buildservers'
--

CREATE TABLE buildservers (
  server varchar(30) default NULL,
  description blob,
  port int(6) default NULL,
  status int(1) default NULL,
  globalmail varchar(64) default NULL
) TYPE=MyISAM;

--
-- Table structure for table 'changes'
--

CREATE TABLE changes (
  server varchar(30) default NULL,
  title varchar(30) default NULL,
  job varchar(25) default NULL,
  changes blob,
  KEY server (server),
  KEY title (title),
  KEY job (job),
  KEY changes (changes(128))
) TYPE=MyISAM;

--
-- Table structure for table 'comments'
--

CREATE TABLE comments (
  server varchar(30) default NULL,
  title varchar(30) default NULL,
  job varchar(25) default NULL,
  comment blob,
  KEY server (server),
  KEY title (title),
  KEY job (job),
  KEY comment (comment(128))
) TYPE=MyISAM;

--
-- Table structure for table 'configuration'
--

CREATE TABLE configuration (
  server varchar(30) NOT NULL default '',
  title varchar(30) NOT NULL default '',
  port varchar(64) default NULL,
  client blob,
  top varchar(255) default NULL,
  type varchar(255) default NULL,
  toolsdir blob,
  isimake varchar(4) default NULL,
  keeplevel int(4) default NULL,
  comment blob,
  sccs varchar(16) default NULL,
  browserlink blob,
  state int(2) default NULL,
  spam int(1) default NULL,
  buildsize bigint(64) default NULL,
  PRIMARY KEY  (server,title)
) TYPE=MyISAM;

--
-- Table structure for table 'joblog'
--

CREATE TABLE joblog (
  server varchar(30) default NULL,
  title varchar(30) default NULL,
  message varchar(255) default NULL,
  step int(2) default NULL
) TYPE=MyISAM;

--
-- Table structure for table 'jobs'
--

CREATE TABLE jobs (
  server varchar(30) default NULL,
  title varchar(30) default NULL,
  job varchar(25) default NULL,
  start int(15) default NULL,
  end int(15) default NULL,
  status int(2) default NULL,
  info blob,
  sccs varchar(16) default NULL,
  browserlink blob,
  buildsize bigint(64) default NULL,
  port varchar(64) default NULL,
  KEY server (server),
  KEY title (title),
  KEY job (job)
) TYPE=MyISAM;

--
-- Table structure for table 'monitorservers'
--

CREATE TABLE monitorservers (
  server varchar(30) default NULL,
  port int(6) default NULL,
  status int(1) default NULL
) TYPE=MyISAM;

--
-- Table structure for table 'proctree'
--

CREATE TABLE proctree (
  server varchar(30) default NULL,
  title varchar(30) default NULL,
  job varchar(25) default NULL,
  cmd blob,
  pid int(64) default NULL
) TYPE=MyISAM;

--
-- Table structure for table 'promotion'
--

CREATE TABLE promotion (
  server varchar(30) default NULL,
  title varchar(30) default NULL,
  job varchar(25) default NULL,
  at varchar(26) default NULL,
  bywhom varchar(60) default NULL,
  comment blob
) TYPE=MyISAM;

--
-- Table structure for table 'removed'
--

CREATE TABLE removed (
  server varchar(30) default NULL,
  title varchar(30) default NULL,
  job varchar(25) default NULL,
  at varchar(26) default NULL,
  action varchar(16) default NULL,
  directory blob
) TYPE=MyISAM;

--
-- Table structure for table 'restore'
--

CREATE TABLE restore (
  server varchar(30) default NULL,
  title varchar(30) default NULL,
  message varchar(255) default NULL,
  time int(15) default NULL,
  state int(2) default NULL
) TYPE=MyISAM;

--
-- Table structure for table 'semaphores'
--

CREATE TABLE semaphores (
  server varchar(30) default NULL,
  title varchar(30) default NULL,
  message varchar(255) default NULL,
  time int(15) default NULL,
  state int(2) default NULL
) TYPE=MyISAM;

--
-- Table structure for table 'subscription'
--

CREATE TABLE subscription (
  server varchar(30) default NULL,
  title varchar(30) default NULL,
  address varchar(64) default NULL
) TYPE=MyISAM;

--
-- Table structure for table 'pending'
--

CREATE TABLE pending (
  server varchar(30) default NULL,
  title varchar(30) default NULL,
  changes blob
) TYPE=MyISAM;

GRANT all on builds.* to build;