artemishaber full sql dump 06.12.2021

Reisci' Alıntı:

DROP TABLE categories;

CREATE TABLE `categories` (
`autoid` int(11) NOT NULL AUTO_INCREMENT,
`name` text COLLATE utf8_unicode_ci NOT NULL,
`topcategory` int(11) NOT NULL,
`active` tinyint(1) NOT NULL,
`memberonly` tinyint(1) NOT NULL,
`commentdisabled` tinyint(1) NOT NULL,
`orderid` int(11) NOT NULL,
`image` text COLLATE utf8_unicode_ci NOT NULL,
`mainpage` int(11) NOT NULL,
`topmenu` int(11) NOT NULL,
PRIMARY KEY (`autoid`)
) ENGINE=MyISAM AUTO_INCREMENT=22 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO categories VALUES("14","GÜNCEL","0","1","0","0","1","","1","1");
INSERT INTO categories VALUES("15","YEREL","0","1","0","0","0","","1","1");
INSERT INTO categories VALUES("16","SPOR","0","1","0","0","3","","1","1");
INSERT INTO categories VALUES("17","ESNAF","0","1","0","0","4","","1","1");
INSERT INTO categories VALUES("18","SİYASET","0","1","0","1","5","","1","1");
INSERT INTO categories VALUES("19","EĞİTİM","0","1","0","0","7","","1","1");
INSERT INTO categories VALUES("20","KÜLTÜR","0","1","0","0","8","","1","1");
INSERT INTO categories VALUES("21","YAZILAR","0","1","0","0","8","","1","1");



DROP TABLE cornerposts;

CREATE TABLE `cornerposts` (
`autoid` int(11) NOT NULL AUTO_INCREMENT,
`columnistid` int(11) NOT NULL,
`title` text COLLATE utf8_unicode_ci NOT NULL,
`content` text COLLATE utf8_unicode_ci NOT NULL,
`active` tinyint(1) NOT NULL,
`dateadded` date NOT NULL,
`memberonly` tinyint(1) NOT NULL,
`commentdisabled` tinyint(1) NOT NULL,
PRIMARY KEY (`autoid`)
) ENGINE=MyISAM AUTO_INCREMENT=559 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


download :

*** Gizli metin: alıntı yapılamaz. ***

Genişletmek için tıkla ...

NasyoneL' Alıntı:

Teşekkürler

Genişletmek için tıkla ...