Guest User

Untitled

a guest
Sep 20th, 2019
111
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. #
  2. # Table structure for table 'tx_blog_domain_model_blog'
  3. #
  4. CREATE TABLE tx_blog_domain_model_blog (
  5.  
  6.     title varchar(255) DEFAULT '' NOT NULL,
  7.     tags varchar(255) DEFAULT '' NOT NULL,
  8.     write_date datetime DEFAULT NULL,
  9.     page int(11) DEFAULT '0' NOT NULL,
  10.     title_image int(11) unsigned NOT NULL default '0',
  11.     footer_images int(11) unsigned DEFAULT '0' NOT NULL,
  12.     short_description text
  13.  
  14. );
  15.  
  16. #
  17. # Table structure for table 'tx_blog_domain_model_tag'
  18. #
  19. CREATE TABLE tx_blog_domain_model_tag(
  20.  
  21.     title varchar(255) DEFAULT '' NOT NULL,
  22.     parentid int(11) DEFAULT '0' NOT NULL,
  23.     tag varchar(255) DEFAULT '' NOT NULL,
  24.     tags varchar(255) DEFAULT '' NOT NULL
  25.  
  26.  
  27. );
  28.  
  29.  
  30. CREATE TABLE tx_blog_relation_mm (
  31.     uid int(11) NOT NULL auto_increment,
  32.     uid_local int(11) DEFAULT '0' NOT NULL,
  33.     uid_foreign int(11) DEFAULT '0' NOT NULL,
  34.     tablenames varchar(30) DEFAULT '' NOT NULL,
  35.     sorting int(11) DEFAULT '0' NOT NULL,
  36.     sorting_foreign int(11) DEFAULT '0' NOT NULL,
  37.     ident varchar(30) DEFAULT '' NOT NULL,
  38.  
  39.     KEY uid_local (uid_local),
  40.     KEY uid_foreign (uid_foreign),
  41.     PRIMARY KEY (uid)
  42. );
RAW Paste Data