<?php
$result = dbquery("ALTER TABLE ".DB_PREFIX."photo_albums ADD album_sub MEDIUMINT( 7 ) NOT NULL ; ");
 
 if ($result) {
echo "Tabela została dodana.<br>";
} else {
echo "Nie dodano tabeli.<br>";
}
?>
Zinterpretowano w sekund: 0.025, wykorzystano GeSHi 1.0.8.10

<?php			
$result = dbquery("DROP TABLE IF EXISTS ".$db_prefix."photo_albums");
$result = dbquery("CREATE TABLE ".$db_prefix."photo_albums (
album_id MEDIUMINT(8) UNSIGNED NOT NULL AUTO_INCREMENT,
album_title VARCHAR(100) NOT NULL DEFAULT '',
album_description TEXT NOT NULL,
album_thumb VARCHAR(100) NOT NULL DEFAULT '',
album_user MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
album_access SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
album_order SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
album_datestamp INT(10) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (album_id),
KEY album_order (album_order),
KEY album_datestamp (album_datestamp)
) TYPE=MyISAM;");			
if ($result) { echo "ok"; } else { echo "Błąd";}			
?>
Zinterpretowano w sekund: 0.023, wykorzystano GeSHi 1.0.8.10