sql server - How do I create MS SQL tables for a fresh WordPress installation? -

-

i working on new wordpress site host online bookstore publishing company. .net developer rather use ms sql in combination wp db abstraction (https://wordpress.org/plugins/wordpress-database-abstraction/) plugin. did fresh install of brandoo wordpress (http://www.microsoft.com/web/gallery/brandoowordpressmssql.aspx) worked fine. when wanted create copies of database create instances of wordpress ran problems not of details relating tables structure, keys, constraints , default values not copied over.

what create table statements need create wordpress related tables in ms sql server?

for sql server 2012, following sql script creates needed tables wordpress 3.8.1.

use [wordpressdb] go  /****** object:  table [dbo].[wp_commentmeta]    script date: 4/6/2014 5:35:46 pm ******/ set ansi_nulls on go  set quoted_identifier on go  create table [dbo].[wp_commentmeta](     [meta_id] [bigint] identity(1,1) not null,     [comment_id] [bigint] not null,     [meta_key] [nvarchar](255) null,     [meta_value] [nvarchar](max) null,  constraint [wp_commentmeta_meta_id] primary key clustered  (     [meta_id] asc )with (pad_index = off, statistics_norecompute = off, ignore_dup_key = off, allow_row_locks = on, allow_page_locks = on) on [primary] ) on [primary] textimage_on [primary]  go  alter table [dbo].[wp_commentmeta] add  default ('0') [comment_id] go  alter table [dbo].[wp_commentmeta] add  default (null) [meta_key] go  /****** object:  table [dbo].[wp_comments]    script date: 4/6/2014 5:37:04 pm ******/ set ansi_nulls on go  set quoted_identifier on go  create table [dbo].[wp_comments](     [comment_id] [bigint] identity(1,1) not null,     [comment_post_id] [bigint] not null,     [comment_author] [nvarchar](max) not null,     [comment_author_email] [nvarchar](100) not null,     [comment_author_url] [nvarchar](200) not null,     [comment_author_ip] [nvarchar](100) not null,     [comment_date] [datetime] not null,     [comment_date_gmt] [datetime] not null,     [comment_content] [nvarchar](max) not null,     [comment_karma] [int] not null,     [comment_approved] [nvarchar](20) not null,     [comment_agent] [nvarchar](255) not null,     [comment_type] [nvarchar](20) not null,     [comment_parent] [bigint] not null,     [user_id] [bigint] not null,  constraint [wp_comments_comment_id] primary key clustered  (     [comment_id] asc )with (pad_index = off, statistics_norecompute = off, ignore_dup_key = off, allow_row_locks = on, allow_page_locks = on) on [primary] ) on [primary] textimage_on [primary]  go  alter table [dbo].[wp_comments] add  default ('0') [comment_post_id] go  alter table [dbo].[wp_comments] add  default ('') [comment_author_email] go  alter table [dbo].[wp_comments] add  default ('') [comment_author_url] go  alter table [dbo].[wp_comments] add  default ('') [comment_author_ip] go  alter table [dbo].[wp_comments] add  default (getdate()) [comment_date] go  alter table [dbo].[wp_comments] add  default (getdate()) [comment_date_gmt] go  alter table [dbo].[wp_comments] add  default ('0') [comment_karma] go  alter table [dbo].[wp_comments] add  default ('1') [comment_approved] go  alter table [dbo].[wp_comments] add  default ('') [comment_agent] go  alter table [dbo].[wp_comments] add  default ('') [comment_type] go  alter table [dbo].[wp_comments] add  default ('0') [comment_parent] go  alter table [dbo].[wp_comments] add  default ('0') [user_id] go  /****** object:  table [dbo].[wp_links]    script date: 4/6/2014 5:37:25 pm ******/ set ansi_nulls on go  set quoted_identifier on go  create table [dbo].[wp_links](     [link_id] [bigint] identity(1,1) not null,     [link_url] [nvarchar](255) not null,     [link_name] [nvarchar](255) not null,     [link_image] [nvarchar](255) not null,     [link_target] [nvarchar](25) not null,     [link_description] [nvarchar](255) not null,     [link_visible] [nvarchar](20) not null,     [link_owner] [bigint] not null,     [link_rating] [int] not null,     [link_updated] [datetime] not null,     [link_rel] [nvarchar](255) not null,     [link_notes] [nvarchar](max) not null,     [link_rss] [nvarchar](255) not null,  constraint [wp_links_link_id] primary key clustered  (     [link_id] asc )with (pad_index = off, statistics_norecompute = off, ignore_dup_key = off, allow_row_locks = on, allow_page_locks = on) on [primary] ) on [primary] textimage_on [primary]  go  alter table [dbo].[wp_links] add  default ('') [link_url] go  alter table [dbo].[wp_links] add  default ('') [link_name] go  alter table [dbo].[wp_links] add  default ('') [link_image] go  alter table [dbo].[wp_links] add  default ('') [link_target] go  alter table [dbo].[wp_links] add  default ('') [link_description] go  alter table [dbo].[wp_links] add  default ('y') [link_visible] go  alter table [dbo].[wp_links] add  default ('1') [link_owner] go  alter table [dbo].[wp_links] add  default ('0') [link_rating] go  alter table [dbo].[wp_links] add  default (getdate()) [link_updated] go  alter table [dbo].[wp_links] add  default ('') [link_rel] go  alter table [dbo].[wp_links] add  default ('') [link_rss] go  /****** object:  table [dbo].[wp_options]    script date: 4/6/2014 5:38:02 pm ******/ set ansi_nulls on go  set quoted_identifier on go  create table [dbo].[wp_options](     [option_id] [bigint] identity(1,1) not null,     [option_name] [nvarchar](64) not null,     [option_value] [nvarchar](max) not null,     [autoload] [nvarchar](20) not null,  constraint [wp_options_option_id] primary key clustered  (     [option_id] asc )with (pad_index = off, statistics_norecompute = off, ignore_dup_key = off, allow_row_locks = on, allow_page_locks = on) on [primary],  constraint [wp_options_option_name] unique nonclustered  (     [option_name] asc )with (pad_index = off, statistics_norecompute = off, ignore_dup_key = off, allow_row_locks = on, allow_page_locks = on) on [primary] ) on [primary] textimage_on [primary]  go  alter table [dbo].[wp_options] add  default ('') [option_name] go  alter table [dbo].[wp_options] add  default ('yes') [autoload] go   /****** object:  table [dbo].[wp_postmeta]    script date: 4/6/2014 5:38:19 pm ******/ set ansi_nulls on go  set quoted_identifier on go  create table [dbo].[wp_postmeta](     [meta_id] [bigint] identity(1,1) not null,     [post_id] [bigint] not null,     [meta_key] [nvarchar](255) null,     [meta_value] [nvarchar](max) null,  constraint [wp_postmeta_meta_id] primary key clustered  (     [meta_id] asc )with (pad_index = off, statistics_norecompute = off, ignore_dup_key = off, allow_row_locks = on, allow_page_locks = on) on [primary] ) on [primary] textimage_on [primary]  go  alter table [dbo].[wp_postmeta] add  default ('0') [post_id] go  alter table [dbo].[wp_postmeta] add  default (null) [meta_key] go   /****** object:  table [dbo].[wp_posts]    script date: 4/6/2014 5:38:37 pm ******/ set ansi_nulls on go  set quoted_identifier on go  create table [dbo].[wp_posts](     [id] [bigint] identity(1,1) not null,     [post_author] [bigint] not null,     [post_date] [datetime] not null,     [post_date_gmt] [datetime] not null,     [post_content] [nvarchar](max) not null,     [post_title] [nvarchar](max) not null,     [post_excerpt] [nvarchar](max) not null,     [post_status] [nvarchar](20) not null,     [comment_status] [nvarchar](20) not null,     [ping_status] [nvarchar](20) not null,     [post_password] [nvarchar](20) not null,     [post_name] [nvarchar](200) not null,     [to_ping] [nvarchar](max) not null,     [pinged] [nvarchar](max) not null,     [post_modified] [datetime] not null,     [post_modified_gmt] [datetime] not null,     [post_content_filtered] [nvarchar](max) not null,     [post_parent] [bigint] not null,     [guid] [nvarchar](255) not null,     [menu_order] [int] not null,     [post_type] [nvarchar](20) not null,     [post_mime_type] [nvarchar](100) not null,     [comment_count] [bigint] not null,  constraint [wp_posts_id] primary key clustered  (     [id] asc )with (pad_index = off, statistics_norecompute = off, ignore_dup_key = off, allow_row_locks = on, allow_page_locks = on) on [primary] ) on [primary] textimage_on [primary]  go  alter table [dbo].[wp_posts] add  default ('0') [post_author] go  alter table [dbo].[wp_posts] add  default (getdate()) [post_date] go  alter table [dbo].[wp_posts] add  default (getdate()) [post_date_gmt] go  alter table [dbo].[wp_posts] add  default ('publish') [post_status] go  alter table [dbo].[wp_posts] add  default ('open') [comment_status] go  alter table [dbo].[wp_posts] add  default ('open') [ping_status] go  alter table [dbo].[wp_posts] add  default ('') [post_password] go  alter table [dbo].[wp_posts] add  default ('') [post_name] go  alter table [dbo].[wp_posts] add  default (getdate()) [post_modified] go  alter table [dbo].[wp_posts] add  default (getdate()) [post_modified_gmt] go  alter table [dbo].[wp_posts] add  default ('0') [post_parent] go  alter table [dbo].[wp_posts] add  default ('') [guid] go  alter table [dbo].[wp_posts] add  default ('0') [menu_order] go  alter table [dbo].[wp_posts] add  default ('post') [post_type] go  alter table [dbo].[wp_posts] add  default ('') [post_mime_type] go  alter table [dbo].[wp_posts] add  default ('0') [comment_count] go  /****** object:  table [dbo].[wp_term_relationships]    script date: 4/6/2014 5:38:54 pm ******/ set ansi_nulls on go  set quoted_identifier on go  create table [dbo].[wp_term_relationships](     [object_id] [bigint] not null,     [term_taxonomy_id] [bigint] not null,     [term_order] [int] not null,  constraint [wp_term_relationships_object_id_term_taxonomy_id] primary key clustered  (     [object_id] asc,     [term_taxonomy_id] asc )with (pad_index = off, statistics_norecompute = off, ignore_dup_key = off, allow_row_locks = on, allow_page_locks = on) on [primary] ) on [primary]  go  alter table [dbo].[wp_term_relationships] add  default ((0)) [object_id] go  alter table [dbo].[wp_term_relationships] add  default ((0)) [term_taxonomy_id] go  alter table [dbo].[wp_term_relationships] add  default ((0)) [term_order] go   /****** object:  table [dbo].[wp_term_taxonomy]    script date: 4/6/2014 5:39:09 pm ******/ set ansi_nulls on go  set quoted_identifier on go  create table [dbo].[wp_term_taxonomy](     [term_taxonomy_id] [bigint] identity(1,1) not null,     [term_id] [bigint] not null,     [taxonomy] [nvarchar](32) not null,     [description] [nvarchar](max) not null,     [parent] [bigint] not null,     [count] [bigint] not null,  constraint [wp_term_taxonomy_term_taxonomy_id] primary key clustered  (     [term_taxonomy_id] asc )with (pad_index = off, statistics_norecompute = off, ignore_dup_key = off, allow_row_locks = on, allow_page_locks = on) on [primary] ) on [primary] textimage_on [primary]  go  alter table [dbo].[wp_term_taxonomy] add  default ((0)) [term_id] go  alter table [dbo].[wp_term_taxonomy] add  default ('') [taxonomy] go  alter table [dbo].[wp_term_taxonomy] add  default ((0)) [parent] go  alter table [dbo].[wp_term_taxonomy] add  default ((0)) [count] go   /****** object:  table [dbo].[wp_terms]    script date: 4/6/2014 5:39:27 pm ******/ set ansi_nulls on go  set quoted_identifier on go  create table [dbo].[wp_terms](     [term_id] [bigint] identity(1,1) not null,     [name] [nvarchar](200) not null,     [slug] [nvarchar](200) not null,     [term_group] [bigint] not null,  constraint [wp_terms_term_id] primary key clustered  (     [term_id] asc )with (pad_index = off, statistics_norecompute = off, ignore_dup_key = off, allow_row_locks = on, allow_page_locks = on) on [primary] ) on [primary]  go  alter table [dbo].[wp_terms] add  default ('') [name] go  alter table [dbo].[wp_terms] add  default ('') [slug] go  alter table [dbo].[wp_terms] add  default ((0)) [term_group] go   /****** object:  table [dbo].[wp_usermeta]    script date: 4/6/2014 5:39:41 pm ******/ set ansi_nulls on go  set quoted_identifier on go  create table [dbo].[wp_usermeta](     [umeta_id] [bigint] identity(1,1) not null,     [user_id] [bigint] not null,     [meta_key] [nvarchar](255) null,     [meta_value] [nvarchar](max) null,  constraint [wp_usermeta_umeta_id] primary key clustered  (     [umeta_id] asc )with (pad_index = off, statistics_norecompute = off, ignore_dup_key = off, allow_row_locks = on, allow_page_locks = on) on [primary] ) on [primary] textimage_on [primary]  go  alter table [dbo].[wp_usermeta] add  default ('0') [user_id] go  alter table [dbo].[wp_usermeta] add  default (null) [meta_key] go   /****** object:  table [dbo].[wp_users]    script date: 4/6/2014 5:39:57 pm ******/ set ansi_nulls on go  set quoted_identifier on go  create table [dbo].[wp_users](     [id] [bigint] identity(1,1) not null,     [user_login] [nvarchar](60) not null,     [user_pass] [nvarchar](64) not null,     [user_nicename] [nvarchar](50) not null,     [user_email] [nvarchar](100) not null,     [user_url] [nvarchar](100) not null,     [user_registered] [datetime] not null,     [user_activation_key] [nvarchar](60) not null,     [user_status] [int] not null,     [display_name] [nvarchar](250) not null,  constraint [wp_users_id] primary key clustered  (     [id] asc )with (pad_index = off, statistics_norecompute = off, ignore_dup_key = off, allow_row_locks = on, allow_page_locks = on) on [primary] ) on [primary]  go  alter table [dbo].[wp_users] add  default ('') [user_login] go  alter table [dbo].[wp_users] add  default ('') [user_pass] go  alter table [dbo].[wp_users] add  default ('') [user_nicename] go  alter table [dbo].[wp_users] add  default ('') [user_email] go  alter table [dbo].[wp_users] add  default ('') [user_url] go  alter table [dbo].[wp_users] add  default (getdate()) [user_registered] go  alter table [dbo].[wp_users] add  default ('') [user_activation_key] go  alter table [dbo].[wp_users] add  default ('0') [user_status] go  alter table [dbo].[wp_users] add  default ('') [display_name] go

Comments

Post a Comment

Popular posts from this blog

c# - Unity IoC Lifetime per HttpRequest for UserStore -

-
i'm trying clean default implementation of accountcontroller.cs comes out of box in new mvc5/owin security implementation. have modified constructor this: private usermanager<applicationuser> usermanager; public accountcontroller(usermanager<applicationuser> usermanager) { this.usermanager = usermanager; } also, have created lifetime manager unity looks this: public class httpcontextlifetimemanager<t> : lifetimemanager, idisposable { private httpcontextbase _context = null; public httpcontextlifetimemanager() { _context = new httpcontextwrapper(httpcontext.current); } public httpcontextlifetimemanager(httpcontextbase context) { if (context == null) throw new argumentnullexception("context"); _context = context; } public void dispose() { this.removevalue(); } public override object get...
Read more

Change the color of an oval at click in Java AWT -

-
i have draw ovals in java, , @ click change color. beginning tried change color after 20 ms, doesn't work. my code is: public class mycomponentnew extends frame { public graphics2d g2d; public mycomponentnew(string title) { super(title); setsize(400, 550); } @override public void paint(graphics g) { this.g2d = (graphics2d) g; this.g2d.setcolor(color.red); this.g2d.filloval(10, 55, 50, 100); } public void changecolor () { this.g2d.setcolor(color.blue); this.g2d.filloval(10, 55, 50, 100); } } and in class main method have: mycomponentnew m; m = new mycomponentnew("fereastra cu baloane"); m.setvisible(true); m.addwindowlistener(new windowadapter() { @override public void windowclosing(windowevent we) { system.exit(0); } }); try { thread.sleep(20); } catch(interruptedexception e) {} m.changecolor(); the color of oval remains red. ...
Read more

I am trying to solve the error message 'incompatible ranks 0 and 1 in assignment' in a fortran 95 program. -

-
i writing program in fortran find velocity of parachuting person in relation time. keep getting error can't fix. new programming , appreciated. the error is v(i+1)=v(i)+[32-((c*v(i)*v(i))/m)]*(h) 1 error: incompatible ranks 0 , 1 in assignment @ (1) and program is program para integer :: real :: v(11) !velocity real :: q !initial velocity real :: h !time step real :: c !drag coefficient real :: m !mass ! gravity equal 32 ft/s^2 write (*,*)'enter time step' read(*,*)h write(*,*)'enter initial velocity' read(*,*)q write(*,*)'enter drag coefficient' read(*,*)c write(*,*)'enter mass' read(*,*)m i=1,10 ! 1 10, 1 being interval. end v(i+1)=v(i)+[32-((c*v(i)*v(i))/m)]*(h) q=v(1) end program you cannot use [] normal parenthesis in expressions. array constructor, [ items ] means array items elements. end do should after line.
Read more