File: mysql2sqlite.sh

package info (click to toggle)
libpreludedb 5.2.0-2.2
  • links: PTS, VCS
  • area: main
  • in suites: sid
  • size: 9,232 kB
  • sloc: ansic: 29,652; cpp: 16,567; sh: 12,736; sql: 1,436; python: 449; makefile: 291; yacc: 227; lex: 106; xml: 36
file content (12 lines) | stat: -rwxr-xr-x 277 bytes parent folder | download | duplicates (4) 
1
2
3
4
5
6
7
8
9
10
11
12
 
#!/bin/sh
sed \
	-e 's/#.*//' \
	-e '/^DROP /d' \
    	-e 's/[a-zA-Z]*INT /INTEGER /' \
	-e 's/UNSIGNED //' \
	-e 's/ENUM([^)]\{1,\})/TEXT/' \
	-e 's/VARCHAR([^)]\{1,\})/TEXT/' \
	-e 's/AUTO_INCREMENT/AUTOINCREMENT/' \
	-e 's/ENGINE=InnoDB//' \
	-e 's/([0-9]\{1,\})//g' \
	$1