Odp: Evo natala by Kolesiek
Probowalem zaimportowac SQL do localhosta i wyskoczylo cos takiego.
--
CREATE TABLE IF NOT EXISTS `accounts` (
`id` INT( 11 ) NOT NULL AUTO_INCREMENT ,
`name` VARCHAR( 32 ) NOT NULL DEFAULT '',
`password` VARCHAR( 255 ) NOT NULL ,
`salt` VARCHAR( 40 ) NOT NULL DEFAULT '',
`premdays` INT( 11 ) NOT NULL DEFAULT '0',
`lastpremdays` INT( 11 ) NOT NULL DEFAULT '0',
`lastday` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0',
`email` VARCHAR( 255 ) NOT NULL DEFAULT '',
`key` VARCHAR( 32 ) NOT NULL DEFAULT '0',
`blocked` TINYINT( 1 ) NOT NULL DEFAULT '0' COMMENT 'internal usage',
`warnings` INT( 11 ) NOT NULL DEFAULT '0',
`group_id` INT( 11 ) NOT NULL DEFAULT '1',
`premium_points` INT( 11 ) NOT NULL DEFAULT '0',
`email_new` VARCHAR( 255 ) NOT NULL ,
`email_new_time` INT( 15 ) NOT NULL ,
`email_code` VARCHAR( 255 ) NOT NULL DEFAULT '0',
`next_email` INT( 11 ) NOT NULL DEFAULT '0',
`created` INT( 11 ) NOT NULL ,
`page_lastday` INT( 11 ) NOT NULL ,
`page_access` INT( 11 ) NOT NULL DEFAULT '0',
`rlname` VARCHAR( 255 ) NOT NULL ,
`location` VARCHAR( 255 ) NOT NULL ,
`flag` VARCHAR( 255 ) NOT NULL ,
`vote` INT( 11 ) NOT NULL ,
`last_post` INT( 11 ) NOT NULL DEFAULT '0',
`vip_time` INT( 11 ) NOT NULL ,
PRIMARY KEY ( `id` ) ,
UNIQUE KEY `name` ( `name` )
) ENGINE = INNODB DEFAULT CHARSET = latin1 AUTO_INCREMENT =4;