Changeset 23862

Timestamp:

Apr 14, 2009, 3:25:41 PM (17 years ago)

Author:

Paul Price

Message:

Generate SQL for mirror tables from parsing SQL for regular tables.

Location:

trunk/ippTools/share

Files:

• Makefile.am (modified) (1 diff)
• pxadmin_create_mirror_tables.sql (deleted)

trunk/ippTools/share/Makefile.am

@@ +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
+
 dist_pkgdata_DATA = \
      camtool_donecleanup.sql \