Changeset 23891 for trunk/ippTools/share/Makefile.am

Timestamp:

Apr 16, 2009, 4:26:15 PM (17 years ago)

Author:

Paul Price

Message:

Don't remove AUTO_INCREMENT and FOREIGN KEY for the receive tables.

File:

• trunk/ippTools/share/Makefile.am (modified) (1 diff)

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 '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
+        $(SED) -n -e '/^  *$$/ d' -e 's/--.*//' -e '/./ H' -e '/;/ !b' -e 'x ; s/\n//g ; /^CREATE TABLE receive/ { b print }' -e 's/AUTO_INCREMENT//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' -e ': print' -e '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