pdaj-DB
2007-11-27 17:07:12 创建 by soybean217@sina.com.cn | 2007-11-29 23:57:11 最后修改 by soybean217@sina.com.cn
编辑标题 插入资源
custom
2007-11-29 23:53:08来自IP：218.19.X.X by soybean217@sina.com.cn
| id |
bigint |
identity(1,1) |
|
primary key, |
| created |
datetime |
default getdate |
not null |
, |
| modified |
datetime |
default getdate |
not null |
, |
| email |
varchar(200) |
|
not null |
,--邮件 |
| pwd |
varchar(100) |
|
not null |
,--密码MD5加密 |
| state |
tinyint |
default 0 |
not null |
|
| nickname |
varchar(100) |
|
|
|
编辑以上内容 删除以上内容 追加资源
orgs
2007-11-29 23:50:40来自IP：218.19.X.X by soybean217@sina.com.cn
| id |
bigint |
identity(1,1) |
|
primary key, |
| created |
datetime |
default getdate |
not null |
, |
| modified |
datetime |
default getdate |
not null |
, |
| title |
varchar(400) |
|
not null |
,--公司或团体名,unique index |
| state |
tinyint |
default 0 |
not null |
|
编辑以上内容 删除以上内容 追加资源
sql
2007-11-29 23:56:59来自IP：218.19.X.X by soybean217@sina.com.cnuse pdaj
if exists(select top 1 * from dbo.sysobjects where id = object_id(N'[dbo].[customs]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table customs
create table customs(
id bigint not null identity(1,1) primary key,
created datetime not null default getdate(),
modified datetime not null default getdate(),
email varchar(200) not null ,--邮件,unique index
pwd varchar(400) not null ,--密码MD5加密
state tinyint default 0 not null ,
nickname varchar(100) ,
);
create unique index idx_customs_email on customs(email)
if exists(select top 1 * from dbo.sysobjects where id = object_id(N'[dbo].[orgs]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table orgs
create table orgs(
id bigint not null identity(1,1) primary key,
created datetime not null default getdate(),
modified datetime not null default getdate(),
title varchar(400) not null ,--公司或团体名,unique index
state tinyint default 0 not null ,
);
create unique index idx_orgs_title on orgs(title)
编辑以上内容 删除以上内容 追加资源
@@add_newSrcLink@@