diff options
author | Antonio Gallo <tonicucoz@gmail.com> | 2011-05-12 21:51:06 +0000 |
---|---|---|
committer | Antonio Gallo <tonicucoz@gmail.com> | 2011-05-12 21:51:06 +0000 |
commit | 3c1f2dfdb82656dc47a1cb467d03e09e52792f24 (patch) | |
tree | 490a63fcaab8213346bb80657e61cde2245bf010 /h-source/tables.sql | |
parent | 1b84f9bcf2d480431608d8fb08d0671bc945211d (diff) |
h-source:added the other_names entry
Diffstat (limited to 'h-source/tables.sql')
-rw-r--r-- | h-source/tables.sql | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/h-source/tables.sql b/h-source/tables.sql index c3e69fe..08bdfa6 100644 --- a/h-source/tables.sql +++ b/h-source/tables.sql @@ -98,7 +98,8 @@ create table hardware ( sound_card_works varchar(30) CHARACTER SET utf8 not null default 'not-specified', bluetooth_works varchar(30) CHARACTER SET utf8 not null default 'not-specified', fingerprint_works varchar(30) CHARACTER SET utf8 not null default 'not-specified', - architecture char(15) not null default 'not-specified' + architecture char(15) not null default 'not-specified', + other_names text CHARACTER SET utf8 not null )engine=innodb; create table revisions ( @@ -130,6 +131,7 @@ create table revisions ( bluetooth_works varchar(30) CHARACTER SET utf8 not null default 'not-specified', fingerprint_works varchar(30) CHARACTER SET utf8 not null default 'not-specified', architecture char(15) not null default 'not-specified', + other_names text CHARACTER SET utf8 not null, id_hard INT UNSIGNED NOT NULL )engine=innodb; |