lib/files/database_schema.rb in knjappserver-0.0.19 vs lib/files/database_schema.rb in knjappserver-0.0.20
- old
+ new
@@ -12,10 +12,12 @@
{"name" => "post_values_data_id", "type" => "bigint"},
{"name" => "cookie_keys_data_id", "type" => "bigint"},
{"name" => "cookie_values_data_id", "type" => "bigint"},
{"name" => "meta_keys_data_id", "type" => "bigint"},
{"name" => "meta_values_data_id", "type" => "bigint"},
+ {"name" => "session_keys_data_id", "type" => "bigint"},
+ {"name" => "session_values_data_id", "type" => "bigint"},
{"name" => "tag_data_id", "type" => "bigint"},
{"name" => "comment_data_id", "type" => "bigint"}
],
"indexes" => [
{"name" => "text_value_id", "columns" => ["text_value_id"]},
@@ -89,10 +91,10 @@
"columns" => [
{"name" => "id", "type" => "bigint", "autoincr" => true, "primarykey" => true},
{"name" => "idhash", "type" => "varchar"},
{"name" => "sess_data", "type" => "text"},
{"name" => "date_added", "type" => "datetime"},
- {"name" => "date_lastused", "type" => "datetime", "on_created" => proc{|d| d["db"].query("UPDATE Session SET date_lastused = '#{Knj::Datet.new.dbstr}")}},
+ {"name" => "date_lastused", "type" => "datetime", "on_created" => proc{|d| d["db"].query("UPDATE Session SET date_lastused = '#{Knj::Datet.new.dbstr}'")}},
{"name" => "ip", "type" => "varchar", "maxlength" => 15},
{"name" => "user_agent", "type" => "text"},
{"name" => "remember", "type" => "enum", "maxlength" => "'0','1'", "default" => 0, "comment" => "If the session should be remembered or not."}
],
"indexes" => [
\ No newline at end of file