• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
how to create ci_sessions table in ms sql server same

#3
[eluser]C.T.[/eluser]
Try this in M$ SMS, hope it help

Code:
USE CI_Database
GO

/*
20120309
CodeIgniter Session Database
Author Cusco
*/

CREATE TABLE CI_Sessions (
session_id NVARCHAR(40) DEFAULT '0' NOT NULL,
ip_address NVARCHAR(16) DEFAULT '0' NOT NULL,
user_agent NVARCHAR(120) NOT NULL,
last_activity INT DEFAULT 0 NOT NULL,
user_data NTEXT NOT NULL,
CONSTRAINT  PK_CI_Session PRIMARY KEY (session_id ASC)
)
GO

CREATE NONCLUSTERED INDEX NCI_Session_Activity
ON CI_Sessions(last_activity DESC)
GO


P.S. I think M$SQL dont have "unsigned" datatype correct me if I am wrong


Messages In This Thread
how to create ci_sessions table in ms sql server same - by El Forum - 03-05-2012, 12:38 AM
how to create ci_sessions table in ms sql server same - by El Forum - 03-05-2012, 12:59 AM
how to create ci_sessions table in ms sql server same - by El Forum - 04-16-2012, 02:45 PM

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2021 MyBB Group.