Design and Making of Dynamic Website

Design and Making of Dynamic Website

Dynamic website design and production of mysql database version source code:

Super Administrator Table Creation Statement is as follows:

create table t_admin(
	id int primary key auto_increment comment 'Primary key',
	username varchar(100) comment 'Super Administrator Account',
	password varchar(100) comment 'Super Administrator Password'
) comment 'Super Administrator';
insert into t_admin(username,password) values('admin','123456');

My message table creation statement is as follows:

create table t_wdxx(
	id int primary key auto_increment comment 'Primary key',
	productId int comment 'Commentary information',
	customerId int comment 'Commentator',
	content varchar(100) comment 'Comment content',
	insertDate datetime comment 'Commentary date',
	typesName varchar(100) comment 'classification',
	customerId int comment 'I',
	title varchar(100) comment 'Title',
	pic varchar(100) comment 'picture'
) comment 'My news';

Classification table creation statement is as follows:

create table t_types(
	id int primary key auto_increment comment 'Primary key',
	content varchar(100) comment 'content'
) comment 'classification';

The bulletin table creation statement is as follows:

create table t_gg(
	id int primary key auto_increment comment 'Primary key',
	zan int comment 'Fabulous',
	insertDate datetime comment 'Release date',
	nologin varchar(100) comment 'Visibility of tourists',
	bkId int comment ''
) comment 'Notice';

The table creation statement is as follows:

create table t_pinglun_product(
	id int primary key auto_increment comment 'Primary key',
	jiaoliuId int comment 'Communication platform',
	hdrName varchar(100) comment 'Answer people',
	insertDate datetime comment 'date',
	content varchar(100) comment 'content'
) comment '';

Discuss the platform record table creation statement as follows:

create table t_jiaoliulist(
	id int primary key auto_increment comment 'Primary key',
	v1 varchar(100) comment 'Title',
	pic varchar(100) comment 'picture',
	showDate datetime comment 'date',
	v3 varchar(100) comment 'content'
) comment 'Discuss Platform Records';

Dynamic website design and production of oracle database version source code:

Super Administrator Table Creation Statement is as follows:

create table t_admin(
	id integer,
	username varchar(100),
	password varchar(100)
);
insert into t_admin(id,username,password) values(1,'admin','123456');
--Super Administrator Field Annotated
comment on column t_admin.id is 'Primary key';
comment on column t_admin.username is 'Super Administrator Account';
comment on column t_admin.password is 'Super Administrator Password';
--Super Administrator Table Annotated
comment on table t_admin is 'Super Administrator';

My message table creation statement is as follows:

create table t_wdxx(
	id integer,
	productId int,
	customerId int,
	content varchar(100),
	insertDate datetime,
	typesName varchar(100),
	customerId int,
	title varchar(100),
	pic varchar(100)
);
--Annotate my message field
comment on column t_wdxx.id is 'Primary key';
comment on column t_wdxx.productId is 'Commentary information';
comment on column t_wdxx.customerId is 'Commentator';
comment on column t_wdxx.content is 'Comment content';
comment on column t_wdxx.insertDate is 'Commentary date';
comment on column t_wdxx.typesName is 'classification';
comment on column t_wdxx.customerId is 'I';
comment on column t_wdxx.title is 'Title';
comment on column t_wdxx.pic is 'picture';
--Annotate my message sheet
comment on table t_wdxx is 'My news';

Classification table creation statement is as follows:

create table t_types(
	id integer,
	content varchar(100)
);
--Annotation of Classification Fields
comment on column t_types.id is 'Primary key';
comment on column t_types.content is 'content';
--Annotation of Classification Table
comment on table t_types is 'classification';

The bulletin table creation statement is as follows:

create table t_gg(
	id integer,
	zan int,
	insertDate datetime,
	nologin varchar(100),
	bkId int
);
--Annotation of bulletin field
comment on column t_gg.id is 'Primary key';
comment on column t_gg.zan is 'Fabulous';
comment on column t_gg.insertDate is 'Release date';
comment on column t_gg.nologin is 'Visibility of tourists';
comment on column t_gg.bkId is '';
--Annotation of bulletin sheet
comment on table t_gg is 'Notice';

The table creation statement is as follows:

create table t_pinglun_product(
	id integer,
	jiaoliuId int,
	hdrName varchar(100),
	insertDate datetime,
	content varchar(100)
);
--Field annotation
comment on column t_pinglun_product.id is 'Primary key';
comment on column t_pinglun_product.jiaoliuId is 'Communication platform';
comment on column t_pinglun_product.hdrName is 'Answer people';
comment on column t_pinglun_product.insertDate is 'date';
comment on column t_pinglun_product.content is 'content';
--Table annotation
comment on table t_pinglun_product is '';

Discuss the platform record table creation statement as follows:

create table t_jiaoliulist(
	id integer,
	v1 varchar(100),
	pic varchar(100),
	showDate datetime,
	v3 varchar(100)
);
--Discuss Platform Record Fields with Annotations
comment on column t_jiaoliulist.id is 'Primary key';
comment on column t_jiaoliulist.v1 is 'Title';
comment on column t_jiaoliulist.pic is 'picture';
comment on column t_jiaoliulist.showDate is 'date';
comment on column t_jiaoliulist.v3 is 'content';
--Discussion Platform Record Table with Notes
comment on table t_jiaoliulist is 'Discuss Platform Records';

oracle is unique, and the corresponding sequence is as follows:

create sequence s_t_wdxx;
create sequence s_t_types;
create sequence s_t_gg;
create sequence s_t_pinglun_product;
create sequence s_t_jiaoliulist;

Dynamic website design and production SQL Server database version source code:

Super Administrator Table Creation Statement is as follows:

--Super Administrator
create table t_admin(
	id int identity(1,1) primary key not null,--Primary key
	username varchar(100),--Super Administrator Account
	password varchar(100)--Super Administrator Password
);
insert into t_admin(username,password) values('admin','123456');

My message table creation statement is as follows:

--My Message Table Comments
create table t_wdxx(
	id int identity(1,1) primary key not null,--Primary key
	productId int,--Commentary information
	customerId int,--Commentator
	content varchar(100),--Comment content
	insertDate datetime,--Commentary date
	typesName varchar(100),--classification
	customerId int,--I
	title varchar(100),--Title
	pic varchar(100)--picture
);

Classification table creation statement is as follows:

--Annotation of Classification Table
create table t_types(
	id int identity(1,1) primary key not null,--Primary key
	content varchar(100)--content
);

The bulletin table creation statement is as follows:

--Annotations to bulletin tables
create table t_gg(
	id int identity(1,1) primary key not null,--Primary key
	zan int,--Fabulous
	insertDate datetime,--Release date
	nologin varchar(100),--Visibility of tourists
	bkId int--
);

The table creation statement is as follows:

--Table annotation
create table t_pinglun_product(
	id int identity(1,1) primary key not null,--Primary key
	jiaoliuId int,--Communication platform
	hdrName varchar(100),--Answer people
	insertDate datetime,--date
	content varchar(100)--content
);

Discuss the platform record table creation statement as follows:

--Discuss Platform Record Table Annotations
create table t_jiaoliulist(
	id int identity(1,1) primary key not null,--Primary key
	v1 varchar(100),--Title
	pic varchar(100),--picture
	showDate datetime,--date
	v3 varchar(100)--content
);

Tags: Database Oracle MySQL SQL

Posted on Sun, 06 Oct 2019 20:51:33 -0700 by leesiulung