· 8 years ago · Jul 10, 2018, 04:08 AM
1-- MySQL dump 10.11
2--
3-- Host: localhost Database: reviewforum
4-- ------------------------------------------------------
5-- Server version 5.0.41
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Table structure for table `acos`
20--
21
22DROP TABLE IF EXISTS `acos`;
23CREATE TABLE `acos` (
24 `id` int(10) unsigned NOT NULL auto_increment,
25 `parent_id` int(10) default NULL,
26 `model` varchar(255) default '',
27 `foreign_key` int(10) unsigned default NULL,
28 `alias` varchar(255) default '',
29 `lft` int(10) default NULL,
30 `rght` int(10) default NULL,
31 PRIMARY KEY (`id`)
32) ENGINE=MyISAM AUTO_INCREMENT=83 DEFAULT CHARSET=latin1;
33
34--
35-- Dumping data for table `acos`
36--
37
38LOCK TABLES `acos` WRITE;
39/*!40000 ALTER TABLE `acos` DISABLE KEYS */;
40INSERT INTO `acos` VALUES (1,NULL,NULL,NULL,'controllers',1,164),(2,1,NULL,NULL,'Pages',2,9),(3,2,NULL,NULL,'display',3,4),(4,2,NULL,NULL,'buildacl',5,6),(5,2,NULL,NULL,'initDB',7,8),(6,1,NULL,NULL,'Groups',10,27),(7,6,NULL,NULL,'initGroups',11,12),(8,6,NULL,NULL,'index',13,14),(9,6,NULL,NULL,'view',15,16),(10,6,NULL,NULL,'add',17,18),(11,6,NULL,NULL,'edit',19,20),(12,6,NULL,NULL,'delete',21,22),(13,6,NULL,NULL,'buildacl',23,24),(14,6,NULL,NULL,'initDB',25,26),(15,1,NULL,NULL,'Reviewees',28,55),(16,15,NULL,NULL,'index',29,30),(17,15,NULL,NULL,'view',31,32),(18,15,NULL,NULL,'start',33,34),(19,15,NULL,NULL,'add',35,36),(20,15,NULL,NULL,'edit',37,38),(21,15,NULL,NULL,'delete',39,40),(22,15,NULL,NULL,'admin_index',41,42),(23,15,NULL,NULL,'admin_view',43,44),(24,15,NULL,NULL,'admin_add',45,46),(25,15,NULL,NULL,'admin_edit',47,48),(26,15,NULL,NULL,'admin_delete',49,50),(27,15,NULL,NULL,'buildacl',51,52),(28,15,NULL,NULL,'initDB',53,54),(29,1,NULL,NULL,'Reviewlinks',56,81),(30,29,NULL,NULL,'index',57,58),(31,29,NULL,NULL,'view',59,60),(32,29,NULL,NULL,'add',61,62),(33,29,NULL,NULL,'edit',63,64),(34,29,NULL,NULL,'delete',65,66),(35,29,NULL,NULL,'admin_index',67,68),(36,29,NULL,NULL,'admin_view',69,70),(37,29,NULL,NULL,'admin_add',71,72),(38,29,NULL,NULL,'admin_edit',73,74),(39,29,NULL,NULL,'admin_delete',75,76),(40,29,NULL,NULL,'buildacl',77,78),(41,29,NULL,NULL,'initDB',79,80),(42,1,NULL,NULL,'Reviews',82,109),(43,42,NULL,NULL,'index',83,84),(44,42,NULL,NULL,'view',85,86),(45,42,NULL,NULL,'add',87,88),(46,42,NULL,NULL,'reply',89,90),(47,42,NULL,NULL,'edit',91,92),(48,42,NULL,NULL,'delete',93,94),(49,42,NULL,NULL,'admin_index',95,96),(50,42,NULL,NULL,'admin_view',97,98),(51,42,NULL,NULL,'admin_add',99,100),(52,42,NULL,NULL,'admin_edit',101,102),(53,42,NULL,NULL,'admin_delete',103,104),(54,42,NULL,NULL,'buildacl',105,106),(55,42,NULL,NULL,'initDB',107,108),(56,1,NULL,NULL,'Userlinks',110,135),(57,56,NULL,NULL,'index',111,112),(58,56,NULL,NULL,'view',113,114),(59,56,NULL,NULL,'add',115,116),(60,56,NULL,NULL,'edit',117,118),(61,56,NULL,NULL,'delete',119,120),(62,56,NULL,NULL,'admin_index',121,122),(63,56,NULL,NULL,'admin_view',123,124),(64,56,NULL,NULL,'admin_add',125,126),(65,56,NULL,NULL,'admin_edit',127,128),(66,56,NULL,NULL,'admin_delete',129,130),(67,56,NULL,NULL,'buildacl',131,132),(68,56,NULL,NULL,'initDB',133,134),(69,1,NULL,NULL,'Users',136,163),(70,69,NULL,NULL,'login',137,138),(71,69,NULL,NULL,'logout',139,140),(72,69,NULL,NULL,'index',141,142),(73,69,NULL,NULL,'view',143,144),(74,69,NULL,NULL,'register',145,146),(75,69,NULL,NULL,'edit',147,148),(76,69,NULL,NULL,'admin_index',149,150),(77,69,NULL,NULL,'admin_view',151,152),(78,69,NULL,NULL,'admin_add',153,154),(79,69,NULL,NULL,'admin_edit',155,156),(80,69,NULL,NULL,'admin_delete',157,158),(81,69,NULL,NULL,'buildacl',159,160),(82,69,NULL,NULL,'initDB',161,162);
41/*!40000 ALTER TABLE `acos` ENABLE KEYS */;
42UNLOCK TABLES;
43
44--
45-- Table structure for table `aros`
46--
47
48DROP TABLE IF EXISTS `aros`;
49CREATE TABLE `aros` (
50 `id` int(10) unsigned NOT NULL auto_increment,
51 `parent_id` int(10) default NULL,
52 `model` varchar(255) default '',
53 `foreign_key` int(10) unsigned default NULL,
54 `alias` varchar(255) default '',
55 `lft` int(10) default NULL,
56 `rght` int(10) default NULL,
57 PRIMARY KEY (`id`)
58) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
59
60--
61-- Dumping data for table `aros`
62--
63
64LOCK TABLES `aros` WRITE;
65/*!40000 ALTER TABLE `aros` DISABLE KEYS */;
66INSERT INTO `aros` VALUES (1,NULL,'Group',1,NULL,1,6),(2,NULL,'Group',2,NULL,7,10),(3,NULL,'Group',3,NULL,11,12),(4,NULL,'Group',4,NULL,13,14),(5,2,'User',1,'',8,9),(6,1,'User',2,'',4,5);
67/*!40000 ALTER TABLE `aros` ENABLE KEYS */;
68UNLOCK TABLES;
69
70--
71-- Table structure for table `aros_acos`
72--
73
74DROP TABLE IF EXISTS `aros_acos`;
75CREATE TABLE `aros_acos` (
76 `id` int(10) unsigned NOT NULL auto_increment,
77 `aro_id` int(10) unsigned NOT NULL,
78 `aco_id` int(10) unsigned NOT NULL,
79 `_create` char(2) NOT NULL default '0',
80 `_read` char(2) NOT NULL default '0',
81 `_update` char(2) NOT NULL default '0',
82 `_delete` char(2) NOT NULL default '0',
83 PRIMARY KEY (`id`)
84) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
85
86--
87-- Dumping data for table `aros_acos`
88--
89
90LOCK TABLES `aros_acos` WRITE;
91/*!40000 ALTER TABLE `aros_acos` DISABLE KEYS */;
92INSERT INTO `aros_acos` VALUES (1,1,1,'1','1','1','1'),(2,2,1,'1','1','1','1'),(3,3,1,'-1','-1','-1','-1'),(4,3,73,'1','1','1','1'),(5,3,44,'1','1','1','1'),(6,3,17,'1','1','1','1');
93/*!40000 ALTER TABLE `aros_acos` ENABLE KEYS */;
94UNLOCK TABLES;
95/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
96
97/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
98/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
99/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
100/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
101/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
102/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
103/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
104
105-- Dump completed on 2009-08-14 19:35:52