- separation continued

[projects/buildlogs.git] / init.sql

-- MySQL dump 9.11
--
-- Host: localhost    Database: buildlogs
-- ------------------------------------------------------
-- Server version	4.0.22

--
-- Table structure for table `architectures`
--
CREATE DATABASE buildlogs;

USE buildlogs;


CREATE TABLE architectures (
  arch_id tinyint(4) NOT NULL default '0',
  name varchar(15) default NULL,
  PRIMARY KEY  (arch_id)
) TYPE=MyISAM;

--
-- Dumping data for table `architectures`
--

INSERT INTO architectures VALUES (0,'th/SRPMS');
INSERT INTO architectures VALUES (1,'th/i486');
INSERT INTO architectures VALUES (2,'th/i686');
INSERT INTO architectures VALUES (3,'th/athlon');
INSERT INTO architectures VALUES (4,'th/x86_64');
INSERT INTO architectures VALUES (5,'th/ia64');
INSERT INTO architectures VALUES (6,'th/alpha');
INSERT INTO architectures VALUES (7,'th/ppc');
INSERT INTO architectures VALUES (8,'th/sparc');
INSERT INTO architectures VALUES (9,'ac/SRPMS');
INSERT INTO architectures VALUES (10,'ac/i386');
INSERT INTO architectures VALUES (11,'ac/i586');
INSERT INTO architectures VALUES (12,'ac/i686');
INSERT INTO architectures VALUES (13,'ac/athlon');
INSERT INTO architectures VALUES (14,'ac/amd64');
INSERT INTO architectures VALUES (15,'ac/alpha');
INSERT INTO architectures VALUES (16,'ac/ppc');
INSERT INTO architectures VALUES (17,'ac/sparc');
INSERT INTO architectures VALUES (18,'ac/sparc64');


-- Table structure for table `logs`
--

CREATE TABLE logs (
  log_id int(11) NOT NULL auto_increment,
  arch_id tinyint(4) default NULL,
  result tinyint(4) default NULL,
  size int(11) default NULL,
  spec_id smallint(6) default NULL,
  mtime int(11) default NULL,
  PRIMARY KEY  (log_id)
) TYPE=MyISAM;


CREATE TABLE result (
  result_id tinyint(4) NOT NULL default '0',
  name varchar(5) default NULL,
  PRIMARY KEY  (result_id)
) TYPE=MyISAM;

--
-- Dumping data for table `result`
--

INSERT INTO result VALUES (0,'FAIL');
INSERT INTO result VALUES (1,'OK');

--
-- Table structure for table `specs`
--

CREATE TABLE specs (
  spec_id smallint(6) NOT NULL auto_increment,
  spec varchar(70) default NULL,
  PRIMARY KEY  (spec_id)
) TYPE=MyISAM;