File indexing completed on 2025-01-19 05:21:24
0001 -- phpMyAdmin SQL Dump 0002 -- version 2.11.6 0003 -- http://www.phpmyadmin.net 0004 -- 0005 -- Host: localhost:3306 0006 -- Generation Time: Jun 19, 2008 at 08:09 PM 0007 -- Server version: 5.0.51 0008 -- PHP Version: 5.2.3 0009 0010 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; 0011 0012 /* 0013 Sample grant for MySQL 0014 0015 GRANT DELETE, INSERT, SELECT, UPDATE ON queue.* TO 'queue'@'127.0.0.1' IDENTIFIED BY '[CHANGE ME]'; 0016 mysql -u queue -h 127.0.0.1 -p queue 0017 0018 mysqlaccess queue queue --superuser=root -H 127.0.0.1 0019 0020 0021 */ 0022 0023 0024 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; 0025 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; 0026 /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; 0027 /*!40101 SET NAMES utf8 */; 0028 0029 -- 0030 -- Database: `queue` 0031 -- 0032 0033 -- -------------------------------------------------------- 0034 0035 -- 0036 -- Table structure for table `message` 0037 -- 0038 0039 DROP TABLE IF EXISTS `message`; 0040 CREATE TABLE IF NOT EXISTS `message` ( 0041 `message_id` bigint(20) unsigned NOT NULL auto_increment, 0042 `queue_id` int(10) unsigned NOT NULL, 0043 `handle` char(32) default NULL, 0044 `body` varchar(8192) NOT NULL, 0045 `md5` char(32) NOT NULL, 0046 `timeout` decimal(14,4) unsigned default NULL, 0047 `created` int(10) unsigned NOT NULL, 0048 PRIMARY KEY (`message_id`), 0049 UNIQUE KEY `message_handle` (`handle`), 0050 KEY `message_queueid` (`queue_id`) 0051 ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 0052 0053 -- -------------------------------------------------------- 0054 0055 -- 0056 -- Table structure for table `queue` 0057 -- 0058 0059 DROP TABLE IF EXISTS `queue`; 0060 CREATE TABLE IF NOT EXISTS `queue` ( 0061 `queue_id` int(10) unsigned NOT NULL auto_increment, 0062 `queue_name` varchar(100) NOT NULL, 0063 `timeout` smallint(5) unsigned NOT NULL default '30', 0064 PRIMARY KEY (`queue_id`) 0065 ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 0066 0067 -- 0068 -- Constraints for dumped tables 0069 -- 0070 0071 -- 0072 -- Constraints for table `message` 0073 -- 0074 ALTER TABLE `message` 0075 ADD CONSTRAINT `message_ibfk_1` FOREIGN KEY (`queue_id`) REFERENCES `queue` (`queue_id`) ON DELETE CASCADE ON UPDATE CASCADE;