mysql -e "drop database social_unit_test_square;"
mysql -e "create database social_unit_test_square;"
mysql social_unit_test_square < ph-db-structure.sql

set DIR=c:\\SocialNetworkingTestData\\square
mysqlimport social_unit_test_square --ignore-lines=1 "%dir%\\Publications.txt"
mysqlimport social_unit_test_square --ignore-lines=1 "%dir%\\PubTypeCategories.txt"
mysqlimport social_unit_test_square --ignore-lines=1 "%dir%\\StarColleagues.txt"
mysqlimport social_unit_test_square --ignore-lines=1 "%dir%\\PeoplePublications.txt"
mysqlimport social_unit_test_square --ignore-lines=1 "%dir%\\People.txt"
mysqlimport social_unit_test_square --ignore-lines=1 "%dir%\\PublicationAuthors.txt"
mysqlimport social_unit_test_square --ignore-lines=1 "%dir%\\ColleaguePublications.txt"
mysqlimport social_unit_test_square --ignore-lines=1 "%dir%\\Colleagues.txt"

mysqldump social_unit_test_square > social_unit_test_square.sql