-- MySQL dump 10.10 -- -- Host: localhost Database: t_crash -- ------------------------------------------------------ -- Server version 5.0.30-Debian_2-log /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Current Database: `t_crash` -- CREATE DATABASE /*!32312 IF NOT EXISTS*/ `t_crash` /*!40100 DEFAULT CHARACTER SET latin1 */; USE `t_crash`; -- -- Table structure for table `m` -- DROP TABLE IF EXISTS `m`; CREATE TABLE `m` ( `id` int(11) NOT NULL auto_increment, `name` varchar(100) NOT NULL default '', `type` varchar(100) NOT NULL default 'plugin', `row` int(11) NOT NULL default '0', `ordering` int(11) NOT NULL default '0', `published` tinyint(3) NOT NULL default '0', `checked_out` int(11) unsigned NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=54 DEFAULT CHARSET=utf8; -- -- Dumping data for table `m` -- LOCK TABLES `m` WRITE; /*!40000 ALTER TABLE `m` DISABLE KEYS */; INSERT INTO `m` VALUES (1,'Context Menu','plugin',0,0,0,0),(2,'Directionality','plugin',3,8,1,0),(3,'Emotions','plugin',4,12,1,0),(4,'Fullscreen','plugin',4,6,1,0),(5,'Paste','plugin',1,16,1,0),(6,'Preview','plugin',4,1,1,0),(7,'Tables','plugin',2,8,1,0),(8,'Print','plugin',4,3,1,0),(9,'Search Replace','plugin',1,17,1,0),(10,'Styles','plugin',4,7,1,0),(11,'Non-Breaking','plugin',4,8,1,0),(12,'Visual Characters','plugin',4,9,1,0),(13,'XHTML Xtras','plugin',4,10,1,0),(14,'Layers','plugin',4,11,1,0),(15,'XHTML Attributes','plugin',4,12,1,0),(16,'Image Manager','plugin',4,13,1,0),(17,'Advanced Link','plugin',4,14,1,0),(18,'Font ForeColour','command',3,4,1,0),(19,'Bold','command',1,5,1,0),(20,'Italic','command',1,6,1,0),(21,'Underline','command',1,7,1,0),(22,'Font BackColour','command',3,5,1,0),(23,'Unlink','command',2,11,1,0),(24,'Font Select','command',3,2,1,0),(25,'Font Size Select','command',3,3,1,0),(26,'Style Select','command',3,1,1,0),(27,'New Document','command',1,4,1,0),(28,'Help','command',1,3,1,0),(29,'StrikeThrough','command',1,12,1,0),(30,'Indent','command',1,11,1,0),(31,'Outdent','command',1,10,1,0),(32,'Undo','command',1,1,1,0),(33,'Redo','command',1,2,1,0),(34,'Horizontal Rule','command',2,1,1,0),(35,'HTML','command',1,13,1,0),(36,'Numbered List','command',1,9,1,0),(37,'Bullet List','command',1,8,1,0),(38,'Clipboard Actions','command',1,16,1,0),(39,'Subscript','command',2,2,1,0),(40,'Superscript','command',2,3,1,0),(41,'Visual Aid','command',3,7,1,0),(42,'Character Map','command',3,6,1,0),(43,'Justify Full','command',2,7,1,0),(44,'Justify Center','command',2,5,1,0),(45,'Justify Left','command',2,6,1,0),(46,'Justify Right','command',2,4,1,0),(47,'Remove Format','command',1,15,1,0),(48,'Anchor','command',2,9,1,0),(49,'Format Select','command',3,9,1,0),(50,'Image','command',4,1,1,0),(51,'Link','command',4,1,1,0),(52,'File Manager','plugin',4,1,1,0),(53,'Media Manager','plugin',4,1,1,0); /*!40000 ALTER TABLE `m` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `u` -- DROP TABLE IF EXISTS `u`; CREATE TABLE `u` ( `id` int(11) NOT NULL auto_increment, `name` varchar(50) NOT NULL default '', `username` varchar(25) NOT NULL default '', `registerDate` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`id`), KEY `idx_name` (`name`) ) ENGINE=MyISAM AUTO_INCREMENT=63 DEFAULT CHARSET=utf8; -- -- Dumping data for table `u` -- LOCK TABLES `u` WRITE; /*!40000 ALTER TABLE `u` DISABLE KEYS */; INSERT INTO `u` VALUES (62,'Administrator','admin','0000-00-00 00:00:00'); /*!40000 ALTER TABLE `u` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2006-12-19 10:18:26