Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

Diff of /generate/bin/template-mysql-filter.py [b947d4] .. [19e22f] Maximize Restore

  Switch to side-by-side view

--- a/generate/bin/template-mysql-filter.py
+++ b/generate/bin/template-mysql-filter.py
@@ -82,7 +82,7 @@
 	if re.match("^.*=CREATE TABLE.*$", line):
 		line=replace(t1,t2,line)
 		
-	if re.search(r'VnSelRestrs',line) or re.search(r'VnSemantics',line):
+	if re.search(r'^VnSelRestrs',line) or re.search(r'VnSemantics',line):
 		line=replace(r'unq_',r'k_',line)
 		line=replace(r'unq',r'index',line)
 		line=replace(r'ADD CONSTRAINT (.*) UNIQUE KEY \(([^\s]*)\)',r'ADD INDEX \1 (\2)',line)
@@ -90,10 +90,14 @@
 			line=replace(r'\(semantics\)',r'(semantics (330))',line)
 			line=replace(r'\(selrestrs\)',r'(selrestrs (330))',line)
 
-	if re.search(r'VnSyntax',line):
+	if re.search(r'^VnSyntax',line):
 		line=replace(r'UNIQUE KEY \(([^\s]*)\)',r'UNIQUE KEY (\1 (330))',line)
+		
+	if re.search(r'^SUMOFormula',line):
+		if re.search(r'\.index',line):
+			line=replace(r'\(formula\)',r'(formula (128))',line)
 
-	if re.search(r'XWnWsd',line) or re.search(r'XWnParseLft',line):
+	if re.search(r'^XWnWsd',line) or re.search(r'XWnParseLft',line):
 		line=replace(r'index',r'index2',line)
 		line=replace(r'unq_',r'k_',line)
 		line=replace(r'unq',r'index1',line)
@@ -104,9 +108,10 @@
 			line=replace(r',parse',r',parse (100)',line)
 			line=replace(r',lft',r',lft (100)',line)
 
-	if re.search(r'GLFlf',line) or re.search(r'ILFWNlf',line):
+	if re.search(r'^GLFlf',line) or re.search(r'ILFWNlf',line):
 		if re.search(r'\.unq',line):
 			line=replace(r',lf',r',lf (128)',line)
+			line=replace(r',prettylf',r',prettylf (128)',line)
 
 	line=replace(rw11,rw21,line)
 	line=replace(rw12,rw22,line)