CGIScripter
Features and Benefits
CGIScripter
Demo Available for download...
Bookmark
This Page
# 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
