andersk / sql-web.git / blame
| Commit | Line | Data |
|---|---|---|
| 50855303 JP |
1 | -- MySQL dump 10.9\r |
| 2 | --\r | |
| 3 | -- Host: localhost Database: mitsql\r | |
| 4 | -- ------------------------------------------------------\r | |
| 5 | -- Server version 4.1.12-nt\r | |
| 6 | \r | |
| 7 | /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;\r | |
| 8 | /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;\r | |
| 9 | /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;\r | |
| 10 | /*!40101 SET NAMES utf8 */;\r | |
| 11 | /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;\r | |
| 12 | /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;\r | |
| 13 | /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;\r | |
| 14 | /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;\r | |
| 15 | \r | |
| 16 | --\r | |
| 17 | -- Table structure for table `db`\r | |
| 18 | --\r | |
| 19 | \r | |
| 20 | DROP TABLE IF EXISTS `db`;\r | |
| 21 | CREATE TABLE `db` (\r | |
| 22 | `DatabaseId` int(10) unsigned NOT NULL auto_increment,\r | |
| 23 | `Name` varchar(200) NOT NULL default '',\r | |
| 24 | `nBytes` int(10) unsigned NOT NULL default '0',\r | |
| 25 | `dLastCheck` datetime NOT NULL default '0000-00-00 00:00:00',\r | |
| 26 | `dCreated` datetime NOT NULL default '0000-00-00 00:00:00',\r | |
| 27 | `bEnabled` tinyint(3) unsigned NOT NULL default '1',\r | |
| 28 | PRIMARY KEY (`DatabaseId`)\r | |
| 29 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1;\r | |
| 30 | \r | |
| 31 | --\r | |
| 32 | -- Table structure for table `dbowner`\r | |
| 33 | --\r | |
| 34 | \r | |
| 35 | DROP TABLE IF EXISTS `dbowner`;\r | |
| 36 | CREATE TABLE `dbowner` (\r | |
| 37 | `DatabaseId` int(10) unsigned NOT NULL default '0',\r | |
| 38 | `UserId` int(10) unsigned NOT NULL default '0',\r | |
| 39 | `GroupId` int(10) unsigned NOT NULL default '0',\r | |
| 40 | KEY `DatabaseId` (`DatabaseId`),\r | |
| 41 | KEY `UserId` (`UserId`),\r | |
| 42 | KEY `GroupId` (`GroupId`)\r | |
| 43 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1;\r | |
| 44 | \r | |
| 45 | --\r | |
| 46 | -- Table structure for table `dbquota`\r | |
| 47 | --\r | |
| 48 | \r | |
| 49 | DROP TABLE IF EXISTS `dbquota`;\r | |
| 50 | CREATE TABLE `dbquota` (\r | |
| 51 | `DatabaseId` int(10) unsigned NOT NULL default '0',\r | |
| 52 | `nBytesSoft` int(10) unsigned NOT NULL default '0',\r | |
| 53 | `nBytesHard` int(10) unsigned NOT NULL default '0',\r | |
| 54 | `dCreated` datetime NOT NULL default '0000-00-00 00:00:00',\r | |
| 55 | PRIMARY KEY (`DatabaseId`)\r | |
| 56 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1;\r | |
| 57 | \r | |
| 58 | --\r | |
| 59 | -- Table structure for table `group`\r | |
| 60 | --\r | |
| 61 | \r | |
| 62 | DROP TABLE IF EXISTS `group`;\r | |
| 63 | CREATE TABLE `group` (\r | |
| 64 | `GroupId` int(10) unsigned NOT NULL auto_increment,\r | |
| 65 | `Username` varchar(200) NOT NULL default '',\r | |
| 66 | `Password` varchar(200) NOT NULL default '',\r | |
| 67 | `Name` text NOT NULL,\r | |
| 68 | `Email` text NOT NULL,\r | |
| 69 | `dCreated` datetime NOT NULL default '0000-00-00 00:00:00',\r | |
| 70 | `bEnabled` tinyint(3) unsigned NOT NULL default '1',\r | |
| 71 | PRIMARY KEY (`GroupId`)\r | |
| 72 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1;\r | |
| 73 | \r | |
| 74 | --\r | |
| 75 | -- Table structure for table `groupquota`\r | |
| 76 | --\r | |
| 77 | \r | |
| 78 | DROP TABLE IF EXISTS `groupquota`;\r | |
| 79 | CREATE TABLE `groupquota` (\r | |
| 80 | `GroupId` int(10) unsigned NOT NULL default '0',\r | |
| 81 | `nDatabases` int(10) unsigned NOT NULL default '0',\r | |
| 82 | `nBytesSoft` int(10) unsigned NOT NULL default '0',\r | |
| 83 | `nBytesHard` int(10) unsigned NOT NULL default '0',\r | |
| 84 | `dCreated` datetime NOT NULL default '0000-00-00 00:00:00',\r | |
| 85 | PRIMARY KEY (`GroupId`)\r | |
| 86 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1;\r | |
| 87 | \r | |
| 88 | --\r | |
| 89 | -- Table structure for table `groupstat`\r | |
| 90 | --\r | |
| 91 | \r | |
| 92 | DROP TABLE IF EXISTS `groupstat`;\r | |
| 93 | CREATE TABLE `groupstat` (\r | |
| 94 | `GroupId` int(10) unsigned NOT NULL default '0',\r | |
| 95 | `nDatabases` int(10) unsigned NOT NULL default '0',\r | |
| 96 | `nBytes` int(10) unsigned NOT NULL default '0',\r | |
| 97 | `dLastCheck` datetime NOT NULL default '0000-00-00 00:00:00',\r | |
| 98 | PRIMARY KEY (`GroupId`)\r | |
| 99 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1;\r | |
| 100 | \r | |
| 101 | --\r | |
| 102 | -- Table structure for table `user`\r | |
| 103 | --\r | |
| 104 | \r | |
| 105 | DROP TABLE IF EXISTS `user`;\r | |
| 106 | CREATE TABLE `user` (\r | |
| 107 | `UserId` int(10) unsigned NOT NULL auto_increment,\r | |
| 108 | `Username` varchar(200) NOT NULL default '',\r | |
| 109 | `Password` varchar(200) NOT NULL default '',\r | |
| 110 | `Name` text NOT NULL,\r | |
| 111 | `Email` text NOT NULL,\r | |
| 112 | `UL` tinyint(3) unsigned NOT NULL default '1',\r | |
| 113 | `dCreated` datetime NOT NULL default '0000-00-00 00:00:00',\r | |
| 114 | `dSignup` datetime NOT NULL default '0000-00-00 00:00:00',\r | |
| 115 | `bEnabled` tinyint(3) unsigned NOT NULL default '0',\r | |
| 116 | PRIMARY KEY (`UserId`)\r | |
| 117 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1;\r | |
| 118 | \r | |
| 119 | --\r | |
| 120 | -- Table structure for table `usergroup`\r | |
| 121 | --\r | |
| 122 | \r | |
| 123 | DROP TABLE IF EXISTS `usergroup`;\r | |
| 124 | CREATE TABLE `usergroup` (\r | |
| 125 | `UserId` int(10) unsigned NOT NULL default '0',\r | |
| 126 | `GroupId` int(10) unsigned NOT NULL default '0',\r | |
| 127 | KEY `UserId` (`UserId`),\r | |
| 128 | KEY `GroupId` (`GroupId`)\r | |
| 129 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1;\r | |
| 130 | \r | |
| 131 | --\r | |
| 132 | -- Table structure for table `userquota`\r | |
| 133 | --\r | |
| 134 | \r | |
| 135 | DROP TABLE IF EXISTS `userquota`;\r | |
| 136 | CREATE TABLE `userquota` (\r | |
| 137 | `UserId` int(10) unsigned NOT NULL default '0',\r | |
| 138 | `nDatabases` int(10) unsigned NOT NULL default '0',\r | |
| 139 | `nBytesSoft` int(10) unsigned NOT NULL default '0',\r | |
| 140 | `nBytesHard` int(10) unsigned NOT NULL default '0',\r | |
| 141 | `dCreated` datetime NOT NULL default '0000-00-00 00:00:00',\r | |
| 142 | PRIMARY KEY (`UserId`)\r | |
| 143 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1;\r | |
| 144 | \r | |
| 145 | --\r | |
| 146 | -- Table structure for table `userstat`\r | |
| 147 | --\r | |
| 148 | \r | |
| 149 | DROP TABLE IF EXISTS `userstat`;\r | |
| 150 | CREATE TABLE `userstat` (\r | |
| 151 | `UserId` int(10) unsigned NOT NULL default '0',\r | |
| 152 | `nDatabases` int(10) unsigned NOT NULL default '0',\r | |
| 153 | `nBytes` int(10) unsigned NOT NULL default '0',\r | |
| 154 | `dLastCheck` datetime NOT NULL default '0000-00-00 00:00:00',\r | |
| 155 | PRIMARY KEY (`UserId`)\r | |
| 156 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1;\r | |
| 157 | \r | |
| 158 | /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;\r | |
| 159 | /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;\r | |
| 160 | /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;\r | |
| 161 | /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;\r | |
| 162 | /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;\r | |
| 163 | /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;\r | |
| 164 | /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;\r | |
| 165 | \r |