Jason,
Here's an Oracle SQL script for the Maven XSD. I had
to shorten all identifiers that had the word directory
like sourcedirectory by truncating directory->dir in
these identifiers. I did this because
integrationUnitTestSourceDirectory was too long of an
identifier for a column. So as a standard I presume that
all identifiers are uppercased and that DIRECTORY substrings
in identifiers are truncated down to DIR.
I need to add some foreign key constraints but for the
time being I have left it bare - I'll get to it later.
Just thought I'd get this to you if you want to experiment
with OJB. Also I might generate some table creation
and deletion scripts later for other databases like
mssql, mysql and postgres.
L8r,
Alex
CREATE TABLE "BRANCH" (
"TAG" VARCHAR2 (255) CONSTRAINT "CNN_BRANCH_0" NOT NULL
)
/
CREATE TABLE "BUILD" (
"NAGEMAILADDRESS" VARCHAR2 (255) CONSTRAINT "CNN_BUILD_1" NOT NULL ,
"SOURCEDIR" VARCHAR2 (255) CONSTRAINT "CNN_BUILD_2" NOT NULL ,
"UNITTESTSOURCEDIR" VARCHAR2 (255) CONSTRAINT "CNN_BUILD_3" NOT NULL ,
"INTEGRATIONUNITTESTSOURCEDIR" VARCHAR2 (255) CONSTRAINT "CNN_BUILD_4" NOT NULL ,
"ASPECTSOURCEDIR" VARCHAR2 (255) CONSTRAINT "CNN_BUILD_5" NOT NULL
)
/
CREATE TABLE "CONTRIBUTOR" (
"NAME" VARCHAR2 (255) CONSTRAINT "CNN_CONTRIBUTOR_6" NOT NULL ,
"EMAIL" VARCHAR2 (255) CONSTRAINT "CNN_CONTRIBUTOR_7" NOT NULL ,
"ORGANIZATION" VARCHAR2 (255) CONSTRAINT "CNN_CONTRIBUTOR_8" NOT NULL ,
"URL" VARCHAR2 (255) CONSTRAINT "CNN_CONTRIBUTOR_9" NOT NULL ,
"TIMEZONE" NUMBER CONSTRAINT "CNN_CONTRIBUTOR_10" NOT NULL CHECK ( "TIMEZONE" >=
-14 AND "TIMEZONE" <= +14)
)
/
CREATE TABLE "ROLES" (
"ROLE" VARCHAR2 (255) CONSTRAINT "CNN_ROLES_11" NOT NULL
)
/
CREATE TABLE "DEPENDENCY" (
"ID" VARCHAR2 (255) CONSTRAINT "CNN_DEPENDENCY_12" NOT NULL ,
"GROUPID" VARCHAR2 (255) CONSTRAINT "CNN_DEPENDENCY_13" NOT NULL ,
"ARTIFACTID" VARCHAR2 (255) CONSTRAINT "CNN_DEPENDENCY_14" NOT NULL ,
"VERSION" VARCHAR2 (255) CONSTRAINT "CNN_DEPENDENCY_15" NOT NULL ,
"JAR" VARCHAR2 (255) CONSTRAINT "CNN_DEPENDENCY_16" NOT NULL ,
"TYPE" VARCHAR2 (255) CONSTRAINT "CNN_DEPENDENCY_17" NOT NULL ,
"URL" VARCHAR2 (255) CONSTRAINT "CNN_DEPENDENCY_18" NOT NULL
)
/
CREATE TABLE "DEVELOPER" (
"NAME" VARCHAR2 (255) CONSTRAINT "CNN_DEVELOPER_19" NOT NULL ,
"ID" VARCHAR2 (255) CONSTRAINT "CNN_DEVELOPER_20" NOT NULL ,
"EMAIL" VARCHAR2 (255) CONSTRAINT "CNN_DEVELOPER_21" NOT NULL ,
"ORGANIZATION" VARCHAR2 (255) CONSTRAINT "CNN_DEVELOPER_22" NOT NULL ,
"URL" VARCHAR2 (255) CONSTRAINT "CNN_DEVELOPER_23" NOT NULL ,
"TIMEZONE" NUMBER CONSTRAINT "CNN_DEVELOPER_24" NOT NULL CHECK ( "TIMEZONE" >=
-14 AND "TIMEZONE" <= +14)
)
/
CREATE TABLE "EXCLUDES" (
"EXCLUDE" VARCHAR2 (255) CONSTRAINT "CNN_EXCLUDES_25" NOT NULL
)
/
CREATE TABLE "INCLUDES" (
"INCLUDE" VARCHAR2 (255) CONSTRAINT "CNN_INCLUDES_26" NOT NULL
)
/
CREATE TABLE "LICENSE" (
"NAME" VARCHAR2 (255) CONSTRAINT "CNN_LICENSE_27" NOT NULL ,
"URL" VARCHAR2 (255) CONSTRAINT "CNN_LICENSE_28" NOT NULL ,
"DISTRIBUTION" VARCHAR2 (255) CONSTRAINT "CNN_LICENSE_29" NOT NULL CONSTRAINT
"CPA_LICENSE_30" CHECK ( "DISTRIBUTION" LIKE 'MANUAL|REPO' )
)
/
CREATE TABLE "MAILINGLIST" (
"NAME" VARCHAR2 (255) CONSTRAINT "CNN_MAILINGLIST_31" NOT NULL ,
"SUBSCRIBE" VARCHAR2 (255) CONSTRAINT "CNN_MAILINGLIST_32" NOT NULL ,
"UNSUBSCRIBE" VARCHAR2 (255) CONSTRAINT "CNN_MAILINGLIST_33" NOT NULL ,
"ARCHIVE" VARCHAR2 (255) CONSTRAINT "CNN_MAILINGLIST_34" NOT NULL
)
/
CREATE TABLE "ORGANIZATION" (
"NAME" VARCHAR2 (255) CONSTRAINT "CNN_ORGANIZATION_35" NOT NULL ,
"URL" VARCHAR2 (255) CONSTRAINT "CNN_ORGANIZATION_36" NOT NULL ,
"LOGO" VARCHAR2 (255) CONSTRAINT "CNN_ORGANIZATION_37" NOT NULL
)
/
CREATE TABLE "PROJECT" (
"EXTEND" VARCHAR2 (255) CONSTRAINT "CNN_PROJECT_38" NOT NULL ,
"POMVERSION" VARCHAR2 (255) CONSTRAINT "CNN_PROJECT_39" NOT NULL ,
"ID" VARCHAR2 (255) CONSTRAINT "CNN_PROJECT_40" NOT NULL ,
"NAME" VARCHAR2 (255) CONSTRAINT "CNN_PROJECT_41" NOT NULL ,
"GROUPID" VARCHAR2 (255) CONSTRAINT "CNN_PROJECT_42" NOT NULL ,
"CURRENTVERSION" VARCHAR2 (255) CONSTRAINT "CNN_PROJECT_43" NOT NULL ,
"INCEPTIONYEAR" DATE CONSTRAINT "CNN_PROJECT_44" NOT NULL ,
"PACKAGE" VARCHAR2 (255) CONSTRAINT "CNN_PROJECT_45" NOT NULL ,
"LOGO" VARCHAR2 (255) CONSTRAINT "CNN_PROJECT_46" NOT NULL ,
"GUMPREPOSITORYID" VARCHAR2 (255) CONSTRAINT "CNN_PROJECT_47" NOT NULL ,
"DESCRIPTION" VARCHAR2 (255) CONSTRAINT "CNN_PROJECT_48" NOT NULL ,
"SHORTDESCRIPTION" VARCHAR2 (255) CONSTRAINT "CNN_PROJECT_49" NOT NULL ,
"URL" VARCHAR2 (255) CONSTRAINT "CNN_PROJECT_50" NOT NULL ,
"ISSUETRACKINGURL" VARCHAR2 (255) CONSTRAINT "CNN_PROJECT_51" NOT NULL ,
"SITEADDRESS" VARCHAR2 (255) CONSTRAINT "CNN_PROJECT_52" NOT NULL ,
"SITEDIR" VARCHAR2 (255) CONSTRAINT "CNN_PROJECT_53" NOT NULL ,
"DISTRIBUTIONSITE" VARCHAR2 (255) CONSTRAINT "CNN_PROJECT_54" NOT NULL ,
"DISTRIBUTIONDIR" VARCHAR2 (255) CONSTRAINT "CNN_PROJECT_55" NOT NULL
)
/
CREATE TABLE "REPOSITORY" (
"CONNECTION" VARCHAR2 (255) CONSTRAINT "CNN_REPOSITORY_56" NOT NULL ,
"DEVELOPERCONNECTION" VARCHAR2 (255) CONSTRAINT "CNN_REPOSITORY_57" NOT NULL ,
"URL" VARCHAR2 (255) CONSTRAINT "CNN_REPOSITORY_58" NOT NULL
)
/
CREATE TABLE "REPORTS" (
"REPORT" VARCHAR2 (255) CONSTRAINT "CNN_REPORTS_59" NOT NULL
)
/
CREATE TABLE "RESOURCE" (
"DIR" VARCHAR2 (255) CONSTRAINT "CNN_RESOURCE_60" NOT NULL ,
"TARGETPATH" VARCHAR2 (255) CONSTRAINT "CNN_RESOURCE_61" NOT NULL ,
"FILTERING" NUMBER CONSTRAINT "CNN_RESOURCE_62" NOT NULL CHECK ("FILTERING" IN
(1,0))
)
/
CREATE TABLE "SOURCEMODIFICATION" (
"CLASSNAME" VARCHAR2 (255) CONSTRAINT "CNN_SOURCEMODIFICATION_63" NOT NULL
)
/
CREATE TABLE "VERSION" (
"ID" VARCHAR2 (255) CONSTRAINT "CNN_VERSION_64" NOT NULL ,
"NAME" VARCHAR2 (255) CONSTRAINT "CNN_VERSION_65" NOT NULL ,
"TAG" VARCHAR2 (255) CONSTRAINT "CNN_VERSION_66" NOT NULL
)
/
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
