mirror of
https://github.com/haiwen/seahub.git
synced 2025-10-28 07:31:29 +00:00
176 lines
8.1 KiB
SQL
176 lines
8.1 KiB
SQL
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
|
|
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
|
|
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
|
|
/*!40101 SET NAMES utf8 */;
|
|
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
|
|
/*!40103 SET TIME_ZONE='+00:00' */;
|
|
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
|
|
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
|
|
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
|
|
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
|
|
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE IF NOT EXISTS `auth_group` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`name` varchar(80) NOT NULL,
|
|
PRIMARY KEY (`id`),
|
|
UNIQUE KEY `name` (`name`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
/*!40000 ALTER TABLE `auth_group` DISABLE KEYS */;
|
|
/*!40000 ALTER TABLE `auth_group` ENABLE KEYS */;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE IF NOT EXISTS `auth_group_permissions` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`group_id` int(11) NOT NULL,
|
|
`permission_id` int(11) NOT NULL,
|
|
PRIMARY KEY (`id`),
|
|
UNIQUE KEY `auth_group_permissions_group_id_permission_id_0cd325b0_uniq` (`group_id`,`permission_id`),
|
|
KEY `auth_group_permissio_permission_id_84c5c92e_fk_auth_perm` (`permission_id`),
|
|
CONSTRAINT `auth_group_permissio_permission_id_84c5c92e_fk_auth_perm` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`),
|
|
CONSTRAINT `auth_group_permissions_group_id_b120cbf9_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
/*!40000 ALTER TABLE `auth_group_permissions` DISABLE KEYS */;
|
|
/*!40000 ALTER TABLE `auth_group_permissions` ENABLE KEYS */;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE IF NOT EXISTS `auth_permission` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`name` varchar(255) NOT NULL,
|
|
`content_type_id` int(11) NOT NULL,
|
|
`codename` varchar(100) NOT NULL,
|
|
PRIMARY KEY (`id`),
|
|
UNIQUE KEY `auth_permission_content_type_id_codename_01ab375a_uniq` (`content_type_id`,`codename`),
|
|
CONSTRAINT `auth_permission_content_type_id_2f476e4b_fk_django_co` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=209 DEFAULT CHARSET=utf8;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
/*!40000 ALTER TABLE `auth_permission` ENABLE KEYS */;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE IF NOT EXISTS `auth_user` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`password` varchar(128) NOT NULL,
|
|
`last_login` datetime DEFAULT NULL,
|
|
`is_superuser` tinyint(1) NOT NULL,
|
|
`username` varchar(150) NOT NULL,
|
|
`first_name` varchar(30) NOT NULL,
|
|
`last_name` varchar(30) NOT NULL,
|
|
`email` varchar(254) NOT NULL,
|
|
`is_staff` tinyint(1) NOT NULL,
|
|
`is_active` tinyint(1) NOT NULL,
|
|
`date_joined` datetime NOT NULL,
|
|
PRIMARY KEY (`id`),
|
|
UNIQUE KEY `username` (`username`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
/*!40000 ALTER TABLE `auth_user` DISABLE KEYS */;
|
|
/*!40000 ALTER TABLE `auth_user` ENABLE KEYS */;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE IF NOT EXISTS `auth_user_groups` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`user_id` int(11) NOT NULL,
|
|
`group_id` int(11) NOT NULL,
|
|
PRIMARY KEY (`id`),
|
|
UNIQUE KEY `auth_user_groups_user_id_group_id_94350c0c_uniq` (`user_id`,`group_id`),
|
|
KEY `auth_user_groups_group_id_97559544_fk_auth_group_id` (`group_id`),
|
|
CONSTRAINT `auth_user_groups_group_id_97559544_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`),
|
|
CONSTRAINT `auth_user_groups_user_id_6a12ed8b_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
/*!40000 ALTER TABLE `auth_user_groups` DISABLE KEYS */;
|
|
/*!40000 ALTER TABLE `auth_user_groups` ENABLE KEYS */;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE IF NOT EXISTS `auth_user_user_permissions` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`user_id` int(11) NOT NULL,
|
|
`permission_id` int(11) NOT NULL,
|
|
PRIMARY KEY (`id`),
|
|
UNIQUE KEY `auth_user_user_permissions_user_id_permission_id_14a6b632_uniq` (`user_id`,`permission_id`),
|
|
KEY `auth_user_user_permi_permission_id_1fbb5f2c_fk_auth_perm` (`permission_id`),
|
|
CONSTRAINT `auth_user_user_permi_permission_id_1fbb5f2c_fk_auth_perm` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`),
|
|
CONSTRAINT `auth_user_user_permissions_user_id_a95ead1b_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
|
|
/*!40000 ALTER TABLE `wiki_personalwiki` DISABLE KEYS */;
|
|
/*!40000 ALTER TABLE `wiki_personalwiki` ENABLE KEYS */;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE IF NOT EXISTS `wiki_wiki` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`username` varchar(255) NOT NULL,
|
|
`name` varchar(255) NOT NULL,
|
|
`slug` varchar(255) NOT NULL,
|
|
`repo_id` varchar(36) NOT NULL,
|
|
`permission` varchar(50) NOT NULL,
|
|
`created_at` datetime NOT NULL,
|
|
PRIMARY KEY (`id`),
|
|
UNIQUE KEY `slug` (`slug`),
|
|
UNIQUE KEY `wiki_wiki_username_3c0f83e1b93de663_uniq` (`username`,`repo_id`),
|
|
KEY `wiki_wiki_fde81f11` (`created_at`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
/*!40000 ALTER TABLE `wiki_wiki` DISABLE KEYS */;
|
|
/*!40000 ALTER TABLE `wiki_wiki` ENABLE KEYS */;
|
|
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
|
|
|
|
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
|
|
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
|
|
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
|
|
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
|
|
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
|
|
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
|
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
|
|
|
CREATE TABLE IF NOT EXISTS `django_cas_ng_proxygrantingticket` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`session_key` varchar(255) DEFAULT NULL,
|
|
`pgtiou` varchar(255) DEFAULT NULL,
|
|
`pgt` varchar(255) DEFAULT NULL,
|
|
`date` datetime NOT NULL,
|
|
`user` varchar(255) NOT NULL,
|
|
PRIMARY KEY (`id`),
|
|
UNIQUE KEY `django_cas_ng_proxygrant_session_key_user_id_4cd2ea19_uniq` (`session_key`,`user`),
|
|
KEY `django_cas_ng_proxyg_user_id_f833edd2_fk_auth_user` (`user`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
CREATE TABLE IF NOT EXISTS `django_cas_ng_sessionticket` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`session_key` varchar(255) NOT NULL,
|
|
`ticket` varchar(255) NOT NULL,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
|
|
CREATE TABLE IF NOT EXISTS `organizations_orgmemberquota` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`org_id` int(11) NOT NULL,
|
|
`quota` int(11) NOT NULL,
|
|
PRIMARY KEY (`id`),
|
|
KEY `organizations_orgmemberquota_org_id_93dde51d` (`org_id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
|
|
|
|
ALTER TABLE notifications_notification ADD INDEX `notifications_notification_386bba5a` (`primary`);
|
|
|
|
ALTER TABLE institutions_institutionadmin ADD INDEX `institutions_institutionadmin_user_7560167c8413ff0e_uniq` (`user`);
|
|
|
|
ALTER TABLE `post_office_attachment` add column `mimetype` varchar(255) NOT NULL;
|
|
|
|
ALTER TABLE Event ADD INDEX `ix_event_timestamp` (`timestamp`);
|
|
ALTER TABLE FileAudit ADD INDEX `ix_FileAudit_timestamp` (`timestamp`);
|
|
ALTER TABLE FileUpdate ADD INDEX `ix_FileUpdate_timestamp` (`timestamp`);
|
|
ALTER TABLE UserTrafficStat ADD INDEX `ix_UserTrafficStat_month` (`month`);
|