.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

CGIScripter Features and Benefits

CGIScripter Demo Available for download...

Bookmark This Page

email a friend

.

# Script: example_create_table1.sql
# Features: This sql script creates the MySQL
# database table.
#
# 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 mysql1 -u mysqluser1 < example_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
# 6-8-2003 dsimpson Removed database name from create
# table statement to account for situations
# where MySQL dbname contains a ".".
#
# This output file was created by CGIScripter version 1.48 on Wed Aug 20 10:42:22 2003. By .com Solutions Inc. www.dotcomsolutionsinc.net
#
# specify database name
use mysql1

# drop table command - commented out
# DROP TABLE IF EXISTS example;

# create MySQL table to match structure of FileMaker file
CREATE TABLE IF NOT EXISTS example
(
item VARCHAR(255) NULL,
category VARCHAR(255) NULL,
picture LONGBLOB NULL,
model VARCHAR(255) NULL,
serial_number VARCHAR(255) NULL,
information TEXT NULL,
date_purchased DATE NULL,
depreciation DOUBLE NULL,
assigned_display DOUBLE NULL,
depreciation_life DOUBLE NULL,
remaining_life DOUBLE NULL,
cost DOUBLE NULL,
book_value DOUBLE NULL

) TYPE=MyISAM;

quit


.

hline

. .

.

. .
 

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

Legal Notices

.
.   .
.
Home Products Services Downloads Order Support Contact