[dbsrgits/SQL-Translator.git] / t / data / mysql / sqlfxml-producer-basic.sql

-- 
-- Created by SQL::Translator::Producer::MySQL
-- Created on Thu Aug  7 16:28:01 2003
-- 
-- SET foreign_key_checks=0;

--
-- Table: Basic
--
CREATE TABLE Basic (
    -- comment on id field
    id integer(10) NOT NULL auto_increment
   ,title varchar(100) NOT NULL DEFAULT 'hello'
   ,description text DEFAULT ''
   ,email varchar(255)
   ,INDEX  titleindex (title)
   ,PRIMARY KEY (id)
   ,UNIQUE (email)
);
Commit	Line	Data
d0c12b9f	1	--
	2	-- Created by SQL::Translator::Producer::MySQL
	3	-- Created on Thu Aug 7 16:28:01 2003
	4	--
	5	-- SET foreign_key_checks=0;
	6
	7	--
	8	-- Table: Basic
	9	--
	10	CREATE TABLE Basic (
3731665b	11	-- comment on id field
d0c12b9f	12	id integer(10) NOT NULL auto_increment
	13	,title varchar(100) NOT NULL DEFAULT 'hello'
	14	,description text DEFAULT ''
	15	,email varchar(255)
	16	,INDEX titleindex (title)
	17	,PRIMARY KEY (id)
	18	,UNIQUE (email)
	19	);
	20