Shema
Groups & menus
Data types
Databases

  

Shema(SVG)

Groups & menus

Groups

1 1 Super User


2 Manager Group of managers
The group of managers can define data in the database and work on the programs

3 Developer Group of developers
The group of developpers can work on the programs

Menus/groups
CodeToolTip Function Group 1
Super		 Group 2
Manager		 Group 3
Developer
1List of tasks to do ordered by priority5368
2Request list5403
3Function list5405
5Table list5512
6Data type list5514
4Menu list5406
7Database list5511
10Project list5538
8Source file list5515
11Manual documentation list5939
9List of the messages to display5516
12Language dictionnary5704
13Properties6036
14Tools and utilities5850
100My Test5522
1001Profile4010
15Switch function call view5404
Data types


ID BIGINT AUTO_INCREMENT
This field is usually used to give a uniq number to a record.


Flag FLAG NOT NULL
It's a true/false or a YES/NO field.
It appears as a Checkbox in MyPitSelf


User BIGINT NOT NULL
It's the actual user reference
As every user loggin in has a user unique reference, this value contains this reference.


BigIntUnsigned BIGINT NOT NULL
As every table contains a field which is an unique ID,
a field refering to a row of an other table has this type.


Char64 CHAR NOT NULL
A 64 characters field
size : 64

BLOB BLOB NOT NULL
A long text


Char32 CHAR NOT NULL
A 32 characters field
size : 32

Char255 CHAR NOT NULL
A 255 characters field
size : 255

DateTime DATETIME NOT NULL
The current date and time
See the use in the todo list


Char64NotVoid CHAR NOT NULL
A 64 characters field which is checked to not be void
size : 64

Char8 CHAR NOT NULL
A 8 characters field
size : 8

DateTodayOrFuture DATE NOT NULL
A date which must be future
When this field is used in a table and the content of this field has to be created/updated, a window pops up where you can click on buttons to enter a date.


DateToday DATE NOT NULL
A date


Password CHAR NOT NULL
A 32 characters field that shows * instead od the characters entered
It can't be void.
size : 32

Char32NotVoid CHAR NOT NULL
A 32 characters field which is checked to not be void
size : 32

PositiveMoney17.2 DECIMAL NOT NULL

size : 17 including 2 position for the decimal part

PositiveMoney19.4 DECIMAL NOT NULL

size : 19 including 4 position for the decimal part

PositiveQuantity17.2 DECIMAL NOT NULL

size : 17 including 2 position for the decimal part

Time TIME NOT NULL



BigIntNSNotZero BIGINT NOT NULL
Same as BigIntUnsigned except that it can't be null.
This is because some cross references to some tables MUST be filled


TEXT TEXT NOT NULL
A long text


Button CHAR NOT NULL
The image of a button for a list function. . is void
size : 32

mypsFckHtml1 HTML NOT NULL
A long text


Double DOUBLE NOT NULL



TimeStamp TIMESTAMP NOT NULL



Char255NotVoid CHAR NOT NULL
A 255 characters field which is checked to not be void
size : 255

FileName CHAR NOT NULL

size : 128

UserGroup ENUM NOT NULL


Possible values are
Group:0
Super:1
Manager:2
Developper:3

Login CHAR NOT NULL

size : 64

MediumText MEDIUMTEXT NOT NULL
A medium text


Priority INTEGER NOT NULL
The priority in the ToDo list must be between 0 and 99 included.


FlagRepeat FLAG NOT NULL
Keep this in order to make the batch list worrk in other environments


FieldSpec ENUM NOT NULL
A complementary specification for data type

Possible values are
NOT NULL:NOT NULL
VOID:
AUTO_INCREMENT:AUTO_INCREMENT

SqlOperation ENUM NOT NULL
Types of Sql operations that are admitted on SQL requests in the WHERE statement.
Contains does a translation in lowercase, and does a like %xxxxx% comparison.

Possible values are
=:=
CONTAINS:CONTAINS
>=:>=
<=:<=
>:>
<:<
<>:<>
LIKE:LIKE
PLIKE:PLIKE
LIKEP:LIKEP
PLIKEP:PLIKEP
IN:IN

SqlOrder ENUM NOT NULL
Ascending or descending

Possible values are
ASC:ASC
DESC:DESC

FunctionType ENUM NOT NULL
List of the types of functions that can be created:

LISTFUNCT are for functions attach to requests that display datas on the screen used with a0_List and a0_Screen functions. They appear on the left of each line of datas of the list.
LISTTOP are for functions attach to requests that display datas on the screen used with a0_List function. They appear just at the top of the list and can use the parameters of the requests.

LISTMENU are for functions attach to requests that display datas on the screen used with a0_List function. They appear over the list and are usually shortcuts to other lists.

MYPITSELF are for functions NOT attach to any requests.

DATATEST are for functions attach to certain datatypes that must be tested.

TABLETEST are for functions attach to certain tables that must be tested.

XREF are for functions attach to fields of tables that refer to other fields.

MENU are for functions attach menus entries definitions in the menu table.


Possible values are
MyPS:MYPITSELF
ListF:LISTFUNCT
ListTop:LISTTOP
ListMenu:LISTMENU
DataTest:DATATEST
TableTest:TABLETEST
XRef:XREF
Menu:MENU

Request Type ENUM NOT NULL
The request type defines the type of request that is generated.
As in MyPitSelf, a request is defined by three tables ( yRequest = definition of the request, yRequestTable = tables of the request and yRequestFields = fields of the request ), the SQL order generated depends of this Request type.
SELECT, DELETE, INSERT, UPDATE are used for SELECT, DELETE, INSERT, UPDATE request
MANUAL is used for request that can't be defined by MyPitSelf. To use that type, you have to create a "normal" SELECT request then to change the request type to MANUAL and to write manually the request.
SELECT LIST is used for defining the screens that display lists of values
SELECT VALUE is used for defining the screens to update/see/duplicate a table entry with the ID code


Possible values are
SELECT:SELECT
UPDATE:UPDATE
INSERT:INSERT
DELETE:DELETE
SELECT LIST:SELECT LIST
SELECT VALUE:SELECT VALUE
DELETE VALUE:DELETE VALUE
MANUAL:MANUAL

TableName CHAR NOT NULL
A table name must be on 32 characters , can't be void and must contain only valid characters ( a-z , A-Z, 0-9 )
size : 64

xRefBase BIGINT NOT NULL



Char32Sql CHAR NOT NULL

size : 32

SourceType ENUM NOT NULL


Possible values are
WEB:WEB
INCLUDE:INCLUDE
CORE:CORE
DOC:DOC

PositiveNumber0_9 CHAR NOT NULL

size : 1

PositiveNumber00_99 CHAR NOT NULL

size : 2

PositiveNumber000_999 CHAR NOT NULL

size : 3

DocTag CHAR NOT NULL
A 64 characters field which is checked to not be void and the authorized are in a-z, A-Z, 0-9
size : 64

PositiveNumber1_5 CHAR NOT NULL

size : 1

DataType ENUM NOT NULL
The list of datatypes one can find in MySql.
Not all of them are represented

Possible values are
BIGINT:BIGINT
BLOB:BLOB
CHAR:CHAR
DATE:DATE
DATETIME:DATETIME
DECIMAL:DECIMAL
DOUBLE:DOUBLE
ENUM:ENUM
FLAG:FLAG
FLOAT:FLOAT
HTML:HTML
INTEGER:INTEGER
MPS:MPS
TEXT:TEXT
MEDIUMTEXT:MEDIUMTEXT
LONGTEXT:LONGTEXT
TIME:TIME
TIMESTAMP:TIMESTAMP

NumberOfFieldsInTable DECIMAL NOT NULL

size : 5 including 0 position for the decimal part

RequestTypeScreen ENUM NOT NULL


Possible values are
UPDATE:UPDATE
INSERT:INSERT

BigIntSigned BIGINT NOT NULL



MPS MPS NOT NULL
Mps source


NumericalProperty BIGINT NOT NULL



TextProperty CHAR NOT NULL
A 32 characters field
size : 32

FlagProperty FLAG NOT NULL



PropertyList ENUM NOT NULL


Possible values are
List Option Column width:12
List BR After this function:11
List CELLPADDING:15
List Do not put in a table:16
List Param Use data type number:10
List Line height:13
List Display GoTo buttons:14
List Line function:17
List Header function:18
List NoMenu:24
List Function to call before:25
List Function to call after:26
List Menu to highlight:28
List Is Sub Select:31
List Repeat the next button at the end:33
List No counter:44
List Cell spacing list: 1 is default:48
List Field - Column width:1
List Field - box width for filter:30
List Field - Do not display the day in the list:46
List Field - Do not display the BR in the date of the line:47
Request LIST LIMIT:8
Request SELECT DISTINCT:7
Request use Count(*):19
Request Limit params:20
Request Field - GROUP BY:51
Request Field - SUM:52
Request Field - AND field =:53
Function Hide debug call:9
Function Is recursive:50
Function X Position of the sub window:40
Function Y Position of the sub window:41
Function X width of the sub window:42
Function Y width of the sub window:43
Without thousand separator:55
LISTTOP x position for listtop sub window:35
LISTTOP y position for listtop sub window:36
LISTTOP x width for listtop sub window:37
LISTTOP y width for listtop sub window:38
Screen Before data:3
Screen After data:4
Screen Before header:5
Screen After header:6
Screen Apply button:21
Screen ScreenAfter:22
Screen CancelFunction:23
Screen View only, No update, create, apply or duplicate:39
Screen Function to call under the screen:27
Screen may be called with replacement values:45
Screen Border style for cells:49
Screen Field - Show the reference on the value:32
UPDATE myTable set `Field`=`Field`:34

Language list ENUM NOT NULL


Possible values are
Indéfini:0
Français (France):2
English (US):1

SvgTableWidth INTEGER NOT NULL



xmlType ENUM NOT NULL


Possible values are
Root:0
xmlElement:1
xmlAttribut:2
SeqFileSep:3
SeqFileSep02:4
SeqFileSep03:5

xmlTypeRootOrElement ENUM NOT NULL


Possible values are
Root:0
Element:1
SeqFileElement:3

xmlTypeElementOrAttribut ENUM NOT NULL


Possible values are
Element:1
Attribut:2
SeqFileType3:3
SeqFileType4:4

Int INTEGER NOT NULL



ScreenPosition INTEGER NOT NULL



cssElementType ENUM NOT NULL


Possible values are
Root:0
File name:2
Class name:3
Rule name:4

cssElementName ENUM NOT NULL


Possible values are
background-color:6242-1
background:6242-2
color:6242-3
font-size:6243-1
font-family:6127-1
scrollbar-base-color:6242-4
scrollbar-arrow-color:6242-5
border:6243-2
border-top-color:6242-6
border-top-style:6264-1
border-top-width:6243-3
border-right-color:6242-7
border-right-style:6264-2
border-right-width:6243-4
border-bottom-color:6242-8
border-bottom-style:6264-3
border-bottom-width:6243-5
border-left-color:6242-9
border-left-style:6264-4
border-left-width:6243-6
padding:6243-7
padding-top:6243-8
padding-right:6243-9
padding-bottom:6243-10
padding-left:6243-11
text-decoration:6265-1
display:6293-1
list-style:6272-1
text-align:6298-1
font-weight:6271-1
line-height:6243-12
margin:6243-13
margin-top:6243-14
margin-right:6243-15
margin-bottom:6243-16
margin-left:6243-17
visibility:6299-1
white-space:5886-1

cssBrowser ENUM NOT NULL


Possible values are
Ie and Firefox:1
Ie only:2
Firefox only:3

cssRuleType ENUM NOT NULL


Possible values are
color:6242
size:6243
font-family:6127
border-style:6264
text-decoration:6265
display:6293
list-style:6272
text-align:6298
font-weight:6271
visibility:6299
white-space:5886

selectHeigh INTEGER NOT NULL



languageCode_2 CHAR NOT NULL

size : 2

CharSet ENUM NOT NULL


Possible values are
NONE:NONE
utf8 UTF-8 Unicode:utf8
latin1 cp1252 West European:latin1
armscii8 ARMSCII-8 Armenian:armscii8
ascii US ASCII:ascii
big5 Big5 Traditional Chinese:big5
binary Binary pseudo charset:binary
cp1250 Windows Central European:cp1250
cp1251 Windows Cyrillic:cp1251
cp1256 Windows Arabic:cp1256
cp1257 Windows Baltic:cp1257
cp850 DOS West European:cp850
cp852 DOS Central European:cp852
cp866 DOS Russian:cp866
cp932 SJIS for Windows Japanese:cp932
dec8 DEC West European:dec8
eucjpms UJIS for Windows Japanese:eucjpms
euckr EUC-KR Korean:euckr
gb2312 GB2312 Simplified Chinese:gb2312
gbk GBK Simplified Chinese:gbk
geostd8 GEOSTD8 Georgian:geostd8
greek ISO 8859-7 Greek:greek
hebrew ISO 8859-8 Hebrew:hebrew
hp8 HP West European:hp8
keybcs2 DOS Kamenicky Czech-Slovak:keybcs2
koi8r KOI8-R Relcom Russian:koi8r
koi8u KOI8-U Ukrainian:koi8u
latin2 ISO 8859-2 Central European:latin2
latin5 ISO 8859-9 Turkish:latin5
latin7 ISO 8859-13 Baltic:latin7
macce Mac Central European:macce
macroman Mac West European:macroman
sjis Shift-JIS Japanese:sjis
swe7 7bit Swedish:swe7
tis620 TIS620 Thai:tis620
ucs2 UCS-2 Unicode:ucs2
ujis EUC-JP Japanese:ujis
Databases

 
 xxDatB
MyPitSelf is done to build programs. All the programs done with MyPitSelf have a system DB.
This database contains the system DB of the programs.

As MyPitSelf is done with itself, When one develops MyPitSelf, physically, the data db is the same as the system db.

The tables defined in this database are:

  yTest
This is a table for my tests while I develop MyPitSelf.

   
   ID , Type = ID
   
   Text , Type = TEXT
   
   liste , Type = DataType
   
   TheFlag , Type = Flag
   
   date , Type = DateTodayOrFuture
   
   Priority , Type = Priority
   
   Text32 , Type = Char32
   
   xRefToMe , Type = BigIntUnsigned
   
   Quantity , Type = PositiveQuantity17.2
   
   DblQt , Type = Double
   
   TestTime , Type = Time
   
   Tag , Type = DocTag
   
   MyHtml , Type = mypsFckHtml1
   
   Date_Time_Test , Type = DateTime
   
   TsTest , Type = TimeStamp
  yData
Contains the data definitions according to the database types.

When you will create a program, some data types will be already inserted in the environment.
They come from The MyPitSelf main environment.

   
   Code , Type = ID
   
   Name , Type = Char32
   
   DataType , Type = DataType
   
   xRefEnum , Type = BigIntUnsigned
   
   NotSigned , Type = Flag
   
   DataSize , Type = BigIntUnsigned
   
   DecimalSize , Type = BigIntUnsigned
   
   Complementary , Type = FieldSpec
   
   TreatQuotes , Type = Flag
   
   Comment , Type = TEXT
   
   Doc , Type = TEXT
   
   User , Type = User
   
   DefaultValue , Type = Char255
   
   TestJavaScript , Type = TEXT
   
   PasswordType , Type = Flag
   
   TextForJSError , Type = Char255
   
   xRefTestFunction , Type = BigIntUnsigned
  yEnv
Contains the environment definition.
In MyPitSelf, an environment is a series of databases and a set of constants and the program is done with these datas ans databases.

MyPitSelf is a program to build new environments

   
   Code , Type = ID
   
   Name , Type = Char64NotVoid
   
   SystemDB , Type = Char32
   
   SysConn , Type = Char64
   
   SysUser , Type = Char64
   
   SysPass , Type = Char64
   
   IsNewMyps , Type = Flag
   
   Version , Type = PositiveNumber00_99
   
   SubVersion , Type = PositiveNumber0_9
   
   MinorVersion , Type = PositiveNumber00_99
   
   Doc , Type = TEXT
   
   IsHidden , Type = Flag
   
   IsBuilt , Type = Flag
   
   HasLock , Type = Flag
   
   HasUser , Type = Flag
   
   IsMonoBase , Type = Flag
   
   IsMonoLang , Type = Flag
  yBase
The database definitions that are used in an environment.

Usually there is only one database but you can also work with several local or distant databases

   
   Code , Type = ID
   
   Name , Type = Char32Sql
   
   Doc , Type = TEXT
   
   User , Type = User
   
   Mandatory , Type = Flag
   
   xRefCollation , Type = BigIntNSNotZero
  yEnvBase
Contains the bases attached to the environment.
When you work with MyPitSelf, the system database is the main MyPitself database but you fill the system database of the program you build.
So in that case, you work with two databases


   
   Code , Type = ID
   
   xRefEnv , Type = BigIntNSNotZero
   
   xRefBase , Type = BigIntNSNotZero
   
   PhysicalName , Type = Char32
   
   DBConn , Type = Char64
   
   DBUser , Type = Char64
   
   DBPass , Type = Char64
  yTable
Contains the table definitions attached to databases

   
   Code , Type = ID
   
   xRefBase , Type = xRefBase
   
   Name , Type = TableName
   
   ListOrder , Type = BigIntUnsigned
   
   Doc , Type = TEXT
   
   User , Type = User
   
   xRefTestFunction , Type = BigIntUnsigned
   
   NumberOfFields , Type = NumberOfFieldsInTable
   
   PosTop , Type = ScreenPosition
   
   PosLeft , Type = ScreenPosition
   
   Height , Type = ScreenPosition
   
   Width , Type = SvgTableWidth
   
   KeyMessage , Type = Char64
  yField
Contains the field definitions of each table

   
   Code , Type = ID
   
   Name , Type = TableName
   
   xRefTable , Type = BigIntUnsigned
   
   xRefData , Type = BigIntUnsigned
   
   ListOrder , Type = BigIntUnsigned
   
   xRefField , Type = BigIntUnsigned
   
   Doc , Type = TEXT
   
   User , Type = User
   
   International , Type = Flag
   
   IsPrimaryKey , Type = Flag
   
   xRefDisplayField , Type = BigIntUnsigned
   
   LinkOnRight , Type = Flag
   
   LinkOnLeft , Type = Flag
   
   xMid1 , Type = ScreenPosition
   
   yMid1 , Type = ScreenPosition
   
   FunctionForXref , Type = BigIntUnsigned
  yIndex
Contains the indexes of each table

   
   Code , Type = ID
   
   Name , Type = Char32
   
   IsUnique , Type = Flag
   
   Doc , Type = TEXT
   
   ErrorText , Type = Char255
   
   xRefTable , Type = BigIntUnsigned
  yIdxFld
Contains the fields of the indexes

   
   xRefIndex , Type = BigIntUnsigned
   
   ListOrder , Type = BigIntUnsigned
   
   SqlOrder , Type = SqlOrder
   
   xRefField , Type = BigIntUnsigned
  yRequest
Contains the request definition to generate an SQL statement.

   
   Code , Type = ID
   
   Type , Type = Request Type
   
   Name , Type = Char255
   
   ArgCount , Type = BigIntUnsigned
   
   xRefTable , Type = BigIntUnsigned
   
   Request , Type = TEXT
   
   php , Type = TEXT
  yReqTbl
Contains the tables that are part of the request

   
   Code , Type = ID
   
   xRefSelect , Type = BigIntUnsigned
   
   xRefTable , Type = BigIntUnsigned
   
   Ref , Type = Char8
  yReqFld
Contains the fields of the request

   
   Code , Type = ID
   
   OrderList , Type = BigIntUnsigned
   
   xRefField , Type = BigIntUnsigned
   
   xRefSelect , Type = BigIntUnsigned
   
   OutputOrder , Type = BigIntUnsigned
   
   OrderByOrder , Type = BigIntUnsigned
   
   AscOrder , Type = SqlOrder
   
   FieldToLink , Type = BigIntUnsigned
   
   LinkRef , Type = Char8
   
   ParamOrder , Type = BigIntUnsigned
   
   ParamType , Type = SqlOperation
   
   ParamText , Type = Char64
   
   Ref , Type = Char8
   
   Header , Type = Char32
   
   Constant , Type = Flag
   
   Hidden , Type = Flag
  yTodo
Contains the tasks to do for each user

I use it like this:
I give a priority 99 for something finished
I give a priority 50 for a global theme i should think about soon
I give a priority 98 for concepts , ideas , text ....
I give a priority 0 to 50 for current tasks with a priority = 0 for the current task.

When I want do do something new ( task A ), I usually have to do other things before, I use the button "add 1 to priority less than 50" on the top of the list and a put the subtask ( task B ) with a priority = 0.
When the task B is finished, I give to it a priority = 99 and I use the button "sub 1 to priority less than 50" so that task A comes back with priority 0.



   
   Code , Type = ID
   
   Priority , Type = Priority
   
   Name , Type = TEXT
   
   User , Type = User
   
   TSCreate , Type = DateTime
   
   TSUpdate , Type = DateTime
  ySource
Contains some sources in various forms to be written directly on the server.

   
   Code , Type = ID
   
   Type , Type = SourceType
   
   Name , Type = Char64
   
   Source , Type = MediumText
  yMsg
Contains some messages to display.
The messages can be then called with the Display() or the ShowMsg functions.

The dictionary contains the localisation values of the messages.

   
   Code , Type = ID
   
   Text , Type = TEXT
  yFunction
Contains the MyPitSelf Functions.
MyPitSelf is mainly written in the MyPitSelf language.

   
   Code , Type = ID
   
   Name , Type = Char64NotVoid
   
   Type , Type = FunctionType
   
   xRefSelect , Type = BigIntUnsigned
   
   ListOrder , Type = BigIntUnsigned
   
   Short , Type = Char32
   
   Source , Type = MPS
   
   User , Type = User
   
   sub , Type = Flag
   
   ImageButton , Type = Button
   
   Ts , Type = TimeStamp
   
   ParamCount , Type = Int
  yMainMenu
Contains the menus definitions.

   
   Code , Type = ID
   
   ToolTip , Type = Char64NotVoid
   
   ListOrder , Type = BigIntUnsigned
   
   LongName , Type = Char32NotVoid
   
   Doc , Type = TEXT
   
   User , Type = User
   
   IsNotForSuper , Type = Flag
   
   ForGroup , Type = Char32
   
   IsForMyPs , Type = Flag
   
   Image , Type = Char32
   
   xRefFunction , Type = BigIntNSNotZero
  yTableEnv
Contains the list of tables by environment.

   
   Code , Type = ID
   
   xRefEnvBase , Type = BigIntUnsigned
   
   xRefTable , Type = BigIntUnsigned
  yUser
Contains the user list
In Mypitself, it also contains the list of the groups.

   
   Code , Type = ID
   
   Name , Type = Login
   
   PassWord , Type = Password
   
   FirstName , Type = Char64
   
   LastName , Type = Char64
   
   Comment , Type = TEXT
   
   xRefUser , Type = UserGroup
   
   IsGroup , Type = Flag
   
   IsActive , Type = Flag
  yLock
Optionnaly, when a user updates a record, the locking informations to stop others users go there.
This table is used in the developpement environment ( flag is developper = 1 ) and in the user environment ( flag is developper = 0 )

   
   TableCode , Type = BigIntUnsigned
   
   FieldCode , Type = Char255
   
   UserCode , Type = BigIntUnsigned
   
   Text , Type = Char255
  yEnvUser
Contains the list of environments where a user can work.

   
   Code , Type = ID
   
   xRefUser , Type = BigIntUnsigned
   
   xRefEnv , Type = BigIntUnsigned
   
   ListOrder , Type = BigIntUnsigned
  yAuth
Contains the list of menus for each group of users

   
   xRefUser , Type = BigIntNSNotZero
   
   xRefMenu , Type = BigIntNSNotZero
  yDoc
This tables contain the documentation text for the manual documentation.

The text of the documentation only exist in the dictionnary ( localisation )

An automatic documentation done with informations entered by the programmer is also generated ( that is the part you are reading ).

   
   Code , Type = ID
   
   IsNotPrinted , Type = Flag
   
   xRefParent , Type = BigIntUnsigned
   
   Pos , Type = BigIntUnsigned
   
   GroupList , Type = Char255
  yRecord
Contains the source code recorded when a sequence of actions are recorded.

   
   Code , Type = ID
   
   TS , Type = DateTime
   
   Name , Type = Char64
   
   Source , Type = MPS
   
   JavaScript , Type = Flag
   
   User , Type = User
   
   IsDevelopper , Type = Flag
  yMyPitSelf
Contains the various versions of MyPitSelf for migration purposes.

   
   Code , Type = ID
   
   Version , Type = PositiveNumber00_99
   
   SubVersion , Type = PositiveNumber0_9
   
   MinorVersion , Type = PositiveNumber00_99
  yMigration
Information for the migration function to apply to import an environment from an old version.

   
   Code , Type = ID
   
   OldVersion , Type = Char64NotVoid
   
   NewVersion , Type = Char64NotVoid
   
   xRefFunction , Type = BigIntUnsigned
  yLanguage
Languages defined for each environment

   
   Code , Type = ID
   
   Name , Type = Char64NotVoid
   
   xRefEnv , Type = BigIntNSNotZero
   
   IsInstalled , Type = Flag
   
   Charset , Type = Char64NotVoid
   
   IsDefault , Type = Flag
   
   shortCode , Type = languageCode_2
  yDictionary
Dictionnary for all languages: contains the translated sentences that can be seen on the screen

   
   Code , Type = ID
   
   xRefLanguage , Type = BigIntNSNotZero
   
   xRefFieldRef , Type = BigIntNSNotZero
   
   xRefCode , Type = BigIntNSNotZero
   
   Value , Type = TEXT
   
   Comment , Type = Char255
   
   xRefParent , Type = BigIntUnsigned
  yBatch
Informations about the batch jobs.

   
   Code , Type = ID
   
   xRefUser , Type = BigIntUnsigned
   
   IsDevelopper , Type = Flag
   
   IsFinished , Type = Flag
   
   IsOK , Type = Flag
   
   Name , Type = Char64NotVoid
   
   FileName , Type = Char255
   
   TS , Type = TimeStamp
  yRev
Contains the table view of a source for treatment

   
   Code , Type = ID
   
   xRefUser , Type = BigIntNSNotZero
   
   IsDevelopper , Type = Flag
   
   FunctionNumber , Type = BigIntUnsigned
   
   ParentNumber , Type = BigIntSigned
   
   OrderInParent , Type = BigIntUnsigned
   
   FunctionName , Type = Char255
   
   FunctionType , Type = Char32
   
   NumberOfChildren , Type = BigIntUnsigned
   
   Level , Type = BigIntUnsigned
   
   C1 , Type = TEXT
   
   C2 , Type = TEXT
  yPropDef
Definitions of the properties

   
   Code , Type = ID
   
   Name , Type = Char64NotVoid
   
   xRefTable , Type = BigIntNSNotZero
   
   xRefRefTable , Type = BigIntUnsigned
   
   xRefDataTypeProp , Type = BigIntNSNotZero
   
   ShortName , Type = Char32Sql
   
   International , Type = Flag
   
   Comment , Type = TEXT
   
   OrderList , Type = BigIntUnsigned
   
   xRefTestFunction , Type = BigIntNSNotZero
   
   xRefRefFunction , Type = BigIntUnsigned
  yProperty
Values of the properties

   
   xRefPropDef , Type = BigIntNSNotZero
   
   xRefField , Type = BigIntNSNotZero
   
   xRefLang , Type = BigIntUnsigned
   
   Value , Type = TEXT
  yEnum
List of enum types

   
   Code , Type = ID
   
   Name , Type = Char64NotVoid
   
   xRefDataType , Type = BigIntNSNotZero
   
   SelectHeight , Type = selectHeigh
  yEnumList
Values of enum types

   
   Code , Type = ID
   
   Name , Type = Char64NotVoid
   
   Value , Type = TEXT
   
   xRefEnum , Type = BigIntNSNotZero
   
   Position , Type = BigIntNSNotZero
  yFile
Contains the structure of the files to be treated. The files can be XML or sequential.

   
   Code , Type = ID
   
   Tag , Type = Char255NotVoid
   
   xRefParentXml , Type = BigIntNSNotZero
   
   Position , Type = BigIntUnsigned
   
   Type , Type = xmlType
   
   Separator , Type = Char255
   
   xRefDataType , Type = BigIntUnsigned
  yCssFile


   
   Code , Type = ID
   
   Name , Type = Char64NotVoid
   
   xRefParent , Type = BigIntNSNotZero
   
   Position , Type = BigIntUnsigned
   
   Type , Type = cssElementType
   
   HTMLName , Type = Char32
   
   Hover , Type = Flag
   
   xRef0Class , Type = BigIntNSNotZero
  yCssClass


   
   xRefCssFile , Type = BigIntNSNotZero
   
   Name , Type = cssElementName
   
   Position , Type = BigIntUnsigned
   
   xRef0Class , Type = BigIntNSNotZero
   
   cssBrowser , Type = cssBrowser
   
   xRefValue , Type = BigIntNSNotZero
   
   xRefxRefCssFile , Type = BigIntUnsigned
   
   xRefName , Type = cssElementName
  yCssValue


   
   Code , Type = ID
   
   RuleType , Type = cssRuleType
   
   Name , Type = Char64NotVoid
   
   Name2 , Type = Char64
   
   Dimension , Type = Char32
   
   Comment , Type = Char64
   
   Position , Type = BigIntUnsigned
   
   Comp , Type = Char32
  yCollation
Collation for database

   
   Code , Type = ID
   
   Collation , Type = Char64NotVoid
   
   CharSet , Type = CharSet
   
   mySqlId , Type = BigIntUnsigned
   
   mySqlDefault , Type = Flag
   
   mySqlCompiled , Type = Flag
   
   mySqlSortLen , Type = BigIntNSNotZero
 
 xxSysB
Contains the System datas.
The system database of a program contains the description and the programs of and for the data.
But when a program runs, It needs some information about the data it has to compute.
That is why a reference to the system DB is needed.


The tables defined in this database are:

 the same as the xxxDataDb