[Summary view] [Print] [Text view]

   1  # if you would like to utilize a table prefix when creating these tables, be sure to reflect that in config.inc.php so the program
   2  # will be aware of it. this option is $db_prefix. if you are unaware of what is meant by utilizing a 'table prefix', then please disregard.
   3  
   4  #
   5  # Table structure for table `audit`
   6  #
   7  
   8  CREATE TABLE audit (
   9    modified_by_ip varchar(39) NOT NULL default '',
  10    modified_by_user varchar(50) NOT NULL default '',
  11    modified_when bigint(14) NOT NULL, 
  12    modified_from bigint(14) NOT NULL,
  13    modified_to bigint(14) NOT NULL, 
  14    modified_why varchar(250) NOT NULL default '',
  15    user_modified varchar(50) NOT NULL default '',
  16    PRIMARY KEY  (modified_when), 
  17    UNIQUE KEY modified_when (modified_when)
  18  ) TYPE=MyISAM;
  19  
  20  # --------------------------------------------------------
  21  
  22  #
  23  # Table structure for table `dbversion`
  24  #
  25  
  26  CREATE TABLE dbversion (
  27    dbversion decimal(5,1) NOT NULL default '0.0',
  28    PRIMARY KEY  (dbversion)
  29  ) TYPE=MyISAM;
  30  
  31  #
  32  # Dumping data for table `dbversion`
  33  #
  34  
  35  INSERT INTO dbversion VALUES ('1.4');
  36  
  37  # --------------------------------------------------------
  38  
  39  #
  40  # Table structure for table `employees`
  41  #
  42  
  43  CREATE TABLE employees (
  44    empfullname varchar(50) NOT NULL default '',
  45    tstamp bigint(14) default NULL,
  46    employee_passwd varchar(25) NOT NULL default '',
  47    displayname varchar(50) NOT NULL default '',
  48    email varchar(75) NOT NULL default '',
  49    groups varchar(50) NOT NULL default '',
  50    office varchar(50) NOT NULL default '',
  51    admin tinyint(1) NOT NULL default '0',
  52    reports tinyint(1) NOT NULL default '0',
  53    time_admin tinyint(1) NOT NULL default '0',
  54    disabled tinyint(1) NOT NULL default '0',
  55    PRIMARY KEY  (empfullname)
  56  ) TYPE=MyISAM;
  57  
  58  #
  59  # Dumping data for table `employees`
  60  #
  61  
  62  INSERT INTO employees VALUES ('admin', NULL, 'xy.RY2HT1QTc2', 'administrator', '', '', '', 1, 1, 1, '');
  63  
  64  # --------------------------------------------------------
  65  
  66  #
  67  # Table structure for table `groups`
  68  #
  69  
  70  CREATE TABLE groups (
  71    groupname varchar(50) NOT NULL default '',
  72    groupid int(10) NOT NULL auto_increment,
  73    officeid int(10) NOT NULL default '0',
  74    PRIMARY KEY  (groupid)
  75  ) TYPE=MyISAM;
  76  
  77  # --------------------------------------------------------
  78  
  79  #
  80  # Table structure for table `info`
  81  #
  82  
  83  CREATE TABLE info (
  84    fullname varchar(50) NOT NULL default '',
  85    `inout` varchar(50) NOT NULL default '',
  86    timestamp bigint(14) default NULL,
  87    notes varchar(250) default NULL,
  88    ipaddress varchar(39) NOT NULL default '',
  89    KEY fullname (fullname)
  90  ) TYPE=MyISAM;
  91  
  92  # --------------------------------------------------------
  93  
  94  #
  95  # Table structure for table `metars`
  96  #
  97  
  98  CREATE TABLE metars (
  99    metar varchar(255) NOT NULL default '',
 100    timestamp timestamp(14) NOT NULL,
 101    station varchar(4) NOT NULL default '',
 102    PRIMARY KEY  (station),
 103    UNIQUE KEY station (station)
 104  ) TYPE=MyISAM;
 105  
 106  # --------------------------------------------------------
 107  
 108  #
 109  # Table structure for table `offices`
 110  #
 111  
 112  CREATE TABLE offices (
 113    officename varchar(50) NOT NULL default '',
 114    officeid int(10) NOT NULL auto_increment,
 115    PRIMARY KEY  (officeid)
 116  ) TYPE=MyISAM;
 117  
 118  # --------------------------------------------------------
 119  
 120  #
 121  # Table structure for table `punchlist`
 122  #
 123  
 124  CREATE TABLE punchlist (
 125    punchitems varchar(50) NOT NULL default '',
 126    color varchar(7) NOT NULL default '',
 127    in_or_out tinyint(1) default NULL,
 128    PRIMARY KEY  (punchitems)
 129  ) TYPE=MyISAM;
 130  
 131  #
 132  # Dumping data for table `punchlist`
 133  #
 134  
 135  INSERT INTO punchlist VALUES ('in', '#009900', 1);
 136  INSERT INTO punchlist VALUES ('out', '#FF0000', 0);
 137  INSERT INTO punchlist VALUES ('break', '#FF9900', 0);
 138  INSERT INTO punchlist VALUES ('lunch', '#0000FF', 0);
 139  
 140  # --------------------------------------------------------
 141  
 142