Subscribe:Posts Comments

You Are Here: Home » Yeniden Mühendislik » Yeniden Mühendislik Uygulaması

Share in top social networks!

Yeniden Mühendislik Uygulaması
Aşağıda WordPress için Yeniden Mühendislik amacıyla yaptığımız uygulama parçasına ait SQL Kodları ve bu kapsamda ilişkilendirilen 2 tablonun son resmi verilmektedir.


Yeniden Mühendislik Uygulaması İçin SQL Kodu

CREATE TABLE `wp_users_101` (
  `ID` bigint(20) unsigned NOT NULL auto_increment,
  `user_login` varchar(60) NOT NULL default '',
  `user_pass` varchar(64) NOT NULL default '',
  `user_nicename` varchar(50) NOT NULL default '',
  `user_email` varchar(100) NOT NULL default '',
  `user_url` varchar(100) NOT NULL default '',
  `user_registered` datetime NOT NULL default '0000-00-00 00:00:00',
  `user_activation_key` varchar(60) NOT NULL default '',
  `user_status` int(11) NOT NULL default '0',
  `display_name` varchar(250) NOT NULL default '',
  PRIMARY KEY  (`ID`),
  KEY `user_login_key` (`user_login`),
  KEY `user_nicename` (`user_nicename`)
) TYPE=INNODB;

CREATE TABLE `wp_posts_101` (
  `ID` bigint(20) unsigned NOT NULL auto_increment,
  `post_author` bigint(20) unsigned NOT NULL default '0',
  `post_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `post_date_gmt` datetime NOT NULL default '0000-00-00 00:00:00',
  `post_content` longtext NOT NULL,
  `post_title` text NOT NULL,
  `post_excerpt` text NOT NULL,
  `post_status` varchar(20) NOT NULL default 'publish',
  `comment_status` varchar(20) NOT NULL default 'open',
  `ping_status` varchar(20) NOT NULL default 'open',
  `post_password` varchar(20) NOT NULL default '',
  `post_name` varchar(200) NOT NULL default '',
  `to_ping` text NOT NULL,
  `pinged` text NOT NULL,
  `post_modified` datetime NOT NULL default '0000-00-00 00:00:00',
  `post_modified_gmt` datetime NOT NULL default '0000-00-00 00:00:00',
  `post_content_filtered` text NOT NULL,
  `post_parent` bigint(20) unsigned NOT NULL default '0',
  `guid` varchar(255) NOT NULL default '',
  `menu_order` int(11) NOT NULL default '0',
  `post_type` varchar(20) NOT NULL default 'post',
  `post_mime_type` varchar(100) NOT NULL default '',
  `comment_count` bigint(20) NOT NULL default '0',
  PRIMARY KEY  (`ID`),
  KEY `post_name` (`post_name`),
  KEY `type_status_date` (`post_type`,`post_status`,`post_date`,`ID`),
  KEY `post_parent` (`post_parent`),
  KEY `post_author` (`post_author`)
) TYPE=INNODB;

ALTER TABLE wp_posts_101 ADD FOREIGN KEY (post_parent)
         REFERENCES wp_posts_101 (ID);

ALTER TABLE wp_posts_101 ADD FOREIGN KEY (post_author)
         REFERENCES wp_users_101(ID);

Yazıya link için aşağıdaki kodu kullanabilirsiniz


Share this:
Share this page via Email Share this page via Stumble Upon Share this page via Digg this Share this page via Facebook Share this page via Twitter

Share in top social networks!

Leave a Reply

*

Muhtevasını değiştirmemek şartıyla yazılardan istifade edebilirsiniz.
© 2011 Prof. DR. B. Gültekin ÇETİNER · Subscribe:PostsComments · Designed by Theme Junkie · Powered by WordPress

Faiz Lobisi