How to generate Scheduler tables in the MySQL database

joemz Megan

created 9 years ago

Can you convert it to Mysql Syntax. Thank you in advance.

Answers approved by DevExpress Support

DevExpress Support Team

created 9 years ago (modified 9 years ago)

Hello,
Here are scripts to create tables for appointments and resources in MySQL:

SQL
CREATE TABLE `appointments` (  
  `ID` int(11) NOT NULL AUTO_INCREMENT,  
  `Type` int(11) DEFAULT NULL,  
  `StartDate` datetime DEFAULT NULL,  
  `EndDate` datetime DEFAULT NULL,  
  `AllDay` tinyint(1) DEFAULT NULL,  
  `Subject` varchar(2000) DEFAULT NULL,  
  `Location` varchar(2000) DEFAULT NULL,  
  `Description` varchar(2000) DEFAULT NULL,  
  `Status` int(11) DEFAULT NULL,  
  `Label` int(11) DEFAULT NULL,  
  `ResourceId` int(11) DEFAULT NULL,  
  `ResourceIds` varchar(2000) DEFAULT NULL,  
  `ReminderInfo` varchar(2000) DEFAULT NULL,  
  `RecurrenceInfo` varchar(2000) DEFAULT NULL,  
  PRIMARY KEY (`ID`),  
  UNIQUE KEY `ID_UNIQUE` (`ID`)  
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

SQL
CREATE TABLE `resources` (  
  `ID` int(11) NOT NULL,  
  `Description` varchar(2000) DEFAULT NULL,  
  `Color` int(11) DEFAULT NULL,  
  PRIMARY KEY (`ID`),  
  UNIQUE KEY `ID_UNIQUE` (`ID`)  
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Should you have further questions, let me know.

Show previous comments (1)

John 5 years ago

Good day there.

I would like to implement the scheduler but with my existing mySQL database. i can see in the control create sample database the query for MS SQL.

SQL
CREATE TABLE [dbo].[Appointments] (
        [UniqueID] [int] IDENTITY (1, 1) NOT NULL,
        [Type] [int] NULL,
        [StartDate] [datetime] NULL,
        [EndDate] [datetime] NULL,
        [QueryStartDate] [datetime] NULL,
        [QueryEndDate] [datetime] NULL,
        [AllDay] [bit] NULL,
        [Subject] [nvarchar] (50) NULL,
        [Location] [nvarchar] (50) NULL,
        [Description] [nvarchar](max) NULL,
        [Status] [int] NULL,
        [Label] [int] NULL,
        [ResourceID] [int] NULL,
        [ResourceIDs] [nvarchar](max) NULL,
        [ReminderInfo] [nvarchar](max) NULL,
        [RecurrenceInfo] [nvarchar](max) NULL,
        [TimeZoneId] [nvarchar](max) NULL,
        [CustomField1] [nvarchar](max) NULL 
CONSTRAINT [PK_Appointments] PRIMARY KEY CLUSTERED
(
        [UniqueID] ASC
)
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

CREATE TABLE [dbo].[Resources] (
        [UniqueID] [int] IDENTITY (1, 1) NOT NULL,
        [ResourceID] [int] NOT NULL,
        [ResourceName] [nvarchar] (50) NULL,
        [Color] [int] NULL,
        [Image] [image] NULL,
        [CustomField1] [nvarchar](max) NULL 
CONSTRAINT [PK_Resources] PRIMARY KEY CLUSTERED
(
        [UniqueID] ASC
)
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET IDENTITY_INSERT [dbo].[Resources] ON
INSERT [dbo].[Resources] ([UniqueID], [ResourceID], [ResourceName], [Color], [Image], [CustomField1]) VALUES (1, 1, N'Resource One', NULL, NULL, NULL)
INSERT [dbo].[Resources] ([UniqueID], [ResourceID], [ResourceName], [Color], [Image], [CustomField1]) VALUES (2, 2, N'Resource Two', NULL, NULL, NULL)
INSERT [dbo].[Resources] ([UniqueID], [ResourceID], [ResourceName], [Color], [Image], [CustomField1]) VALUES (3, 3, N'Resource Three', NULL, NULL, NULL)
SET IDENTITY_INSERT [dbo].[Resources] OFF

Can someone provide the MySQL equivalent queries to create the DB?
and a simple guide to connect it with XPO ?

Now when i try to point scheduler control to datasource of XPO object with appointments table i got a object reference error.

Thanks.

Sasha (DevExpress Support) 5 years ago

Hello John,

I see that you created the How to generate Scheduler tables in MySQL database C# thread with your question. We will address it as soon as possible.

呉

呉 4 years ago

i want to use mysql database too. a simple guide to create mysql db and connect it. Can someone share it?

Sasha (DevExpress Support) 4 years ago

Hi,

To avoid mixing multiple questions in one thread, I've created a separate ticket on your behalf: How to create a MySQL database and connect to it. I will address it shortly.

Created: June 8, 2016 4:12 PM

Modified: April 2, 2021 8:35 AM

Platform: WinForms

Product: XtraScheduler Suite

Build: 15.2.10

IDE: Microsoft Visual Studio 2013

Disclaimer: The information provided on DevExpress.com and affiliated web properties (including the DevExpress Support Center) is provided "as is" without warranty of any kind. Developer Express Inc disclaims all warranties, either express or implied, including the warranties of merchantability and fitness for a particular purpose. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.

Confidential Information: Developer Express Inc does not wish to receive, will not act to procure, nor will it solicit, confidential or proprietary materials and information from you through the DevExpress Support Center or its web properties. Any and all materials or information divulged during chats, email communications, online discussions, Support Center tickets, or made available to Developer Express Inc in any manner will be deemed NOT to be confidential by Developer Express Inc. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.

How to generate Scheduler tables in the MySQL database

Answers approved by DevExpress Support

Recently viewed tickets