]> jfr.im git - z_archive/KronOS.git/blame - dump.sql
projects / z_archive / KronOS.git / blame
? search:
summary | shortlog | log | commit | commitdiff | tree
blob | blame (incremental) | history | HEAD
Changing javascript return stryle
[z_archive/KronOS.git] / dump.sql
CommitLineData
342d13af 1-- MySQL dump 10.13 Distrib 5.1.72, for debian-linux-gnu (i486)
f255c3e2 2--
342d13af 3-- Host: localhost Database: kosjrunyon
f255c3e2 4-- ------------------------------------------------------
342d13af 5-- Server version 5.1.72-2
f255c3e2
JR		 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 `apps`
20--
21
22DROP TABLE IF EXISTS `apps`;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `apps` (
26 `aid` int(10) unsigned NOT NULL AUTO_INCREMENT,
27 `appname` varchar(100) NOT NULL,
9fde3326 28 `classname` varchar(100) NOT NULL,
f255c3e2
JR		 29 `parent` int(10) unsigned NOT NULL,
30 `filename` varchar(100) NOT NULL,
31 `access` enum('user','operator','manager') NOT NULL DEFAULT 'user',
9e6fe058 32 `active` tinyint(1) DEFAULT '1',
f255c3e2
JR		 33 PRIMARY KEY (`aid`),
34 UNIQUE KEY `appname` (`appname`)
342d13af 35) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
f255c3e2
JR		 36/*!40101 SET character_set_client = @saved_cs_client */;
37
38--
39-- Dumping data for table `apps`
40--
41
42LOCK TABLES `apps` WRITE;
43/*!40000 ALTER TABLE `apps` DISABLE KEYS */;
9e6fe058 44INSERT INTO `apps` VALUES (1,'App Zone','App_Zone',2,'default/appzone.php','manager',0),(2,'User Manager','User_Manager',2,'default/users.php','operator',1),(3,'App Settings','App_Settings_Manager',2,'default/appsetup.php','operator',0);
f255c3e2
JR		 45/*!40000 ALTER TABLE `apps` ENABLE KEYS */;
46UNLOCK TABLES;
47
48--
49-- Table structure for table `categories`
50--
51
52DROP TABLE IF EXISTS `categories`;
53/*!40101 SET @saved_cs_client = @@character_set_client */;
54/*!40101 SET character_set_client = utf8 */;
55CREATE TABLE `categories` (
56 `cid` int(10) unsigned NOT NULL AUTO_INCREMENT,
57 `catname` varchar(100) NOT NULL,
58 PRIMARY KEY (`cid`),
59 UNIQUE KEY `catname` (`catname`)
342d13af 60) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
f255c3e2
JR		 61/*!40101 SET character_set_client = @saved_cs_client */;
62
63--
64-- Dumping data for table `categories`
65--
66
67LOCK TABLES `categories` WRITE;
68/*!40000 ALTER TABLE `categories` DISABLE KEYS */;
342d13af 69INSERT INTO `categories` VALUES (1,'System'),(2,'Administration');
f255c3e2
JR		 70/*!40000 ALTER TABLE `categories` ENABLE KEYS */;
71UNLOCK TABLES;
72
73--
74-- Table structure for table `session_apps`
75--
76
77DROP TABLE IF EXISTS `session_apps`;
78/*!40101 SET @saved_cs_client = @@character_set_client */;
79/*!40101 SET character_set_client = utf8 */;
80CREATE TABLE `session_apps` (
81 `iid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
82 `sid` int(10) unsigned NOT NULL,
9e6fe058
JR		 83 `aid` int(11) NOT NULL,
84 `corename` varchar(100) DEFAULT NULL,
f255c3e2 85 PRIMARY KEY (`iid`)
9e6fe058 86) ENGINE=MyISAM AUTO_INCREMENT=29 DEFAULT CHARSET=latin1;
f255c3e2
JR		 87/*!40101 SET character_set_client = @saved_cs_client */;
88
89--
90-- Dumping data for table `session_apps`
91--
92
93LOCK TABLES `session_apps` WRITE;
94/*!40000 ALTER TABLE `session_apps` DISABLE KEYS */;
9e6fe058 95INSERT INTO `session_apps` VALUES (1,2,4,NULL),(2,3,4,NULL),(3,6,0,NULL),(4,6,0,NULL),(5,6,0,NULL),(6,6,0,NULL),(7,6,0,NULL),(8,6,0,NULL),(9,7,0,NULL),(10,7,0,NULL),(11,7,4,NULL),(12,8,0,NULL),(13,11,0,NULL),(14,12,0,NULL),(15,14,2,NULL),(16,15,0,NULL),(17,16,-1,'credits'),(18,17,-1,'credits'),(19,18,-1,'credits'),(20,18,-1,'credits'),(21,19,-1,'credits'),(22,20,2,NULL),(23,21,2,NULL),(24,22,2,NULL),(25,23,2,NULL),(26,24,2,NULL),(27,25,2,NULL),(28,26,2,NULL);
f255c3e2
JR		 96/*!40000 ALTER TABLE `session_apps` ENABLE KEYS */;
97UNLOCK TABLES;
98
99--
100-- Table structure for table `sessions`
101--
102
103DROP TABLE IF EXISTS `sessions`;
104/*!40101 SET @saved_cs_client = @@character_set_client */;
105/*!40101 SET character_set_client = utf8 */;
106CREATE TABLE `sessions` (
107 `sid` int(10) unsigned NOT NULL AUTO_INCREMENT,
108 `uid` int(10) unsigned NOT NULL,
109 `started` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
110 `last` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
111 `lockip` text NOT NULL,
112 PRIMARY KEY (`sid`)
9e6fe058 113) ENGINE=MyISAM AUTO_INCREMENT=27 DEFAULT CHARSET=latin1;
f255c3e2
JR		 114/*!40101 SET character_set_client = @saved_cs_client */;
115
116--
117-- Dumping data for table `sessions`
118--
119
120LOCK TABLES `sessions` WRITE;
121/*!40000 ALTER TABLE `sessions` DISABLE KEYS */;
9e6fe058 122INSERT INTO `sessions` VALUES (1,1,'0000-00-00 00:00:00','0000-00-00 00:00:00','67.79.10.133'),(2,1,'0000-00-00 00:00:00','0000-00-00 00:00:00','67.79.10.133'),(3,1,'0000-00-00 00:00:00','0000-00-00 00:00:00','67.79.10.133'),(4,1,'0000-00-00 00:00:00','0000-00-00 00:00:00','67.79.10.133'),(5,1,'0000-00-00 00:00:00','0000-00-00 00:00:00','67.79.10.133'),(6,1,'0000-00-00 00:00:00','0000-00-00 00:00:00','67.79.10.133'),(7,1,'0000-00-00 00:00:00','0000-00-00 00:00:00','67.79.10.133'),(8,1,'0000-00-00 00:00:00','0000-00-00 00:00:00','67.79.10.133'),(9,1,'0000-00-00 00:00:00','0000-00-00 00:00:00','67.79.10.133'),(10,1,'0000-00-00 00:00:00','0000-00-00 00:00:00','67.79.10.133'),(11,2,'0000-00-00 00:00:00','0000-00-00 00:00:00','67.79.10.133'),(12,1,'0000-00-00 00:00:00','0000-00-00 00:00:00','67.79.10.133'),(13,2,'0000-00-00 00:00:00','0000-00-00 00:00:00','67.79.10.133'),(14,2,'0000-00-00 00:00:00','0000-00-00 00:00:00','85.157.91.21'),(15,1,'0000-00-00 00:00:00','0000-00-00 00:00:00','67.79.10.133'),(16,1,'0000-00-00 00:00:00','0000-00-00 00:00:00','67.79.10.133'),(17,1,'0000-00-00 00:00:00','0000-00-00 00:00:00','67.79.10.133'),(18,1,'0000-00-00 00:00:00','0000-00-00 00:00:00','67.79.10.133'),(19,1,'0000-00-00 00:00:00','0000-00-00 00:00:00','67.79.10.133'),(20,1,'0000-00-00 00:00:00','0000-00-00 00:00:00','67.79.10.133'),(21,1,'0000-00-00 00:00:00','0000-00-00 00:00:00','67.79.10.133'),(22,1,'0000-00-00 00:00:00','0000-00-00 00:00:00','67.79.10.133'),(23,1,'0000-00-00 00:00:00','0000-00-00 00:00:00','67.79.10.133'),(24,1,'0000-00-00 00:00:00','0000-00-00 00:00:00','67.79.10.133'),(25,1,'0000-00-00 00:00:00','0000-00-00 00:00:00','67.79.10.133'),(26,1,'0000-00-00 00:00:00','0000-00-00 00:00:00','67.79.10.133');
f255c3e2
JR		 123/*!40000 ALTER TABLE `sessions` ENABLE KEYS */;
124UNLOCK TABLES;
125
126--
127-- Table structure for table `users`
128--
129
130DROP TABLE IF EXISTS `users`;
131/*!40101 SET @saved_cs_client = @@character_set_client */;
132/*!40101 SET character_set_client = utf8 */;
133CREATE TABLE `users` (
134 `uid` int(10) unsigned NOT NULL AUTO_INCREMENT,
135 `username` varchar(15) NOT NULL,
136 `password` char(40) NOT NULL,
137 `salt` char(5) NOT NULL,
138 `display_name` varchar(100) NOT NULL,
139 `level` enum('user','operator','manager') NOT NULL DEFAULT 'user',
140 PRIMARY KEY (`uid`)
9e6fe058 141) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
f255c3e2
JR		 142/*!40101 SET character_set_client = @saved_cs_client */;
143
144--
145-- Dumping data for table `users`
146--
147
148LOCK TABLES `users` WRITE;
149/*!40000 ALTER TABLE `users` DISABLE KEYS */;
9e6fe058 150INSERT INTO `users` VALUES (1,'jrunyon','0e4fbcfac8f8627fbebace9647f0b8af8b13eac9','53214','John','manager'),(2,'test','2c378084a75e475bc98a964e27923ab6f1789966','saltd','Test User','manager');
f255c3e2
JR		 151/*!40000 ALTER TABLE `users` ENABLE KEYS */;
152UNLOCK TABLES;
153/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
154
155/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
156/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
157/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
158/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
159/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
160/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
161/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
162
9e6fe058 163-- Dump completed on 2013-11-03 17:31:27
Unnamed repository; edit this file 'description' to name the repository.