
Free V2.1ΪV3.0汾ݿ

һȵ¼ɰ汾̨ѡݴݿSQL䡱ִ²ɰ汾ݿ⣺

1alter table Ft_soft add column err_name varchar(50) default ""

2alter table Ft_soft add user_id integer default 0,passed integer default 0

3update Ft_soft set err_name="",passed=1,user_id=0

4alter table Ft_soft_cat add user_type integer default 0

5update Ft_soft_cat set user_type=0

6alter table Ft_soft drop column cat_name,class_name

7alter table Ft_soft alter column soft_roof varchar(100)

8alter table Ft_art_cat add user_type integer default 0

9update Ft_art_cat set user_type=0

10alter table Ft_course_cat add user_type integer default 0

11update Ft_course_cat set user_type=0

12alter table Ft_art add user_id integer default 0,passed integer default 0

13update Ft_art set passed=1,user_id=0

14alter table Ft_course add user_id integer default 0,passed integer default 0

15update Ft_course set passed=1,user_id=0

16update Ft_admin set admin_power="1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1" where admin_super=1

17update Ft_admin set admin_power="0,1,0,0,0,0,1,0,1,1,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,1,0,1,0,1,0" where admin_super=0

18alter table Ft_user add column user_power varchar(50) default ""

19update Ft_user set user_power="1#1#1#1#0" 

ע1#1#1#1#0ʾԱз//̳/ȨޣҪˣûԱз/̳/Ȩޣ1#0#0#0#0

ACESSݿ⣬ֹݿ

1ɾԭݿеFt_mb_styleɾ۱(Ft_art_remarkFt_course_remakFt_dj_remarkFt_news_remarkFt_soft_remarkFt_pic_remark

2.ֱӵupdate.mdbеFt_remarkFt_messageFt_mb_style

3ֹ޸ݿֶƣ

1Ft_picpic_name-->pic_title
2Ft_djdj_name-->dj_title
3Ft_diaryd_ֶȫΪdiary_ͷd_title --> diary_title
4Ft_coursec_ֶȫΪcourse_ͷc_title --> course_title
5Ft_softֶsoft_rcount-->soft_count

ݿɹɾǰ̨̨aspļincĿ¼imagesĿ¼SkinsĿ¼ȻϴЩݣ

ġʱɹԱÿԱȨޣ

塢ã鿴Ŀ


==================================
ڿС[PowerBy FeitecStudio Group] 15:01 2008-10-06




