Userdb:groups

From EjudgeWiki
Revision as of 17:57, 25 June 2012 by Vk (talk | contribs) (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...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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`)

)