aboutsummaryrefslogtreecommitdiff
path: root/web
diff options
context:
space:
mode:
authorGravatar Thomas Petazzoni <thomas.petazzoni@free-electrons.com>2017-10-20 14:49:26 +0200
committerGravatar Thomas Petazzoni <thomas.petazzoni@free-electrons.com>2017-10-20 14:49:26 +0200
commit93d759e4cbd765e8f67123ae085160f30c4477ae (patch)
tree465ec5c6aaedd8ec893430a42c30d58d21b05d09 /web
parente4a41a37f4acc1c51e7241c1849152071dad12e5 (diff)
downloadbuildroot-test-93d759e4cbd765e8f67123ae085160f30c4477ae.tar.gz
buildroot-test-93d759e4cbd765e8f67123ae085160f30c4477ae.tar.bz2
Update SQL schema
Signed-off-by: Thomas Petazzoni <thomas.petazzoni@free-electrons.com>
Diffstat (limited to 'web')
-rw-r--r--web/schema.sql23
1 files changed, 16 insertions, 7 deletions
diff --git a/web/schema.sql b/web/schema.sql
index 14ad70c..79806f3 100644
--- a/web/schema.sql
+++ b/web/schema.sql
@@ -7,14 +7,23 @@ CREATE TABLE `results` (
`identifier` char(40) NOT NULL DEFAULT '',
`arch` varchar(64) NOT NULL DEFAULT '',
`reason` varchar(255) NOT NULL DEFAULT '',
+ `libc` varchar(32) NOT NULL DEFAULT '',
+ `static` tinyint(1) NOT NULL default '0',
+ `subarch` varchar(64) NOT NULL DEFAULT '',
+ `duration` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-CREATE TABLE `results_config` (
- `id` int(11) NOT NULL auto_increment,
- `resultid` int(11) default NULL,
- `isset` tinyint(1) NOT NULL default '0',
- `name` varchar(255) NOT NULL default '',
- `value` varchar(255) NOT NULL default '',
- PRIMARY KEY (`id`)
+CREATE TABLE `config_symbol` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `name` varchar(255) NOT NULL DEFAULT '',
+ `value` varchar(255) NOT NULL DEFAULT '',
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+
+CREATE TABLE `symbol_per_result` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `result_id` int(11) NOT NULL DEFAULT '0',
+ `symbol_id` int(11) NOT NULL DEFAULT '0',
+ PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;