السلام عليكم
اريد انشاء جدولين في قاعدة بيانات MYSQL
جدول رئيسي master
وجدول فرعي له details
وبينها علاقة many to one relationship
الجدول الرئيسي انشأته بـ sql server وهذا الكود الخاص به :
USE [db1]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[table_main](
[file_type] [int] NOT NULL,
[file_no] [int] NOT NULL,
[file_date] [date] NULL,
[descr] [nvarchar](50) NULL,
CONSTRAINT [PK_table_main] PRIMARY KEY CLUSTERED
(
[file_type] ASC,
[file_no] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
الجدول الفرعي انشأته بـ sql server وهذا الكود الخاص به :
USE [db1]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[table_sub](
[file_type] [int] NOT NULL,
[file_no] [int] NOT NULL,
[file_srno] [int] IDENTITY(1,1) NOT NULL,
[descr] [nvarchar](100) NULL,
CONSTRAINT [PK_table_sub] PRIMARY KEY CLUSTERED
(
[file_type] ASC,
[file_no] ASC,
[file_srno] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[table_sub] WITH CHECK ADD CONSTRAINT [FK_table_sub_table_main] FOREIGN KEY([file_type], [file_no])
REFERENCES [dbo].[table_main] ([file_type], [file_no])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[table_sub] CHECK CONSTRAINT [FK_table_sub_table_main]
GO
فكيف انشاء اكود مثلهما تعمل في mysql