cmailleux 2005/11/21 16:48:35 CET
Modified files:
core/src/webapp/WEB-INF/var/db/sql/schema/hypersonic
jahia-schema.sql
core/src/webapp/WEB-INF/var/db/sql/schema/mssql
jahia-schema.sql
core/src/webapp/WEB-INF/var/db/sql/schema/mysql
jahia-schema.sql
core/src/webapp/WEB-INF/var/db/sql/schema/postgresql
jahia-schema.sql
phase1-schema.sql
quartz-schema.sql
registry-schema.sql
Log:
Change length of content to 250 chars
CHange schema of jetspeed for using text instead of bytea
Revision Changes Path
1.13 +1 -1
jahia/core/src/webapp/WEB-INF/var/db/sql/schema/hypersonic/jahia-schema.sql
http://jahia.mine.nu:8080/cgi-bin/cvsweb.cgi/jahia/core/src/webapp/WEB-INF/var/db/sql/schema/hypersonic/jahia-schema.sql.diff?r1=1.12&r2=1.13&f=h
1.11 +1 -1
jahia/core/src/webapp/WEB-INF/var/db/sql/schema/mssql/jahia-schema.sql
http://jahia.mine.nu:8080/cgi-bin/cvsweb.cgi/jahia/core/src/webapp/WEB-INF/var/db/sql/schema/mssql/jahia-schema.sql.diff?r1=1.10&r2=1.11&f=h
1.14 +1 -1
jahia/core/src/webapp/WEB-INF/var/db/sql/schema/mysql/jahia-schema.sql
http://jahia.mine.nu:8080/cgi-bin/cvsweb.cgi/jahia/core/src/webapp/WEB-INF/var/db/sql/schema/mysql/jahia-schema.sql.diff?r1=1.13&r2=1.14&f=h
1.14 +1 -1
jahia/core/src/webapp/WEB-INF/var/db/sql/schema/postgresql/jahia-schema.sql
http://jahia.mine.nu:8080/cgi-bin/cvsweb.cgi/jahia/core/src/webapp/WEB-INF/var/db/sql/schema/postgresql/jahia-schema.sql.diff?r1=1.13&r2=1.14&f=h
1.3 +1 -1
jahia/core/src/webapp/WEB-INF/var/db/sql/schema/postgresql/phase1-schema.sql
http://jahia.mine.nu:8080/cgi-bin/cvsweb.cgi/jahia/core/src/webapp/WEB-INF/var/db/sql/schema/postgresql/phase1-schema.sql.diff?r1=1.2&r2=1.3&f=h
1.5 +31 -32
jahia/core/src/webapp/WEB-INF/var/db/sql/schema/postgresql/quartz-schema.sql
http://jahia.mine.nu:8080/cgi-bin/cvsweb.cgi/jahia/core/src/webapp/WEB-INF/var/db/sql/schema/postgresql/quartz-schema.sql.diff?r1=1.4&r2=1.5&f=h
1.2 +8 -8
jahia/core/src/webapp/WEB-INF/var/db/sql/schema/postgresql/registry-schema.sql
http://jahia.mine.nu:8080/cgi-bin/cvsweb.cgi/jahia/core/src/webapp/WEB-INF/var/db/sql/schema/postgresql/registry-schema.sql.diff?r1=1.1&r2=1.2&f=h
Index: jahia-schema.sql
===================================================================
RCS file:
/home/cvs/repository/jahia/core/src/webapp/WEB-INF/var/db/sql/schema/hypersonic/jahia-schema.sql,v
retrieving revision 1.12
retrieving revision 1.13
diff -u -r1.12 -r1.13
--- jahia-schema.sql 3 Nov 2005 13:22:48 -0000 1.12
+++ jahia-schema.sql 21 Nov 2005 15:48:33 -0000 1.13
@@ -126,7 +126,7 @@
parentid_jahia_audit_log integer,
operation_jahia_audit_log VARCHAR (50),
site_jahia_audit_log VARCHAR (50),
- content_jahia_audit_log VARCHAR (50),
+ content_jahia_audit_log VARCHAR (250),
PRIMARY KEY(id_jahia_audit_log)
);
Index: jahia-schema.sql
===================================================================
RCS file:
/home/cvs/repository/jahia/core/src/webapp/WEB-INF/var/db/sql/schema/mssql/jahia-schema.sql,v
retrieving revision 1.10
retrieving revision 1.11
diff -u -r1.10 -r1.11
--- jahia-schema.sql 3 Nov 2005 13:22:49 -0000 1.10
+++ jahia-schema.sql 21 Nov 2005 15:48:33 -0000 1.11
@@ -348,7 +348,7 @@
parentid_jahia_audit_log INT NULL,
operation_jahia_audit_log VARCHAR (50) NULL,
site_jahia_audit_log VARCHAR (50) NULL,
- content_jahia_audit_log VARCHAR (50) NULL,
+ content_jahia_audit_log VARCHAR (250) NULL,
CONSTRAINT jahia_audit_log_PK PRIMARY KEY(id_jahia_audit_log));
Index: jahia-schema.sql
===================================================================
RCS file:
/home/cvs/repository/jahia/core/src/webapp/WEB-INF/var/db/sql/schema/mysql/jahia-schema.sql,v
retrieving revision 1.13
retrieving revision 1.14
diff -u -r1.13 -r1.14
--- jahia-schema.sql 3 Nov 2005 13:22:49 -0000 1.13
+++ jahia-schema.sql 21 Nov 2005 15:48:34 -0000 1.14
@@ -120,7 +120,7 @@
parentid_jahia_audit_log INTEGER,
operation_jahia_audit_log VARCHAR (50),
site_jahia_audit_log VARCHAR (50),
- content_jahia_audit_log VARCHAR (50),
+ content_jahia_audit_log VARCHAR (250),
PRIMARY KEY(id_jahia_audit_log)
);
Index: jahia-schema.sql
===================================================================
RCS file:
/home/cvs/repository/jahia/core/src/webapp/WEB-INF/var/db/sql/schema/postgresql/jahia-schema.sql,v
retrieving revision 1.13
retrieving revision 1.14
diff -u -r1.13 -r1.14
--- jahia-schema.sql 4 Nov 2005 13:14:48 -0000 1.13
+++ jahia-schema.sql 21 Nov 2005 15:48:34 -0000 1.14
@@ -135,7 +135,7 @@
parentid_jahia_audit_log integer,
operation_jahia_audit_log varchar (50),
site_jahia_audit_log varchar (50),
- content_jahia_audit_log varchar (50),
+ content_jahia_audit_log varchar (250),
PRIMARY KEY (id_jahia_audit_log)
);
Index: phase1-schema.sql
===================================================================
RCS file:
/home/cvs/repository/jahia/core/src/webapp/WEB-INF/var/db/sql/schema/postgresql/phase1-schema.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -r1.2 -r1.3
--- phase1-schema.sql 8 Jul 2005 16:12:43 -0000 1.2
+++ phase1-schema.sql 21 Nov 2005 15:48:34 -0000 1.3
@@ -12,7 +12,7 @@
NAME varchar (80) NOT NULL,
CHARACTER_SET varchar (40),
TITLE varchar (80),
- DESCRIPTION bytea,
+ DESCRIPTION text,
PRIMARY KEY (MEDIATYPE_ID)
);
Index: quartz-schema.sql
===================================================================
RCS file:
/home/cvs/repository/jahia/core/src/webapp/WEB-INF/var/db/sql/schema/postgresql/quartz-schema.sql,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -r1.4 -r1.5
--- quartz-schema.sql 24 Oct 2005 12:42:51 -0000 1.4
+++ quartz-schema.sql 21 Nov 2005 15:48:34 -0000 1.5
@@ -1,22 +1,22 @@
-drop table jahia_qrtz_calendars cascade constraints;
-drop table jahia_qrtz_fired_triggers cascade constraints;
-drop table jahia_qrtz_trigger_listeners cascade constraints;
-drop table jahia_qrtz_blob_triggers cascade constraints;
-drop table jahia_qrtz_cron_triggers cascade constraints;
-drop table jahia_qrtz_simple_triggers cascade constraints;
-drop table jahia_qrtz_triggers cascade constraints;
-drop table jahia_qrtz_job_listeners cascade constraints;
-drop table jahia_qrtz_job_details cascade constraints;
-drop table jahia_qrtz_paused_trigger_grps cascade constraints;
-drop table jahia_qrtz_locks cascade constraints;
-drop table jahia_qrtz_scheduler_state cascade constraints;
+drop table jahia_qrtz_job_listeners;
+drop table jahia_qrtz_trigger_listeners;
+drop table jahia_qrtz_fired_triggers;
+DROP TABLE jahia_qrtz_PAUSED_TRIGGER_GRPS;
+DROP TABLE jahia_qrtz_SCHEDULER_STATE;
+DROP TABLE jahia_qrtz_LOCKS;
+drop table jahia_qrtz_simple_triggers;
+drop table jahia_qrtz_cron_triggers;
+DROP TABLE jahia_qrtz_BLOB_TRIGGERS;
+drop table jahia_qrtz_triggers;
+drop table jahia_qrtz_job_details;
+drop table jahia_qrtz_calendars;
CREATE TABLE jahia_qrtz_job_details
(
JOB_NAME VARCHAR(80) NOT NULL,
JOB_GROUP VARCHAR(80) NOT NULL,
DESCRIPTION VARCHAR(120) NULL,
- JOB_CLASS_NAME VARCHAR(128) NOT NULL,
+ JOB_CLASS_NAME VARCHAR(128) NOT NULL,
IS_DURABLE BOOL NOT NULL,
IS_VOLATILE BOOL NOT NULL,
IS_STATEFUL BOOL NOT NULL,
@@ -27,19 +27,19 @@
CREATE TABLE jahia_qrtz_job_listeners
(
- JOB_NAME VARCHAR(80) NOT NULL,
+ JOB_NAME VARCHAR(80) NOT NULL,
JOB_GROUP VARCHAR(80) NOT NULL,
JOB_LISTENER VARCHAR(80) NOT NULL,
PRIMARY KEY (JOB_NAME,JOB_GROUP,JOB_LISTENER),
- FOREIGN KEY (JOB_NAME,JOB_GROUP)
- REFERENCES jahia_QRTZ_JOB_DETAILS(JOB_NAME,JOB_GROUP)
+ FOREIGN KEY (JOB_NAME,JOB_GROUP)
+ REFERENCES jahia_qrtz_JOB_DETAILS(JOB_NAME,JOB_GROUP)
);
CREATE TABLE jahia_qrtz_triggers
(
TRIGGER_NAME VARCHAR(80) NOT NULL,
TRIGGER_GROUP VARCHAR(80) NOT NULL,
- JOB_NAME VARCHAR(80) NOT NULL,
+ JOB_NAME VARCHAR(80) NOT NULL,
JOB_GROUP VARCHAR(80) NOT NULL,
IS_VOLATILE BOOL NOT NULL,
DESCRIPTION VARCHAR(120) NULL,
@@ -53,8 +53,8 @@
MISFIRE_INSTR SMALLINT NULL,
JOB_DATA BYTEA NULL,
PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),
- FOREIGN KEY (JOB_NAME,JOB_GROUP)
- REFERENCES jahia_QRTZ_JOB_DETAILS(JOB_NAME,JOB_GROUP)
+ FOREIGN KEY (JOB_NAME,JOB_GROUP)
+ REFERENCES jahia_qrtz_JOB_DETAILS(JOB_NAME,JOB_GROUP)
);
CREATE TABLE jahia_qrtz_simple_triggers
@@ -65,8 +65,8 @@
REPEAT_INTERVAL BIGINT NOT NULL,
TIMES_TRIGGERED BIGINT NOT NULL,
PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),
- FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP)
- REFERENCES jahia_QRTZ_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)
+ FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP)
+ REFERENCES jahia_qrtz_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)
);
CREATE TABLE jahia_qrtz_cron_triggers
@@ -76,8 +76,8 @@
CRON_EXPRESSION VARCHAR(80) NOT NULL,
TIME_ZONE_ID VARCHAR(80),
PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),
- FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP)
- REFERENCES jahia_QRTZ_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)
+ FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP)
+ REFERENCES jahia_qrtz_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)
);
CREATE TABLE jahia_qrtz_blob_triggers
@@ -86,24 +86,24 @@
TRIGGER_GROUP VARCHAR(80) NOT NULL,
BLOB_DATA BYTEA NULL,
PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),
- FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP)
- REFERENCES jahia_QRTZ_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)
+ FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP)
+ REFERENCES jahia_qrtz_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)
);
CREATE TABLE jahia_qrtz_trigger_listeners
(
- TRIGGER_NAME VARCHAR(80) NOT NULL,
+ TRIGGER_NAME VARCHAR(80) NOT NULL,
TRIGGER_GROUP VARCHAR(80) NOT NULL,
TRIGGER_LISTENER VARCHAR(80) NOT NULL,
PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP,TRIGGER_LISTENER),
- FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP)
- REFERENCES jahia_QRTZ_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)
+ FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP)
+ REFERENCES jahia_qrtz_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)
);
CREATE TABLE jahia_qrtz_calendars
(
- CALENDAR_NAME VARCHAR(80) NOT NULL,
+ CALENDAR_NAME VARCHAR(80) NOT NULL,
CALENDAR BYTEA NOT NULL,
PRIMARY KEY (CALENDAR_NAME)
);
@@ -111,7 +111,7 @@
CREATE TABLE jahia_qrtz_paused_trigger_grps
(
- TRIGGER_GROUP VARCHAR(80) NOT NULL,
+ TRIGGER_GROUP VARCHAR(80) NOT NULL,
PRIMARY KEY (TRIGGER_GROUP)
);
@@ -142,7 +142,7 @@
CREATE TABLE jahia_qrtz_locks
(
- LOCK_NAME VARCHAR(40) NOT NULL,
+ LOCK_NAME VARCHAR(40) NOT NULL,
PRIMARY KEY (LOCK_NAME)
);
@@ -154,4 +154,3 @@
INSERT INTO jahia_qrtz_locks values('MISFIRE_ACCESS');
commit;
-
Index: registry-schema.sql
===================================================================
RCS file:
/home/cvs/repository/jahia/core/src/webapp/WEB-INF/var/db/sql/schema/postgresql/registry-schema.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- registry-schema.sql 23 Dec 2004 16:19:52 -0000 1.1
+++ registry-schema.sql 21 Nov 2005 15:48:34 -0000 1.2
@@ -69,7 +69,7 @@
ID integer NOT NULL,
-- REFERENCES PORTLET_APPLICATION
(APPLICATION_ID)
OBJECT_ID integer NOT NULL,
- VALUE bytea NOT NULL,
+ VALUE text NOT NULL,
NAME varchar (100) NOT NULL,
LOCALE_STRING varchar (50) NOT NULL,
PRIMARY KEY (ID)
@@ -88,7 +88,7 @@
ID integer NOT NULL,
-- REFERENCES PORTLET_DEFINITION (ID)
OBJECT_ID integer NOT NULL,
- VALUE bytea NOT NULL,
+ VALUE text NOT NULL,
NAME varchar (100) NOT NULL,
LOCALE_STRING varchar (50) NOT NULL,
PRIMARY KEY (ID)
@@ -109,7 +109,7 @@
TITLE varchar (100),
SHORT_TITLE varchar (50),
LOCALE_STRING varchar (50) NOT NULL,
- KEYWORDS bytea,
+ KEYWORDS text,
PRIMARY KEY (ID)
);
@@ -126,7 +126,7 @@
CONTENT_TYPE_ID integer NOT NULL,
PORTLET_ID integer NOT NULL,
CONTENT_TYPE varchar (30) NOT NULL,
- MODES bytea,
+ MODES text,
PRIMARY KEY (CONTENT_TYPE_ID)
);
@@ -144,7 +144,7 @@
PARENT_ID integer NOT NULL,
CLASS_NAME varchar (255) NOT NULL,
NAME varchar (80) NOT NULL,
- PARAMETER_VALUE bytea NOT NULL,
+ PARAMETER_VALUE text NOT NULL,
PRIMARY KEY (PARAMETER_ID)
);
@@ -160,7 +160,7 @@
(
ID integer NOT NULL,
PREFERENCE_ID integer,
- VALUE bytea,
+ VALUE text,
PRIMARY KEY (ID)
);
@@ -299,7 +299,7 @@
ID integer NOT NULL,
OBJECT_ID integer NOT NULL,
CLASS_NAME varchar (255) NOT NULL,
- DESCRIPTION bytea NOT NULL,
+ DESCRIPTION text NOT NULL,
LOCALE_STRING varchar (50) NOT NULL,
PRIMARY KEY (ID)
);
@@ -317,7 +317,7 @@
ID integer NOT NULL,
OBJECT_ID integer NOT NULL,
CLASS_NAME varchar (255),
- DISPLAY_NAME bytea NOT NULL,
+ DISPLAY_NAME text NOT NULL,
LOCALE_STRING varchar (50) NOT NULL,
PRIMARY KEY (ID)
);
