NRAO Home  >  Green Bank  |  Wiki Topic:    GB > Software > PlanOfRecordC72006 > SchedulingSoftware > DBaseVsMySQL

Changes | Index | Contents | Search | Statistics | Go

DBase Vs MySQL

DBase Table:

===========================================================
Table structure for p:\data\authors.DBF:
===========================================================
  Name                  Type        Len Dec Default 
  pcode                 CHARACTER    10    
  peoplekey             NUMERIC       6   0 
  astro_id              NUMERIC      10   0 
  authorder             NUMERIC       3   0 
  thesis                CHARACTER     1    
  observing             CHARACTER     1    
Total Length:                        31
---------------------------------------------
Indexes for p:\data\authors.DBF:
---------------------------------------------
  Peoplekeyunique
    peoplekey
    Unique

  Pcode
    pcode

  Pcac
    pcode+str(authorder,3,0,"0")

  Peoplekey
    peoplekey

MySQL Table:

/****************************************/
/*              AUTHORS              */
/****************************************/
drop table if exists `pas`.`authors`;

CREATE TABLE `pas`.`authors` (
      aukey integer primary key auto_increment not null,
         /* From vdb type of CHARACTER to pcode varchar(15) */
      pcode varchar(15),
         /* From vdb type of NUMERIC to integer */
      peoplekey integer,
         /* From vdb type of NUMERIC to integer */
      astro_id integer,
         /* From vdb type of NUMERIC to smallint */
      authorder smallint,
         /* From vdb type of CHARACTER */
      thesis varchar(1),
         /* From vdb type of CHARACTER */
      observing varchar(1),

      affiliation integer,

         index pcode (pcode),

         index peoplekey (peoplekey) );
  /*------------------------------------------------------------------*/
  /*   Dbase indexes on original table                                */
  /*------------------------------------------------------------------*/
  /* PEOPLEKEYUNIQUE                                                  */
  /*    peoplekey                                                     */
  /*       Unique                                                     */
  /* PCODE                                                            */
  /*    pcode                                                         */
  /* PCAC                                                             */
  /*    pcode+str(authorder,3,0,"0")                                  */
  /* PEOPLEKEY                                                        */
  /*    peoplekey                                                     */
  /*------------------------------------------------------------------*/