aboutsummaryrefslogtreecommitdiff
path: root/h-source
diff options
context:
space:
mode:
authorAntonio Gallo <tonicucoz@gmail.com>2011-10-02 17:35:41 +0000
committerAntonio Gallo <tonicucoz@gmail.com>2011-10-02 17:35:41 +0000
commitfef5c074223364eb32032a5787ea824fcbadc4fe (patch)
treefc4a3256743f54de5e1170df93ecdb74fdbfa9cf /h-source
parent029021b689453cd745b6d44450adbe76684effca (diff)
added sd card readers
Diffstat (limited to 'h-source')
-rw-r--r--h-source/Application/Controllers/BluetoothController.php2
-rw-r--r--h-source/Application/Controllers/DownloadController.php10
-rw-r--r--h-source/Application/Controllers/SdcardreadersController.php129
-rw-r--r--h-source/Application/Include/hardware.php12
-rw-r--r--h-source/Application/Include/languages.php16
-rw-r--r--h-source/Application/Models/SdcardreadersModel.php70
-rw-r--r--h-source/Application/Views/Download/index.php4
-rw-r--r--h-source/Application/Views/Hardware/left.php4
-rw-r--r--h-source/Application/Views/Sdcardreaders/catalogue.php89
-rw-r--r--h-source/Config/Route.php10
-rwxr-xr-xh-source/Public/Img/H2O/media-flash-sd-mmc.pngbin0 -> 4272 bytes
-rwxr-xr-xh-source/Public/Img/H2O/media-flash-sd-mmc_22.pngbin0 -> 1081 bytes
-rw-r--r--h-source/tables.sql4
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
Binary files differ
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
Binary files differ
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',