• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Oracle Capitalization Problem and the Session Library

#3
[eluser]Unknown[/eluser]
[quote author="jenci" date="1253110427"]Try this table:
CREATE TABLE "ci_sessions"
(
"session_id" VARCHAR2(40 BYTE) DEFAULT 0 NOT NULL,
"ip_address" VARCHAR2(16 BYTE) DEFAULT 0 NOT NULL,
"user_agent" VARCHAR2(50 BYTE) NOT NULL,
"last_activity" NUMBER ,
"user_data" VARCHAR2(3000 BYTE)
);

CREATE UNIQUE INDEX PK_SESSION_ID ON "ci_sessions" ("session_id");
ALTER TABLE "ci_sessions" ADD (CONSTRAINT PK_SESSION_ID PRIMARY KEY ("session_id"));[/quote]

Thank you!now i can proceed to finish my project...appreciate that.


Messages In This Thread
Oracle Capitalization Problem and the Session Library - by El Forum - 08-09-2009, 12:34 PM
Oracle Capitalization Problem and the Session Library - by El Forum - 09-16-2009, 07:13 AM
Oracle Capitalization Problem and the Session Library - by El Forum - 09-23-2012, 04:26 PM

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


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