portals-jetspeed-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 15039] - dbpsml-schema.sql generation for MySQL produces spurious commas
Date Wed, 04 Dec 2002 00:59:20 GMT
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG 
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://nagoya.apache.org/bugzilla/show_bug.cgi?id=15039>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND 
INSERTED IN THE BUG DATABASE.

http://nagoya.apache.org/bugzilla/show_bug.cgi?id=15039

dbpsml-schema.sql generation for MySQL produces spurious commas





------- Additional Comments From david@bluesunrise.com  2002-12-04 00:59 -------
I tried it, and I get this (i dont see spurious commas):


# -----------------------------------------------------------------------
# JETSPEED_USER_PROFILE
# -----------------------------------------------------------------------
drop table if exists JETSPEED_USER_PROFILE;

CREATE TABLE JETSPEED_USER_PROFILE
(
                            PSML_ID INTEGER NOT NULL AUTO_INCREMENT,
                    USER_NAME VARCHAR (32) NOT NULL,
                    MEDIA_TYPE VARCHAR (99),
                    LANGUAGE VARCHAR (2),
                    COUNTRY VARCHAR (2),
                    PAGE VARCHAR (99),
                    PROFILE BLOB,
    PRIMARY KEY(PSML_ID),
    UNIQUE (USER_NAME, MEDIA_TYPE, LANGUAGE, COUNTRY, PAGE)
);

# -----------------------------------------------------------------------
# JETSPEED_GROUP_PROFILE
# -----------------------------------------------------------------------
drop table if exists JETSPEED_GROUP_PROFILE;

CREATE TABLE JETSPEED_GROUP_PROFILE
(
                            PSML_ID INTEGER NOT NULL AUTO_INCREMENT,
                    GROUP_NAME VARCHAR (99) NOT NULL,
                    MEDIA_TYPE VARCHAR (99),
                    LANGUAGE VARCHAR (2),
                    COUNTRY VARCHAR (2),
                    PAGE VARCHAR (99),
                    PROFILE BLOB,
    PRIMARY KEY(PSML_ID),
    UNIQUE (GROUP_NAME, MEDIA_TYPE, LANGUAGE, COUNTRY, PAGE)
);

# -----------------------------------------------------------------------
# JETSPEED_ROLE_PROFILE
# -----------------------------------------------------------------------
drop table if exists JETSPEED_ROLE_PROFILE;

CREATE TABLE JETSPEED_ROLE_PROFILE
(
                            PSML_ID INTEGER NOT NULL AUTO_INCREMENT,
                    ROLE_NAME VARCHAR (99) NOT NULL,
                    MEDIA_TYPE VARCHAR (99),
                    LANGUAGE VARCHAR (2),
                    COUNTRY VARCHAR (2),
                    PAGE VARCHAR (99),
                    PROFILE BLOB,
    PRIMARY KEY(PSML_ID),
    UNIQUE (ROLE_NAME, MEDIA_TYPE, LANGUAGE, COUNTRY, PAGE)
);

--
To unsubscribe, e-mail:   <mailto:jetspeed-dev-unsubscribe@jakarta.apache.org>
For additional commands, e-mail: <mailto:jetspeed-dev-help@jakarta.apache.org>


Mime
View raw message