/[libdata]/trunk/pg/libstats.pgsql
This is repository of my old source code which isn't updated any more. Go to git.rot13.org for current projects!
ViewVC logotype

Diff of /trunk/pg/libstats.pgsql

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 37 by dpavlin, Thu Mar 4 21:28:31 2004 UTC revision 38 by dpavlin, Thu Mar 4 21:37:42 2004 UTC
# Line 27  CREATE SEQUENCE libstats.elementstats_el Line 27  CREATE SEQUENCE libstats.elementstats_el
27    
28  CREATE TABLE libstats.elementstats (  CREATE TABLE libstats.elementstats (
29    elementstats_id INT4 DEFAULT nextval('libstats.elementstats_elementstats_id'),    elementstats_id INT4 DEFAULT nextval('libstats.elementstats_elementstats_id'),
30    page_id INT4 DEFAULT NULL,    page_id INT4 references page(page_id),
31    element_id INT4 DEFAULT NULL,    element_id INT4 references element(element_id),
32    resource_id INT4 DEFAULT NULL,    resource_id INT4 references resource(resource_id),
33    location_id INT4 DEFAULT NULL,    location_id INT4 references location(location_id),
34    service_id INT4 DEFAULT NULL,    service_id INT4 references service(service_id),
35    staff_id INT4 DEFAULT NULL,    staff_id INT4 references staff(staff_id),
36    subject_id INT4 DEFAULT NULL,    subject_id INT4 references subject(subject_id),
37    visit_date TIMESTAMP DEFAULT NULL,    visit_date TIMESTAMP DEFAULT NULL,
38    user_ip varchar(15) DEFAULT NULL,    user_ip varchar(15) DEFAULT NULL,
39    PRIMARY KEY (elementstats_id)    PRIMARY KEY (elementstats_id)
# Line 62  CREATE SEQUENCE libstats.pagestats_pages Line 62  CREATE SEQUENCE libstats.pagestats_pages
62    
63  CREATE TABLE libstats.pagestats (  CREATE TABLE libstats.pagestats (
64    pagestats_id INT4 DEFAULT nextval('libstats.pagestats_pagestats_id_seq'),    pagestats_id INT4 DEFAULT nextval('libstats.pagestats_pagestats_id_seq'),
65    page_id INT4 DEFAULT NULL,    page_id INT4 references page(page_id),
66    visit_date TIMESTAMP DEFAULT NULL,    visit_date TIMESTAMP DEFAULT NULL,
67    user_ip varchar(15) DEFAULT NULL,    user_ip varchar(15) DEFAULT NULL,
68    PRIMARY KEY (pagestats_id)    PRIMARY KEY (pagestats_id)
# Line 133  CREATE SEQUENCE libstats.substats_substa Line 133  CREATE SEQUENCE libstats.substats_substa
133    
134  CREATE TABLE libstats.substats (  CREATE TABLE libstats.substats (
135    substats_id INT4 DEFAULT nextval('libstats.substats_substats_id_seq'),    substats_id INT4 DEFAULT nextval('libstats.substats_substats_id_seq'),
136    subject_id INT4 DEFAULT NULL,    subject_id INT4 references subject(subject_id),
137    visit_date TIMESTAMP DEFAULT NULL,    visit_date TIMESTAMP DEFAULT NULL,
138    user_ip varchar(15) DEFAULT NULL,    user_ip varchar(15) DEFAULT NULL,
139    PRIMARY KEY (substats_id)    PRIMARY KEY (substats_id)
Legend:
Removed from v.37  
changed lines
  Added in v.38
  ViewVC Help
Powered by ViewVC 1.1.26