GSP
Quick Navigator

Search Site

Unix VPS
A - Starter
B - Basic
C - Preferred
D - Commercial
MPS - Dedicated
Previous VPSs
* Sign Up! *

Support
Contact Us
Online Help
Handbooks
Domain Status
Man Pages

FAQ
Virtual Servers
Pricing
Billing
Technical

Network
Facilities
Connectivity
Topology Map

Miscellaneous
Server Agreement
Year 2038
Credits
 

USA Flag

 

 

Man Pages


Manual Reference Pages  -  SYMPA::DATABASEDESCRIPTION (3)

.ds Aq ’

NAME

Sympa::DatabaseDescription - Dafinition of core database structure

CONTENTS

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.
Search for    or go to Top of page |  Section 3 |  Main Index


6.2.14 SYMPA::DATABASEDESCRIPTION (3Sympa) 2016-01-06

Powered by GSP Visit the GSP FreeBSD Man Page Interface.
Output converted with manServer 1.07.