Author: ranger
Date: Wed May 10 22:25:29 2006
New Revision: 15
URL:
<http://svn.finkproject.org/websvn/listing.php?sc=1&rev=15&repname=user%3a+ranger>
Log:
update schema
Modified:
trunk/phenomenon/schema.sql
Modified: trunk/phenomenon/schema.sql
URL:
<http://svn.finkproject.org/websvn/diff.php?path=/trunk/phenomenon/schema.sql&rev=15&repname=user%3a+ranger>
==============================================================================
--- trunk/phenomenon/schema.sql (original)
+++ trunk/phenomenon/schema.sql Wed May 10 22:25:29 2006
@@ -1,5 +1,9 @@
CREATE TABLE visitors (id integer primary key autoincrement, session_id test);
-CREATE TABLE hits (id integer primary key autoincrement, visitor_id integer
not null references visitors(id), url text, page text, referrer text,
user_agent text, remote_addr text, language text, browser_width integer,
browser_height integer);
+CREATE TABLE hits (id integer primary key autoincrement, visitor_id integer
not null references visitors(id), url text, page text, referrer text,
user_agent text, remote_addr text, browser_width integer, browser_height
integer);
CREATE TABLE keywords (id integer primary key autoincrement, keyword text);
CREATE TABLE hit_keyword_map (hit_id integer not null references hits(id),
keyword_id integer not null references keywords(id));
+CREATE TABLE languages (id integer primary key autoincrement, language text);
+CREATE TABLE hit_language_map (hit_id integer not null references hits(id),
language_id integer not null references languages(id));
+CREATE TABLE charsets (id integer primary key autoincrement, charset text);
+CREATE TABLE hit_charset_map (hit_id integer not null references hits(id),
charset_id integer not null references charsets(id));
_______________________________________________
Fink-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/fink-commits
