how to create new tables *easily* ?

[xtian]

hi,

Thanks for the script ! It's taken me a bit of patience and working around some hindrances, but I managed to make the whole stuff work eventually ! This forum is quite relevant !

It's my very first day on a database, and I don't know what 's the simplest way to create new tables for use on the database I set up for dadabik. I don't think there is a way to do it *from* the dadabik admin page. Do you confirm ?
Do I have to create the new tables from phpMyadmin, and if yes what is the easiest way to do so ?

thanks !

xtian

 

[Mark]

The best way is with phpMyAdmin and do a query on the database. For example:

CREATE TABLE abhaengigkeiten (
ID_NR int(8) NOT NULL auto_increment,
SYSTEM_SERVICE text,
APP_KOMP text,
APP_KOMP2 text NOT NULL,
DATENBANK text NOT NULL,
HW_KOMP text,
BET_ABTEILUNG text,
AUSWIRKUNG text,
VERANTWORTLICH text,
DATUM_GEANDERT timestamp(14) NOT NULL,
GEANDERT_VON text NOT NULL,
KOMMENTAR text NOT NULL,
PRIMARY KEY (ID_NR)
) TYPE=MyISAM;


I've used this method repeatedly, especially when I wanted to create similiar tables.