MySQL:Tabellen
Aus Alexander's Wiki
Version vom 13. Februar 2014, 09:25 Uhr von Admin (Diskussion | Beiträge) (Die Seite wurde neu angelegt: „<source lang=sql> CREATE TABLE tbname ( id INT UNSIGNED AUTO_INCREMENT, name VARCHAR(255) NOT NULL, visible BOOLEAN NOT N…“)
CREATE TABLE tbname (
id INT UNSIGNED AUTO_INCREMENT,
name VARCHAR(255) NOT NULL,
visible BOOLEAN NOT NULL DEFAULT 0,
int_value INTEGER(10) DEFAULT NULL,
dec_value DECIMAL(8,2),
created DATETIME,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
ALTER TABLE tbname DEFAULT CHARACTER SET utf8 COLLATE utf8_german2_ci;
ALTER TABLE tbname ADD UNIQUE (name, visible);
ALTER TABLE tbname ADD CONSTRAINT fk_tbname_othertbname
FOREIGN KEY (id)
REFERENCES othertbname(id);