]>
Commit | Line | Data |
---|---|---|
377015e0 JP |
1 | -- MySQL dump 10.9 |
2 | -- | |
3 | -- Host: localhost Database: mitsql | |
4 | -- ------------------------------------------------------ | |
5 | -- Server version 4.1.12-nt | |
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 | /*!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 */; | |
15 | ||
16 | -- | |
17 | -- Table structure for table `DB` | |
18 | -- | |
19 | ||
20 | DROP TABLE IF EXISTS `DB`; | |
21 | CREATE TABLE `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; | |
30 | ||
31 | -- | |
32 | -- Table structure for table `DBOwner` | |
33 | -- | |
34 | ||
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; | |
44 | ||
45 | -- | |
46 | -- Table structure for table `DBQuota` | |
47 | -- | |
48 | ||
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; | |
57 | ||
58 | -- | |
59 | -- Table structure for table `Group` | |
60 | -- | |
61 | ||
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 '', | |
67 | `Name` text NOT NULL, | |
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; | |
73 | ||
74 | -- | |
75 | -- Table structure for table `GroupQuota` | |
76 | -- | |
77 | ||
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; | |
87 | ||
88 | -- | |
89 | -- Table structure for table `GroupStat` | |
90 | -- | |
91 | ||
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; | |
100 | ||
101 | -- | |
102 | -- Table structure for table `User` | |
103 | -- | |
104 | ||
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; | |
118 | ||
119 | -- | |
120 | -- Table structure for table `UserGroup` | |
121 | -- | |
122 | ||
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; | |
130 | ||
131 | -- | |
132 | -- Table structure for table `UserQuota` | |
133 | -- | |
134 | ||
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; | |
144 | ||
145 | -- | |
146 | -- Table structure for table `UserStat` | |
147 | -- | |
148 | ||
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; | |
157 | ||
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 */; | |
165 |