工作文档备案(oracle建表..........)

创建表 
CREATE TABLE t_channel (
channel_id number(20) primary key NOT NULL ,//主键约束，非空约束

channel_name varchar2 (50) NOT NULL , 
website_id number(20) NOT NULL , 
channel_parent number(20) NULL , 
doc_count number(20) NOT NULL ,
visit_today number(20) NOT NULL ,
visit_total number(20) NOT NULL , 
display varchar2 (10) DEFAULT ('true') NULL ,//默认值
title varchar2 (50) NULL , 
description varchar2 (50) NULL ,
channel_url varchar2 (50) NOT NULL , 
channel_function varchar2 (50) NOT NULL , 
displayorder number(20) NOT NULL , 
depth number(20) NULL ,
chan_article_url varchar2 (50) NULL ,
chan_article_function varchar2 (50) NULL , 
chan_article_path varchar2 (50) NULL , 
menu varchar2 (10) NULL ,
channel_model_url number(20) NULL , 
channel_model_urlpath varchar2 (100) NULL ) ; 

 
CREATE TABLE t_role_x_permission (
role_id number(20) NOT NULL , 
permission_id number(20) NOT NULL ,
primary key (role_id,permission_id),//主键约束 
FOREIGN KEY (permission_id )  REFERENCES t_permission (permission_id ),//外键约束 
FOREIGN KEY ( role_id ) REFERENCES t_role (role_id )); //外健约束 
  
 
创建序列 
 
CREATE SEQUENCE seq_t_channel 
INCREMENT BY 1 
START WITH 1 
MAXVALUE 9999999; 
 
 
创建触发器 
 
create or replace trigger t_channel_auto 
before insert on t_channel for each row 
begin select seq_t_channel.nextval into :new.CHANNEL_ID from dual; 
end;

备注：创建表、序列的时候可以批量创建，创建触发器的时候是一个一个的创建。