Difference between revisions of "Userdb:groups"
From EjudgeWiki
(Created page with "CREATE TABLE `groups` ( `group_id` int(11) NOT NULL AUTO_INCREMENT, `group_name` varchar(128) NOT NULL, `description` varchar(512) DEFAULT NULL, `created_by` int(11) N...") |
|||
| Line 1: | Line 1: | ||
| − | CREATE TABLE `groups` | + | Навигация: [[Main Page|Главная страница]]/[[Система ejudge]]/[[Разработка]]/[[Схема БД пользователей]]/[[userdb:users|Таблица users]] |
| − | `group_id` int(11) NOT NULL AUTO_INCREMENT, | + | |
| + | CREATE TABLE `groups` | ||
| + | (`group_id` int(11) NOT NULL AUTO_INCREMENT, | ||
`group_name` varchar(128) NOT NULL, | `group_name` varchar(128) NOT NULL, | ||
`description` varchar(512) DEFAULT NULL, | `description` varchar(512) DEFAULT NULL, | ||
| Line 8: | Line 10: | ||
PRIMARY KEY (`group_id`), | PRIMARY KEY (`group_id`), | ||
UNIQUE KEY `group_name` (`group_name`), | UNIQUE KEY `group_name` (`group_name`), | ||
| − | KEY `created_by` (`created_by`) | + | KEY `created_by` (`created_by`)); |
| − | ) | ||
Revision as of 18:00, 25 June 2012
Навигация: Главная страница/Система ejudge/Разработка/Схема БД пользователей/Таблица users
CREATE TABLE `groups` (`group_id` int(11) NOT NULL AUTO_INCREMENT, `group_name` varchar(128) NOT NULL, `description` varchar(512) DEFAULT NULL, `created_by` int(11) NOT NULL, `create_time` datetime NOT NULL, `last_change_time` datetime DEFAULT NULL, PRIMARY KEY (`group_id`), UNIQUE KEY `group_name` (`group_name`), KEY `created_by` (`created_by`));
