Changeset 23865 for trunk/ippTools/share

Timestamp:

Apr 14, 2009, 3:57:28 PM (17 years ago)

Author:

Paul Price

Message:

Fixing generation of mirror table creation SQL.

Location:

trunk/ippTools/share

Files:

• . (modified) (1 prop)
• Makefile.am (modified) (1 diff)

trunk/ippTools/share

@@ -1 +1 @@
 Makefile.in
 Makefile
+pxadmin_create_mirror_tables.sql

@@ -1 +1 @@
 Makefile.in
 Makefile
+pxadmin_create_mirror_tables.sql

trunk/ippTools/share/Makefile.am

@@ -1 +1 @@
 pxadmin_create_mirror_tables.sql: pxadmin_create_tables.sql
         -$(RM) pxadmin_create_mirror_tables.sql
-        $(SED) -n -e '/^  *$$/ d' -e '/./ H' -e '/;/ { x ; s/AUTO_INCREMENT//g ; s/\n//g ; s/,\{0,1\} *FOREIGN *KEY *(.*) *REFERENCES *[a-zA-Z]\{1,\}(.*)//g ; s/( */(/g ; s/ *)/)/g ; s/  */ /g ; p ; s/.*//g ; x }' pxadmin_create_tables.sql > pxadmin_create_mirror_tables.sql
+        $(SED) -n -e '/^  *$$/ d' -e 's/--.*//' -e '/./ H' -e '/;/ { x ; s/AUTO_INCREMENT//g ; s/\n//g ; s/,\{0,1\} *FOREIGN *KEY *([a-zA-Z][a-zA-Z0-9\-_, ]*) *REFERENCES *[a-zA-Z]\{1,\}([a-zA-Z][a-zA-Z0-9\-_, ]*)//g ; s/( */(/g ; s/ *)/)/g ; s/  */ /g ; p ; s/.*//g ; x }' pxadmin_create_tables.sql > pxadmin_create_mirror_tables.sql
+        echo '-- This comment line is here to avoid empty query error.' >> pxadmin_create_mirror_tables.sql
 
 dist_pkgdata_DATA = \

@@ -1 +1 @@
 Makefile.in
 Makefile
+pxadmin_create_mirror_tables.sql