ICreate
(creative content management tools)
Download
The latest version available at source forge
https://sourceforge.net/projects/solutionsicreat/
Installations
Install SQL Server express
Down from: http://www.microsoft.com/express/database/
Create icreate database
Execute the following install script using icreate databas
----------------------------------------------------------
CREATE TABLE [dbo].[Contents](
[Id] [int] IDENTITY(1,1) NOT NULL,
[Name] [varchar](100) NOT NULL,
[Author] [varchar](50) NULL,
[Path] [varchar](500) NULL,
[FileType] [varchar](40) NULL,
[ByteSize] [int] NULL,
[CreateDate] [datetime] NOT NULL,
[UpdateDate] [datetime] NOT NULL,
CONSTRAINT [PK_Contents] PRIMARY KEY CLUSTERED
(
[Id] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
USE [icreate]
GO
/****** Object: Table [dbo].[Roles] Script Date: 10/19/2010 11:55:23 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Roles](
[RoleName] [nvarchar](50) NOT NULL,
[Note] [nvarchar](50) NULL,
CONSTRAINT [PK_Roles] PRIMARY KEY CLUSTERED
(
[RoleName] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Roles] WITH CHECK ADD CONSTRAINT [FK_Roles_Roles] FOREIGN KEY([RoleName])
REFERENCES [dbo].[Roles] ([RoleName])
GO
ALTER TABLE [dbo].[Roles] CHECK CONSTRAINT [FK_Roles_Roles]
GO
USE [icreate]
GO
/****** Object: Table [dbo].[Permissions] Script Date: 10/19/2010 11:55:31 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Permissions](
[Name] [nvarchar](50) NOT NULL,
[Note] [nvarchar](50) NULL,
[RoleName] [nvarchar](50) NOT NULL,
CONSTRAINT [PK_Permissions] PRIMARY KEY CLUSTERED
(
[Name] ASC,
[RoleName] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Permissions] WITH CHECK ADD CONSTRAINT [FK_Permissions_Roles1] FOREIGN KEY([RoleName])
REFERENCES [dbo].[Roles] ([RoleName])
GO
ALTER TABLE [dbo].[Permissions] CHECK CONSTRAINT [FK_Permissions_Roles1]
GO
USE [icreate]
GO
/****** Object: Table [dbo].[Users] Script Date: 10/19/2010 11:55:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Users](
[UserID] [int] IDENTITY(1,1) NOT NULL,
[FirstName] [varchar](50) NOT NULL,
[LastName] [varchar](50) NOT NULL,
[UserName] [varchar](50) NOT NULL,
[Password] [varchar](50) NULL,
[Email] [varchar](100) NOT NULL,
[LastLoggedIn] [datetime] NULL,
[AccessLevel] [varchar](50) NULL,
[DateJoined] [datetime] NULL,
[AccountStatus] [varchar](50) NULL,
[Deleted] [bit] NOT NULL,
[Phone] [varchar](50) NOT NULL,
[Address] [varchar](50) NULL,
CONSTRAINT [PK_Users] PRIMARY KEY CLUSTERED
(
[UserID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
USE [icreate]
GO
/****** Object: Table [dbo].[UserRoles] Script Date: 10/19/2010 11:56:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserRoles](
[UserName] [nvarchar](50) NOT NULL,
[RoleName] [nvarchar](50) NOT NULL,
CONSTRAINT [PK_UserRoles] PRIMARY KEY CLUSTERED
(
[UserName] ASC,
[RoleName] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
DB Security User Setup
Create user icreate
Assign icreate as db_owner role in icreate database
Log out of the admin user
Login is an icreate user
/**
Insert roles and permission
*/
INSERT INTO Roles(RoleName ,Note) VALUES ('Admin','Administration role');
INSERT INTO Roles(RoleName ,Note) VALUES ('default','Default user role');
INSERT INTO Permissions ([Name] ,[Note],[RoleName]) VALUES('ALL','Super all permission','Admin');
INSERT INTO Permissions ([Name] ,[Note],[RoleName]) VALUES('basic','Default permission','Admin');
/** ------------------------------------- **/
/* Insert user information */
INSERT INTO [icreate].[dbo].[Users]
([FirstName]
,[LastName]
,[UserName]
,[Password]
,[Email]
,[LastLoggedIn]
,[AccessLevel]
,[DateJoined]
,[AccountStatus]
,[Deleted]
,[Phone]
,[Address])
VALUES
('FirstName'
,'LastName'
,'DOMAIN\NT-User-NAME
,NULL
,'Email'
,null
,null
,null
,null
,0
,'Phone'
,'Address');
INSERT INTO [icreate].[dbo].[UserRoles]
([UserName]
,[RoleName])
VALUES
('DOMAIN\NT-User-NAME
,'Admin')
GO
------------------------------------------------------
Create Temp Directory
Create directory C:\Projects\solutions\runtime\temp\icreate
Installation Web Application
Create directory C:\Projects\solutions\API.net\Solutions.iCreate
Unzip to C:\Projects\solutions\API.net\Solutions.iCreate
Solutions.iCreate.Web.zip
Open IIS manager ( admin console)
Navigate to
Right click Default Web Site
New -> Virtual Directory
alias = icreate
path =C:\Projects\solutions\API.net\Solutions.iCreate\Solutions.iCreate.Web
Check Run scripts (such as ASP)
Click Finish
Edit
C:\Projects\solutions\API.NET\Solutions.iCreate\Solutions.iCreate.Web\web.xml
Update (appSettings)
- dao.connection.str (connection URL)
-fileRoot (directory where output publish
-publishRoot (output web URL)
Access URL
http://localhost
Enter NT user/password
Create iCreate Web Application (IIS example)
Create Directory
C:\msccc\msccc\www\content\DOMAIN\user
Edit C:\Projects\solutions\API.net\Solutions.iCreate\Solutions.iCreate.Web\web.xml appSettings
Path: Solutions.iCreate.Services.mgr.FolderPublisher.publishPath
Open C:\Projects\solutions\API.net\Solutions.iCreate\Solutions.iCreate.Web\castle.xml
Remove
PublishPath -> C:\Projects\solutions\API.net\Solutions.iCreate\www\content
XML Node
Create Directory C:\Projects\solutions\runtime\temp\icreate
Click Create New Page in icreate
default.aspx
Type content
Coming Soon
Click Save
Click Publish
Open IIS Manager
Righ Click "Default Web Site"
New -> Virtual Directory
alias:msccc
C:\msccc\msccc\www\content\DOMAIN\user
* This must match root folder
Check Run scripts
Click Finish\