Skip to content

Instantly share code, notes, and snippets.

@m-root
Created March 10, 2018 09:54
Show Gist options
  • Save m-root/e515fbb7b2cfad253da3e063141e89ee to your computer and use it in GitHub Desktop.
Save m-root/e515fbb7b2cfad253da3e063141e89ee to your computer and use it in GitHub Desktop.
Wordpess Schema in Django Models
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