
CREATE TABLE aithseis (
  id_ypopshfioy int(10) unsigned default NULL,
  typos_synergath tinyint(3) unsigned default NULL,
  id_ma8hmatos int(10) unsigned default NULL,
  hm_aithshs date default NULL
) ENGINE=MyISAM DEFAULT CHARSET=greek;

CREATE TABLE dhmosieyseis (
  id_ypopshfioy int(10) unsigned default NULL,
  synedria tinyint(3) unsigned default NULL,
  periodika tinyint(3) unsigned default NULL,
  UNIQUE KEY id_ypopshfioy (id_ypopshfioy)
) ENGINE=MyISAM DEFAULT CHARSET=greek;

CREATE TABLE mathimata (
  id_mathimatos int(10) unsigned NOT NULL auto_increment,
  kwdikos_math varchar(6) default NULL,
  titlos varchar(40) default NULL,
  tomeas char(2) default NULL,
  theoria tinyint(4) default NULL,
  ergasthrio tinyint(4) default NULL,
  askhseis tinyint(4) default NULL,
  PRIMARY KEY  (id_mathimatos)
) ENGINE=MyISAM DEFAULT CHARSET=greek AUTO_INCREMENT=3 ;

CREATE TABLE pros_dedomena (
  id_ypopshfioy int(10) unsigned default NULL,
  hm_gennhshs date default NULL,
  pantremenos tinyint(1) default NULL,
  arithmos_paidiwn tinyint(3) unsigned default NULL,
  dieythinsi varchar(40) default NULL,
  polh varchar(30) default NULL,
  afm varchar(10) default NULL,
  doy varchar(15) default NULL,
  thl_spiti varchar(13) default NULL,
  thl_kin varchar(13) default NULL,
  email varchar(30) default NULL,
  arithmos_taytothtas varchar(8) default NULL,
  glwsses varchar(40) default NULL,
  UNIQUE KEY id_ypopshfioy (id_ypopshfioy)
) ENGINE=MyISAM DEFAULT CHARSET=greek;

CREATE TABLE proyphresia (
  id int(10) unsigned NOT NULL auto_increment,
  id_ypopshfioy int(10) unsigned default NULL,
  typos tinyint(3) unsigned default NULL,
  apo date NOT NULL default '0000-00-00',
  eos date NOT NULL default '0000-00-00',
  wromisth tinyint(1) default NULL,
  wres int(10) unsigned default NULL,
  organismos varchar(20) default NULL,
  thesh varchar(20) default NULL,
  tameio varchar(10) default NULL,
  bebaiwsh tinyint(1) default NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM DEFAULT CHARSET=greek AUTO_INCREMENT=2 ;

CREATE TABLE users (
  username varchar(16) default NULL,
  `password` varchar(16) default NULL,
  authlevel tinyint(4) default NULL,
  mail varchar(50) default NULL,
  id_ypopshfioy int(10) unsigned default NULL,
  `status` varchar(12) default 'enabled',
  onoma varchar(30) default NULL,
  eponymo varchar(30) default NULL,
  UNIQUE KEY username (username)
) ENGINE=MyISAM DEFAULT CHARSET=greek;

CREATE TABLE ypopshfioi (
  id int(10) unsigned NOT NULL auto_increment,
  onoma varchar(30) NOT NULL default '',
  eponymo varchar(30) NOT NULL default '',
  eidikothta varchar(30) default NULL,
  ptyxeio varchar(50) default NULL,
  ptyxeio_etos date default NULL,
  ptyxeio_synaf tinyint(1) default NULL,
  metapt varchar(50) default NULL,
  metapt_etos date default NULL,
  metapty_synaf tinyint(1) default NULL,
  didakt varchar(50) default NULL,
  didakt_etos date default NULL,
  didakt_synaf tinyint(1) default NULL,
  parathrhseis varchar(50) default NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM DEFAULT CHARSET=greek AUTO_INCREMENT=3 ;

