irsa.cnr.it Database

irsa.cnr.it

Gr33nRage


available databases [7]:
[*] Bozza
[*] information_schema
[*] NewIntra
[*] NewPub
[*] OLdPubImport
[*] piwik
[*] test



Database: Bozza
[13 tables]
+------------+
| AlboForn   |
| AvvisiGare |
| Bandi      |
| Pages      |
| Personale  |
| Progetti   |
| Proposte_p |
| Quaderni   |
| Riviste    |
| Sedi       |
| Seminari   |
| Strum      |
| TipoBandi  |
+------------+


Database: piwik
[50 tables]
+-------------------------------+
| piwik_access                  |
| piwik_archive_blob_2011_06    |
| piwik_archive_blob_2011_07    |
| piwik_archive_blob_2011_08    |
| piwik_archive_blob_2011_09    |
| piwik_archive_blob_2011_10    |
| piwik_archive_blob_2011_11    |
| piwik_archive_blob_2011_12    |
| piwik_archive_blob_2012_01    |
| piwik_archive_blob_2012_02    |
| piwik_archive_blob_2012_03    |
| piwik_archive_blob_2012_04    |
| piwik_archive_blob_2012_05    |
| piwik_archive_blob_2012_06    |
| piwik_archive_blob_2012_09    |
| piwik_archive_blob_2012_10    |
| piwik_archive_numeric_2011_06 |
| piwik_archive_numeric_2011_07 |
| piwik_archive_numeric_2011_08 |
| piwik_archive_numeric_2011_09 |
| piwik_archive_numeric_2011_10 |
| piwik_archive_numeric_2011_11 |
| piwik_archive_numeric_2011_12 |
| piwik_archive_numeric_2012_01 |
| piwik_archive_numeric_2012_02 |
| piwik_archive_numeric_2012_03 |
| piwik_archive_numeric_2012_04 |
| piwik_archive_numeric_2012_05 |
| piwik_archive_numeric_2012_06 |
| piwik_archive_numeric_2012_09 |
| piwik_archive_numeric_2012_10 |
| piwik_goal                    |
| piwik_log_action              |
| piwik_log_conversion          |
| piwik_log_conversion_item     |
| piwik_log_link_visit_action   |
| piwik_log_profiling           |
| piwik_log_visit               |
| piwik_logger_api_call         |
| piwik_logger_error            |
| piwik_logger_exception        |
| piwik_logger_message          |
| piwik_option                  |
| piwik_pdf                     |
| piwik_session                 |
| piwik_site                    |
| piwik_site_url                |
| piwik_user                    |
| piwik_user_dashboard          |
| piwik_user_language           |
+-------------------------------+



Table: piwik_access
[3 columns]
+--------+------------------+
| Column | Type             |
+--------+------------------+
| access | varchar(10)      |
| idsite | int(10) unsigned |
| login  | varchar(100)     |
+--------+------------------+


Table: piwik_user
[6 columns]
+-----------------+--------------+
| Column          | Type         |
+-----------------+--------------+
| alias           | varchar(45)  |
| date_registered | timestamp    |
| email           | varchar(100) |
| login           | varchar(100) |
| password        | char(32)     |
| token_auth      | char(32)     |
+-----------------+--------------+



Table: piwik_site
[11 columns]
+---------------------+------------------+
| Column              | Type             |
+---------------------+------------------+
| currency            | char(3)          |
| ecommerce           | tinyint(4)       |
| excluded_ips        | text             |
| excluded_parameters | varchar(255)     |
| feedburnerName      | varchar(100)     |
| group               | varchar(250)     |
| idsite              | int(10) unsigned |
| main_url            | varchar(255)     |
| name                | varchar(90)      |
| timezone            | varchar(50)      |
| ts_created          | timestamp        |
+---------------------+------------------+



Table: piwik_access
[2 entries]
+--------+--------+-----------+
| access | idsite | login     |
+--------+--------+-----------+
| view   | 1      | anonymous |
| view   | 2      | anonymous |
+--------+--------+-----------+