vanli65 Posted February 9, 2013 Share Posted February 9, 2013 (edited) CREATE TABLE mybb_posts( pid INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT , tid INT( 10 ) UNSIGNED NOT NULL , replyto INT( 10 ) UNSIGNED NOT NULL , fid SMALLINT( 5 ) UNSIGNED NOT NULL , subject VARCHAR( 120 ) NOT NULL , icon SMALLINT( 5 ) UNSIGNED NOT NULL , uid INT( 10 ) UNSIGNED NOT NULL , username VARCHAR( 80 ) NOT NULL , dateline BIGINT( 30 ) NOT NULL , ***** message """"TEXT ( " ) """" NOT NULL , ***** ipaddress VARCHAR( 30 ) NOT NULL , longipaddress INT( 11 ) NOT NULL , includesig INT( 1 ) NOT NULL , smilieoff INT( 1 ) NOT NULL , edituid INT( 10 ) UNSIGNED NOT NULL , edittime INT( 10 ) NOT NULL , visible INT( 1 ) NOT NULL , posthash VARCHAR( 32 ) NOT NULL , thumbsup INT( 11 ) NOT NULL , thumbsdown INT( 11 ) NOT NULL , PRIMARY KEY ( pid ) , KEY tid( tid, uid ) , KEY uid( uid ) , KEY visible( visible ) , KEY dateline( dateline ) , KEY longipaddress( longipaddress ) , KEY message( message ) ); arkadaşlar message yerinede yani kırmızı ile *** bölge message ...? TEXT (?) not null yerine ne gelmesi gerekiyor. bu konuda bana acil yardım gerekli Edited February 9, 2013 by vanli65 Quote Link to comment Share on other sites More sharing options...
yasak_ask Posted February 9, 2013 Share Posted February 9, 2013 (edited) Mesaj başlığında acil vs. yazmaması gerekiyor kurallar gereği. Bilginize Madde 16. Başlıklarınızda açıklayıcı olmalısınız. Hiçbir açıklayıcılığı olmayan "yardım edin", "lütfen dikkat", "acil" ve benzeri kelimeleri başlık içerisinde kullanmamalısınız. Edited February 9, 2013 by yasak_ask Quote Link to comment Share on other sites More sharing options...
SecondLife Posted February 9, 2013 Share Posted February 9, 2013 (edited) CREATE TABLE mybb_posts( pid INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT , tid INT( 10 ) UNSIGNED NOT NULL , replyto INT( 10 ) UNSIGNED NOT NULL , fid SMALLINT( 5 ) UNSIGNED NOT NULL , subject VARCHAR( 120 ) NOT NULL , icon SMALLINT( 5 ) UNSIGNED NOT NULL , uid INT( 10 ) UNSIGNED NOT NULL , username VARCHAR( 80 ) NOT NULL , dateline BIGINT( 30 ) NOT NULL , ***** message """"TEXT ( " ) """" NOT NULL , ***** ipaddress VARCHAR( 30 ) NOT NULL , longipaddress INT( 11 ) NOT NULL , includesig INT( 1 ) NOT NULL , smilieoff INT( 1 ) NOT NULL , edituid INT( 10 ) UNSIGNED NOT NULL , edittime INT( 10 ) NOT NULL , visible INT( 1 ) NOT NULL , posthash VARCHAR( 32 ) NOT NULL , thumbsup INT( 11 ) NOT NULL , thumbsdown INT( 11 ) NOT NULL , PRIMARY KEY ( pid ) , KEY tid( tid, uid ) , KEY uid( uid ) , KEY visible( visible ) , KEY dateline( dateline ) , KEY longipaddress( longipaddress ) , KEY message( message ) ); arkadaşlar message yerinede yani kırmızı ile *** bölge message ...? TEXT (?) not null yerine ne gelmesi gerekiyor. bu konuda bana acil yardım gerekli `message` longblob NOT NULL, veya `message` blob NOT NULL, alan adı = TEXT Alan türü =longblob Edited February 9, 2013 by SecondLife Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.