.com Solutions Inc. - logo  
Products - Header Buttons
.
Repgen bullet item 7b Installgen bullet item 7b FmPro Migratorbullet item 7b CGIScripter
.
.
.

.
.

FmPro Migrator - MySQL Files - Title Graphic

FmPro Migrator Features and Benefits

FmPro Migrator Demo Available for download...

Bookmark This Page

email a friend

.

# Script: contact_management_create_table1.sql
# Features: This sql script creates the MySQL
# table for the FileMaker data.
#
# Notes:
# This file only needs run if
# the table does not already exist
# in the destination database.
# The DBA should modify the table creation
# commands as needed before running this file.

#
# Usage: mysql test -u user1 < contact_management_create_table1.sql
#
# Used By: run manually by the MySQL DBA on the database server
# Copyright 2003 by .com Solutions Inc.
#
# ---------------------- Revision History ---------------
# Date By Changes
# 3-29-2003 dsimpson Initial Release
#
# This output file was created by FmPro Migrator version 1.23 on Thu Apr 3 12:19:39 2003. By .com Solutions Inc. www.dotcomsolutionsinc.net
#
# specify database name
use test

# drop table command - commented out
# DROP TABLE IF EXISTS test.contact_management;

# create MySQL table to match structure of FileMaker file
CREATE TABLE IF NOT EXISTS test.contact_management
(
last_name VARCHAR(255) NULL,
first_name VARCHAR(255) NULL,
company VARCHAR(255) NULL,
title VARCHAR(255) NULL,
street_1 VARCHAR(255) NULL,
city_1 VARCHAR(255) NULL,
state_province_1 VARCHAR(255) NULL,
postal_code_1 VARCHAR(255) NULL,
notes VARCHAR(255) NULL,
phone_1 VARCHAR(255) NULL,
date_created DATE NULL,
date_modified DATE NULL,
identification_number VARCHAR(255) NULL,
image_data LONGBLOB NULL,
template_information_global VARCHAR(255) NULL,
created_by VARCHAR(255) NULL,
last_layout DOUBLE NULL,
email VARCHAR(255) NULL,
phone_2 VARCHAR(255) NULL,
current_date_ DATE NULL,
similar_by VARCHAR(255) NULL,
similars_key VARCHAR(255) NULL,
similars_multikey VARCHAR(255) NULL,
similars_count DOUBLE NULL,
similars_tab_label VARCHAR(255) NULL,
similar_name_key VARCHAR(255) NULL,
similar_company_key VARCHAR(255) NULL,
street_2 VARCHAR(255) NULL,
city_2 VARCHAR(255) NULL,
state_province_2 VARCHAR(255) NULL,
postal_code_2 VARCHAR(255) NULL,
address_type_1 VARCHAR(255) NULL,
address_type_2 VARCHAR(255) NULL,
scratch VARCHAR(255) NULL,
thumbnail LONGBLOB NULL,
contact_id DOUBLE NULL,
most_recent_form_layout DOUBLE NULL,
letter_body_text VARCHAR(255) NULL,
email_address_with_name VARCHAR(255) NULL,
thumbnail_display LONGBLOB NULL

) TYPE=MyISAM;

quit


.

hline

. .

.

. .
 

Home | Products | Services | Downloads | Order | Support | Contact

Legal Notices

.
.   .
.
Home Products Services Downloads Order Support Contact