schema/spacewalk/README | 105 +++++++++++++++++++++++
schema/spacewalk/common/data/data.deps | 13 ++
schema/spacewalk/common/tables/tables.deps | 12 ++
schema/spacewalk/common/views/views.deps | 13 ++
schema/spacewalk/header.txt | 3
schema/spacewalk/oracle/Makefile | 38 ++++++++
schema/spacewalk/oracle/class/class.deps | 13 ++
schema/spacewalk/oracle/data/data.deps | 13 ++
schema/spacewalk/oracle/packages/packages.deps | 13 ++
schema/spacewalk/oracle/procs/procs.deps | 15 +++
schema/spacewalk/oracle/tables/tables.deps | 17 +++
schema/spacewalk/oracle/triggers/triggers.deps | 13 ++
schema/spacewalk/oracle/types/types.deps | 13 ++
schema/spacewalk/oracle/views/views.deps | 13 ++
schema/spacewalk/postgres/Makefile | 30 ++++++
schema/spacewalk/postgres/class/class.deps | 13 ++
schema/spacewalk/postgres/data/data.deps | 13 ++
schema/spacewalk/postgres/packages/packages.deps | 13 ++
schema/spacewalk/postgres/procs/procs.deps | 15 +++
schema/spacewalk/postgres/tables/tables.deps | 15 +++
schema/spacewalk/postgres/triggers/triggers.deps | 13 ++
schema/spacewalk/postgres/views/views.deps | 13 ++
schema/util/genmain.py | 19 ++++
23 files changed, 418 insertions(+), 20 deletions(-)
New commits:
commit 7bfebb5990eab9cbb14a3af3107e8c6f470f6d37
Author: Jeff Ortel <jortel(a)redhat.com>
Date: Thu Apr 2 10:53:12 2009 -0400
Update .deps header and comments; add README
diff --git a/schema/spacewalk/README b/schema/spacewalk/README
new file mode 100644
index 0000000..ede788b
--- /dev/null
+++ b/schema/spacewalk/README
@@ -0,0 +1,105 @@
+
+
+DIRECTORIES
+-------------------------------------------------------------------------------
+
+/schema/spacewalk
+/schema/spacewalk/common - Common DDL
+/schema/spacewalk/common/tables - Common DDL: table,index,sequences
+/schema/spacewalk/common/data - Common SQL: INSERTs
+/schema/spacewalk/common/views - Generic view DDL
+
+ORACLE:
+
+/schema/spacewalk/oracle - Oracle specific DDL
+/schema/spacewalk/oracle/class - Oracle specific class DDL
+/schema/spacewalk/oracle/types - Oracle specific types DDL
+/schema/spacewalk/oracle/tables - Oracle specific table DDL
+/schema/spacewalk/oracle/tables/common - Generated from common/tables
+/schema/spacewalk/oracle/views - Oracle specific view DDL
+/schema/spacewalk/oracle/views/common - Copied from common/views
+/schema/spacewalk/oracle/data - Oracle specific INSERTs
+/schema/spacewalk/oracle/data/common - Generated from common/data
+/schema/spacewalk/oracle/triggers - Oracle specific trigger DDL
+/schema/spacewalk/oracle/procs - PL/SQL procedures/functions DDL.
+/schema/spacewalk/oracle/packages - PL/SQL packages DDL.
+
+POSTGRES:
+
+/schema/spacewalk/postgres - Postgres specific DDL
+/schema/spacewalk/postgres/class - Postgres specific class DDL
+/schema/spacewalk/postgres/types - Postgres specific types DDL
+/schema/spacewalk/postgres/tables - Postgres specific table DDL
+/schema/spacewalk/postgres/tables/common - Generated from common/tables
+/schema/spacewalk/postgres/views - Postgres specific view DDL
+/schema/spacewalk/postgres/views/common - Copied from common/views
+/schema/spacewalk/postgres/data - Postgres specific INSERTs
+/schema/spacewalk/postgres/data/common - Generated from common/data
+/schema/spacewalk/postgres/triggers - Postgres specific trigger DDL
+/schema/spacewalk/postgres/procs - PG/SQL procedures/functions DDL.
+/schema/spacewalk/postgres/packages - PG/SQL packages DDL.
+
+
+TOOLS
+-------------------------------------------------------------------------------
+
+dogchow - Used to translate the common DDL to oracle|postgres specific
+ DDL.
+
+util/genmain.py - Used to generate the main.sql based on .deps files.
+
+
+DEPENDENCY FILES (.deps)
+-------------------------------------------------------------------------------
+
+Terms:
+ namespace - A root directory.
+ May be: (.|class|types|tables|views|procs|packages)
+ where (.) represents the current namesapce.
+
+ qname - A qualified name.
+ May be: [namespace/]basename[.ext]. When the namespace
+ is not specified, the name is unqualified and resolved
+ using the "path". Using the extension is only necessary
+ when more then (1) file exists in a given namespace with
+ the same name but with different extensions.
+
+Format:
+
+ path = {namespace}([\s,]+{namespace})*
+
+ {qname} :: {qname}([\s,]+{qname})*
+
+Examples:
+
+ path = . tables packages"
+
+ rhnSharedChannelView :: rhnChannel procs/lookup_functions \
+ rhn_channel.pks
+
+ Assuming the current namespace (or directory) is /views.
+ The table dependency "rhnChannel" is unqualifed and would be searched
+ for in the following order:
+ 1st. views/rhnChannel
+ 2nd. tables/rhnChannel
+ 3rd. packages/rhnChannel
+ However, lookup_functions dependency is qualified by namespace so the
+ path will not be used.
+ The package header dependency "rhn_channel.pks" is unqualifed and but has
+ an extension and would be searched for in the following order:
+ 1st. views/rhn_channel.pks
+ 2nd. tables/rhn_channel.pks
+ 3rd. packages/rhn_channel.pks
+
+Lines may be joined by (\).
+
+
+MAIN.SQL
+-------------------------------------------------------------------------------
+The main.sql file is generated and references includes
+the individual .sql, .pks, .pkb files within the directory
+tree. This file is generated by "utils/genmain.py and ordered
+based on .deps files. This takes the place of the universal .sql
+file.
+
+
diff --git a/schema/spacewalk/common/data/data.deps
b/schema/spacewalk/common/data/data.deps
index ac54834..649e6ad 100644
--- a/schema/spacewalk/common/data/data.deps
+++ b/schema/spacewalk/common/data/data.deps
@@ -1,5 +1,16 @@
#
-# Dependencies for objects in the data directory
+# Copyright (c) 2008 Red Hat, Inc.
+#
+# This software is licensed to you under the GNU General Public License,
+# version 2 (GPLv2). There is NO WARRANTY for this software, express or
+# implied, including the implied warranties of MERCHANTABILITY or FITNESS
+# FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2
+# along with this software; if not, see
+#
http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt.
+#
+# Dependencies for data (insert) objects in this (namespace) directory.
+# See: ../../README for details.
+# No TABS, PLEASE!
#
path = . tables procs
diff --git a/schema/spacewalk/common/tables/tables.deps
b/schema/spacewalk/common/tables/tables.deps
index 6623e18..0b28da3 100644
--- a/schema/spacewalk/common/tables/tables.deps
+++ b/schema/spacewalk/common/tables/tables.deps
@@ -1,6 +1,16 @@
#
-# Dependencies for objects in the tables directory
+# Copyright (c) 2008 Red Hat, Inc.
#
+# This software is licensed to you under the GNU General Public License,
+# version 2 (GPLv2). There is NO WARRANTY for this software, express or
+# implied, including the implied warranties of MERCHANTABILITY or FITNESS
+# FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2
+# along with this software; if not, see
+#
http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt.
+#
+# Dependencies for table objects in this (namespace) directory.
+# See: ../../README for details.
+# No TABS, PLEASE!
#
path = . class types
diff --git a/schema/spacewalk/common/views/views.deps
b/schema/spacewalk/common/views/views.deps
index ebd2419..1f7a6ba 100644
--- a/schema/spacewalk/common/views/views.deps
+++ b/schema/spacewalk/common/views/views.deps
@@ -1,5 +1,16 @@
#
-# Dependencies for the views directory
+# Copyright (c) 2008 Red Hat, Inc.
+#
+# This software is licensed to you under the GNU General Public License,
+# version 2 (GPLv2). There is NO WARRANTY for this software, express or
+# implied, including the implied warranties of MERCHANTABILITY or FITNESS
+# FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2
+# along with this software; if not, see
+#
http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt.
+#
+# Dependencies for view objects in this (namespace) directory.
+# See: ../../README for details.
+# No TABS, PLEASE!
#
path = . tables procs packages
diff --git a/schema/spacewalk/oracle/class/class.deps
b/schema/spacewalk/oracle/class/class.deps
index 76d2c50..f9c55f6 100644
--- a/schema/spacewalk/oracle/class/class.deps
+++ b/schema/spacewalk/oracle/class/class.deps
@@ -1,5 +1,16 @@
#
-# Dependencies for objects in the class directory
+# Copyright (c) 2008 Red Hat, Inc.
+#
+# This software is licensed to you under the GNU General Public License,
+# version 2 (GPLv2). There is NO WARRANTY for this software, express or
+# implied, including the implied warranties of MERCHANTABILITY or FITNESS
+# FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2
+# along with this software; if not, see
+#
http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt.
+#
+# Dependencies for class objects in this (namespace) directory.
+# See: ../../README for details.
+# No TABS, PLEASE!
#
path = . packages
diff --git a/schema/spacewalk/oracle/data/data.deps
b/schema/spacewalk/oracle/data/data.deps
index a483ce7..85aea44 100644
--- a/schema/spacewalk/oracle/data/data.deps
+++ b/schema/spacewalk/oracle/data/data.deps
@@ -1,5 +1,16 @@
#
-# Dependencies for the data directory
+# Copyright (c) 2008 Red Hat, Inc.
+#
+# This software is licensed to you under the GNU General Public License,
+# version 2 (GPLv2). There is NO WARRANTY for this software, express or
+# implied, including the implied warranties of MERCHANTABILITY or FITNESS
+# FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2
+# along with this software; if not, see
+#
http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt.
+#
+# Dependencies for data (insert) objects in this (namespace) directory.
+# See: ../../README for details.
+# No TABS, PLEASE!
#
path = tables procs
diff --git a/schema/spacewalk/oracle/packages/packages.deps
b/schema/spacewalk/oracle/packages/packages.deps
index 5e7574c..36b8ffe 100644
--- a/schema/spacewalk/oracle/packages/packages.deps
+++ b/schema/spacewalk/oracle/packages/packages.deps
@@ -1,5 +1,16 @@
#
-# Dependencies for the packages directory
+# Copyright (c) 2008 Red Hat, Inc.
+#
+# This software is licensed to you under the GNU General Public License,
+# version 2 (GPLv2). There is NO WARRANTY for this software, express or
+# implied, including the implied warranties of MERCHANTABILITY or FITNESS
+# FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2
+# along with this software; if not, see
+#
http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt.
+#
+# Dependencies for packages objects in this (namespace) directory.
+# See: ../../README for details.
+# No TABS, PLEASE!
#
path = . tables views procs
diff --git a/schema/spacewalk/oracle/procs/procs.deps
b/schema/spacewalk/oracle/procs/procs.deps
index 2f169d0..4328b6a 100644
--- a/schema/spacewalk/oracle/procs/procs.deps
+++ b/schema/spacewalk/oracle/procs/procs.deps
@@ -1,5 +1,18 @@
#
-# Dependencies for objects in the procs directory
+# Copyright (c) 2008 Red Hat, Inc.
+#
+# This software is licensed to you under the GNU General Public License,
+# version 2 (GPLv2). There is NO WARRANTY for this software, express or
+# implied, including the implied warranties of MERCHANTABILITY or FITNESS
+# FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2
+# along with this software; if not, see
+#
http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt.
+#
+# Dependencies for stored procedures/functions objects
+# in this (namespace) directory.
+#
+# See: ../../README for details.
+# No TABS, PLEASE!
#
path = . tables views packages class types
diff --git a/schema/spacewalk/oracle/tables/tables.deps
b/schema/spacewalk/oracle/tables/tables.deps
new file mode 100644
index 0000000..e635a5d
--- /dev/null
+++ b/schema/spacewalk/oracle/tables/tables.deps
@@ -0,0 +1,17 @@
+#
+# Copyright (c) 2008 Red Hat, Inc.
+#
+# This software is licensed to you under the GNU General Public License,
+# version 2 (GPLv2). There is NO WARRANTY for this software, express or
+# implied, including the implied warranties of MERCHANTABILITY or FITNESS
+# FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2
+# along with this software; if not, see
+#
http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt.
+#
+# Dependencies for table objects in this (namespace) directory.
+# See: ../../README for details.
+# No TABS, PLEASE!
+#
+
+path = . class types
+
diff --git a/schema/spacewalk/oracle/triggers/triggers.deps
b/schema/spacewalk/oracle/triggers/triggers.deps
index 12a2378..1010127 100644
--- a/schema/spacewalk/oracle/triggers/triggers.deps
+++ b/schema/spacewalk/oracle/triggers/triggers.deps
@@ -1,5 +1,16 @@
#
-# Dependencies for objects in the triggers directory
+# Copyright (c) 2008 Red Hat, Inc.
+#
+# This software is licensed to you under the GNU General Public License,
+# version 2 (GPLv2). There is NO WARRANTY for this software, express or
+# implied, including the implied warranties of MERCHANTABILITY or FITNESS
+# FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2
+# along with this software; if not, see
+#
http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt.
+#
+# Dependencies for trigger objects in this (namespace) directory.
+# See: ../../README for details.
+# No TABS, PLEASE!
#
path = tables procs packages
diff --git a/schema/spacewalk/oracle/types/types.deps
b/schema/spacewalk/oracle/types/types.deps
index fb30acd..228a613 100644
--- a/schema/spacewalk/oracle/types/types.deps
+++ b/schema/spacewalk/oracle/types/types.deps
@@ -1,5 +1,16 @@
#
-# Dependencies for objects in the types directory
+# Copyright (c) 2008 Red Hat, Inc.
+#
+# This software is licensed to you under the GNU General Public License,
+# version 2 (GPLv2). There is NO WARRANTY for this software, express or
+# implied, including the implied warranties of MERCHANTABILITY or FITNESS
+# FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2
+# along with this software; if not, see
+#
http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt.
+#
+# Dependencies for user defined types objects in this (namespace) directory.
+# See: ../../README for details.
+# No TABS, PLEASE!
#
path = .
diff --git a/schema/spacewalk/oracle/views/views.deps
b/schema/spacewalk/oracle/views/views.deps
index da48a15..047458c 100644
--- a/schema/spacewalk/oracle/views/views.deps
+++ b/schema/spacewalk/oracle/views/views.deps
@@ -1,5 +1,16 @@
#
-# Dependencies for the views directory
+# Copyright (c) 2008 Red Hat, Inc.
+#
+# This software is licensed to you under the GNU General Public License,
+# version 2 (GPLv2). There is NO WARRANTY for this software, express or
+# implied, including the implied warranties of MERCHANTABILITY or FITNESS
+# FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2
+# along with this software; if not, see
+#
http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt.
+#
+# Dependencies for view objects in this (namespace) directory.
+# See: ../../README for details.
+# No TABS, PLEASE!
#
path = . tables procs packages types
diff --git a/schema/spacewalk/postgres/class/class.deps
b/schema/spacewalk/postgres/class/class.deps
index 76d2c50..f9c55f6 100644
--- a/schema/spacewalk/postgres/class/class.deps
+++ b/schema/spacewalk/postgres/class/class.deps
@@ -1,5 +1,16 @@
#
-# Dependencies for objects in the class directory
+# Copyright (c) 2008 Red Hat, Inc.
+#
+# This software is licensed to you under the GNU General Public License,
+# version 2 (GPLv2). There is NO WARRANTY for this software, express or
+# implied, including the implied warranties of MERCHANTABILITY or FITNESS
+# FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2
+# along with this software; if not, see
+#
http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt.
+#
+# Dependencies for class objects in this (namespace) directory.
+# See: ../../README for details.
+# No TABS, PLEASE!
#
path = . packages
diff --git a/schema/spacewalk/postgres/data/data.deps
b/schema/spacewalk/postgres/data/data.deps
index a483ce7..85aea44 100644
--- a/schema/spacewalk/postgres/data/data.deps
+++ b/schema/spacewalk/postgres/data/data.deps
@@ -1,5 +1,16 @@
#
-# Dependencies for the data directory
+# Copyright (c) 2008 Red Hat, Inc.
+#
+# This software is licensed to you under the GNU General Public License,
+# version 2 (GPLv2). There is NO WARRANTY for this software, express or
+# implied, including the implied warranties of MERCHANTABILITY or FITNESS
+# FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2
+# along with this software; if not, see
+#
http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt.
+#
+# Dependencies for data (insert) objects in this (namespace) directory.
+# See: ../../README for details.
+# No TABS, PLEASE!
#
path = tables procs
diff --git a/schema/spacewalk/postgres/packages/packages.deps
b/schema/spacewalk/postgres/packages/packages.deps
index 5e7574c..ba053ea 100644
--- a/schema/spacewalk/postgres/packages/packages.deps
+++ b/schema/spacewalk/postgres/packages/packages.deps
@@ -1,5 +1,16 @@
#
-# Dependencies for the packages directory
+# Copyright (c) 2008 Red Hat, Inc.
+#
+# This software is licensed to you under the GNU General Public License,
+# version 2 (GPLv2). There is NO WARRANTY for this software, express or
+# implied, including the implied warranties of MERCHANTABILITY or FITNESS
+# FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2
+# along with this software; if not, see
+#
http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt.
+#
+# Dependencies for package objects in this (namespace) directory.
+# See: ../../README for details.
+# No TABS, PLEASE!
#
path = . tables views procs
diff --git a/schema/spacewalk/postgres/procs/procs.deps
b/schema/spacewalk/postgres/procs/procs.deps
index 2f169d0..3c5f4b3 100644
--- a/schema/spacewalk/postgres/procs/procs.deps
+++ b/schema/spacewalk/postgres/procs/procs.deps
@@ -1,5 +1,18 @@
#
-# Dependencies for objects in the procs directory
+# Copyright (c) 2008 Red Hat, Inc.
+#
+# This software is licensed to you under the GNU General Public License,
+# version 2 (GPLv2). There is NO WARRANTY for this software, express or
+# implied, including the implied warranties of MERCHANTABILITY or FITNESS
+# FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2
+# along with this software; if not, see
+#
http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt.
+#
+# Dependencies for stored procedure/function objects
+# in this (namespace) directory.
+#
+# See: ../../README for details.
+# No TABS, PLEASE!
#
path = . tables views packages class types
diff --git a/schema/spacewalk/postgres/tables/tables.deps
b/schema/spacewalk/postgres/tables/tables.deps
index 507bddc..e635a5d 100644
--- a/schema/spacewalk/postgres/tables/tables.deps
+++ b/schema/spacewalk/postgres/tables/tables.deps
@@ -1,4 +1,17 @@
#
-# Dependencies for (forked) objects in the tables directory
+# Copyright (c) 2008 Red Hat, Inc.
#
+# This software is licensed to you under the GNU General Public License,
+# version 2 (GPLv2). There is NO WARRANTY for this software, express or
+# implied, including the implied warranties of MERCHANTABILITY or FITNESS
+# FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2
+# along with this software; if not, see
+#
http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt.
+#
+# Dependencies for table objects in this (namespace) directory.
+# See: ../../README for details.
+# No TABS, PLEASE!
+#
+
+path = . class types
diff --git a/schema/spacewalk/postgres/triggers/triggers.deps
b/schema/spacewalk/postgres/triggers/triggers.deps
index 12a2378..1010127 100644
--- a/schema/spacewalk/postgres/triggers/triggers.deps
+++ b/schema/spacewalk/postgres/triggers/triggers.deps
@@ -1,5 +1,16 @@
#
-# Dependencies for objects in the triggers directory
+# Copyright (c) 2008 Red Hat, Inc.
+#
+# This software is licensed to you under the GNU General Public License,
+# version 2 (GPLv2). There is NO WARRANTY for this software, express or
+# implied, including the implied warranties of MERCHANTABILITY or FITNESS
+# FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2
+# along with this software; if not, see
+#
http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt.
+#
+# Dependencies for trigger objects in this (namespace) directory.
+# See: ../../README for details.
+# No TABS, PLEASE!
#
path = tables procs packages
diff --git a/schema/spacewalk/postgres/views/views.deps
b/schema/spacewalk/postgres/views/views.deps
index 85a3569..65a9ab6 100644
--- a/schema/spacewalk/postgres/views/views.deps
+++ b/schema/spacewalk/postgres/views/views.deps
@@ -1,5 +1,16 @@
#
-# Dependencies for the views directory
+# Copyright (c) 2008 Red Hat, Inc.
+#
+# This software is licensed to you under the GNU General Public License,
+# version 2 (GPLv2). There is NO WARRANTY for this software, express or
+# implied, including the implied warranties of MERCHANTABILITY or FITNESS
+# FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2
+# along with this software; if not, see
+#
http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt.
+#
+# Dependencies for view objects in this (namespace) directory.
+# See: ../../README for details.
+# No TABS, PLEASE!
#
path = . tables procs packages
diff --git a/schema/util/genmain.py b/schema/util/genmain.py
index 8cc8150..4482c95 100755
--- a/schema/util/genmain.py
+++ b/schema/util/genmain.py
@@ -13,6 +13,25 @@
# You should have received a copy of the GNU Lesser General Public License
# along with this program; if not, write to the Free Software
# Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
+#
+# The (.dep) file grammar is as follows:
+#
+# path : 'path' '=' nslist
+#
+# nslist : namespace
+# | nslist \s namespace
+# | nslist ',' namespace
+#
+# entry : qname '::' deplist
+#
+# qname : [namespace/]basename[.ext]
+#
+# deplist : dependency
+# | deplist \s dependency
+# | deplist ',' dependency
+#
+# dependency : qname
+#
import sys, os, re
from getopt import getopt, GetoptError
commit 596ac4e4652847612434331f90cceba926644e9a
Author: Jeff Ortel <jortel(a)redhat.com>
Date: Thu Apr 2 09:04:05 2009 -0400
Update Makefile header and comments
diff --git a/schema/spacewalk/header.txt b/schema/spacewalk/header.txt
index b680460..5995461 100644
--- a/schema/spacewalk/header.txt
+++ b/schema/spacewalk/header.txt
@@ -11,5 +11,6 @@
-- Red Hat trademarks are not licensed under GPLv2. No permission is
-- granted to use or replicate Red Hat trademarks that are incorporated
-- in this software or its documentation.
--- generated: DO NOT EDIT HERE!
+--
+-- Generated from ../common: DO NOT EDIT HERE!
--
diff --git a/schema/spacewalk/oracle/Makefile b/schema/spacewalk/oracle/Makefile
index 8dbde5f..517fb62 100644
--- a/schema/spacewalk/oracle/Makefile
+++ b/schema/spacewalk/oracle/Makefile
@@ -1,6 +1,42 @@
#
-# make
+# Copyright (c) 2008 Red Hat, Inc.
#
+# This software is licensed to you under the GNU General Public License,
+# version 2 (GPLv2). There is NO WARRANTY for this software, express or
+# implied, including the implied warranties of MERCHANTABILITY or FITNESS
+# FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2
+# along with this software; if not, see
+#
http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt.
+#
+# Red Hat trademarks are not licensed under GPLv2. No permission is
+# granted to use or replicate Red Hat trademarks that are incorporated
+# in this software or its documentation.
+#
+# Make used to build the oracle schema.
+#
+# Arguments:
+#
+# SQLUSER - The sqlplus connect information.
+# (default: spacewalk/spacewalk@xe).
+# TBS - The name of the tablespace to be used to replace the
+# [[ tbs ]] macros found in the DDL. It is intended that
+# this be specified only for development installs.
+# (default: users).
+#
+# It uses the following tools:
+#
+# dogchow - A common DDL -> oracle DDL generator installed via rpm
+# installed via (yum install dogchow) from fedora extras.
+# genmain.py - A tool used to process the .deps files to produce
+# the main.sql. It will inject the contents of a file
+# named "start.sql" at the beginning if it exits.
+#
+# The build steps are as follows:
+#
+# - Populate tables/common from ../common/tables using dogchow.
+# - Populate data/common from ../data/tables using dogchow.
+# - Populate views/common from ../views/tables
+# - Generate the main.sql using genmain.py.
#
ifndef TBS
diff --git a/schema/spacewalk/postgres/Makefile b/schema/spacewalk/postgres/Makefile
index 992b3da..510620d 100644
--- a/schema/spacewalk/postgres/Makefile
+++ b/schema/spacewalk/postgres/Makefile
@@ -1,6 +1,34 @@
#
-# make
+# Copyright (c) 2008 Red Hat, Inc.
#
+# This software is licensed to you under the GNU General Public License,
+# version 2 (GPLv2). There is NO WARRANTY for this software, express or
+# implied, including the implied warranties of MERCHANTABILITY or FITNESS
+# FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2
+# along with this software; if not, see
+#
http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt.
+#
+# Make used to build the postgres schema.
+#
+# Arguments:
+#
+# SQLUSER - The psql connect information.
+# (default: spacewalk).
+#
+# It uses the following tools:
+#
+# dogchow - A common DDL -> postgres DDL generator installed via rpm
+# installed via (yum install dogchow) from fedora extras.
+# genmain.py - A tool used to process the .deps files to produce
+# the main.sql. It will inject the contents of a file
+# named "start.sql" at the beginning if it exits.
+#
+# The build steps are as follows:
+#
+# - Populate tables/common from ../common/tables using dogchow.
+# - Populate data/common from ../data/tables using dogchow.
+# - Populate views/common from ../views/tables
+# - Generate the main.sql using genmain.py.
#
ifndef SQLUSER