CREATE TABLE IF NOT EXISTS `fr - SQL - NoPaste.me

26.01.2012 - 14:37

Private

Report Download Raw Expand Content

Show Options

CREATE TABLE IF NOT EXISTS `friendships` (
`id` INT NOT NULL AUTO_INCREMENT,
`user1` INT NOT NULL DEFAULT 0,
`user2` INT NOT NULL DEFAULT 0,
`active` int NOT NULL DEFAULT 0,
`created` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY ( `id` )
);
 
CREATE TABLE IF NOT EXISTS `log` (
`id` INT NOT NULL AUTO_INCREMENT,
`user` INT NOT NULL DEFAULT 0,
`activity` int NOT NULL DEFAULT 0, /* 1 = Freundschaft; 2 = Freundschaft beendet; 3 = Aktivität */
`arguments` TEXT NOT NULL DEFAULT '',
`created` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY ( `id` )
);

NoPaste.me

Login