Just to add on to this, here is an example intended to be indexed on a tag path.
MySQL
CREATE TABLE IF NOT EXISTS `notes` (
`ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
`UserName` varchar(45) NOT NULL,
`TimeStamp` datetime NOT NULL,
`NoteText` text NOT NULL,
`TagName` varchar(45) NOT NULL,
`IsSticky` tinyint(3) unsigned NOT NULL,
`Attachment` longblob DEFAULT NULL,
`AttachmentName` varchar(45) DEFAULT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=22 ;
MS SQL (assumes the database is called sqltags)
USE [sqltags]
GO
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[notes]') AND type in (N'U'))
DROP TABLE [dbo].[notes]
GO
USE [sqltags]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[notes](
[ID] [int] IDENTITY(1,1) NOT NULL,
[UserName] [nvarchar](50) NOT NULL,
[TimeStamp] [datetime] NOT NULL,
[NoteText] [ntext] NOT NULL,
[TagName] [nvarchar](255) NOT NULL,
[IsSticky] [int] NOT NULL,
[Attachment] [varbinary](max) NULL,
[AttachmentName] [nvarchar](50) NULL,
CONSTRAINT [PK_notes] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
Alarm Notes.vwin (10.3 KB)