]>
Commit | Line | Data |
---|---|---|
638df245 | 1 | -- MySQL dump 9.11 |
2 | -- | |
3 | -- Host: localhost Database: buildlogs | |
4 | -- ------------------------------------------------------ | |
5 | -- Server version 4.0.22 | |
6 | ||
7 | -- | |
8 | -- Table structure for table `architectures` | |
9 | -- | |
10 | CREATE DATABASE buildlogs; | |
11 | ||
12 | USE buildlogs; | |
13 | ||
14 | ||
15 | CREATE TABLE architectures ( | |
16 | arch_id tinyint(4) NOT NULL default '0', | |
17 | name varchar(15) default NULL, | |
18 | PRIMARY KEY (arch_id) | |
19 | ) TYPE=MyISAM; | |
20 | ||
21 | -- | |
22 | -- Dumping data for table `architectures` | |
23 | -- | |
24 | ||
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'); | |
cd8d80e7 | 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'); | |
638df245 | 48 | |
49 | ||
50 | -- Table structure for table `logs` | |
51 | -- | |
52 | ||
53 | CREATE 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, | |
60 | PRIMARY KEY (log_id) | |
61 | ) TYPE=MyISAM; | |
62 | ||
63 | ||
64 | CREATE TABLE result ( | |
65 | result_id tinyint(4) NOT NULL default '0', | |
66 | name varchar(5) default NULL, | |
67 | PRIMARY KEY (result_id) | |
68 | ) TYPE=MyISAM; | |
69 | ||
70 | -- | |
71 | -- Dumping data for table `result` | |
72 | -- | |
73 | ||
74 | INSERT INTO result VALUES (0,'FAIL'); | |
75 | INSERT INTO result VALUES (1,'OK'); | |
76 | ||
77 | -- | |
78 | -- Table structure for table `specs` | |
79 | -- | |
80 | ||
81 | CREATE TABLE specs ( | |
82 | spec_id smallint(6) NOT NULL auto_increment, | |
83 | spec varchar(70) default NULL, | |
84 | PRIMARY KEY (spec_id) | |
85 | ) TYPE=MyISAM; | |
86 |