[glotpress-updates] [GlotPress] #97: Glossary

[GlotPress]

#97: Glossary
--------------------------+----------------------
  Reporter:  nbachiyski   |      Owner:  yoavf
      Type:  enhancement  |     Status:  assigned
  Priority:  minor        |  Milestone:  1.0
 Component:  general      |    Version:
Resolution:               |   Keywords:
--------------------------+----------------------

Comment (by yoavf):

 Current tables structures
 {{{
 CREATE TABLE IF NOT EXISTS `gp_glossary_entries` (
   `id` int(10) NOT NULL AUTO_INCREMENT,
   `glossary_id` int(10) NOT NULL,
   `term` varchar(255) NOT NULL,
   `part_of_speech` varchar(255) DEFAULT NULL,
   `comment` text,
   `translation` varchar(255) DEFAULT NULL,
   `date_modified` datetime DEFAULT NULL,
   `last_edited_by` bigint(20) NOT NULL,
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 ;
 }}}

 {{{
 CREATE TABLE IF NOT EXISTS `gp_glossaries` (
   `id` int(10) NOT NULL AUTO_INCREMENT,
   `translation_set_id` int(10) NOT NULL,
   `parent_glossary_id` int(10) DEFAULT NULL,
   `description` text,
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB  DEFAULT CHARSET=utf8  ;
 }}}

--
Ticket URL: <https://glotpress.trac.wordpress.org/ticket/97#comment:14>
GlotPress <https://glotpress.trac.wordpress.org>
Easy comin', easy goin'