For DV7.1.0sql versions of the network, there are 2 versions that are leaking from commercial users. One is Club.sql with a file size of 127K (128K, the other is 124K Club.sql.
The original time of 127kclub.sql should be 2005/04/04 15:18, while 124K Club.sql file is 2005/04/07 16:13, two files are all official. But 128K is used for beta test, which is issued to administrators, moderators, and small part of business users; 124K is the official final release file. Quote: Forum commercial new version begins, please contact us in time http://bbs.dvbbs.net/dispbbs.asp?boardid=8&id=939112&page=1 Publish post is: 2005-04-07 17:53
I am in line with the difference between Access and two SQL data:
1, the difference between Access and the second SQL database:
SQL's than Access is a DV_TEMPLATES table,
And canceled the DV_NOTDOWNLOAD table required for Access.
Of course, I didn't contrast the two fields.
2, the difference between the first SQL and the second SQL:
In the design: The first is more: DV_ADCODE, DV_BLACKOLMENU these two tables.
The stored procedure is exactly the same, only the word is not bad!
==============================
2005.04.21 Supplement:
Deleted script:
If EXISTS (Select * from dbo.sysObjects where id = Object_id (n '[dv_adcode]') And ObjectProperty (ID, N'ISUSERTABLE ') = 1) DROP TABLE [DV_ADCODE] Go
Go
If Exists (Select * from dbo.sysObjects where id = Object_id (n '[dv_blackolmenu]') And ObjectProperty (ID, n'susertable ') = 1) DROP TABLE [DV_BLACKOLMENU]
Create Table [DV_ADCODE] ([A_ID] [INT] Identity (1, 1) NOT NULL, [A_ADDRESS] [VARCHAR] (5) Collate Chinese_PRC_CI_AS NULL, [A_FileType] [VARCHAR] (5) Collate Chinese_PRC_CI_AS NULL, [A_RATE] [varchar] (5) COLLATE Chinese_PRC_CI_AS NULL, [A_Adcode] [text] COLLATE Chinese_PRC_CI_AS NULL, [A_AddTime] [smalldatetime] NULL, [A_IsForum] [tinyint] NULL) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO
Go
Create Table [DV_BLACKOLMENU] ([ID] [INT] Identity (1, 1) NOT NULL, [Menutext] [Text] Collate Chinese_PRC_CI_AS NULL) ON [PRIMARY] textImage_on [primary] [CREATE TABLE [DV_USERGROUPS]]
[Isdisp] [tinyint] NULL,
Alter Table [DV_ADCode] with nocheck address [pk_dv_adcode] primary key clustered ([A_ID]) on [primary] Go
Go
Alter Table [DV_BLACKOLMENU] with nocheck add constraint [pk_dv_bmenu] Primary Key Clustered ([ID]) on [Primary]
ALTER TABLE [DV_ADCODE] add constraint [DF_DV_ADCODE_A_ADDTIME] Default (getdate ()) for [a_addtime], consTRAINT [DF_DV_ADCODE_A_ISFORUM] Default (0) for [a_isforum] GO
Create Index [DISP] ON [DV_ADCODE] ([A_ADDRESS]) ON [PRIMARY] GO
