Skip site navigation (1)Skip section navigation (2)

FreeBSD Manual Pages

  
 
  

home | help
Sympa::DatabaseDescription(3Sympasympa 6.2.1Sympa::DatabaseDescription(3Sympa)

NAME
       Sympa::DatabaseDescription - Dafinition of core database	structure

DESCRIPTION
       This module keeps structure of database used by Sympa software.

   Functions
       full_db_struct ()
	   Function.  Returns a	heshref	containing definitions of all tables.
	   Each	item has the name of table as key and definition as value.

	   Each	definition is hashref containig	following keys:

	   fields
	       See below.

	   doc Description of the table.

	   order
	       TBD.

	   "fields" item is hasref which may contain following items.

	   struct
	       Column data types.  Definitions are based on MySQL.  Following
	       types are recognized:

	       varchar(length)
		   Text	with length upto length.  length must be lower than
		   2^16	- 2.

	       int(1)
		   Boolean, 1 or 0.

	       int(11)
		   Unix	time.

	       int(cols)
		   Integer with	columns	upto cols, with	its value from -2^31
		   to 2^31 - 1.

	       tinyint
		   Integer, -2^7 to 2^7	- 1.

	       smallint
		   Integer, -2^15 to 2^15 - 1.

	       bigint
		   Integer, -2^63 to 2^63 - 1.

	       double
		   IEEE	floating point number, 8 bytes.

	       enum
		   Keyword with	length upto 20 o.

	       text
		   Text	with length upto 500 o.

	       longtext
		   Text	with length upto 2^32 -	4 o.

	       datetime
		   Timestamp.

	       mediumblob
		   Binary data with length upto	2^24 - 3 o.

	   doc Description of the field.

	   primary
	       If this is true,	primary	key consists of	this field.

	   not_null
	       If this is true,	Null value is not allowed.  Note that fields
	       included	in primary key always don't allow Null value.

       db_struct ()
	   This	function was OBSOLETED.

       not_null	()
	   Function.  TBD.

       autoincrement ()
	   Function.  TBD.

       primary ()
	   Function.  TBD.

SEE ALSO
       sympa_database(5), Sympa::DatabaseManager.

HISTORY
       Sympa::DatabaseDescription was introduced behind	the veil on Sympa 6.1.
       It began	to be referred overtly as a part of Sympa Database Manager
       (SDM) on	Sympa 6.2.

6.2.16				  2016-05-18Sympa::DatabaseDescription(3Sympa)

NAME | DESCRIPTION | SEE ALSO | HISTORY

Want to link to this manual page? Use this URL:
<https://www.freebsd.org/cgi/man.cgi?query=Sympa::DatabaseDescription&sektion=3sympa&manpath=FreeBSD+12.1-RELEASE+and+Ports>

home | help