Skip to content

Instantly share code, notes, and snippets.

@badsyntax
Created December 5, 2010 16:00
Show Gist options
  • Select an option

  • Save badsyntax/729187 to your computer and use it in GitHub Desktop.

Select an option

Save badsyntax/729187 to your computer and use it in GitHub Desktop.
Kohana 3 mysql config table schema
CREATE TABLE IF NOT EXISTS `config` (
`id` int(11) NOT NULL auto_increment,
`group_name` varchar(32) character set utf8 NOT NULL,
`config_key` varchar(32) character set utf8 NOT NULL,
`label` varchar(64) character set utf8 NOT NULL,
`config_value` text character set utf8,
`default` text character set utf8,
`rules` text character set utf8,
`field_type` varchar(255) character set utf8 NOT NULL default 'text',
`date` timestamp NOT NULL default CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
UNIQUE KEY `group` (`group_name`,`config_key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment