Created
March 10, 2018 09:54
-
-
Save m-root/e515fbb7b2cfad253da3e063141e89ee to your computer and use it in GitHub Desktop.
Wordpess Schema in Django Models
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
from django.db import models | |
class WpCommentmeta(models.Model): | |
meta_id = models.BigAutoField(primary_key=True) | |
comment_id = models.BigIntegerField() | |
meta_key = models.CharField(max_length=255, blank=True, null=True) | |
meta_value = models.TextField(blank=True, null=True) | |
class Meta: | |
managed = False | |
db_table = 'wp_commentmeta' | |
class WpComments(models.Model): | |
comment_id = models.BigAutoField(db_column='comment_ID', primary_key=True) # Field name made lowercase. | |
comment_post_id = models.BigIntegerField(db_column='comment_post_ID') # Field name made lowercase. | |
comment_author = models.TextField() | |
comment_author_email = models.CharField(max_length=100) | |
comment_author_url = models.CharField(max_length=200) | |
comment_author_ip = models.CharField(db_column='comment_author_IP', max_length=100) # Field name made lowercase. | |
comment_date = models.DateTimeField() | |
comment_date_gmt = models.DateTimeField() | |
comment_content = models.TextField() | |
comment_karma = models.IntegerField() | |
comment_approved = models.CharField(max_length=20) | |
comment_agent = models.CharField(max_length=255) | |
comment_type = models.CharField(max_length=20) | |
comment_parent = models.BigIntegerField() | |
user_id = models.BigIntegerField() | |
class Meta: | |
managed = False | |
db_table = 'wp_comments' | |
class WpLinks(models.Model): | |
link_id = models.BigAutoField(primary_key=True) | |
link_url = models.CharField(max_length=255) | |
link_name = models.CharField(max_length=255) | |
link_image = models.CharField(max_length=255) | |
link_target = models.CharField(max_length=25) | |
link_description = models.CharField(max_length=255) | |
link_visible = models.CharField(max_length=20) | |
link_owner = models.BigIntegerField() | |
link_rating = models.IntegerField() | |
link_updated = models.DateTimeField() | |
link_rel = models.CharField(max_length=255) | |
link_notes = models.TextField() | |
link_rss = models.CharField(max_length=255) | |
class Meta: | |
managed = False | |
db_table = 'wp_links' | |
class WpNggAlbum(models.Model): | |
id = models.BigAutoField(primary_key=True) | |
name = models.CharField(max_length=255) | |
slug = models.CharField(max_length=255) | |
previewpic = models.BigIntegerField() | |
albumdesc = models.TextField(blank=True, null=True) | |
sortorder = models.TextField() | |
pageid = models.BigIntegerField() | |
extras_post_id = models.BigIntegerField() | |
class Meta: | |
managed = False | |
db_table = 'wp_ngg_album' | |
class WpNggGallery(models.Model): | |
gid = models.BigAutoField(primary_key=True) | |
name = models.CharField(max_length=255) | |
slug = models.CharField(max_length=255) | |
path = models.TextField(blank=True, null=True) | |
title = models.TextField(blank=True, null=True) | |
galdesc = models.TextField(blank=True, null=True) | |
pageid = models.BigIntegerField() | |
previewpic = models.BigIntegerField() | |
author = models.BigIntegerField() | |
extras_post_id = models.BigIntegerField() | |
class Meta: | |
managed = False | |
db_table = 'wp_ngg_gallery' | |
class WpNggPictures(models.Model): | |
pid = models.BigAutoField(primary_key=True) | |
image_slug = models.CharField(max_length=255) | |
post_id = models.BigIntegerField() | |
galleryid = models.BigIntegerField() | |
filename = models.CharField(max_length=255) | |
description = models.TextField(blank=True, null=True) | |
alttext = models.TextField(blank=True, null=True) | |
imagedate = models.DateTimeField() | |
exclude = models.IntegerField(blank=True, null=True) | |
sortorder = models.BigIntegerField() | |
meta_data = models.TextField(blank=True, null=True) | |
extras_post_id = models.BigIntegerField() | |
updated_at = models.BigIntegerField(blank=True, null=True) | |
class Meta: | |
managed = False | |
db_table = 'wp_ngg_pictures' | |
class WpOptions(models.Model): | |
option_id = models.BigAutoField(primary_key=True) | |
option_name = models.CharField(unique=True, max_length=191) | |
option_value = models.TextField() | |
autoload = models.CharField(max_length=20) | |
class Meta: | |
managed = False | |
db_table = 'wp_options' | |
class WpPostmeta(models.Model): | |
meta_id = models.BigAutoField(primary_key=True) | |
post_id = models.BigIntegerField() | |
meta_key = models.CharField(max_length=255, blank=True, null=True) | |
meta_value = models.TextField(blank=True, null=True) | |
class Meta: | |
managed = False | |
db_table = 'wp_postmeta' | |
class WpPosts(models.Model): | |
id = models.BigAutoField(db_column='ID', primary_key=True) # Field name made lowercase. | |
post_author = models.BigIntegerField() | |
post_date = models.DateTimeField() | |
post_date_gmt = models.DateTimeField() | |
post_content = models.TextField() | |
post_title = models.TextField() | |
post_excerpt = models.TextField() | |
post_status = models.CharField(max_length=20) | |
comment_status = models.CharField(max_length=20) | |
ping_status = models.CharField(max_length=20) | |
post_password = models.CharField(max_length=255) | |
post_name = models.CharField(max_length=200) | |
to_ping = models.TextField() | |
pinged = models.TextField() | |
post_modified = models.DateTimeField() | |
post_modified_gmt = models.DateTimeField() | |
post_content_filtered = models.TextField() | |
post_parent = models.BigIntegerField() | |
guid = models.CharField(max_length=255) | |
menu_order = models.IntegerField() | |
post_type = models.CharField(max_length=20) | |
post_mime_type = models.CharField(max_length=100) | |
comment_count = models.BigIntegerField() | |
class Meta: | |
managed = False | |
db_table = 'wp_posts' | |
class WpTermRelationships(models.Model): | |
object_id = models.BigIntegerField(primary_key=True) | |
term_taxonomy_id = models.BigIntegerField() | |
term_order = models.IntegerField() | |
class Meta: | |
managed = False | |
db_table = 'wp_term_relationships' | |
unique_together = (('object_id', 'term_taxonomy_id'),) | |
class WpTermTaxonomy(models.Model): | |
term_taxonomy_id = models.BigAutoField(primary_key=True) | |
term_id = models.BigIntegerField() | |
taxonomy = models.CharField(max_length=32) | |
description = models.TextField() | |
parent = models.BigIntegerField() | |
count = models.BigIntegerField() | |
class Meta: | |
managed = False | |
db_table = 'wp_term_taxonomy' | |
unique_together = (('term_id', 'taxonomy'),) | |
class WpTermmeta(models.Model): | |
meta_id = models.BigAutoField(primary_key=True) | |
term_id = models.BigIntegerField() | |
meta_key = models.CharField(max_length=255, blank=True, null=True) | |
meta_value = models.TextField(blank=True, null=True) | |
class Meta: | |
managed = False | |
db_table = 'wp_termmeta' | |
class WpTerms(models.Model): | |
term_id = models.BigAutoField(primary_key=True) | |
name = models.CharField(max_length=200) | |
slug = models.CharField(max_length=200) | |
term_group = models.BigIntegerField() | |
class Meta: | |
managed = False | |
db_table = 'wp_terms' | |
class WpUsermeta(models.Model): | |
umeta_id = models.BigAutoField(primary_key=True) | |
user_id = models.BigIntegerField() | |
meta_key = models.CharField(max_length=255, blank=True, null=True) | |
meta_value = models.TextField(blank=True, null=True) | |
class Meta: | |
managed = False | |
db_table = 'wp_usermeta' | |
class WpUsers(models.Model): | |
id = models.BigAutoField(db_column='ID', primary_key=True) # Field name made lowercase. | |
user_login = models.CharField(max_length=60) | |
user_pass = models.CharField(max_length=255) | |
user_nicename = models.CharField(max_length=50) | |
user_email = models.CharField(max_length=100) | |
user_url = models.CharField(max_length=100) | |
user_registered = models.DateTimeField() | |
user_activation_key = models.CharField(max_length=255) | |
user_status = models.IntegerField() | |
display_name = models.CharField(max_length=250) | |
class Meta: | |
managed = False | |
db_table = 'wp_users' |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment