maven-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jason van Zyl <jvan...@maven.org>
Subject Re: Oracle SQL Schema Script for Maven XSD
Date Mon, 12 Jan 2004 15:42:21 GMT
On Mon, 2004-01-12 at 02:59, Alex Karasulu wrote:
> Jason,
> 
> Here's an Oracle SQL script for the Maven XSD.  

Cool, I'll keep that but have you worked with Axion? I figured for
testing purposes it might be easier as it is easily embeddable for
tests. At any rate it will be good to have some other model providers
for testing. I'll integrate soonish.

> 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.

No problem, easy enough to sort through that.

> 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.  

Yah, using OJB I never use foreign keys directly in the DDL. I let the
application take care of managing the integrity of relationships among
entities anyway. FKs used directly in DDL are always a big fat pain in
the ass.

> Also I might generate some table creation 
> and deletion scripts later for other databases like 
> mssql, mysql and postgres.

Definitely, there's lots of stuff for that. commons-sql, the stuff in
torque and some stuff in OJB.

Thanks for the goods!

> 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: dev-unsubscribe@maven.apache.org
> For additional commands, e-mail: dev-help@maven.apache.org

-- 
jvz.

Jason van Zyl
jason@maven.org
http://maven.apache.org

happiness is like a butterfly: the more you chase it, the more it will
elude you, but if you turn your attention to other things, it will come
and sit softly on your shoulder ...

 -- Thoreau 


---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@maven.apache.org
For additional commands, e-mail: dev-help@maven.apache.org


Mime
View raw message