/[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 42 by dpavlin, Thu Mar 4 21:37:42 2004 UTC revision 43 by dpavlin, Fri Mar 5 00:21:54 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 references page(page_id),    page_id INT4 references page(page_id) on delete cascade on update cascade,
31    element_id INT4 references element(element_id),    element_id INT4 references element(element_id) on delete cascade on update cascade,
32    resource_id INT4 references resource(resource_id),    resource_id INT4 references resource(resource_id) on delete cascade on update cascade,
33    location_id INT4 references location(location_id),    location_id INT4 references location(location_id) on delete cascade on update cascade,
34    service_id INT4 references service(service_id),    service_id INT4 references service(service_id) on delete cascade on update cascade,
35    staff_id INT4 references staff(staff_id),    staff_id INT4 references staff(staff_id) on delete cascade on update cascade,
36    subject_id INT4 references subject(subject_id),    subject_id INT4 references subject(subject_id) on delete cascade on update cascade,
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 references page(page_id),    page_id INT4 references page(page_id) on delete cascade on update cascade,
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 references subject(subject_id),    subject_id INT4 references subject(subject_id) on delete cascade on update cascade,
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.42  
changed lines
  Added in v.43
  ViewVC Help
Powered by ViewVC 1.1.26