3 -- Host: localhost Database: buildlogs
4 -- ------------------------------------------------------
5 -- Server version 4.0.22
8 -- Table structure for table `architectures`
10 CREATE DATABASE buildlogs;
15 CREATE TABLE architectures (
16 arch_id tinyint(4) NOT NULL default '0',
17 name varchar(15) default NULL,
22 -- Dumping data for table `architectures`
25 INSERT INTO architectures VALUES (0,'th/SRPMS');
26 INSERT INTO architectures VALUES (1,'th/i486');
27 INSERT INTO architectures VALUES (2,'th/i686');
28 INSERT INTO architectures VALUES (3,'th/athlon');
29 INSERT INTO architectures VALUES (4,'th/x86_64');
30 INSERT INTO architectures VALUES (5,'th/ia64');
31 INSERT INTO architectures VALUES (6,'th/alpha');
32 INSERT INTO architectures VALUES (7,'th/ppc');
33 INSERT INTO architectures VALUES (8,'th/sparc');
34 INSERT INTO architectures VALUES (9,'ac/SRPMS');
35 INSERT INTO architectures VALUES (10,'ac/i386');
36 INSERT INTO architectures VALUES (11,'ac/i586');
37 INSERT INTO architectures VALUES (12,'ac/i686');
38 INSERT INTO architectures VALUES (13,'ac/athlon');
39 INSERT INTO architectures VALUES (14,'ac/amd64');
40 INSERT INTO architectures VALUES (15,'ac/alpha');
41 INSERT INTO architectures VALUES (16,'ac/ppc');
42 INSERT INTO architectures VALUES (17,'ac/sparc');
43 INSERT INTO architectures VALUES (18,'ac/sparc64');
44 INSERT INTO architectures VALUES (19,'ti/SRPMS');
45 INSERT INTO architectures VALUES (20,'ti/i586');
46 INSERT INTO architectures VALUES (21,'ti/i686');
47 INSERT INTO architectures VALUES (22,'ti/x86_64');
50 -- Table structure for table `logs`
54 log_id int(11) NOT NULL auto_increment,
55 arch_id tinyint(4) default NULL,
56 result tinyint(4) default NULL,
57 size int(11) default NULL,
58 spec_id smallint(6) default NULL,
59 mtime int(11) default NULL,
65 result_id tinyint(4) NOT NULL default '0',
66 name varchar(5) default NULL,
67 PRIMARY KEY (result_id)
71 -- Dumping data for table `result`
74 INSERT INTO result VALUES (0,'FAIL');
75 INSERT INTO result VALUES (1,'OK');
78 -- Table structure for table `specs`
82 spec_id smallint(6) NOT NULL auto_increment,
83 spec varchar(70) default NULL,