From 3c1f2dfdb82656dc47a1cb467d03e09e52792f24 Mon Sep 17 00:00:00 2001
From: Antonio Gallo <tonicucoz@gmail.com>
Date: Thu, 12 May 2011 21:51:06 +0000
Subject: h-source:added the other_names entry

---
 h-source/tables.sql | 4 +++-
 1 file changed, 3 insertions(+), 1 deletion(-)

(limited to 'h-source/tables.sql')

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;
 
-- 
cgit v1.2.3

