<?php
$result = dbquery("DROP TABLE IF EXISTS ".$db_prefix."filmai;
CREATE TABLE ".$db_prefix."filmai (
  filmai_id int(10) unsigned NOT NULL auto_increment,
  filmai_img text CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  filmai_pav varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  filmai_apr text CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  filmai_kodas text CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  filmai_kodas2 text CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  filmai_trailler text CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  filmai_siustis text CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  filmai_metai varchar(20) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  filmai_kalba varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  filmai_rezisierius varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  filmai_trukme varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  filmai_aktoriai varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  serialas1 varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  pavadinimas1 varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  serialas2 varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  pavadinimas2 varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  serialas3 varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  pavadinimas3 varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  serialas4 varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  pavadinimas4 varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  serialas5 varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  pavadinimas5 varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  serialas6 varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  pavadinimas6 varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  serialas7 varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  pavadinimas7 varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  serialas8 varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  pavadinimas8 varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  serialas9 varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  pavadinimas9 varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  serialas10 varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  pavadinimas10 varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  serialas11 varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  pavadinimas11 varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  serialas12 varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  pavadinimas12 varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  serialas13 varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  pavadinimas13 varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  serialas14 varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  pavadinimas14 varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  serialas15 varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  pavadinimas15 varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  serialas16 varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  pavadinimas16 varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  serialas17 varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  pavadinimas17 varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  serialas18 varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  pavadinimas18 varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  serialas19 varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  pavadinimas19 varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  serialas20 varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  pavadinimas20 varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  serialas21 varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  pavadinimas21 varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  serialas22 varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  pavadinimas22 varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  serialas23 varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  pavadinimas23 varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  serialas24 varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  pavadinimas24 varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  serialas25 varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  pavadinimas25 varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  serialas26 varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  pavadinimas26 varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  serialas27 varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  pavadinimas27 varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  serialas28 varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  pavadinimas28 varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  serialas29 varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  pavadinimas29 varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  serialas30 varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  pavadinimas30 varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  serialas31 varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  pavadinimas31 varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  serialas32 varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  pavadinimas32 varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  serialas33 varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  pavadinimas33 varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  serialas34 varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  pavadinimas34 varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  serialas35 varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  pavadinimas35 varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  serialas36 varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  pavadinimas36 varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  serialas37 varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  pavadinimas37 varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  serialas38 varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  pavadinimas38 varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  serialas39 varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  pavadinimas39 varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  serialas40 varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  pavadinimas40 varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  serialas41 varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  pavadinimas41 varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  serialas42 varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  pavadinimas42 varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  filmai_kat0 int(10) NOT NULL default '0',
  filmai_kat1 int(10) NOT NULL default '0',
  filmai_kat2 int(10) NOT NULL default '0',
  filmai_kat3 int(10) NOT NULL default '0',
  filmai_kat4 int(10) NOT NULL default '0',
  filmai_kat5 int(10) NOT NULL default '0',
  filmai_kat6 int(10) NOT NULL default '0',
  filmai_kat7 int(10) NOT NULL default '0',
  filmai_kat8 int(10) NOT NULL default '0',
  filmai_kat9 int(10) NOT NULL default '0',
  filmai_per int(12) NOT NULL default '0',
  filmai_date int(10) NOT NULL default '0',
  PRIMARY KEY  (filmai_id)
) ENGINE=MyISAM;");

$result2 = dbquery("DROP TABLE IF EXISTS ".$db_prefix."filmai_kat;
CREATE TABLE ".$db_prefix."filmai_kat (
  filmai_kat_id int(10) unsigned NOT NULL auto_increment,
  filmai_kat_pav varchar(200) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL default '',
  filmai_kat_lvl int(20) unsigned NOT NULL default '0',
  PRIMARY KEY  (filmai_kat_id)
) ENGINE=MyISAM;");

if($result)
echo "<center><p>Filmų Lentele sukurta.</p></center>";
else
echo "<center><p>Filmų Lentele nesukurta.</p>
<p>".mysql_error()."</p></center>";

if($result2)
echo "<center><p>Filmų Kategorijų Lentele sukurta.</p></center>";
else
echo "<center><p>Filmų Kategorijų Lentele nesukurta.</p>
<p>".mysql_error()."</p></center>";
?>