3 -- Host: localhost Database: mitsql
4 -- ------------------------------------------------------
5 -- Server version 4.1.12-nt
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 /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
12 /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
13 /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
14 /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17 -- Table structure for table `DB`
20 DROP TABLE IF EXISTS `DB`;
22 `DatabaseId` int(10) unsigned NOT NULL auto_increment,
23 `Name` varchar(200) NOT NULL default '',
24 `nBytes` int(10) unsigned NOT NULL default '0',
25 `dLastCheck` datetime NOT NULL default '0000-00-00 00:00:00',
26 `dCreated` datetime NOT NULL default '0000-00-00 00:00:00',
27 `bEnabled` tinyint(3) unsigned NOT NULL default '1',
28 PRIMARY KEY (`DatabaseId`)
29 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
32 -- Table structure for table `DBOwner`
35 DROP TABLE IF EXISTS `DBOwner`;
36 CREATE TABLE `DBOwner` (
37 `DatabaseId` int(10) unsigned NOT NULL default '0',
38 `UserId` int(10) unsigned NOT NULL default '0',
39 `GroupId` int(10) unsigned NOT NULL default '0',
40 KEY `DatabaseId` (`DatabaseId`),
41 KEY `UserId` (`UserId`),
42 KEY `GroupId` (`GroupId`)
43 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
46 -- Table structure for table `DBQuota`
49 DROP TABLE IF EXISTS `DBQuota`;
50 CREATE TABLE `DBQuota` (
51 `DatabaseId` int(10) unsigned NOT NULL default '0',
52 `nBytesSoft` int(10) unsigned NOT NULL default '0',
53 `nBytesHard` int(10) unsigned NOT NULL default '0',
54 `dCreated` datetime NOT NULL default '0000-00-00 00:00:00',
55 PRIMARY KEY (`DatabaseId`)
56 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
59 -- Table structure for table `Group`
62 DROP TABLE IF EXISTS `Group`;
63 CREATE TABLE `Group` (
64 `GroupId` int(10) unsigned NOT NULL auto_increment,
65 `Username` varchar(200) NOT NULL default '',
66 `Password` varchar(200) NOT NULL default '',
68 `Email` text NOT NULL,
69 `dCreated` datetime NOT NULL default '0000-00-00 00:00:00',
70 `bEnabled` tinyint(3) unsigned NOT NULL default '1',
71 PRIMARY KEY (`GroupId`)
72 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
75 -- Table structure for table `GroupQuota`
78 DROP TABLE IF EXISTS `GroupQuota`;
79 CREATE TABLE `GroupQuota` (
80 `GroupId` int(10) unsigned NOT NULL default '0',
81 `nDatabases` int(10) unsigned NOT NULL default '0',
82 `nBytesSoft` int(10) unsigned NOT NULL default '0',
83 `nBytesHard` int(10) unsigned NOT NULL default '0',
84 `dCreated` datetime NOT NULL default '0000-00-00 00:00:00',
85 PRIMARY KEY (`GroupId`)
86 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
89 -- Table structure for table `GroupStat`
92 DROP TABLE IF EXISTS `GroupStat`;
93 CREATE TABLE `GroupStat` (
94 `GroupId` int(10) unsigned NOT NULL default '0',
95 `nDatabases` int(10) unsigned NOT NULL default '0',
96 `nBytes` int(10) unsigned NOT NULL default '0',
97 `dLastCheck` datetime NOT NULL default '0000-00-00 00:00:00',
98 PRIMARY KEY (`GroupId`)
99 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
102 -- Table structure for table `User`
105 DROP TABLE IF EXISTS `User`;
106 CREATE TABLE `User` (
107 `UserId` int(10) unsigned NOT NULL auto_increment,
108 `Username` varchar(200) NOT NULL default '',
109 `Password` varchar(200) NOT NULL default '',
110 `Name` text NOT NULL,
111 `Email` text NOT NULL,
112 `UL` tinyint(3) unsigned NOT NULL default '1',
113 `dCreated` datetime NOT NULL default '0000-00-00 00:00:00',
114 `dSignup` datetime NOT NULL default '0000-00-00 00:00:00',
115 `bEnabled` tinyint(3) unsigned NOT NULL default '0',
116 PRIMARY KEY (`UserId`)
117 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
120 -- Table structure for table `UserGroup`
123 DROP TABLE IF EXISTS `UserGroup`;
124 CREATE TABLE `UserGroup` (
125 `UserId` int(10) unsigned NOT NULL default '0',
126 `GroupId` int(10) unsigned NOT NULL default '0',
127 KEY `UserId` (`UserId`),
128 KEY `GroupId` (`GroupId`)
129 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
132 -- Table structure for table `UserQuota`
135 DROP TABLE IF EXISTS `UserQuota`;
136 CREATE TABLE `UserQuota` (
137 `UserId` int(10) unsigned NOT NULL default '0',
138 `nDatabases` int(10) unsigned NOT NULL default '0',
139 `nBytesSoft` int(10) unsigned NOT NULL default '0',
140 `nBytesHard` int(10) unsigned NOT NULL default '0',
141 `dCreated` datetime NOT NULL default '0000-00-00 00:00:00',
142 PRIMARY KEY (`UserId`)
143 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
146 -- Table structure for table `UserStat`
149 DROP TABLE IF EXISTS `UserStat`;
150 CREATE TABLE `UserStat` (
151 `UserId` int(10) unsigned NOT NULL default '0',
152 `nDatabases` int(10) unsigned NOT NULL default '0',
153 `nBytes` int(10) unsigned NOT NULL default '0',
154 `dLastCheck` datetime NOT NULL default '0000-00-00 00:00:00',
155 PRIMARY KEY (`UserId`)
156 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
158 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
159 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
160 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
161 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
162 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
163 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
164 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;