Confirmed users, Bureaucrats and Sysops emeriti
882
edits
Despot:Schema: Difference between revisions
Jump to navigation
Jump to search
no edit summary
No edit summary |
|||
| Line 17: | Line 17: | ||
`user_id` mediumint(8) unsigned NOT NULL, | `user_id` mediumint(8) unsigned NOT NULL, | ||
`partition_id` mediumint(8) unsigned NOT NULL, | `partition_id` mediumint(8) unsigned NOT NULL, | ||
`class` | `class` enum('owner','peer','member') NOT NULL default 'member', | ||
UNIQUE KEY `user_id` (`user_id`,`partition_id`), | UNIQUE KEY `user_id` (`user_id`,`partition_id`), | ||
KEY `class` (`class`) | KEY `class` (`class`) | ||
| Line 24: | Line 24: | ||
`partition_id` mediumint(8) unsigned NOT NULL, | `partition_id` mediumint(8) unsigned NOT NULL, | ||
`field` varchar(255) NOT NULL, | `field` varchar(255) NOT NULL, | ||
`oldvalue` | `oldvalue` mediumtext, | ||
`newvalue` | `newvalue` mediumtext, | ||
`who` mediumint(8) unsigned NOT NULL, | `who` mediumint(8) unsigned NOT NULL, | ||
`ts` | `ts` datetime NOT NULL, | ||
KEY `ts` (`ts`) | KEY `ts` (`ts`), | ||
KEY `partition_id` (`partition_id`) | |||
`partitions` | `partitions` | ||
`id` mediumint(8) unsigned NOT NULL auto_increment, | `id` mediumint(8) unsigned NOT NULL auto_increment, | ||
`name` varchar(255) NOT NULL, | `name` varchar(255) NOT NULL, | ||
`state` | `state` enum('open','restricted','closed') NOT NULL default 'open', | ||
`description` text, | `description` text, | ||
`doclinks` mediumtext, | `doclinks` mediumtext, | ||
| Line 40: | Line 41: | ||
`private` tinyint(1) NOT NULL default '0', | `private` tinyint(1) NOT NULL default '0', | ||
PRIMARY KEY (`id`), | PRIMARY KEY (`id`), | ||
KEY `name` (`name`), | |||
KEY `parent_id` (`parent_id`) | |||
`repositories` | `repositories` | ||
| Line 55: | Line 58: | ||
`repository_id` mediumint(8) unsigned NOT NULL, | `repository_id` mediumint(8) unsigned NOT NULL, | ||
`field` varchar(255) NOT NULL, | `field` varchar(255) NOT NULL, | ||
`oldvalue` | `oldvalue` mediumtext, | ||
`newvalue` | `newvalue` mediumtext, | ||
`who` mediumint(8) unsigned NOT NULL, | `who` mediumint(8) unsigned NOT NULL, | ||
`ts` | `ts` datetime NOT NULL, | ||
KEY `ts` (`ts`) | KEY `ts` (`ts`), | ||
KEY `repository_id` (`repository_id`) | |||
`restrictions` | `restrictions` | ||
| Line 78: | Line 82: | ||
`tags` | `tags` | ||
`name` varchar(255) NOT NULL, | `name` varchar(255) NOT NULL, | ||
`partition_id` mediumint(8) unsigned NOT NULL | `partition_id` mediumint(8) unsigned NOT NULL, | ||
KEY `name` (`name`) | KEY `name` (`name`) | ||
| Line 84: | Line 88: | ||
`user_id` mediumint(8) unsigned NOT NULL, | `user_id` mediumint(8) unsigned NOT NULL, | ||
`field` varchar(255) NOT NULL, | `field` varchar(255) NOT NULL, | ||
`oldvalue` | `oldvalue` mediumtext, | ||
`newvalue` | `newvalue` mediumtext, | ||
`who` mediumint(8) unsigned NOT NULL, | `who` mediumint(8) unsigned NOT NULL, | ||
`ts` | `ts` datetime NOT NULL, | ||
KEY `ts` (`ts`) | KEY `ts` (`ts`), | ||
KEY `user_id` (`user_id`) | |||
`vouchers` | `vouchers` | ||