Desktop Center (i) Create a database _php Foundation

Source: Osso Network

Desktop Center (i) Creating a database

Author: elong


This is the first time the younger brother writes an article. I don't know if I can release it. I write out the program is to want you to refer to. If you have a master who can change a better program,
Please don't forget to tell me. :P
The source program's demo page is elong.oso.com.cn/desk/
The first step is to create a database:
Let's take the Oso database as a list.
Log into the database first. Then at the point of your own database name, right on the left.
Enter the following command at the input command.
CREATE TABLE jpg (
ID Int (8) not NULL auto_increment,
URL char (255) not NULL,
Mess char (m) not NULL,
FromX char (not NULL),
URL1 char (255) not NULL,
Mess1 char (m) not NULL,
Fromx1 char (not NULL),
Url2 char (255) not NULL,
Mess2 char (m) not NULL,
FROMX2 char (not NULL),
Url3 char (255) not NULL,
Mess3 char (m) not NULL,
Fromx3 char (not NULL),
PRIMARY KEY (ID)
);
CREATE TABLE JPG1 (
ID Int (8) not NULL auto_increment,
URL char (255) not NULL,
Mess char (m) not NULL,
FromX char (not NULL),
URL1 char (255) not NULL,
Mess1 char (m) not NULL,
Fromx1 char (not NULL),
Url2 char (255) not NULL,
Mess2 char (m) not NULL,
FROMX2 char (not NULL),
Url3 char (255) not NULL,
Mess3 char (m) not NULL,
Fromx3 char (not NULL),
PRIMARY KEY (ID)
);
CREATE TABLE JPG2 (
ID Int (8) not NULL auto_increment,
URL char (255) not NULL,
Mess char (m) not NULL,
FromX char (not NULL),
URL1 char (255) not NULL,
Mess1 char (m) not NULL,
Fromx1 char (not NULL),
Url2 char (255) not NULL,
Mess2 char (m) not NULL,
FROMX2 char (not NULL),
Url3 char (255) not NULL,
Mess3 char (m) not NULL,
Fromx3 char (not NULL),
PRIMARY KEY (ID)
);
CREATE TABLE jpg3 (
ID Int (8) not NULL auto_increment,
URL char (255) not NULL,
Mess char (m) not NULL,
FromX char (not NULL),
URL1 char (255) not NULL,
Mess1 char (m) not NULL,
Fromx1 char (not NULL),
Url2 char (255) not NULL,
Mess2 char (m) not NULL,
FROMX2 char (not NULL),
Url3 char (255) not NULL,
Mess3 char (m) not NULL,
Fromx3 char (not NULL),
PRIMARY KEY (ID)
);
CREATE TABLE Jpg4 (
ID Int (8) not NULL auto_increment,
URL char (255) not NULL,
Mess char (m) not NULL,
FromX char (not NULL),
URL1 char (255) not NULL,
Mess1 char (m) not NULL,
Fromx1 char (not NULL),
Url2 char (255) not NULL,
Mess2 char (m) not NULL,
FROMX2 char (not NULL),
Url3 char (255) not NULL,
Mess3 char (m) not NULL,
Fromx3 char (not NULL),
PRIMARY KEY (ID)
);
The meaning of these commands is to create four tables to store the data. This represents the four classes of the picture. If you want to add a class you can add a table and change the source program.