Location: PHPKode > projects > Pimped-Fusion > db_updates_v0.08.01/db_update_10-06-19.txt
<?php

$result = dbquery("DROP TABLE IF EXISTS ".$db_prefix."admin_notes"); // pimped table
$result = dbquery("CREATE TABLE ".$db_prefix."admin_notes (
note_id MEDIUMINT(8) UNSIGNED NOT NULL AUTO_INCREMENT,
note_name VARCHAR(20) NOT NULL,
note_text TEXT NOT NULL,
note_datestamp INT(10) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (note_id)
) TYPE=MyISAM CHARACTER SET utf8 COLLATE utf8_general_ci;");

?>
Return current item: Pimped-Fusion