Making my first tabel - hlp

[Templar]

Hi. I am making my first tabel in my life and need some help. The lines are supposed to look like this:

Code: Select all

CREATE TABLE phpbb_themes_demo_info (
  themes_id mediumint( 8 ) unsigned NOT NULL,
  style_author varchar( 50 ) NOT NULL default '',
  style_converter varchar( 50 ) NOT NULL default '',
  style_version varchar( 10 ) NOT NULL default '',
  style_date date NOT NULL default '0000-00-00',
  style_website varchar( 100 ) NOT NULL default '',
  style_cwebsite varchar( 100 ) NOT NULL default '',
  style_download varchar( 100 ) NOT NULL default '',
  style_views mediumint( 8 ) unsigned NOT NULL default '0',
  style_downloads mediumint( 8 ) unsigned NOT NULL default '0',
  style_details text NOT NULL default '',
  PRIMARY KEY  (themes_id)
) TYPE=MyISAM;

INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('demoname', 'Styles Demo v1.1.0 ME');
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('pure_demo', '0');

This have I put into my phpmyadmin like this:
http://83.227.193.230/pic/mysql.gif

1. How do I get the '' chars inte the end of every line?

2. How do I put in "PRIMARY KEY (themes_id)" who is supposed to be in the end?

3. Why do I get the error "'style_details' can't have a default value"?

4. Have missed something more?

Big thanks in advance!

[Alexei Kubarev]

first of all: you have a syntax error there: TEXT field types do NOT have default values

You can select a primaty key check box in phpmyadmin

[Templar]

TACK! One step in the right direction. If you check the picture again at http://83.227.193.230/pic/mysql.gif

1. Is it fine to write as I have done in "default"? (default 'a'). It is supposed to be just default '' but I dosent manage to make it like that. Any ideas?

2. where do I add the code:

Code: Select all

INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('demoname', 'Styles Demo v1.1.0 ME');
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES ('pure_demo', '0');

?

[Alexei Kubarev]

you will need to go to the SQL browser to copy-paste it... or you may go to the insert screen and enter data manually

[Templar]

Tackar o bugar återigen (thx)

[Alexei Kubarev]

Hehe du är alltid välkommen med dina frågor