Skip to content

Instantly share code, notes, and snippets.

@w0rldart
Last active December 15, 2015 02:59
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save w0rldart/5191274 to your computer and use it in GitHub Desktop.
Save w0rldart/5191274 to your computer and use it in GitHub Desktop.
logs database for my apps
--
-- Database: `logs`
--
DROP DATABASE `logs`;
CREATE DATABASE `logs` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
USE `logs`;
-- --------------------------------------------------------
--
-- Table structure for table `lrapi`
--
-- Creation: Mar 05, 2013 at 10:33 PM
--
CREATE TABLE IF NOT EXISTS `lrapi` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`url` varchar(255) CHARACTER SET latin1 NOT NULL,
`input` text CHARACTER SET latin1,
`headers` text CHARACTER SET latin1 NOT NULL,
`ip` varchar(15) CHARACTER SET latin1 NOT NULL,
`extra` text CHARACTER SET latin1,
`created_at` date NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='http://github.com/w0rldart/lRapi/';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment