Please some one help in coverting this query from MS Sql to MySql
CREATE TABLE [T_DOCUMENT] (
[DOCUMENT_ID] [int] IDENTITY (1, 1) NOT NULL ,
[PROJECT_ID] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[BEGIN_ATTACH] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[END_ATTACH] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[IS_LOCKED] [bit] NOT NULL CONSTRAINT [DF_T_DOCUMENT_IS_LOCKED] DEFAULT (0),
[IS_CHECKED] [bit] NOT NULL CONSTRAINT [DF_T_DOCUMENT_IS_CHECKED] DEFAULT (0),
[IS_REWORKED] [bit] NOT NULL CONSTRAINT [DF_T_DOCUMENT_IS_REWORKED] DEFAULT (0),
[QC_ID] [int] NULL ,
[REWORKER_ID] [int] NULL ,
[NOTES] [varchar] (5000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[LOCKED_TIME] [datetime] NULL ,
[CDID] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[CurrentNode] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[LOCKED_BY] [int] NULL ,
[StartDate] [datetime] NULL ,
[QCPass_Stage] [int] NULL ,
CONSTRAINT [td_pk] PRIMARY KEY CLUSTERED
(
[DOCUMENT_ID],
[PROJECT_ID]
) ON [PRIMARY] ,
CONSTRAINT [td_fk_projid] FOREIGN KEY
(
[PROJECT_ID]
) REFERENCES [T_PROJECT] (
[PROJECT_ID]
) ON DELETE CASCADE
) ON [PRIMARY]
GO