|
|
|
| Доброе утро!
возможно я не верно выражаюсь но на сколько я знаю обновление сразу нескольких данных в таблице называется каскадным...
есть форма вывода данных из базы, с кнопкой обновления по ID
пример:
<?php
while ($row = mysql_fetch_array($res)) {
echo '
<form method="POST" action="update.php?id='.$row['id'].'">
Текст <textarea name="text">'.$row['text'].'</textarea>
<input type="submit" value="Обновить" name="update">
</form><br>
';
?>
|
Таких форм на страницу выводится много и для обновления текста приходится для каждой отдельно нажимать кнопку обновить
обновление записей по отдельности простое:
<?php
if(isset($_POST['update'])) {
$id = $_GET['id'];
$text= $_POST['text'];
$query = "UPDATE mytable SET text='$text' WHERE (id='$id')";
mysql_query($query) or die (mysql_error());
mysql_close();
header ("Location: /");
}
?>
|
Можно ли сделать одну общую кнопку обновить для всех записей? учитывая, что в форму ввели изменения отличающиеся друг от друга | |
|
|
|
|
|
|
|
для: tima2010
(16.09.2011 в 09:27)
| | Т.е. вы хотите обновить одним оператором UPDATE несколько строк таблицы? Нет, такой возможности нет. | |
|
|
|
|
|
|
|
для: cheops
(16.09.2011 в 11:59)
| | ясно, спасибо, а какой для этого должен быть способ записи данных для реализации данный возможности? | |
|
|
|
|
|
|
|
для: tima2010
(16.09.2011 в 12:33)
| | Данной, это какой? | |
|
|
|
|
|
|
|
для: cheops
(16.09.2011 в 13:10)
| | извиняюсь, для возможности обновлять несколько строк через одну форму | |
|
|
|
|
|
|
|
для: tima2010
(16.09.2011 в 16:23)
| | у меня одним файлом обновляется 311 таблиц в базе вот код:
[code]<?php
include("db.php");
$sql = mysql_query("DELETE FROM `OB` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `OB` DROP `id`");
$sql = mysql_query("ALTER TABLE `OB` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nkjsg` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nkjsg` DROP `id`");
$sql = mysql_query("ALTER TABLE `nkjsg` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nkjso` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nkjso` DROP `id`");
$sql = mysql_query("ALTER TABLE `nkjso` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nkjsd` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nkjsd` DROP `id`");
$sql = mysql_query("ALTER TABLE `nkjsd` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nkjst` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nkjst` DROP `id`");
$sql = mysql_query("ALTER TABLE `nkjst` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nkjsc` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nkjsc` DROP `id`");
$sql = mysql_query("ALTER TABLE `nkjsc` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nkjsdom` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nkjsdom` DROP `id`");
$sql = mysql_query("ALTER TABLE `nkjsdom` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nkjkk` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nkjkk` DROP `id`");
$sql = mysql_query("ALTER TABLE `nkjkk` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nkjkg` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nkjkg` DROP `id`");
$sql = mysql_query("ALTER TABLE `nkjkg` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nkjko` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nkjko` DROP `id`");
$sql = mysql_query("ALTER TABLE `nkjko` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nkjkd` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nkjkd` DROP `id`");
$sql = mysql_query("ALTER TABLE `nkjkd` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nkjkt` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nkjkt` DROP `id`");
$sql = mysql_query("ALTER TABLE `nkjkt` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nkjkc` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nkjkc` DROP `id`");
$sql = mysql_query("ALTER TABLE `nkjkc` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nkjkdom` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nkjkdom` DROP `id`");
$sql = mysql_query("ALTER TABLE `nkjkdom` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nkjpk` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nkjpk` DROP `id`");
$sql = mysql_query("ALTER TABLE `nkjpk` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nkjpg` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nkjpg` DROP `id`");
$sql = mysql_query("ALTER TABLE `nkjpg` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nkjpo` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nkjpo` DROP `id`");
$sql = mysql_query("ALTER TABLE `nkjpo` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nkjpd` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nkjpd` DROP `id`");
$sql = mysql_query("ALTER TABLE `nkjpd` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nkjpt` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nkjpt` DROP `id`");
$sql = mysql_query("ALTER TABLE `nkjpt` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nkjpc` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nkjpc` DROP `id`");
$sql = mysql_query("ALTER TABLE `nkjpc` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nkjpdom` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nkjpdom` DROP `id`");
$sql = mysql_query("ALTER TABLE `nkjpdom` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nknss` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nknss` DROP `id`");
$sql = mysql_query("ALTER TABLE `nknss` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nknsg` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nknsg` DROP `id`");
$sql = mysql_query("ALTER TABLE `nknsg` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nknso` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nknso` DROP `id`");
$sql = mysql_query("ALTER TABLE `nknso` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nknsstr` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nknsstr` DROP `id`");
$sql = mysql_query("ALTER TABLE `nknsstr` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nknsm` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nknsm` DROP `id`");
$sql = mysql_query("ALTER TABLE `nknsm` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nknsb` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nknsb` DROP `id`");
$sql = mysql_query("ALTER TABLE `nknsb` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nknks` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nknks` DROP `id`");
$sql = mysql_query("ALTER TABLE `nknks` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nknkg` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nknkg` DROP `id`");
$sql = mysql_query("ALTER TABLE `nknkg` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nknko` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nknko` DROP `id`");
$sql = mysql_query("ALTER TABLE `nknko` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nknkstr` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nknkstr` DROP `id`");
$sql = mysql_query("ALTER TABLE `nknkstr` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nknkm` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nknkm` DROP `id`");
$sql = mysql_query("ALTER TABLE `nknkm` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nknkb` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nknkb` DROP `id`");
$sql = mysql_query("ALTER TABLE `nknkb` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nknps` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nknps` DROP `id`");
$sql = mysql_query("ALTER TABLE `nknps` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nknpg` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nknpg` DROP `id`");
$sql = mysql_query("ALTER TABLE `nknpg` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nknpo` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nknpo` DROP `id`");
$sql = mysql_query("ALTER TABLE `nknpo` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nknpstr` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nknpstr` DROP `id`");
$sql = mysql_query("ALTER TABLE `nknpstr` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nknpm` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nknpm` DROP `id`");
$sql = mysql_query("ALTER TABLE `nknpm` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nknpb` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nknpb` DROP `id`");
$sql = mysql_query("ALTER TABLE `nknpb` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `npjsk` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `npjsk` DROP `id`");
$sql = mysql_query("ALTER TABLE `npjsk` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `npjsg` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `npjsg` DROP `id`");
$sql = mysql_query("ALTER TABLE `npjsg` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `npjso` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `npjso` DROP `id`");
$sql = mysql_query("ALTER TABLE `npjso` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `npjsd` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `npjsd` DROP `id`");
$sql = mysql_query("ALTER TABLE `npjsd` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `npjst` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `npjst` DROP `id`");
$sql = mysql_query("ALTER TABLE `npjst` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `npjsc` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `npjsc` DROP `id`");
$sql = mysql_query("ALTER TABLE `npjsc` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `npjsdom` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `npjsdom` DROP `id`");
$sql = mysql_query("ALTER TABLE `npjsdom` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `npjkk` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `npjkk` DROP `id`");
$sql = mysql_query("ALTER TABLE `npjkk` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `npjkg` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `npjkg` DROP `id`");
$sql = mysql_query("ALTER TABLE `npjkg` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `npjko` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `npjko` DROP `id`");
$sql = mysql_query("ALTER TABLE `npjko` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `npjkd` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `npjkd` DROP `id`");
$sql = mysql_query("ALTER TABLE `npjkd` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `npjkt` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `npjkt` DROP `id`");
$sql = mysql_query("ALTER TABLE `npjkt` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `npjkc` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `npjkc` DROP `id`");
$sql = mysql_query("ALTER TABLE `npjkc` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `npjkdom` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `npjkdom` DROP `id`");
$sql = mysql_query("ALTER TABLE `npjkdom` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `npjpk` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `npjpk` DROP `id`");
$sql = mysql_query("ALTER TABLE `npjpk` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `npjpg` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `npjpg` DROP `id`");
$sql = mysql_query("ALTER TABLE `npjpg` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `npjpo` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `npjpo` DROP `id`");
$sql = mysql_query("ALTER TABLE `npjpo` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `npjpd` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `npjpd` DROP `id`");
$sql = mysql_query("ALTER TABLE `npjpd` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `npjpt` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `npjpt` DROP `id`");
$sql = mysql_query("ALTER TABLE `npjpt` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `npjpc` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `npjpc` DROP `id`");
$sql = mysql_query("ALTER TABLE `npjpc` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `npjpdom` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `npjpdom` DROP `id`");
$sql = mysql_query("ALTER TABLE `npjpdom` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `npnss` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `npnss` DROP `id`");
$sql = mysql_query("ALTER TABLE `npnss` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `npnsg` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `npnsg` DROP `id`");
$sql = mysql_query("ALTER TABLE `npnsg` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `npnso` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `npnso` DROP `id`");
$sql = mysql_query("ALTER TABLE `npnso` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `npnsstr` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `npnsstr` DROP `id`");
$sql = mysql_query("ALTER TABLE `npnsstr` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `npnsm` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `npnsm` DROP `id`");
$sql = mysql_query("ALTER TABLE `npnsm` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `npnsb` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `npnsb` DROP `id`");
$sql = mysql_query("ALTER TABLE `npnsb` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `npnks` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `npnks` DROP `id`");
$sql = mysql_query("ALTER TABLE `npnks` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `npnkg` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `npnkg` DROP `id`");
$sql = mysql_query("ALTER TABLE `npnkg` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `npnko` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `npnko` DROP `id`");
$sql = mysql_query("ALTER TABLE `npnko` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `npnkstr` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `npnkstr` DROP `id`");
$sql = mysql_query("ALTER TABLE `npnkstr` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `npnkm` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `npnkm` DROP `id`");
$sql = mysql_query("ALTER TABLE `npnkm` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `npnkb` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `npnkb` DROP `id`");
$sql = mysql_query("ALTER TABLE `npnkb` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `npnps` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `npnps` DROP `id`");
$sql = mysql_query("ALTER TABLE `npnps` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `npnpg` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `npnpg` DROP `id`");
$sql = mysql_query("ALTER TABLE `npnpg` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `npnpo` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `npnpo` DROP `id`");
$sql = mysql_query("ALTER TABLE `npnpo` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `npnpstr` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `npnpstr` DROP `id`");
$sql = mysql_query("ALTER TABLE `npnpstr` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `npnpm` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `npnpm` DROP `id`");
$sql = mysql_query("ALTER TABLE `npnpm` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `npnpb` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `npnpb` DROP `id`");
$sql = mysql_query("ALTER TABLE `npnpb` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nsjsk` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nsjsk` DROP `id`");
$sql = mysql_query("ALTER TABLE `nsjsk` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nsjsg` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nsjsg` DROP `id`");
$sql = mysql_query("ALTER TABLE `nsjsg` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nsjso` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nsjso` DROP `id`");
$sql = mysql_query("ALTER TABLE `nsjso` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nsjsd` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nsjsd` DROP `id`");
$sql = mysql_query("ALTER TABLE `nsjsd` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nsjst` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nsjst` DROP `id`");
$sql = mysql_query("ALTER TABLE `nsjst` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nsjsc` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nsjsc` DROP `id`");
$sql = mysql_query("ALTER TABLE `nsjsc` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nsjsdom` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nsjsdom` DROP `id`");
$sql = mysql_query("ALTER TABLE `nsjsdom` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nsjkk` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nsjkk` DROP `id`");
$sql = mysql_query("ALTER TABLE `nsjkk` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nsjkg` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nsjkg` DROP `id`");
$sql = mysql_query("ALTER TABLE `nsjkg` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nsjko` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nsjko` DROP `id`");
$sql = mysql_query("ALTER TABLE `nsjko` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nsjkd` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nsjkd` DROP `id`");
$sql = mysql_query("ALTER TABLE `nsjkd` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nsjkt` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nsjkt` DROP `id`");
$sql = mysql_query("ALTER TABLE `nsjkt` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nsjkc` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nsjkc` DROP `id`");
$sql = mysql_query("ALTER TABLE `nsjkc` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nsjkdom` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nsjkdom` DROP `id`");
$sql = mysql_query("ALTER TABLE `nsjkdom` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nsjpk` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nsjpk` DROP `id`");
$sql = mysql_query("ALTER TABLE `nsjpk` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nsjpg` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nsjpg` DROP `id`");
$sql = mysql_query("ALTER TABLE `nsjpg` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nsjpo` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nsjpo` DROP `id`");
$sql = mysql_query("ALTER TABLE `nsjpo` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nsjpd` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nsjpd` DROP `id`");
$sql = mysql_query("ALTER TABLE `nsjpd` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nsjpt` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nsjpt` DROP `id`");
$sql = mysql_query("ALTER TABLE `nsjpt` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nsjpc` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nsjpc` DROP `id`");
$sql = mysql_query("ALTER TABLE `nsjpc` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nsjpdom` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nsjpdom` DROP `id`");
$sql = mysql_query("ALTER TABLE `nsjpdom` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nsnss` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nsnss` DROP `id`");
$sql = mysql_query("ALTER TABLE `nsnss` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nsnsg` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nsnsg` DROP `id`");
$sql = mysql_query("ALTER TABLE `nsnsg` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nsnso` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nsnso` DROP `id`");
$sql = mysql_query("ALTER TABLE `nsnso` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nsnsstr` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nsnsstr` DROP `id`");
$sql = mysql_query("ALTER TABLE `nsnsstr` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nsnsm` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nsnsm` DROP `id`");
$sql = mysql_query("ALTER TABLE `nsnsm` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nsnsb` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nsnsb` DROP `id`");
$sql = mysql_query("ALTER TABLE `nsnsb` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nsnks` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nsnks` DROP `id`");
$sql = mysql_query("ALTER TABLE `nsnks` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nsnkg` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nsnkg` DROP `id`");
$sql = mysql_query("ALTER TABLE `nsnkg` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nsnko` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nsnko` DROP `id`");
$sql = mysql_query("ALTER TABLE `nsnko` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nsnkstr` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nsnkstr` DROP `id`");
$sql = mysql_query("ALTER TABLE `nsnkstr` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nsnkm` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nsnkm` DROP `id`");
$sql = mysql_query("ALTER TABLE `nsnkm` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nsnkb` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nsnkb` DROP `id`");
$sql = mysql_query("ALTER TABLE `nsnkb` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nsnps` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nsnps` DROP `id`");
$sql = mysql_query("ALTER TABLE `nsnps` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nsnpg` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nsnpg` DROP `id`");
$sql = mysql_query("ALTER TABLE `nsnpg` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nsnpo` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nsnpo` DROP `id`");
$sql = mysql_query("ALTER TABLE `nsnpo` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nsnpstr` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nsnpstr` DROP `id`");
$sql = mysql_query("ALTER TABLE `nsnpstr` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nsnpm` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nsnpm` DROP `id`");
$sql = mysql_query("ALTER TABLE `nsnpm` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nsnpb` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nsnpb` DROP `id`");
$sql = mysql_query("ALTER TABLE `nsnpb` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nsnjsk` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nsnjsk` DROP `id`");
$sql = mysql_query("ALTER TABLE `nsnjsk` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nsnjsg` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nsnjsg` DROP `id`");
$sql = mysql_query("ALTER TABLE `nsnjsg` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nsnjso` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nsnjso` DROP `id`");
$sql = mysql_query("ALTER TABLE `nsnjso` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nsnjsd` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nsnjsd` DROP `id`");
$sql = mysql_query("ALTER TABLE `nsnjsd` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nsnjst` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nsnjst` DROP `id`");
$sql = mysql_query("ALTER TABLE `nsnjst` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nsnjsc` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nsnjsc` DROP `id`");
$sql = mysql_query("ALTER TABLE `nsnjsc` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nsnjsdom` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nsnjsdom` DROP `id`");
$sql = mysql_query("ALTER TABLE `nsnjsdom` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nsnjkk` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nsnjkk` DROP `id`");
$sql = mysql_query("ALTER TABLE `nsnjkk` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nsnjkg` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nsnjkg` DROP `id`");
$sql = mysql_query("ALTER TABLE `nsnjkg` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nsnjko` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nsnjko` DROP `id`");
$sql = mysql_query("ALTER TABLE `nsnjko` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nsnjkd` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nsnjkd` DROP `id`");
$sql = mysql_query("ALTER TABLE `nsnjkd` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nsnjkt` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nsnjkt` DROP `id`");
$sql = mysql_query("ALTER TABLE `nsnjkt` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nsnjkc` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nsnjkc` DROP `id`");
$sql = mysql_query("ALTER TABLE `nsnjkc` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nsnjkdom` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nsnjkdom` DROP `id`");
$sql = mysql_query("ALTER TABLE `nsnjkdom` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nsnjpk` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nsnjpk` DROP `id`");
$sql = mysql_query("ALTER TABLE `nsnjpk` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nsnjpg` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nsnjpg` DROP `id`");
$sql = mysql_query("ALTER TABLE `nsnjpg` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nsnjpo` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nsnjpo` DROP `id`");
$sql = mysql_query("ALTER TABLE `nsnjpo` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nsnjpd` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nsnjpd` DROP `id`");
$sql = mysql_query("ALTER TABLE `nsnjpd` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nsnjpt` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nsnjpt` DROP `id`");
$sql = mysql_query("ALTER TABLE `nsnjpt` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nsnjpc` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nsnjpc` DROP `id`");
$sql = mysql_query("ALTER TABLE `nsnjpc` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nsnjpdom` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nsnjpdom` DROP `id`");
$sql = mysql_query("ALTER TABLE `nsnjpdom` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nsnnss` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nsnnss` DROP `id`");
$sql = mysql_query("ALTER TABLE `nsnnss` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nsnnsg` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nsnnsg` DROP `id`");
$sql = mysql_query("ALTER TABLE `nsnnsg` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nsnnso` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nsnnso` DROP `id`");
$sql = mysql_query("ALTER TABLE `nsnnso` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nsnnsstr` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nsnnsstr` DROP `id`");
$sql = mysql_query("ALTER TABLE `nsnnsstr` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nsnnsm` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nsnnsm` DROP `id`");
$sql = mysql_query("ALTER TABLE `nsnnsm` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nsnnsb` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nsnnsb` DROP `id`");
$sql = mysql_query("ALTER TABLE `nsnnsb` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nsnnks` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nsnnks` DROP `id`");
$sql = mysql_query("ALTER TABLE `nsnnks` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nsnnkg` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nsnnkg` DROP `id`");
$sql = mysql_query("ALTER TABLE `nsnnkg` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nsnnko` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nsnnko` DROP `id`");
$sql = mysql_query("ALTER TABLE `nsnnko` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nsnnkstr` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nsnnkstr` DROP `id`");
$sql = mysql_query("ALTER TABLE `nsnnkstr` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nsnnkm` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nsnnkm` DROP `id`");
$sql = mysql_query("ALTER TABLE `nsnnkm` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nsnnkb` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nsnnkb` DROP `id`");
$sql = mysql_query("ALTER TABLE `nsnnkb` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nsnnps` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nsnnps` DROP `id`");
$sql = mysql_query("ALTER TABLE `nsnnps` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nsnnpg` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nsnnpg` DROP `id`");
$sql = mysql_query("ALTER TABLE `nsnnpg` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nsnnpo` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nsnnpo` DROP `id`");
$sql = mysql_query("ALTER TABLE `nsnnpo` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nsnnpstr` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nsnnpstr` DROP `id`");
$sql = mysql_query("ALTER TABLE `nsnnpstr` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nsnnpm` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nsnnpm` DROP `id`");
$sql = mysql_query("ALTER TABLE `nsnnpm` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nsnnpb` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nsnnpb` DROP `id`");
$sql = mysql_query("ALTER TABLE `nsnnpb` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nmnjsk` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nmnjsk` DROP `id`");
$sql = mysql_query("ALTER TABLE `nmnjsk` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nmnjsg` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nmnjsg` DROP `id`");
$sql = mysql_query("ALTER TABLE `nmnjsg` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nmnjso` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nmnjso` DROP `id`");
$sql = mysql_query("ALTER TABLE `nmnjso` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nmnjsd` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nmnjsd` DROP `id`");
$sql = mysql_query("ALTER TABLE `nmnjsd` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nmnjst` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nmnjst` DROP `id`");
$sql = mysql_query("ALTER TABLE `nmnjst` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nmnjsc` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nmnjsc` DROP `id`");
$sql = mysql_query("ALTER TABLE `nmnjsc` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nmnjsdom` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nmnjsdom` DROP `id`");
$sql = mysql_query("ALTER TABLE `nmnjsdom` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nmnjkk` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nmnjkk` DROP `id`");
$sql = mysql_query("ALTER TABLE `nmnjkk` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nmnjkg` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nmnjkg` DROP `id`");
$sql = mysql_query("ALTER TABLE `nmnjkg` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nmnjko` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nmnjko` DROP `id`");
$sql = mysql_query("ALTER TABLE `nmnjko` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nmnjkd` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nmnjkd` DROP `id`");
$sql = mysql_query("ALTER TABLE `nmnjkd` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nmnjkt` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nmnjkt` DROP `id`");
$sql = mysql_query("ALTER TABLE `nmnjkt` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nmnjkc` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nmnjkc` DROP `id`");
$sql = mysql_query("ALTER TABLE `nmnjkc` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nmnjkdom` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nmnjkdom` DROP `id`");
$sql = mysql_query("ALTER TABLE `nmnjkdom` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nmnjpk` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nmnjpk` DROP `id`");
$sql = mysql_query("ALTER TABLE `nmnjpk` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nmnjpg` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nmnjpg` DROP `id`");
$sql = mysql_query("ALTER TABLE `nmnjpg` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nmnjpo` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nmnjpo` DROP `id`");
$sql = mysql_query("ALTER TABLE `nmnjpo` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nmnjpd` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nmnjpd` DROP `id`");
$sql = mysql_query("ALTER TABLE `nmnjpd` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nmnjpt` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nmnjpt` DROP `id`");
$sql = mysql_query("ALTER TABLE `nmnjpt` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nmnjpc` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nmnjpc` DROP `id`");
$sql = mysql_query("ALTER TABLE `nmnjpc` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nmnjpdom` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nmnjpdom` DROP `id`");
$sql = mysql_query("ALTER TABLE `nmnjpdom` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nmnnss` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nmnnss` DROP `id`");
$sql = mysql_query("ALTER TABLE `nmnnss` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nmnnsg` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nmnnsg` DROP `id`");
$sql = mysql_query("ALTER TABLE `nmnnsg` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nmnnso` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nmnnso` DROP `id`");
$sql = mysql_query("ALTER TABLE `nmnnso` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nmnnsstr` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nmnnsstr` DROP `id`");
$sql = mysql_query("ALTER TABLE `nmnnsstr` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nmnnsm` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nmnnsm` DROP `id`");
$sql = mysql_query("ALTER TABLE `nmnnsm` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nmnnsb` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nmnnsb` DROP `id`");
$sql = mysql_query("ALTER TABLE `nmnnsb` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nmnnks` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nmnnks` DROP `id`");
$sql = mysql_query("ALTER TABLE `nmnnks` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nmnnkg` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nmnnkg` DROP `id`");
$sql = mysql_query("ALTER TABLE `nmnnkg` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nmnnko` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nmnnko` DROP `id`");
$sql = mysql_query("ALTER TABLE `nmnnko` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nmnnkstr` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nmnnkstr` DROP `id`");
$sql = mysql_query("ALTER TABLE `nmnnkstr` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nmnnkm` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nmnnkm` DROP `id`");
$sql = mysql_query("ALTER TABLE `nmnnkm` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nmnnkb` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nmnnkb` DROP `id`");
$sql = mysql_query("ALTER TABLE `nmnnkb` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nmnnps` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nmnnps` DROP `id`");
$sql = mysql_query("ALTER TABLE `nmnnps` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nmnnpg` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nmnnpg` DROP `id`");
$sql = mysql_query("ALTER TABLE `nmnnpg` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nmnnpo` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nmnnpo` DROP `id`");
$sql = mysql_query("ALTER TABLE `nmnnpo` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nmnnpstr` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nmnnpstr` DROP `id`");
$sql = mysql_query("ALTER TABLE `nmnnpstr` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nmnnpm` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nmnnpm` DROP `id`");
$sql = mysql_query("ALTER TABLE `nmnnpm` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `nmnnpb` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `nmnnpb` DROP `id`");
$sql = mysql_query("ALTER TABLE `nmnnpb` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `akm` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `akm` DROP `id`");
$sql = mysql_query("ALTER TABLE `akm` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `aki` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `aki` DROP `id`");
$sql = mysql_query("ALTER TABLE `aki` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `ako` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `ako` DROP `id`");
$sql = mysql_query("ALTER TABLE `ako` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `akg` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `akg` DROP `id`");
$sql = mysql_query("ALTER TABLE `akg` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `akt` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `akt` DROP `id`");
$sql = mysql_query("ALTER TABLE `akt` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `akz` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `akz` DROP `id`");
$sql = mysql_query("ALTER TABLE `akz` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `apm` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `apm` DROP `id`");
$sql = mysql_query("ALTER TABLE `apm` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `api` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `api` DROP `id`");
$sql = mysql_query("ALTER TABLE `api` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `apo` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `apo` DROP `id`");
$sql = mysql_query("ALTER TABLE `apo` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `apg` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `apg` DROP `id`");
$sql = mysql_query("ALTER TABLE `apg` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `apt` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `apt` DROP `id`");
$sql = mysql_query("ALTER TABLE `apt` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `apz` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `apz` DROP `id`");
$sql = mysql_query("ALTER TABLE `apz` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `asm` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `asm` DROP `id`");
$sql = mysql_query("ALTER TABLE `asm` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `asi` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `asi` DROP `id`");
$sql = mysql_query("ALTER TABLE `asi` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `aso` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `aso` DROP `id`");
$sql = mysql_query("ALTER TABLE `aso` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `asg` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `asg` DROP `id`");
$sql = mysql_query("ALTER TABLE `asg` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `ast` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `ast` DROP `id`");
$sql = mysql_query("ALTER TABLE `ast` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `asz` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `asz` DROP `id`");
$sql = mysql_query("ALTER TABLE `asz` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `avm` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `avm` DROP `id`");
$sql = mysql_query("ALTER TABLE `avm` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `avi` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `avi` DROP `id`");
$sql = mysql_query("ALTER TABLE `avi` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `avo` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `avo` DROP `id`");
$sql = mysql_query("ALTER TABLE `avo` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `avg` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `avg` DROP `id`");
$sql = mysql_query("ALTER TABLE `avg` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `avt` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `avt` DROP `id`");
$sql = mysql_query("ALTER TABLE `avt` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `avz` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `avz` DROP `id`");
$sql = mysql_query("ALTER TABLE `avz` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `amm` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `amm` DROP `id`");
$sql = mysql_query("ALTER TABLE `amm` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `ami` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `ami` DROP `id`");
$sql = mysql_query("ALTER TABLE `ami` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `amo` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `amo` DROP `id`");
$sql = mysql_query("ALTER TABLE `amo` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `amg` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `amg` DROP `id`");
$sql = mysql_query("ALTER TABLE `amg` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `amt` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `amt` DROP `id`");
$sql = mysql_query("ALTER TABLE `amt` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `amz` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `amz` DROP `id`");
$sql = mysql_query("ALTER TABLE `amz` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `rpp` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `rpp` DROP `id`");
$sql = mysql_query("ALTER TABLE `rpp` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `rpr` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `rpr` DROP `id`");
$sql = mysql_query("ALTER TABLE `rpr` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `rps` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `rps` DROP `id`");
$sql = mysql_query("ALTER TABLE `rps` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `rpv` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `rpv` DROP `id`");
$sql = mysql_query("ALTER TABLE `rpv` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `rip` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `rip` DROP `id`");
$sql = mysql_query("ALTER TABLE `rip` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `rir` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `rir` DROP `id`");
$sql = mysql_query("ALTER TABLE `rir` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `ris` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `ris` DROP `id`");
$sql = mysql_query("ALTER TABLE `ris` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `riv` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `riv` DROP `id`");
$sql = mysql_query("ALTER TABLE `riv` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `bktel` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `bktel` DROP `id`");
$sql = mysql_query("ALTER TABLE `bktel` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `bkk` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `bkk` DROP `id`");
$sql = mysql_query("ALTER TABLE `bkk` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `bki` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `bki` DROP `id`");
$sql = mysql_query("ALTER TABLE `bki` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `bkt` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `bkt` DROP `id`");
$sql = mysql_query("ALTER TABLE `bkt` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `bkd` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `bkd` DROP `id`");
$sql = mysql_query("ALTER TABLE `bkd` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `bks` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `bks` DROP `id`");
$sql = mysql_query("ALTER TABLE `bks` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `bkp` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `bkp` DROP `id`");
$sql = mysql_query("ALTER TABLE `bkp` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `bkh` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `bkh` DROP `id`");
$sql = mysql_query("ALTER TABLE `bkh` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `bkg` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `bkg` DROP `id`");
$sql = mysql_query("ALTER TABLE `bkg` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `bptel` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `bptel` DROP `id`");
$sql = mysql_query("ALTER TABLE `bptel` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `bpk` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `bpk` DROP `id`");
$sql = mysql_query("ALTER TABLE `bpk` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `bpi` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `bpi` DROP `id`");
$sql = mysql_query("ALTER TABLE `bpi` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `bpt` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `bpt` DROP `id`");
$sql = mysql_query("ALTER TABLE `bpt` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `bpd` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `bpd` DROP `id`");
$sql = mysql_query("ALTER TABLE `bpd` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `bps` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `bps` DROP `id`");
$sql = mysql_query("ALTER TABLE `bps` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `bpp` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `bpp` DROP `id`");
$sql = mysql_query("ALTER TABLE `bpp` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `bph` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `bph` DROP `id`");
$sql = mysql_query("ALTER TABLE `bph` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `bpg` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `bpg` DROP `id`");
$sql = mysql_query("ALTER TABLE `bpg` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `bmtel` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `bmtel` DROP `id`");
$sql = mysql_query("ALTER TABLE `bmtel` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `bmk` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `bmk` DROP `id`");
$sql = mysql_query("ALTER TABLE `bmk` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `bmi` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `bmi` DROP `id`");
$sql = mysql_query("ALTER TABLE `bmi` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `bmt` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `bmt` DROP `id`");
$sql = mysql_query("ALTER TABLE `bmt` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `bmd` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `bmd` DROP `id`");
$sql = mysql_query("ALTER TABLE `bmd` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `bms` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `bms` DROP `id`");
$sql = mysql_query("ALTER TABLE `bms` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `bmp` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `bmp` DROP `id`");
$sql = mysql_query("ALTER TABLE `bmp` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `bmh` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `bmh` DROP `id`");
$sql = mysql_query("ALTER TABLE `bmh` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `bmg` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `bmg` DROP `id`");
$sql = mysql_query("ALTER TABLE `bmg` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `pkd` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `pkd` DROP `id`");
$sql = mysql_query("ALTER TABLE `pkd` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `pkv` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `pkv` DROP `id`");
$sql = mysql_query("ALTER TABLE `pkv` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `pkp` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `pkp` DROP `id`");
$sql = mysql_query("ALTER TABLE `pkp` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `pks` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `pks` DROP `id`");
$sql = mysql_query("ALTER TABLE `pks` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `pko` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `pko` DROP `id`");
$sql = mysql_query("ALTER TABLE `pko` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `pkstr` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `pkstr` DROP `id`");
$sql = mysql_query("ALTER TABLE `pkstr` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `pkdom` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `pkdom` DROP `id`");
$sql = mysql_query("ALTER TABLE `pkdom` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `pkpr` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `pkpr` DROP `id`");
$sql = mysql_query("ALTER TABLE `pkpr` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `ppd` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `ppd` DROP `id`");
$sql = mysql_query("ALTER TABLE `ppd` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `ppv` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `ppv` DROP `id`");
$sql = mysql_query("ALTER TABLE `ppv` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `ppp` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `ppp` DROP `id`");
$sql = mysql_query("ALTER TABLE `ppp` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `pps` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `pps` DROP `id`");
$sql = mysql_query("ALTER TABLE `pps` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `ppo` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `ppo` DROP `id`");
$sql = mysql_query("ALTER TABLE `ppo` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY FIRST ");
$sql = mysql_query("DELETE FROM `ppstr` WHERE `data` <NOW()-INTERVAL 7 DAY");
$sql = mysql_query("ALTER TABLE `ppstr` DROP `id`");
$sql = mysql_query("ALTER TABLE `ppstr` ADD `id` INT DEFAULT NULL AUTO_INCREMENT PRIMARY KEY | |
|
|
|
|
|
|
|
для: Денис2009
(16.09.2011 в 18:29)
| | код не полностью отображается, удаляется сарая нифа старше 7 дней затем удаляется стока id и вновь создается с новыми значениями. в id стоит автоинкремент. может это и не совсем правильно но работает стабильно и быстро 3 -4 секунды | |
|
|
|
|
|
|
|
для: Денис2009
(16.09.2011 в 18:29)
| | Можно уменьшить объем кода, но не количество запросов. Напрашивается решение, помещения названия таблиц в массив и выполнения приведенных выше запросов в цикле. | |
|
|
|