xsqldb.mco

全新的纯内存式实时数据库

/*******************************************************************
 *                                                                 *
 *  xsqldb.mco                                                      *
 *                                                                 *
 *  This file is a part of the eXtremeDB source code               *
 *  Copyright (c) 2001-2007 McObject LLC                           * 
 *  All Rights Reserved                                            *
 *                                                                 *
 *******************************************************************/
#define int1      signed<1>
#define int2      signed<2>
#define int4      signed<4>
#define int8      signed<8>
#define uint8     unsigned<8>
#define uint4     unsigned<4>
#define uint2     unsigned<2>
#define uint1     unsigned<1>

declare database  xsqldb;

class S
{
    char<5>  sid;
    char<20> sname; 
    int4     status;
    char<15> city;

    list;
    autoid[1000];
    hash<sid> pk[1000];
};

class P
{
    char<5>  pid;
    char<20> pname; 
    char<6>  color;
    double   weight;
    char<15> city;

    list;
    autoid[1000];
    hash<pid> pk[1000];
};

class J
{
    char<5>  jid;
    string jname;
    char<15> city;

    list;
    autoid[1000];
    hash<jid> pk[1000];
};

class SP 
{
    char<5>  sid;
    char<5>  pid;
    char<5>  jid;
    int8     qty;

    list;
    autoid[1000];
    tree<sid> sk;
    tree<pid> pk;
    tree<jid> jk;
};