You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@maven.apache.org by Alex Karasulu <ao...@bellsouth.net> on 2004/01/12 08:59:22 UTC
Oracle SQL Schema Script for Maven XSD
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
Re: Oracle SQL Schema Script for Maven XSD
Posted by Jason van Zyl <jv...@maven.org>.
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
Re: Oracle SQL Schema Script for Maven XSD
Posted by Jason van Zyl <jv...@maven.org>.
On Mon, 2004-01-12 at 02:59, Alex Karasulu wrote:
> Jason,
>
> Here's an Oracle SQL script for the Maven XSD.
Also, if you have some more code it's best to stuff them in JIRA or I
will definitely forget about them after a few days.
--
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