CREATE TABLE IF NOT EXISTS `myproject_config` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(30) NOT NULL,
`string` varchar(50) NOT NULL,
`flag` bigint(20) NOT NULL DEFAULT '0' COMMENT 'byte / numeric ..flag',
`origin` varchar(80) NOT NULL COMMENT 'origin of last modification at time in time',
`time` int(11) NOT NULL DEFAULT '0',
`info` varchar(80) NOT NULL,
`text` text NOT NULL,
`update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='configuration ram replacement' AUTO_INCREMENT=7 ;
INSERT INTO `myproject_config` (`id`, `name`, `string`, `flag`, `origin`, `time`, `info`, `text`, `update`) VALUES
(1, 'masterswitch', '', 1, '', 0, '1:enable 0:disable site', '', '2014-02-24 12:22:04'),
(2, 'aa', '', 0, '', 0, '', '', '2014-02-25 11:37:10'),
(3, '', '', 1, '', 0, '', '', '2014-02-25 11:40:14'),
(4, 'xxxx', '', 0, '', 0, '', '', '2014-02-25 11:41:23'),
(5, 'whatever', '', 1, '', 0, '', '', '2014-02-25 11:43:32'),
(6, 'whatever2', '', 2, '', 0, '', '', '2014-02-25 11:43:32');
|
Download
