Platon Technologies
not logged in Login Registration
EnglishSlovak
open source software development celebrating 10 years of open source development! Friday, March 29, 2024

File: [Platon] / phpMyEdit / comprehensive / comprehensive.sql (download)

Revision 1.1, Wed Jul 31 15:43:48 2002 UTC (21 years, 8 months ago) by nepto

phpMyEdit project imported into CVS (see http://phpmyedit.sf.net/).

# useful for debugging

DROP TABLE IF EXISTS comprehensive;

CREATE TABLE comprehensive (
xtinyint         TINYINT DEFAULT 0,
xtinyint_u       TINYINT UNSIGNED DEFAULT 0,
xtinyint_z       TINYINT ZEROFILL DEFAULT 0,
xtinyint_u_z     TINYINT UNSIGNED ZEROFILL DEFAULT 0,
xsmallint        SMALLINT DEFAULT 0,
xsmallint_u      SMALLINT UNSIGNED DEFAULT 0,
xsmallint_z      SMALLINT ZEROFILL DEFAULT 0,
xsmallint_u_z    SMALLINT UNSIGNED ZEROFILL DEFAULT 0,
xmediumint       MEDIUMINT DEFAULT 0,
xmediumint_u     MEDIUMINT UNSIGNED DEFAULT 0,
xmediumint_z     MEDIUMINT ZEROFILL DEFAULT 0,
xmediumint_u_z   MEDIUMINT UNSIGNED ZEROFILL DEFAULT 0,
xint     int     NOT NULL DEFAULT 0,
xint_u   int     UNSIGNED DEFAULT 0,
xint_z   int     ZEROFILL DEFAULT 0,
xint_u_z int     UNSIGNED ZEROFILL DEFAULT 0,
xinteger         INTEGER DEFAULT 0,
xinteger_u       INTEGER UNSIGNED DEFAULT 0,
xinteger_z       INTEGER ZEROFILL DEFAULT 0,
xinteger_u_z     INTEGER UNSIGNED ZEROFILL DEFAULT 0,
xbigint          BIGINT DEFAULT 0,
xbigint_u        BIGINT UNSIGNED DEFAULT 0,
xbigint_z        BIGINT ZEROFILL DEFAULT 0,
xbigint_u_z      BIGINT UNSIGNED ZEROFILL DEFAULT 0,
xfloat1          FLOAT(24) DEFAULT 0,
xfloat1_z        FLOAT(24) ZEROFILL DEFAULT 0.00,
xfloat2          FLOAT(10,24) DEFAULT 0,
xfloat2_z        FLOAT(10,24) ZEROFILL DEFAULT 0.00,
xdouble2         DOUBLE(10,24) DEFAULT 0,
xdouble2_z       DOUBLE(10,24) ZEROFILL DEFAULT 0.00,
xreal2           REAL(10,24) DEFAULT 0,
xreal2_z         REAL(10,24) ZEROFILL DEFAULT 0.00,
xdecimal2        DECIMAL(10,24) DEFAULT 0,
xdecimal2_z      DECIMAL(10,24) ZEROFILL DEFAULT 0.00,
xnumeric2        NUMERIC(10,24) DEFAULT 0,
xnumeric2_z      NUMERIC(10,24) ZEROFILL DEFAULT 0.00,
xdate            DATE,
xdatetime        DATETIME,
xtimestamp2      TIMESTAMP(2) ,
xtimestamp4      TIMESTAMP(4) ,
xtimestamp6      TIMESTAMP(6) ,
xtimestamp8      TIMESTAMP(8) ,
xtimestamp10     TIMESTAMP(10),
xtimestamp12     TIMESTAMP(12),
xtimestamp14     TIMESTAMP(14),
xtime            TIME,
xyear            YEAR,
xchar1           CHAR(1),
xchar255         CHAR(255) BINARY,
xbit             BIT,
xbool            BOOL,
xchar            CHAR,
xvarchar1        VARCHAR(1),
xvarchar255      VARCHAR(255),
xtinytext        TINYTEXT,
xblob            BLOB,
xtext            TEXT,
xmediumblob      MEDIUMBLOB,
xmediumtext      MEDIUMTEXT,
xlongblob        LONGBLOB,
xlongtext        LONGTEXT,
xenum            ENUM('enum1','enum2','enum3'),
xset             SET('set0','set1','set2')
);


Platon Group <platon@platon.org> http://platon.org/
Copyright © 2002-2006 Platon Group
Site powered by Metafox CMS
Go to Top