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 |
No edit summary |
||
| Line 4: | Line 4: | ||
`name` varchar(255) NOT NULL, | `name` varchar(255) NOT NULL, | ||
PRIMARY KEY (`id`) | PRIMARY KEY (`id`) | ||
`files` | `files` | ||
| Line 37: | Line 31: | ||
`partitions` | `partitions` | ||
`id` mediumint( | `id` mediumint(8) unsigned NOT NULL auto_increment, | ||
`name` varchar(255) NOT NULL, | `name` varchar(255) NOT NULL, | ||
`state` tinyint(1) unsigned NOT NULL default '1', | `state` tinyint(1) unsigned NOT NULL default '1', | ||
| Line 43: | Line 37: | ||
`doclinks` mediumtext, | `doclinks` mediumtext, | ||
`newsgroups` mediumtext, | `newsgroups` mediumtext, | ||
` | `parent_id` smallint(5) unsigned NOT NULL default '0', | ||
`private` tinyint(1) NOT NULL default '0', | `private` tinyint(1) NOT NULL default '0', | ||
PRIMARY KEY (`id`), | PRIMARY KEY (`id`), | ||
| Line 81: | Line 75: | ||
`repository_id` mediumint(8) unsigned NOT NULL, | `repository_id` mediumint(8) unsigned NOT NULL, | ||
`needed` tinyint(1) NOT NULL default '0' | `needed` tinyint(1) NOT NULL default '0' | ||
`tags` | |||
`name` varchar(255) NOT NULL, | |||
`partition_id` mediumint(8) unsigned NOT NULL auto_increment, | |||
KEY `name` (`name`) | |||
`user_changes` | `user_changes` | ||
| Line 90: | Line 89: | ||
`ts` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, | `ts` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, | ||
KEY `ts` (`ts`) | KEY `ts` (`ts`) | ||
`vouchers` | `vouchers` | ||