Skip to content

Instantly share code, notes, and snippets.

@rogersguedes

rogersguedes/codeigniteSessionTableDDL.sql

Created October 5, 2016 12:46
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save rogersguedes/c3f5b9e6e8c04156afe7e296a26f3e10 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save rogersguedes/c3f5b9e6e8c04156afe7e296a26f3e10 to your computer and use it in GitHub Desktop.
Download ZIP
SQL Table Creation script to create session table for Codeigniter 3 MySQL session driver.
Raw
codeigniteSessionTableDDL.sql
CREATE TABLE `sessions` (
`id` varchar(40) NOT NULL,
`ip_address` varchar(45) NOT NULL,
`timestamp` int(10) unsigned NOT NULL DEFAULT '0',
`data` blob NOT NULL,
PRIMARY KEY (`id`),
KEY `sessions_timestamp` (`timestamp`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment