Use 'with time zone' instead of 'without time zone'
We load data with TZ information so 'with time zone' is the valid option for the schema
@@ -28,7 +28,7 @@ create table message (
*/
m_messageid bigint not null,
m_ps_imagefile varchar,
- m_creationdate timestamp without time zone not null,
+ m_creationdate timestamp with time zone not null,
m_locationip varchar not null,
m_browserused varchar not null,
m_ps_language varchar,
@@ -43,14 +43,14 @@ create table message (
create table forum (
f_forumid bigint not null,
f_title varchar not null,
- f_creationdate timestamp without time zone not null,
+ f_creationdate timestamp with time zone not null,
f_moderatorid bigint
);
create table forum_person (
fp_forumid bigint not null,
fp_personid bigint not null,
- fp_joindate timestamp without time zone not null
+ fp_joindate timestamp with time zone not null
);
create table forum_tag (
@@ -71,8 +71,8 @@ create table person (
p_firstname varchar not null,
p_lastname varchar not null,
p_gender varchar not null,
- p_birthday timestamp without time zone not null,
- p_creationdate timestamp without time zone not null,
+ p_birthday timestamp with time zone not null,
+ p_creationdate timestamp with time zone not null,
p_locationip varchar not null,
p_browserused varchar not null,
p_placeid bigint
@@ -92,13 +92,13 @@ create table person_tag (
create table knows (
k_person1id bigint not null,
k_person2id bigint not null,
- k_creationdate timestamp without time zone not null
+ k_creationdate timestamp with time zone not null
);
create table likes (
l_personid bigint not null,
l_messageid bigint not null,
- l_creationdate timestamp without time zone not null
+ l_creationdate timestamp with time zone not null
);
create table person_language (
