erosri in sql de la activity pt. jocuri
Scris: 03-Dec-2004, 22:45:02
SQL-query:
CREATE TABLE `phpbb_ina_tour` (
`tour_id` mediumint( 5 ) NOT NULL AUTO_INCREMENT ,
`tour_name` varchar( 25 ) default NULL ,
`tour_desc` text
)
MySQL said:
#1075 - Incorrect table definition; There can only be one auto column and it must be defined as a key
Error
SQL-query:
CREATE TABLE `phpbb_ina_cat` (
`cat_id` mediumint( 8 ) NOT NULL AUTO_INCREMENT ,
`mod_id` mediumint( 8 ) default NULL ,
`cat_name` varchar( 100 ) default NULL ,
`cat_desc` text,
`icon` varchar( 255 ) default NULL ,
`special_play` smallint( 5 ) NOT NULL default '0',
`last_game` varchar( 25 ) default NULL ,
`last_player` mediumint( 8 ) default NULL ,
`last_time` int( 11 ) default NULL
)
MySQL said:
#1075 - Incorrect table definition; There can only be one auto column and it must be defined as a key
de ce imi da erorile astea cand vreau sa pun aceste tabele in mysql...pt. activity (pt. jocuri)... celalalte au mers dar asta nu merge... ce trebuie sa fac? poate stii tu BuGSy ca am vazut ca te pricepi in mysql ... va rog ajutati-ma/// multumesc anticipat...
CREATE TABLE `phpbb_ina_tour` (
`tour_id` mediumint( 5 ) NOT NULL AUTO_INCREMENT ,
`tour_name` varchar( 25 ) default NULL ,
`tour_desc` text
)
MySQL said:
#1075 - Incorrect table definition; There can only be one auto column and it must be defined as a key
Error
SQL-query:
CREATE TABLE `phpbb_ina_cat` (
`cat_id` mediumint( 8 ) NOT NULL AUTO_INCREMENT ,
`mod_id` mediumint( 8 ) default NULL ,
`cat_name` varchar( 100 ) default NULL ,
`cat_desc` text,
`icon` varchar( 255 ) default NULL ,
`special_play` smallint( 5 ) NOT NULL default '0',
`last_game` varchar( 25 ) default NULL ,
`last_player` mediumint( 8 ) default NULL ,
`last_time` int( 11 ) default NULL
)
MySQL said:
#1075 - Incorrect table definition; There can only be one auto column and it must be defined as a key
de ce imi da erorile astea cand vreau sa pun aceste tabele in mysql...pt. activity (pt. jocuri)... celalalte au mers dar asta nu merge... ce trebuie sa fac? poate stii tu BuGSy ca am vazut ca te pricepi in mysql ... va rog ajutati-ma/// multumesc anticipat...