Просмотр поста

NIKO, Ну вот запросы (убери функции и "" , запрос в бд сделай...)
mysql_query("CREATE TABLE IF NOT EXISTS `shop` (
`id` INT NOT NULL AUTO_INCREMENT ,
`name` VARCHAR( 50 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
`link` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
`balans` INT( 10 ) NOT NULL ,
`sub` VARCHAR( 20 ) NOT NULL ,
PRIMARY KEY ( `id` )
) ENGINE = MYISAM ;");
mysql_query("INSERT INTO `shop` SET `name`='karma', `balans`='300', `sub`='modul'");
mysql_query("INSERT INTO `shop` SET `name`='status', `balans`='500', `sub`='modul'");
mysql_query("INSERT INTO `shop` SET `name`='ban', `balans`='600', `sub`='modul'");

mysql_query("INSERT INTO `shop` SET `name`='cnik', `balans`='400', `sub`='modul'");
mysql_query("INSERT INTO `shop` SET `name`='cstatus', `balans`='300', `sub`='modul'");
mysql_query("INSERT INTO `shop` SET `name`='nik', `balans`='600', `sub`='modul'");
mysql_query("ALTER TABLE `users` ADD `color` VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
ADD `cstatus` VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL");