#
# Table structure for table `faq`
#

CREATE TABLE faq (
  id int(11) NOT NULL auto_increment,
  who text NOT NULL,
  email text NOT NULL,
  quest text NOT NULL,
  otv int(11) NOT NULL default '0',
  repl text NOT NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `links`
#

CREATE TABLE links (
  id int(11) NOT NULL auto_increment,
  url text NOT NULL,
  name text NOT NULL,
  prior int(11) NOT NULL default '0',
  descr text NOT NULL,
  shw int(11) NOT NULL default '0',
  who text NOT NULL,
  dt date NOT NULL default '0000-00-00',
  PRIMARY KEY  (id)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `news`
#

CREATE TABLE news (
  id int(11) NOT NULL auto_increment,
  title text NOT NULL,
  txt text NOT NULL,
  dt date NOT NULL default '0000-00-00',
  PRIMARY KEY  (id)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `stat`
#

CREATE TABLE stat (
  id int(11) NOT NULL auto_increment,
  name text NOT NULL,
  txt text NOT NULL,
  author text NOT NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `vote`
#

CREATE TABLE vote (
  id int(11) NOT NULL auto_increment,
  typ int(11) NOT NULL default '0',
  actv int(11) NOT NULL default '0',
  num int(11) NOT NULL default '0',
  quest text NOT NULL,
  otv1 text NOT NULL,
  otv2 text NOT NULL,
  otv3 text NOT NULL,
  otv4 text NOT NULL,
  otv5 text NOT NULL,
  otv6 text NOT NULL,
  otv7 text NOT NULL,
  otv8 text NOT NULL,
  otv9 text NOT NULL,
  otv10 text NOT NULL,
  otv11 text NOT NULL,
  otv12 text NOT NULL,
  otv13 text NOT NULL,
  otv14 text NOT NULL,
  otv15 text NOT NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `workers`
#

CREATE TABLE workers (
  id int(11) NOT NULL auto_increment,
  fio text NOT NULL,
  ordr int(11) NOT NULL default '0',
  descr text NOT NULL,
  email text NOT NULL,
  foto blob NOT NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

#
# Table structure for table `texts`
#

CREATE TABLE texts (
  id int(11) NOT NULL auto_increment,
  name text NOT NULL,
  txt text NOT NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

#
# Dumping data for table `texts`
#

INSERT INTO texts VALUES (1, 'About text', 'About About About About About About About About About About About About About About About About About About About About About About About About About\r\nAbout About About About About About About About About About About About About About About About About About About About About About About About ');
INSERT INTO texts VALUES (2, 'Contacts', 'contacts info\r\ncontacts info\r\ncontacts info\r\ncontacts info\r\ncontacts info\r\ncontacts info\r\ncontacts info\r\ncontacts info\r\n');
INSERT INTO texts VALUES (3, 'License', 'more.....\r\n. .. . . . .  . . .\r\n. .. . . . .  . . .\r\n. .. . . . .  . . .\r\n. .. . . . .  . . .\r\n. .. . . . .  . . .');