gboolean
ephy_history_service_initialize_urls_table (EphyHistoryService *self)
{
GError *error = NULL;
if (ephy_sqlite_connection_table_exists (self->history_database, "visits")) {
return TRUE;
}
ephy_sqlite_connection_execute (self->history_database,
"CREATE TABLE urls ("
"id INTEGER PRIMARY KEY,"
"host INTEGER NOT NULL REFERENCES hosts(id) ON DELETE CASCADE,"
"url LONGVARCAR,"
"title LONGVARCAR,"
"sync_id LONGVARCAR,"
"visit_count INTEGER DEFAULT 0 NOT NULL,"
"typed_count INTEGER DEFAULT 0 NOT NULL,"
"last_visit_time INTEGER,"
"thumbnail_update_time INTEGER DEFAULT 0," /* this column is legacy, unused */
"hidden_from_overview INTEGER DEFAULT 0)", &error);
if (error) {
g_warning ("Could not create urls table: %s", error->message);
g_error_free (error);
return FALSE;
}
return TRUE;
}
gboolean
ephy_history_service_initialize_hosts_table (EphyHistoryService *self)
{
EphyHistoryServicePrivate *priv = EPHY_HISTORY_SERVICE (self)->priv;
GError *error = NULL;
if (ephy_sqlite_connection_table_exists (priv->history_database, "hosts")) {
return TRUE;
}
ephy_sqlite_connection_execute (priv->history_database,
"CREATE TABLE hosts ("
"id INTEGER PRIMARY KEY,"
"url LONGVARCAR,"
"title LONGVARCAR,"
"visit_count INTEGER DEFAULT 0 NOT NULL,"
"zoom_level REAL DEFAULT 1.0)", &error);
if (error) {
g_error("Could not create hosts table: %s", error->message);
g_error_free (error);
return FALSE;
}
ephy_history_service_schedule_commit (self);
return TRUE;
}
gboolean
ephy_history_service_initialize_hosts_table (EphyHistoryService *self)
{
GError *error = NULL;
if (ephy_sqlite_connection_table_exists (self->history_database, "hosts")) {
return TRUE;
}
ephy_sqlite_connection_execute (self->history_database,
"CREATE TABLE hosts ("
"id INTEGER PRIMARY KEY,"
"url LONGVARCAR,"
"title LONGVARCAR,"
"visit_count INTEGER DEFAULT 0 NOT NULL,"
"zoom_level REAL DEFAULT 0.0)", &error);
if (error) {
g_warning ("Could not create hosts table: %s", error->message);
g_error_free (error);
return FALSE;
}
return TRUE;
}
gboolean
ephy_history_service_initialize_visits_table (EphyHistoryService *self)
{
GError *error = NULL;
if (ephy_sqlite_connection_table_exists (self->history_database, "visits"))
return TRUE;
ephy_sqlite_connection_execute (self->history_database,
"CREATE TABLE visits ("
"id INTEGER PRIMARY KEY,"
"url INTEGER NOT NULL REFERENCES urls(id) ON DELETE CASCADE,"
"visit_time INTEGER NOT NULL,"
"visit_type INTEGER NOT NULL,"
"referring_visit INTEGER)", &error);
if (error) {
g_warning ("Could not create visits table: %s", error->message);
g_error_free (error);
return FALSE;
}
return TRUE;
}