added sd card readers

13 files changed, 346 insertions, 4 deletions

diff --git a/h-source/Application/Controllers/BluetoothController.php b/h-source/Application/Controllers/BluetoothController.php
index bff2723..5d701e9 100644
--- a/h-source/Application/Controllers/BluetoothController.php
+++ b/h-source/Application/Controllers/BluetoothController.php
@@ -28,7 +28,7 @@ class BluetoothController extends GenericController
 		
 		$this->_topMenuClasses['hardware'] = " class='currentitem'";
 
-		$worksOptions = Bluetooth::$select;;
+		$worksOptions = Bluetooth::$select;
 		$worksField = 'bluetooth_works';
 		$interfaceOptions = Bluetooth::$interface;
 		
diff --git a/h-source/Application/Controllers/DownloadController.php b/h-source/Application/Controllers/DownloadController.php
index d44d343..d58ba6c 100644
--- a/h-source/Application/Controllers/DownloadController.php
+++ b/h-source/Application/Controllers/DownloadController.php
@@ -145,6 +145,11 @@ class DownloadController extends BaseController
 				$xml .= "\t\t<it_works>".$row['hardware']['ethernet_card_works']."</it_works>\n";
 			}
 
+			if ($type === 'sd-card-reader')
+			{
+				$xml .= "\t\t<it_works>".$row['hardware']['sd_card_works']."</it_works>\n";
+			}
+
 			if ($type !== "notebook")
 			{
 				$xml .= "\t\t<driver>".$row['hardware']['driver']."</driver>\n";
@@ -240,4 +245,9 @@ class DownloadController extends BaseController
 	{
 		$this->printXml($lang, array('type'=>'ethernet-card','-deleted'=>'no'));
 	}
+
+	public function sdcardreaders($lang = 'en')
+	{
+		$this->printXml($lang, array('type'=>'sd-card-reader','-deleted'=>'no'));
+	}
 }
\ No newline at end of file
diff --git a/h-source/Application/Controllers/SdcardreadersController.php b/h-source/Application/Controllers/SdcardreadersController.php
new file mode 100644
index 0000000..6d7b719
--- /dev/null
+++ b/h-source/Application/Controllers/SdcardreadersController.php
@@ -0,0 +1,129 @@
+<?php 
+
+// h-source, a web software to build a community of people that want to share their hardware information.
+// Copyright (C) 2010  Antonio Gallo (h-source-copyright.txt)
+//
+// This file is part of h-source
+//
+// h-source is free software: you can redistribute it and/or modify
+// it under the terms of the GNU General Public License as published by
+// the Free Software Foundation, either version 3 of the License, or
+// (at your option) any later version.
+// 
+// h-source is distributed in the hope that it will be useful,
+// but WITHOUT ANY WARRANTY; without even the implied warranty of
+// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+// GNU General Public License for more details.
+// 
+// You should have received a copy of the GNU General Public License
+// along with h-source.  If not, see <http://www.gnu.org/licenses/>.
+
+if (!defined('EG')) die('Direct access not allowed!');
+
+class SdcardreadersController extends GenericController
+{
+
+	public function __construct($model, $controller, $queryString)
+	{
+		
+		$this->_topMenuClasses['hardware'] = " class='currentitem'";
+
+		$worksOptions = Sdcardreaders::$select;
+		$worksField = 'sd_card_works';
+		$interfaceOptions = Sdcardreaders::$interface;
+		
+		parent::__construct($model, $controller, $queryString);
+		
+		//load the model
+		$this->model('HardwareModel');
+		$this->model('RevisionsModel');
+		$this->model('SdcardreadersModel');
+		$this->model('TalkModel');
+		
+		$this->mod = $this->m['SdcardreadersModel'];
+		
+		$this->m['HardwareModel']->id_user = $this->s['registered']->status['id_user'];
+		$this->m['HardwareModel']->type = 'sd-card-reader';
+
+		$this->m['HardwareModel']->setConditions($worksOptions,$worksField,$interfaceOptions);
+		
+		$this->m['HardwareModel']->setFields('model,kernel,description,distribution,comm_year,sd_card_works,pci_id,interface,driver,other_names','sanitizeAll');
+		
+		$argKeys = array(
+			'page:forceNat'						=>	1,
+			'history_page:forceNat'				=>	1,
+			'vendor:sanitizeString'				=>	'undef',
+			'comm_year:sanitizeString'			=>	'undef',
+			'sd_card_works:sanitizeString'		=>	'undef',
+			'interface:sanitizeString'			=>	'undef',
+			'sort-by:sanitizeString'			=>	'undef'
+		);
+
+		$this->setArgKeys($argKeys);
+		
+		$data['title'] = 'Bluetooth';
+
+		$data['intefaceOptions'] = $interfaceOptions;
+		$data['worksOptions'] = $worksOptions;
+		$data['worksField'] = $worksField;
+		$this->append($data);
+	}
+	
+	public function catalogue($lang = 'en')
+	{		
+		$this->shift(1);
+		
+		$whereArray = array(
+			'type'				=>	$this->mod->type,
+			'vendor'			=>	$this->viewArgs['vendor'],
+			'comm_year'			=>	$this->viewArgs['comm_year'],
+			'sd_card_works'		=>	$this->viewArgs['sd_card_works'],
+			'interface'			=>	$this->viewArgs['interface'],
+		);
+		
+		$this->mod->setWhereQueryClause($whereArray);
+		
+		parent::catalogue($lang);
+	}
+
+	public function view($lang = 'en', $id = 0, $name = null)
+	{
+		parent::view($lang, $id, $name);
+	}
+
+	public function history($lang = 'en', $id = 0)
+	{
+		parent::history($lang, $id);
+	}
+
+	public function revision($lang = 'en', $id_rev = 0)
+	{
+		parent::revision($lang, $id_rev);
+	}
+
+	public function insert($lang = 'en', $token = '')
+	{
+		parent::insert($lang, $token);
+	}
+	
+	public function update($lang = 'en', $token = '')
+	{
+		parent::update($lang, $token);
+	}
+
+	public function differences($lang = 'en', $id_hard = 0, $id_rev = 0)
+	{
+		parent::differences($lang, $id_hard, $id_rev);
+	}
+
+	public function climb($lang = 'en', $id_rev = 0, $token = '')
+	{
+		parent::climb($lang, $id_rev, $token);
+	}
+
+	public function talk($lang = 'en', $id_hard = 0, $token = '')
+	{
+		parent::talk($lang, $id_hard, $token);
+	}
+
+}
\ No newline at end of file
diff --git a/h-source/Application/Include/hardware.php b/h-source/Application/Include/hardware.php
index 2e5cb0e..e919326 100644
--- a/h-source/Application/Include/hardware.php
+++ b/h-source/Application/Include/hardware.php
@@ -42,7 +42,7 @@ class Hardware
 		return $string;
 	}
 	
-	public static $controllers = array('notebooks','wifi','videocards','printers','scanners','threegcards','soundcards','webcams','bluetooth','acquisitioncards','fingerprintreaders','ethernetcards'); //used by UsersController::login()
+	public static $controllers = array('notebooks','wifi','videocards','printers','scanners','threegcards','soundcards','webcams','bluetooth','acquisitioncards','fingerprintreaders','ethernetcards','sdcardreaders'); //used by UsersController::login()
 
 	//classId => controller
 	public static $deviceClasses = array(
@@ -68,6 +68,7 @@ class Hardware
 		'acquisition-card'		=>	'Crystal/cam_mount-22.png',
 		'fingerprint-reader'	=>	'fingerprint_icon-22.png',
 		'ethernet-card'			=>	'H2O/network-wired_22.png',
+		'sd-card-reader'			=>	'H2O/media-flash-sd-mmc_22.png',
 	);
 
 	public static $typeToController = array(
@@ -83,6 +84,7 @@ class Hardware
 		'acquisition-card'		=>	'acquisitioncards',
 		'fingerprint-reader'	=>	'fingerprintreaders',
 		'ethernet-card'			=>	'ethernetcards',
+		'sd-card-reader'		=>	'sdcardreaders',
 	);
 
 	public static function getTypes()
@@ -411,5 +413,13 @@ class Ethernetcards extends Hardware
 	public static $select = 'yes,no';
 
 	public static $interface = "not-specified,USB,PCI,PCI-E,mini-PCI,mini-PCI-E,ExpressCard,PC-Card,Firewire,Parallel,Serial";
+}
+
+class Sdcardreaders extends Hardware
+{
+
+	public static $select = 'yes,no';
+
+	public static $interface = "not-specified,USB,PCI,PCI-E,mini-PCI,mini-PCI-E,ExpressCard,PC-Card,Firewire,Parallel,Serial";
 
 }
\ No newline at end of file
diff --git a/h-source/Application/Include/languages.php b/h-source/Application/Include/languages.php
index 635f361..406fad0 100644
--- a/h-source/Application/Include/languages.php
+++ b/h-source/Application/Include/languages.php
@@ -296,6 +296,9 @@ class Lang
 				/*0248*/"Edit"	=>	"Modifica",
 				/*0249*/"Talk page"	=>	"Pagina di discussione",
 				/*0250*/"Download the xml file of all the <b>ethernet cards</b> in the database"	=>	"Scarica il file xml di tutte le <b>schede ethernet</b> presenti nel database",
+				/*0251*/"No sd card readers found"	=>	"Non è stato trovato alcun lettore di schede sd",
+				/*0252*/"Sd card readers"	=>	"Lettori di schede sd",
+				/*0253*/"Download the xml file of all the <b>sd card readers</b> in the database"	=>	"Scarica il file xml di tutti i <b>lettori di schede sd</b> presenti nel database",
 			),
 		'es'	=>	array
 			(
@@ -1012,6 +1015,7 @@ class Lang
 			'acquisitioncards'		=>	'acquisition card',
 			'fingerprintreaders'		=>	'fingerprint reader',
 			'ethernetcards'		=>	'ethernet card',
+			'sdcardreaders'		=>	'sd card reader',
 		),
 		'it'	=>	array(
 			'notebooks'		=>	'notebook',
@@ -1026,6 +1030,7 @@ class Lang
 			'acquisitioncards'		=>	'scheda di acquisizione',
 			'fingerprintreaders'		=>	'lettore di impronte digitali',
 			'ethernetcards'		=>	'scheda ethernet',
+			'sdcardreaders'		=>	'lettore di schede sd',
 		),
 		'es'	=>	array(
 			'notebooks'		=>	'portátil',
@@ -1040,6 +1045,7 @@ class Lang
 			'acquisitioncards'		=>	'tarjeta de adquisición',
 			'fingerprintreaders'		=>	'lector de huella digital',
 			'ethernetcards'		=>	'tarjeta de ethernet',
+			'sdcardreaders'		=>	'sd card reader',
 		),
 		'fr'	=>	array(
 			'notebooks'		=>	'notebook',
@@ -1054,6 +1060,7 @@ class Lang
 			'acquisitioncards'		=>	'carte d\'acquisition',
 			'fingerprintreaders'		=>	'lecteur d\'empreintes digitales',
 			'ethernetcards'		=>	'carte ethernet',
+			'sdcardreaders'		=>	'sd card reader',
 		),
 		'de'	=>	array(
 			'notebooks'		=>	'notebook',
@@ -1068,6 +1075,7 @@ class Lang
 			'acquisitioncards'		=>	'acquisition card',
 			'fingerprintreaders'		=>	'fingerprint reader',
 			'ethernetcards'		=>	'ethernet card',
+			'sdcardreaders'		=>	'sd card reader',
 		),
 	);
 
@@ -1085,6 +1093,7 @@ class Lang
 			'acquisitioncards'		=>	'acquisition cards',
 			'fingerprintreaders'		=>	'fingerprint readers',
 			'ethernetcards'		=>	'ethernet cards',
+			'sdcardreaders'		=>	'sd card readers',
 		),
 		'it'	=>	array(
 			'notebooks'		=>	'notebook',
@@ -1099,6 +1108,7 @@ class Lang
 			'acquisitioncards'		=>	'schede di acquisizione',
 			'fingerprintreaders'		=>	'lettori di impronte digitali',
 			'ethernetcards'		=>	'schede ethernet',
+			'sdcardreaders'		=>	'lettori di schede sd',
 		),
 		'es'	=>	array(
 			'notebooks'		=>	'portátiles',
@@ -1113,6 +1123,7 @@ class Lang
 			'acquisitioncards'		=>	'tarjetas de adquisición',
 			'fingerprintreaders'		=>	'lectores de huella digital',
 			'ethernetcards'		=>	'tarjetas de ethernet',
+			'sdcardreaders'		=>	'sd card readers',
 		),
 		'fr'	=>	array(
 			'notebooks'		=>	'notebooks',
@@ -1126,7 +1137,8 @@ class Lang
 			'bluetooth'		=>	'périphériques bluetooth',
 			'acquisitioncards'		=>	'cartes d\'acquisition',
 			'fingerprintreaders'		=>	'lecteurs d\'empreintes digitales ',
-			'ethernetcards'		=>	'cartes ethernet',	
+			'ethernetcards'		=>	'cartes ethernet',
+			'sdcardreaders'		=>	'sd card readers',
 		),
 		'de'	=>	array(
 			'notebooks'		=>	'notebooks',
@@ -1141,6 +1153,7 @@ class Lang
 			'acquisitioncards'		=>	'acquisition cards',
 			'fingerprintreaders'		=>	'fingerprint readers',
 			'ethernetcards'		=>	'ethernet cards',
+			'sdcardreaders'		=>	'sd card readers',
 		),
 	);
 	
@@ -1194,6 +1207,7 @@ class MyStrings
 		'acquisition-card'	=>	'acquisitioncards',
 		'fingerprint-reader'	=>	'fingerprintreaders',
 		'ethernet-card'		=>	'ethernetcards',
+		'sd-card-reader'	=>	'sdcardreaders',
 	);
 
 	public static function getTypes()
diff --git a/h-source/Application/Models/SdcardreadersModel.php b/h-source/Application/Models/SdcardreadersModel.php
new file mode 100644
index 0000000..f580d87
--- /dev/null
+++ b/h-source/Application/Models/SdcardreadersModel.php
@@ -0,0 +1,70 @@
+<?php
+
+// h-source, a web software to build a community of people that want to share their hardware information.
+// Copyright (C) 2010  Antonio Gallo (h-source-copyright.txt)
+//
+// This file is part of h-source
+//
+// h-source is free software: you can redistribute it and/or modify
+// it under the terms of the GNU General Public License as published by
+// the Free Software Foundation, either version 3 of the License, or
+// (at your option) any later version.
+// 
+// h-source is distributed in the hope that it will be useful,
+// but WITHOUT ANY WARRANTY; without even the implied warranty of
+// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+// GNU General Public License for more details.
+// 
+// You should have received a copy of the GNU General Public License
+// along with h-source.  If not, see <http://www.gnu.org/licenses/>.
+
+if (!defined('EG')) die('Direct access not allowed!');
+
+class SdcardreadersModel extends GenericModel
+{
+
+	public $type = 'sd-card-reader'; //device type
+	
+	public function __construct()
+	{
+   
+		$this->_popupItemNames = array(
+			'vendor'		=>	'vendor',
+			'comm_year'		=>	'comm_year',
+			'sd_card_works'	=>	'sd_card_works',
+			'interface'		=>	'interface',
+		);
+   
+		$this->_popupLabels = array(
+			'vendor'		=>	gtext("vendor"),
+			'comm_year'		=>	gtext("year"),
+			'sd_card_works'	=>	gtext("does it work?"),
+			'interface'		=>	gtext("interface"),
+		);
+		
+		$this->_popupFunctions = array(
+			'vendor'		=>	'betterVendor',
+		);
+
+		$this->createPopupWhere('vendor,sd_card_works,comm_year,interface');
+		
+		$this->diffFields = array(
+			'vendor' 		=>	gtext("vendor"),
+			'model' 		=>	gtext('model name'),
+			'other_names' 		=>	gtext('possible other names of the device'),
+			'pci_id'		=>	gtext("VendorID:ProductID code of the device"),
+			'comm_year'		=>	gtext('year of commercialization'),
+			'interface'		=>	gtext("interface"),
+			'distribution' 	=>	gtext('GNU/Linux distribution used for the test'),
+			'kernel'		=>	gtext('tested with the following kernel libre'),
+			'sd_card_works'	=>	gtext("does it work with free software?"),
+			'driver'		=>	gtext("free driver used"),
+			'description'	=>	gtext('Description'),
+		);
+	
+		$this->fieldsWithBreaks = array(gtext('Description'),gtext('possible other names of the device'));
+		
+		parent::__construct();
+	}
+
+}
\ No newline at end of file
diff --git a/h-source/Application/Views/Download/index.php b/h-source/Application/Views/Download/index.php
index de4d434..2ffeae0 100644
--- a/h-source/Application/Views/Download/index.php
+++ b/h-source/Application/Views/Download/index.php
@@ -89,6 +89,10 @@
 							<td><?php echo gtext("Download the xml file of all the <b>ethernet cards</b> in the database");?></td>
 							<td><a href="<?php echo $this->baseUrl."/download/ethernetcards/$lang";?>"><img src="<?php echo $this->baseUrl?>/Public/Img/H2O/download.png"></a></td>
 						</tr>
+						<tr>
+							<td><?php echo gtext("Download the xml file of all the <b>sd card readers</b> in the database");?></td>
+							<td><a href="<?php echo $this->baseUrl."/download/sdcardreaders/$lang";?>"><img src="<?php echo $this->baseUrl?>/Public/Img/H2O/download.png"></a></td>
+						</tr>
 					</table>
 				</div>
 			</div>
diff --git a/h-source/Application/Views/Hardware/left.php b/h-source/Application/Views/Hardware/left.php
index 5390303..d6ea435 100644
--- a/h-source/Application/Views/Hardware/left.php
+++ b/h-source/Application/Views/Hardware/left.php
@@ -73,4 +73,8 @@
 		<div class="hardware_element">
 			<img align="middle" class="hardware_element_image" src="<?php echo $this->baseUrl;?>/Public/Img/H2O/network-wired.png"><a class="hardware_element_link" href="<?php echo $this->baseUrl?>/ethernetcards/catalogue/<?php echo $lang;?>"><?php echo gtext("Ethernet cards");?></a>
 		</div>
+
+		<div class="hardware_element">
+			<img align="middle" class="hardware_element_image" src="<?php echo $this->baseUrl;?>/Public/Img/H2O/media-flash-sd-mmc.png"><a class="hardware_element_link" href="<?php echo $this->baseUrl?>/sdcardreaders/catalogue/<?php echo $lang;?>"><?php echo gtext("Sd card readers");?></a>
+		</div>
 	</div>
\ No newline at end of file
diff --git a/h-source/Application/Views/Sdcardreaders/catalogue.php b/h-source/Application/Views/Sdcardreaders/catalogue.php
new file mode 100644
index 0000000..be0a14c
--- /dev/null
+++ b/h-source/Application/Views/Sdcardreaders/catalogue.php
@@ -0,0 +1,89 @@
+<?php if (!defined('EG')) die('Direct access not allowed!'); ?>
+
+<?php
+// h-source, a web software to build a community of people that want to share their hardware information.
+// Copyright (C) 2010  Antonio Gallo (h-source-copyright.txt)
+//
+// This file is part of h-source
+//
+// h-source is free software: you can redistribute it and/or modify
+// it under the terms of the GNU General Public License as published by
+// the Free Software Foundation, either version 3 of the License, or
+// (at your option) any later version.
+// 
+// h-source is distributed in the hope that it will be useful,
+// but WITHOUT ANY WARRANTY; without even the implied warranty of
+// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+// GNU General Public License for more details.
+// 
+// You should have received a copy of the GNU General Public License
+// along with h-source.  If not, see <http://www.gnu.org/licenses/>.
+?>
+
+		<div class="viewall_popup_menu_box_external">
+			<div class="viewall_popup_menu_box">
+				<?php echo $popup;?>
+			</div>
+			<div class="viewall_popup_menu_status">
+				<div class="viewall_popup_menu_status_item"><?php echo betterVendor($this->viewArgs['vendor'])?></div>
+				<div class="viewall_popup_menu_status_item"><?php echo $this->viewArgs['comm_year']?></div>
+				<div class="viewall_popup_menu_status_item"><?php echo $this->viewArgs['sd_card_works']?></div>
+				<div class="viewall_popup_menu_status_item"><?php echo $this->viewArgs['interface']?></div>
+				<div class="viewall_popup_menu_status_item"><?php echo $this->viewArgs['sort-by']?></div>
+			</div>
+		</div>
+		
+		<!--if no notebooks found-->
+		<?php if (strcmp($recordNumber,0) === 0) { ?>
+		<div class="viewall_no_items_found">
+			<?php echo gtext("No sd card readers found");?>..
+		</div>
+		<?php } ?>
+		
+		<!--loop-->
+		<?php foreach ($table as $item) {?>
+		<div class="model_viewall">
+
+			<div class="notebook_model">
+				<img align="top" class="catalogue_item_icon" src="<?php echo Hardware::getIconFromType($item['hardware']['type']);?>"> <span class="span_model_name"><?php echo gtext("model");?>: <b><?php echo $item['hardware']['model'];?></b></span>
+			</div>
+
+			<?php if ( strcmp($item['hardware']['other_names'],'') !== 0 ) { ?>
+			<div class="notebook_vendor">
+				<div class="inner_label"><?php echo gtext("possible other names of the device");?>:</div>
+				<div class="inner_value"><?php echo nl2br($item['hardware']['other_names']);?></div>
+			</div>
+			<?php } ?>
+			
+			<div class="notebook_vendor">
+				<div class="inner_label"><?php echo gtext("vendor");?>:</div>
+				<div class="inner_value"><?php echo betterVendor($item['hardware']['vendor']);?></div>
+			</div>
+			
+			<div class="notebook_vendor">
+				<div class="inner_label"><?php echo gtext("year of commercialization");?>:</div>
+				<div class="inner_value"><b><?php echo $item['hardware']['comm_year'];?></b></div>
+			</div>
+			
+			<div class="notebook_vendor">
+				<div class="inner_label"><?php echo gtext("interface");?>:</div>
+				<div class="inner_value"><b><?php echo $item['hardware']['interface'];?></b></div>
+			</div>
+			
+			<div class="notebook_kernel">
+				<div class="inner_label"><?php echo gtext("does it work with free software?");?></div>
+				<div class="inner_value"><b><?php echo $item['hardware']['sd_card_works'];?></b></div>
+			</div>
+			
+			<div class="notebook_view_link">
+				<a href="<?php echo $this->baseUrl."/".$this->controller."/view/$lang/".$item['hardware']['id_hard'].'/'.encodeUrl($item['hardware']['model']).$this->viewStatus;?>"><?php echo gtext("view the other specifications");?>..</a>
+			</div>
+			
+		</div>
+		<?php } ?>
+		
+		<?php if (strcmp($recordNumber,0) !== 0) { ?>
+		<div class="history_page_list">
+			<?php echo gtext("page list");?>: <?php echo $pageList;?>
+		</div>
+		<?php } ?>
\ No newline at end of file
diff --git a/h-source/Config/Route.php b/h-source/Config/Route.php
index fb345a2..be8daba 100644
--- a/h-source/Config/Route.php
+++ b/h-source/Config/Route.php
@@ -122,6 +122,7 @@ class Route
 		'download,acquisitioncards',
 		'download,fingerprintreaders',
 		'download,ethernetcards',
+		'download,sdcardreaders',
 		'history,hide',
 		'history,show',
 		'history,block',
@@ -221,6 +222,15 @@ class Route
 		'ethernetcards,differences',
 		'ethernetcards,climb',
 		'ethernetcards,talk',
+		'sdcardreaders,catalogue',
+		'sdcardreaders,view',
+		'sdcardreaders,history',
+		'sdcardreaders,revision',
+		'sdcardreaders,insert',
+		'sdcardreaders,update',
+		'sdcardreaders,differences',
+		'sdcardreaders,climb',
+		'sdcardreaders,talk',
 	);
 	
 	//it can be 'yes' or 'no'
diff --git a/h-source/Public/Img/H2O/media-flash-sd-mmc.png b/h-source/Public/Img/H2O/media-flash-sd-mmc.png
new file mode 100755
index 0000000..ff41fd8
--- /dev/null
+++ b/h-source/Public/Img/H2O/media-flash-sd-mmc.png
diff --git a/h-source/Public/Img/H2O/media-flash-sd-mmc_22.png b/h-source/Public/Img/H2O/media-flash-sd-mmc_22.png
new file mode 100755
index 0000000..cd97b66
--- /dev/null
+++ b/h-source/Public/Img/H2O/media-flash-sd-mmc_22.png
diff --git a/h-source/tables.sql b/h-source/tables.sql
index 194a799..59fee95 100644
--- a/h-source/tables.sql
+++ b/h-source/tables.sql
@@ -101,6 +101,7 @@ create table hardware (
 	bluetooth_works varchar(30) CHARACTER SET utf8 not null default 'not-specified',
 	fingerprint_works varchar(30) CHARACTER SET utf8 not null default 'not-specified',
 	ethernet-card_works varchar(30) CHARACTER SET utf8 not null default 'not-specified',
+	sd_card_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
 )engine=innodb;
@@ -133,7 +134,8 @@ create table revisions (
 	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',
-	ethernet-card_works varchar(30) CHARACTER SET utf8 not null default 'not-specified'
+	ethernet-card_works varchar(30) CHARACTER SET utf8 not null default 'not-specified',
+	sd_card_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,
 	approved char(4) not null default 'yes',