phpBB.de

Code: Alles auswählen

CREATE TABLE `pja_userverwaltung` (
  `id` int(11) NOT NULL auto_increment,
  `pja_id` varchar (50) NOT NULL default '',
  `pja_code` varchar (50) NOT NULL default '',
  `name` varchar(100) NOT NULL default '',
  `vorname` varchar(100) NOT NULL default '',
  `strasse` varchar(100) NOT NULL default '',
  `nummer` varchar(100) NOT NULL default '',
  `plz` varchar(100) NOT NULL default '',
  `ort` varchar(100) NOT NULL default '',
  `telefon` varchar(100) NOT NULL default '',
  `telefax` varchar(100) NOT NULL default '',
  `mail` varchar(100) NOT NULL default '',
  `gtag` varchar(100) NOT NULL default '',
  `clanname` varchar(100) NOT NULL default '',
  `clankuerzel` varchar(100) NOT NULL default '',
  `leadernick` varchar(100) NOT NULL default '',
  `leadername` varchar(100) NOT NULL default '',
  `leadervorname` varchar(100) NOT NULL default '',
  `leadermail` varchar(100) NOT NULL default '',
  `details` text NOT NULL,
  `agb` varchar (50) NOT NULL default '',
  `url` varchar (50) NOT NULL default '',
  PRIMARY KEY  (`id`)
)


INSERT INTO `pja_userverwaltung` VALUES ('pjaid', 'pjacode', 'name', 'vorname', 'strasse', 'nummer', 'plz', 'ort', 'telefon', 'telefax', 'mail', 'gtag', 'clanname', 'clankuerzel', 'leadernick', 'leadername', 'leadervorname', 'leadermail', 'details', 'agb', 'url');

Code: Alles auswählen

#1064 - You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT INTO `pja_userverwaltung` VALUES ('pjaid', 'pjacode' 

Code: Alles auswählen

  PRIMARY KEY  (`id`) 
)

Code: Alles auswählen

  PRIMARY KEY  (`id`) 
);

Code: Alles auswählen

 'pajoas.de/still',);

Code: Alles auswählen

 'pajoas.de/still');