Despot:Schema: Difference between revisions

Despot:Schema (view source)

Revision as of 21:02, 13 March 2007

1,409 bytes added , 13 March 2007

no edit summary

Reed

Confirmed users, Bureaucrats and Sysops emeriti

882

edits

@@ Line 1: / Line 1: @@
-== Proposed Schema (as text) ==
+== Proposed Schema ==
-partitions
+`branches`
- - id (int, auto_increment, primary key)
+  `id` mediumint(8) unsigned NOT NULL auto_increment,
- - name (varchar)
+  `name` varchar(255) NOT NULL,
- - state (enum - open, restricted, closed)
+  PRIMARY KEY  (`id`)
-  - description (mediumtext)
- - doclinks (mediumtext)
- - newsgroups (mediumtext)
- - category_id
- - private (boolean)
- * index(name)
-repositories
+`categories`
- - id (int, auto_increment, primary key)
+  `id` mediumint(8) unsigned NOT NULL auto_increment,
- - name (varchar)
+  `name` varchar(255) NOT NULL,
- - type (integer - cvs, svn, hg)
+  PRIMARY KEY  (`id`),
-  - root (varchar)
+  UNIQUE KEY `name` (`name`)
- - vouchers_req (smallint; number of vouchers needed for access)
- - sr_req (boolean; is an SR required to approve all accounts?)
- - private (boolean)
- * unique(name,type)
-branches
+`files`
- - id (int, auto_increment, primary key)
+  `partition_id` mediumint(8) unsigned NOT NULL,
- - name (varchar)
+  `repository_id` mediumint(8) unsigned NOT NULL,
- * unique(name)
+  `branch_id` mediumint(8) unsigned NOT NULL default '0',
+  `pattern` varchar(255) NOT NULL,
+  KEY `partition_id` (`partition_id`),
+  KEY `repository_id` (`repository_id`),
+  KEY `branch_id` (`branch_id`)
-files
+`members`
- - partition_id (int -> partitions)
+  `user_id` mediumint(8) unsigned NOT NULL,
- - repository_id (int -> repositories)
+  `partition_id` mediumint(8) unsigned NOT NULL,
- - branch_id (int -> branches; only used for cvs)
+  `class` smallint(1) unsigned NOT NULL default '3',
- - pattern (varchar or text)
+  UNIQUE KEY `user_id` (`user_id`,`partition_id`),
- * index(partition_id)
+  KEY `class` (`class`)
- * index(repository_id)
- * index(branch_id)
-members
+`partition_changes`
- - user_id (int)
+  `partition_id` mediumint(8) unsigned NOT NULL,
- - partition_id (int)
+  `field` varchar(255) NOT NULL,
- - class (enum - owner, peer, member)
+  `oldvalue` varchar(255) default NULL,
- * unique(user_id,partition_id)
+  `newvalue` varchar(255) default NULL,
- * index(partition_id)
+  `who` mediumint(8) unsigned NOT NULL,
- * index(class)
+  `ts` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
+  KEY `ts` (`ts`)
-users
+`partitions`
- - id (int, auto_increment, primary key)
+  `id` mediumint(9) unsigned NOT NULL auto_increment,
- - ldap_id (int; refers to LDAP account)
+  `name` varchar(255) NOT NULL,
- - disabled (boolean)
+  `state` tinyint(1) unsigned NOT NULL default '1',
- - signedform (boolean)
+  `description` text,
- - superreviewer (boolean)
+  `doclinks` mediumtext,
- - bugzilla_id (int)
+  `newsgroups` mediumtext,
- * unique(account)
+  `category_id` smallint(5) unsigned NOT NULL default '0',
-  * unique(bugzilla_id)
+  `private` tinyint(1) NOT NULL default '0',
+  PRIMARY KEY  (`id`),
-sessions
+`repositories`
- - id (varchar(255), primary key, not null, default <nowiki>''</nowiki>)
+  `id` mediumint(8) unsigned NOT NULL auto_increment,
- - data (text)
+  `name` varchar(255) NOT NULL,
-  - expires (int(11), default null)
+  `type` tinyint(3) unsigned NOT NULL,
+  `root` varchar(255) NOT NULL,
+  `vouchers_req` tinyint(3) unsigned NOT NULL default '2',
+  `sr_req` tinyint(3) unsigned NOT NULL default '1',
+  `private` tinyint(1) NOT NULL default '0',
+  PRIMARY KEY  (`id`),
+  UNIQUE KEY `name` (`name`,`type`)
-restrictions
+`repository_changes`
- - user_id (int)
+  `repository_id` mediumint(8) unsigned NOT NULL,
- - partition_id (int)
+  `field` varchar(255) NOT NULL,
- * index(user_id)
+  `oldvalue` varchar(255) default NULL,
- * index(partition_id)
+  `newvalue` varchar(255) default NULL,
+  `who` mediumint(8) unsigned NOT NULL,
+  `ts` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
+  KEY `ts` (`ts`)
-categories
+`restrictions`
- - id (int)
+  `user_id` mediumint(8) unsigned NOT NULL,
- - name (varchar)
+  `partition_id` mediumint(8) unsigned NOT NULL,
+  UNIQUE KEY `user_id` (`user_id`,`partition_id`)
-vouchers
+`sessions`
- - user_id (int)
+  `id` varchar(255) NOT NULL default '',
- - partition_id (int)
+  `data` text,
- - voucher_id (int)
+  `expires` int(11) default NULL,
- - sr (boolean)
+  PRIMARY KEY  (`id`)
- * index(user_id)
- * index(voucher_id)
-  * index(partition_id)
-user_changes
+`syncneeded`
- - user_id (int)
+  `repository_id` mediumint(8) unsigned NOT NULL,
- - field (varchar)
+  `needed` tinyint(1) NOT NULL default '0'
- - oldvalue (varchar)
- - newvalue (varchar)
- - who (int)
- - ts (timestamp)
- * index(ts)
-partition_changes
+`user_changes`
- - partition_id (int)
+  `user_id` mediumint(8) unsigned NOT NULL,
- - field (varchar)
+  `field` varchar(255) NOT NULL,
- - oldvalue (varchar)
+  `oldvalue` varchar(255) default NULL,
- - newvalue (varchar)
+  `newvalue` varchar(255) default NULL,
- - who (int)
+  `who` mediumint(8) unsigned NOT NULL,
- - ts (timestamp)
+  `ts` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
- * index(ts)
+  KEY `ts` (`ts`)
-repository_changes
+`users`
- - repository_id (int)
+  `id` mediumint(8) unsigned NOT NULL auto_increment,
- - field (varchar)
+  `ldap_id` mediumint(8) unsigned NOT NULL,
- - oldvalue (varchar)
+  `disabled` tinyint(1) NOT NULL default '0',
- - newvalue (varchar)
+  `signedform` tinyint(1) NOT NULL default '0',
- - who (int)
+  `superreviewer` tinyint(1) NOT NULL default '0',
-  - ts (timestamp)
+  `bugzilla_id` mediumint(8) unsigned default NULL,
- * index(ts)
+  `despot` tinyint(1) NOT NULL default '0',
+  `partitionlord` tinyint(1) NOT NULL default '0',
+  PRIMARY KEY  (`id`),
+  UNIQUE KEY `ldap_id` (`ldap_id`,`bugzilla_id`)
-syncneeded (is this needed now that authorizations is all handled in LDAP?)
+`vouchers`
- - needed (boolean)
+  `user_id` mediumint(8) unsigned NOT NULL,
- - repository_id (int)
+  `partition_id` mediumint(8) unsigned NOT NULL,
+  `voucher_id` mediumint(8) unsigned NOT NULL,
+  `sr` tinyint(1) NOT NULL default '0',
+  KEY `user_id` (`user_id`,`partition_id`,`voucher_id`)
 == Fields that need to be decided if they belong in LDAP or mysql ==